Data Definition Language (DDL) Reference Manual

Definition Attributes
Data Definition Language (DDL) Reference Manual—529431-004
6-43
SQLNULLABLE
Example 6-33. SQL-Nullable Output for C
DDL Type C Type
DEF B SQLNULLABLE.
02 name PIC X(25)
NOT SQLNULLABLE.
02 nickname PIC X(10)
VALUE SQLNULL
02 salary TYPE BINARY
NOT SQLNULLABLE.
02 hire-date TYPE SQL DATE
NOT SQLNULLABLE.
END.
#pragma fieldalign shared2 __b
typedef struct __b
{
char name[25];
struct
{
short indicator;
char valu[10];
} nickname;
short salary;
char hire_date[10];
} b_def;
Example 6-34. SQL-Nullable Output for COBOL
DDL Type COBOL Type
DEF B SQLNULLABLE.
02 name PIC X(25)
NOT SQLNULLABLE.
02 nickname PIC X(10)
VALUE SQLNULL.
02 salary TYPE BINARY
NOT SQLNULLABLE.
02 hire-date TYPE SQL DATE
NOT SQLNULLABLE.
END.
01 B.
02 NAME PIC X(25).
02 FILLER PIC X(1).
02 NICKNAME.
03 INDICATOR PIC S9(4) COMP.
03 VALU PIC X(10).
02 SALARY PIC S9(4) COMP.
02 HIRE-DATE PIC X(10).
Example 6-35. SQL-Nullable Output for FORTRAN
DDL Type FORTRAN Type
DEF B SQLNULLABLE.
02 name PIC X(25)
NOT SQLNULLABLE.
02 nickname PIC X(10)
VALUE SQLNULL.
02 salary TYPE BINARY
NOT SQLNULLABLE.
02 hire-date TYPE SQL DATE
NOT SQLNULLABLE.
END.
RECORD B.
CHARACTER*25 NAME
FILLER*1
RECORD NICKNAME.
INTEGER*2 INDICATOR
CHARACTER*10 VALU
END RECORD
INTEGER*2 SALARY
CHARACTER*10 HIREDATE
END RECORD