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

    chowas400225 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

    lgronewold5 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,030 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.

    srivijay1145 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,030 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,030 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:
  • Single Page Subfile

    Hi.. I need to create a window subfile in RPGLE, and the subfile field values should be taken from the array which is defined in program itself. Can anybody give me the sample code for this? Surey

    Sureyz2,475 pointsBadges:
  • Use 200-character variable in AS/400 subfile

    Hi.. I have 200 character-length variable (for ex Address) as a field name. I want to use this in a subfile. Is it possible? How? By using sflfold option?

    Sureyz2,475 pointsBadges:
  • Display multiple messages at bottom of screen in AS/400

    I need to display multiple messages at bottom of screen.Is there an alternate way of displaying multiple error messages rather than using message subfile...if so can you give me a simple example

    Ben Rubenstein6,755 pointsBadges:
  • Move values from subfile screen to display file

    I have one display file and subfile. I used load all subfile to load my records in subfile, in that i have one selection filed. My question is if i give "1" in that selection field without pressing "enter" it has to be move values from subfile screen to display file?

    shyedajmal285 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