DB2 call

ibmmainframe1 · New User Joined: 26 Jul 2005 Posts: 64 Location: India

Hi All

I have a querry which extracts space from the table

GuyC · Posted: Wed Nov 25, 2009 10:38 pm

none

if 1 row is found, then a space will be put into WS-SG57-SPACE
If no row is found then +100 is returned
if >1 rows are found, you get some other sqlcode

Which is probably what the statement wants to test.

ibmmainframe1 · New User Joined: 26 Jul 2005 Posts: 64 Location: India

I got it. Basically it is testing whether that Input_VIN is present in the table.

The other way could be..
select Vin_C and test if it is not spaces.

GuyC,

pls correct me if my understanding is wrong.

Thanks a lot for your response.

Bharath Bhat · Posted: Thu Nov 26, 2009 2:56 pm

GuyC · Posted: Thu Nov 26, 2009 3:40 pm

The idea is that select space is faster than selecting a column.
select 1 as an integer would even be a little bit better.

But really that is talking about nanoseconds or even picoseconds.

If you select with a where clause there is no need to test the field afterwards. The statement will always return +100 when not exists.

ibmmainframe1 · New User Joined: 26 Jul 2005 Posts: 64 Location: India