Data Integrity
How to insure data integrity while transferring data from HP to AS/400?

Answer Question   |  June 19, 2013  7:34 PM
AS/400, Data backup, HP

How to get the maximum access path size value in a program?
Hi Friends, My requirement is to get the Maximum access Path size value in the program, I have the value as 1TB and 4GB in 2 different PF in different machine by DSPFD command. But I could not get the details when I OUTFILE using DSPFD, Even I tried RTVOBJD, RTVMBRD, I could not find it [...]

Answer Question   |  June 18, 2013  2:56 PM
AS/400, AS/400 commands, DSPFD

SETLL
Hi, I want to read a physical file sequentially. The physical file has no key. I use SETLL and READ. *LOVAL is not allowed when I use SETLL (because no key in the pf?) so I set a 1 in factor 1. 1 SETLL READ 90 *IN90 IFEQ *ON … Is this ok? When I [...]

Answer Question   |  June 18, 2013  12:28 PM
AS/400, Physical File, READE, SETLL

AS/400 RPGLE
How do I batch job end?

Answer Question   |  June 18, 2013  11:11 AM
AS/400, AS/400 commands, RPGLE

AS/400 to SAP change
I have 3+ years of exp in AS/400 development. I want to change my technology to SAP. 1) Which module should I go for? 2) How hard is to sustain if change? 3) Planning for SAP training? Module? 4) Do I need to be SAP certified? Need your answer as quick as possible. Thanks!

Answer Question   |  June 18, 2013  10:27 AM
AS/400, SAP, SAP Career

AS/400 RPGLE
How do I retrieve the system date in RPGLE? And is coding needed for me?

Answer Question   |  June 18, 2013  10:19 AM
AS/400, RPGLE

Journal Size in AS/400
Hi, I am looking for a command which can give the journal size (ie object type *JRN) in AS/400. Thanks!

Answer Question   |  June 18, 2013  10:04 AM
AS/400, AS/400 commands, AS/400 journaling

AS/400-Array
Hi, could someone tell me what are array related errors (most of problems are loaded file, etc,,,)?

Answer Question   |  June 18, 2013  7:24 AM
Array, AS/400

DB2 WebQuery for System i problem
Hi! Our server has already installed with DB2 web query. I have checked the basic things in licensed programs like QWEBQRC77(*lib) , MRADMIN(*usrprf)…everything is there. But when I try to start web query, the command is not available and also in license programs the web query shown like *INSTALLED(not *Compatible). We are using V6R1 version. [...]

Answer Question   |  June 18, 2013  6:42 AM
AS/400, AS/400 commands, DB2 Web Query

NULL value in physical file
I am a beginner in AS/400 and learning through some tutorials, I came with a problem of how to add a NULL value in physical file. The spaces can’t do the work, as even spaces have a ASCII value. Please respond with possible solutions.

Answer Question   |  June 18, 2013  5:27 AM
AS/400, ASCII, Physical File

FTP query definition to another AS/400 server
I have a QRY in one of the system. but, I don’t have this on other system where I wanted to populate the results using the QRY that runs on system1. Thought of FTP’ing QRYDFN to other AS/400…though we have QRY object in library on system1, while FTP’g says no such file found in library [...]

Answer Question   |  June 17, 2013  1:05 PM
*QRYDFN, AS/400, AS/400 FTP

OVRDBF example
I have been asked to prepare a small project in which we use a display file and and physical files. Now, I have to create a COBOL/400 program in which the user enters that name of the physical file and according to the name I have to enter empid and empname in that particular physical [...]

Answer Question   |  June 17, 2013  11:30 AM
AS/400, AS400 - COBOL, OVRDBF

Delete USRPRF in AS/400
Hi all! What are the condition or things should be notified or should be made when deleting a user profile from AS/400? Our application using the USERNAME in master. But i think only its saving the USERNAME in the MASTER PF. If I delete a user profile will it affect somewhere? How can I check [...]

Answer Question   |  June 17, 2013  7:31 AM
AS/400, AS/400 user profiles, USRPRF

Calculate Distance between cities using latitude and longitude
We currently have a program that returns a locations latitude and longitude. Searching the web I’ve located an RPG program that calculates the distance between 2 locations however it gives me the miles using a straight line. When I search Google maps it shows me the distance in miles using the shortest route but it [...]

Answer Question   |  June 17, 2013  10:01 PM
AS/400, RPG Program

Calling programs information in RPG
I have RPG program which consists around 7,000 lines. Is there any way to see the calling programs from the main program. One way is to manually searching the calling program name in main program. But it also taking so much time to know. So is there any way or command to get the all [...]

Answer Question   |  June 14, 2013  3:17 PM
AS/400, AS/400 commands, RPG Program

Converting a character to numeric
In WRKQRY environment, what is the function that can be used to convert a string or character to numeric? By Sulaiman “Sem” Salomon Bernat

Answer Question   |  June 14, 2013  3:06 PM
AS/400, AS/400 FUNCTIONS, WRKQRY

How can I make sure all new and changed objects are being backed up when using the SAVCHGOBJ command?
Our current backup procedures include a full system save once a week (SAT) and two daily save change object processes (M-F). Yesterday a new library added on Monday was deleted by accident. When trying to restore it from one of the daily tape backups which was done using the SAVCHGOBJ command it was discovered that [...]

Answer Question   |  June 14, 2013  2:39 PM
AS/400, AS/400 backup, SAVCHGOBJ

QMQRY!
How can we run multiple select/update query via a single QMQRY?

Answer Question   |  June 14, 2013  11:11 AM
AS/400, AS/400 Query, QMQRY

Why did the system crash?
Forgive me if this is hard to read but editor looks messed up again (tried using all 3 browsers). At a loss here. We had a user working remotely through a VPN last night. Around 19:00 last night they lost the connection running a query and did not try logging back on. At 19:17 I [...]

Answer Question   |  June 13, 2013  7:17 PM
AS/400, PTF

AS/400 backup
We built a new system with 3 LPARs with IBM i 7.1 . We setup the BRMS & using image catalog ,we created the virtual volume and scheduled the backups. Backups are performing perfect in virtual volumes also we can make a dupe tape using the physical media. My question is we have data of [...]

Answer Question   |  June 13, 2013  1:33 PM
AS/400 Administrator, AS/400 backup, AS/400 BRMS