Re: help with tables

On Wed, 30 Jan 2008 10:39:28 -0700, "Frank Swarbrick" <Frank.Swarbrick@xxxxxxxxxxxxxx>
wrote:

--------------------------------------------------------------------
SQL0060W The "COBOL" precompiler is in progress.
19 SQL0008N The token "occurs" found in a host variable
declaration is not valid.
41 SQL4943W The number of host variables in the INTO clause
is not the same as the number of items in the SELECT
clause. SQLSTATE=01503

The manual says DB2 doesn't allow a simple SELECT to return multiple rows. You must do the
SELECT in a cursor declaration and read the table with a single FETCH, as illustrated by
Frederico.

Thanks for the experiment.

.

Relevant Pages

  • Re: Dont use the "use" clause
    ... > Dmitry A. Kazakov wrote: ... > The use clause is barred by coding standards for a good reason, ... And if you need to see the declaration, ...
    (comp.lang.ada)
  • Re: help with tables
    ... SQL0060W The "COBOL" precompiler is in progress. ... 41 SQL4943W The number of host variables in the INTO clause ... SELECT in a cursor declaration and read the table with a single FETCH, ...
    (comp.lang.cobol)
  • Re: Dont use the "use" clause
    ... The use clause is barred by coding standards for a good reason, ... don't think it's necessarily name collisions that drive this rule. ... And if you need to see the declaration, ... > IDE should have "go to declaration" button. ...
    (comp.lang.ada)
  • Re: SELECTing from a DML statement
    ... Just found this excellent paper "Returning Modified Rows - SELECT ... Oracle has introduced a returning clause for insert, ... in which case the host variables need to be declared as ... Does it mean triggers on the view's base table? ...
    (comp.databases.oracle.server)
  • Re: FileReader/FileWriter question
    ... >> If you think about it, it does not make much sense for the else clause ... I was talking about the Java language and the scope that the declaration ... FileWriter works. ...
    (comp.lang.java.help)