I have an iSeries RPG program that writes a report using a printer file that has a dozen different record formats. I need a way to repeat the printing of each page, without having to read thr...
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 ...
I have an AS400 system that will automatically disable user accounts that havent logged in for a certain amount of time. This causes obvious issues as you can imagine. I would like to know whe...
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...
Hi there, i have just copied our live data to the test environment and as part of the process, and renamed the libraries as necessary during the restore. I have been told to delete the logica...
Hi,
We have an application which is based on the OS/400 platform. The GUI code is in J2EE. We are using the DB2400 database that comes along with the OS.
To meet industry compliance, we ...
I am running an AS400 with V5R4 OS. When I enter the command STRTCPSVR SERVER(*FTP), I get this error message in the job log:
40 08/25/09 08:15:21.607792 QTMFSRVR QTCP *STMT ...
What is the function used to subtract two date data types in RPG Free format?
Hi Experts,
I have an SQL command that creates extra characters to the result file when I use fixed data.
e.g. Select ' ', Field01, ' ' from etc.
the both ' ' in this select are stored ...
This question has been raised before but never answered. We're looking for a way to remove Client Access from 200 workstations SILENTLY. I have searched in Redbooks here: http://www.redbooks.i...
I've replaced the DASD from a model 820 AS400 and want to restore from fullsysbk. I switched the panel to 02 D in manual mode. But the external tape drive is not booting.
How can I load ...
The problem is that the target field on AS400 DB2 is a text field with some portion consisting of packed decimal data. I can use AS400PackedDecimal from the AS400 toolkit to pack the fields i...
Hi,
We have published a java (web) based application on our i-series running on Apache, it is secured by two lots of Firewalls with http application filtering. I have a few of cencerns; 1. ...
When I run a store proc with a case statement it returns the result as EBCIDIC. When I run the same statement in iSeries Navigator the case statement returns the correct characters, not EBCIDI...
Dear All,
What is the procedure to take up the certification in
IBM Certified Specialist - AS/400 RPG IV Programmer.
Can any one provide me the url to view the sample Question and
what i...
Situation: I'm a consultant asked to help out with a clients SBS server and basic needs they ask for on a monthly basis. The company also has a as400 server that someone remotes in to work ...
I am using STRTCPIPS command and keep getting this error whether I do the command from the command line or in a clp:
Message ID . . . . . . : CPD0078 ...
Hi,
I am struggling with something that I believe should be quite simple.
I would like to convert the current date to a serial date in a query to compare with a serialized date and exclude r...
Hi,
I have an iSeries that runs a bespoke ERP application and every couple of days I get a function in wrkactjob
IDX-FNCSECPF - Its always related to a user and stops anyone else from op...
hi all,
I'm trying to run a query from VBA, which I will be moving to VB6 once it's installed on my work PC. basically I need to get some records between 2 dates.
the code works as far a...
I would like to write a CL to auto-delete any files in an IFS directory that are older than 5 days old. Has anyone done something like this before?
I figured I would ask to see if anyone ha...
what is the functionalty of the following keyword
cursym,datedit,decedit,dftname,expropts
please give code in example to explain
what is the functionalty of the following keyword
block,commit,extind,extfile,indds
please give code in example to explain
In need help establishing a connection to AS400 in an ASP page. Here's where I am so far...
<%@ LANGUAGE=VBSCRIPT %>
<%
dim conn
Set conn = Server.CreateObject("ADODB.Connection")
...
I'm looking for a CL program to give me the job# of an active job on my ISeries. I have two jobs that have the same name that I want to end but I need to know the job number to do this without...
