DSXchange

You can probably write a routine. But is it just comp3 or signed decimal (PicS9)?

chulett wrote:Or just one column with any non-null value from your feed and Count it.

Actually this is a better way.

Then i tried for Field(Execute_Command_0.$CommandOutput,@FM,1) also Execute_Command_0.$CommandOutput<1> You are giving these expressions in the expression space of the job parameter right? Try this, clear out everything, right click, it will open up a small list. What all do you see there?

Do you have any warnings in the log file?

Refer to this post. Look at the last post by me. It gives a design description along with code.

Add a 'www' before the dsxchange in your embedded post.
What is your job design?
What did you type in the expression editor?

whardeman wrote:I think I've just been itching to code something for the last five days.

DSXchange read your mind

Yes just select. I think that will be it as far as the system tables are concerned. A complete list is found in the help guide of Oracle Enterprise Stage.

The error message tells you all. Its not being able to connect to the database. Have you ever gotton this stage to work before? If yes, then verify that your dabase instance is up and running.

The OP will have to give the begining event id and ending event id, which i assumed he will get to know once he reads more about it in the guide.

Did you set APT_LINKEROPT and APT_COMPILEROPT too?

Add two more columns in your aggregator with derivation @INROWNUM for the count and a dummy key for the other.Feed it to the aggregator, grouped on the dummy key and Last for the count column.

Or even dsjob -logdetail.

Open datastage help and type Type conversion functions. It will give you a chart. This function is present there.