DSXchange

Btw, this is part of "Sequence" jobs.

You can also include a sub-query in job1 as

yourNormalQuery
where
not exists (select 1 from Table1)

This is assuming that your job does not overwrite or re-create anything.

Several ways.

Simplest will be to run the sql command from command activity and decide on the return value.

What is the returnCode from the cl ?

Also the PIC clause used in the CFF stage.

Can you put that in simple English please. Too cryptic for me.

Also provide more information on what you are doing.

You need to provide
a.) job design
b.) resource available
c.) error messages received - unedited

for anyone to assit.

Scratch or Resource disk being full may be due to several reasons.

But you can simulate an update or use other mechanisms to make it happen.

You may have to break the job into smaller units or increase your "resource" availibility.

Update what ?

You have provided no information for others to assist in any way.

Provide your full requirement and design.

Who said you cannot use any database ?

Pivot stage is part of default DataStage installation.

Btw, do you want the last column alone or all other columns with the last one made single?

One possibility is that your hashed file is the driving stream and source is the reference. So any unmatched value results in setting NULL.

You can include a constraint in the update link as IsNotNull(hashDesc).

Patience is a virtue. This is an all-volunteer site.

1.) Use same job with different connection parameters which can be change during runtime
2.) Include any unique value in connection parameter - say dbname - as part of the key

Is your job a Multi-instance job?

Try opening director from the designer via tools->director to locate the exact job you are running in director.

Also try refershing your director (Ctrl-R) to see the latest entries.

PS : Please avoid reply with quotes

Do you have any transformer set with abort after 1 rows option enabled ?

If the target is a sequential file, set the record delimiter to none (or spaces).