DSXchange

well, in this sequence job I have one job parameter data_loc which default set to test, and in the execute command: I coded cat /#data_loc#/chk_total_record.txt | sed s/\"//g However when job ran, got the following error message, /test/chk_total_record.txt A file or directory is not found. That...

I have a sequence job using execute_command. In execute command, I put the following command: cat /test/chk_total_record.txt | sed s/\"//g and the return result is 0 in Trigger, I specify Expression type - Custom - (conditional) and Expression - left(Execute_Command_1.$CommandOutput,1) =0 which...

Search 'Failed to connect JobMonApp on port' was posted back in Tue Apr 20, 2004 2:26 am. You will find the answer you need.

I don't believe so, but someone posted a function on this forum before which will do the trick as ADD_MONTHS, see below FUNCTION AddMonthsToDate(BaseDate, Months) Equate RoutineName To "AddMonthsToDate" Ans = @NULL Test = Iconv(BaseDate, "DYMD") If Status() = 0 And BaseDate Match...

If you got datastage CD then go to datastage client -> Docs -> ENU -> Books directory, open up the document 'dsupgde', there is a chapter 'New Feature in DataStage' will give you a list of new feature has been added in version 7x.