Nick Litten
Nick Litten
  • 448
  • 1 088 725
Subscriber IBM i DDS to SQL Conversion #QandA
Sometimes it's easier to show you how to do something than write a thousand words in a blog :)
In this little video, I take a real world sample of an old *PF and upgrade/modernise it into a SQL TABLE www.nicklitten.com/converting-an-old-pf-to-a-shiny-modern-sql-table/
zhlédnutí: 96

Video

Modernize RPG400 to RPG ILE FREE and PF to SQL - 5 - Upgrade Physical Files to SQL Tables
zhlédnutí 105Před 21 dnem
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 t...
Modernize RPG400 to RPG ILE FREE and PF to SQL - 4 - Upgrade RPG Subroutines to Sub Procedures
zhlédnutí 35Před 21 dnem
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
zhlédnutí 42Před 21 dnem
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
zhlédnutí 54Před 21 dnem
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
zhlédnutí 83Před 21 dnem
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
zhlédnutí 90Před 21 dnem
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!
zhlédnutí 104Před měsícem
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
zhlédnutí 61Před měsícem
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
zhlédnutí 142Před měsícem
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
zhlédnutí 262Před měsícem
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.
zhlédnutí 223Před 3 měsíci
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
zhlédnutí 116Před 5 měsíci
MontePego, Trash Runs, Hungover Coffees and Happy Sandy Dogs
RPG 101 Ep6 - Tweaking Hello World to make it a bit more fancy
zhlédnutí 278Před 5 měsíci
RPG 101 Ep6 - Tweaking Hello World to make it a bit more fancy
IBM i PDM 101 Ep4 Working with PDM User Defined Options
zhlédnutí 161Před 6 měsíci
IBM i PDM 101 Ep4 Working with PDM User Defined Options
IBM i PDM 101 Ep3 - Working with PDM Members in Files
zhlédnutí 125Před 6 měsíci
IBM i PDM 101 Ep3 - Working with PDM Members in Files
IBM i PDM 101 Ep2 Working with PDM Object in a Library
zhlédnutí 125Před 6 měsíci
IBM i PDM 101 Ep2 Working with PDM Object in a Library
IBM i PDM 101 Ep1- What is the Programming Development Manager
zhlédnutí 169Před 6 měsíci
IBM i PDM 101 Ep1- What is the Programming Development Manager
RPG 101 Ep5 - Modern RPG deserves a Modern Code Development Environment VSCODE
zhlédnutí 568Před 6 měsíci
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
zhlédnutí 152Před 6 měsíci
RPG 101 Ep4 - Finally stepping up to a modern RPG Free Format Layout
RPG 101 Ep3 - Setting legacy RPG Free
zhlédnutí 143Před 6 měsíci
RPG 101 Ep3 - Setting legacy RPG Free
RPG 101 Ep2 - Tarting up the old fashioned AS400 RPG to iSERIES RPGLE Hello World Example
zhlédnutí 233Před 6 měsíci
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
zhlédnutí 705Před 6 měsíci
RPG 101 Ep1 - Basic old fashioned AS400 RPG Hello World Example
Converting IBM i Physical Files to SQL Tables
zhlédnutí 291Před 6 měsíci
Converting IBM i Physical Files to SQL Tables
Upgrading RPG Column Based to Free with VS Code for IBM i
zhlédnutí 163Před 6 měsíci
Upgrading RPG Column Based to Free with VS Code for IBM i
Moli Del Pas, OntinYent -- Uncle Dave's Thanksgiving Dinner
zhlédnutí 151Před 8 měsíci
Moli Del Pas, OntinYent Uncle Dave's Thanksgiving Dinner
Testing IBM i IWS Integrated Web Server with SOAPUI
zhlédnutí 348Před 10 měsíci
Testing IBM i IWS Integrated Web Server with SOAPUI
Setup IBM i IWS Integrated Web Server
zhlédnutí 519Před 10 měsíci
Setup IBM i IWS Integrated Web Server
SUPERSIMP - Compile the Simple RPG Webservice Program
zhlédnutí 153Před 10 měsíci
SUPERSIMP - Compile the Simple RPG Webservice Program
SUPERSIMP - Simple RPG Webservice Program
zhlédnutí 234Před 10 měsíci
SUPERSIMP - Simple RPG Webservice Program

