Batch processing in Showcase will only generate HEX or GRAPHIC fields in the output table. This is causing issues with applications that are expecting certain fields to be CHAR.
Running a batch query connecting to a ShowCase server writing the results to a batch table only returns the data types of graphics or hex. As a result a column defined as character (10) will not be returned as character (10) but as data type GRAPHICS when querying the result table via ShowCase Query.
Error seen in Batch Query:
Job State: The batch job failed due to a SQL error. Character conversion between CCSID 13488 and CCSID 65535 not valid
Configuration change within the showcase.cfg file is now required. The column CCSIDs in the batch query results table will then retain the CCSID of the original table and a data type used within valid CAST functions will now be honored in the batch results tables.
showcasecorp.batchQuery.useOriginalCCSIDs=true
edtf '/scserver/proddata/config/showcase.cfg'
(replace 'scserver' with the name of your ShowCase server library)
Notes:
Ref#: 1478835
Still have questions? We can help. Submit a case to Technical Support.