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
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
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 am using the Access client solution (ACS) software and opened up the Run SQL script option, ran the simple SQL select query, and selected the date from one of the files. select * from libname.filename Now, I want the 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
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
I have a requirement where I have to restore files from a save file to one of the libraries where these files already exist. So, before that I have to make sure that no locks exist on the particular file ...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
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