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

    GHENDER220 pointsBadges:
  • Expanding subfile error

    In Expanding subfile I am able to load and display the records. I created a simple example with 4 sfl pages. After loading all the pages I used page up to the first page. Now when I am pressing the enter key the subfile directly showing the last page. What might be the reason for this issue. Anyone...

    Renjithgr285 pointsBadges:
  • AS400 – Files

    I am using one File in Rpgle Program. I am reading the File. In debug mode, I am trying to see all the field values which is in File. But i am not able to see all the field values. I am able to see the field values which i used in program. What is reason for this?

    rajeshece1,230 pointsBadges:
  • Single Page subfile

    hi i am try to create a single page sub file for record updation with option 1-create 2-update when i put 2 in opt. field and press page down then option field showing 2 in every row in sub file please any one help me i am new in subfile programing thanks in advance

    97834441841,465 pointsBadges:
  • AS/400 Source. Physical Files. Key Fields?

    We assume that we have a source physical file from AS/400 about i.e. Amounts. Is there a way to figure out the key fields?

    Deksmark5 pointsBadges:
  • Files

    hai friends, i have PF in this format --------------PF1-NAME R   REC      FLD1      FLD2 ------------------------ FOR LF: ------------------LF1 R   REC   PFILE(PF1) -------------------- My question Is it possible to have some other record format name in my LF??? Example::...

    shyedajmal285 pointsBadges:
  • Read & Write Flat file

    I want to read & write same flat file(CSV).For eg.If I have flat file structure in this way 1'PL','ABC'  2 'PL','DEF'  3'PP','BGC' In this I am reading only PL type of records.If it is PL type like 'ABC'then i am doing some processing & writing 'PL','RIC' record in to the same.After writing the...

    Rr22100 pointsBadges:
  • How can we write an AS/400 subfile program without using any indicators?

    How can we write a subfile program without using any indicators(Even no indicators for SFLDSP, SFLDSPCTL)?

    Vgf5 pointsBadges:
  • Subfile code for AS/400

    In Subfile, OPT   ShipQuantity   QuantityToShip   Item#   CustomerOrder#        ___     ____________   100                  ABC1     CO100010                 ___     ____________   10                    WQE1   ...

    22917560 pointsBadges:
  • COBOL SubFile Processing

    Hello All. I am sure that this question has already been answered somewhere but I am not able to find the answer so please bear with me. My DDS contains 4 records 1) MAP1 RECORD 2)MAP1S SFL 3)MAP1C SFLCTL 4) MAP1S MAP2 RECORD Map1 contains fields that are used to filter the results to be displayed...

    Schue10 pointsBadges:
  • sflend(*More)

    I have an order entry program where the detail is entered at the bottom of the subfile and the More... stays on all the time even when the indicator is on or off. If the file I am reading only has one record in it and my subfile page is 8 and subfile size is 9 the More... still shows. Can anyone...

    filuphaze475 pointsBadges:
  • Embedded SQL in RPGLE hdr, dtl fetch for subfile build

    I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr      E DS                  EXTNAME(wtchdr) D dswtcdet      E DS                  EXTNAME(wtcdet) C     $CreateCsr   ...

    NickHutcheson11,485 pointsBadges:
  • Error handling in as/400 subfile options

    In my Subfile,if i entered invalid Otions,i should get the reverse image on my field(Option),how is it possible... if i use reverse image indicator for that field,i am getting for all the records as reverse image

    22917560 pointsBadges:
  • Problem in writing footer in windows subfile

    hi if i write footer its not getting displayed... write control write footer exfmt control.. i hv coded lik above pls rep as soon as possible

    22917560 pointsBadges:
  • Printer file in AS/400 subfile

    [strong]Hi, I need to generate a separate spool file,I have 10 records displayed in subfile,if i enter option 6 in subfile,for five records,these five records should generate a separate spool file... each record separate spool file[/strong]

    22917560 pointsBadges:
  • Two window AS/400 subfiles problem

    I have a DSPF with 2 subfiles defined as subfile windows. I need to display both of them.. I have got it to work with a full screen but no the wondow subfile. I get a error reading the first subfile. If I switch them around I get one then the other after I hit enter. Anyone have any code that works...

    RonKoontz1,780 pointsBadges:
  • Retrieving remote Files from AS/400

    I'm running SFTP and I just want to receive files that begin with JR. .. I tried using a JR*.* but got everything ... any ideas ? Thanks in advance

    Njsammy5 pointsBadges:
  • Subfile loading procedure

    Hi , I am new to as/00 .I have a doubt in the loading procedure between load all and page-wise?

    assa150 pointsBadges:
  • AS400 Flat file data comparison on Window based third party tool like Examdiff Pro

    My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files.  example...

    Kapiltiwari350 pointsBadges:
  • Subfile in As400

    Hi below pasted is my code which i am running but i am getting an error 'Attemp to write duplicate records" DDS A*                                                        ...

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

Thanks! We'll email you when relevant content is added and updated.

Following