Nick Litten
Nick Litten
  • 447
  • 1 083 541
Modernize RPG400 to RPG ILE FREE and PF to SQL - 5 - Upgrade Physical Files to SQL Tables
Let's convert our physical file to an SQL Table two ways, once using my toolkit command from PROJEX4i, or for those that don't want to download and install the toolkit onto their IBM i System, we will also use IBM i Access Client Solutions itself. We will check the file record format level ID to prove that the new TABLE looks just like the old PF and all existing RPG code will simply run over the new TABLE without needing any recompiles.
www.nicklitten.com/course/modernize-rpg400-to-rpg-ile-free-and-pf-to-sql-5-upgrade-physical-files-to-sql-tables/
Переглядів: 83

Відео

Modernize RPG400 to RPG ILE FREE and PF to SQL - 4 - Upgrade RPG Subroutines to Sub Procedures
Переглядів 2319 годин тому
Come with me, while we trawl through this old code and update to a newer style of subroutine - the much lauded RPG SUB PROCEDURE
Modernize RPG400 to RPG ILE FREE and PF to SQL - 3 - RPG Modernize to RPG Freeformat
Переглядів 2819 годин тому
Time to dive into the existing RPG400 (Column Based Old Style RPG) and set it FREE. This means using Visual Studio Code, and the Code4i plugin, to automatically upgrade the old legacy code style to modern free format RPG ILE. This does a pretty good job easily upgrading 90% of the code - so come with me while I walk through the code base and manually fix the few lines it couldnt automatically h...
Modernize RPG400 to RPG ILE FREE and PF to SQL - 2 - A Beginners guide to RPG 400 Compile and Test
Переглядів 4621 годину тому
Let's take a deep dive into this RPG400 program to try and figure out how it works. This will mean looking at the file and display setting to understand the relationship with the RPG code. We are going through it line by line to understand it, compile it and test it. After that... then we can look at upgrading the code to modern FREE FORMAT RPG and upgrade the physical file to an SQL TABLE. Put...
Modernize RPG400 to RPG ILE FREE and PF to SQL - 1 - Review PF LF and DSPF
Переглядів 7021 годину тому
Are you a novice IBM RPG programmer, or perhaps just a techno junkie who likes to learn about new programming languages? Then this breakdown of some other programmers old RPG400 file update program might be something that you will enjoy. I hope you do. I get strange enjoyment from playing with chunks of code like this... and figuring out what makes them tick. www.nicklitten.com/course/modernize...
Upgrade from PF to SQL with IBM i RPG Code Modernization
Переглядів 7621 годину тому
Come with me, while I play with someone else's old RPG400 code which performs a *PF file update and allows paging forward and backward through the data... then we will refactor that old ISERIES COLUMN BASED RPG to modern IBM i RPG ILE Freeformat and test it. Assuming that works... then we will upgrade the *PF to an *SQL TABLE and prove that it works with the program without needing any recompil...
Duffin Dagels - Denia's wonderfully ridiculous Dunkin Donuts RIPOFF!
Переглядів 9628 днів тому
In the land of sugary delights, where coffee meets the dawn, Duffin Dagels tiptoes in, a shadow of the Donut’s yawn. Its curves, a mimicry of glazed rings, sprinkled with deceit, Yet whispers secrets only morning birds and bakers greet. But hush! The Dunkin Donuts sigh, their frosting slightly smudged, “Dear Duffin, you’re a flaky fraud, our legacy you’ve nudged. For we are more than sugar hole...
MontePego Breakfast/Brunch Summer 2024
Переглядів 5728 днів тому
Come with us, while we cruise down the slopes of Monte Pego, and head down into Denia Marina for a delicious breakfast at *Julieta en su balcón*
Set the VSCODE IBMi PATH to Open Source Packages on IBM i
Переглядів 135Місяць тому
Setting the VSCODE IBM i PATH to open source packages on IBM i is beneficial for several reasons: Ease of Access: By setting the PATH to /QOpenSys/pkgs/bin, you can easily access open source tools and packages without needing to specify their full paths each time. This is similar to how library lists work on IBM i Efficiency: It streamlines your workflow by allowing you to run commands and scri...
Use an AS400 5250 Green Screen Emulator in VS Code
Переглядів 213Місяць тому
Did I say AS400? /me *slaps myself around the chops* Obviously, I meant an IBM i 5250 Green Screen Emulator Learn more at www.nicklitten.com/course/5250-green-screen-terminal-in-vs-code/
What is a subfile? An overview of AS400 iSeries and IBM i display file subfiles.
Переглядів 2052 місяці тому
An IBM i subfile has the same setup as previous generations of AS/400 and iSeries. A subfile is a powerful feature that allows you to display and manage multiple records on a single screen. Let me break it down for you: Purpose of Subfiles: Subfiles are used to present a list of values or records to the user. They allow you to handle multiple records of the same type on a display screen. You ca...
MontePego, Trash Runs, Hungover Coffees and Happy Sandy Dogs
Переглядів 1134 місяці тому
Come with use as we drive down MontePego to drop off the trash and head out for a quick coffee, dogs in tow. Then down to El Verger for a little beach fun with our furry friends. Life in #MontPego is pretty pretty good on Sunny Spanish April Mornings. ps: that little orange motor is the Renault Kangoo BeBop (with its most excellent convertible roof)
RPG 101 Ep6 - Tweaking Hello World to make it a bit more fancy
Переглядів 2685 місяців тому
RPG 101 Ep6 - Tweaking Hello World to make it a bit more fancy
IBM i PDM 101 Ep4 Working with PDM User Defined Options
Переглядів 1495 місяців тому
IBM i PDM 101 Ep4 Working with PDM User Defined Options
IBM i PDM 101 Ep3 - Working with PDM Members in Files
Переглядів 1165 місяців тому
IBM i PDM 101 Ep3 - Working with PDM Members in Files
IBM i PDM 101 Ep2 Working with PDM Object in a Library
Переглядів 1195 місяців тому
IBM i PDM 101 Ep2 Working with PDM Object in a Library
IBM i PDM 101 Ep1- What is the Programming Development Manager
Переглядів 1555 місяців тому
IBM i PDM 101 Ep1- What is the Programming Development Manager
RPG 101 Ep5 - Modern RPG deserves a Modern Code Development Environment VSCODE
Переглядів 5645 місяців тому
RPG 101 Ep5 - Modern RPG deserves a Modern Code Development Environment VSCODE
RPG 101 Ep4 - Finally stepping up to a modern RPG Free Format Layout
Переглядів 1485 місяців тому
RPG 101 Ep4 - Finally stepping up to a modern RPG Free Format Layout
RPG 101 Ep3 - Setting legacy RPG Free
Переглядів 1345 місяців тому
RPG 101 Ep3 - Setting legacy RPG Free
RPG 101 Ep2 - Tarting up the old fashioned AS400 RPG to iSERIES RPGLE Hello World Example
Переглядів 2115 місяців тому
RPG 101 Ep2 - Tarting up the old fashioned AS400 RPG to iSERIES RPGLE Hello World Example
RPG 101 Ep1 - Basic old fashioned AS400 RPG Hello World Example
Переглядів 6135 місяців тому
RPG 101 Ep1 - Basic old fashioned AS400 RPG Hello World Example
Converting IBM i Physical Files to SQL Tables
Переглядів 2695 місяців тому
Converting IBM i Physical Files to SQL Tables
Upgrading RPG Column Based to Free with VS Code for IBM i
Переглядів 1595 місяців тому
Upgrading RPG Column Based to Free with VS Code for IBM i
Moli Del Pas, OntinYent -- Uncle Dave's Thanksgiving Dinner
Переглядів 1478 місяців тому
Moli Del Pas, OntinYent Uncle Dave's Thanksgiving Dinner
Testing IBM i IWS Integrated Web Server with SOAPUI
Переглядів 3339 місяців тому
Testing IBM i IWS Integrated Web Server with SOAPUI
Setup IBM i IWS Integrated Web Server
Переглядів 4899 місяців тому
Setup IBM i IWS Integrated Web Server
SUPERSIMP - Compile the Simple RPG Webservice Program
Переглядів 1489 місяців тому
SUPERSIMP - Compile the Simple RPG Webservice Program
SUPERSIMP - Simple RPG Webservice Program
Переглядів 2269 місяців тому
SUPERSIMP - Simple RPG Webservice Program
Enable RPG formatting in Visual Studio Code for IBM i (aka linting)
Переглядів 61810 місяців тому
Enable RPG formatting in Visual Studio Code for IBM i (aka linting)

