DSXchange

As of now, I am interested in Job Start time, End time and Job status.
Please elaborate how I can access DSODB database to get this information. If possible, in detail please.

But Datastage Director client will also give the jobs which didn't ran today. Basically I want to create a report in customized format and automate this process. We can do this using dsjob command with -linvocations but this gives all invocation ids irrespective of date. I am just interested for a p...

How I can get logs (Status alone will also work) for datastage jobs ran today/yesterday. Please note that jobs are running with invocation Id (Multiple instance jobs).

Thanks for the response. I was just asking if can handle this at sequential file stage itself. As this is the expected functionality

Hi, I am reading a Sample.txt file using Sequential File Stage. Below are the details for .txt file and metadata for Sequential File Stage- 1) 3 Fields are defined in Sequential file stage Schema. 2) Sample.txt is having below set of records- Field1|Field2|Field3 1|2|3 11|22 111|222|333|444 Output o...

Hi, How I can write User defined Update/Insert query in Netezza connector. I have a update query similar to the one mentioned below : Update Table1 Set Col1=Orchestrate.DatastageCol1,Col2=Orchestrate.DatastageCol2 DatastageCol1 is the Column coming from input link to Netezza connector. DatastageCol2...

I would guess your script has a typo. Can you post the whole script? So,the guess is correct...Below is the script I was using- DSCMD=/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob If [[<expression>]]; then `$DSCMD -run -wait -param <Parameters> <ProjectName> <Jobname>` fi I just removed &quo...

I have already tried this option. It returns with same warning message.
Also, -mode NORMAL is optional to write, if we don't write -mode then dsjob will run in NORMAL mode as a default behavior.

I am calling dsjob command with"-wait" option from a shell script but it seems, the dsjob command just triggers the job and does not wait for the Job to finish. Below is the Syntax I am using within the shell - DSCMD=/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob $DSCMD -run -wait -p...

Thanks for such a clear explanation. To avoid any future issue, I will go for using different files and then merge into one. This will prevent from any abort/Lock or unforeseen issue.

Thanks for the help!!!

Just to clear my understanding, If LOCKED clause is not mentioned , any other invocation will wait until the file lock is released. Please confirm. What if the LOCKED clause is mentioned? How other invocation will behave? Is there any chance of abort for other job invocation due to same files access...

So, the code works in a simpler way. I just did a small change and here it is.... Changed line : SEEK FileVar, 0 ,2 Since, I am writing into same file using different jobs at the same time, Is there any possibility that file might get locked. I have tested this scenario but did not get this issue. J...

Thanks Guys for the sharing the different approach to debug this. I have the working code now. Now adding few more question as I have added few more requirements :) 1) I am going to use this routine in multiple jobs, hence want to append the count instead of overwriting the file. Using SEEK command ...

Answer #1, Its not a parameter but its a value. I have given "Basepath" in the code posted on forum since I don't want to mention the actual path used in the code. Anyway, this doesn't have anything to do with the functionality of the routine rather it is just to capture the count. Answer ...

Answer to your questions - 1) Basepath is nothing but the disk path where the count in the file "count.txt" will be captured. 2) No, Quotes are not part of the routine. 3) Can't give as of now. I will post that soon. Its just a abort message without any specific detail. It doesn't enable T...