doritariel
Programmer
Am using Informix 7.31. Having a table with a column of type char(1) which stores non-printable characters (0x01 through 0x1c). Is there any way to retrieve such a column through DBACCESS ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retrieveing non-printable character from dbaccess
- Thread starter doritariel
- Start date
- Status
Hi,
Yes, there is. You may activate the hexadecimal load/unload format (XLUF) feature in DB-Access at the command line:
dbaccess -X
When invoked, using this switch, the LOAD and UNLOAD SQL statements can format nonprintable ASCII signs in hexadecimal format.
The hexadecimal data present in the data file will be interpreted properly during a LOAD statement.
The data file generated by the UNLOAD statement contains the hexadecimal format data.
Regards,
Shriyan
"The value of a program is proportional to the weight of its output."
Yes, there is. You may activate the hexadecimal load/unload format (XLUF) feature in DB-Access at the command line:
dbaccess -X
When invoked, using this switch, the LOAD and UNLOAD SQL statements can format nonprintable ASCII signs in hexadecimal format.
The hexadecimal data present in the data file will be interpreted properly during a LOAD statement.
The data file generated by the UNLOAD statement contains the hexadecimal format data.
Regards,
Shriyan
"The value of a program is proportional to the weight of its output."
- Thread starter
- #3
doritariel
Programmer
Thanks - I was aware of the unload/load option (via DBACCESS -X). However, I was looking for a solution which does not involve unloading the table to a file.
Regard,
Doritariel
Regard,
Doritariel
- Status
