Error codes

[Liam1]

Hello all,

I am trying to capture the error code returned by Teradata.

We are on a V2R5.0 box, and do not seem to have an ErrorLog table within DBC.

I would like to be able to capture this error code and put it into a table, or even pass it back to a VBA script.

I have managed to use the .If ErrorCode command, but this is only used for very simple code decisioning.

Thanks,

Liam1

 

[dnoeth]

What do you mean by ErrorLog?
The dbc.ErrorMsgs table contains errortexts for each errorcode.

Which tool are you using?
.IF ERRORCODE looks like BTEQ.
You can't use BTEQ's ErrorCode in an Insert, you just can stop the BTEQ script by submitting

.IF ERRORCODE <> 0 THEN .QUIT ERRORCODE

Dieter

 

[Liam1]

Basically we use (as and e.g.)
.IF Errorcode = 1 then goto Label1 in BTEQ.
If this value cannot actually be put into a table fair enough (

BUT
QueryMan is able to bring back the actual Teradata Errorcode, as opposed to an ODBC errorcode - is there a way I can trap this in VBA and use this for IF Statements?
I don't think TD would be too pleaseme trying to crack into the QueryMan code!

Thanks