• sql table in rpg

    I need to read an sql table (file) in rpg and select certain records. I'm pretty green in sql. Anyone have a sample they could share? I'am better at rpg than ile., but I'll take what I can get. Thanks

    Brenger170 pointsBadges:
  • AS/400 file specification

    Why sometimes we need to put "K" for file specification?eg: FSSDATA IF E K DISK

    Cev105 pointsBadges:
  • iSeries RPG Embedded SQL Performance

    Hi, I'm trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I've already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when...

    Gilly40023,730 pointsBadges:
  • Using QIMGCVTI API in RPG to convert image formats

    Has anyone used the QIMGCVTI API in a RPG program to convert image formats? If so, can you provide a sample of the RPG codes?

    Jacksonville15 pointsBadges:
  • Controlling Display sizes

    I have an application that, when called, displays a full screen subfile as an 80 wide record (*DS3 at the file level). This works fine from any command line but, this application needs to be available from within an SEU session where the session is set to 132 wide also. Obviously I cannot display...

    Floyd02320 pointsBadges:
  • Converting spool file output to Excel in RPG without third-party software

    I would like to know how to write an RPG program and have my spool file output be converted to an Excel file without using any 3rd-party software.

    AS400 - Ask the Expert485 pointsBadges:
  • Reading a Microsoft Word file (.doc) in a ILE RPG program

    I need to read the text of a Ms Word file without opening word, reading it in a ile rpg program, and put the text in a string. How can I do ? Thanks in advance

    Alfredovitali5 pointsBadges:
  • 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?

    Brenger170 pointsBadges:
  • Embedded SQL in RPG ILE

    I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time

    Jeffm125 pointsBadges:
  • Barcoding in RPG/400 DDS

    How can I code an EAN13 barcode in RPG 400 DDS

    Roddyredbelt25 pointsBadges:
  • Modules in RPGLE

    Hi, Can anyone tell me what is module in RPGLE and how is it created? alos tell me how this can be called from rpgle?

    Mathi5 pointsBadges:
  • Print a company logo using rpg

    How do you print a company logo using rpg on a laser printer?

    Alpfalpf25 pointsBadges:
  • 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 3mb. Can...

    Supriyob2165 pointsBadges:
  • 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?

    Floyd02320 pointsBadges:
  • AS/400 Batch Debugging with source

    I want do batch debugging with source for an OPM RPG program in test enviraonment. But im not able view the source. I have compiled the program with the *SRCDBG option. But im getting a 'Source not available' message when doing batch debug. In my development machine im able to view the souce but...

    34789025 pointsBadges:
  • operation code-occur

    In what condition we have to use occur?what is the use of occur(Set/Get Occurrence of a Data Structure )?

    Cev105 pointsBadges:
  • 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 done??

    Shwesmile20 pointsBadges:
  • 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

    Geojf385 pointsBadges:
  • Barcodes in RPG

    How can I code EAN13 barcodes in RPG

    Roddyredbelt25 pointsBadges:
  • Combining fields in RPG

    How can I combine three fields into one in rpg?

    farmgirl165 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following