DSXchange

Wrap the command in some shell and call it on After Job subroutine.
orchadmin rm DatasetName

Kim, what you said is 100% true. We can do anything but not with the cost of our health. I ll find room for myself to play Cricket, just an outdoor game. I do pencil sketches to find some relaxation. I ll try to follow the commandments that you mentioned.

hi Parvathi, Sorry, I couldn't get what you exactly mean here. Do you mean to say, the records are getting reject at transformer or not passing after this stage? If so check the constraints and metadata options for nullable. If you see the statistics in the input link of the tranformer, and if there...

Have you searched for 'Code 138'.
Could you explain more about your job structure? Is it Dataset--->Transformer---.Dataset???

JOBNO is the unique no given to each job by datastage engine, when it got created.
JOBID is alais name that can be assigned using dsjob function.

Hi Ravi,

Welcome to DsXchange :D !!!

As mentioned, you need to explain clearly on what you exactly you are looking for. Are you looking for some stages in datastage which work in unix OS. If so SCD is available in the latest version 8. But Windows version has just released.

Is it like you are processing some kind of where class to another database or a script file or something?
After concatenation, check for IsNull(), and assign the required default value.

Don't you get any other error or warning? If the job is aborted, Reset the job and check for 'Log from Previous run..." log, it might get you more info.

Pls delete the other duplicate post.

Try to create a dummy file in that directory with the same user id, and check if you have rights to create a file on that given directory.

Hi Raj,
Welcome to DsXchang :D !!!!

You can pass it as a parameter from the calling job. $PROJDEF or $ENV can be used by the job to assign the Env variable as parameter.

Good to see these sort of post among the routine ones.
:D

The previous attempt may not be fixed width, or may be a varchar field.
Try giving three spaces like ' ' as default.
By the way, what is the issue at field level settings?

Check the field "A", if its fixed width, the null field value that you have specified as default doesn't match the given length. It should be of 3 digit.
Search for ""null_field" length (0) must match field's fixed width (3)" for all match.

Hi and Welcome to Dsxchange :D !!! There should be other valid error code along with this error message. Just with this message, we can guess various reasons like, Wrong SQL query, incompatable datatype, wrong column name specification. You need to give more details about the job as well as the erro...

That particular directory can be of different mount point, which might have network congestion.