DSXchange

I have got to be dumb. Not really much help from the search on this

Where can i find documentation on the Constants in Link Variables, the Constants like DSE.NO.MORE.DATA, DSE.INVALIDARG, DSE.INVKEYBASE etc??

Any help is appreciated.

Thanks in advance

I didn't know that these were either documented or listed anywhere, they are part of the GCI. Where did you find references to these mnemonic codes?

They are all (almost all) documented, but only indirectly. For each of the DataStage API functions there is a list of possible returned values, which is where these constants are mentioned.

You can obtain their decoded values from JOBCONTROL.H but, since they are almost all integers, this does not aid your understanding that much.

They are intended to be used as arguments to, or result values from, DS Functions that you may have used in expressions.

I found a mention of all these constants in the DSD_CONST.H header file in the dsinclude directory of the project. Dont know what use they would be to use in a transformer stage derivation, as they are available in the Link Variables- Constants section
in the expression editor menu
was also wondering if any function can return a value equal to DSE.NO.MORE.DATA if the transformer stage received zero rows in its input

Anyway thanks for your help

There's no exposed function that can return DSE.NO.MORE.DATA. It's only used in "internal" functions as far as I am aware.