DSXchange

Hi, My source is a file. I have one column name like ENAME and data's are like below. ENAME 1 1 2 3. Now, my problem is I need to capture all the unique records in one file. The records not unique need to capture in other files. I know only If any duplicate records are there, I will capture that rec...

You can put all the jobs in one Parallel job if job parameters are common and the run this job. So all the jobs will run concurrently. Sorry I didn't explain my requirement clearly. Please apologies for that. I have developed 7 jobs. All the jobs have moved to other job. That means one job consists...

Hi All,

I have developed 7 jobs. Now I need to run all the 7 jobs concurrently. There is no dependency in any of the jobs. Is there any way to do in the sequence. If yes, Please help me how to do?

Thanks Ray. I fixed my problem :D

Hi,

In my source file one of the column is Date. My requirement is If any Date Format is DD-MM-YYYY then I have to load the records into target table. If records are not in DD-MM-YYYY format move the records to rejected files. Plz guide me how to Identify that the record in DD-MM-YYYY?.

chulett wrote:Assuming you really need that output format... what is your target datatype for this? String or Date? ...

Thanks for your response chulett. My Target data type is date. I tried even convert function to remove first single quote from the file like this. Convert ('''','',inputcolumn). But no luck.

My source file having one date column. It has value like Ex: '02/03/2001'. I need to load my date column like yyyy-mm-dd. I don't know how to remove the single code from the date value. Plz help me to achieve this Issue?

Input :'01/02/2001'
Output:2001-02-01

I have csv source file from that i am getting the date column in the format "dd-mon-yy" but, i need to load into oracle table with the format yyyy-mm-dd. Plz help me how to achieve this.

I have finished my job successfully but with warnings. When I was checking the director I got error message like this " Unable to read Temp_Final_Balance to OMD.XML.DIR. I don't have any temprorary files in my job. But still i am getting this warning. I don't know why it's coming. Plz guide me ...

yes!I need to do like that. Plz help me how to do this?

Hi,

My source file is having more than 10 lakhs records. When I execute my jobs some of the records are going to reject files. Now, my requirement Is If reject records are greater than 10% then I have to stop the job. I don't know how to achieve this?.

Please give me valuable Input for this

thx for your valuable inpurt ray.

Thx for your Information ray. I need one more Information. Can you tell me what are all the functions are not common between UNIX and LINUX?

Hi All,

I just wanted to know few Information from you. I am planning to Install datastage in Linux Environment. After some time I want to migrate all datastage jobs to Unix Environment.

Is it possible to do that? If it is possible, how to do that?

Please provide all your valuable reply for this

Thanx for your reply eostic. The question how to parse the xml string. I am new to DB2 Env. I don't know how to achieve this result. Plz help me to resolve this issue. Sample data: <Object name="Person"><Attribute name="Name"><Scalar>david</Scalar></Attribute><Attribute name=&quo...