DSXchange

Hi, I am getting following Phantom error how to look at line # 220 and from where DataStage Job 330 Phantom 20630 Program "JOB.403394601.DT.1369463998.TRANS2": Line 220, Improper data type. Attempting to Cleanup after ABORT raised in stage JobNameABC ..Transformer_32 DataStage Phantom Abor...

it worked out.. No quotes.. !
Thanks all!

I am getting following error when i provided "/ fullpath/Archive.ksh #InputFileName# #InputPath# #ArchivePath#" Error *** Output from command was: *** SH:"/ fullpath/Archive.ksh InputFileName InputPath ArchivePath: not found. Do i need to provide anything else apart from parameter. Th...

Hi Craig,

i gave like

"cd fullpath/XXXX.ksh #InputFile# #InputPath# #ArchivePath#"

is it correct.. or do i need to separate it by commas.

new to this stuff..

Thanks

It is EXECSH - not EXECSL - typo

Hi, I need to archive input file (created thru job parameter -created based on input parameter for the job - so i don't know the entire file name but i know AAAA.BBBB .XXXX - where XXXX is dynamically changes). I want to use EXECSL after job routine to use and archive my input file, we a have in hou...

Hi Arndw,

Tested the function and it is working fine now.
Now need some hlep how to pass values to Job Parameters.

I have same kind of requirement to read a sequential file which contains a single record seperated by "," . I need to use this values as parameters in same job to get the data from DB2. I created function using ReadMySeqFile(InFile) EQUATE Delimiter to ',' Ans = '' OPENSEQ InFile TO InFile...

Hi Ray,
Can you please provide any sample codes you are mentioning about Execute or routine activity..

Thanks in advance..

Hi Ray, Input Seq file contains only one record with 3 values separated by a delimeter, i need to get those values as a parameters to the next JOB-1 and JOB-2 , so right now i am reading those values in Xfm-1 , stage variable area and passing using pipe to job paramters by invoking UtilityRunJob fro...

I have job where I am triggering JOB1 using UtilityRunJob Transform -1 stage then Trigger JOB2 in another Transform-2 stage. I want to trigger JOB2 only when Transformer-1 status is successful. I tried using DSLinkLastErr = 0 and DSStageLastErr = 0 in both transformer stage, but could not achieve wh...

Create another job only for FTP and in the sequence trigger it when ever previous job successful.