• How do I create a subfile which has fields in the SFL Record Format with different attributes?

    I need to design a subfile which takes the field name and attribute as the *entry parameter and then based on that field a specific file will be read and the detailed record will be shown in the subfile screen. The issue is each time the field name & attributr may differ, so accordingly how do i...

    PRIYAS40 pointsBadges:
  • subfile

    I have created a message subfile but my code is not moving the error message to the display file.I did a debug and found that the write msgctl statement is executed but nothing is being written.Wat could be the possible reason

    0 pointsBadges:
  • How to view online the new data added to a PF?

    Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!

    Mariodlg2,790 pointsBadges:
  • Fold/Drop

    I have a dds in which the subfile record spans several lines of the map. I need to display the first three lines and truncate the rest using a function key to display the rest. Truncation occurs after one line when using fold/drop. Is there anyway to change where there truncation takes place?

    Schue10 pointsBadges:
  • Can any one give detailed functionality of SFLRCDNBR

    I would like to know the fuctionality of the SFLRCDNBR. Can any one help me in this regards ? Eg: When I am using Load All Subfile programming I have 1000-records, page size-5. Now I am at 200th record , when I will take enter, it goes to 1st record. I hope in this case only we can used SFLRCDNBR....

    Zilan85 pointsBadges:
  • AS/400 – Subfile

    I have a SFL that has drop/fold capability. The problem is when the SFL goes into drop mode, additional fields/records needs to be displayed, how can I display those fields/records? Currently it is displaying only one record.

    Kundankumar 8375 pointsBadges:
  • AS/400

    Hi, Whre we can use SFLNXTCHG?why we want to use this?

    Icc10 pointsBadges:
  • AS/400 SFLNXTCHG

    Hey this is venkatesh.Please can any body tell me what is SFLNXTCHG?where we use this keyword?what perpuse we use this?Can you tell me in real time senario with example? And in 7 specification(RPG/400)what is the mandatory specification using programs?

    Thara15 pointsBadges:
  • Positioning Cursor in Subfile

    I can use the SFLRCDNBR(CURSOR) keyword to position the cursor on the correct subfile line that I want, but can I then get it to position on a particular field ? SFLRCDNBR(CURSOR) defaults to the first input capable field. DSPATR(PC) seems to override the SFLRCDNBR keyword; therefore I lose the...

    Modiyooch540 pointsBadges:
  • SQL Subfile and position to ability

    I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile. I want to be able to allow the user to enter position to information, and position to that entry - normally, I would do a SETLL to the file based on...

    Klw50 pointsBadges:
  • SUBFILE

    I read opt(options) in the subfile. If all the entered option is valid(i.e 1) then i have to write the record into PF else not. I read subfile by READC first till EOF. then i set RRN=1 and then inorder to update again i use READC. but when it reach DOW NOT%EOF it come out of the loop. si i could...

    Minuvinu35 pointsBadges:
  • handle page down in load all subfile

    After doing a position to in my subfile, all the page displays the last record, i still get "More." message. How to get rid of this message

    RSK5 pointsBadges:
  • Subfile Interaction with other Display Files

    I am trying to write my first subfile program. I thought I could use a subfile to display a file and allow users to select a record from that file to update a field in another file. In my case I'm maintaining client data and have a file with languages (English, Spanish, etc). I would like to user...

    Kellab575 pointsBadges:
  • AS/400:- How to select records to be displayed in subfile

    Dear All, Thanks to all your inputs. As some of you suggested, Earlier I have used SQLRPG & achieved the result by dynamically building the SQL Query string. but now they want to scrap the SQL because they say it's a performance issue(i.e. it slows down the system & a over head on it). Now what is...

    svankipu560 pointsBadges:
  • RPG/400 – Window Subfile

    I want to display a footer on a window subfile. I have used a window subfile which displays a list of codes. And want to have a footer on this window. For this I used a simple WINDOW having the same border formats and position as that of the Window subfile - this contains just one line at the...

    Kundankumar 8375 pointsBadges:
  • SFL Conditioning

    I have a subfile data entry screen where a user needs to enter data into several fields. There is a subroutine that checks for both entry and valid data for each field. Indicators are supposed to color, position the cursor and reverse the specific field if the field does not pass verification yet...

    Floyd02320 pointsBadges:
  • RPG – Subfile – Read using RRN

    Is it possible to read a subfile record if its RRN number is known? In my case, when on a subfile record, if F4 is pressed a Prompt window is displayed to list codes. When a code is selected I want this selected code to appear in my subfile record for which the F4 was pressed. In my case I have RRN...

    Kundankumar 8375 pointsBadges:
  • AS/400:- I need to build a query to select records, to be displayed in subfile

    The requirement is basically:- 1) I have a screen with some "FROM" and "TO" fields(see below:) -------------------------------------------------------------------------------------------------------------- Select: From To ------------------------------ ----------- ----------- Fax Referenece Number:...

    svankipu560 pointsBadges:
  • single page subfile

    Hello friend, Currently i m learning as/400.i am confidence when i make load all subfile and expandable subfile...but when i go for single page subfile...i always stucked....i dont understand..page up and page down subroutine.....if anybody hv full progrm for single page subfile plzz mail me.... my...

    Swapniln35 pointsBadges:
  • Multiple Sorts Without Using Multiple Function Keys

    When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act like that in...

    GHENDER190 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