Komentáře

  • @FernandoRodrigues-n9e

    Eu Queria Ser Este Cachorro Mesmo ❤

  • @yomismo6969
    @yomismo6969 Před 4 dny

    I am trying to find a manual for the Integrated Web Services for IBM i or a red book...but it looks like the one from IBM is from 2018. Do you know where can I find a newer one. From 2018 to 2024 there must be a lot of change. I watch your videos about it and where exelect, but I would like to find the lastes manual if possible.

  • @user-vd9xc4gg4e
    @user-vd9xc4gg4e Před 9 dny

    Xix ❤

  • @s.b.8704
    @s.b.8704 Před 20 dny

    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 Před 21 dnem

    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 Před 21 dnem

      @@BeastGamingCorner good luck senor!!

  • @BeastGamingCorner
    @BeastGamingCorner Před 21 dnem

    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 Před 22 dny

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

  • @tonywhite6107
    @tonywhite6107 Před 24 dny

    1st one in.

    • @NickLitten
      @NickLitten Před 21 dnem

      Strictly speaking... I was ;)

  • @PixelOutlaw
    @PixelOutlaw Před 26 dny

    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 Před 21 dnem

      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 Před měsícem

    Fantastic!

  • @Jimi-bx3xf
    @Jimi-bx3xf Před měsícem

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

    • @NickLitten
      @NickLitten Před měsícem

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

  • @bernardjoseph6094
    @bernardjoseph6094 Před měsícem

    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 Před měsícem

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

  • @matthewjohnston1602
    @matthewjohnston1602 Před měsícem

    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 Před měsícem

      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 Před 2 měsíci

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

  • @daddytazflRG
    @daddytazflRG Před 2 měsíci

    put the towel down !

  • @approvalguy9389
    @approvalguy9389 Před 2 měsíci

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

    • @NickLitten
      @NickLitten Před 19 dny

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

  • @Joaorferreira
    @Joaorferreira Před 3 měsíci

    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!

  • @irajaghakhani2145
    @irajaghakhani2145 Před 3 měsíci

    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 Před 3 měsíci

    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 Před 19 dny

      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 Před 3 měsíci

    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 Před 3 měsíci

      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 Před 28 dny

      @@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 Před 3 měsíci

    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 Před 2 měsíci

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

  • @daquanlamar4752
    @daquanlamar4752 Před 3 měsíci

    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 Před 3 měsíci

      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 Před 3 měsíci

    Fine Ass you

  • @BG5850
    @BG5850 Před 3 měsíci

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

    • @NickLitten
      @NickLitten Před 3 měsíci

      czcams.com/video/mvdx8EfCcB8/video.html

  • @demtron
    @demtron Před 3 měsíci

    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 Před 3 měsíci

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

    • @NickLitten
      @NickLitten Před 3 měsíci

      After nearly 4 years.... Nope 😅

  • @EricFacundoQuiroz
    @EricFacundoQuiroz Před 3 měsíci

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

    • @NickLitten
      @NickLitten Před 3 měsíci

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

    • @EricFacundoQuiroz
      @EricFacundoQuiroz Před 3 měsíci

      @@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 Před 3 měsíci

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

    • @NickLitten
      @NickLitten Před 3 měsíci

      White background matters lol

  • @travisirish6322
    @travisirish6322 Před 3 měsíci

    What was it song before?

  • @TheRafagomez62
    @TheRafagomez62 Před 3 měsíci

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

    • @NickLitten
      @NickLitten Před 3 měsíci

      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 Před 3 měsíci

    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 Před 3 měsíci

      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 Před 4 měsíci

    Thks a lot Nick!! Very useful!

  • @vividstudio4651
    @vividstudio4651 Před 4 měsíci

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

  • @vercnockekooy9508
    @vercnockekooy9508 Před 4 měsíci

  • @winwithchristina
    @winwithchristina Před 4 měsíci

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

  • @chub89s79
    @chub89s79 Před 4 měsíci

    Lucky dog! lol

  • @skyandgavinvlogs4534
    @skyandgavinvlogs4534 Před 4 měsíci

    How to unmerged gmail from proton?

  • @MAE-yg8bf
    @MAE-yg8bf Před 4 měsíci

    Bon apppetit.!

  • @unboxingreviews5327
    @unboxingreviews5327 Před 4 měsíci

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

  • @Leedoggie6677
    @Leedoggie6677 Před 4 měsíci

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

    • @NickLitten
      @NickLitten Před 4 měsíci

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

  • @sergioarguedas5068
    @sergioarguedas5068 Před 4 měsíci

    Wow

  • @mxxt2554
    @mxxt2554 Před 5 měsíci

    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 Před 3 měsíci

      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 Před 5 měsíci

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

  • @finleyl.2822
    @finleyl.2822 Před 5 měsíci

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

  • @AngelVillar-do7ch
    @AngelVillar-do7ch Před 5 měsíci

    😍😍😍😍😘😘😘

  • @AngelVillar-do7ch
    @AngelVillar-do7ch Před 5 měsíci

    😘😘😘❣️❣️

  • @AngelVillar-do7ch
    @AngelVillar-do7ch Před 5 měsíci

    ❤❤❤

  • @filippyknow
    @filippyknow Před 5 měsíci

    You are hero! Thanks Nick!

  • @chrislaw4958
    @chrislaw4958 Před 5 měsíci

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

  • @djust270
    @djust270 Před 5 měsíci

    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.

    • @NickLitten
      @NickLitten Před 5 měsíci

      Is the most boring role-playing game you ever played lol