Topic
2 replies Latest Post - ‏2011-05-09T10:48:34Z by manshanb
goetzj@de.ibm.com
goetzj@de.ibm.com
2 Posts
ACCEPTED ANSWER

Pinned topic using SQL variables as CLPPlus variables

‏2010-07-26T17:47:51Z |
in which FP will it be possible to read in SQL data into a variable and use this
later on as a CLPPlus variable ?
This is basic to build variable scripts.

Thanks !

Jürgen
Updated on 2011-05-09T10:48:34Z at 2011-05-09T10:48:34Z by manshanb
  • l1t
    l1t
    5 Posts
    ACCEPTED ANSWER

    Re: using SQL variables as CLPPlus variables

    ‏2011-05-09T05:27:49Z  in response to goetzj@de.ibm.com
    SQL> var x decimal;
    DB250000I: 成功地完成该命令。

    SQL> exec select 1 into :x from dual;
    DB250000I: 成功地完成该命令。

    SQL> set serverout on

    SQL> exec dbms_output.put_line(:x);
    1
    DB250000I: 成功地完成该命令。
  • manshanb
    manshanb
    6 Posts
    ACCEPTED ANSWER

    Re: using SQL variables as CLPPlus variables

    ‏2011-05-09T10:48:34Z  in response to goetzj@de.ibm.com
    This feature is available in DB2 v97 FP3 release.