• Pass-Through API

    QPASTRPT- i can use this API to do Pass thru from one system to another, but i can't return any values back to the calling program thru this. is there any API for that ?

    PRIYAS40 pointsBadges:
  • Bad performance in call command in RPGLE

    We are facing a bad performance issue when RPGLE pgm A is calling RPG pgm B. Pgm A is reading a file as primary that contains 1000000 records and for every record calls pgm B that is doing 1 chain to a file and if it's sucessfully updates another file and then RETURN (not with SETON LR) to pgm A...

    SAMANDI75 pointsBadges:
  • converting numeric field to a character field and show leading zeros

    I am using %char to convert a numeric 9 pos field to character for use in a larger out put field. My code looks basically like eval labelout - "4J'+lpart+%char(lexpire)+%char(lserl) Where lexpire and lserl are used in the labelout field, I need the leading zeros to show. Right now, they are being...

    Merts30 pointsBadges:
  • Using RPGLE indicators

    How can use i use indicators for hide the fields and lables in the display file.

    Annal5 pointsBadges:
  • multilingual applications in as/400

    How to convert an existing RPG application to support Multilingual and multicurrency?

    TRam130 pointsBadges:
  • How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

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

    GHENDER190 pointsBadges:
  • Unable to over ride a PF member

    Hi, I made a cl program and in it I over ride a pf member, clrpfm then call my rpgle program. I can't write on my member but instead it writes on the primary member and reads it. seems the member that is used is the the primary member and not the member that I over rides.

    Ayterrobias5 pointsBadges:
  • Embedded SQL over multiple physical file members

    Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the...

    Gilly40023,730 pointsBadges:
  • File maintenance

    Hi, I have a file with million records and a batch program scheduled in the night maintains it. But it's found that the program is taking too much time for it's completion.How can we control and complete the program execution within one hour programmatically? thanks

    ten20081,150 pointsBadges:
  • delete from flat file

    HI My flat file contains data copied from a spool file.The records in this file is used as reference to delete links from dir.Can i delete those records in the flat file for which there is no link in the dir(that is the link or text file object has been deleted from the dir) ?I tried using embedded...

    0 pointsBadges:
  • Unable to use delete statement in SQLRPG

    Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

    0 pointsBadges:
  • RPG/400 – How to check if record is reaching end of the file in CL

    Please advice me how to chck record is reaching end of the file in CL.

    Askt1140 pointsBadges:
  • RPG/400 – How to send spoolfiles to different users

    Please advice how to send spoolfiles to different users.

    Askt1140 pointsBadges:
  • Doubt in *noMAX parm

    Does *nomax actually have some value.That is if i give the initial no of record parm as *nomax what will be the maximum number of records the file wiil accomodate.I believe there is some limit?

    0 pointsBadges:
  • How to get the duplicate records using RPG/400

    Please advice how to get the duplicate records using rpg/400.

    Askt1140 pointsBadges:
  • RPG/400: Maximum and minimum values

    Please advice how to find out maximum and minimum values in particular filed using rpg/400.

    Askt1140 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • Data Area Lock issue in RPG ILE

    Hi, I am using a data area in a RPG ILE program which will lock the data area and updates value. If the data area is locked, the program has to unlock the data area which is locked by the same user in any of his other session. Is it possible? If yes, please let me know steps have to be followed for...

    frmdeva365 pointsBadges:
  • how do you code a table in rpg

    I need to code a table in rpg iv. I'm new to rpg and need assistance on coding techniques as it pertains to creating a table in a rpg iv program

    Simobam10 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