DATAAREA
I have a variable that contains the name of a data area How can I access the data area? Without using CL

Answer Question   |  May 22, 2013  9:03 AM
AS 400, Data Area, RPGLE

More than 50 files in RPG?
How can i declare more than 50 files in RPG/400 program?

Answer Question   |  May 20, 2013  11:54 AM
AS 400, RPG, RPG Code

webservice and iDB2 connections slow on startup
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]

Answer Question   |  April 1, 2013  2:11 PM
AS 400, DB2 connectivity, i series, SQL Server

Alternative name of Physical file
How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

Answer Question   |  November 7, 2012  5:11 PM
AS 400, DB2/400, Physical File

TCP/IP Host Table Entries
When i enter TCP/IP Host Table Entries could see list of all server and their IP’s. my question is these are the systems connects to BRMS network or there any other relation so they appear here?

Answer Question   |  July 23, 2012  6:53 AM
AS 400, AS/400, AS/400 administration

How to prevent MSG ID CPI3420?
Hi, Im new to this blog so hi to everyone. This is my problem, I’m trying to generate performance reports, when I go to WRKSPLF and 5 to display them, in some of them I get the CPI3420 and I can’t see the text I need. I found out the way to display the overwritten [...]

Answer Question   |  July 16, 2012  8:55 PM
AS 400, AS400 printing issue, Spool files

2nd Pair of SSH Keys
I need to create second pair of SSH Keys for a User Profile ,Which has already working SSH Keys. If i normally do with SSH KEYGEN -T RSA ,i believe it will overwrite the existing environment and set new keys…Could You Please Advise me how to do this ?

Answer Question   |  July 10, 2012  6:37 AM
AS 400, iSeries, SFTP, SSH

ASP source connect to System i (AS400)
Hi.Now, I create ODBC of system i access software and config finishedBut, I can not get data form database on System i for showSouce code as below.(It connected to ODBC but can not get data for show)<%ConnectionString= “Driver={iSeries Access ODBC Driver}; System=10.230.1.32; UID=PCS; PWD=PCS;”set con = Server.CreateObject(“ADODB.Connection”)con.open(ConnectionString)Set rs = Server.CreateObject(“ADODB.Recordset”)on error resume nextset rs=server.CreateObject(“adodb.recordset”)sql=”select * [...]

Answer Question   |  July 6, 2012  8:09 AM
AS 400, ASP

Want retrieve job attributes for another job in CLLE
Hi My aim is very simple. I am writing CLLE program wherein I want to retrieve attributes for a job (here job name is fix, but not the job itself) I want to check whether this particular job is submitted previously irrespecive of status (MSGW, DLWT etc). If its sumitted previously I don’t need to [...]

Answer Question   |  July 3, 2012  5:16 AM
AS 400

How to find the If – Endif relationship
Hi it is very hard to find which END is related to which IF statement. I know we can find it during compilation by using ”Source listing indentation ” but for this we have to check the spool file. i wanna know is there any way to find it in source. I mean i have [...]

Answer Question   |  July 2, 2012  11:52 AM
AS 400, RPGLE

Identifier is ambiguous .
Hi I have a simple program that moves value ’a’ into a variable AB. the length of AB is 1. during debug I eval the value of AB.Instead of showing the value of AB it gives me the following notification : ”””” Identifier is ambiguous ””””. But when i am changing the variable name from [...]

Answer Question   |  July 2, 2012  11:02 AM
AS 400, RPGLE

need rpg code to add two values and dsp in the same screen in result field
THERE ARE TWO FILED CALLED “FILED A” and “FIELD B” IN DSP FILE IF I GIVEN VALUES FOR BOTH FIELDS   i.e,, FIELD A = 5 AND FIELD B =6 >>>>>>>>>  I NEED TO GET ANSWER “11” IN “RESULT” FIELD                                                 DSPFIL FILEDA            +           FIELDB              RESULT      5                                  6                        11         I [...]

Answer Question   |  June 25, 2012  6:48 AM
AS 400

Mainframe to AS 400
I belong to India & have around 5 years of experience in Mainframe. Now i am asked to shift to AS400. I am not able justify this change. Can anyone suggest whether this can have good future prospects?

Answer Question   |  May 21, 2012  11:07 AM
AS 400, Mainframe

Printek 4503 Configuration for I-Series
This printer is driving me nuts. Has anyone been able to config this to the I-Series. I tried 9100 direct and remote output queues and cannot get it to work.

Answer Question   |  March 17, 2012  3:16 PM
AS 400, Printer Configuration

Cursor
Hi, I have posted my SQLRPGLE program, output is not showing down,what mistake i did in my program,please correct it, FMA01F     IF   E           K DISK    FMA01FTES  IF A E    K DISK   RENAME(RMA01F:REMA01F) PREFIX(P_)   D COMNO           S              3  0        D SHPNO           S              5  0   D ITMNO           S             15A   D TOTAL           S              7  2    D COUNT           S              2  0       [...]

Answer Question   |  March 17, 2012  7:26 AM
AS 400, SQLRPGLE

How to identify whether the field values are in particular format
I have a file field of type 10A. I need to filter those values in that field which has 8 digits as numeric followed by 9th alpha character.  Example  78345687J or 12462446D   Which opcode I can use here to identify this format ? 

Answer Question   |  March 17, 2012  6:12 PM
AS 400, AS400 field values, RPG field format

Favorite printer in AS 400 environment
Just curious if anyone has a fav printer in the AS-400 world.  The HP4200 / 4250 has worked well for us and unfortunately can no longer buy new. Suggestions?  

Answer Question   |  February 28, 2012  3:55 PM
AS 400, AS/400 printers

Chinese as secondary laungage on iSeries
Hi, I need to setup Chinese (Lang caode – 2989) as secondary lang. on V6R1. I have parimary 2924 English installed on my box. So where else i need to configure to get Chinese login prompt/ main and all sub menus.   Best wishes. Chirag Sheth

Answer Question   |  March 17, 2012  10:14 AM
AS 400

taplib issue
In one system tapmlb01 device varied off and back on after an IPL. please help me WHY this needs to go offline/online for these systems when it doesn’t do the same on the rest

Answer Question   |  November 18, 2011  5:12 AM
AS 400

AS/400 Access Control
Some of the system commands are considered to be powerful like, {*USRPRF,*AUTHLR, CHGSYSLIBL, CHGSYSVAL, etc}. 1. Limiting capability does not restrict a user from executing a command. If so how can we restrict the user access to these commands? 2. Is there way to list all users with the access to these commands? Or does [...]

Answer Question   |  August 27, 2010  7:24 AM
Access control, AS 400, AS/400, AS/400 Access Paths, AS/400 administration