DSXchange

Hi,
In sequencer,Is it compulsary to enable below both options to impliment the job restart activity.Can you tell whats the difference between these 2 options.
- Add Checkpoints so sequence is restatable on failure
- automatically handle activities that fail

Thanks & Regards,
Arshi

Hi, Facing the problem while loading the data from DB2 to Oracle , The Timestamp column data in the source not loaded correctly to Target . Using DB2 as source and Oracle as Target. Datastage server edition : 7.2.1 Source data like : 2009-03-06 13:40:02.000000 Datatype :VARCHAR of length 28 Target l...

Murthy,

Using Server Edition (7.5.1)

Hi Murthy, I didnot found any options tab in the sort stage . I am using the server edition (7.5) . Can you explain where it is exactly? Hi Sainath, As per my requirement I have to sort column1 and column2. Here, column2 having the date data (DDMMYYYY). If i use the sort stage its not giving the cor...

Hi,

First sort the data by using the Sort stage and use the stage variables to remove the duplicates.

By using the sort stage , It will work fine for a particular month data but not on entire data.

Any one have the solution for this.

Regards,
Arshi.

Hi,

I want to remove the duplicate data on the DATE column data.
The date format is DDMMYYYY.

Using Datastage Server Edition (7.5) , source is Flat file.

Any one have the solution for this?




Regards,
Arshi

Hi, I am getting the following warning while running the job. [IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 Source : Text file Target : DB2 Any one have the solution to overcome these warnings. Regards, ...

Chulet,

How to demote the warning messages using message handler.

Regards,
Arshi

Hi, I am getting the following warning while running the job. [IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 Source : Text file Target : DB2 Any one have the solution to overcome these warnings. Regards, ...

Hi,

Remaining all other jobs in the project running fine.

Also giving the Following Messages:

DataStage Job 123 Phantom 8934

In Phantom 8934 warning givining the message as:
Program "JOB.253038028.DT.1493569814.TRANS2": Line 432,

How to overcome this problem.

Regards,
Arshi

Hi, I am facing problem while running the ETL job, In log its giving the message as ds_uvput() : record contains characters which are not defined in the file's NLS map. Also the job running very slowly along with warnings and some times aborted. Can you provide the solution to overcome this problem....

Its working fine by using Index() function

Thanks,
Arshi

Hi,

One of my source column data having the word 'Index' (this word is part of the Text).If the 'Index' word occured then I want to remove that particular row while populating to the Target.

I am trying with 'Matches' function.But unable to get the solution.

Regards,Arshi

Ray,

Once importing data into sequential file,how to build the mentioned filter logic(to filter the 5 character data from the source file ) .Can you give the solution for this.

Hi, I have a requirement to filter the 5 character data from the source file and load the data into Target.Source data will provide in text file with pipe delimeter.How to impliment this logic and is there any function available in datastage. Datastage: Server edition(7.X) Source: Text File(Pipe del...