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
brainchime.com Latest Questions
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
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 have created a SQL stored procedure that takes 2 input parameters and 1 output parameter means a return value. The script of the SQL stored procedure is as follows: CREATE OR REPLACE PROCEDURE STORED33A( ...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
I have written a SQL stored procedure and I have to call that SQL stored procedure in the CL program. I am facing an issue in calling the SQL stored procedure from the CL program. I can call it using ...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
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
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 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