Download User Manual

Varchar2
Byte
Number
Varies, see below
Long
Not supported
Rowid
Not supported
Date
Oracle Date
Raw
Not supported
Long raw
Not supported
Char
Byte
Mislabel
Not supported
Number Data-Type
Oracle numbers are translated into a variety of Suprtool data-types. The translation
depends on the precision of the number and the number of decimal places. The
following table describes the translation for each case:
Precision
Decimal Places
Suprtool Data-Type
None
Any
8-byte IEEE
1-4
Zero
2-byte Integer
5-9
Zero
4-byte Integer
1-9
Non-zero
Packed-decimal
10-27
Any
Packed-decimal
28-38
Any
8-byte IEEE
In packed-decimal translations Suprtool uses the precision of the number to
determine the size of a packed-decimal number.
Order By vs. Sort
Oracle's Order By statement on the Select command does not always generate the
same results. Specifically, sorted fields with null field values appear at the beginning
when they are sorted by Suprtool's Sort command.
Restrictions
Suprtool/UX cannot handle all Oracle database concepts. The current restrictions are:
1.
Suprtool/UX can handle varchar2, char, date, and number data-types. It
cannot handle any other data-type.
2.
Because any Oracle Select command can be used, it is possible to
generate column names that are not compatible with Suprtool/UX. For
example,
>select sal + comm from bonus
This example produces a column called "sal + comm". In some cases Suprtool/UX
correctly uses this as the column name (e.g., the List command). You cannot refer to
this column by name in any Suprtool/UX command that accepts field names as a
parameter.
Suprtool 5.0 for HP-UX
Suprtool Issues and Solutions • 65