Yes.
In RPGSql you need to do the insert as a prepared statement – that you build on the fly..this is dynamitic SqL
or
In RPG native mode use OVRDBF to redirect the program to the actualy file.
or
You could also have the file as USROPN and EXTFILe in the f spec’s assign the proper name to the ExTfile variable before opening the file.
Phil
Discuss This Question: 3  Replies
Exec Sql Execute Immediate :WkFld;
runs I get an sql 206 error with the message "Column @FULOTRWT not in specified tables." I also tried naming the columns specifically instead of the data structure, but then I get the same error but with the column name instead of the data structure. I would appreciate it if anyone can tell me what I'm missing here. Thanks, Steve