Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB2 TABLE EXPORT and SQL0104N #43

Open
prab99 opened this issue Dec 4, 2019 · 1 comment
Open

DB2 TABLE EXPORT and SQL0104N #43

prab99 opened this issue Dec 4, 2019 · 1 comment
Labels

Comments

@prab99
Copy link

prab99 commented Dec 4, 2019

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.

@zFernand0
Copy link
Member

hey @prab99
Could you try to reproduce the issue with newer versions of the DB2 Plug-in?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Medium Priority
Development

No branches or pull requests

2 participants