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
brainchime.com Latest Questions
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 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 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 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
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 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
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 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 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