DSXchange

Hi All, I got the answer by using the following way to implement the requirement. Parameter = 'param1':x in the Sequence variable. where x is the parameter that i am passing to the sequence. I tried all other options finally got the answer. It is great fun learning Datastage... Thanks Sudharsanan[/c...

Hi Gurus, In the same topic, i need some expert advice on how to design. Now my existing jobs have a parameter = param1 in a sequence job which calls a routine. This routine will return me the corresponding value from a hashfile. Now I have a new requirement to change the parameter as =param1#x#. Th...

Thanks Craig.. I got the ouput with the Query that you provided... and here are the Results.. SELECT OLETYPE,COUNT(*) from DS_JOBOBJECTS GROUP BY OLETYPE OLETYPE........... count(*) CContainerView ---8 CCustomInput ---5 CCustomOutput ---7 CCustomStage --- 10 CHashedFileStage---2 CHashedInput ---1 CH...

Hi Gurus, Thanks for your inputs.. I tried the Duke method to find out how many jobs are using DB2/ODBC stage by using the Administrator command line..I gave the following query select count(*) from DS_JOBOBJECTS GROUP BY OLETYPE The result was 82 record selected.. I think i am missing the where con...

HI Gurus, We are in the process of converting a warehouse database from db2 to oracle..while doing the conversion we will change all the db2 stages into oracle stages.. we want to know what are the precautions that are to be taken while doing the conversion.. can anybody share there experiences on c...

Hi Shyju, You have asked about Oracle8i stage with "Use OS level authentication" option.. This option is avaliable at the database level. In oracle you can log in to the database with the OS user ID..This option is set by the Oracle DBA while creating the database...if you want how oracle ...

Shreya, how to read value from hash file and read and return as status and how to pass this value in next job. In order to read value from hashfile, you have to get familiar with Datastage Routines. Datastage's repository is universe Database. You have to query the Universe database to fetch the val...

Hai Sainath,

Can you provide some more inputs on how to distribute and recollect to achieve the result...please provide the logic to implement the same..

Thanks
Sudharsanan A N

HI SAS, Some more inputs about FTP Stage, whenever you involve in FTP staging try to have some checking before and after the FTP stage. You can use your own logic to check whether the FTP has been completed successfully or not.. for example, you can have header and footer on your file and check for ...

Hi Arndw,

I used your logic for the stage variable and the result is

Field1Field2

1A=B
1,C=D
1,E=F
1,G=H
2


Thanks
Sudharsanan

Hi Sunshine, I merged my input into one column.. When i see the sequential file VIEW DATA the Result was 1,A=B&C=D&E=F&G=H 2,L=M&G=H I changed the Sequential file delimiter to 000 Then i used the same Stage variables StageVar=FIELD(DSLink3.Field1,",",1) StageVar1=EREPLACE( ...

I did the same way as you said..............

Thanks Sunshine and Arndw.. for your inputs.. i was able to get the Result...


Regards
Sudharsanan

Hi All,

As I couldn't use the Merge Stage..I used the Database approach where i moved the data to two temporary tables did a simple select with the table and got the result very easily... Thanks for all the inputs...


Regards
Sudharsanan

Thanks Sunshine and Arndw.. for your inputs.. i will try Sunshine's appraoch and will let know the result...

Thanks
Sudharsanan