DSXchange

email me - got info for AIX, not windows though. your compiler options would be different, as well as paths to object files. - elder700@yahoo.com Thanks Ron Your document is exactly want I need. I'm not a pro in datastage. and I'm in this forum asking for implementing c/c++ but the solutions given ...

How is this job called, from a controlling prospective? The controlling job, whether it be a shell script or a job sequence, you can do this while passing the parameter to this job. In a shell you can use the commands like date and pass month mask for one and year mask for another. In a sequence jo...

What are your first two column metadata definitions in your job? When you do a 'display data' do you only get the 1st column contents (correctly)? What is displayed for the 2nd column? ... Varchar ( 8 ) Varchar ( 11 ) Yaa, I'm getting first column correctly. Second column is NULL for all the record...

Duplicate....

Hi I'm using a sequential file with fixed width columns (no white space or tab separator). On sequential file format property I'm using Final Delimiter : none Delimiter : none Quote : none it is giving only one column while viewing the records. This job was there in server edition and running as ser...

It is not copy, sorry, export from Production and imported to Development Environment and I made it NRO by the following command: UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' NAME ='Jobname' Hi If you exported as .dsx file. Please open that on notepad or any text editor, find all readonly and set the ...

iDomz wrote:

abc123 wrote:iDomz, what would the URL be?

Create custom operators for WebSphere DataStage

Cheers,
D

Thanks a ton for this link.

Can I call a unix shell script from Datastage job I you go to job properties ( Ctrl+J) . On general tab there is after_job and before_job subroutines, where you can use UNIX command. Limitations : This command can only triggered before/after job executions. If you want to use in between then you ha...

Hi, I'm evaluating a job for optimization/performance etc, and I see that there's a JOIN being used. One of the reference file can be upto 6MB. Is it advisable to go for LOOKUP in place of this JOIN ? Thanks I think using Lookup stage ( with ref. link entire partitioning and input link unsorted) wi...

Hi
I need to build a custom stage using C/C++ ( earlier in server job using a routine like clean field, valid alpha numeric, getting ASCII value of alpha numeric inputs etc. ).

Can someone help me with the steps needed to incorporate C/C++ codes into PX environment?

Thanks in Advance
Debasis

Hi All, I have a job which looks up from a file and takes some columns on matching to the target table as shown below. lookupup fileset | source--->lookup stage---->target table The lookup stage has conditions set to CONTINUE in case of lookup failure. So I believe even when the key columns dont ma...

Hi I've to generate a control report using DS 7.5.1. There are 6 col (1-6 suppose). The report should have : Group by 1) col1 and 2) (if col2=-999 than catagory1 else if col2=-998 catagory2 else catagory3 (there are lot more value for this column). Problem: how to categorize this. Solution : I'm usi...

Removing all characters but alphanumeric (i.e. [A-Z] [a-z] [0-9]) from input strings. This string is coming from a comma separated sequential file. And I need to remove it from only one column.

Thanks
Debasis