Mismatch in creating DBS from EI 6.6.0’s GUI and Integration Studio 8.0.1 and 8.2.0.

[ksankeerth]

Hi Team,

We can create a DBS from EI 6.6.0’s GUI and have a param with type “INOUT” from EI 6.6.0’s GUI.

<query id="update_REG_ASSOCIATION_query" useConfig="default">
   <sql>UPDATE PUBLIC.REG_ASSOCIATION SET REG_SOURCEPATH=?,REG_TARGETPATH=?,REG_ASSOCIATION_TYPE=?,REG_TENANT_ID=? WHERE REG_ASSOCIATION_ID=?</sql>
   <param name="REG_SOURCEPATH" ordinal="1" paramType="SCALAR" sqlType="STRING" type="IN"/>
   <param name="REG_TARGETPATH" ordinal="2" paramType="SCALAR" sqlType="STRING" type="IN"/>
   <param name="REG_ASSOCIATION_TYPE" ordinal="3" paramType="SCALAR" sqlType="STRING" type="IN"/>
   <param name="REG_TENANT_ID" ordinal="4" paramType="SCALAR" sqlType="INTEGER" type="IN"/>
   <param name="REG_ASSOCIATION_ID" ordinal="5" paramType="SCALAR" sqlType="INTEGER" type="INOUT"/>
</query>

But the same type “INOUT” is not valid in Integration studio. In Integration studio, only the “IN-OUT” type is valid.

Thanks, Sankeerthan