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

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

    chowas400585 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)

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

    chowas400585 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

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

    HABBIE845 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,630 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.

    srivijay1190 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,630 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,475 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...

    UARTJ105 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,630 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...

    HABBIE845 pointsBadges:
  • Searching a field in Load-all Subfile

    Hi, I am trying to display the contents of tables present in a library. The contents of tables will have the following details 1. Count of records 2. File name 3. Last change date 4. Last change time There can be around 3000 files in this library. I have used Load all subfile Is it advisable to use...

    Prashanth123255 pointsBadges:
  • Query on Subfile

    Have Display File - Subfile with Few Numeric Fields. SUBSIZ = 45, SUBPAG = 10. In RPGLE, Getting to Value from another Data Queue, Writing in to the Subfile if Record if there and incrementing the RRN and Line Number. Writing in to Subfile even there is no record in Data Queue. Here incrementing...

    rajeshece1,215 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