• Guru: How To Use Global Variables In SQL Scripts

  January 23, 2017 Michael Sansoterra

  Hey, Mike:

  I’m writing SQL scripts to do some administrative work. These scripts are run in iNavigator’s RunSQL scripts utility and use the special CL: directive to execute an IBM i command. I stumbled across the CREATE VARIABLE statement and wondered if I could use an SQL variable to substitute a library name within the OS commands.

  For example, if I define something like the following in iNavigator:

  CREATE OR REPLACE VARIABLE QGPL/LIB CHAR(10) DEFAULT 'JOE';
  

  Can I then use the LIB variable in a CL: command as follows?

  CL:  DSPLIB LIB(LIB) OUTPUT(*PRINT);
  

  –Guru Reader

   

  Unfortunately, GLOBAL VARIABLES cannot …

  Read more

• Handling Constraints Revisited

  March 31, 2015 Paul Tuohy

  I recently had an email from Doug, who was making use of some code I had published way back in February 2010 in my article Handling Constraint Violations in RPG. The article discussed how to trap a constraint violation caused by a WRITE/UPDATE/DELETE operation and, more importantly, how to determine the name of the constraint that caused the violation. Doug had come up with an instance where my code was not working! After going through the usual stages of denial, anger, and some expensive therapy, I read the rest of the email. Doug’s code worked fine with an RPG

  …

  Read more

Next Articles