Newbie question - first time looking at free format SQL.
I can execute this SQL in IBM i Access Client Solutions, Run SQL Scripts successfully, but when I attempt to execute it with SELECT_SQL using free-format it fails. Any clues? In the online guide, there appears to be a requirement for playing with quotes, but there are examples where that is not shown.
set SCHEMA modernize;
set entauthlstjob = 'TESTJOBNAM';
set entauthlstuser = 'VLFU03';
set entauthlstnbr = '123456';
set entauthlsttype = 'ALPHAWHSES';
set entauthlstloc = ' ';
SELECT RCCST#, RCSORT, RCNAME, RCADR1, RCADR2, RCCITY, RCST FROM ENTAUTHLSTVW8 ORDER BY RCCST# LIMIT 100;