DSXchange

How (with what tool) did you open the control file? Maybe the limit is in that tool.

Protect the dscc executable.

They are explained well in the UniVerse docs. "MD2-" indicates two decimal places with a trailing sign. Note, though, that the result of Iconv() has masked decimal - to reinstate you would need an Oconv().

Wrap your expression in Code tags, otherwise multiple spaces get compressed by the software. Yes, I mean that you need 19 spaces if the Field Width is 19.

So, basically, the same arguments as NullToValue().

You will find, generally, that the Transformer stage has "To" function names, such as StringToDecimal(), while the Modify stage has "_from_" function names, such as decimal_from_string(), for conversion functions.

Setting this environment variable can, as the information you read (and, indeed, posted) about it tells you, prohibit re-import. That's why my preferred approach is not to use this environment variable but to use Null Field Value property values that match the size of the fixed-width field.

Set the Null Field Value property to something that has the same number of characters as does the fixed-width field.

I prefer to use null field values that match the fixed field width.

There's not a whole lot you can do with the knowledge, because it's more for the internal management of jobs, but here goes... VnSmPk is the DataStage Repository ID (DSRID) of an object. V is a "view" - the basic job design is always V0 and containers are numbered V1, V2, and so on. Sm is ...

Add it to LD_LIBRARY_PATH as well. Don't know why, but sometimes having both LIBPATH and LD_LIBRARY_PATH set is necessary.

It may come as no surprise that you may need to re-boot Windows O/S in order for changes to environment variables to become effective. At the very least you will need to re-start DataStage services.

What happens if you make PriceX and PriceY larger, for example decimal[11,6]?

There are more grid environment variables you will need to set. The obvious one is APT_GRID_PARTITIONS (companion of APT_GRID_COMPUTENODES). For the Sequential File stage the pathname should be preceded by a reference to APT_GRID_SEQFILE_HOST or APT_GRID_SEQFILE_HOST2 (since sequential file I/O can ...

You need to specify, in the Trim() function, that you want to remove @FM characters (the default is to remove white space characters). The full form of the Trim() function has three arguments. You can get away with only two.

The parameter reference is clearly not being resolved. Work it out.

Are there perhaps additional spaces in the parameter name field?