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
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 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 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 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 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 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 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
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.