Thread: [Squirrel-sql-users] AS400 multiple member files
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Jim I. <ji...@ho...> - 2004-04-08 20:42:43
|
<html><div style='background-color:'><DIV class=RTE>Colin,</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>I use Squirrel every day to access AS/400 data. It works perfectly, except for a few little issues.</DIV> <DIV class=RTE>(Occasionally, Copy & Paste doesn't work.)</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>To access multiple member AS/400 files, you must use CREATE ALIAS command to create a file alias over that member. </DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Ex. <STRONG>Create Alias Library.NewFile For LIB.FILE (MBR)</STRONG></DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Also you can call OS/400 commands directly from the Squirrel SQL edit window.</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Ex. <STRONG>CALL QSYS.QCMDEXC('WRKACTJOB SEQ(*CPUPCT) CPUPCTLMT(0.1)', 0000000037.00000)</STRONG></DIV> <DIV class=RTE><FONT face=Arial></FONT> </DIV> <DIV class=RTE><FONT face=Arial>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).</FONT></DIV> <P><FONT face=Arial>Jim</FONT></P> <DIV class=RTE><BR></DIV> <DIV class=RTE> </DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2755??PS=">Is your PC infected? Get a FREE online computer virus scan from McAfee® Security.</a> </html> |
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/ |
From: Colin B. <col...@bi...> - 2004-04-18 11:30:40
|
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 |