• Subfile load all & expandable

    Hi , i have some confusion beween load all & expandable subfile, for example in case of load all Pf has 100 records sfksiz=20 and sflpag =10   but if i am writing more then 20 records , but it should allow only 20 records in load all subfile because sflsiz=20 but its allowing to write more...

    Rpgle400tech145 pointsBadges:
  • Load data from two physical files in a subfile

    How to load data from 2 physical files in subfile which have two subfiles in single screen?

    vasanthisrini30 pointsBadges:
  • SUBFILE – To read only the UNCHANGED RECORD

    Hi, please help me with the logic how can I read the subfile when the record is not changed. (The user did not touch or crossed the subfile of particular record). How can I deal with that? After searching, I came to know we can achieve only with SFLNXTCHG keyword. But I don't how to proceed with...

    srivijay1320 pointsBadges:
  • AS/400 subfiles

    It's a general question. I need to update and delete the records in file at a time using subfile screens. Please see the below subfile screen when I'm selecting alternative option and press enter, it's not working. Please advise. Program logic: 0025.00 C     SFLPROCESS    BEGSR 0026.00 C    ...

    chowas400620 pointsBadges:
  • AS/400 subfiles

    Reg subfiles: In a main page,when a press F2 key how to open the new page ? How do I that programmatically and without program? Please advise..(it's an interview question)

    chowas400620 pointsBadges:
  • Reading flat file defined as DBCS

    Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF      ...

    Dodiaz10 pointsBadges:
  • AS/400: Load all subfiles

    In load all subfile i'm loading 100 records and displaying 10 records per page in the screen(i.e, SLFSIZE=100,SLFPAGE=10). But I need to display records from 3rd page onwards..how to do that, can I use SFLRCDNUM in DSPF. Please help me.

    chowas400620 pointsBadges:
  • How to create an AS/400 subfile

    I am trying to create a subfile, so that user can enter in what records they want details for. I keep getting the error Incorrect record number in subfile SFLRCDNBR or SFLSIZ field. What Do I need to do

    lgronewold30 pointsBadges:
  • Flat file or Physical file in as/400?

    How to know whether a file is physical file or flat file in CL/400?

    Alicsc370 pointsBadges:
  • Subfile Identification

    Hi,Is it possible to find out , what kind of a subfile(Load All/Load Forward/Single page) it is? By just seeing the subfile screen itself.

    HABBIE895 pointsBadges:
  • How to insert double quotes in a flat file

    Hi everyone, I want to insert data in double quotes within a single record. Later I want to split it up. Actually I want to insert column headings in flat file like "sr.no","name","product"  later when I open the file in excel file it should get in different columns Thanks

    hunshabbir72,900 pointsBadges:
  • I want to check some fields if any values changes then I write in to another file

    Can you please tell me if can we pass library name as a parameter if I declare same file for both library. It seems if i have a file in library A has a key field num,name,age a nd the file in library B has a same key field it that possible. Please help to do this to get accurate result.

    srivijay1320 pointsBadges:
  • Display fields and subfile side by side

    Hi all I am using V5R1. I have to design a screen where some fields should be on left side and a subfile on right side (both side by side). I have tried a lot but couldn't succeeded yet. I have made two separate record formats one for all fields on left side and the other one is subfile. but when I...

    hunshabbir72,900 pointsBadges:
  • AS/400 Error handling for multiple selection in subfile

    I want to throw error message, when user selects multiple options in a subfile field with '1' as  valid selection. In this for all records in the subfile, I need to select only one record at time, but not multiple records. Suggest any DDS keyword/function which will validate only one selection,...

    poojaary85 pointsBadges:
  • Position to Specific Records in AS/400 Subfile

    Hi! For example when we display the records in a subfile normally it is listing out all the records from the first record of a physical file. In the same, I want to show all the records in a subfile but when they view it, it should show the page related to the current month or date. In my physical...

    Sureyz2,880 pointsBadges:
  • Position cursor when back to subfile

    I have to position the cursor of a subfile in the same field where i am selected after back from some other screen validation. The subfile type is SFLSIZ>SFLPAG . Please help

    Nammy5 pointsBadges:
  • AS/400: Adding a F4 prompt to 2 subfiles over/under

    I am modifying a 2 subfile screen, one subfile over the other. The TOP subfile is using the EXFMT statement while the BOTTOM subfile is a WRITE statement. I need to add an F4 prompt to the BOTTOM subfile using the customer number that was keyed into the TOP subfile to search with. When I key in the...

    UARTJ230 pointsBadges:
  • Pageup and Pagedown in Single page Subfile using SQL

    Hi All, Am looking embedded SQL to do page up and page down. I know this can be achieved with Fetch relative. But somewhere I am missing some logic. Here is my loadsubfile routine logic. First Prepare the SQL string into variable WSQLSTR then c/exec sql c+ PREPARE S1 From :WSQLSTR C/end-exec c/exec...

    RamvishakRamesh2,505 pointsBadges:
  • Design wider subfile in AS/400

    How can I design a wider subfile, meaning I have about 20 fields to show in a subfile with variable length. How I can display them to-gather in a single subfile and implement horizontal scrolling also. Thanks in advance.

    hunshabbir72,900 pointsBadges:
  • Problem with Load Forwarded Subfile.

    Hi,I am new to this technology.Below is My Load Forwarded subfile code.This is just a program to copy more than 9999 records nothing more than that. I was facing some Relational error in the program( Coded in Red colour).it was displaying only first 5 records on the screen. Kindly help me to...

    HABBIE895 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