SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-30
Defining Columns
E NUMERIC(4, 0) PIC S9(4)
COMP.
short c; int16; int c;
F NUMERIC(4, 0)
UNSIGNED
PIC 9(4) COMP. unsigned short
d;
cardinal; int d
/SMALLINT
UNSIGNED/;
G NUMERIC(9, 2) PIC S9(7)V9(2)
COMP.
long e;
/* scale is 2 */
int32; {*
scale is 2 *}
int(32) e; ! scale
is 2
H NUMERIC(9, 2)
UNSIGNED
PIC 9(7)V9(2)
COMP.
unsigned long f;
/* scale is 2 */
int32; {*
scale is 2 *}
int(32) f
/INTEGER
UNSIGNED/;
! scale is 2
I NUMERIC(18, 2) PIC S9(16)V9(2)
COMP.
long long f;
/* scale is 2 */
int64; {*
scale is 2 *}
(No
arithmetic in
Pascal)
fixed(2) g;
J SMALLINT PIC S9(4)
COMP.
short h; int16; int h;
K SMALLINT
UNSIGNED
PIC 9(4) COMP. unsigned short i; cardinal; int i
/SMALLINT
UNSIGNED/;
L INTEGER PIC S9(9)
COMP.
long j; int32; int(32) j;
M INTEGER
UNSIGNED
PIC 9(9) COMP. unsigned long k; {* k:
UNSIGNED
INTEGER IS
NOT
SUPPORTE
D *}
int(32) k
/INTEGER
UNSIGNED/;
N LARGEINT PIC S9(18)
COMP.
long long l; int64;
(No
arithmetic in
Pascal)
fixed(0) l;
O DECIMAL(18, 2) PIC S9(16)V9(2)
DISPLAY SIGN
IS LEADING.
decimal m[19];
/* scale is 2 */
decimal(18);
{* scale is 2
*}
string m[0:17]
/DECIMAL(18)/;
! scale is 2
P DECIMAL(9, 2)
UNSIGNED
PIC 9(7)V9(2)
DISPLAY.
decimal n[10];
/* scale is 2 */
decimal(9);
{* scale is 2
*}
string n[0:8]
/DECIMAL(9)
UNSIGNED/;
! scale is 2
Table 5-1. Summary of Corresponding Data Types (page2of3)
SQL/MP Column
Name and Data
Type COBOL C Pascal TAL