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!

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.

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

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( ?????? )

How to find all the objects authorization list assigned?

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?

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…

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

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

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

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?

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!

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

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…

Why does SQL+ stop after running so many characters in a long SQL statement?

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…

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

 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?

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

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…