On Thu, Apr 08, 2004 at 04:51:15PM -0400, Jim It wrote:
> 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
>
> _________________________________________________________________
Hi Jim,
Thanks for letting me about this, I'll add some entries to the
FAQ for the AS/400.
--
Colin Bell
http://squirrel-sql.sf.net
|
