DSXchange

Please do a search. There are lot of posts on stored procedures.
They will certainly help you to solve your problem.

You can do a search for your error message there are few posts with that error message.Please check if it helps you.

Welcome to dsxchange Phani ! Do you want to know what is resource disk and what is resource scratch disk? In simple words resource disk is used to store permanent data like data in datasets and resource scratch disk is used to store temporary data like data before sorting and aggregating. You can fi...

Already posted one.

As DeepakCorning Said: Write your source2 in 3 different hashfiles say hashfile file1 with col1 as key, hashfile2 with col2 as key and hashfile 3 with col3 as key. Compare col1 from source1 with hashfile1,col2 from source1 with col2 from hashfile2 and col3 from source1 with col3 from hashfile3 Set 3...

Why do you want to call ICONV and OCONV in parallel job. To call them you need basic transformer which will be costly. You can achieve that functionality in different ways in parallel.

Status code = -2 DSJE_BADSTATE.
will be thrown usually when a job is not in a runnable state.You can compile the job and can run the screipt again.

As a usual practice we used to reset the job in the script only.

I have seen a file of 210GB on AIX server and so I belive a file size of max 120GB might not be true.

You can use a shell script in before job subroutine to remove header and trailer records from the file and read only the detail records.

Can you tell us what is the query you are using.
That will help people to analyse the problem.

Are these load jobs loading the same table?

We had the same requirement in the past. We had NFS drives which can be accessed by both unix and window users. A .csv file will be viewed as an excel sheet when we see it through windows user. So we used this NFS drive to write the files directly from datastage and the windows users will be able to...

I believe it should be okay to proceed.Lets see what our DSGurus comment on this.

I believe the sequential file limit is at Operating system level. The limit will be set by your Unix admin.

Then can we pass the data with natural keys and this column (neither key nor expected to change) to a different stream and the required fields only to change capture data. Then we can join/lookup both streams and get the data in required format for the target database. Just a vauge idea just check i...