DSXchange

Hi Gurus, I need to lookup on huge data i.e around 7 million records and the performance is very very slow. I m making lookup directly on table using ODBC stage (Since the data is huge , i can't use hashed file).I have only one key column in the table where i m making lookup and That key column is V...

Thanks a lot Kim, Cr.cezon and Ray Ji ,

I got Ans exactly what i want.

Thanks once again

Cheers

Hi Gurus, I can get the total number of jobs in a project by executing the query COUNT DS_JOBS WITH @ID LIKE '1N0N' , but 1) I want to get the number of jobs in a particular category in my project 2) Number of only jobs and number of only sequences in project 3)Number of only jobs and number of only...

Thanks a lot Ray and Kumar for u r answers, Kumar thanks for simplifying the code. And Kumar, i just explained with only two keys in the previous example. Here if u see the example below i have total 4 keys , among those Key1 is the common key across to generate the flags. Steps : 1), i want to crea...

Hi Kumar Then i need to explain about my rotine and the requirement In this routine i m comparing first record with the second record based on two keys and processing the first record and so on.... For this, first record i m just capturing in variables and when second record comes (i.e now current r...

Hi Gurus, I have created one routine using COMMON basic function and it is working fine. When i pass the output of this routine to the same routine then it is giving strange results. But if i copy this routine (Also changed the memory space name in copy routine) it is working fine even if i passed t...

Hi Gurus, I m splitting the single record into two records and after that i wanted to treat these two records as two seperate records Eg : Source Record : 3,CD,HHHHHHH,16-05-2004,31-12-99994,CD,MMMMMMM,01-01-2002,15-04-2002LastRecord Splitting this record using Char(10) (Using in between the record ...

Thanks a lot Ray.

I m able to do it .....

Hi Gurus, I have a Shell Script (For moving files from One directory to another directory) which i want to call from DataStage routine by passing the Parameteres (As Src Directory and Tgt Directory) to the script. Anyone tell me, Can DataStage Executes Unix Shell Script from Routine. Thanks in Advance

Hi Ray, Thanks for the Routine. It is usefull to me as well in my project. In my project we have many sequence names (Generated using SDKSequences) and i wanted to reset all those sequences to 0 when i m moving to Dev to Test AND Test to Prod. For that i m putting all the sequence names and the rese...

Hi Craig,

I have gone through the code, i did't find where to pass the parameters. I mean file path ..etc in the routine code.

I understood that this routine will be called from Routine Activity before the actual jobs start running. correct me if i m wrong.

Cheers