We are using Trusted Link on the iSeries. Is there a way to do loops within a segment? We are creating an 834 transaction set and have two different segments that need to be populated. So ther...
I am trying to setup up some MS Excel Files which will import data from an AS400 using the following methods but i am getting mixed results.
In Excel i am using the menu "Data / Import Exter...
Background: I was trying to end tcp on our test AS400 so I could add a new SMTP email table entry.
I couldn't log into QCTL side on the Console Manager on the PC Console because someone had ...
Title really says it all. I'm interested in setting up SNMP on our 400. What all can I monitor with IBMs builtin SNMP? I am pretty new to the 400 so please keep that in mind. Also if anyon...
When doing a "wrksyssts" from my CL, my % system ASP used is approx 90%. There is a command I can run from the CL that will list all files and allow me to sort by largest file first. Does an...
I have a SQL stored procedure that is created without errors when I run the RUNSQLSTM command. Within this procedure I write to an output file (I have an almost exact SQL Procedure that I got...
Hi,
How do i split of a spooled file that was generated into many spools especially by the content of the reports if it possible as i do not want to rewrite the whole RPG programme ?
Hi,
I have configured SMTP on my AS/400 machine to send out emails and have been successful. However when i send out the emails with or without attachments using the SNDDST command the the ...
I am having trouble reading some data from a data file and writing it out to another file using SQL/400. I am getting the following error message when I "RUNSQLSTM"
SQL0117 30 1 Statemen...
i have followed several steps on varies webpages about overlays on the as400. However the overlay is not printing out. i have no idea what i am missing.
I have a spool file and when i look ...
I need to run RUNRMTCMD to execute a .bat file. In order for the server to receive the command, the service CWBRXD needs to be running on the receiving server. I don't want to load the full I...
Hi,
I would like the screen to take the transaction date as system date by default.
Please provide me with the sample code.
Thank you,
Praveen.
Does anyone know of any good online free tutorials for VERY BASIC rpg and or CL programming for the AS/400?
Much appreciated...
-AB
I am attempting to modify what I believe is an old S/36 procedure because some filename changes by a software vendor have rendered them useless. I have very little experience programming on an...
I am VERY new to this platform and just doing my best to do some documentation of the different profiles on the system.
The list of accounts below currently have *allobj special authority. ...
Hi,
I need to set passwords to expired on all users every 90 days. Is there a method to do this via command? Or is there a program which can be developed easily to have this occur?
Than...
I need to do an update to concatenate 3 files
Example
Fileld 1 Field 2 Field 3
11000 7890 25634
Desired update of fileld in file in the following format
1...
Hi
I'm trying to migrate the files/folders/shares from QDLS to IFS. I need to know if there is a command to do that. Can anyone explain step by step how to do that.
Thank you
When trying to send spooled files from one box runing V5R3 to another using V5R1, I get error msg cannot connect to remote system 128.200.0.1. Even though it works the other way around. Is snd...
Hi,
I am using Mapics XA on AS400, the AS400 Session does not expire.
Session usually logoff in 10 minutes if not used by the Users. But now it is not.
Is it possible to perform AS/400 backup to disk (B2D) and/or restore from disk backups. Are there any solutions out there free or commercial. I would like to at least try to backup-to-disk as ...
Hi,
I have a zebra barcode printer and a iseries 515 v5r4. There is a customers file and is neccessary to print a label with a barcode. This barcode must have customer name and it postal co...
We are using FTP to transmit files. I've been asked to set up the FTP process to now use a certificate to secure the process. I have no idea where to begin and the IBM website is somewhat conf...
Can anyone come up with a way to (after adding a clickable button to the toolbar in Client Access) so when you click the button, a row/column screen position is read and a parm passed to a pro...
Hi,
I am trying to compile this RPG program but it keeps hitting error as below and it say that it cannot be complied because the binding directory . TQ
SBMJOB CMD(CRTBNDRPG PGM(MYLIB/F...
