1. CONVERT.SQL FILE_NAME
CONVERT.SQL [filename][length] [CHECKONLY | FORCE] [PUBLIC [privilege]]
2. Copy DICT Items to converted file.
COPY FROM DICT FILE.NAME TO DICT FILE_NAME DICT_ITEMS
3. SQL>
a. LISTDICT FILE_NAME;
b. select * from privilege where @ID like "%C21%";
c. GRANT {ALL PRIVILEGES | privilege[,privilege]...
ON table_spec
TO {PUBLIC | user_name [,user_name]...}
[WITH GRANT OPTION]
Privilege Specifies privilege(s) to grant the user(s):
DELETE - Privilege to delete rows from a table, subtable, or view.
INSERT - Privilege to insert rows in a table, subtable, or view.
SELECT - Privilege to select data in a table, subtable, or view.
UPDATE - Privilege to change values in a table, subtable, or view.
d. CREATE VIEW NEW_VIEW
AS SELECT * FROM INVENTORY
WHERE COLOR LIKE "B%";
GRANT ALL PRIVILEGES ON NEW_VIEW TO PUBLIC;
* UniData Documentation: :HELP SQL, :HELP CONVERT.SQL
