|
From: Jim I. <ji...@ho...> - 2004-04-19 17:39:52
|
Colin,
I use Squirrel SQL daily to access large AS/400 databases. Squirrel
performs excellently even on very large, complex SQL statements. I've
joined up to 13 files in one statement.
In DB2/400, the way to access different members of the same file is with the
CREATE ALIAS sql command. The sql syntax is; CREATE ALIAS LIBRARY.NEWFILE
For LIBRARY.FILE (MEMBER)
Or you could issue the OS/400 OVRDBF command via SQL editor to force JDBC
connection to use the member you wish to select. The OS/400 syntax is; CALL
QSYS/QCMDEXC('OVRDBF FILE(NEWFILE) TOFILE(LIBRARY/FILE)
MBR(MEMBER)',0000000053.00000) Where 0000000053.00000 is a 15.5 decimal
value greater or equal to length of the entire OS/400 command. (Executing
OS/400 commands directly from SQL editor is great. This should be a
plugin!!!)
Jim
_________________________________________________________________
Watch LIVE baseball games on your computer with MLB.TV, included with MSN
Premium!
http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/
|
