DSXchange

Hi ... I have an requirement like to send a notification mail if the count of records in two tables not same, those two tables populated in same job. Any suggestions how to handle this Compare the two counts may be like if count1=count2 then 'Y' else 'N' and use DSSETUSERSTATUS routine and then sen...

Thanks Ray ...

Hi,

Is there any inbuilt function to Convert character to hexadecimal.

Thanks in advance

Thanks Craig for your help

Hi , I am using KeyMgtGetNextValue and the Argument which i am passing is the tablename but in the Datastage transformer it is showing Red but still i ran the job i got a warning DataStage Job 282 Phantom 2640 Program "DSX.KEYMGTGETNEXTVALUE": Line 58, Variable "Arg1" previously ...

Hi ,

Thanks all for the reply . As i dont have any experience in writing Routines , Can anyone guide me how to write a routine to solve this issue.

Any help is really appreciated

Thanks in advance

Use Seq function for each character in string: Seq(<strig>[1,1]):Seq(<strig>[2,1]):Seq(<strig>[3,1]) and so on. Hi , Thanks for your quick reply , but the logic above is for each character and i want for multiple characters. I mean , i dont know the input , the input might be abc for 1 row and sdfg...

Hi ,

Can any one tell me how to convert Character to Decimal Value . For example if i have A , it should convert to 65 . and if i have Aa it should convert to 6597.

Any help is really appreciated

Thanks in advance

Hi , I am doing some transformations before loading into DB.And most of the time taking while doing lookup i mean loading data from DB to hash file to do look up say if my job ran for 10 min , then in order to load from DB to hash file to do lookup is taking almost 6 to 7 min. And i tried with check...

Hi , I am also doing a lookup from the hash file , so the time taken to load from db to hash file for lookup is also more around 5000 rows / sec. So the time is taking more at the reading and loading. Is there anything that i can speed up to load the data from db to hash file so that it might increa...

Hi, I am trying to load almost like 2 million records into database which is oracle. I used link partitioner , link collector , IPC stages also. I also increased the array size in db to 30,000 and transaction handling to the same number but still taking almost more than 30 min to load and my source ...

Hi ,

I used a sequential stage and used the DAT file in sequential stage and when i view the data i could able to view the data. So i would like to know the DAT files can be used by both sequential or CFF stage

Thanks in advance

Hi ray,

can you tell me what is DIS file means?

Thanks in advance

Hi,

Its in ASCII and and i am not sure if has packed fields or not and can you tell me how do we determine whethe it is paacked fields or they are going to tell about this and they had provided cobol copy book

Hi ,

Actually they are extracting the mainframe data into DAT file and FTPed the DAT file into Datastage Server.

Thanks in advance