DSXchange

If one of your two output sequential files has the same columns and contents as your database then you can use that output file as an input stream to your database stage. This would effect a sequential load.

Change the $PROJDEF values one by one until you find out which one of the settings for which parameter is causing this. Once you've identified it, see where and how you use it - if you can't find the problem location you can post additional information here.

There should be no difference between the two, since the data is on the server. Are you using the same login-id to enter the designer in both cases?

Do you mean that "view data" from DataStage is showing the correct data? I don't know what you mean by viewing the data from the server. What happens if, for test purposes, you replace $PROJDEF with other values - does it work?

Murali - my question meant that you should look to see where in your job you are using $PROJDEF and to make sure that it is used correctly. It should be in the default parameter values; the fact that your job is showing an error in a library is quite odd. The passive source stage for DSLINK1 is most...

Murali - "-$PROJDEF" for a library looks very suspicious. Are you using $PROJDEF in your job?

Raghu, there are several builtin functions for manipulating dates in PX. Are you wishing to subtract one day or one second from your timestamp?

As you've noted, the .ds file doesn't contain the data, so removing it iwll leave orphaned datafiles. You should use the UNIX command orchadmin rm {dataset.ds} to remove both the descriptor as well as the associated data files. The orchadmin command also has a desc option to let you get such informa...

In DataStage, what you view is not always what you get. If you output your data to a sequential file and then use the same viewer that you do for your source data it should be the same.

The pipe symbol needs to part of the string sent to the routine in order for it to correctly parse the parameters. You also have put the "'=" sign outside of your string... Your line needs to look something like StageVariable2 =If StageVariable1=-1then UtilityRunJob('ErrorLoad','JobName=':DSJobN...

Looks like the value of "0" is being used instead of the parameter name. What does your actaul call look like? Perhaps your pipe symbols are correct and the error lies elsewhere.

Cut-and-paste the pipe symbol from this thread into your parameter list.

Yes. Do you want to see the errors, do you want to find out how many errors from another job or from UNIX?

If you change your sort order then you would be changing your current record based on the previous one - meaning you wouldn't need to do an update of a changed record.

This looks like your c++ compiler is not installed or configured correctly.

1501-273 A mismatch exists between the OS level and the configuration file. The configuration file /etc/vac.cfg is intended for AIX 5.2. Use vac.cfg.53 to correct the problem.