DSXchange

What exact action you wish to perform?

In the connected ODBC stage.....obviously.

Simplest will be to perform an 'after job' sql to insert row. If you want to keep everything in DataStage, you can include that as a separate link in your job.

As you said that it must be 'after' the rows are inserted, I believe it will have to do something with row count, reject info etc.

Good point Craig. Maybe the column name used as the place holder is causing the problem somewhere. But this is only a guess as there is no information on the design.

The comma is meant to be there. It implies ANY option of the 2 values provided.

Also have specific column names instead of an '*'.

I think he means writing the output to user status and connecting the link output to a (dummy) seq file with name as /dev/null in order to ignore any output from it.

Roy,

Did you check whether any value is populated into the user status?

Maybe your project was removed from the VOC. Does it say your project name is invalid?

Check whether you can logto your project from universe.

If everything is fine, you can perform a reindex to set your links correct.

Check whether
1.) Is_Expired is a numeric datatype
2.) COL_ID is not a numeric data type

Can you run the same successfully via sqlplus or toad?

You have option to distribute the record and collect them again.

Lindy,

That is why you are using Universe BASIC language to prepare the value. If it is user defined, you can accept it as a parameter and compute the same in your program.

Distributed hash file is similar to partitioned table. I do not think you will be able to cache as the main purpose of this is to reduce the scanning and loading into memory.

Use mv command and supply the target file name as mixed parameters.

As ArndW said, it is something defined in the tutorial and any class.

Check you have linked your seq file before the hash-file.

You can call your routine as a normal function. But you need to define it using 'deffun'.

Search for 'deffun'.