Originally posted by: SystemAdmin

Hi
Can anyone tell what is the exact difference between DBLOOKUP and DBQUERY.

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

Originally posted by: vijji_WTX

Hi , Only one difference....Terminator
DBLOOKUP (″SELECT PART_NAME from PARTS where PART_NUMBER =1″, ″mytest.mdq″, ″PartsDB″)
Returns
1/4″ x 3″ Bolt

DBQUERY (″SELECT PART_NAME from PARTS where PART_NUMBER =1″, ″mytest.mdq″, ″PartsDB″)
Returns
1/4″ x 3″ Bolt<cr/lf>

where <cr/lf> is a carriage return followed by a line feed

i hope your clear abt this.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

It is worth noting that is the query results in multiple rows, DBLOOKUP would only return the first row, DBQUERY would return all of the rows.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: maddysam

Hi aic,

DBLOOKUP function also returns multiple rows , this will not act like a LOOKUP function.
Even , I have observed that is the only difference b/w the 2 functions(DBLOOKUP&DBQUERY)which was mentioned by Vijji.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

My mistake, I have validated that you are indeed correct, both return the same results, except the trailing <CR><LF> on the last row of the results (as was already mentioned).
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Hi All
Thanks for your information.
Thanks A lot.

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