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

    HABBIE820 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

    hunshabbir71,580 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...

    hunshabbir71,580 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,430 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.

    hunshabbir71,580 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...

    HABBIE820 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,430 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,430 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,065 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:
  • Filter records with a certain value in AS/400 subfile

    did the above steps but its not working… Example:: —————————————– FLD1 FLD2 FLD3 AAA AAAA AAAAA AAA AAAA AAAAA AAA AAAA AAAAA rrn = 3 —————————————– BB ______ _________ I need to filter the records having the value BB, but there are no...

    shyedajmal285 pointsBadges:
  • How to toggle between two columns in a subfile

    I want to toggle between two columns in a subfile...I'm using following code to condition the fields...however when i display subfile none of the fields are displayed...is there anything else i need to take care of?A #PROCP 8A O 6 22 A 15 DSPATR(ND) A #ORDERP 8A O 6 22 A N15 DSPATR(ND) ---------- C...

    Nutangujar895 pointsBadges:
  • How to remain on same page on Load All Subfile

    I am using Load All Subfile. I used Page Down key and went to 2nd page then on 2nd Page I pressed ENTER Key, then it went back to the first page of subfile. I am using COBOL program to write the subfile. Can anybody tell me how to remain on the same page after pressing ENTER key on Load All...

    Vids295 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