HCO for PostgreSQL (Known Issues)

Attention: This feature is in Early Adopter Program (EAP) release status for GDG variant. We intend to provide the finalized feature in a future release. Please contact OpenText Support for Micro Focus Products if you require further clarification.

Neither the Amazon AWS nor the GDG community edition (early adopter program) variants of HCO for PostgreSQL support:

Implicit type casting
Example
```
SELECT ITEM1,ITEM2,ITEM3
     FROM TABLE1 LEFT OUTER JOIN TABLE2
     ON ITEM2 = ITEM3
```
Where TABLE1.ITEM2 is declared as INTEGER and TABLE2.ITEM3 is declared as CHAR(2).
Note: A workaround for this is to cast columns or input host variables explicitly to the correct type. For example:
```
SELECT ITEM1,ITEM2,ITEM3
     FROM TABLE1 LEFT OUTER JOIN TABLE2
     ON ITEM2 = CAST(ITEM3 AS INTEGER)
```
Input host variables of DATE/TIME/TIMESTAMP in Date/Time arithmetic
Note: A workaround for this is to cast these host variables using DATE()/TIME()/TIMESTAMP() functions.
INCLUDING and EXCLUDING clauses in DB2 "DECLARE TEMP TABLE AS …" statements
FINAL TABLE
COBOL stored procedures

In addition, the GDG variant of HCO for PostfreSQL does not support:

EBCDIC database collations