DSXchange

Hi, I am trying to initialize/setup a new DB2 connection for my project, so that I can use the DB2 Connector in data stage to read a table from mainframe. Can you please let me know the steps that are required for this? I just have the catalog setup as the first step, but not able to test the connec...

Yes. I used a JOIN Stage and it worked. Thanks

Hi, I am new to DataStage EE. I have to combine 2 files in one sequential file. Reason being I need to bring one column from this other file, and take all columns from first file. If I specify these file names separately and use "read specific files" in read pattern, will this append this ...

What is a Sparse Lookup? Why and when can we use it?

Thanks

Hi , I think that this topic has already been discussed, but I still dont know how t o do that..? I have a single row comming in which can have upto 5 codes in that. Sometimes it may have one cd, sometimes all of them. There is only 1 target column for that, so i need to send them all to one column,...

Hi All,
What should be done to get rid of the error message that says:
ORA-01036: Illegal Variable name\number?????
I am not even able to validate my datastage job..it gives the above error message.......what should be done??
Any help will be appreciated...
Thanks

Hi Keith, Thanks a lott... I did the same thing... I defined Stage variables and did this calculation there.... Now as I have a set of 3 keys in my table..So the same combination of the keys can not have the same value again.. So I need to write those stage variables to my target columns..So how sho...

Hi all, I have a problem, I have 4 columns in the source table and I have one column in my Target.. the calculation looks something like this: I need to check the value of 1 column, and if it matches say "XXX" then I need t0 see 2nd column and if it is also "XXX" then I need to p...