DSXchange

Executing a batch job through execute command. Was having an issue with the batch where I need to check if FTP was successful by reading the ls or dir, and send that list to a file, then use grep on that file to find my required file name. Any suggestions? slightly out of the DS realm but any help i...

Hi all, I am trying to finish up a job sequence that sends a success/failure notification if a file is/is not created on the mainframe. Does anyone know how to accomplish this? I assume it would be something like a script checking if file exists after logging into a server via FTP... I am unsure of ...

Great. Thanks for your help. :D

My C skills are beginner level . But for the wait for file stage, when time is 00:00:00 how will it act, meaning will it fail if once it reaces this point in the process if the file does not exist? (i know simple question, but I need to be sure)

Thanks.

Hi all,

I am a real newb with routine writing. I am trying to have a routing that looks for a file. If it exists then the routine is OK, otherwise it is a Fail.
Could anyone help me out on this? or point me to some resources that I can sift through to find a solution?

Thanks and happy thursday

sidenote: posting ftp loc, user, and password may not be a great idea for sensitive data... and if its fake good on ya

Hi all, Had help with parts of this recently but can't get to the end result. I have a Routine which reads a list, passes the list to a parameter in string format, and a Job which trys to use this parameter in a WHERE clause in a DB2 SQL Query. Here are the specifics: The Routine is as follows: Ans ...

Hey again Ray, Well i appear to have set the value of the parameter correctly. This is the value of the param passed in: ppFNDPolicyList='0136530000','0322430008','0414643009','0532516008' So thats all good. But when I run the following code: SELECT CTR_POL_NUM, CTR_RSA_TOT_PREM FROM DMIDBO.CTR_TRAN...

Hi Ray, I have defined the Parameter type as String. Here is my routine: Ans = "" OpenSeq FoundationPoliciesFile to fFoundationFile Then Loop While ReadSeq Line from fFoundationFile Ans<-1> = Line; Repeat Convert @FM To "," In Ans CloseSeq fFoundationFile End Else Call DSLogWarn(...

Ok I used all my "resources" and was able to create the routine to pull the data. It worked :D . In my job sequence I have a simple routine activity linked to a parellel job (containing the DB2 sql pull). On runtime I recieve the following error: db2testing..JobControl (@Copy_of_jobDB2FNDt...

I can grab the data fine now... db2testing_exec_command..JobControl (@Execute_Command_8): Executed: type \\Nho04\micpriv\Adam\CPC_Datasets\ER_CPC_Unmatched_HUON_PolicyNumbers.txt Reply=0 Output from command ====> '0136530000','0322430008','0414643009','0532516008', however I am still getting the sam...

hey Ray. Thanks for the reponse. Do you know where I can locate documentation on where to write the routine in datastage? my IBM manual is lacking... at best.

7.5x2

It seems to not like the <1>. My expression is Execute_Command_8.$CommandOutput<1> and it give me a compile error of 'Expected: Expression'. I tried Execute_Command_8.$CommandOutput[1] It compiled but errored on execution with the same error: db2testing..JobControl (@jobDB2FNDtest): Controller probl...

Ok that makes sense about the list, thanks for the input I was unaware of how exactly the list setting worked. I have formatted my input .txt file to have all values on one line... i.e. '12345','54321', This parameter is now defined as a string as well. I am still recieving the same error. Where exa...