RE: SQL newbie question / Exec SQL "SET"...

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/db2/rbafzmstsoption.htm#soption
>>-SET OPTION----+-ALWBLK = --alwblk-option---------+-+--------><
                 +-ALWCPYDTA = --alwcpydta-option---+
                 +-CLOSQLCSR = --closqlcsr-option---+
                 +-CNULRQD = --cnulrqd-option-------+
                 +-COMPILEOPT = --compile-option----+
                 +-COMMIT = --commit-option---------+
                 +-DATFMT = --datfmt-option---------+
                 +-DATSEP = --datsep-option---------+
                 +-DBGVIEW = --dbgview-option-------+
                 +-DECMPT = --decmpt-option---------+
                 +-DECRESULT = --decresult-option---+
                 +-DFTRDBCOL = --dftrdbcol-option---+
                 +-DLYPRP = --dlyprp-option---------+
                 +-DYNDFTCOL = --dyndftcol-option---+
                 +-DYNUSRPRF = --dynusrprf-option---+
                 +-EVENTF = --eventf-option---------+
                 +-LANGID = --langid-option---------+
                 +-NAMING = --naming-option---------+
                 +-OPTLOB = --optlob-option---------+
                 +-OUTPUT = --output-option---------+
                 +-RDBCNNMTH = --rdbcnnmth-option---+
                 +-SQLCA = --sqlca-option-----------+
                 +-SQLCURRULE = --sqlcurrule-option-+
                 +-SQLPATH = --sqlpath-option-------+
                 +-SRTSEQ = --srtseq-option---------+
                 +-TGTRLS = --tgtrls-option---------+
                 +-TIMFMT = --timfmt-option---------+
                 +-TIMSEP = --timsep-option---------+
                 '-USRPRF = --usrprf-option---------'

Don't you sometimes wish that the regular RPGLE compiler's hspec supported 
TLGRLS?

Rob Berendt