
June 14th, 2006, 11:35 AM
|
|
Registered User
|
|
Join Date: Jun 2006
Posts: 3
Time spent in forums: 29 m 4 sec
Reputation Power: 0
|
|
|
SQLCA shared between bound procedures?
I'm just now delving into the depths of embedded SQL. One thing I'd like to do is to put SQL error handling into a service program module. Are the contents of the SQLCA unique for each procedure/module? (RPGLE specifically - RPG's SQL pre-compiler inserts all SQL data definitions.)
I.E. Main program has enbedded SQL. It is bound to a Service Program with a procedure that performs a GET DIAGNOSTICS. Since the GET DIAG returns values from SQL's data pool, will it see the data in the primary program, or return whatever is in the procedure's local area?
|