Can anyboddy explain what is "QUERYNO" in select

soumyaranjan007 · New User Joined: 30 Aug 2006 Posts: 30 Location: mumbai

Hi,

Query is as like below

EXEC SQL
SELECT
Column 1,
Column 2
Into
:c1,
:c2
from Table_A
where Column 3 = :c3
QUERYNO 15101
END-EXEC.

Thanks
Soumya

CICS Guy · Posted: Wed Feb 20, 2008 4:29 pm

Have you looked at the fine manual?
QUERYNO integer
Specifies the number to be used for this SQL statement in EXPLAIN output and trace records. The number is used for the QUERYNO columns of the plan tables for the rows that contain information about this SQL statement. This number is also used in the QUERYNO column of the SYSIBM.SYSSTMT and SYSIBM.SYSPACKSTMT catalog tables.

soumyaranjan007 · New User Joined: 30 Aug 2006 Posts: 30 Location: mumbai

what is the benefits to use QUERYNO ?
Could any one please send me the manual please?

rajeshrs488 · New User Joined: 21 Feb 2008 Posts: 3 Location: Banglore

this is inside the plan table.optimiser tuk the best path
nad also contain the information about the sql statement

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain