DSXchange

Did you get a read receipt ?

Send a personal message to Editor from DSXchange site as an extra avenue.

Can you please show us? I want to see what "internal format" means to you. Can you also show us the SQL statement being executed by the Oracle stage?

You have declared the data type to be Integer. "" is not a valid Integer.

Change the data type to VarChar or send NULL instead of 0 and set the Null Field Value property to "".

The default value in the Parameter Set for the parameter can still be $PROJDEF, $ENV or $UNSET.

Only if the default value in the project were $ENV surely?

I doubt that there's any way to "capture" the parameters passed to a shared container unless you put reporting stages into that shared container. Probably a Transformer and a Sequential File stage inserted into the stream, with the new output constrained as @INROWNUM = 1.

Welcome aboard.

Have you configured a system DSN for use with Oracle database? DataStage on Windows can not (or will not) use a user DSN.

Have you imported the table definition(s) from Oracle? This will populate a file called uvodbc.config in your project on the server.

What Source Type have you specified in this stage? If Flat File, have you initialized the state file?

Is jobImportVM a server job, a parallel job or a sequence job?

If you want the maximum count, no.

Figure out your actual requirement and deploy the appropriate functions.
I've suggested the most likely.

Does it have to be 20 columns, or can you get them as one column? If not, assemble a field-mark delimited dynamic array containing the 20 columns. Apply the Counts() function to return an equivalent dynamic array of the number of value marks in each field (you may need to convert to a non-delimiter ...

Does it have to be 20 columns, or can you get them as one column? If not, assemble a field-mark delimited dynamic array containing the 20 columns. Apply the Counts() function to return an equivalent dynamic array of the number of value marks in each field (you may need to convert to a non-delimiter ...

Care to be more specific about which definitions you had omitted, the better to aid future searchers?

Maybe not. What if the parameter value had been overridden in the job run request?

Do "they" shut down the system or block access when you're trying to do your exports?