On 11/10/2013 1:16 AM, Ivan Přenosil wrote:

>> Option 2:
>> select ID from CITIES where CITY = :NEWCITY into :NEWID;
>> if ( NEWID is not null ) then suspend;
>> /* Do insert operation since nothing found */
> Do not forget that this requires NEWID to be set to Null before calling select !

After the select statement, if no row is found, what value will NEWID be
if I haven't specifically assigned anything to it prior to the select?

--
Daniel