NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-107
Examples—CONVERT
E PIC X(10) -- WARNING - PIC N
DEFAULT "abcdefgh" NOT NULL ,
--WARNING Default literal originally national language
string
--WARNING The default value is truncated.
G VARCHAR(8) NOT NULL , -- WARNING - PIC N
PRIMARY KEY C
)
If the DDL default string is longer than eight characters, CONVERT truncates the
default string to eight bytes long.
•
The following example illustrates more features of the CONVERT command. The
DDL record definition follows:
RECORD SCHEDULE.
FILE IS "$VOL3.DDL.SCHEDULE" KEY-SEQUENCED.
02 EMP-SCHEDULE.
03 EMPNUM PIC 9(5).
03 EMPNUM-KEY REDEFINES EMPNUM.
05 DEP-KEY PIC X(2).
05 EMP-KEY PIC X(3).
03 DAY-SCHED OCCURS 5 TIMES.
04 DAYNUM PIC X(2).
04 SHIFTS OCCURS 2 TIMES.
05 START-HOUR PIC 9(2).
05 END-HOUR PIC 9(2).
KEY IS EMPNUM DUPLICATES NOT ALLOWED.
END
The following command produces an EDIT file named SCHDCONV, which
contains commands that convert the Enscribe file to a table and includes comments
in the CREATE TABLE command:
>>CONVERT RECORD SCHEDULE TO TABLE $VOL1.PERSNL.SCHEDULE
+>REDEFINE(EMP-SCHEDULE.EMPNUM AS EMP-SCHEDULE.EMPNUM-KEY)
+>COMMENTS SOURCE SCHDCONV CLEAR;