Skip to Content
0
Former Member
Mar 02, 2007 at 11:38 PM

Routine in transformation

19 Views

Dear All,

I wrote this code:

SELECT SINGLE /bic/zXYZ INTO RESULT

FROM /bic/pzabcd

WHERE /bic/zsxxx = SOURCE_FIELDS-sxxx

AND /bic/zpxxx_id = SOURCE_FIELDS-xxx_id

AND objvers = 'A'.

This is not pulling the data instead of data being present for a particular condition.

Any inputs would be appreciated.

Thanks.