A First Look At SQL Descriptors
September 15, 2015 Paul Tuohy
SQL descriptors allow for incredible flexibility when it comes to constructing dynamic SQL statements and/or processing the results of a dynamic SQL statement. But, since this is an introduction, let’s look at how they can be used in constructing dynamic SQL statements and leave their use in processing results for a later article. Assume we want to embed the following SQL statement in an RPG program: select workDept, empno, firstname, lastname from employee where workDept = ? and hireDate >= ? and birthDate >= ? order by workDept, empno The difficulty we have is that comparison values may or may |