DSXchange

Hi CharlesNagy,
Welcome to Dsxchange!!

$DSHOME/bin/uv "uv commands" is one way you can call the uv commands from the command prompt.

When i am running the sever job its finished.after i will run the sequence job that server job is aborted.
Since Satya, able to run the job individually, NLS shouldnt be an issue. Should be somewhere in the method of passing the password value.

Mike wrote:The OP did say he only needed to create 5 output files. That is simple enough with the GUI to set up 5 output links with constraints.

True.

Just export doenst make any differenct in the working Job/Routine. There should be some other environmental change, which might be the reason for the routine to validate ok for those records, which you think, should be rejected.
What is the condition based on which you are trying to reject the rows.

I think I faced similar problem in 7.5.1 when last column is null. I tried to swap a non nullable column to the last. Just give the try with the same.

Is it SPU or CPU?
Which database? Where are you firing this query?

Check if you have any header record.

The error is about the exixtance of the parent column. Check whether the give name is correct. If not try to have table.column name in the statement.

It is best to write a BASIC routine if you are not sure about the number of group of x you are about to get.

Beware, dont try with all the command you try to learn in to the Datastage system files. It may totally screw up you project as well as the installation some times.

You can speak to your support people to locate the patch.

Check if any of your input column contain Null. If so try to use NVL/decode/coalase functions.

As Kim mentioned, if you use seperate link for each Insert/update/delete you can count using the link count. Else if you have any lookup feature, maintain a internal counter using any stage variable.

"invalid username/password; logon denied "
Are giving the password as Encrypted? The parameter passed in the Database job should be covered with #. #PasswordParameter#.
Though it will just show you *'s.

May I know your version of the Datastage. I guess your server might be in unix. Though you clients are on windows, the jobs are getting compiled and stored in the server. Where ther is not such exe. Rather its all a OSH code.