SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

221

222

223

224

225

226

227

228

229

230

HP NonStop SQL/MP Reference Manual—523352-013

C-94

CONVERT Command

CONVERT is an SQLCI utility that creates an EDIT file containing SQL commands to

convert an Enscribe file described in a Data Definition Language (DDL) dictionary to an

SQL table described in a specific catalog. You can invoke the EDIT file commands by

using the OBEY command to create:



a table containing rows that correspond to the record definition of the Enscribe file

and columns that correspond to the fields in each record.



indexes on the table that correspond to the alternate keys associated with the

Enscribe file.

If SMF is installed on your node, files you specify in CONVERT syntax cannot be on

any $*.ZYS*. subvolumes.

CONVERT RECORD ddl-record-name TO TABLE table-name

[ [,] convert-option ] ... ;

convert-option is:

{ MAP NAME[S] { map } }

{ { ( map [ , map ] ... ) } }

{ }

{ CATALOG[S] { catalog-spec }

{ { ( catalog-spec [, catalog-spec ]...) }

{ }

{ COMMENTS }

{ }

{ DICTIONARY subvol }

{ }

{ FILE IS enscribe-file }

{ }

{ { LOAD | NO LOAD } }

{ }

{ { PART | NO PART } }

{ }

{ SOURCE edit-file [ CLEAR ] }

{ }

{ { VARCHARS | NO VARCHARS } }

{ }

{ REDEFINE ( redef-spec [, redef-spec ] ... ) }

{ }