DSXchange

sorry that was typo error from me.

it is

I am building a simple job wherein I am using a DB2/UDB stage and linking it to a sequential file. I am specifying a user defined query like "SELECT COL1,COL2 FROM TABLE WHERE IN COL1 IN (111,112,113)" When I execute the query i get the following error and the job aborts. [IBM][CLI Driver]...

I have a set of jobs in job sequencer and now i need the names of the jobs in the sequencer as a comma separated list.

What functions can be used for this?

Also how can i get the names of individual job activities in a sequencer

Hi,

I am using a job control code to retrieve some information possibly values.Is there any way to pump these values into a text file?

Regards,
Shilpa

Hi Ray,

My requirement is to populate all the director logs into a dataset.

so will this approach work?

Thanks

Hi,

I have a job design like a universe table loading into a sequential/dataset file.

In the universe table I want to use SELECT * FROM RT_LOGn where n is the job number.

Will this approach work in capturing the job logs?

Regards,
Shilpa

Hi Ray,

How would it be possible to store it in unified metadata repository?

Hi,
Will all my director logs be placed in RT_LOG?As per my understanding,its a universe hashed file.Correct me if I am wrong here.As a developer will I have access to RT_LOG?

Regards,
Shilpa

I want to bulid a container for error handling. I want to select columns from the calling job and capture the error/message and feed to an oracle or db2 stage.

how can i implement it in datastage version 8?

Do you mean to say that you want to move the hashed file from a non protected environment into the production environment? Your question is not clear here. Hi All, Is there any way to Move the Hashed file from one project to another project. We have a requirement to create a hashed file in one of th...

Well using NumericRound4 in DS Transform sorts this problem.

I have got the solution.Using a transformer between the OCI stage and the Pivot solves this problem.

I have got the solution.Using a transformer between the OCI stage and the Pivot solves this problem.

DS Transforms are Datastage routines.Month Tag is one the DS Routine which converts a numeric internal date to the string in YYYY-MM format.

I tried the same in oracle writing a query and inserting into the same target table.

But there I am getting currect result without specifying scale.