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 |
