• RPG internally described output (printer) file to DDS

    How do i convert an old RPG internally described output (printer) file to an externally described DDS printer file?

    ITDavid140 pointsBadges:
  • Reading only the active records in a flat file

    I have a physical flat file which has thousands of deleted records. (I can't get exclusive use of the system to do a reorg) I am doing a sequential read of the file because the file only has a few active records. However, it is taking the program awhile to finish and I'm guessing it is because the...

    GHENDER190 pointsBadges:
  • Select substring from clob-field with sql

    How do you copy substring from clob-field with SQL if substring from/to positions are varables? This works OK (RPG free w embedded sql): exec sql select substr(myclobfield, 25, 70)                 INTO :mystring                 FROM MYLIB/MYFILE; [/pre] Whereas this...

    DanTheDane2,555 pointsBadges:
  • Sorting alphanumeric field with hexadecimal values

    We have a task where we have to convert key numeric field (8,0) to alphanumeric field (8A) with hexadecimal values ('00000000' - 'FFFFFFFF'). The problem in sorting with alphanumeric is the alphabet is less than the numeric value (A-Z < 0-9). Is there a way, by LF or any AS400 utility, that can...

    Vsevilod135 pointsBadges:
  • OPNQRY File

    OPNQRYF Query Hi, I am having difficulty in figuring out the syntax for using the special keyword %values with the variables in the OPNQRYF command. Below is the &QRYSLT I used.  CHGVAR VAR(&QRYSLT) VALUE('(DQB8ST *EQ "A" *AND + DQJRCE *EQ %VALUES( ' *TCAT &MARKET + *CAT ' )) *OR (DQB8ST = "D"...

    Ankita135 pointsBadges:
  • Are there any Synon experts out there? (20 plus years)

    Experienced, 20 years plus, synon developers have probably forgotten more about synon than the new generation (yes there are young people learning synon) will ever know.   Does any of those experts remember the phantom + sign on subfile displays when there were no more records to display?  If so,...

    Trbeesley140 pointsBadges:
  • Want to make a utility to search string.

    [h3 class="groups"> Hi,[/h3] [h3 class="groups">I want to make a utility in AS400 to search a string (Such as file name/PGM name) in my current Library and in all Source physical files if found show PGM and all related files. Like I do trough find string Command. [/h3] It would be also help ful you...

    Builtin100 pointsBadges:
  • Compile an RPGPGLE Program???

    Hi All,  I am making modifications to an RPGPGLE Program but am having trouble compiling it. It does not like the option 14 compile within the PDM and I think there is another option that can be used or command for the compile but I seem to have forgotton what that is. Anyone able to provide...

    DaJuRan30 pointsBadges:
  • RPG Object verification

    Hi, I need to verify if a RPG object on our production AS/400 is the same as on our test box. I used to to look at object size, but it doesn't always seem to be a consistent way to determine if two objects are the same. Any other way, to determine if two RPG ojects are the same?

    DeonFourie25 pointsBadges:
  • External data structure retrieve field data types

    In RPG I am trying to move a External DS (based on a file, filled on input) to a character string and convert all decimal (packed) values to their character representation while doing so. I need to repeat this action on multiple files so a simple or generic solution is what I'm aiming for. Since...

    MvandenBrink55 pointsBadges:
  • CPF5032 member already locked to this job

    I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be...

    GHENDER190 pointsBadges:
  • Debugging an ILE RPG module within a program

    I have a program containing 3 modules. The module I need to debug is not displaying the source. How do I debug this module?

    Ile novice10 pointsBadges:
  • SetON LR and Return

    What is the difference between Seton LR And Return

    PrateekChowdhri10 pointsBadges:
  • How to fetch data from physical file using RRN value of a record ?

    I want to fetch / read a record with given RRN value in rpg. How to read a record for which only RRN value is given, in RPG ?

    Aum15 pointsBadges:
  • Non Subfile Field Not Changing When Doing an EXFMT

    This should be a simple thing to do but it is not working. I have an RPG program in which the user enters a warehouse code and presses enter. If the code is valid, it then populates a field in the record with the warehouse description. If the user changes the code to an invalid warehouse, I turn on...

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

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