SQLCOD values

[instrucrat1]

Hi,
Is it the case that any SQLCODE other than 0 to 100 (inclusive of 0 and 100) range is exception in SQL statement execution?
Only 0 to 100 are either warning or successful operation SQLCODE value?


Thanks

[B.Hauser]

Re: SQLCOD values

Hi,

SQLCODE between 01 and 99 are warnings
SQLCODE 100 means not found
SQLCODE < *Zeros means error.

Birgitta

[gcraill]

Re: SQLCOD values

Check this thread

Jamie lists a nice PDF with codes explained, and LittlePD links to an IBM site to search for SQL codes.

For further examples look at Kit's avatar ....

[kitvb1]

Re: SQLCOD values

and it's a sticky at the top of this forum

[instrucrat1]

Re: SQLCOD values

Hey guys
All people over here are really helpful and having very good knowledge. Thanks so much before 5-6 years I used embedded so was having confusion. So as per 100 + SQLCOD are also considered as fatel errors. Please correct me if am wrong.

Thanks again.