Post #1
0 votes
Alex
Reputation
8
Posts: 35
Joined: Jun 15, 2026, 9:20 AM
Posted: Aug 3, 2026, 12:18 PM
I know SQL from Postgres. Is DB2 on z/OS basically the same idea with different tooling?
What is a plan / package and why does COBOL care?
Thread: DB2
What is DB2 on the mainframe? Absolute basics
Started by Alex • user3 replies240 viewsLast activity 1 week ago
Post #2
1 votes
Elena
Reputation
391
Posts: 19
Joined: Apr 18, 2024, 9:30 AM
Posted: Aug 3, 2026, 2:18 PM
Tables, SQL, indexes - same idea. Tooling and operations differ a lot.
COBOL embeds SQL. Precompile/compile produces a DBRM. Bind turns that into a package/plan DB2 can run. If you skip the bind or bind wrong, you get -805 even when the SQL looks fine.
Post #3
0 votes
Sandra
Reputation
198
Posts: 17
Joined: Oct 15, 2024, 8:30 AM
Posted: Aug 4, 2026, 1:18 PM
Check SQLCODE after every statement. 0 = ok, 100 = no row, negative = problem. Memorize that early.
You must be signed in to reply to this thread