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 or tools should [...]
Answer Question
| April 23, 2009 1:03 PM
AS/400 development, AS/400 Web Applications, AS/400 Web tools, V5R4
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 or tools should [...]
Answer Question
| April 23, 2009 1:03 PM
AS/400 development, AS/400 Web Applications, AS/400 Web tools, V5R4
Synon/2E – No member source genned
I created a file in the model and it did not generate a source member.
Answer Question
| April 21, 2009 11:41 AM
AS/400 development, iSeries development, Synon, Synon/2E
I created a file in the model and it did not generate a source member.
Answer Question
| April 21, 2009 11:41 AM
AS/400 development, iSeries development, Synon, Synon/2E
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?
Answer Question
| May 6, 2009 6:56 AM
AS/400 connectivity, AS/400 database connectivity, AS/400 development, AS/400 interoperability, MySQL
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?
Answer Question
| May 6, 2009 6:56 AM
AS/400 connectivity, AS/400 database connectivity, AS/400 development, AS/400 interoperability, MySQL
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.
Answer Question
| April 15, 2009 4:54 AM
AS/400, AS/400 development, AS/400 import/export, AS/400 migration, Java, Java Web developers, RPG
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.
Answer Question
| April 15, 2009 4:54 AM
AS/400, AS/400 development, AS/400 import/export, AS/400 migration, Java, Java Web developers, RPG
DB2/400 stored procedures
Can you please tell me how to create stored procedures in AS/400 and when they are to be used?
Answer Question
| April 14, 2009 6:12 PM
AS/400 development, AS/400 stored procedures, DB2 stored procedures, DB2/400
Can you please tell me how to create stored procedures in AS/400 and when they are to be used?
Answer Question
| April 14, 2009 6:12 PM
AS/400 development, AS/400 stored procedures, DB2 stored procedures, DB2/400
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 [...]
Answer Question
| August 4, 2009 9:29 AM
AS/400 development, CRTMNU, Display File, DSPF, Screen Design Aid, Start SDA, STRSDA
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 [...]
Answer Question
| August 4, 2009 9:29 AM
AS/400 development, CRTMNU, Display File, DSPF, Screen Design Aid, Start SDA, STRSDA
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
Answer Question
| February 18, 2010 7:49 AM
AS/400 development, AS/400 Library, ComboBox, ListBox, VB 6, Visual Basic, 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
Answer Question
| February 18, 2010 7:49 AM
AS/400 development, AS/400 Library, ComboBox, ListBox, VB 6, Visual Basic, Visual Basic 6
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 behaviour can happen [...]
Answer Question
| April 8, 2009 6:11 AM
AS/400 debugging, AS/400 development, COBOL debugging, COBOL/400, ISDB debugger, Source Interactive DeBug utility, STRISDB
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 behaviour can happen [...]
Answer Question
| April 8, 2009 6:11 AM
AS/400 debugging, AS/400 development, COBOL debugging, COBOL/400, ISDB debugger, Source Interactive DeBug utility, STRISDB
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 getting error… please advice
Answer Question
| October 29, 2009 12:00 PM
AS/400 development, RPG, RPG/400
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 getting error… please advice
Answer Question
| October 29, 2009 12:00 PM
AS/400 development, RPG, RPG/400
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 [...]
Answer Question
| April 3, 2009 11:45 AM
AS/400 development, Keyed program described files, 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 [...]
Answer Question
| April 3, 2009 11:45 AM
AS/400 development, Keyed program described files, RPG
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
Answer Question
| October 22, 2009 3:17 PM
AS/400 administration, AS/400 development, CL programming, CL/400, iSeries
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
Answer Question
| October 22, 2009 3:17 PM
AS/400 administration, AS/400 development, CL programming, CL/400, iSeries
Stored Procedure in AS/400
What different ways to we have to call a stored procedure in AS400 multiple times?How to implement this?Please any body suggest.
Answer Question
| March 31, 2009 7:19 PM
AS/400 development, AS/400 stored procedures
What different ways to we have to call a stored procedure in AS400 multiple times?How to implement this?Please any body suggest.
Answer Question
| March 31, 2009 7:19 PM
AS/400 development, AS/400 stored procedures
AS/400 F9 Retrieve Logic
Hello, Hope every one doing well. I am planning to implement F9 “Retrieve” functionality in my application. It would be great if any one can provide me the logic to implement the same. Hope you guys can guide me in this regards. Thanks & Regards Bibin George
Answer Question
| April 6, 2009 3:26 AM
AS/400 development, AS/400 F9, AS/400 Function Logic
Hello, Hope every one doing well. I am planning to implement F9 “Retrieve” functionality in my application. It would be great if any one can provide me the logic to implement the same. Hope you guys can guide me in this regards. Thanks & Regards Bibin George
Answer Question
| April 6, 2009 3:26 AM
AS/400 development, AS/400 F9, AS/400 Function Logic
How to programmatically initiate power down on another partition?
We are running a partitioned i5 with a UPS. We need to initiate a program controlled power down of the secondary partition from the primary partition after being notified by the UPS that the external power has failed. Then, once the secondary partition has or is about to shut down, perform a similar program controlled [...]
Answer Question
| May 4, 2009 10:11 PM
AS/400 administration, AS/400 development, AS/400 primary partition, AS/400 secondary partition, UPS
We are running a partitioned i5 with a UPS. We need to initiate a program controlled power down of the secondary partition from the primary partition after being notified by the UPS that the external power has failed. Then, once the secondary partition has or is about to shut down, perform a similar program controlled [...]
Answer Question
| May 4, 2009 10:11 PM
AS/400 administration, AS/400 development, AS/400 primary partition, AS/400 secondary partition, UPS
SIGN on Left Side on Display File
Hi All, I have defined a numeric field on my Screen as 11,02 which is Both (I & O). I want SIGN (-) to be displayed on left side. I use edit code ‘N’ and numeric shift attribute ‘Y’. But when I enter value as -123.45 on my screen, it goes into program as 123.45. [...]
Answer Question
| March 24, 2009 3:20 PM
AS/400 development, AS/400 Display File
Hi All, I have defined a numeric field on my Screen as 11,02 which is Both (I & O). I want SIGN (-) to be displayed on left side. I use edit code ‘N’ and numeric shift attribute ‘Y’. But when I enter value as -123.45 on my screen, it goes into program as 123.45. [...]
Answer Question
| March 24, 2009 3:20 PM
AS/400 development, AS/400 Display File
Record format in Display file in COBOL/400
What is the maximum number of Record format that can be used in Display file in COBOL/400?
Answer Question
| May 5, 2010 7:32 AM
AS/400 development, COBOL/400, Display File
What is the maximum number of Record format that can be used in Display file in COBOL/400?
Answer Question
| May 5, 2010 7:32 AM
AS/400 development, COBOL/400, Display File
AS/400 stored procedure passing parameter
I have created a stored procedure with an input parameter of type varchar(100). I am using the input variable in the query below select deptid,name , max(location) from emp where empid in (empnos); In which the empnos is the parameter i pass to the procedure and the variable is of type varchar. Empid in the [...]
Answer Question
| March 20, 2009 3:36 AM
AS/400 development, AS/400 stored procedures
I have created a stored procedure with an input parameter of type varchar(100). I am using the input variable in the query below select deptid,name , max(location) from emp where empid in (empnos); In which the empnos is the parameter i pass to the procedure and the variable is of type varchar. Empid in the [...]
Answer Question
| March 20, 2009 3:36 AM
AS/400 development, AS/400 stored procedures
Accessing AS/400 DB2 physical files with Java
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I [...]
Answer Question
| May 20, 2009 7:00 AM
AS/400 development, DB2/400, Java, Java/400, JD Edwards World, JDE, ODBC, Physical File
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I [...]
Answer Question
| May 20, 2009 7:00 AM
AS/400 development, DB2/400, Java, Java/400, JD Edwards World, JDE, ODBC, Physical File
CEERANO compiling
Does CEERANO in RPGLE have to be compiled with any options like a special Activation Group or a Bound Service Program?
Answer Question
| March 6, 2009 8:17 PM
AS/400 development, CEERANO, RPGLE
Does CEERANO in RPGLE have to be compiled with any options like a special Activation Group or a Bound Service Program?
Answer Question
| March 6, 2009 8:17 PM
AS/400 development, CEERANO, RPGLE
New Web Service Project
Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP’d to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a [...]
Answer Question
| March 6, 2009 10:05 PM
AS/400 development, AS/400 jobs, FTP, iSeries, Java, V5R4, Web development, Web Services Standards, WebSphere, XML
Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP’d to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a [...]
Answer Question
| March 6, 2009 10:05 PM
AS/400 development, AS/400 jobs, FTP, iSeries, Java, V5R4, Web development, Web Services Standards, WebSphere, XML
