DSXchange

I hope after importing, when you compile the jobs this issue wont occur.

Thanks a lot Ray.

EVAL worked for me

Thanks
George

Finally Oracle buys Sun.

Thanks for the answers Hashed File <------- LKP DB | | | | | | v SOurce DB ------>Transformer ------> Target In the above job design, the Hashed File will be populated first, so the link from LKP DB will be executed first. By seeing this design we will be able to identify this, but how and where it ...

Is there a way to know the job execution order. Say for example if i have 10 stages, which stage will be executed first, and the sequential order of execution. I did find some thing on DS_TEMPnn and RT_CONFIGnn (like all the stages), but wanted to know their execution order. Can we get this informat...

yes all the services are running

We are planning to move from 7.5 Server Edition to 8.1 Server Edition. So i am in the process of setting up the 8.1 server. The toplogy we have choosen is having 2 Windows 2003 servers, and in Server 1 , we have installed Service Tier and metadata server (Oracle). And in Server2 , we have installed ...

Take a look on the datastage supplied routine UtilityHashLookup, it will do the required things. I hope it works only for account based hashed files, So you might need to create an entry to your hashed file in the VOC using SETFILE. In case you have more than one key for doing a lookup combine them ...

based on your terminologies, it seems you are using peoplesoft jobs. Convert the corresponding field data type to longvarchar in the ETL job, as this is the supported datatype for CLOB fields, when using with DRS stage. Alternatively , you can try DBMS_LOB.SUBSTR and use varchar also. You can use DB...

Change the Effectivedate in your DRS stage to Timestamp, and make sure you are passing the input in the format 'YYYY-MM-DD HH24:MI:SS', even , if you dont have time part also append it with 00:00:00.

Convert your incoming date from the sequential file to the above specified format, using OCONV.

We have huge number of jobs which is already there in production, and now a requirement came to capture the job run statistics to a table. We can do it , by writing a seperate job and call that in the after job subroutine, But this requires , changing all the jobs. I want to achieve this with minimu...

Thanks, I resolved it by using FINDSTR.

Thanks for the information Ray, I will try that tomorrow. BTW how to read the entire file in a READ statement, in the help i am seeing only READSEQ statement.

Hi All, I am building a dynamic array, by reading a flatfile. My Flatfile will have the values like JOB1,Y,N JOB2,N,N JOB3,Y,Y So i am building the dynamic array (JOBLIST) also in the same manner. So my dynamic array will look like JOB1,Y,N:@AM: JOB2,N,N:@AM: JOB3,Y,Y:@AM: And inside the jobcontrol,...