|
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>
|
