DSXchange

Hi, We are working on a project to migrate DataStage 8.7 to Talend. Is there a tool/utility which can automatically convert DS code to talend? If so then what is the percentage of code which can me automatically convert DS code to talend? what are the limitations? Or do we need to manually migrate t...

Today we ran the job in test environment again and the stored proc did actually run. The insert in the SP however failed due to NULL being inserted in Non nullable column. Same was captured in the log table. However we have no way to know what happened in the last run which happened last month. I am...

We have a job which calls a stored Proc using Stored procedure stage. The stored procedure has some insert statements. We have handled exceptions in the stored proc and any exception is captured in the log table. When the job is run in dev environment the first insert in the stored proc fails due to...

Hi, I found the work around. Replaced the first tr statement with a perl statement. OsCmd = "tr -d '\000\001\002\003\004\005\006\007\010\011\013\014\015\016\017\020\021\022\023\024\025\026\027\030\031\032\033\034\035\036\037\177' < ":FILENAME:" > ":NEWFILENAME Replaced with OsCmd...

Hi Ray,

As mentioned before, there is no error thrown. The same command works fine directly from the AIX box but not from the DS routine.
The routine returns status '0' (success) but the result of the operations (tr command and pearl) is not visible in the final output file.

Regards,
Abhisek

Hi, We have migrated our project from LINUX box to AIX box. In one of the DS routine we have are performing some operations using unix commands. This commands works fine in DS routine on LINUX box but it doesn't works on AIX box. The unix commands works fine if i run it directly from the AIX box. Bu...

Thanks Craig,

Thanks Eric,
I like your suggestion. But just I am afraid of attempting it as we have a delivery this weekend. I have incorporated the same logic in Stored Procedure in DB2. Just waiting till Friday to test the same.
Will post the results of my tests.

REgards,
Abhishek

Hi, I have a requirement where I need to split a free text column (which mostly exceeds 255 chars) coming in the input row and insert them as multiple rows in the output with each having splitted chunk from the free text column. So, I have used Loop Condition in Transformer to split the columns with...

Hi Ray, Can we use vertical pivot when we dont know the number of rows? Eg My file contains 1 AA 2 BB 3 CC . . . <N> LMT Where <N> is any integer value. Actually my requirement is as follows. My file contains following recs. A1 1 A2 2 A3 3 A4 4 A5 5 Now I have to generate following recs in addition ...

Hi, Its working now. I am now using the following syntax. /interface2/IBM/InformationServer/Server/DSEngine/bin/dsjob -server :31544 -user DSUSER -password DSPASS -domain czhs0791:9080 -run -mode NORMAL -jobstatus -param InputFilePath=/interface4/emacomet/emacomet/cometproject/TR/Input -param Migrat...

Hi Bobyon, I have used similar command to run the job in DS8.1 from unix command line. /interface/ascential/Ascential/DataStage/DSEngine/bin/dsjob -file /interface4/emacomet/emacomet/cometproject/Common/Scripts/dsjoblogindev CZHS0791:9080 CZHS0791.prg-dc.dhl.com -run -mode NORMAL -jobstatus -param I...

Hi,

The issue is fixed now. The job whose call was delayed by half an hour had huge logs. Hence it was taking time to span it in the sequence.
Now we have cleared the logs of that job, reimported the job again and now the sequence finishes in less than a minute.

Thanks for the help ArndW.

Hi, One of our sequence takes 1 hour to complete in production. The sequence contains 3 jobs and 2 routines. After investigating why it takes so long to complete, I saw that the sequence halts for half an hour after it finishes a routine and before calling the next job. The sequence is run 5 times a...

Actually the problems kept aggrevating over the time. First special characters were not visible, later we got the warning about locale, then we noticed timestamps were missing, then recently the job logs got corrupted. At this stage we were not able to run the process from directopr/designer but we ...

Hi All,

The issue is resolved now.
The datastage project was corrupted and hence we were facing all the above issues.
I recreated the project with the same settings as before and now all is working fine.

Regards,
Abhishek