RE: Embedded SQL Question

Considering the simplicity of the clause, an IN statement would probably
work better for you:

QQW = 'Where BHBHST IN(?,?) ' +
' And BHBTDT >= ?';

Tom Armbruster

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Robert Munday
Sent: Friday, April 18, 2008 11:00 AM
To: RPG programming on the AS400 / iSeries
Subject: Embedded SQL Question

The systems analyst says that my program is not catching selected
records. The only spot in the program where this function is performed
is conditioned by an embedded SQL statement in an RPG /Free program. My
question about the embedded SQL statement is this:

Using the PREPARE method, original statement was:

// Set Where For Records Having A Manual Or Spinner Recall Entry Since
The Last Recall Run
QQW = 'Where (BHBHST = ? Or BHBHST = ?) ' + // Manual Or Spinner
Recall Code
' And BHBTDT >= ? '; // Updated Since Last
Recall Run


Would it be more correct if it were structured as:

// Set Where For Records Having A Manual Or Spinner Recall Entry Since
The Last Recall Run
QQW = 'Where BHBHST = ? And BHBTDT >= ? ' + // Manual Recall Updated
Since Last Recall Run
' Or BHBHST = ? And BHBTDT >= ? '; // Spinner Recall Updated
Since Last Recall Run


To me, the first example should work. The analyst says otherwise.

Thanks,



Robert Munday
Munday Software Consultants
Montgomery, AL
on assignment in Columbia, SC