DSXchange

Required Information From previous run DataStage Job 1202 Phantom 17860 kgefec: fatal error Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program JOB.1161750357.DT.1310851132.TRANS1 at address b0.0 JOB.1161750357.DT.1310851132.TRANS1 * T...

Hi All, I am extracting data from Oracle table using ORACI8 stage and writing it to a flat file. After extracting about 15 Million records, the job is getting aborted. The error message is "Abnormal termination of stage J4XfmNovAnu..Txfm detected". Each time also the job aborts when the re...

hi, You can acheive this by sorting the data in descending order and then taking first 4 rows by writing the constraint DSLinkRowCount < 5 in the subsequent transformer. Here wou will have one sort stage in which you will sort the data in descending order and then transformer in which u will write D...

hi, You can use Oconv(Iconv(toTxfm.End_Date,"D-YMD[4,2,2]") - Iconv(toTxfm.Start_Date,"D-YMD[4,2,2]"),"D-M") to get the Month difference only. For more then 30 days difference you will get 2 as the month difference, and for less then 30 days you will get 1. The Input Da...

Hi, u can also go to DataStage Process and Lock Administration and then clear status file for that job, as i have observed that clearing status file from director does not always works, the job remains in locked state. the method of going to DS TOOLS is from ur project directory run . `cat /.dshome`...