• Controlling Form Overlay

    I have a requirement to print a report with a form overlay ON THE FIRST PAGE ONLY. Has anyone done this? Using the overlay is no problem, but it seems like it's all or nothing. I tried printing all pages after the first as a separate spool file and then using the SHARE(*YES) keyword to merge them....

    PageOverlay15 pointsBadges:
  • Position to in load all subfile

    I have done a position to in a load all subfile by checking if the position to field is not empty, then chain the file with that key and display records from there onwards. But am facing this issue, after the subfile is displayed, I am not able to do a page up. It gives error "roll up or down past...

    RamvishakRamesh2,410 pointsBadges:
  • iSeries Installation

    As I am new for installation, could you please guide me that which is the best way to install iSeries V5R4? Manual or Automatic and in what condition I should use them?

    MayurRastogi390 pointsBadges:
  • Add leading zeros to numeric value in a character filed

    I have a display file field which is of type 7A. I am entering value as 18 to that field. Now I need to go to a file with this field as the keyfield. But in the file the value is stored as '00000018'. So if I chain with ' 18' it says value is not in file. Please help

    RamvishakRamesh2,410 pointsBadges:
  • Scroll cursor example

    My physical file is STUDENT i am trying to get the particular record using scroll cursor but i am unable to get the values. pls correct it A UNIQUE A R STUREC A STUNUM 10P A STUNAME 10A A STUAGE 5P A K STUNUM Dnumber s 10p 0 Dname s 10a Dage s 5p 0 C z-add 555 number c/exec sql c+ declare c1 scroll...

    gsivakkp86220 pointsBadges:
  • CPF4169 error appeared during OPEN for screen file

    In reference to Ibmi ILE programming environment. I am in a screen program which is set to 132 length. There are multiple calls to other programs that are set to 80 length where there is not a problem getting the CPF4169 error. So now I have a new program to call and I am getting this error and I...

    sewell90 pointsBadges:
  • AS400 to Oracle query

    Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

    Atti123130 pointsBadges:
  • AS/400 windows profile issue

    AS/400 printer session prints out fine as administrator of the PC, but when logged in as a user the printouts come out with different spacing between letters.

    Vicmtzmtz10 pointsBadges:
  • AS400 – PF

    How to View Records from File based on Key List. Generally SQL will display records based retrieval sequence. I want to see it keyed Sequence.

    rajeshece1,215 pointsBadges:
  • Want to find a string in CL source file(ABOUT 400 CL SOURCE ) and replace with other String.

    I Have a problem For replacing a particular Hard coded Libray name from my all CL source file(about 400) by some other hardcoded library name.For e.g There is a library name Used in many CL source file with ABCD(lib name).I want to change all occurances in each CL source file By DEFG.

    fsddfsdfsd60 pointsBadges:
  • Performance improvement – RPGLE

    Hi, I have an RPGLE program which reads every record of a masterfile ( 4 million records) and updates some of the field values. There are different procedures to retrieve the values from various files and to update the masterfile. The procedures are written with read, chain logic to retrieve the...

    ZWANZIG40 pointsBadges:
  • Submitted jobs

    Our submitted jobs use to show up at the bottom of "work with submitted jobs" F14 now some of the current jobs are showing up at the top on the "work with submitted jobs". Would like all current jobs to show up at the end. Thought it had something to with the job number rolling over but cant...

    okbound5 pointsBadges:
  • QSECOFR Profile Creation

    How to create a new QSECOFR profile. What authorities we should have to create this profile.

    didinu760 pointsBadges:
  • 2039 Year Limitation in CVTDATE

    I used date 20430923 to be converted to *ISO format using CVTDATE, but got a machine error. How do I overcome this limitation? Does iSeries provide another command to accomplish the same?

    asakla240 pointsBadges:
  • convert DTF and DTT scripts to RTO

    Can anyone, and I cannot stress this enough, Can anyone tell me why I cannot convert Client Access file transfer to replicate in Rumba? in our legacy system we have numerous, but I find it painstakenly (sorry no spell check) difficult to just convert one to work the same way, and when starting from...

    Twindad9720 pointsBadges:
  • AS/400 CPYTOIMPF

    While I am using CPYTOIMPF, is it possible to copy field names?

    kennedy2802110 pointsBadges:
  • DFU to SQL translator

    Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn't see DFU commands but does see SQL statements.

    DandyDon10 pointsBadges:
  • How can I retrieve the source of a STRQMQRY?

    In my CL program I have a STRQMQRY. How can I get the source file name were this QMQRY resides?

    RamvishakRamesh2,410 pointsBadges:
  • Finding particular member data in RPG

    I have a physical file(EXTPF) it contains one member(mbr1) how to read that particular member data in RPG. I wrote a code for that but i got CPF4102 error please rectify it A UNIQUE A R EXTPFREC A NUMBER 10P A NAME 10A A ADDRESS 10A A K NUMBER Fextpf if e k disk extmbr('mbr1') /free read extpf; dow...

    gsivakkp86220 pointsBadges:
  • Is there and efficient way to load Prtf fields with data from a PF?

    I want to load a Physical File with Printer File field names and Data. Then read through the PF and populate the printer file field variable with the data from another field in the file. Then I can write the PrtF record with the variable data from the file. For example PFfields: fLINE fCMD1 fRIGHT...

    JimboNbr215 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