Chapter 3 DBMS Reference Guide


Variables for reverse engineering

Variable name Comment
R Set to TRUE during reverse engineering
S Allow to skip a word. The string is parsed for reverse but not generated
D Allow to skip a numeric value. The numeric value is parsed for reverse but not generated
A Allow to skip all Text. The text is parsed for reverse but not generated
ISODBCUSER True if Current user is Connected one
CATALOG Catalog name to be used in ODBC reverse queries
SCHEMA Variable representing a user login and the object belonging to this user in the database. You should use this variable for queries on objects listed in ODBC reverse dialog boxes, because their owner is not defined yet. Once the owner of an object is defined, you can use SCHEMA or OWNER
SIZE Data type size of column or domain. Used for reverse ODBC, when the length is not defined in the system tables
VALUE One value from the list of values in a column or domain
PERMISSION Allow to reverse engineer permissions set on a database object
PRIVILEGE Allow to reverse engineer privileges set on a user, a group, or a role

 


Copyright (C) 2005. Sybase Inc. All rights reserved.