КОМЕНТАРІ

  • @s.b.8704
    @s.b.8704 5 днів тому

    The way I would explain indicators to someone completely new to RPG is that they are predeclared boolean variables. The RPG program cycle instead is similar to AWK implicit main loop. These analogies might help someone grasp these two concepts more quickly.

  • @BeastGamingCorner
    @BeastGamingCorner 6 днів тому

    I have worked for 12 years on IBM AS 400 , RPG IV, FREE, RPG ILE, I am finding a freelance remote job. Backup and restore whole system also.

    • @NickLitten
      @NickLitten 6 днів тому

      @@BeastGamingCorner good luck senor!!

  • @BeastGamingCorner
    @BeastGamingCorner 6 днів тому

    I have worked for 12 years on IBM AS 400 , RPG IV, FREE, RPG ILE, I am finding a freelance remote job. Backup and restore whole system also.

  • @MichaelDelk
    @MichaelDelk 7 днів тому

    Making progress, converting ERPs in the wild from DDS to SQL, with bonuses of journals. Woot!

  • @tonywhite6107
    @tonywhite6107 9 днів тому

    1st one in.

    • @NickLitten
      @NickLitten 6 днів тому

      Strictly speaking... I was ;)

  • @PixelOutlaw
    @PixelOutlaw 12 днів тому

    So the only editor on the system is hostile towards working in current versions of IBM's own RPG. Hardware aside, it seems like IBM really only cares about collecting fees from long standing captive businesses. Given the limited utility of SEU they either want to bleed you for "Rational" Developer yearly or force you to just write RPG like it's the 70s. It would have been nice to have an editor like Vim or Emacs which have been ported to MANY systems even text only environments. Sadly you probably can't call them from the POSIX side to edit source members on the IBM side.

    • @NickLitten
      @NickLitten 6 днів тому

      True... IBM sells "IBM Rational Developer" an IDE based on ECLIPSE. They moved away from a native terminal based editor to a richer Interactive Developer Environment. But... But... the fact that it's an expensive tool and not included with the OS is ridiculously bad marketing.

  • @naveedshaikh8408
    @naveedshaikh8408 23 дні тому

    Fantastic!

  • @Jimi-bx3xf
    @Jimi-bx3xf 29 днів тому

    Hello nick i try to test httpapi i'm using pub400 but i can't create a lib on the machine.

    • @NickLitten
      @NickLitten 29 днів тому

      @@Jimi-bx3xf raise a support ticket on my website and we can talk .. see if I can help you

  • @bernardjoseph6094
    @bernardjoseph6094 Місяць тому

    so my question has noting to do with actjob, but with printer, my writer keeps ending randomly after it was recreated from a copy, and name changed to the original name. can you put me on the right track?

    • @NickLitten
      @NickLitten Місяць тому

      @@bernardjoseph6094 sounds like a hardware problem on the printer. Powered off? Losing comms?

  • @matthewjohnston1602
    @matthewjohnston1602 Місяць тому

    Hey nick. When dealing with multiple logins (employees), F3 view will not display the employees names/numbers. Is there a history or way to display everyone logged into a resource, or is that only available when enabling screen history? Thanks, I’m stumped so hard

    • @NickLitten
      @NickLitten Місяць тому

      You can use WRKACTJOB and qualify the subsystem to see which users are logged in.. or possibly define each users name as their workstation name within ACS? Then just add the workstation entry to the subsystem they will log into...

  • @LittleB612
    @LittleB612 Місяць тому

    This video was soooo helpful !! Thank you soooo much!

  • @daddytazflRG
    @daddytazflRG 2 місяці тому

    put the towel down !

  • @approvalguy9389
    @approvalguy9389 2 місяці тому

    Hi Nick, Awesome video! how can I not send customer to WordPress login when they forget the password? thank you

    • @NickLitten
      @NickLitten 4 дні тому

      Add a redirect www.hostinger.com/tutorials/fix-wordpress-login-redirect-loop

  • @Joaorferreira
    @Joaorferreira 2 місяці тому

    Hi Mr. Litten, I have no words to thank you on this video that is helping me to start studing RPG. I worked as consultant for a software company, and now I am managing a Bank application written complettly in RPG. In 15 years my company never given me the oportunity to learn this program languange, but my curiosity made me go further. I am now gathering information to start a beautiful journey trhough RPG knowledge and I am counting with your amazing videos! Thanks a lot!

    • @NickLitten
      @NickLitten 2 місяці тому

      Delighted they help!!

  • @irajaghakhani2145
    @irajaghakhani2145 2 місяці тому

    Hi Nick, Awesome video! Unfortunately, when I tried to add the plugin to my site, as soon as I uploaded it, my page stopped scrolling up or down, is it possible is plugin casing this problem?

  • @dreytonthibodeaux2767
    @dreytonthibodeaux2767 2 місяці тому

    Currently learning a lot of old style columnized RPG to help my company. Graduated college about a year ago, learning to take over some legacy code. Could you go over some more old-style columnized code? Not super in depth or anything, i know that would be a hassle, just some of the most common usage/errors? if not, no big deal, im currently doing your course on VSCODE with rpg as well. youre the man!

    • @NickLitten
      @NickLitten 4 дні тому

      I'm adding all the time... if you have a specific old program you would like me to talk through... just raise a ticket on the website and email me the code.

  • @jarrellstrempel
    @jarrellstrempel 2 місяці тому

    Can this version of ACS work with an AS400 running R4v5m0? We are replacing the AS400 with Power10 and I cannot get ACS to work with the AS/400.

    • @NickLitten
      @NickLitten 2 місяці тому

      V4r5 for the old AS400 was released in 2000 - so it's 24 years old LOL. I have no idea... You might be best sticking with the old client access version you can download it from the DLS share on the as400?

    • @MasonPirk
      @MasonPirk 13 днів тому

      @@NickLitten Yeaaah I am finding this out myself the hard way lol. I got an old Power5 system i 520 to play with and ACS does not like the ancient security protocols and certificates. Its setup to run through the virtual console over LAN only so I am hosed until my old disc copy of access for windows shows up. Hoping that works and I can set up 5250 sessions then actually use the damn thing.

  • @RickyThompson
    @RickyThompson 2 місяці тому

    One I would love to see is a one page at a time subfile that is all written in SQL that has pageup/page down and position to and also allows to select edit/delete from multiple pages. I've written a skeleton one that I use but it has it's own quirks. I basically save all the select options to a data structure along with a key so that I can reload and save the selection options. But I would like to see others techniques but this might not be something anyone else is interested in. Just looking for best practices.

    • @NickLitten
      @NickLitten 2 місяці тому

      I can do that! I've added it to the top of my "record a thing" list. Check back later this week...

  • @daquanlamar4752
    @daquanlamar4752 2 місяці тому

    Please don’t kill this series, I’m currently being hired to be our company’s new 400 programmer, I’m 24 and have no experience, so so far you’ve been a life saver

    • @NickLitten
      @NickLitten 2 місяці тому

      If you have specific questions or topics you'd like me to cover go and leave a support ticket on my website nicklitten.com 👍

  • @thomashutson7205
    @thomashutson7205 2 місяці тому

    Fine Ass you

  • @BG5850
    @BG5850 3 місяці тому

    Nick, did you not make a part 2? I see the next video skills to Showing proton in use?

    • @NickLitten
      @NickLitten 2 місяці тому

      ua-cam.com/video/mvdx8EfCcB8/v-deo.html

  • @demtron
    @demtron 3 місяці тому

    I worked for the Cleveland School System. We got our first AS400 (9406-640) in 1998 in preparation for Y2K. It replaced an IBM 3090. We started off on V4R3 and when V4R4 was released we were able to LPAR the system and carve out a development system. This was before the Hardware Management Console. You had to IPL the primary partition and from the primary partition you could bring up or take down the secondary partition. The secondary partition could not run alone. Our system also contained a Power PC card that allowed Windows NT to run on it. This required a secondary monitor, keyboard and mouse to be connected directly to the PC card. The AS400 at the time could handle up to 4 PC cards. Later the 640 was upgraded to a 730. The 730 was eventually replaced with the IBM I. We made it as far as V5R4 before we ran into a snag. V6R1 required a recompile of code and we had many mission critical code that we did not have source code for. The software vendor that supplied and maintained the code went out of business,. so by 2018 we have for the most part moved off the I series platform to software as a service in the cloud. The hard drives were RAID 5 so if a drive failed the data did not have to moved. It will report the issue to IBM and your CE would show up with part. Once the new drive was installed (it had to be same size) the system would rebuild the drive. This only worked this way if only 1 drive failed in a RAID set. If more than one drive failed in a set you were sunk and had to do a full restore. This was because the OS saw all the hard disk storage as one big pool or one big disk drive even though at the hardware level it was not. Having started on an IBM 3090 Mainframe MVS, CIICS, ROSCOE, CA/Ideal, CA Datacom environment and moving to the AS400. The AS400 required a whole lot less of IT Operations support.

  • @KennyLeeJS
    @KennyLeeJS 3 місяці тому

    shouldn't you be censoring some of the information on screen?

    • @NickLitten
      @NickLitten 3 місяці тому

      After nearly 4 years.... Nope 😅

  • @EricFacundoQuiroz
    @EricFacundoQuiroz 3 місяці тому

    Im sorry, which plugin i need to install to get that "Convert to rpg free"?

    • @NickLitten
      @NickLitten 3 місяці тому

      www.nicklitten.com/course/what-is-the-visual-studio-code-extension-for-ibm-i/

    • @EricFacundoQuiroz
      @EricFacundoQuiroz 3 місяці тому

      @@NickLittenYeah i did install that, but when i select a block of code in rpg ILE it doesnt work... it does not show the option, do i need to do something more? maybe a hiden setting? or it only works when you select a whole program and not just a block of code? because my example program its a mix between rpg free and ILE

  • @EricFacundoQuiroz
    @EricFacundoQuiroz 3 місяці тому

    Not the white as400 background 😭. Ty so much by the way!

    • @NickLitten
      @NickLitten 3 місяці тому

      White background matters lol

  • @travisirish6322
    @travisirish6322 3 місяці тому

    What was it song before?

  • @TheRafagomez62
    @TheRafagomez62 3 місяці тому

    Your video is very interesting but How could you keep the same level identifier in the new table? Thank you so much

    • @NickLitten
      @NickLitten 2 місяці тому

      Converting and compiling a DDS PF as a SQL TABLE has the exact same record format ID. No level checks and works with all existing RPG programs... :)

  • @jemyrjohnanover
    @jemyrjohnanover 3 місяці тому

    Hi after issuing the command STRTCPSVR SERVER(*SSHD) I got this error message "STRTCPSVR ended abnormally. Reason code is 0005" Do you know why I'm getting this error message and how I can solve this. Thanks in advance

    • @NickLitten
      @NickLitten 3 місяці тому

      From IBM "...The error message "STRTCPSVR ended abnormally. Reason code is 0005" when starting IBM i may indicate that the server program or library is incorrect or that the user doesn't have proper authority to it."

  • @Joaorferreira
    @Joaorferreira 3 місяці тому

    Thks a lot Nick!! Very useful!

  • @vividstudio4651
    @vividstudio4651 3 місяці тому

    Some folk do like watching a dude natting away while multitasking an in install and tryout.

    • @NickLitten
      @NickLitten 2 місяці тому

      Strange but true LOL

  • @vercnockekooy9508
    @vercnockekooy9508 3 місяці тому

  • @winwithchristina
    @winwithchristina 3 місяці тому

    Nick, this video was excellent and very helpful. Thank you!!

    • @NickLitten
      @NickLitten 2 місяці тому

      Glad it was helpful!

  • @chub89s79
    @chub89s79 4 місяці тому

    Lucky dog! lol

  • @skyandgavinvlogs4534
    @skyandgavinvlogs4534 4 місяці тому

    How to unmerged gmail from proton?

    • @BG5850
      @BG5850 3 місяці тому

      Don’t

  • @MAE-yg8bf
    @MAE-yg8bf 4 місяці тому

    Bon apppetit.!

  • @unboxingreviews5327
    @unboxingreviews5327 4 місяці тому

    thanks Nick very straight forward i am too from AS400 domain and found this very Helpful

  • @Leedoggie6677
    @Leedoggie6677 4 місяці тому

    Tom Ford’s Tuscan Leather or Ombré Leather smells amazing. Get you some! You deserve it!

    • @NickLitten
      @NickLitten 4 місяці тому

      I've smelt some great Tom Ford - will deffo check those out :)

  • @sergioarguedas5068
    @sergioarguedas5068 4 місяці тому

    Wow

  • @mxxt2554
    @mxxt2554 4 місяці тому

    Thanks a lot Nick for sharing your knowledge to the world. It is indeed very insightful. I was wondering if you would share some knowledge/tool on how to automate file transfer from windows to ibm i IFS. Wanted to know how to avoid user intervention and automate the whole process. Thanks!

    • @NickLitten
      @NickLitten 2 місяці тому

      simply use the CPYTOIMPF command - this will copy any TABLE or PF to an IFS file location (and even allow you to convert to spreadsheet format)

  • @NathanLitten
    @NathanLitten 4 місяці тому

    Your video editing has improved a lot dad. I enjoyed this.

  • @finleyl.2822
    @finleyl.2822 4 місяці тому

    "In case you were wondering, it was poop time for the dogs, not for me." Jealous of the coffee 🥺

  • @AngelVillar-do7ch
    @AngelVillar-do7ch 4 місяці тому

    😍😍😍😍😘😘😘

  • @AngelVillar-do7ch
    @AngelVillar-do7ch 4 місяці тому

    😘😘😘❣️❣️

  • @AngelVillar-do7ch
    @AngelVillar-do7ch 4 місяці тому

    ❤❤❤

  • @filippyknow
    @filippyknow 5 місяців тому

    You are hero! Thanks Nick!

  • @chrislaw4958
    @chrislaw4958 5 місяців тому

    Thanks. I've been looking for videos of 955 fuel pump installation.

  • @djust270
    @djust270 5 місяців тому

    I was so confused, I thought RPG referred to "Role Playing Game". I got halfway through the video and was thinking, this is the strangest video game I have ever seen.

  • @user-nk2kw6pe2w
    @user-nk2kw6pe2w 5 місяців тому

    Shall we work DBMS and Object Oriented software engineering in IBM Rational

  • @isriwong
    @isriwong 5 місяців тому

    How can IWS enable SSL