|
From: Jim I. <ji...@ho...> - 2004-04-08 20:51:21
|
Colin,
I use Squirrel every day to access AS/400 data. It works perfectly, except
for a few little issues.
(Occasionally, Copy & Paste doesn't work.)
To access multiple member AS/400 files, you must use CREATE ALIAS command to
create a file alias over that member.
Ex. Create Alias Library.NewFile For LIB.FILE (MBR)
Also you can call OS/400 commands directly from the Squirrel SQL edit
window.
Ex. CALL QSYS.QCMDEXC('WRKACTJOB SEQ(*CPUPCT) CPUPCTLMT(0.1)',
0000000037.00000)
Where 0000000037.00000 is a fixed decimal field with a length of 10 and 5
decimal places. The value 37 in the sample above must be the length of the
string (the number of characters including spaces between the single
quotes).
Jim
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.com/go/onm00200415ave/direct/01/
|
