RE: References Clause on create table and library list

>cross library views (or logical files) as the devils spawn

I don't like them at all, but sometimes the files you need are in
multiple libraries. And in this case, it's actually all one library in
production, but several libraries in development. 

>If you don't do the RUNSQLSTM ... DFTRDBCOL(...) but instead do 
>CHGCURLIB to the library you are building the new table RUNSQLSTM will
that work? 

Yup, works fine. And actually the help text on the default collection
(DFTRDBCOL) parameter even says: 

"Specify the name of the collection identifier to be   
used INSTEAD OF THE NAMING CONVENTION specified on the
Precompiler options prompt (OPTION parameter)."

But who reads help text. <G>

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)