DSXchange

Thanks chulett.

The version of DataStage is 8.1.

I would like to see a log for perticular job And I am not able to see means..the DataStage Director is Retrieving log for that job from last two hours.

I tried by closing and re-opened the Director.

Thanks
Bob

Hi

Can anybody please let me know where the log files are stored?

I am not able to see log in DataStage Director. Is there any way to see the log for perticular job?

DataStage is installed on Windows Server

Thanks
Bob

Hi

Thanks for the suggession. However because of following reasons I am not mearging the rejected records in to one file.

1) Metadata for the files is different

2) Rejected file names indicate which source file has rejected records.

Thanks
Bob

Thanks. Using the ZIP Approach this issue is resolved.

Thanks
Bob

Hi

Can you try / test the same routine without "DSSentmail Routine"?

I was also facing the error with "DSSentmail Routine" in my routine

Thanks
Bob

Hi I tried to use the "DSSentmail Routine", but I guess I am missing some header file to include. And I am not sure which file to add in the routine. I was checking each file in a loop and if the return code is "1" then I was sending a mail using notification activity. Thanks Bob

Hi, If I understand you correctly, 'You want to send one email with all the rejected files, provided if they have any records in them'. In this case you can directly use the notification activity stage and in the attachement space list all the file names (with path / parameter). i think is would fi...

Hi, For the same design, I have developed a routine, which will take the rejected file name and path as arguments. Then I am checking the record count (wc -l) and if the record count is greater than 1, then I am sending a mail to the user. Consider, First line in rejected file is column header. Rout...

Hi Thanks for reply. I was trying to use the utility "UtilityRunJob" as below UtilityGetRunJobInfo(UtilityRunJob("Depend_Job", "my_date=": DSLink2.STATUS, 0,0),"JobCompletionStatus",'') I guess, we can only read the value of parameter my_date i.e. "DSLink...

Hi Craig, I am trying to avoid parsing the values and trying to develop a solution in which I can fetch all the values for parameters from Oracle Database in one parallel job, assign each parameter with the value from database and directly (without parsing) pass those parameters (with values) to ano...

Hi USERSTATUS is a good option, however If I have to pass 15-20 parameters, then I need to set the USERSTATUS with comma separated string and assign it to another job using some manipulation.. Is there any way, using which I can assign Parameters of job one to another using sequence? Can we create o...

Hi In a sequence, we have two different jobs depending on one job. Currently we are passing the parameter value to sequence using parameter file. Now, the design has changed and we need to pass the parameter value from Oracle Database by reading the param table. Option one: Read the parameter from O...

Hi We are executing a sequence from last 100 days. We need to generate / present a report on the performance of the jobs. ( The performance of job is not good). We need to present this report for statistical analysis. Is there any function, table / query or procedure or tool, which gives us the deta...

Hi I have two sequences, Seq A and Seq B. Seq A is a "parent" sequence because Seq B is called from Seq A. In Seq B, I have 15 DataStage Job running in parallel. Now Out of these 15 DataStage Jobs, I need to disable one job (Job A) temporarily. I have two options, 1) Create a Dummy Job (Fo...

Hi I have a requirement in which, I need to read a column with has 100,000 characters. The source is a sequential file (.csv). Total Rows between 10 to 200. Can I read the column in a sequential file as VARCHAR (100000)? If yes, what is the maximum length i can specify to read the column? Thanks Bob