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.
What different ways to we have to call a stored procedure in AS400 multiple times?How to implement this?Please any body suggest.
10 pts.
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
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
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...
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...
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. SIGN is not coming into program. If...
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. SIGN is not coming into program. If...
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?
What is the maximum number of Record format that can be used in Display file in COBOL/400?
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....
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....
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 am...
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 am...
CEERANO compiling
Does CEERANO in RPGLE have to be compiled with any options like a special Activation Group or a Bound Service Program?
Does CEERANO in RPGLE have to be compiled with any options like a special Activation Group or a Bound Service Program?
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...
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...
Explain Stored Procedures in AS/400
Hi, Can any one please explain me 1.What is stored procedures in AS/400. 2.What is the use of Stored Procedure 3.Please give me small example how to code stored procedures in AS/400 4.What is the object type of Stored procedures 5. How can we code stored Procedures and how can we call it. and main...
View Answer
| Feb 20 2009 8:31 AM GMT
AS/400 stored procedures, AS/400 development, Stored Procedures
Hi, Can any one please explain me 1.What is stored procedures in AS/400. 2.What is the use of Stored Procedure 3.Please give me small example how to code stored procedures in AS/400 4.What is the object type of Stored procedures 5. How can we code stored Procedures and how can we call it. and main...
View Answer
| Feb 20 2009 8:31 AM GMTAS/400 stored procedures, AS/400 development, Stored Procedures
Submitting a batch job from a C program
Is it possible to call SMBJOB in a C program to submit a batch job? If not, is it possible to submit a batch job in a C program some other way?
Is it possible to call SMBJOB in a C program to submit a batch job? If not, is it possible to submit a batch job in a C program some other way?
(AS/400 - RPG(ILE)) Date-Conversion
Date-Conversion --------------------- I have a date in 7-digit format in '1YYMMDD' format. e.g 1071231 for representing 31st of December 2007.(where '107' represents 2007; 12 represents December & 31 represents 31st Day of the month). Now i need to convert this into '31/12/2007' (European...
Date-Conversion --------------------- I have a date in 7-digit format in '1YYMMDD' format. e.g 1071231 for representing 31st of December 2007.(where '107' represents 2007; 12 represents December & 31 represents 31st Day of the month). Now i need to convert this into '31/12/2007' (European...
Pop-Up Calendar with RPG
I found a link that would show me how to code a pop-up calendar on the AS400. However, when I went to that link, it was invalid. Does anyone know how to create RPG code for a pop-up calendar on the AS400?
I found a link that would show me how to code a pop-up calendar on the AS400. However, when I went to that link, it was invalid. Does anyone know how to create RPG code for a pop-up calendar on the AS400?
How to retreive stored procedure from DB2/400
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload ... ...
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload ... ...
RPG Debugger
I work for a small AS/400 shop. For the most part, we are still coding in RPGIII and doing green screen applications. Due to a recent Lawson upgrade, we have had to convert a large chunk of our code to ILE. Myself and the other programmer here are used to the Interactive debugger and using the old...
I work for a small AS/400 shop. For the most part, we are still coding in RPGIII and doing green screen applications. Due to a recent Lawson upgrade, we have had to convert a large chunk of our code to ILE. Myself and the other programmer here are used to the Interactive debugger and using the old...
UPS and Fedex program interfaces
Does anyone know of any programs that can interface with the UPS or Fedex websites and return back shippng information; such as rates, delivery dates, etc... ???
Does anyone know of any programs that can interface with the UPS or Fedex websites and return back shippng information; such as rates, delivery dates, etc... ???
How to get a Lastname from a field that contains the Full Name? (RPG-ILE)
Hi Guys, I need your suggestions.... I have to extract data from our AS400 box and convert it into text file. For a client's name we have 3 particular fields. 1. FirstName, 2. LastName and 3. FullName. The problem is there are records where First Name and LastName fields are empty. Thats why I...
Hi Guys, I need your suggestions.... I have to extract data from our AS400 box and convert it into text file. For a client's name we have 3 particular fields. 1. FirstName, 2. LastName and 3. FullName. The problem is there are records where First Name and LastName fields are empty. Thats why I...
Please explain RPG "Bind by Copy" and "Bind by Reference"?
Can you explain the terms with example BIND BY COPY BIND BY REFERENCE
Can you explain the terms with example BIND BY COPY BIND BY REFERENCE
AS400 - RPGLE Module
Hi, I have created module mod1. and i have merged the mod1 with services programs sp1, sp2, sp3. how do i find what are all the service programs attached with that particular module?
Hi, I have created module mod1. and i have merged the mod1 with services programs sp1, sp2, sp3. how do i find what are all the service programs attached with that particular module?
AS/400 script or program needed
I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...
I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...
