Originally posted by: Bottle1234

I have successfully created a map which has an output card which does a DBLOOKUP and fetches a value from the database. The query is as follows

“=DBLOOKUP("Select UNIQUE(MBR_POLICY) from MCP834M Where UNIQUE_KEY = '"NUMBERTOTEXT(transactionId Comp:Seq:ElemDecl startTransactionResponse Element:TrackerId)"'" ," -MDQ ../common/mdq/EYE400_Oracle_Staging.mdq -DBNAME EYE400_Staging")”
“transactionId Comp:Seq:ElemDecl startTransactionResponse Element:TrackerId” is a value passed from the input card.
This works absolutely fine, but i have another map which is kind of a controller map, which runs a sequence of maps. When I tried to run my this map from my controller map by passing the input to this map generated in one of the previous fields of the controller map , this doesn't seem to be fethching any data from the database.
The Command given is :-

“RUN( "XYZ.mmc", "-TIO " + "-IE1s" + NUMBERTOTEXT( SIZE( TEXT(transactionId Field:.:Process834) ) ) + " " + TEXT(transactionId Field:.:Process834) + "-OE2")”

transactionId Field:.:Process834 is the value passed to overide the input card value “transactionId Comp:Seq:ElemDecl startTransactionResponse Element:TrackerId” , which has been generated in the previous field of the controlled map , and has created a record corresponding to it in the DB.

Can anyone suggest me as to why is it not fetching any value from the database??
has it got something to do with the .mdq file
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Dhiren.Ghelani

1. Check if the input value reaches this card.
2. put a VALID, FAIL with LASTERRORCODE and LASTERRORMSG around the DBLOOKUP
3. Add -T or -TE to the DB call.
4. Are you sure your DBLOOKUP is correct. Just looking at the rule, you might have missed + before and after NUMBERTOTEXT

Other things:
replace -IE1S with ECHOIN.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Bottle1234

I have the + in place, I somehow missed it while copying the rule, sorry for that.
It Looks like this.
=VALID(DBLOOKUP("Select UNIQUE(MBR_POLICY) from Stage6.MCP834M Where UNIQUE_KEY = '"NUMBERTOTEXT(transactionId Comp:.:TrackerId)"'" ," -MDQ ../common/mdq/EYE400_Oracle_Staging.mdq -DBNAME EYE400_Staging"),FAIL(LASTERRORCODE()+""+LASTERRORMSG()))

The DBLOOKUP works fine , I have used VALID too around DBLOOKUP, there doesn't seem to be a problem.
I have now used the .mmc file of the above map inside the RUN command of my controller map,When I place the RUN command inside VALID,and RUN this map it says that 'FAIL Function aborted map'

When I RUN this map without VALID it returns me '8', which is some error code I think.
My RUN command looks like :-

=RUN ("Migration", ECHOIN(1,(Tracker_ID Field:834_Process:Process834 )) + "-OE3")

Pls let me knw where do i place the -T in the above command, it doesnt seem to aceept it, and also let me knw if i can try something else to make it work.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: TarunB

A return code of 8 implies that the data you are sending via the RUN command does not match the format expected by the map being run.

Check the map trace that should be generated by your -TIO command. Otherwise, backup the data in transactionId Field:.:Process834 (or obtain it somehow) and check that it is exactly what you expect, and exactly what map XYZ.mmc expects.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

=RUN ("Migration", "-T " + ECHOIN(1,(Tracker_ID Field:834_Process:Process834 )) + "-OE3")
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender