DSXchange

I designed the sequencer in such a way that to run the abbreviations hash first and address hash next ( in series) instead of parallel. Now it is working fine.

I have created 2 hash files for address and abbreviatons separately and created individual sequencer for address and abbreviations . Then I created one main sequencer which call the address and abbreviations to run concurrently and other jobs. When I am running the main sequencer, abbreviations ran ...

Thanks for your information, Ray.

May I know the possiblities of this error, please.

I am getting this message when run the command given by you. 'Datastage/SQL: Table "RT_LOG149" does not exist' Since I got this error, I copied the load job and renamed it. Then I deleted the old load job which thrown error. Again renamed the new copied job to old load job name and ran it....

I got a DB2 error of SQLSTATE=57016 when I tried to load the data into the DB2 table and also 'FAILED TO OPEN RT_LOG149 file' error. After fixing this DB2 error also I am unable to compile the ds load job . What is the reason for this?

Thanks a lot. I did as you have told in this forum. It worked and this problem is resolved.

Yes same version of IBM Information server 8- Datastage server edition 8. Earlier I had a temporary environment and now imported all the jobs to the permanent environment.

I exported my job modules( validate,default,lookup, load) into my local drive and did the import all the jobs into the new permanent environment by selecting import->datastage components-->Import selected-->overwrite the query and gave ok. Only validate and load job got copied whereas default & ...

Yes. I need your help in stage variable logic. Plz let me know.

My expression in transformer is

if Input .MT_REPLACEDBYID=lookup.MT_ID then lookup.MT_MODELNUMBER:',':Input.MT_MODELNUMBER else Input.MT_MODELNUMBER

Plz let me know how to enable multiple rows return.

No. I am looking up '101' from the input with the 101 inthe lookup. i.e
if input. MT_REPLACEDBYID =lookup.MT_ID then I should get A, 1,2,3.

But I am getting only A,3 as the output.

Sorry.Mistyped. '1' should not be there. It is like this Lookup -------- MT_MODELNUMBER MT_ID ---------------------- -------- A 101 Input ------ MT_MODELNUMBER MT_REPLACEDBYID ----------------------- ------------------------- 1 101 2 101 3 101 Can you plz advise how to proceed ahead?

There is only one reference key.

Input ------- MT_MODELNUMBER MT_REPLACEDBYID 1 101 2 101 3 101 LOOKUP table ---------- MT_MODELNUMBER MT_ID A 1 101 Output field - BISEPS_MODELNUM should have values obeying this condition [ condition for look up is 'if INPUT.MT_REPLACEDBYID=LOOKUP.MT_ID THEN CONCATENATE lookup.MT_MODELNUMBER , inpu...