DSXchange

Thanks Anbu i will try that

Hi anbu
but how do do you fetch that in formation into a file

Hi Anbu
This we need to give on unix or in the before/after subroutine?

Hi All,

I need to get all job information and load to the table can any one tel me how to parse the datastage log/DB.

Thanks in advance

Hi ray, "in a Transformer stage, direct values into the appropriate columns depending on the value of the field name. ... " To the above suggestion if we take 2 fieldslike field1 field2 name roxy place chili job_type emp status active block A manager vick duration 2 How can we direct this ...

Hi Arnd,

What ever u suggested is exactly what iam looking for but iam using server edition can you please suggest me how to achieve this in server edition.

Thanks

Hi ray, but if i do so then i will get only two fields but i need out in this way name place job_type status block manager duration roxy chili emp active A vick 2 This is my input name: roxy place: chili job_type: emp status: active block: A manager: vick duration: 2

Hi All, Iam importing a txt file the sample input is name: roxy place: chili job_type: emp status: active block: A manager: vick duration: 2 now i want output as name place job_type status block manager duration roxy chili emp active A vick 2 i tried with delimiter : but iam not getting required out...

Thanks swapnil for immediate response but i wanted to do this because these jobs are scheduled for next 30 days

Hi craig ,

Oracle database

Hi craig,

Ya , we are using autosys and i have to fetch previous jobs status information and comming 30 days jobs status information from database .

Thanks duke for quick reply but iam not getting clear idea like how to design the job

Hi All,

I have a situation where i need to fetch History and comming 30 days job status information from autosys to peoplesoft table, Can any one share their ideas.

Thanks in advance

Hello All, In need your advice on something I'm working on. I need to create an Job sequence in the DataStage project A but this needs to trigger a job which is in the DataStage project B. At present I use to do this putting a flag in a table and I have a Unix Shell that looks for the flag and exec...

Hi Ray,

You mean to say delivered jobs?