[[{“value”:”Coming up with a meaningful title for this post proved harder than normal. I was asked a question about how to fetch data, using a SQL Cursor, and convert some of the fetched columns into an array. The questioner had tried various approaches, but was always receiving an error in the SQL pre-compile step of his program.
The file in question contained 35 fields he was interested in. The record would be for an account, by year and month, 31 balance fields one for every day of the month (yes, I know not all months have 31 days), and finally a total monthly change balance. The questioner wanted to put all of the 31 day fields into one array.
Let me start with my version of his file, that I called TESTFILE:
Read more »”}]] Read More
Multitasking with Navigator for i Emma Pitzl
[[{“value”:”IBM i expert Dawn May shares tips on how to multitask in Navigator for i
The post Multitasking with Navigator for i appeared first on TechChannel.”}]] Read More
Secure my IBM i – Default Password NickLitten
Keeping your IBM i Power System Secure is key Using default passwords for your IBM i system is obviously a bad security practice! Default passwords can be a significant security risk because they are often well-known and can be easily guessed by unauthorized users. On your IBM i system, profiles that have a default password Read More
Leverage Form Software to Maximize Productivity Arin Seeger
[[{“value”:”Want to increase productivity, free up thousands of dollars to invest in other projects, improve forms that will enhance company brand and customer engagement, and improve the system of generating forms? You need the most trusted forms software solution to create and generate forms on IBM i: TLAForms by TL Ashford. Here’s why: Reduce Time
The post Leverage Form Software to Maximize Productivity appeared first on TechChannel.”}]] Read More
Transferring subfile data JC_Hazard
[[{“value”:”Hi
Does anyone know what is the best and easiest way to transfer data from one subfile to another? I am pretty new to rpgle (using free format) and I am struggling to find a method, not sure if I must implement the use of an array or not. The columns are the same between the subfiles except for around 4 columns which are to be hardcoded by default. Any push in the right direction would be greatly appreciated.
submitted by /u/JC_Hazard[link][comments]”}]] Read More
