PFU0083E - SELECT#0001: "COMMA VALUE " INVALID WITH "QUOTE VALUE "
search cancel

PFU0083E - SELECT#0001: "COMMA VALUE " INVALID WITH "QUOTE VALUE "

book

Article ID: 115250

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Upgraded to V20 and getting PFU0083E - SELECT#0001: "COMMA VALUE " INVALID WITH "QUOTE VALUE "

Environment

z/os DB2 

Cause

Specifying both QUOTE NONE and COMMA ' ' prevents us from generating valid CSV if any values have blanks

Resolution

Change COMMA ' ' to COMMA ','