General scenario:
* I have two as400 i5 systems with identical data library structure and physical files.
* Development system has new logical files against the physical files.
* Produ...
Hello
At the moment in DOS prompt I am manually entering the following to copy a script from an AS400 server to another location on a windows 2003 server: Is it possible to automate this pr...
We have an IBM System I with i5/OS V5R4. We would like to do a file reorganization on the 100 largest files each month. The problem I am having is trying to get the file information (fi...
We are trying to connect UPS' Worldship (Version 10) to a database on an ISeries that contains all the relevant shipping informmation via an ODBC connection. The connection works fine except f...
I want to change the printer font on AS400 printouts. The OVRPRTF command has a FONT parameter. Many values are shown in the drop-down. Where do I find out the type of font? And will this w...
I have created a .Net (VB) application that uses the cwbx.dll from the iSeries suite in order to connect and make program/command calls against an AS400 machine. I have to redistribute this a...
Hi,
We have an initiative to secure all telnet connections. Most all systems / serves are done. However we have a list of IP addresses that cannot be converted to SSL by our deadline. So my...
I have a PRTF file that we used to use on an IPDS printer that looked like this:
-----------------------------------------------------------------------------------------------------
0015.00...
Hello,
I need to display an Error Message in Display file but not using a display field's Error Indicator Option or Message files.
For Example: "File is updated" or "You are not authoriz...
On iSeries Access for Windows version 8, I am accessing an AS400.
I am trying to record a Macro using the "Record" function that will copy certain text. I can press "control + v" during re...
I would like to know how to convert an numeric field to a character fiels using AS400 Query on an i5 OS
Hi all,
We have an IBM iSeries machine model 520, with 6 G Ram and a total of 480 G Hard drives memory. We plan to implement JDE on this machine. What are the requirement for JDE to run acc...
Hi all,
I've got a problem on our company AS/400
We're using the 570 with OS version V5R3
The users are getting into the system through iSeries emulator(Telnet) and some web interface p...
I had a previous question:
I need to use iSeries Access Data Transfer to dowload records from a file. The file has an 8 digit dec field(FLDA) used to store a date in YYYYMMDD format. I nee...
On booting up my laptop, Zone Alarm Security Suite won't initialize. Mousing over the ZA tray icon reveals Protection Is Up, UI is initializing, but nothing ocurs. The computer is, however, si...
Hi,
We have a web application on Websphere 6.1 (running on a RedHat server), we wish to process the logon to the server initially using LDAP against an iSeries account, then once authentica...
I am trying to extract the past 6 months of data from a DB2 File.
The date is a converted string
(Date (Digits(UTRDMM||'/'||Digits(UTRDDD)||'/'||Digits( UTRDYY))
My statement so far looks ...
How to load new PTF's in Mapics XA 6.0, AS400 V5R1M0?
As I said I need to install new PTF's in Mapics XA Rel: 6.0 and AS/400 V5R1M0. I have no idea I am new.
The ERP Mapics is running on ...
is there a routine or command to clear output queue by date?
Is there an SQL function in AS400/iSeries that returns the TOP (like in MSAccess) 10 records of some rank?
I don't know any way except to MAX and then ORDER BY descending.
Dear Experts,
What is the best way to avoid users running update command in DB2/400?
In the other side we dont want to make any conflict with the applications that run in AS/400.
Thanks
Since yesterday we have installed a new version of OpenDGS, a third party application that connects to the iSeries on a frequentl basis. The older version only made one connection a day, and t...
What is the line command to vary on an AS400 device?
I'm trying to connect to a web service using the iSeries Web Service Client for ILE. I created the C stubs and was provided a self-signed SSL certificate for access to the remote web service....
1) The below Command When called from AS/400 MainMenu Command line succesfully overrides the message file.
Where as when i call the CL program written below to perform the following action, ...
