In today’s post I will show you on how to convert upper case to lower case utilizing the built-in function %lower. You can convert an entire word or you can specify which position you want to start the conversion. I am using IBM’s API QUILNGTX as it does not limit me to the text length…

In this example, I will show you on how to use the various %trim built in functions %trim – will remove the trailing blanks from end of text field.%trimR – will remove trailing blanks or specified characters from end of text field.%trimL – will remove specified characters or blanks from beginning of text field. Due…

In my quest to have a better understanding of how triggers worked I did quite a bit of searching on the web and reading different articles. Nick Litten had a wonderful starting point of one in RPG Free where he was unable to recall the original source of the code. This updated code was quite…

I am on a journey to teach myself SQL and make better use of SQL inside an RPG program. Your first step is to define the program as SQLRPGLE This simple statement used SQL to retrieve a record from a database file (table). exec sql Select EXTWHS into :mywarehouse from WHSPF where    WHID = :programwhs;   …

You can set up a library list to use when using Access Client Solutions (ACS) to run SQL Scripts. Open RUN SQL SCRIPTS in ACS (Access Client Solutions) From menu bar: Click EDIT Click JBDC Configurations Click ADD Input name and description Click NEXT button Library List will be pre-populated with *LIBL Insert your library…

I am asked this question a couple of times recently; how do I debug a program that is processed in batch? In order to make this work ensure the program has been compiled with debug view of *SOURCECRTBNDRPG PGM(MYLIB/MYPROG) SRCFILE(MYLIB/QRPGLESRC) DBGVIEW(*SOURCE) Verify your library list is set up correctly before submitting the job. I hope…

Dropping a table is equivalent to deleting a file. It will also delete all the data contained in that table/file. In this post will describe on how to create a table (file) using IBM Access Client solutions. Definition of keywords: Schema Name Schema is the library name of where you will be storing the file…

In this post will describe on how to create a table (file) using IBM Access Client solutions. Definition of keywords: Schema Name Schema is the library name of where you will be storing the file Table Name The name of the table (file) Column Name The name of the columns (fields) contained within the table…

In today’s tutorial, I want to start with the different data types available to use when creating tables using SQL on the IBM iSeries (system i, Power i, AS400). I am only including common ones below. Data Types Description Example VARCHAR Stores variable length text Name = ‘Alice’ CHAR Stores fixed length text Country Code…

In my journey of learning SQL came new terminology to me. The terminology I have used for many years felt comfortable to me, these new terms were confusing. It took a few minutes to wrap my head around the new terms. I created a small table to use to help me navigating through these new…

Did you know that when you use RUN SQL SCRIPTS from IBM i Access Client Solutions (Client access) you can save the SQL Scripts to the iSeries (system i/ power i / AS400O in a Source File Member? In the attached document I will outline on how you can save the scripts to the iSeries…