Retrieving error description for SQL Server

[prabaharan]

In our Job i need error message to capture error message for future reference. i can acquire error code from link variables but not the error message.

Is there any provision in DS to get SQL error message.

Note: I couldn't find any such info in DSGetLinkInfo.

Thanx in advance.

[ray.wurlod]

The link variable LASTERR returns the error text.

Beware that, with all Microsoft databases, it tends to be verbose so, if you're wanting to capture it into a table, make sure the column's a wide one!

[ailuro]

DSr7.5 Developer's Help says:

The output link variable, Linkname.LASTERR, contains the last error code on Linkname.

DSGetLinkInfo where InfoType=DSJ.LINKLASTERR
returns the last error message (if any) reported from the link in question.

HTH

[prabaharan]

Thanx for ur suggestion.
I tried with LASTERR , but i am getting full logfile message.
My requirement is only capture the error message (ex. constraint violation or datatype mismatch etc...)

[garkus]

I encountered the same issue with both the odbc and drs stages, reported it and am told that this will be addressed in the mid november release of datastage.

Thanx for ur suggestion.
I tried with LASTERR , but i am getting full logfile message.
My requirement is only capture the error message (ex. constraint violation or datatype mismatch etc...)

[ray.wurlod]

LASTERR is "the error text returned by the driver or database server".
Blame Bill Gates.

[chaitanyap]

We can catch the last error message by using this

DSGetStageInfo (DSJ.ME, DSJ.ME, DSJ.STAGELASTERR)