Embedded SQL in RPG ILE
I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time
I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time
65 pts.
Joining More Than 2 Files
What is the best way to join more than 2 files using SQLRPGLE with embedded sql?
What is the best way to join more than 2 files using SQLRPGLE with embedded sql?
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
Embedded SQL in a Cobol program using a sub-select in the select clause
The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = ...
The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = ...
