I have created a source member (text file) in one of my source files in my library on the IBM i development machine where I have written several SQL queries separated by a semicolon(;). Instead of using STRSQL on the ...Read more
brainchime.com Latest Questions
How can I run SQL queries if STRSQL is not installed on my IBM i machine? I need to get some information from the tables and I noticed that STRSQL is not installed at all on one of the IBM ...Read more
I want to enable commitment control with DB2 tables to use COMMIT on success and ROLLBACK on failure to perform operations with tables. I want to ensure that nothing goes wrong with the database and that the integrity must be ...Read more
I want to create an SQL function for calculating the number of business/working days between two dates, similar to the NETWORKDAYS function for Microsoft Excel. This SQL function should accept two input parameters such as start date and ...Read more
Hi, I was running a simple SQL select from the Run SQL script utility on Access client solutions (ACS) and was getting a SQL error code: -204 and SQLSTATE: 42704 select * from testlib.pf111 SQL State: 42704 Vendor Code: -204 Message: [SQL0204] ...Read more
I can display my IBM i session library list by running the DSPLIBL command from the command line. However, I want to get it in my SQLRPGLE program using SQL query. Is there any SQL query that I can use or ...Read more
Hi, I have set the library DEVLIB on top of the library list by running the command addlible lib(devlib) from the command line, so that file PF1 should get picked from that library as I am running one SQL select ...Read more
I have gone across many example program’s source code and I observed that there is no space between the colon (:) and the host variable in embedded SQL within RPG programs on IBM i. I am curious whether we can provide ...Read more