AS/400 Development

Member Level ID

Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...

AS/400: Close open files

Dear sirs, could you please help me with the following problem: I want to close all open files that are left open from previous different steps (pgms rpg , rpgle , clp) that were run. I have tried to use a CLP pgm using RCLRSC, RCLRSC *CALLER with no success. Could you please advise me how to close...

Stored Procedure

hi, I'm calling a Stored procedure from RPGLEV program. I'm getting error pointer not set for location referenced. the SP has 3 parameters, numeric, numeric, Character my call stmt is CallP  SP_Prototype(num1:num2:Char1) the program crahses....any thoughts???? thanks, NG Software/Hardware used:...

AS/400 Tool

i want 2 create as/400 tool in my prj which will save time Could anybody gimme some idea reagrding as/400 tools. Software/Hardware used: AS/400

DDS function keys with point and click functionality

I feel kind of stupid about this, but when did the DDS function keys become point and click action?  I have always used "CMD" and not "F#=" and totally missed this functionality.  I'm almost afraid of the answer. 

DB2 connection in VBscript

I need to delete some records from a DB2 database on an AS400 using VBscript.

How to connect to an AS/400 database from a remote PHP script

Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

Transform DB2 to XML from AS/400

I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

Program calls on AS/400

How i can check that my previous call to a program from other program was successful. Only after successful call and run only i can call another program. How to do check this in RPG and CL?

AS400 web app with map

I need an application that displays a map of our company property and all the inventory storage locations on that property. When you mouse over an inventory location I want to see a pop-up of all the materials stored at that location. The inventory database is on the AS400 (V5R4). What product...

Synon/2E - No member source genned

I created a file in the model and it did not generate a source member.

MySQL on AS/400 V5.3

I need to install MYSQL for as/400 V5.3 but I don’t know how and from where and dose it free or charge or chargeable product?

AS/400 to Java migration

Hello, could someone suggest me an appropriate tool for AS/400 to Java migration? also, I am more interested if that is a product and not a service.

DB2/400 stored procedures

Can you please tell me how to create stored procedures in AS/400 and when they are to be used?

How to create AS/400 menus

Hi, I am new to work with Menus. I have to Create menus. How do I need to start ? I need information from the scratch. Here I am using CRTMNU MENU(PAYLIB/PAYROLL) TYPE(*DSPF) ... Here onwords I don’t know how to proceed . Last time I have sent the same request , but some one send me link...

Retrieving AS/400 library list with Visual Basic 6

How can I retrieve As400 library list in a combo box / data combo box (Visual Basic 6) so that user may choose the corret library name then use it wherever needed. using windows 2000 or above is it possible to send me a sample program which explains how to do it. Thanks

AS/400 Debugging

Hi I am using STRISDB to debug my COBOL/400 progra. My object and source are in same libary. But, the debuggin is not working well. It's not executing all the lines and it's executing both the IF statement and else statements. It's behaving mysterically. Could some one explain why this type of...

RPG/400 error

i am getting error while moving data from one field to another field. I have two files xodcfp(physical file) xounpr 8 p(2) xodstsf(physical file) xsuprc1 10a while moving data from xounpr to xsuprc1 i am gettig error.... i tried EVAL XSUPRC1 = %EDITC(XOUNPR:'X') but still...

Processing of keyed program described files in RPG

Hi, I am very new to RPG and have a doubt on processing of keyed program described files. I know it's not a good idea to use program described files as externally described files offer many advantages over the former, but I am just exploring the alternatives. How do we tell the system about the...

List of Outfiles

I've seen a list of the System Supplied Outfiles in one of the manuals. Can anyone direct me to that manual ? Thanks, Bill Poulin