Re: SQL newbie question -- MIDRANGE-L

rob@xxxxxxxxx wrote:

Love to see the exact message you received on both:
- the FOR READ ONLY
- UNION not availble.
Please include message id.

On closer examination, it looks like the UNION part iswithin a given embedded SELECT, rather than betweenmultiple SELECTs.


At any rate, this programmatically-generated statement:

    INSERT INTO QTEMP/WTGRPW SELECT CID FROM WTCONT CO
    WHERE CO.U01010 = '1' FOR READ ONLY WITH NC

produced this error message:

    FOR FETCH ONLY clause not allowed.

with this help-text:

Message ID . . . . . . : SQL0109 Severity . . . .. . . : 30

Message type . . . . . :   Diagnostic

Date sent . . . . . . : 11/11/05 Time sent . . .. . . : 11:31:43


Message . . . . :   FOR FETCH ONLY clause not allowed.

Cause . . . . . : One of the following conditions wasnot allowed:-- Embedded SELECT statements cannot include the FORUPDATE clause, theFOR READ ONLY clause, the FOR FETCH ONLY clause, theOPTIMIZE clause, or the

  UNION or UNION ALL operator.

-- SELECT statement used in cursor declarations orsubselects cannot have

  an INTO clause.

-- CREATE VIEW statements may not have an INTO, ORDERBY, FOR UPDATE, FOR

  READ ONLY, FOR FETCH ONLY, or OPTIMIZE clause.

-- INSERT statements may not have an INTO clause in asubselect, a FORUPDATE, FOR READ ONLY, FOR FETCH ONLY, or an OPTIMIZEclause.-- WHERE CURRENT OF cursor clause is not allowed instatements processedin interactive SQL or statements processed by theRUNSQLSTM command.-- The NOT NULL clause is not allowed in thedefinition of a column being

  added to a table unless a default value is specified.

Recovery . . . : Remove the clause. A cursor may beneeded to perform the

  processing.

-- The FOR UPDATE, FOR READ ONLY, FOR FETCH ONLY, andOPTIMIZE clauses are

  accepted in the DECLARE CURSOR statement.

-- The UNION or UNION ALL operators are accepted inthe DECLARE CURSOR and

  INSERT statements.

-- The INTO clause is accepted in the FETCH andembedded SELECT

  statements.

-- The ORDER BY clause is allowed on the DECLARECURSOR, embedded SELECT,

  and the INSERT statements.

-- The WHERE CURRENT OF cursor clause is valid in anembedded or dynamic

  SQL statement.

-- Remove the NOT NULL clause from the columndefinition or specify a

  default value for the column.
    Try the request again.

--
JHHL