difference between extpgm and extproc
could someone please let me know what is the difference between EXTPGM and EXTPROC. in which scenario extpgm is used and in which scnario extproc is used? what are the limitations of extpgm over extproc? if possible could u please let me know the difference with a sample program as an example. Thanks in advance

Answer Question   |  June 20, 2013  9:49 AM
AS400 RPGLE

Reg security audit of AS/400
Hi, Can any one give me the sample report structure for the As/400 securityaudit journal Entry for Type – JS, AP. This would give the basic idea of important field. I got the field attributes in QASYJS* , QASYAP* files. Thanks, Dev

Answer Question   |  June 19, 2013  3:50 PM
AS/400, AS/400 commands, AS/400 Fields

Capture and print electronic signatures
Has anyone used an electronic signature capture pad on the IBM i? If so, how do you print the signature later? A BLOB field is the perfect place to store the electronic signature which is typically a bitmap or JGEP file. That part appears to be easy. However, printing it is another matter. So far [...]

Answer Question   |  June 19, 2013  3:35 PM
AS/400 printing, IBM i

Any 5250/3270 Macro Commands to Reference?
I’m trying to run a macro within a macro from my text.mac file. I tried various syntax with no avail. Can someone help out? Also, if there is reference for all the Macro commands that would be really helpful too.

Answer Question   |  June 19, 2013  3:20 PM
iSeries AS/400, macro

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