Batch job performance
I have a Batch job that’s running for 4 hours. I want to reduce the executing time to 2 hours. What should I do?

Answer Question   |  April 10, 2013  6:39 AM
AS/400, AS/400 batch jobs

SQLRPGLE program executing at log off
I wrote a simple SQLRPGLE program. It accepts a “from” and “to” code, deletes all records with the “to” code, then copies all “from” records, replacing the “from” code with the “to” code. It runs fine, produces expected results. When I log off the session which ran the program, even hours later, it seems to [...]

Answer Question   |  April 9, 2013  4:31 PM
AS/400, SQLRPGLE

Create source from a file object
I have an utility which displays the file fields and keys. Now I want to add an option in that utility to create the source of that object. Can anyone help me to figure out the command which will create the source of an object? My intention is when I take F9 from that tool, [...]

Answer Question   |  April 9, 2013  5:23 AM
AS/400, AS/400 objects, STRSEU

Control Indicators
What are control break logic indicators?..How they work?

Answer Question   |  April 8, 2013  6:59 PM
AS/400, RPG

Different queues
Can any one clarify me the differences between message queue, out queue, spool files and printer files? If possible with an example. Thanks in advance.

Answer Question   |  April 8, 2013  4:27 PM
AS/400, AS/400 queue

How the Lansa program objects with older version can be migrated to higher vesrsion
Hi, How to migrate Lansa objects with older OS/400 version to the higher V6 R1 version. Any idea, easy approach, suggestion or any command? Thanks!

Answer Question   |  April 8, 2013  11:43 AM
AS/400, LANSA

Authority on a user profile
I have a screen where I have a field to input a User ID, I need to validate that the user who is entering the user profile (of some other user) is authorized to the user profile or not.

Answer Question   |  April 5, 2013  7:36 AM
AS/400, AS/400 user profiles

Authority on a JOBQ
How can I check that a particular user is authorized to a JOBQ or not?

Answer Question   |  April 5, 2013  7:33 AM
AS/400, AS/400 commands

Array size
Hi, I have used array to store ItemNUmbers, D Arry S 15A DIM(9999) But I am getting error as Array index is out of range… I knew that file has more item numbers. I need nearly 70000000 So please tell me the maximum size of array…. Ans : DIM( ?????? )

Answer Question   |  April 5, 2013  7:13 AM
AS/400, AS/400 Arrays

How to find all the object authorization list assigned
How to find all the objects authorization list assigned?

Answer Question   |  April 5, 2013  5:54 AM
AS/400, AS/400 administration

Merging columns from 2 different files
I want to merg data from 2 different files.  1 column in both files has same type of data but the headers (Library and Libraries) are different and the fieldnames (ODLBNM & MLLIB).  Is there a way to merge both columns into 1 column?

Answer Question   |  April 5, 2013  10:17 PM
AS/400, as/400 files

Client Access
I cannot get a signon screen thru Client Access…… Current setup…… TCP/IP iSeries is 192.168.1.2 Router address is 66.102.238.245 Router gateway is 66.102.238.246 Primary DNS 74.40.74.41 Secondary DNS 74.40.74.40 (Actually these are different from actual but stated for example purposes) To configure Router and set up port forwarding is 192.168.1.1 In a DOS prompt I [...]

Answer Question   |  April 5, 2013  9:23 PM
Client Access, Client Access 5.4

RPGILE To RPG IV conversion
How RPG/400 code can be converted to RPG IV code with a single command?

Answer Question   |  April 4, 2013  3:50 PM
AS/400, RPG

Dynamic array
I want to declare the number of elements of an array dynamically in RPGLE. How to do it? Please reply.

Answer Question   |  April 4, 2013  3:29 PM
AS/400, AS/400 Arrays

DBCS
What is DBCS(Double byte Character Set)?..what purpose we use it?

Answer Question   |  April 4, 2013  2:46 PM
AS/400, RPG

Spool file info
I need to capture spool file information from a job within that job. I can get most of the info from using RTVJOBA but how do I get the file number?

Answer Question   |  April 4, 2013  1:58 PM
iSeries, Spool file

Problem while using SSCANF funtion in RPGLE!
Hi, I am trying to check whether a string is numeric or not so for that I’m using SSCANF but every time its giving me return a 0 . Not sure what I’m doing wrong! Below is my code: I am always getting i=0 ideally it should be 1234 … Please suggest!

Answer Question   |  April 4, 2013  10:06 PM
AS/400, RPGLE

How to read MS SQL tables using iSeries RPG
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

Answer Question   |  April 4, 2013  9:27 PM
iSeries, RPG Program, SQL 2008

Pointer not set for location referenced
I have a service PGM with 2 modules that are similar in functionality. One works and the other gives me the error in the title. Both load array data structures that are define using likeds. The problem I’m having is when I try and load the first array element. When I dump the PGM, it [...]

Answer Question   |  April 3, 2013  3:14 PM
PGM, RPGLE, RPGLE array

SQL Plus stops before finishing
Why does SQL+ stop after running so many characters in a long SQL statement?

Answer Question   |  April 3, 2013  12:23 PM
SQL Plus, SQL statement