• When doing a chain the (HI) indicator return with ’1′. But if I do a query on the same file I can see that the record is in the file.

    I have a program in RPGIII. In the production environment the users are getting the following error message: RPG1221: (Issued update or delete in SDFBOBS0 without prior READ or CHAIN). I thought i shall put this program in my test environment and try to do the same as what the users have done in...

    KorsouRPG5 pointsBadges:
  • Can I change c0001copybook in RPG?

    in rpg c0001 is a standard copybook.if i want to make a new program then can i use this copybook.and for my program some modification is necessary...so can i change this copybook program

    Rehan8810 pointsBadges:
  • serviece program in rpgle

    what is serviece program in rpgle and how to use it

    Bcd5 pointsBadges:
  • Can I write a program in CL to update a record on a database file

    Hi, I am not familiar with RPG . Is it possible to write a program in CL to update records in a database file. I have thought about SQL , however I do not have any SQL frontend installed on the AS/400

    Alanyegambaram15 pointsBadges:
  • Creating two receivers

    i need to crt more than a 2 rcvr for a user to monitor his different jobs, like CL,RPG,SQL.but there is no option to crt more than two? why itis so?whats the truth behind it?

    Rajasekhar151,395 pointsBadges:
  • subfile processing – Incorrect record number in subfile SFLRCDNBR or SFLSIZ field.

    I am getting the above error - this the dds specs  A A R SUBDTB SFL  A SUBPART 35A B 6 18   A R SUBCTLB SFLCTL(SUBDTB)   A*%%TS SD 20031114 134548 KAUSC REL-V5R2M0 5722-WDS   A SFLSIZ(0020)   A SFLPAG(0010)   A ROLLUP   A ROLLDOWN   A 60 SFLDSPCTL   A N61 OVERLAY   A 61 SFLCLR   A 62...

    Manyquestions65 pointsBadges:
  • RPG date retrieval

    how to retrive the next 7th date of current month using rpg? EX: today's date is 06/09/2011 i want to get the date 13/09/2011, how it's possible?

    Rajasekhar151,395 pointsBadges:
  • Filed in D specs is not getting initialized on the 2nd call to program.

    My RPG programs fields in the D specs that are set to initialize Example(D Fld1    S      1A     INZ('Y') will work the first time the program is called but not on the second call of the same program.

    Amjim25 pointsBadges:
  • dspfile in rpg

    can we do debugging a dsp file in rpg? if its so how is possible? plz give me the steps?

    Rajasekhar151,395 pointsBadges:
  • SQL to query a file

    I want to use SQL to query a file and summurize data, using multiple scalars( min, max, sum) and display the results on a workstation screen.  Can i use one select statement in RPG iseries or should I create a stored procedure?   Any code samples,etc would be greatly appreciated.  

    rmb115 pointsBadges:
  • 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...

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

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