I am trying to write an Informix procedure to insert fields from the tdilc101 table into a custom table using certain criteria. I only want to select records where the warehouse is 'nettable'. The variable nr_cwar is ttilc101.t_cwar.

if (select t_nwrh from ttcmcs003310
where t_cwar=nr_cwar)<>1
then
let type='non-nettable';
else
let type='nettable';
end if;

I have both nettable and non-nettable warehouses defined in the tcmcs003 table, but no matter what value I pass in a nr_cwar the type always comes out as 'nettable'

TIA for any guidance!


Duane

Here is the code I used:

define nettable int;

...

let nettable=(select t_nwrh
from ttcmcs003310
where t_cwar=nr_cwar);
...

if nettable = 1
then let type='Raw Material';