WrtSFL : Write complete Subfile code in less than 20 seconds.

Description
This utility can write Subfile code for any given SQL select statement with little or no user interaction. It takes less than 20 seconds to write complete Subfile code. Check video at top/bottom of this page for more details.

Main features:

  1. Very easy to use interface.
  2. Write Free format code.
  3. All DB operations are SQL based. No native I/O(F-Spec).
  4. All three type of subfiles are supported.
  5. No dummy variables names.
  6. Write  code with named indicators only.
  7. Final code is well formatted with proper indentation.
  8. Code generated is highly readable and very easy to understand and modify.
  9. Message subfile will be created for message handling.
  10. And much more…..

You can report a Bug in comment section or send a mail to onlysumitg@gmail.com.

Please check change log latest bug fix.


SAVF Download Link : 

Download “WrtSFL 1.1.0” WRTSFL-3.zip – Downloaded 6454 times – 4 MB


PLEASE FOLLOW THESE STEPS after Download

On your PC
— Unzip this zip file and Upload to IBM I(Iseries/AS400)

On your IBM I

  1. RSTLIB SAVLIB(SUMITG) DEV(*SAVF) SAVF(*LIBL/WRTSFL)
  2. Use menu QSYS400 or command WrtSFL

Notes:
– The save file can be deleted after the RSTLIB is complete.
– LIB SUMITG can be renamed to any LIB name as per requirement.

Please send any feedback on to:
Sumit goyal
onlysumitg@gmail.com


Videos for more details:


CHANGE LOG:

Release Date/Time Version: Change Details: Supported IBM i OS version: Expiry date:
07 Feb,2018 1.1.0 Stable Minor Bug fix
V6R1M0 and later only
30 June, 2020
16 June,2017 1.1.0 Stable V6R1M0 and later only 30 June, 2020
28Aug 2016 11:00PM  1.0.2 BETA version

  1. Now Option field in SFL is configurable.
  2. Minor Bug fix
V6R1M0 and later only 30 June, 2017
20June 2016 7:00PM  1.0.1 BETA version

  1. CCSID issue fixed (hopefully 🙂 )
  2. Hidden field issue in ADD and CHANGE Screen.
V6R1M0 and later only 30 August, 2016
19June 2016 7:00PM  1.0.0 BETA version V6R1M0 and later only 30 August, 2016

ALL SOFTWARE IS PROVIDED “AS IS” WITHOUT ANY WARRANTY OF ANY NATURE WHATSOEVER. THE PROVIDER OF THIS SOFTWARE HEREBY DISCLAIMS ALL WARRANTIES, REPRESENTATIONS, AND CONDITIONS, STATUTORY OR OTHERWISE, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO WARRANTY OF TITLE AND THE IMPLIED WARRANTY OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE PROVIDER SHALL NOT BE LIABLE FOR ANY DAMAGES ARISING FROM OR AS A RESULT OF YOUR USE
OF THIS SOFTWARE. USE IT AS YOUR OWN RISK.

18 Replies to “WrtSFL : Write complete Subfile code in less than 20 seconds.”

  1. One of the best utility needed for RPG programmers, saves a lot of time creating screens. Good thing also is using new RPG functionality. Congrats Sumit, thumbs up

  2. Very Nice Tool Sumit your are simply superb and all the best for your future projects which will be a great help for iseries guys.

  3. I am currently IBMi Server Administrator, but I still write some RPGLE code for a few applications. I have used RPGLE and Lansa(DB and Code Generator) for many years.

    I was very impressed with the results from this tool, generating SQLRPGLE, by just pasting SQL Select statement! The amount of functionality and the readability receives high marks. I regenerated my programs multiple times until I as good with the results. Then, it was easy to add parameter passing code to link these programs together.

    Sumit, thanks again for allowing me to review this tool! One of the best tools I used in the last few years!

    Thanks!
    JP Jones
    IBMi Server Administrator
    Cascadia Behavioral Healthcare

  4. Sumit hi,
    Everybody keeps congratulating you and only I encounter problems…. 🙁
    I want to send you the relevant Joblog so you’ll be able to see for yourself where lies the problem.
    How can I do it ?
    By the way, I saw that at some point you perform “CHGJOB CCSID(273)”.
    What’s the reason for it ? Because OUR CCSID is (for example) 424.

    1. Moti .. After upload the SAVF please run these steps

      On your IBM I

      RSTLIB SAVLIB(SUMITG) DEV(*SAVF) SAVF(*LIBL/WRTSFL)

      ADDLIBLE LIB(SUMITG) POSITION(*LAST)

      CALL SUMITG/RESET PARM(‘SUMITG’)

      PARM is LIB NAME where ALL the Objects are restored.
      Use menu QSYS400 or command WrtSFL

  5. It is a very impressive program. Not only to save time creating screens but also I learned a lot of new things about the source code generated by this tool.

  6. Hi Sumit I’m Not having the authority to do the RSTOBJ or RSTLIB.
    Can you please upload the necessary source files in Notepad, so that i can ftp them to my System and will recreate them?
    Thanks In advance.

  7. It looks very nice but i can’t test it, we have only iseries with v5r4m0.
    Would it be possible to have a version for v5r4m0?
    (SAVLIB with TGTRLS value to V5R4M0)
    Thanks in advance.

    1. I am Sorry John. There is some SQL stuff which is not compatible with V5R4M0. So SAVLIB with TGTRLS value to V5R4M0 can not work.

  8. Hello, Sumit! Great idea, wonderful tool!
    Could you please load the sources too? I would like to make it full free-form (H, F and D-specs too) and also translate the DSPF generated constant text in my language.
    Best regards.

  9. I met Sumit online while using his RPGLE tool “WRTSFL”, which is a genius product if there ever was one. I had an issue and he responded right away. After connecting thru gotomeeting. He found the problem was due to a change on my system that affected submitted jobs and associated library lists. He had new code to me the same day to prevent a repeat of my issue.
    With everything Sumit had on his plate, he was very professional and fixed my issue. Thank you Sumit.
    I would highly recommend Sumit for further technical work on IBM i systems.

  10. Absolutely love the utility. You rightfully should take pride in the ease of use. Out of curiosity, would there be any way that I could get access to and modify your source (on our system only, of course) to adjust some aspects to fit our needs? We have certain naming conventions and case standardization that we need to abide by, and I find myself doing a lot of refactor-rename in the created RPGLE and DSPF files. I 100% understand if you would not be willing to give up the source. I will live with the additional time spent modifying the code to meet our standards each time, but I thought I’d give it a shot, if only to save me some time in the future (the goal of this utility!).

    Thank you again, Sumit. Great work.

  11. Hi Sumit,

    I downloaded your tool which seems very interesting but unfortunately is get stuck when trying to generate the display file/program. We are running 7.1

    Any idea?

    1. Hi Sumit,

      I downloaded your tool which seems very interesting but unfortunately is get stuck when trying to generate the display file/program. We are running 7.1

      Any idea?

      Never Mind, I granted myself all permissions and now it works. Going for the details now.

      Thanks a lot

Leave a Reply

Your email address will not be published. Required fields are marked *