Originally posted by: karthikpc

Hi,

We are calling 'MAP2' map from the 'MAP1' map using RUN function. MAP2 map select the table as an input and converts into Outbbound Format. But after selecting the table, its trying to validate the Data and giving us an error "Input Valid But Unknown Data present". Now we want to see the trace for this selected data to find out "unknown Data". We are using RUN cmd in MAP1 map as below to call MAP2.

=VALID(RUN( Map_Name Fields:In1,"-ID1 '-PLAN " +Sub_System Fields:In1 +" -SUBSYSTEM " +Creator_ID Fields:In1 +" -VAR SUBSYSTEM="LEFT(Creator_ID Fields:In1,7)" -VAR COID="+Co_Id Fields:In1 +" -VAR DEPTID="+Dept_Id Fields:In1 + " -VAR BATCHNUMBER="+TRSM_Sub_Batch_Number Fields:In1 + " -VAR DBNAME="+Creator_ID Fields:In1 + " -TI' -OD2 ' -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CUST_OGNG -CCARD ' " ), LASTERRORMSG())

We have enabled trace in Map settings. also we are using GET>SOURCE>COMMAND as -T. (because of this -T, we are able to see any sql related issues in the trace. but not able to figure out the issue that is causing by the Data which was selected from the table).

Pleae let us know if anyone of you aware of how to get the trace for selected data from the table?
Thanks in advance.

P C
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: karthikpc

All,

Forgot to provide the platform name that we are executing these maps. Its ZOS(Mainframe)- CICS.

Thanks,
P C
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: paul.brett

You have the -TI inside the -ID1 '' string.

If the -TI is supposed to be the map trace, it needs to be outside:

=VALID(RUN( Map_Name Fields:In1,"-ID1 '-PLAN " +Sub_System Fields:In1 +" -SUBSYSTEM " +Creator_ID Fields:In1 +" -VAR SUBSYSTEM="LEFT(Creator_ID Fields:In1,7)" -VAR COID="+Co_Id Fields:In1 +" -VAR DEPTID="+Dept_Id Fields:In1 + " -VAR BATCHNUMBER="+TRSM_Sub_Batch_Number Fields:In1 + " -VAR DBNAME="+Creator_ID Fields:In1 + "' -TI -OD2 ' -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CUST_OGNG -CCARD ' " ), LASTERRORMSG())

...and preferrably, before the card overrides (for clarity):

=VALID(RUN( Map_Name Fields:In1,"-TI -ID1 '-PLAN " +Sub_System Fields:In1 +" -SUBSYSTEM " +Creator_ID Fields:In1 +" -VAR SUBSYSTEM="LEFT(Creator_ID Fields:In1,7)" -VAR COID="+Co_Id Fields:In1 +" -VAR DEPTID="+Dept_Id Fields:In1 + " -VAR BATCHNUMBER="+TRSM_Sub_Batch_Number Fields:In1 + " -VAR DBNAME="+Creator_ID Fields:In1 + "' -OD2 ' -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CUST_OGNG -CCARD ' " ), LASTERRORMSG())

Paul.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange