• Staying on the Same Subfile Page When Auto Refreshing

    I am doing an auto refresh. To do this, I created my display file using waitrcd(15), used maxdev(*file) for my workstn file and instead of using exfmt, I turned on the indicator which controls my INVITE, wrote to my subfile control record ,read from my display file and then turned my INVITE...

    GHENDER190 pointsBadges:
  • reading values through data area except IN & RTVDTAARA ?

    Is there any other way to read values through data area except Using 'IN'Opcode in RPG and RTVDTARA command in CL? Pls. tell if it could be done in other ways in our RPG programme or in our Cl programme?

    6r1,520 pointsBadges:
  • MSGW in WRKACTJOB

    How to end a job in MSGW how we can give in a program all the proces to give OPT-7 in front of a job which is in MSGW & giving 'G' to end that in RPGLE /CLLE progrm that too in a scheduled time

    Sitaratnam10 pointsBadges:
  • Converting from System 36 to iSeries V5R4

    I've been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could'nt find anything. Does anyone have something I can use - something like the...

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

    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:

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