Thread: DB2

What is SQLCODE and why do people check it after every SQL?

Started by Sam • user3 replies221 viewsLast activity 2 months ago

Post #1

1 votes

Sam

Reputation5

Posts: 28

Joined: 07/01/2026, 02:30 PM

Posted: 07/27/2026, 01:37 PM

COBOL DB2 examples always say IF SQLCODE = 0 ... What are the common values I should memorize first?

Post #2

0 votes

Sandra

Reputation198

Posts: 17

Joined: 10/15/2024, 08:30 AM

Posted: 07/27/2026, 03:37 PM

0 = ok
+100 = no row found (not always an error)
negative = real problem (-803 duplicate, -911 deadlock/timeout, -305 null, etc)

Always check it. Ignoring SQLCODE is how you process garbage and smile.

Post #3

0 votes

Omar

Reputation155

Posts: 12

Joined: 01/07/2025, 10:05 AM

Posted: 07/27/2026, 07:37 PM

DISPLAY SQLCODE in test when something feels wrong. Cheap debugging.

You must be signed in to reply to this thread

What is SQLCODE and why do people check it after every SQL? | MainframeMaster Forum