SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-26
Using Backup and Restore 2 to Create Offline RDF
Backup Databases
Retrieving Saved DDL
The DDL for a CREATE TABLE statement is written to an OSS file named
/usr/tandem/sqlmx/ddl/catalog.schema.tablename-yyyymmdd-
timestamp.ddl.
For example, if the table CAT.SCH.TAB01 is dropped at 11:57:15 am on April 23,
2003, the saved DDL file is:
/usr/tandem/sqlmx/ddl/CAT.SCH.TAB01-20030423-115715.ddl
If the table name contains a delimiter in this list, the delimiter is replaced by an
underscore in the OSS file name:
•
" (quotes within the delimited name)
•
& (ampersand)
•
() (parentheses)
•
* (asterisk)
•
, (comma)
•
/ (forward slash)
•
; (semicolon)
•
<> (angle brackets)
•
? (question mark)
•
[] (square brackets)
•
| (bar)
•
\ (back slash)
In each case, the quotes delimiting the identifier are removed. For example, if the table
CAT.”S&C%H”.”T*A*B?01” is dropped at 12:57:15 am on April 24, 2003, the saved
DDL file would be:
/usr/tandem/sqlmx/ddl/CAT.S_C_H.T_A_B_01-20030424-215715.ddl
If the three-part ANSI name exceeds the maximum OSS file name length of 248, it is
truncated to 248 characters.
Files with similar names can be distinguished by:
•
The trailing timestamp portion of the name
•
The contents of the file, which always indicates the full ANSI name of the table
Note. Note that NonStop SQL/MX does not remove these files You must remove unwanted
files from this location.