查询未从命令行运行 [英] Query is not running from command line

问题描述

错误：

 DB21034E该命令作为SQL语句处理，因为它不是
有效的命令行处理器命令。在SQL处理期间，它返回：
 SQL0104N在ECT DECLINECODE 
 FROM之后发现了意外的令牌DASUSR1。预期的代币可能包括：INTO。 LINE NUMBER = 1。 SQLSTATE = 42601 

查询：

 db2CREATE PROCEDURE TEST_PROCEDURE（）BEGIN从DASUSR1中选择DECLINECODE。DECLINECODE;结束

我尝试过：



在END语句后输入@，＃进行检查。

保持;语句结束后

 SELECT DECLINECODE FROMDASUSR1。DECLINECODE; 

解决方案

试试这个：

 db2CREATE PROCEDURE TEST_PROCEDURE（）从[DASUSR1]开始选择DECLINECODE。[DECLINECODE]; END

Error:

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "DASUSR1" was found following "ECT DECLINECODE
FROM".  Expected tokens may include:  "INTO".  LINE NUMBER=1.  SQLSTATE=42601

Query:

db2 "CREATE PROCEDURE TEST_PROCEDURE() BEGIN SELECT DECLINECODE FROM "DASUSR1"."DECLINECODE"; END"

What I have tried:

Checked by putting @,# after END statement.
By Keeping ; after end of statement

SELECT DECLINECODE FROM "DASUSR1"."DECLINECODE";

解决方案

Try this:

db2 "CREATE PROCEDURE TEST_PROCEDURE() BEGIN AS SELECT DECLINECODE FROM [DASUSR1].[DECLINECODE]; END"

这篇关于查询未从命令行运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！