Does RUNSQL support a simple select? When I run this:
runsql 'SELECT SYSTEM_TABLE_SCHEMA, count(*)
FROM syscolumns WHERE system_table_schema=''ERPLXF''
GROUP BY SYSTEM_TABLE_SCHEMA'

I get nothing. Nothing returns to my screen. No joblog information.
Nothing.
Command Entry
CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES)
runsql 'SELECT SYSTEM_TABLE_SCHEMA, count(*)
FROM syscolumns WHERE system_table_schema=''ERPLXF''
GROUP BY SYSTEM_TABLE_SCHEMA'

But this works fine
runsql 'CREATE TABLE ROB/NATHANs (WTF CHAR (5 ) NOT NULL WITH DEFAULT)'
Ownership of object NATHANS in ROB type *FILE changed.

Guess not:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Fsqlp%2Frbafyrunsql.htm

What a major disappointment. In the stuff that uses wrap arounds for
STRQMQRY you can use a simple select. But when I tried to write a
imbedded sql in RPG type solution I think I had the same limitation that a
simple select (without an into or some such thing) wouldn't work. IBM
probably ran into the same thing. I guess there's still situations for
the renamed command I use to run an sql statement.



Rob Berendt




Return to Archive home page | Return to MIDRANGE.COM home page