Originally posted by: SystemAdmin

Hello,

I tried this following rule to use an SQL UPDATE stored in a mdq file.
This rule works when the third parameter INFOLOR is short. The map fails (message = Adapter not found ; code = -9999) if I try to put a longer text.

very strange ??

Is there a best way to use a SQL UPDATE or what is wrong in my rule?

Thanks !

= VALID(GET("DB", "-MDQ %UPA_MDQ_DIR%/UPA_AAA_Queries.mdq -TRACEERR -DBNAME XLS_Queries -USER aaa -PASSWORD aaaaaa -SOURCE DSKAOSYBA\\aaaingbedb -QUERY Update_XLSSTATUS -VAR FILENAME = " + TEXT(ShortFileName) + " -VAR INFOLOG = " + TEXT("fdhsfkdlfhsdjklffdhsjkflsdhkfjsdkflfd")), FAIL("Failure on GET-DB for Query Update_XLSSTATUS - Card UpdateXlsStatus ; Error code = " + TEXT(LASTERRORCODE()) + " ; Error message = " + LASTERRORMSG()))
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: janhess

Try using DBLOOKUP.
VALID(dblookup("Update_XLSSTATUS -VAR FILENAME = " + TEXT(ShortFileName) + " -VAR INFOLOG = " + TEXT("fdhsfkdlfhsdjklffdhsjkflsdhkfjsdkflfd"),"-MDQ %UPA_MDQ_DIR%/UPA_AAA_Queries.mdq -TRACEERR -DBNAME XLS_Queries -USER aaa -PASSWORD aaaaaa -SOURCE DSKAOSYBA\\aaaingbedb"), FAIL("Failure on GET-DB for Query Update_XLSSTATUS - Card UpdateXlsStatus ; Error code = " + TEXT(LASTERRORCODE()) + " ; Error message = " + LASTERRORMSG()))
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

That's rubish. Didn't read the rule properly.

You can use the query in place of the first bit in quotes

=VALID(dblookup("UPDATE QUERY STATEMENT HERE","-MDQ %UPA_MDQ_DIR%/UPA_AAA_Queries.mdq -TRACEERR -DBNAME XLS_Queries -USER aaa -PASSWORD aaaaaa -SOURCE DSKAOSYBA\\aaaingbedb"), FAIL("Failure on GET-DB for Query Update_XLSSTATUS - Card UpdateXlsStatus ; Error code = " + TEXT(LASTERRORCODE()) + " ; Error message = " + LASTERRORMSG()))

or you can have the query in the mdq as an input card to a map and run that from the first map passing the variables.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

OK. It works.
Thanks a lot !!
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I tried the DBLOOKUP function but I have the following error code = -1009 (Failed to execute the SQL statement)....

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