I have been looking for an answer to this for a long time, but I have not found a solution without RPG/COBOL yet. Is there any way or approach that I use to make a call to the SQL stored procedure ...Read more
brainchime.com Latest Questions
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
We have system36 files, and since these files are not externally described files and are internally described files within system36 programs with predefined structures within the program itself. Please tell us if we can access the system36 files using SQL.
I was getting an issue where I tried copying data from a text file in IFS to the DB2-based DDS file and the data was not copied correctly. After looking at the data as hex values I got to know ...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
how to declare a global temporary table in the rpgle program. I was working on creating the temporary SQL file in my rpgle program that I do not want to share with any other job/session which means only the present ...Read more
I was writing a sqlrpgle program since I had to write an SQL query to fetch data from a table into rpg variables and I was not sure how to map SQL data types field in SQL select statement ...Read more
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
I have a date field in one of my files and the date is formatted in the YYYYMMDD format. I have to extract the week from the particular date value present in my file. How can I do this using ...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