DSXchange

I for one can't tell you - don't have a Windows based server. Give it a shot, let us know! FYI... the batch file worked as long as I was logged into the Server with the same username and password that was used to install the DataStage Server (DSAdmin). Maybe any other user with the same permissions...

Or you can put them in a file and use the -file option on the command line. Based on the server you specify, it will pull the appropriate record from the file. File format: sever,user,password That is definitely an option that I am considering... Although would prefer to not have the username and p...

I am using a Windows Batch file to execute a Master Sequence in DataStage. Presently I am using the following command in the batch file: echo @"%clientdir%\dsjob" -server %servername% -run -mode NORMAL -warn 50 -wait -param RunSched= %paramval% %ds_project% %mainjob% @%clientdir%\dsjob -server %serv...

It's probably just volume. Have you sorted your incoming data in a manner which supports the aggregation? Have you 'asserted' your Sort Order in the Aggregator stage? If not, then that is more than likely your problem. If you have, then something else is going on. Thanks for the reply.... I have no...

I am reading millions of rows from a source table and after about 12 to 17 million rows my job aborts at the Aggregator Stage. The errors in the log are: JobName.Agg_StageName: %s (Warning) JobName.Agg_StageName: |-100| (Abort) Has anyone else encountered these errors. I have put an nvl function on ...