DSXchange

Hi All, I cannot write user defined query at target, This is my requirement I have RCP enabled job which creates a dataset with one column by joining 2 tables. Query is passed through parameters. Is it possible to delete the records by using dataset which is created using RCP from table? I need to d...

I cannot use DB2 Connector as output in same job, because i am selecting the data from same table by joining with one table. So i need to store this data in dataset and in next job i need to use this dataset and delete the data. As the job is RCP Enabled i cannot make this column as key in dataset

Hi Ray,

The data of column in the select statement (which is passed as parameter) is stored in dataset. How can i use this column from dataset and delete the data from a particular table.

I have multi instance job which is RCP Enabled. Source query is parameterized as below Select #Parameter# From #Parameter A#, #Parameter B# where A.column=b.column Select has one column and is derived after joining 2 tables and the data of this column is stored in Dataset. I need to use this dataset...

Hi Criag,

I used execute command in the sequence to get the status for each instance.

First step in script to get the jobinfo like starttime, endtime, job status, jobname and seq name. Once this is done, script will send mail if the job status is other then RUN OK, then next is to load the above stats into table.

Craig,

Sorry to ask silly question what should i select in drop down for after sub routine to use DSJ.JOBINTERIMSTATUS?

Hi Paul, Thanks for your response, As my job is multi instance, i want to capture status for each instance, If i call the script at the end of the seqeuce by using execute command i cannot achieve my requirement. I want to capture the status for each instance, how this can be done. Appreciate your h...

Hi All, I have unix script which get me the jobinfo like start time, end time and status of the job. I am using this script in after sub routine in one of the multi instance job. I am passing job name and invocation id as parameter through the job, Issue is the instance is finished but the status re...

I do not want to run seqeunce in loop, is there other way to provide invocation id.

Hi All, I have job which is multi instance and i have a parameter set which has 10 value file name. I need to pass invocation id from value file eg:-- Parameter set is ABC and value file name XYZ and invocation id is 1234 I need to pass value in seqeunce for invocation id as below #ABC#.#XYZ#.#Invoc...

Hi All,

I have multi instance job which has a after subroutine which calls Unix script,
Please let me know how script run if 10 instances are created? Does Unix script run in multi instance mode?


Thanks
Manoj

Hi All, I have built a new multi instance job and new parameter set which has 10 value file name, Need to know how the value file should be automatically set during job run. If i run this in adding seqeunce how to define value file name values for single multi instance job in seqeunce to take 10 val...

Hi,

I have master sequence which has 100 jobs in it, if a job fails, how to identify which job has failed as I do not have access to director.

Thanks

Hi Everyone,

I am facing performance issue when i am loading data into SAP by using BAPI stage. Currently i have 9 Million records and job took more then 24 hours to load this data. can anybody help to improve the performance.

Thanks