MVSFORUMS.com

[dbzTHEdinosauer]

Have an 'option' db2 table.
Select performed for row.
If sqlcode = 0 then values from row are used.
If sqlcode = +100, then program populates values.

so which select will return from db2 quicker, the sqlcode 0 with data or +100 without any data?
_________________
Dick Brenholtz
American living in Varel, Germany

[Terry_Heinze]

Wouldn't they be the same? Regardless of the presence of an appropriate index?
_________________
....Terry

[kolusu]

dbzTHEdinosauer,

I would define the column with null and use IFNULL/VALUE/COALSCE on the column and retrieve the default value with sql code being always zero.


Kolusu