DB2 for z/OS R19 Abend PFU0083E - SELECT£0001: "COMMA VALUE " INVALID WITH "DEC-PT VALUE" on FASTUNLOAD LOAD-CONTROL
We migrated to CA DATABASE MANAGEMENT Solutions for DB2 for z/OS R19
Getting an Abend PFU0083E - SELECT £0001: "COMMA VALUE " INVALID WITH "DEC-PT VALUE" on FASTUNLOAD LOAD-CONTROL NONE
SHRLEVEL IGNORE SQL-ACCESS ONLY VALIDATE-HEADER YES OUTPUT-FORMAT COMMA-DELIMITED COMMA ',' QUOTE '"' NULL-FIELD QUOTES SELECT * FROM TABLE
This statement worked in CA DATABASE MANAGEMENT Solutions for DB2 for z/OS R17
Do you know what is causing this?
From your job output i can see you have a Comma set for Decimal points in your DSNHDECP: thus: DSNHDECP SPECIFIES: EUR FOR DATE; EUR FOR TIME; "," FOR DEC PT <<<<
Then in your job you are trying to set a COMMA as a ',' Thus: COMMA ','
This is what is causing the problem.
PFU0083E - SELECT#0001: "COMMA VALUE " INVALID WITH "DEC-PT VALUE"
There have been required changes between R17 and R19 that now prevent you doing this.
That is having both a COMMA and a DECIMAL POINT set as a ','
You will need to change your job from COMMA ',' to a different value that does not clash with your DSNHDECP setting