In a pinch, you could do something like this...
/* Format an SQL insert statement to add to the error log */
/* Note: Remember to terminate the SQL with a semicolon! */
CHGVAR VAR(&SQLSTMT) VALUE('GRANT xxx ...;')
/* Execute the SQL via the QSH DB2 Datalink manager */
CALL PGM(QZDFMDB2) PARM(&SQLSTMT)
-Eric DeLong
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of fbocch2595@xxxxxxx
Sent: Monday, January 21, 2013 1:27 PM
To: midrange-l@xxxxxxxxxxxx
Subject: sql GRANT from command line or in CL?
Hi Folks, as we incorporate sql into our code, is there any way the GRANT cmd can be run from a command line or via a CL pgm...do any 3rd party change management packages run the GRANT cmd as the pgm goes through the cycle from test to live?
Thanks, Frank
