DSXchange

Hi, Thanks all, the UNIX command really worked for opening all the files through list/indirect file. There's one problem which I am still facing. I am trying to remove the header by using the command `cat listfile.txt|grep -v 'HEADER'`. This is giving me a warning : Sequential_File_6,0: Field "...

Hi Thomas, The solution you suggested is going to run the job 300 times (once for each file). I want to run the job just once. Like we have file pattern in sequential file which reads multiple files with same pattern, is there a way I can read multiple files(may or may not be in the same directory) ...

Hi, I have 200-300 different files with the same metadata (which I will pass through schema file) which I want to load into a single table. Below are the limitations I have: 1. Files are in different folder 2. Each file has a header How can I read all these files at the same time in a single job. Is...

Yes, quite similar is not identical. His is an insurance domain while mine is a banking domain. So the fields might be different but the transformation he is looking for is the same I am looking for. If you still think I need to create a new thread, I will do that. But I think solution to his proble...

Yes, my problem is similar to UdayanGuha. I couldn't try much as I could not understand how to convert the different file records in a COBOL format. When I put the transformer between sequential file and CFF stage, I could not map the fields. But yes, Udayanguha's scenario is quite similar to my pro...

Hi,
Any help on this? Even I am facing a same scenario with one of my code pieces.

Yes Chulett, I set up a reject link as well. But the job is aborting for unsuccessful load and is not sending anything to the reject. Tried with different properties as well. Is there some specific property which needs to be set up?

Also, I am using a normal load (write mode) and not a bulk load.

Hi, I want to load some data into a Oracle table using oracle connector (in append mode). My job fails if there's some issue with the data load (like primary key violation, NULL value for not-NULL fields etc). I want the job to continue and insert whatever it can and reject records which can't be in...

Hi,
We are currently on the Datastage job design phase and do not have access to Datastage thats why could not try myself. So if there are multiple 'not changed records' with the same key, will my change capture still work (If I sort and partition my before and after dataset based on my key).

Hi, I have a before and after dataset which have two columns PK(Primary key) and VK(Value key). Now in the Before dataset I have records like: PK VK A 1 A 2 A 3 In the after dataset I have all the records in before dataset plus some new records like: PK VK A 1 A 2 A 3 A 4 A 5 B 1 Will my change capt...

Hi, I ran a job wherein I am loading data from source to target after some transformations. Now I want to load the summary of this already run job into a table using Datastage. How can I retrieve the number of records passing through each link in the already run job. Also, in a Datastage job, is it ...

Hi, I am trying to compare a record in Datastage filter stage with the following condition: upper(record) like '%PLAN%' when I run the job I get the following error Parse error: Expected comparison, 'between', or 'like' operator, got: "upper" When I remove the upper function, the code runs...

I am trying to finetune some old Datastage jobs. There are some extraction jobs where we are extracting data from a table (using oracle connector) and putting the data into a dataset. Now in all the jobs I am seeing, a copy stage has been used in between the Oracle connector and Dataset. Since no tr...

Thanks Chulett
Actually niether me nor my manager knows much about Datastage :P. So he asked me to find out how DSParam file is created. Now you have answered to the creation part.
I am now curious to know if DSParam file is different from DSEnv file. If yes, how?