• Highest RRN in a Subfile

    Does anyone have the positions for the highest RRN on a Subfile? This was found in the old CPF programmer’s guide a hundred years ago. It was right after the Lowest RRN currently displayed on the subfile. This info comes from the INFDS. Are there examples?  

    Nickhutcheson165 pointsBadges:
  • Date field default value – RPG

    I have a date field defined in a file to hold the date we expect an order to be delivered. However there may be no orders open for an item and I expect I will get an error if I then leave this field blank. Any ideas on how I can handle this to avoid the error?

    FrankStacey105 pointsBadges:
  • Connect to Oracle from AS/400

    I need to connect to an Oracle database from an AS/400 (RPG III/CL program). Because I need to get some data. How can I do it? What do I need?

    Esnu5 pointsBadges:
  • Access Oracle/Sybase/Informix from RPG

    Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...

    JohnDavid5 pointsBadges:
  • Opening an internet browser session from AS/400 5250 session.

    In my CL program on the AS/400, I have a URL that references a document stored on a network server that I would like to display to the user in an internet browser session while they are using a 5250 session on the As400. (i know it's a run-on sentence.) Can someone give me advice as to the...

    BikerDude0 pointsBadges:
  • AS/400 Trigger programming

    Sir, I have a trigger program on a file (File1) with INSERT / UPDATE / DELETE. The requirement is to execute the business logic on the same file (File1). So I'm opening File1 in trigger program in update/add mode. I know that it is not recommended to use the same file in trigger program. The...

    GauriKulkarni0 pointsBadges:
  • RPG FREE Reference Book

    Currently, I am using RPG IV. However, I need to learn how to code in RPG Free. Can anyone tell me the names of some good books and/or tutorials which would help with this?

    GHENDER190 pointsBadges:
  • Difference between Record and File locks

    I had always thought that record and file locking where terms used interchangeably. I searched the web and couldn't validate my assumpition. Is there anyway in RPG you can lock a specific record (record lock) in a file without locking the entire file (file lock)?

    GTank5 pointsBadges:
  • error in following rpg code?

    Dear all, I am having problem while compiling follwing rpg code for calculation of square and cube of 2digit number.my display file compiles well but there is an error exfmt operation entry not valid.(error qrg 5199). RPG CODE is:  Columns . . . :    1  71           ...

    6r1,590 pointsBadges:
  • Passing parameters thru LDA

    Hi i want to know how the parameters can be passed from one RPG program to another RPG program using LDA.Please give me an example code. thanks Ram

    ten20081,150 pointsBadges:
  • DBF in AS/400 – last record written

    Hi , There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.   Thanks

    Atti123135 pointsBadges:
  • Algorithm for parsing a RTF file ? anyone? ?

    I need to extract the user entered text from RTF files held within the IFS. Microsoft have a quaint 'specification' which incorporates several 'standards' for the syntax of control words. Does anyone have any RTF reading code that will run on an IBM i? - doesn't need to produce a print, or do...

    Yorkshireman5,580 pointsBadges:
  • AS/400 (Retail) Banking application

    Hi, I'm looking for some details and materials on any AS/400 retail banking application. Information in design level.. You may ask what exact requirement is but as of now I need a model which uses technology RPG, CL, SQL, menu screens, display files etc pls.. Thanks

    itkr125 pointsBadges:
  • RPG indicators

    Pls tell me how to pass values to a group of indicators at once in a single statement in RPG and RPGILE with example..thanks

    ten20081,150 pointsBadges:
  • Subfile code for AS/400

    In Subfile, OPT   ShipQuantity   QuantityToShip   Item#   CustomerOrder#        ___     ____________   100                  ABC1     CO100010                 ___     ____________   10                    WQE1   ...

    22917515 pointsBadges:
  • CHAIN(E)

    what is chain(e) please explane with example

    It doubts85 pointsBadges:
  • useropen

    Hi, What is the purpose of USROPN keyword?

    As400venkat20 pointsBadges:
  • AS/400: RPG IV

    Hi, I stuck in following scenario. I have 2 files FILEA in lib LIBA and FILEB in LIBB and have to use both the files in RPG program.   Please assist me on this.    

    Samule400160 pointsBadges:
  • Embedded SQL in rpg for subfile build SQLCOD

    My fetch next in sql is getting sqlcod = -000000181 and sqlstt = '22007'.  I looked this up.  It says invalid date or time. Pointing to date data types in the file I am trying to read. The records contain two date fields and two time fields. How can I get around this?   Thanks in advance. Nick

    NickHutcheson11,380 pointsBadges:
  • Free format subdur minutes from a time

    I am trying to search for the correct syntax for subtracting a minute from a time. I have a 6 numeric time field in HHMMSS format.  I am trying to use free format to subtract a minute.  Having trouble. Using: @atime=%dec((%time(@atime:*hms)- 1 *min)...

    VictoriaS15 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