Skip to content

DB2 TABLE EXPORT and SQL0104N #43

@prab99

Description

@prab99

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.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    Status

    Medium Priority

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions