Originally posted by: Bragger

Hi All,

I know how to override the database adapter using RUN function and -ID1 command. Does anyone know if we can also use ECHOIN function to achieve the same?

For e.g. - Currently I have this command -

RUN("ChildMap.mmc", "-ID1 '-MDQ Temp.MDQ -DBNAME %a% -USER %b% -PASSWORD %c% -Query Temp'")

In order to use ECHOIN function I tried below command but its not working. My guess is it's not able to recognize Db2 adapter and rather it is considering it as normal text data.

RUN("ChildMap.mmc", ECHOIN(1,"-MDQ Temp.MDQ -DBNAME %a% -USER %b% -PASSWORD %c% -Query Temp"))

Originally posted by: PaulBrett

Yes, the -IE1 parameter can be used for echo in.

https://www.ibm.com/support/knowledgecenter/en/SSVSD8_9.0.0/com.ibm.websphere.dtx.execcmd.doc/references/r_execution_commands_Input_Source_Override_Echo_IE.htm

The echo command can be built manually ( like -IE1S"+TEXT*SIZE(Input))+" "+INPUT ) or you can used the ECHOIN() function to get the product to build it automatically:

https://www.ibm.com/support/knowledgecenter/en/SSVSD8_9.0.0/com.ibm.websphere.dtx.funcexp.doc/references/r_funcs_express_ECHOIN.htm

...but this will only send the text string to the input card, and NOT connect to DB2 (or any other database).

What is it you're trying to achieve?

Thank you

Paul

Follow me on Twitter