Wednesday, June 07, 2006

Handling SQL Error return codes - DSNTIAR

DSNTIAR is a subroutine used to convert an SQL return code into a text message. DSNTIAR takes data from the SQLCA, formats it into a message and places the result in the message output area, provided in the application program.

Syntax:
rc = DSNTIAR (&sqlca, &message, &lrecl)
&sqlca : An SQL communication Area
&message : An output area in VARCHAR format, in which DSNTIAR places the message text. The first halfword contains the length of the remaining area; its minimum value is 240
The output lines of text, each line being the length specified in &lrecl, are put in this area.

No comments: