We have an iSeries 810 with 175 GB of system storage, 85% used. We IPL weekly. The IPL typically takes about 15-20 minutes. We perform an entire system save monthly, which takes about 5 hou...
Prior to V5R3 upgrade i used the command below to copy the results of a series of SQL INSERT statements into a file on the shared folder:
CPYTOIMPF FROMFILE(PLUEXTRACT/PT_NORM_DN) TOSTMF('/...
I'm trying to connect to an as400 via jdbc, I have no problems connecting via odbc and have been doing that for six months, but the odbc queries and execution is taking a long time so I am loo...
Is there an easy command or utility to copy files from a library on one AS400 server to a library on another AS400 server? I have two networked servers that I need to copy some *CMD and *PGM ...
Hello,
I am writing a code in vb.net which allow to use API directly from on asp.net site.
I am able to user QUSLJOB API already. I would like to use QUSRJOBI (http://as400bks.rochester....
I have one printer file (RLU) in which i want to print multiple colours based on the values / description.
is it possible.
when i am trying to assign the keyword "COLOR" system is giving ...
Hi all
When I log on a terminal server with the sane user ID of AS/400 user (but whit different passwords) I cannot access to shared folders but If I try to access to shared folders directly ...
We have several applications that need to send printouts to customers via fax and email. The best format to send to them is to convert the document to PDF and then send. This in not an issue. ...
i have a cl program that once retrieved a number from a data area, *dec 7 0. Now the CL needs to pull that number from a different data area of type *char 7 . How do I get the new char data ...
Hello,
I am looking to ftp a CSV file I created and overlay each week from the IFS (where it is sitting now) to a PC running an ftp server. I have looked around for help to no avail lol so...
we recently upgraded our 720 from V5R1 to V5R3 but there were problems with the upgrade and we had to do a scratch install. Since installing V5R3 its performance is abissmal. A job I run on ...
I have a xml to DB mapping app. (made with Altova Mapforce) which I use to create records in a DB2 table from xml files.
When I run the app. in command prompt on my Windows server, I get th...
I am not very knowledgable about AS400s, but we are running Client Access V5R2 and are connecting to an AS400 running 5.3. We have been having a problem with users losing their sessions interm...
Is there a way to restrict ODBC access to read only on AS400, I have a few users who use Access link tables to AS400 files. I don't want them to be able to update data via Access, I know I can...
I have Motorola MC9090 (PDA) using Wavelink telnet. I connect to AS/400 with default settings. When I push function keys on the PDA the telnet client doesn't work as on a PC. It displays a kin...
How do I call a program on the AS/400 from Visual Basic?
I've tried the following:
In the Declarations section of a Form:
Dim cnnAS400 As New ADODB.Connection 'Done at Prog...
Hi All:
I am using JDBC to connect to DB2/400 to call a Stored Procedure. Here is my AS400 code that works fine with no problems.
CREATE PROCEDURE IJLIB/WEE1520IJ
(IN giftc# CHAR (19...
These days with iSeries bach machines (0 interactive), and even developing RPG code but without green screen (i.e. doing html screens) would be nice found any Windows PC Editor program able to...
Hi,
I m a vb6 programmer. I have started a new job where they have main software running on AS400 and I have no previous knowledge of AS400. After trying I have been able to access the AS400 ...
os/400 ibm iseries server to tack user changes on pf
Option 1:
CALL QCMDEXC('SBMJOB CMD(CALL PGM(T_SESLIBWL/CNSHPPUC)) JOB(PROCNEWEDI) JOBQ(QB
ATCH4) MSGQ(*NONE) INLLIBL(T_SESLIBWL)' 0000000103.00000) ;
Option 2:
CALL PGM(QCMDEXC) PARM('...
I have a bunch of output queues in the system that are not used and just clutter up the view when I go into 'WRKOUTQ' and so I would like to delete them. When I go into 'DLTOUTQ' I enter all ...
What is the name of the font on the AS400? I need to use it in Windows so Im trying to find the equivalent.
Thanks.
using AS400 iSeries V5R4 is this "kind-of-thing" possible?
Declare DynamicSQLstatement varchar(1000);
SET DynamicSQLstatement = 'SELECT count(*) FROM '
SET DynamicSQLstatement = DynamicSQ...
I was wondering if there was a way that I could obtain the disk usage of my iSeries servers via some kind of script. We have over 50 servers and I do not want to have to log into each one of t...
