WebFOCUS Data types and their SQL equivalent

An CHARacter (fixed length)
AnV CHARacter VARying (maximum length)
TX TEXT, CLOB – Character Large Object
BLOB BLOB – Binary Large Object
I2 SMALLINT – 2 bytes
I4 INTEGER – 4 bytes
F FLOAT – floating point 4 bytes
D DOUBLE PRECISION – floating point 8 bytes
Pn PACKED DECIMAL (number of bytes specified 1-16)
DATE DATE
HYYMDx DATETIME, TIMESTAMP
HHx TIME

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *