DSXchange

Main sequencer call several jobs(Which have parameters) with job activities..and following are the job activity parameters.. JB_TRG_DB=TRG_DB JB_USER_DB=USER_DB JB_PASS_DB=PASS_DB and same for other activities.. It's not a problem with your script or how the parameters are defined in the Sequence j...

This would be a more appropriate topic for the 'Site' forum, don'tcha think?

Hmmm... what exact version number of DataStage? I believe that this 'delegation' can only happen during the installation of the server itself, but not positive.

Two problems here. 1) You've posted the exact same thing twice, once marked as Server and once marked as Parallel. Which is it? 2) You've not stated what you've tried, what problems you have encountered nor asked no question. As Ray would note, with no question the only response would be - 'Fine, g...

How, exactly, are you allowing the parameters to 'default' inside the Sequence job itself when running the child jobs via the Job Activity stage? That should be where the error is coming from. They should be empty there, allowing the job to use its current default value.

And? Did you search the forums as suggested?

For every column defined on the Columns tab, you need to specify a numbered bind variable. You've got 8 columns defined but only 7 mentioned in the sql, hence the error. Remove the target for the sequence from the column list (TREASURY_PRODUCT_CODE) and decrement all of your bind variable numbers by...

Not that I recall. How large is the file? What is your job design? Reset the job and see if there is a 'From previous run...' message in the log, if so post it.

Ah, yes. I recall that you do have an option to specify whom a scheduled job would run as, but would it not default to the scheduling user? Still, something that needs to be checked regardless.

Do you get any other messages as well? Have you tried searching the forums for 'Unable to return an attached job'?

Corruption. Please search the forums for 'Failed to open RT_STATUS' for a number of discussions on the subject.

Scheduled how - via Director I assume and thus 'at'? Unless Windows works totally different from UNIX, it should run under the credentials of the scheduling user. Don't know for certain, however.

Not without some idea what your "DATE(4)" data looks like and what you want to do for the missing date/time portions.

It's telling you that the parameter name you used doesn't exist. Why are you trying to set a parameter that uses an environment variable? Let it default.

No clue - you tell us. I don't have that stage on my palette.