Post #1
0 votes
Alex
Reputation8
Posts: 35
Joined: 06/15/2026, 09:20 AM
Posted: 08/03/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?
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?
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.
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