Problem with MAX() query

kranthikumarb · Posted: Tue Jan 27, 2009 7:31 pm

Hi,

I have a table in which a field "accno" is defined as numeric(5). Wen i genereated the DCLGEN for the table, the same field is decimal(5,0) and the corresponding hoset variable is "ws-accno" with data type s9(5)v usage comp-3.

Now when i try to use a query in tha program, it is throwing an error.
The query is

Select MAX(accno) into :ws-accno from account

The error is undefined or unusable host variable ws-accno.

1) I tried using a local variable
2) i tried using a comp variable instead of comp-3
3) i changed the query to write max function in a sub query.

Nothing worked out.

Please help me

Suresh Ponnusamy · Posted: Tue Jan 27, 2009 9:51 pm

Hi

1) What is the definition of ws-accno in your program.

2) Are you directly using this variable in the query or doing some operation (initialize or move) before that.

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi,

Have you included the DCLGEN in your COBOL program.

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

I think you shull use null indicator variable also if the column is nullable in the database.

Bharath Bhat · Posted: Wed Jan 28, 2009 12:55 pm

There are a lot of functions which are nullable even though the columns are not nullable. This is one of them. But I do not think it would say unusable host variable. We'll get this if the variable is not declared or : is missing from the query. Check this in your program. If it is not the problem, paste the code from your program(both declaration and the SQL).

sumit agarwalla · New User Joined: 13 Nov 2008 Posts: 17 Location: hyderabad