You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using
-- pluginName: @brightside/db2
-- package: @brightside/db2
-- version: 2.1.1
-- registry: https://registry.npmjs.org/
on Windows 10, node V11.15.0, npm 6.7.0 and zos is 2.3, DB2 CODE LEVEL (V12R1M505 ).
While I can use zowe db2 client for SQL query, g Stored Procedures, db2 export table is failing with
PS C:\windows\system32> zowe db2 export table DSN81210.PROJ
Command Error:
Error: [IBM][CLI Driver][DB2] SQL0104N An unexpected token "," was found following "". Expected tokens may include: "
DISTINCT UNIQUE ALL * ARRAY + - ROW NEXTVAL PREVVAL NEXT". SQLSTATE=42601
on ZOS DB2 explain is showing
SELECT , , , , , , ,
FROM DSN81210.PROJ
FOR FETCH ONLY
zowe client instead of using column names from meta data, is sending ,,,,, to the query and hence failing.
The text was updated successfully, but these errors were encountered:
I am using
-- pluginName: @brightside/db2
-- package: @brightside/db2
-- version: 2.1.1
-- registry: https://registry.npmjs.org/
on Windows 10, node V11.15.0, npm 6.7.0 and zos is 2.3, DB2 CODE LEVEL (V12R1M505 ).
While I can use zowe db2 client for SQL query, g Stored Procedures, db2 export table is failing with
PS C:\windows\system32> zowe db2 export table DSN81210.PROJ
Command Error:
Error: [IBM][CLI Driver][DB2] SQL0104N An unexpected token "," was found following "". Expected tokens may include: "
DISTINCT UNIQUE ALL * ARRAY + - ROW NEXTVAL PREVVAL NEXT". SQLSTATE=42601
on ZOS DB2 explain is showing
SELECT , , , , , , ,
FROM DSN81210.PROJ
FOR FETCH ONLY
zowe client instead of using column names from meta data, is sending ,,,,, to the query and hence failing.
The text was updated successfully, but these errors were encountered: