Error Code Handling

cosec · Post by **cosec** » Mon May 14, 2007 2:01 am

hi,

I am trying to have all my error codes and error messages organized in a file...

Are there any particular functions to get the error code and error message ?

I tried the available DS MAcros but didn't get what I was expecting...

Would appreciate if some one could point me in the right direction

chulett · Post by **chulett** » Mon May 14, 2007 6:34 am

You need to do a better job of explaining what you are trying to do and what you are expecting. Examples are always good.

ray.wurlod · Post by **ray.wurlod** » Mon May 14, 2007 4:20 pm

Many of the error codes can be resolved via a lookup on the SYS.MESSAGE hashed file. However you need a six digit key.

Code: Select all

 Fmt(ErrorCode, "R%6")

Apart from that most of the others are not retrievable using software. Some are documented in header files, but searching these has to be by token, and you don't have the tokens in the error message itself.

Other error codes, external to DataStage (such as SQL State for ODBC and database error codes) need to be resolved by other means.