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
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’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
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
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
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
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
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 can I code EAN13 barcodes in RPG
Answer Question | October 17, 2008 8:27 AM
Barcode, EAN-13, European Article Number, 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
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 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
How can I combine three fields into one in rpg?
Answer Question | October 14, 2008 8:06 PM
RPG, RPG IV
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
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
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
How will u specify overflow in RPG program without indicators?
Answer Question | August 26, 2010 8:00 AM
RPG, RPG overflow
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
How to convert an existing RPG application to support Multilingual and multicurrency?
Answer Question | February 16, 2009 8:06 AM
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