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

Column heading issue with RUNQRY in CL
I have a CL program which has a RUNQRY. I have two input files and I have defined the result fields. I have given an expression and I have used column heading. The issue is after executing the query, if I do a RUNQRY on the outfile, I am not able to see the column [...]

Answer Question   |  April 3, 2013  10:54 AM
AS/400, CL Program

Batch job performence
Can anybody tell me how to reduce the running time of a Batch job?

Answer Question   |  April 3, 2013  6:19 AM
AS/400, AS/400 batch jobs

Key list in AS/400
 I have defined 3 keyfields in my logical file and I’m using them in my program as keylist parameters. Is it possible to perform chain operation using first and third keyfield? If not can you please tell me the other alternative?

Answer Question   |  April 3, 2013  5:50 AM
AS/400, AS/400 logical file

iSeries SQL Cobol
In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with “date” as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

Answer Question   |  April 2, 2013  6:59 PM
COBOL, iSeries, SQL statement