Copy data from flat file to a flat file
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto [...]
Answer Question
| November 3, 2008 6:37 AM
AS/400 import/export, COBOL, COBOL/400, Flat files, PF, Physical File, RPG
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto [...]
Answer Question
| November 3, 2008 6:37 AM
AS/400 import/export, COBOL, COBOL/400, Flat files, PF, Physical File, RPG
Haversine formula in RPG or SQL
I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?
Answer Question
| November 6, 2008 10:01 PM
AS/400 development, Great-circle distance, Haversine formula, RPG, SQL
I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?
Answer Question
| November 6, 2008 10:01 PM
AS/400 development, Great-circle distance, Haversine formula, RPG, SQL
Menubar and pulldown menus
I’m trying to get a menubar with pulldown menus to work in RPG. Coding the DDS was fairly easy just from reading the Application Display Programming book. Unfortunately, it doesn’t give the supporting RPG code to make it work. Anyone know of a code example I can view that works?
Answer Question
| October 31, 2008 1:35 PM
Application Display Programming, MNUBAR, PLDWN, RPG
I’m trying to get a menubar with pulldown menus to work in RPG. Coding the DDS was fairly easy just from reading the Application Display Programming book. Unfortunately, it doesn’t give the supporting RPG code to make it work. Anyone know of a code example I can view that works?
Answer Question
| October 31, 2008 1:35 PM
Application Display Programming, MNUBAR, PLDWN, RPG
Data Extract
What is the easiest way to extract data from a pipe-delimited text file?
Answer Question
| September 13, 2010 2:37 PM
CL, DB2, Pipe-Delimited Text File, RPG
What is the easiest way to extract data from a pipe-delimited text file?
Answer Question
| September 13, 2010 2:37 PM
CL, DB2, Pipe-Delimited Text File, RPG
Print a company logo using rpg
How do you print a company logo using rpg on a laser printer?
Answer Question
| November 3, 2008 3:37 PM
AS/400 printing, RPG
How do you print a company logo using rpg on a laser printer?
Answer Question
| November 3, 2008 3:37 PM
AS/400 printing, RPG
operation code-occur
In what condition we have to use occur?what is the use of occur(Set/Get Occurrence of a Data Structure )?
Answer Question
| October 24, 2008 7:22 AM
Operation Code, RPG, RPGLE
In what condition we have to use occur?what is the use of occur(Set/Get Occurrence of a Data Structure )?
Answer Question
| October 24, 2008 7:22 AM
Operation Code, RPG, RPGLE
Create a window on the iSeries
Hi all, I know I have seen it done, where the user requests a list of codes while in an inquiry and a “window” pops up with the desired information. Can anyone guide me to where I can see how the window program is created? Thank you, George
Answer Question
| October 22, 2008 12:00 PM
iSeries, iSeries window, RPG
Hi all, I know I have seen it done, where the user requests a list of codes while in an inquiry and a “window” pops up with the desired information. Can anyone guide me to where I can see how the window program is created? Thank you, George
Answer Question
| October 22, 2008 12:00 PM
iSeries, iSeries window, RPG
Grouping the records in RPG
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a ‘SQL precompile failed’ error. How do I handle this?? And i have to display the employee records grouped by their locations… how can this be [...]
Answer Question
| October 22, 2008 4:39 AM
AS/400 database, AS/400 development, AS/400 error messages, Embedded SQL, Report Program Generator, RPG, RPG/400, SQL precompile failed, SQL/400
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a ‘SQL precompile failed’ error. How do I handle this?? And i have to display the employee records grouped by their locations… how can this be [...]
Answer Question
| October 22, 2008 4:39 AM
AS/400 database, AS/400 development, AS/400 error messages, Embedded SQL, Report Program Generator, RPG, RPG/400, SQL precompile failed, SQL/400
Barcodes in RPG
How can I code EAN13 barcodes in RPG
Answer Question
| October 17, 2008 8:27 AM
Barcode, EAN-13, European Article Number, RPG
How can I code EAN13 barcodes in RPG
Answer Question
| October 17, 2008 8:27 AM
Barcode, EAN-13, European Article Number, RPG
RPG 3 duplicate record error handler
The physical file has a field keyed and unique. If i want to update these to RPG 3 program it is showing a duplicate record error. Does anybody have solution? tell me the command to handle this error only for RPG 3.
Answer Question
| August 27, 2010 5:23 AM
Duplicate records, Error handling, Physical File, RPG
The physical file has a field keyed and unique. If i want to update these to RPG 3 program it is showing a duplicate record error. Does anybody have solution? tell me the command to handle this error only for RPG 3.
Answer Question
| August 27, 2010 5:23 AM
Duplicate records, Error handling, Physical File, RPG
How to display the SQL query results on SDA screen?
I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you.
Answer Question
| October 14, 2008 8:58 AM
AS/400 development, RPG, Screen Design Aid, SQL/400
I got an answer for how to embed the SQL statements in RPG program. Can you please help me with how to use these values in the program, or display them on the SDA screen??? Thank you.
Answer Question
| October 14, 2008 8:58 AM
AS/400 development, RPG, Screen Design Aid, SQL/400
Can you embed SQL statements in RPG program
I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???
Answer Question
| August 22, 2010 4:48 AM
Embedded SQL, RPG, SQL, SQLRPGLE
I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???
Answer Question
| August 22, 2010 4:48 AM
Embedded SQL, RPG, SQL, SQLRPGLE
Combining fields in RPG
How can I combine three fields into one in rpg?
Answer Question
| October 14, 2008 8:06 PM
RPG, RPG IV
How can I combine three fields into one in rpg?
Answer Question
| October 14, 2008 8:06 PM
RPG, RPG IV
Embedded SQL
I need to get a grip on using the embedded SQL in an RPG ILE program using the word “CURRENT” and I need to know how this works (in laymens terms please.)
Answer Question
| October 13, 2008 6:51 PM
Embedded SQL, RPG, RPG ILE, SQL
I need to get a grip on using the embedded SQL in an RPG ILE program using the word “CURRENT” and I need to know how this works (in laymens terms please.)
Answer Question
| October 13, 2008 6:51 PM
Embedded SQL, RPG, RPG ILE, SQL
iSeries IBM
What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error
Answer Question
| October 13, 2008 5:36 AM
AS/400, RPG, RPG/400
What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error
Answer Question
| October 13, 2008 5:36 AM
AS/400, RPG, RPG/400
Switch between two display files
I M USING A RPGLE PRGM IN WHICH THERE ARE 2 SCREENS.1 CONTAINS ALL THE RECORDS OF CUST ,IN WHICH 1 CAN USE OPT 2OR 4 FOR UPDATE AND DELETE.BOTH THE FUNCTIONS ARE WORKING BUT WHEN UPDATE SCREEN OPENS I WANT TO GO BACK TO MAIN SCREEN WHICH CONTAINS ALL THE RECORDS.SO PLZ TELLL ME [...]
Answer Question
| October 10, 2008 7:04 AM
RPG, RPGLE
I M USING A RPGLE PRGM IN WHICH THERE ARE 2 SCREENS.1 CONTAINS ALL THE RECORDS OF CUST ,IN WHICH 1 CAN USE OPT 2OR 4 FOR UPDATE AND DELETE.BOTH THE FUNCTIONS ARE WORKING BUT WHEN UPDATE SCREEN OPENS I WANT TO GO BACK TO MAIN SCREEN WHICH CONTAINS ALL THE RECORDS.SO PLZ TELLL ME [...]
Answer Question
| October 10, 2008 7:04 AM
RPG, RPGLE
Overflow in RPG
How will u specify overflow in RPG program without indicators?
Answer Question
| August 26, 2010 8:00 AM
RPG, RPG overflow
How will u specify overflow in RPG program without indicators?
Answer Question
| August 26, 2010 8:00 AM
RPG, RPG overflow
CHECK vs SCAN
can anyone explain me when to use CHECK and SCAN and differentiate between them? Please provide examples too…thanks
Answer Question
| October 10, 2008 8:24 AM
RPG
can anyone explain me when to use CHECK and SCAN and differentiate between them? Please provide examples too…thanks
Answer Question
| October 10, 2008 8:24 AM
RPG
multilingual applications in as/400
How to convert an existing RPG application to support Multilingual and multicurrency?
Answer Question
| February 16, 2009 8:06 AM
RPG
How to convert an existing RPG application to support Multilingual and multicurrency?
Answer Question
| February 16, 2009 8:06 AM
RPG
Trying to run remote command to view AS/400 UNC and failing!
I need some ideas here…I’m stuck. I’m running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files [...]
Answer Question
| August 15, 2010 7:54 PM
CSV, Microsoft Excel, RPG, UNC, UNC path
I need some ideas here…I’m stuck. I’m running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files [...]
Answer Question
| August 15, 2010 7:54 PM
CSV, Microsoft Excel, RPG, UNC, UNC path
