DB2DataAdapter.Fill(dataset) 抛出错误“SQL0901N（原因“CPF4273”。）SQLSTATE=58004”

发布于 2024-12-10 08:22:12 字数 1197 浏览 5 评论 0原文

我的应用程序基于 Dot Net。我正在使用 VS 我的应用程序在其后端使用 IBm DB2。我的查询是

SELECT A, B FROM SERVER.D WHERE A IN 
    (SELECT C FROM SERVER.E WHERE X = '01OBPP' AND Y= 'U' AND Z= '1')

服务器名称、D 和 E-表名称

PFB 代码-

DB2DataAdapter dbAdapter = null;
DB2Connection dbConn = null;
DB2Command dbCommand;
DataSet dsReturnDataSet  ;              
dbConn = new DB2Connection(connectionString);
if (dbConn.State == ConnectionState.Closed) dbConn.Open();
dsReturnDataSet.Clear();

dbCommand = GetCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConn;
dbAdapter = new DB2DataAdapter((DB2Command)dbCommand);
dbAdapter.Fill(dsReturnDataSet);
return dsReturnDataSet;

GetCommand() 方法具有以下语句

DB2Command dbCommand; 
dbCommand = null;
dbCommand = new DB2Command();
dbCommand.CommandType = CommandType.Text;
dbCommand.CommandTimeout = 30;
return dbCommand;

A、B、C、X、Y、Z-列名称、服务器- 填充（dsReturnDataSet）；'它在那里停留了很长一段时间，然后抛出错误

“错误 [58004] [IBM][AS] SQL0901N SQL 语句失败，因为非严重的系统错误。可以处理后续的SQL语句。（原因“CPF4273”。）SQLSTATE=58004”

请提供一些指示。如果有人能够提供一些有关如何解决此错误的指示，我将非常感激。

原文

My application is Dot Net based.I am using VS My application uses IBm DB2 at its backend.
My Query is

SELECT A, B FROM SERVER.D WHERE A IN 
    (SELECT C FROM SERVER.E WHERE X = '01OBPP' AND Y= 'U' AND Z= '1')

A,B,C,X,Y,Z-COLUMN NAME, SERVER- SERVER NAME, D AND E -TABLE NAME

PFB the code-

DB2DataAdapter dbAdapter = null;
DB2Connection dbConn = null;
DB2Command dbCommand;
DataSet dsReturnDataSet  ;              
dbConn = new DB2Connection(connectionString);
if (dbConn.State == ConnectionState.Closed) dbConn.Open();
dsReturnDataSet.Clear();

dbCommand = GetCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConn;
dbAdapter = new DB2DataAdapter((DB2Command)dbCommand);
dbAdapter.Fill(dsReturnDataSet);
return dsReturnDataSet;

The GetCommand() method has the following statement

DB2Command dbCommand; 
dbCommand = null;
dbCommand = new DB2Command();
dbCommand.CommandType = CommandType.Text;
dbCommand.CommandTimeout = 30;
return dbCommand;

While it hits the line 'dbAdapter.Fill(dsReturnDataSet);' it stucks there for a very long time and after that it throws the error

"ERROR [58004] [IBM][AS] SQL0901N The SQL statement failed because of
a non-severe system error. Subsequent SQL statements can be processed.
(Reason "CPF4273".) SQLSTATE=58004"

Please provide some pointers.
i will be very grateful if any one can give some pointers as to hoW to solve this error.

分享到QQ

分享到微博