![Nick Litten](/img/default-banner.jpg)
- 448
- 1 088 725
Nick Litten
United States
Registrace 14. 08. 2006
A load of old video nonsense, cobblers and other guff. English Dad, with a bunch of kids, dogs and other clan members doing it American Style. When I'm not being a Digital Dad I'm waffling about #AS400, #iSERIES, #IBMi and #RPG programming
8bef2018faac0d5f
8bef2018faac0d5f
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/
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
Eu Queria Ser Este Cachorro Mesmo ❤
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.
Xix ❤
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.
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.
@@BeastGamingCorner good luck senor!!
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.
Making progress, converting ERPs in the wild from DDS to SQL, with bonuses of journals. Woot!
1st one in.
Strictly speaking... I was ;)
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.
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.
Fantastic!
Hello nick i try to test httpapi i'm using pub400 but i can't create a lib on the machine.
@@Jimi-bx3xf raise a support ticket on my website and we can talk .. see if I can help you
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?
@@bernardjoseph6094 sounds like a hardware problem on the printer. Powered off? Losing comms?
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
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...
This video was soooo helpful !! Thank you soooo much!
put the towel down !
Hi Nick, Awesome video! how can I not send customer to WordPress login when they forget the password? thank you
Add a redirect www.hostinger.com/tutorials/fix-wordpress-login-redirect-loop
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!
Delighted they help!!
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?
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!
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.
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.
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?
@@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.
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.
I can do that! I've added it to the top of my "record a thing" list. Check back later this week...
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
If you have specific questions or topics you'd like me to cover go and leave a support ticket on my website nicklitten.com 👍
Fine Ass you
Nick, did you not make a part 2? I see the next video skills to Showing proton in use?
czcams.com/video/mvdx8EfCcB8/video.html
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.
shouldn't you be censoring some of the information on screen?
After nearly 4 years.... Nope 😅
Im sorry, which plugin i need to install to get that "Convert to rpg free"?
www.nicklitten.com/course/what-is-the-visual-studio-code-extension-for-ibm-i/
@@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
Not the white as400 background 😭. Ty so much by the way!
White background matters lol
What was it song before?
Your video is very interesting but How could you keep the same level identifier in the new table? Thank you so much
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... :)
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
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."
Thks a lot Nick!! Very useful!
Some folk do like watching a dude natting away while multitasking an in install and tryout.
Strange but true LOL
❤
Nick, this video was excellent and very helpful. Thank you!!
Glad it was helpful!
Lucky dog! lol
How to unmerged gmail from proton?
Don’t
Bon apppetit.!
thanks Nick very straight forward i am too from AS400 domain and found this very Helpful
Tom Ford’s Tuscan Leather or Ombré Leather smells amazing. Get you some! You deserve it!
I've smelt some great Tom Ford - will deffo check those out :)
Wow
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!
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)
Your video editing has improved a lot dad. I enjoyed this.
"In case you were wondering, it was poop time for the dogs, not for me." Jealous of the coffee 🥺
😍😍😍😍😘😘😘
😘😘😘❣️❣️
❤❤❤
You are hero! Thanks Nick!
Thanks. I've been looking for videos of 955 fuel pump installation.
No problem 👍
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.
Is the most boring role-playing game you ever played lol