• 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...

    GHENDER200 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:
  • 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?

    GHENDER200 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:

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