MVSFORUMS.com

[pzmohanty]

hi all,

to check the status of previosly executed sql statement we use SQLCODE in our COBOL code & check whether SQLCODE is equal to zero , greater than zero or less than zero & accordingly interpret the status of previously executed SQL statement.

In the same vien how should we use SQLSTATE in our COBOL program .

a sample COBOL code using SQLSTATE will be of immense help.

Thanx in advance

[kolusu]

pzmohanty,

An SQLSTATE variable declared as PICTURE X(5) .

You can simply code