Hi all. Here I’m using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here… Surey

Hi experts, Does Hibernate require AFTER and BOTH the Images of Journalling (Journalled files). Please let us know. Or After image alone is enough for Hibernate? AFTER or BOTH images is better to use for database? Thanks , Amutha

I want to list all the Job Schedule entries and save them in a Physical file , I used API QWCLSCDE to fetch that list in a User Space , then I did a QUSRTVUS to load the data in my COBOL program. As the variable Starting position and Length of data are Binary, and…

How to print the fields in bold letters in printer file? Can you give me a sample program?

Is there any way to prevent the message subfile to have the system generated messages? I have a monitor block in my program and the message tracked by the on-error block is appearing to the user through the message subfile, I dont want this to happen. Any suggestions?

Hi, I’m debugging an RPG program and came across a ‘KLIST ‘ with ‘KFLDS’. What I know so far is that a KLIST is used as a search argument and KFLDS make up the argument, but what I want to know is how does this actually work? Are the KFLDS concentrated to make up one…

I am running 5250 emulation on a PC.  It was running fine until today because now I receive an error remote address could not be resolved.

How do you print shading in RPG?

I got a request asking for reconfiguring the AP and an IP address is given in the request. I am not aware of what is AP and how to reconfigure it.

Is there a date format like this dd/mm/yyyy?

Like we select fields in STRSQL, is there a way I can specify the fields I want in OPNQRYF? Say I have 40 fields in my file, but I am interested in 10 fields and wanted to make a CSV out of it. Can I achieve this with OPNQRYF instead of creating another file with…

RPGLE object was changed and we can see it is DSPOBJD. We want to know who had changed the object? Thanks in advance.

When restoring SAVSECDTA (240 user profiles) on iSeries, 220 profiles restored and 20 authorization lists were restored. This obviously equals my total number of saved profiles but I don’t see the total number of profiles on the restored system. Any idea why this is happening?

I would like to have sample code on the OPCODE LIKEREC with all its parameters like with *All and *KEY and *INPUT and *OUTPUT. Also, I want to know whether OPCODE EVAL-CORR in iSeries or not  because when I want to transfer data from one DS (Data Structure) to another DS using EVAL-CORR, I’m getting…

I tried the command CVTRPGSRC to convert RPG source into RPGLE but getting run time error that says: “Format name in log file QRNCVTLG library QGPL not the same as format name of model. Conversion terminated.”

I want to show multiple messages on a DSPF, when user keys page down, I want it to appear one by one. I know we can do this, but now I don’t remember exactly. Please give a hint.

I have a display file with 25 fields. I want to know whether some value is changed when user hits enter. Since I have many fields in display file, taking each one and comparing with the file field is a difficult task. Any other suggestions?

Is there an easy way to get a full listing of the complete IFS? Guy

AS/400 question – 11 I have a service program that contains 3 modules. ADD, SUB, DIV. Now Say I have Modified the code one of the modules. One of the advantages of service programs that I have known is that whenever a module in a service program is modified, you dont have to compile all…

AS/400 question 10: In RPG 1 I have 6 parameters and in RPG2 I have 9 parameters being passed. I have RPG 3 which processes the request based on RPG1 and RPG2. if RPG 1 is called then 6 parameters will be received and the rest 7,8,9 should be initiated to Zeroes. If RPG 2…