Kbase P111911: Ascii dump fails with error "INPUT/OUTPUT operations are not allowed with datatype fixchar". (6901)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/12/2005 |
|
Status: Unverified
SYMPTOM(s):
Ascii dump fails with error "INPUT/OUTPUT operations are not allowed with datatype fixchar". (6901)
SQL-92 Table includes fixchar type defined for column
CAUSE:
fixchar datatype is not supported with SQL-92 or 4GL
FIX:
The table can not be dumped with 4GL or SQL but a connection can be made with a SQL-92 client to retrieve records.
Select * from <ownername>."<tablename>";
Capture the output from the command.
Drop the table from the database after all data from the database has been captured.
Re-create the table with a valid field datatype.