Re: what is the sql way to list the libraries/schemas on the system?

Should work. Keep in mind though that if the schema has no tables defined
in it you won't see it in that list. For example
CRTLIB ROB42

select char(table_schema,10) libname, count(*) objc
from qsys2/systables
where substr(table_schema,1,3) ='ROB'
group by table_schema
ORDER BY TABLE_SCHEMA

LIBNAME OBJCX
ROB 108
ROBG 19
ROBGBUD 33
ROBGBUDLX 38
ROBGC 3
ROBGHLD 4
ROBGLXQ 1,070
ROBG0706 146
ROBG13 42
ROBG23 6
ROBG26 95
ROBG33 4
ROBG36 75
ROBG52 8
ROBG70 3,307

CRTPF FILE(ROB42/STEVE) RCDLEN(10)

select char(table_schema,10) libname, count(*) objcx
from qsys2/systables
where substr(table_schema,1,3) ='ROB'
group by table_schema
ORDER BY TABLE_SCHEMA
gets same list, no ROB42 still.

CREATE TABLE ROB42/DUH (MYCHAR CHAR (10 ) NOT NULL WITH DEFAULT)
Now when I run the sql, it appears

And when I create a DDS file the number of tables is bigger
CRTPF FILE(ROB42/HOURSSUM) SRCFILE(ROB/QDDSSRC)

Apparently DDS physical files are in this view. SQL tables are in this
view. Tables created with no dds and no sql are not.



Rob Berendt