Re: [Squirrel-sql-users] AS400 multiple member files

[Colin B. <col...@bi...>]

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