Hi, I have a file that I want to populate using a SQLRPGLE program. To test it, I am using STRSQL and the select statement that will be in the program. The selection criteria pulls a total of 16 fields from a couple of files, but the DDS file has 17 fields. I want the last field to be blank when I run the SQL. (It will be populated later) However, STRSQL fails saying "Query output definition does not match file". How can I use SQL Select to populate part of a file? Is there a way to force a blank value in a Select statement? The last field is defined as ALWNULL in the DDS.
TIA, Kevin
TIA, Kevin
Comment