Query related to MAX() function

anaresh · New User Joined: 01 Aug 2008 Posts: 3 Location: Hyderabad

Hi,

I have a FIELD in a table which is defined as INT.
Logic in program is it is getting MAX(FIELD) in to a S9(9) COMP variable.

Initially when no rows are there in table, what will the function return?
Checking this I have to move '1' to this field.

Thanks,
Naresh.

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Hi anaresh ,
The sqlcode will return 100.
check for the sqlcode if it is 0 then move wharever you have to
if it is 100 move 1 to the field.

anaresh · New User Joined: 01 Aug 2008 Posts: 3 Location: Hyderabad

Thanks Anand...

Bharath Bhat · Posted: Fri Mar 13, 2009 11:38 am

The function will return a null. You can check the null indicator also. But, the column should be not null.

ajeshrn · New User Joined: 25 Mar 2009 Posts: 78 Location: India

Hi,

Thats true if the column is not defined with NOT NULL ,then if null is being passed to the application hist variable it will be returning a SQLCODE -305.As Bharat told we can handle this situation through NULLINDICATOR.

Thanks
Ajesh R N