Introduction to Single Page Sub file in IBM i

This video explains the logic of single page sub file. You can understand the logic of it by debugging a existing program .

[@yusy4code]

The source code is available here for reference. Do let me know if we can make another video to write the code from scratch. drive.google.com/uc?authuser=0&id=1VHeohKiGEqNPyEyuQHjrdoFSoEehIgOU&export=download

[@Jimi-bx3xf]

Hello but your code lack of explanation... only two files i suppose the dspf and the rpgle... where is studpf ?

[@rutnaja7272]

love you Yusuf

[@sbmahapatra]

Excellent video Yusuf. No words. Thank you very much!!!

[@brijeshroy3182]

Sir why are you running for loop in pageup from 1 to sflpag+1 , in this manner it will load 9 values ??

[@ARVINDKUMAR-sn7kv]

Very useful Video.

[@sbmahapatra]

Hello Yusuf, Thank you for the very helpful video. Any idea why are you using *IN in this line "0009.01 D IndAddress S * INZ(%Addr(*IN))"? Thank you again!

[@yusy4code]

In our program we use indicators. We have 1-99 indicators in RPG program and that can be accessed via syntax *IN01 to *IN99. Here we are pointing to the memory location of the indicator. These indicators memory location are sequentially located in IBMi memory. So %Addr(*IN) will give us the first address of the indicatory (which is *IN01) and we assign that value to our variable IndAddress pointer variable. Then we created another data structure based on this pointer variable so that this data structure can contain fields inside which can be mapped to the indicator based on the position. more info: www.itjungle.com/2012/09/19/fhg091912-story01/

[@tanujmayank8529]

thanks very useful . Can you please give some example when to use which type of subfile , I mean when to use single page subfile or when to use load all subfile etc .

[@anjitsingha]

What is INPSTUD in the program? I know its a silly question but I am very new to RPGLE and Subfile.

[@yusy4code]

It’s input field name in our DSPF. Whatever user enter on that , the value will be available in our program for accessing.

[@anjitsingha]

@@yusy4code Thanks Yusuf. A big thums up👍

[@siliverusatyanarayana2042]

Very useful if it possible please make a video from scratch

[@sbmahapatra]

Guys, could you please provide the link for Single Page Subfile from scratch?

[@SanojKumar-iq9xm]

Hi Yusuf your all videos lecture is awesome , could you please make video on expandable subfile ?

[@yusy4code]

Will plan for it. Thanks

[@Prirowdy]

Hey Yusuf great work!! It helped in understanding single page subfiles ...But if you make another example from scratch that would be more helpful.

[@yusy4code]

Thanks for your feedback. I will try to make a video soon on single page subfile from scratch.

[@sanalmoh]

@@yusy4code Could you please provide the Video link for single page subfile from scratch ?

[@vandana9738]

If we want to display more than 9999 records then which subfile we should use?

[@yusy4code]

We can use single page subfile for this.

[@kaattupoochi5992]

What if the First_rec value is all same...say example....I read a logical file based on student id...I retrieve 100 records for that student id and do page down for 5 times...in that case how will I do setll student_id studfile; in page up section...it will automatically point to very first record of the file....pls help with this.

[@yusy4code]

In single page subfile, we do not need to setll student_id for page up. For page up and page down we need to use ReadP and Read. Setll will come into picture only if we have position to or search by student option. So if i want to position to particular student then setll student_id will be used and it will point to very first record of that student is correct.

[@priyanka2653]

Thank you for this video..Can we write single page in sqlrpgle? If yes can you please guide me how ?

[@balachandrann8140]

Great Yusuf

[@yogmahirazz]

Hi Yusuf...Is there any trail version of as400 software available where we can practice code at home ??? ...please suggest

[@yusy4code]

There is a option of getting 3 month subscription for 25$ from TexAS400 texas400.com/as400account.html

[@salmanbagwan6746]

T U sir, Can you please give videos related to message subtile and windows subfile.

[@GutchAlex]

I enjoyed the session, can you in the future export the code to GITHUB so we can download thanks

[@yusy4code]

Thanks for the suggestion. I will post the codes in Git for future reference.

[@carefree_ladka]

Can you write from scratch Yousuf? Thanks btw for all videos 🙂

[@yusy4code]

Will plan for it