DMSQ PROJECT (8012)    OPTION (19)

View in ViViaN Menu
Name Value
NAME DMSQ PROJECT
X ACTION PRESENT YES
MENU TEXT Regenerate SQLI Projection
UPPERCASE MENU TEXT REGENERATE SQLI PROJECTION
PACKAGE VA FILEMAN
E ACTION PRESENT YES
EXIT ACTION ;vendor's mapper call could go here
ENTRY ACTION ;vendor's keyword call could go here
SCHEDULING RECOMMENDED YES
ROUTINE SETUP^DMSQ
LOCK XUPROGMODE
DESCRIPTION
Regenerates the SQLI projection of VA FileMan data dictionaries. The
 
This option requires programmer mode as well as the progmode key.
 
This option may also be used as a skeleton for one that you may want
to create locally.  Your local option could include the vendor's
keyword call in the Entry Action and the vendor's mapping call in the
Exit Action.  A status variable could be used to confirm that the
SQLI projection completes before the vendor mapping is initiated.
regeneration process:
 
  1. Purges existing information in SQLI data files.
  2. Projects the data dictionaries for all VA FileMan files.
 
Before running this option, the SQLI_KEY_WORD file should be populated
with all SQL, ODBC, and vendor-specific keywords that should not be used
in SQLI entity naming.
CREATOR USER,FIFTYFOUR
TYPE run routine