Kbase P48252: ASCII dump of a SQL-92 table fails with an error 6901
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Ascii dump fails with an error "INPUT/OUTPUT operations are not allowed with datatype TIMESTAMP". (6901)
SQL-92 Table includes TIMESTAMP column
CAUSE:
TIMESTAMP datatype is not supported in 4GL.
FIX:
You have to use sqldump and sqlload utilities instead. The syntax is:
sqldump -u username -a password -t tablename progress:T:host:port:dbname
sqlload -u username -a password -t tablename progress:T:host:port:dbname
References to Written Documentation: Database Administration Guide and Reference, chapter 18.15 SQLDUMP Utility