Hi ,
i am using the basic notification in JDBC adapter for DB2 database and created the Buffer table with a cloumn alias of wm_rowid(user defined) as, passed the parameter in JAVA tab of JVM option(-Djdbc.rowIDColumn=QAWMRID where QAWMRID is alias of wm_rowid), but giving the folowing Error:
java.sql.SQLException: [SQL0208] ORDER BY column WM_ROWID or expression not in result table. Cause . . . . . : Column WM_ROWID or an expression is specified in the ORDER BY clause and is not valid because: – The column or expression is not in the result table (is not specified in the SELECT list). – The column or expression is in the SELECT list but the result column is renamed using an AS clause. If the AS clause is used to name a column in the result table, the name specified on the AS clause must be the name specified on the ORDER BY clause. – A qualified name in the ORDER BY clause refers to a name specified in an AS clause. A name specified in an AS clause cannot be qualified. – The name does not refer to a named column of the result table when a UNION or UNION ALL operator is specified. The result column is named if the corresponding columns in each SELECT list have the same name. Recovery . . . : Do one of the following and try the request again: – Add column WM_ROWID or the expression to the result table. – Remove column WM_ROWID or the expression from the ORDER BY clause. – Ensure WM_ROWID is a named result column if UNION or UNION ALL is specified. – Specify a numeric column identifier in place of WM_ROWID in the ORDER BY clause.
can any one help me .
Thanks,
Ashutosh