home *** CD-ROM | disk | FTP | other *** search
/ Java 1.2 How-To / JavaHowTo.iso / 3rdParty / jbuilder / TRIAL / JBUILDER / JRUNTIME.Z / dbx.dbi < prev    next >
Encoding:
Borland DataBase Explorer Information  |  1998-05-08  |  135.4 KB  |  3,072 lines
  1.  
  2.  
  3. [Version]
  4. DbXName="SQL Explorer"
  5. DbXDR=True
  6. DbXVersion=3.00
  7.  
  8. [Properties]
  9. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,ASCIIDRV
  10. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  11. NET PROTOCOL:Values2=APPC,ASYNC
  12. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  13. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  14. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  15. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  16. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  17. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  18. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  19. ENABLE BCD:Values=Closed,FALSE,TRUE
  20. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  21. LOCAL SHARE:Values=Closed,FALSE,TRUE
  22. AUTO ODBC:Values=Closed,FALSE,TRUE
  23. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  24. YEARBIASED:Values=Closed,FALSE,TRUE
  25. LEADINGZEROM:Values=Closed,FALSE,TRUE
  26. LEADINGZEROD:Values=Closed,FALSE,TRUE
  27. TWELVEHOUR:Values=Closed,FALSE,TRUE
  28. SECONDS:Values=Closed,FALSE,TRUE
  29. MILSECONDS:Values=Closed,FALSE,TRUE
  30. LEADINGZERON:Values=Closed,FALSE,TRUE
  31. COLLCHAR:Values=Closed,0,1,2
  32. DBNLS:Values=Closed,0,1,2
  33. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  34.  
  35. :HelpContext=4039
  36. DB2:HelpContext=4038
  37. INFORMIX:HelpContext=4035
  38. INTRBASE:HelpContext=4037
  39. MSACCESS:HelpContext=4042
  40. MSSQL:HelpContext=4036
  41. ORACLE:HelpContext=4034
  42. STANDARD:HelpContext=4045
  43. SYBASE:HelpContext=4033
  44.  
  45. MSSQL:Identity=select substring(@@version,1,charindex(char(0x0a),@@version)-1)
  46. MSSQL:IdentityRE=SQL Server [^0-9]*([0-9]+)\.
  47.  
  48. SYBASE:Identity=select @@version
  49. SYBASE:IdentityRE=SQL Server/([0-9]+)\.
  50. SYBASE:IdentityMap:11=10
  51.  
  52. ORACLE:Identity=select 'Oracle ' || VERSION_TEXT from SM$VERSION
  53. ORACLE:IdentityRE=([0-9]+\.[0-9]*)
  54. ORACLE:IdentityMap:7.3=7.2
  55.  
  56. INFORMIX:Identity=select 'Informix ' || owner from informix.systables where tabid=99
  57. INFORMIX:IdentityRE=([0-9]+)\.
  58.  
  59. DB2:IdentityMap:DB2/2=Common Server
  60. DB2:IdentityMap:DB2/NT=Common Server
  61. DB2:IdentityMap:DB2/AIX=Common Server
  62.  
  63. [DATAREP Properties]
  64. BDETypes:Values1=Closed,1=ZString,2=Date,3=Blob,4=Bool,5=Int16,6=Int32
  65. BDETypes:Values2=7=Float,8=BCD,9=Bytes,10=Time,11=TimeStamp,12=UInt16
  66. BDETypes:Values3=13=UInt32,14=IEEE Float,15=VarBytes,16=LockInfo
  67.  
  68. BDESubTypes:Values1=Closed,0=,1=Password,21=Money,22=Memo,23=Binary
  69. BDESubTypes:Values2=24=Formatted Memo,25=OLE Object,26=Graphic
  70. BDESubTypes:Values3=27=DBase OLE Object,28=Typed Binary,29=Auto Increment
  71.  
  72. TScale:Values=Open,0=
  73. TBooleanTF:Values=Closed,0=False,-1=True
  74. TAlignment:Values=Closed,0=taLeftJustify,1=taRightJustify,2=taCenter
  75.  
  76. TFieldType:Values1=Closed,0=ftUnknown,1=ftString,2=ftSmallint,3=ftInteger
  77. TFieldType:Values2=4=ftWord,5=ftBoolean,6=ftFloat,7=ftCurrency,8=ftBCD
  78. TFieldType:Values3=9=ftDate,10=ftTime,11=ftDateTime,12=ftBytes
  79. TFieldType:Values4=13=ftVarBytes,14=ftAutoInc,15=ftBlob,16=ftMemo
  80. TFieldType:Values5=17=ftGraphic,18=ftFmtMemo,19=ftParadoxOle
  81. TFieldType:Values6=20=ftDBaseOle,21=ftTypedBinary
  82.  
  83. TBlobType:Values1=Closed,15=ftBlob,16=ftMemo,17=ftGraphic,18=ftFmtMemo
  84. TBlobType:Values2=19=ftParadoxOle,20=ftDBaseOle,21=ftTypedBinary
  85.  
  86. DRDATABASES:Reference="Databases"
  87. DREXTFIELDS:Reference="Attribute Sets"
  88. DBTABLES:Reference="Tables"
  89. TABLEFLDS:Reference="Fields"
  90. FLDEXTFIELD:Reference="Attribute Set"
  91. EXTFIELDFLDS:Reference="Referencing Fields"
  92. PARENTEXTFIELD:Reference="Based On"
  93. CHILDEXTFIELD:Reference="Referencing Attribute Sets"
  94.  
  95. DATABASE:Category=Database
  96. DATABASE:NameRE=.*
  97. DATABASE:Attrs=DBPATH="Path":0:-E,DBTYPE="Type"::-E
  98.  
  99. TABLE:Category=Dataset
  100. TABLE:NameRE=.*
  101. TABLE:Attrs=PATH=:0,DRIVERTYPE="Type"::-E,ISFILE=:0,ISVIEW=:0,ISSYNONYM=:0
  102.  
  103. FIELD:Category=Column
  104. FIELD:Attrs1=PHYTYPE="Physical Type"::-E
  105. FIELD:Attrs2=LOGTYPE="Logical Type"::-E:::VM=BDETypes
  106. FIELD:Attrs3=LOGSUBTYPE="Logical Subtype"::-E:::VM=BDESubTypes
  107. FIELD:Attrs4=UNITS1="Size"::-E
  108. FIELD:Attrs5=UNITS2="Scale"::-E:::VM=TScale
  109. FIELD:Attrs6=DEFVAL=:2:-E
  110. FIELD:Attrs7=MINVAL=:2:-E
  111. FIELD:Attrs8=MAXVAL=:2:-E
  112. FIELD:Attrs9=REQUIRED=:0:-E:::VM=TBooleanTF
  113. FIELD:Attrs10=READONLY=:0:-E:::VM=TBooleanTF
  114.  
  115. EXTFIELD:NameRE=.*
  116. EXTFIELD:Attrs1=FIELDCLASS=:1
  117. EXTFIELD:Attrs2=CONTROLCLASS=:1
  118. EXTFIELD:Attrs3=ALIGNMENT=:2::::VM=TAlignment
  119. EXTFIELD:Attrs4=DISPLABEL=:2
  120. EXTFIELD:Attrs5=DISPWIDTH=:2
  121. EXTFIELD:Attrs6=READONLY=:2::::VM=TBooleanTF
  122. EXTFIELD:Attrs7=REQUIRED=:2::::VM=TBooleanTF
  123. EXTFIELD:Attrs8=VISIBLE=:2::::VM=TBooleanTF
  124. EXTFIELD:Attrs9=TRANSLITERATE=:2::::VM=TBooleanTF
  125. EXTFIELD:Attrs10=EDITMASK=:2
  126. EXTFIELD:Attrs11=DISPFORMAT=:2
  127. EXTFIELD:Attrs12=EDITFORMAT=:2
  128. EXTFIELD:Attrs13=MINVAL=:2
  129. EXTFIELD:Attrs14=MAXVAL=:2
  130. EXTFIELD:Attrs15=CURRENCY=:2::::VM=TBooleanTF
  131. EXTFIELD:Attrs16=PRECISION=:2
  132. EXTFIELD:Attrs17=DISPLAYVALUES=:2
  133. EXTFIELD:Attrs18=BLOBTYPE=:2::::VM=TBlobType
  134.  
  135. [DATAREP 20 Properties]
  136. TABLECONSTRS:Reference="Check Constraints"
  137.  
  138. CONSTRAINT:NameRE=.*
  139. CONSTRAINT:Attrs1=SRVCHECK=:2:-E
  140. CONSTRAINT:Attrs2=LOCCHECK=:2
  141. CONSTRAINT:Attrs3=ERRORSTR=:2
  142.  
  143. EXTFIELD:Attrs1=SRVDOMAINNAME=:1:-E
  144. EXTFIELD:Attrs2=FIELDCLASS=:1
  145. EXTFIELD:Attrs3=CONTROLCLASS=:1
  146. EXTFIELD:Attrs4=ALIGNMENT=:2::::VM=TAlignment
  147. EXTFIELD:Attrs5=DISPLABEL=:2
  148. EXTFIELD:Attrs6=DISPWIDTH=:2
  149. EXTFIELD:Attrs7=READONLY=:2::::VM=TBooleanTF
  150. EXTFIELD:Attrs8=REQUIRED=:2::::VM=TBooleanTF
  151. EXTFIELD:Attrs9=VISIBLE=:2::::VM=TBooleanTF
  152. EXTFIELD:Attrs10=TRANSLITERATE=:2::::VM=TBooleanTF
  153. EXTFIELD:Attrs11=EDITMASK=:2
  154. EXTFIELD:Attrs12=DISPFORMAT=:2
  155. EXTFIELD:Attrs13=EDITFORMAT=:2
  156. EXTFIELD:Attrs14=MINVAL=:2
  157. EXTFIELD:Attrs15=MAXVAL=:2
  158. EXTFIELD:Attrs16=CURRENCY=:2::::VM=TBooleanTF
  159. EXTFIELD:Attrs17=PRECISION=:2
  160. EXTFIELD:Attrs18=DISPLAYVALUES=:2
  161. EXTFIELD:Attrs19=BLOBTYPE=:2::::VM=TBlobType
  162. EXTFIELD:Attrs20=DEFAULT=:2
  163. EXTFIELD:Attrs21=SRVCHECK=:2:-E
  164. EXTFIELD:Attrs22=LOCCHECK=:2
  165. EXTFIELD:Attrs23=ERRORSTR=:2
  166.  
  167. [STANDARD Properties]
  168. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  169. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  170. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  171. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  172. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  173. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  174. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  175. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  176. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  177. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  178. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  179. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  180. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  181. FamilyMemberType:Values3=8="Blob File"
  182.  
  183. STANDARD:Objects=O:C:0M::"Tables":Table
  184.  
  185. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  186. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  187. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  188. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  189. Table:Dataset5=PROTECTED=Word,VALID=Word
  190.  
  191. Table:Category=Dataset
  192. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  193. Table:Attrs2=DATE="Date"
  194. Table:Attrs3=TIME="Time"
  195. Table:Attrs4=VERSION="Version":2
  196. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  197. Table:Attrs6=STRUCTURE="Structure":2
  198. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  199. Table:Name=FILENAME,EXTENSION
  200. Table:Objects1=O:P:1M::"Fields":Column
  201. Table:Objects2=O:O:0M::"Indices":Index
  202. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  203. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  204. Table:Objects5=O:O:0M::"Security Specs":Security
  205. Table:Objects6=O:C:1M::"Family Members":Family
  206.  
  207. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  208. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  209. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  210.  
  211. Column:Category=Column
  212. Column:Order=FIELDNUM
  213. Column:Attrs1=FIELDNUM="Order":2:NR
  214. Column:Attrs2=TYPE="Type":1:NR
  215. Column:Attrs3=UNITS1="Size":1:N
  216. Column:Attrs4=UNITS2="Scale":1:N
  217. Column:Attrs5=LENGTH="Physical Length"
  218. Column:Name=NAME
  219.  
  220. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  221. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  222. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  223. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  224. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  225. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  226.  
  227. Index:Category=Index
  228. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  229. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  230. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  231. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  232. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  233. Index:Attrs6=FORMAT="Format":2
  234. Index:Attrs7=BLOCKSIZE="Block Size":2
  235. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  236. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  237. Index:Attrs10=EXPRESSION="Expression":2:N
  238. Index:Attrs11=CONDITION="Subset Condition":2:N
  239. Index:Name=NAME
  240. Index:OnAfterLoad=GetIndexInfo
  241.  
  242. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  243. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  244. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  245. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  246.  
  247. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  248. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  249. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  250. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  251. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  252. ValCheck:Attrs6=PICTURE="Picture":2:N
  253. ValCheck:Name=FIELDNUM
  254.  
  255. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  256.  
  257. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  258. Family:Attrs2=NAME="Object Name":1
  259. Family:Name=FILENAME
  260.  
  261. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  262. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  263. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  264.  
  265. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  266. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  267. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  268. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  269. Reference:Name=NAME
  270. Reference:OnAfterLoad=GetReferenceInfo
  271.  
  272. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  273. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  274.  
  275. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  276. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  277. Security:Name=PASSWORD
  278.  
  279. [MSACCESS Properties]
  280. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  281. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  282. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  283. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  284. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  285. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  286. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  287. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  288. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  289. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  290. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  291.  
  292. MSACCESS:Objects=O:C:0M::"Tables":Table
  293.  
  294. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  295. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  296. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  297. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  298. Table:Dataset5=PROTECTED=Word,VALID=Word
  299.  
  300. Table:Category=Dataset
  301. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  302. Table:Attrs2=DATE="Date"
  303. Table:Attrs3=TIME="Time"
  304. Table:Attrs4=VERSION="Version":2
  305. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  306. Table:Attrs6=STRUCTURE="Structure":2
  307. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  308. Table:Name=FILENAME,EXTENSION
  309. Table:Objects1=O:P:1M::"Fields":Column
  310. Table:Objects2=O:O:0M::"Indices":Index
  311. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  312. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  313. Table:Objects5=O:O:0M::"Security Specs":Security
  314.  
  315. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  316. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  317. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  318.  
  319. Column:Category=Column
  320. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  321. Column:Attrs2=LENGTH="Physical Length"
  322. Column:Name=NAME
  323.  
  324. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  325. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  326. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  327. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  328. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  329. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  330.  
  331. Index:Category=Index
  332. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  333. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  334. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  335. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  336. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  337. Index:Attrs6=FORMAT="Format":2
  338. Index:Attrs7=BLOCKSIZE="Block Size":2
  339. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  340. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  341. Index:Attrs10=EXPRESSION="Expression":2:N
  342. Index:Attrs11=CONDITION="Subset Condition":2:N
  343. Index:Name=NAME
  344. Index:OnAfterLoad=GetIndexInfo
  345.  
  346. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  347. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  348. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  349. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  350.  
  351. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  352. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  353. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  354. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  355. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  356. ValCheck:Attrs6=PICTURE="Picture":2:N
  357. ValCheck:Name=FIELDNUM
  358.  
  359. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  360. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  361. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  362.  
  363. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  364. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  365. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  366. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  367. Reference:Name=NAME
  368. Reference:OnAfterLoad=GetReferenceInfo
  369.  
  370. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  371. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  372.  
  373. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  374. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  375. Security:Name=PASSWORD
  376.  
  377. [ODBC Properties]
  378. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  379. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  380. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  381. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  382. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  383. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  384. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  385. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  386. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  387. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  388. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  389.  
  390. ODBC:Objects1=O:C:0M::"Tables":Table
  391. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  392.  
  393. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  394. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  395. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  396. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  397. Table:Dataset5=PROTECTED=Word,VALID=Word
  398.  
  399. Table:Category=Dataset
  400. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  401. Table:Attrs2=DATE="Date"
  402. Table:Attrs3=TIME="Time"
  403. Table:Attrs4=VERSION="Version":2
  404. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  405. Table:Attrs6=STRUCTURE="Structure":2
  406. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  407. Table:Name=FILENAME,EXTENSION
  408. Table:Objects1=O:P:1M::"Fields":Column
  409. Table:Objects2=O:O:0M::"Indices":Index
  410. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  411. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  412. Table:Objects5=O:O:0M::"Security Specs":Security
  413.  
  414. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  415. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  416. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  417.  
  418. Column:Category=Column
  419. Column:Order=FIELDNUM
  420. Column:Attrs1=FIELDNUM="Order":2:NR
  421. Column:Attrs2=TYPE="Type":1:NR
  422. Column:Attrs3=UNITS1="Size":1:N
  423. Column:Attrs4=UNITS2="Scale":1:N
  424. Column:Attrs5=LENGTH="Physical Length"
  425. Column:Name=NAME
  426.  
  427. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  428. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  429. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  430. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  431. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  432. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  433.  
  434. Index:Category=Index
  435. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  436. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  437. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  438. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  439. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  440. Index:Attrs6=FORMAT="Format":2
  441. Index:Attrs7=BLOCKSIZE="Block Size":2
  442. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  443. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  444. Index:Attrs10=EXPRESSION="Expression":2:N
  445. Index:Attrs11=CONDITION="Subset Condition":2:N
  446. Index:Name=NAME
  447. Index:OnAfterLoad=GetIndexInfo
  448.  
  449. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  450. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  451. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  452. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  453.  
  454. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  455. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  456. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  457. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  458. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  459. ValCheck:Attrs6=PICTURE="Picture":2:N
  460. ValCheck:Name=FIELDNUM
  461.  
  462. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  463. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  464. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  465.  
  466. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  467. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  468. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  469. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  470. Reference:Name=NAME
  471. Reference:OnAfterLoad=GetReferenceInfo
  472.  
  473. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  474. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  475.  
  476. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  477. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  478. Security:Name=PASSWORD
  479.  
  480. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  481.  
  482. Procedure:Category=Executable
  483. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  484. Procedure:EAttrs=Data
  485. Procedure:Name=NAME
  486.  
  487. [ORACLE Properties]
  488. TBooleanNY:Values=Closed,N="No",Y="Yes"
  489. TBlank0:Values=Open,0=
  490. TValid:Values=Closed,INVALID=:"No",VALID=:"Yes"
  491. TDisabled:Values=Closed,ENABLED=ENABLE:"No",DISABLED=DISABLE:"Yes"
  492. TDataType:Values1=Open,CHAR=`'CHAR('=Length')'`:CHAR
  493. TDataType:Values2=DATE=DATE
  494. TDataType:Values3=FLOAT=FLOAT
  495. TDataType:Values4=LONG=LONG
  496. TDataType:Values5=LONG RAW=LONG RAW
  497. TDataType:Values6=MLSLABEL=MLSLABEL
  498. TDataType:Values7=NUMBER=NUMBER
  499. TDataType:Values8=RAW=`'RAW('=Length')'`:RAW
  500. TDataType:Values9=ROWID=ROWID
  501. TDataType:Values10=VARCHAR2=`'VARCHAR2('=Length')'`:VARCHAR2
  502. TUnique:Values=Closed,NONUNIQUE=:"No",UNIQUE=UNIQUE:"Yes"
  503. TNulls:Values=Closed,N=NOT NULL:"No",Y=:"Yes"
  504. TBeforeAfter:Values=Closed,0=BEFORE:"Before",-1=AFTER:"After"
  505. TRowStatement:Values1=Closed,STATEMENT=:"For each statement"
  506. TRowStatement:Values2=ROW=FOR EACH ROW:"For each row"
  507. TMaxValue:Values=Open,=`'MAXVALUE ' @MaxValue`:`:MaxValue`,1E+27=NOMAXVALUE:"None"
  508. TMinValue:Values=Open,=`'MINVALUE ' @MinValue`:`:MinValue`,1E+27=NOMINVALUE:"None"
  509. TCycle:Values=Closed,N=NOCYCLE:"No",Y=CYCLE:"Yes"
  510. TOrder:Values=Closed,N=NOORDER:"No",Y=ORDER:"Yes"
  511. TCache:Values=Open,=`'CACHE ' @Cache`:`:Cache`,0=NOCACHE:"None"
  512. TTSStatus:Values1=Closed,ONLINE=ONLINE:"Online",OFFLINE=OFFLINE:"Offline"
  513. TTSStatus:Values2=READ ONLY=:"Read Only",INVALID=:"Invalid"
  514. TCluster:Values=Closed,INDEX=INDEX:"Index",HASH=HASH:"Hash"
  515. THashFn:Values1=Closed,COLUMN=:"Column",DEFAULT=:"Default",HASH EXPRESSION=:"Expression"
  516. THashFn:Values2=DEFAULT2=:"Default2"
  517. TRefresh:Values=Closed,FAST=FAST:"Fast",COMPLETE=COMPLETE:"Complete",FORCE=FORCE:"Force"
  518.  
  519. Template:Storage1=`! \N '    INITIAL ' =INITIAL_EXTENT`
  520. Template:Storage2=`! \N '    NEXT ' =NEXT_EXTENT`
  521. Template:Storage3=`! \N '    MINEXTENTS ' =MIN_EXTENTS`
  522. Template:Storage4=`! \N '    MAXEXTENTS ' =MAX_EXTENTS`
  523. Template:Storage5=`! \N '    PCTINCREASE ' =PCT_INCREASE`
  524.  
  525. Template:ObjectStorage=`ETemplates Storage`
  526.  
  527. ORACLE:UserName=select user from dual
  528. ORACLE:Comments=--;/*,*/
  529.  
  530. ORACLE:Objects1=O:C:0M::"Tables":Table
  531. ORACLE:Objects2=O:C:0M::"Views":View
  532. ORACLE:Objects3=O:C:0M::"Synonyms":Synonym
  533. ORACLE:Objects4=O:C:0M::"Snapshots":Snapshot
  534. ORACLE:Objects5=O:C:0M::"Clusters":Cluster
  535. ORACLE:Objects6=O:C:0M::"TableSpaces":TableSpace
  536. ORACLE:Objects7=O:C:0M::"Sequences":Sequence
  537. ORACLE:Objects8=O:C:0M::"Procedures":Procedure
  538. ORACLE:Objects9=O:C:0M::"Functions":Function
  539. ORACLE:Objects10=O:C:0M::"Packages":Package
  540. ORACLE:Objects11=O:C:0M::"Package Bodies":PackageBody
  541.  
  542. SYS.ALL_OBJECTS:Name=OWNER,OBJECT_NAME
  543. SYS.ALL_OBJECTS:Attrs1=STATUS="Valid":::::VM=TValid
  544. SYS.ALL_OBJECTS:Attrs2=CREATED="Created"
  545. SYS.ALL_OBJECTS:Attrs3=LAST_DDL_TIME="Modified"
  546. SYS.ALL_OBJECTS:FilterSystemObjects=A.OWNER <> 'SYS'
  547.  
  548. SYS.ALL_TABLES:Name=OWNER,TABLE_NAME
  549. SYS.ALL_TABLES:Objects1=T:P:1M::"Columns":Column
  550. SYS.ALL_TABLES:Objects2=T:O:0M::"Indices":Index
  551. SYS.ALL_TABLES:Objects3=T:O:01::"Primary Key":PrimaryKey
  552. SYS.ALL_TABLES:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  553. SYS.ALL_TABLES:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  554. SYS.ALL_TABLES:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  555. SYS.ALL_TABLES:Objects7=T:O:0M::"Triggers":Trigger
  556. SYS.ALL_TABLES:Objects8=P:R:M1::"TableSpace":TableSpace
  557. SYS.ALL_TABLES:Objects9=P:R:M1::"Cluster":Cluster
  558. SYS.ALL_TABLES:Attrs1=BACKED_UP="Backed Up":::::VM=TBooleanNY
  559. SYS.ALL_TABLES:Attrs2=PCT_FREE="Block Min % Free":2:E
  560. SYS.ALL_TABLES:Attrs3=PCT_USED="Block Min % Used":2:E
  561. SYS.ALL_TABLES:Attrs4=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  562. SYS.ALL_TABLES:Attrs5=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  563. SYS.ALL_TABLES:Attrs6=INITIAL_EXTENT="Initial Extent (B)":2:E
  564. SYS.ALL_TABLES:Attrs7=NEXT_EXTENT="Next Extent (B)":2:E
  565. SYS.ALL_TABLES:Attrs8=MIN_EXTENTS="Min Extents":2:E
  566. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2:E
  567. SYS.ALL_TABLES:Attrs10=PCT_INCREASE="Extent Size % Increase":2:E
  568. SYS.ALL_TABLES:Attrs11=NUM_ROWS="Row Count":2
  569. SYS.ALL_TABLES:Attrs12=CHAIN_CNT="Chained Rows":2
  570. SYS.ALL_TABLES:Attrs13=BLOCKS="Data Block Count":2
  571. SYS.ALL_TABLES:Attrs14=EMPTY_BLOCKS="Empty Data Blocks":2
  572. SYS.ALL_TABLES:Attrs15=AVG_SPACE="Avg Bytes Free / Block":2
  573. SYS.ALL_TABLES:Attrs16=AVG_ROW_LEN="Avg Row Length":2
  574. SYS.ALL_TABLES:Reference:"TableSpace"=TABLESPACE_NAME
  575. SYS.ALL_TABLES:Reference:"Cluster"=CLUSTER_NAME
  576. SYS.ALL_TABLES:FilterSystemObjects=A.OWNER <> 'SYS'
  577.  
  578. SYS.ALL_SYNONYMS:Name=OWNER,SYNONYM_NAME
  579. SYS.ALL_SYNONYMS:Attrs1=TABLE_OWNER="Target Owner"::E
  580. SYS.ALL_SYNONYMS:Attrs2=TABLE_NAME="Target Object"::ER
  581. SYS.ALL_SYNONYMS:Attrs3=DB_LINK="Database"::E
  582. SYS.ALL_SYNONYMS:Reference:"Target"=TABLE_OWNER,TABLE_NAME
  583.  
  584. SYS.ALL_SNAPSHOTS:Name=OWNER,NAME
  585. SYS.ALL_SNAPSHOTS:Objects=P:R:M1::"Snapshot Table":Table
  586. SYS.ALL_SNAPSHOTS:Attrs1=TYPE="Refresh Type"::E:::VM=TRefresh
  587. ; !!! First Refresh::E
  588. SYS.ALL_SNAPSHOTS:Attrs2=START_WITH="First Refresh"
  589. SYS.ALL_SNAPSHOTS:Attrs3=NEXT="Next Refresh"::E
  590. SYS.ALL_SNAPSHOTS:Attrs4=QUERY="Snapshot Query":2:ER
  591. SYS.ALL_SNAPSHOTS:Attrs5=ERROR="Error"
  592. SYS.ALL_SNAPSHOTS:Attrs6=LAST_REFRESH="Last Refresh"
  593. SYS.ALL_SNAPSHOTS:Attrs7=MASTER_LINK="Master Database":2
  594. SYS.ALL_SNAPSHOTS:Attrs8=MASTER_OWNER="Master Owner":2
  595. SYS.ALL_SNAPSHOTS:Attrs9=MASTER_VIEW="Master View":2
  596. SYS.ALL_SNAPSHOTS:Attrs10=MASTER="Master Table":2
  597. SYS.ALL_SNAPSHOTS:Attrs11=UPDATABLE="Updatable":2
  598. SYS.ALL_SNAPSHOTS:Attrs12=CAN_USE_LOG="Snapshot Log":2
  599. SYS.ALL_SNAPSHOTS:Reference:"Snapshot Table"=OWNER,TABLE_NAME
  600.  
  601. SYS.ALL_INDEXES:Key=TABLE_OWNER,TABLE_NAME,OWNER,INDEX_NAME
  602. SYS.ALL_INDEXES:Name=OWNER,INDEX_NAME
  603. SYS.ALL_INDEXES:Objects1=T:P:1M::"Columns":IndexColumn
  604. SYS.ALL_INDEXES:Objects2=P:R:M1::"TableSpace":TableSpace
  605. SYS.ALL_INDEXES:Attrs1=STATUS="Valid":::::VM=TValid
  606. SYS.ALL_INDEXES:Attrs2=UNIQUENESS="Unique"::E:::VM=TUnique
  607. SYS.ALL_INDEXES:Attrs3=INITIAL_EXTENT="Initial Extent (B)":2:E
  608. SYS.ALL_INDEXES:Attrs4=NEXT_EXTENT="Other Extents (B)":2:E
  609. SYS.ALL_INDEXES:Attrs5=MIN_EXTENTS="Minimum Extents":2:E
  610. SYS.ALL_INDEXES:Attrs6=MAX_EXTENTS="Maximum Extents":2:E
  611. SYS.ALL_INDEXES:Attrs7=PCT_INCREASE="% Increase":2:E
  612. SYS.ALL_INDEXES:Attrs8=PCT_FREE="Minimum % Free":2:E
  613. SYS.ALL_INDEXES:Attrs9=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  614. SYS.ALL_INDEXES:Attrs10=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  615. SYS.ALL_INDEXES:Reference:"TableSpace"=TABLESPACE_NAME
  616.  
  617. SYS.ALL_IND_COLUMNS:Key=TABLE_OWNER,TABLE_NAME,INDEX_OWNER,INDEX_NAME,COLUMN_NAME
  618. SYS.ALL_IND_COLUMNS:Name=Column
  619. SYS.ALL_IND_COLUMNS:Order=COLUMN_POSITION
  620. SYS.ALL_IND_COLUMNS:Objects1=P:R:M1::"Column":Column:<<>Column
  621. SYS.ALL_IND_COLUMNS:Attrs1=COLUMN_POSITION="Order":2:ER
  622. SYS.ALL_IND_COLUMNS:Reference:"Column"=TABLE_OWNER,TABLE_NAME,COLUMN_NAME
  623. ; !!! ASC/DESC information is lost in system catalog
  624.  
  625. SYS.ALL_TAB_COLUMNS:Key=OWNER,TABLE_NAME,COLUMN_NAME
  626. SYS.ALL_TAB_COLUMNS:Name=COLUMN_NAME
  627. SYS.ALL_TAB_COLUMNS:Order=COLUMN_ID
  628. SYS.ALL_TAB_COLUMNS:Attrs1=COLUMN_ID="Order":2:ER
  629. SYS.ALL_TAB_COLUMNS:Attrs2=DATA_TYPE=Type="Type"::ER:::VM=TDataType
  630. SYS.ALL_TAB_COLUMNS:Attrs3=DATA_LENGTH=Length="Length"::E
  631. SYS.ALL_TAB_COLUMNS:Attrs4=DATA_PRECISION=Precision="Precision"::E
  632. SYS.ALL_TAB_COLUMNS:Attrs5=DATA_SCALE=Scale="Scale"::E
  633. SYS.ALL_TAB_COLUMNS:Attrs6=NULLABLE=Null="Nulls"::E:::VM=TNulls
  634. SYS.ALL_TAB_COLUMNS:Attrs7=DATA_DEFAULT=Default="Default":2:E
  635.  
  636. SYS.ALL_SEQUENCES:Name=SEQUENCE_OWNER,SEQUENCE_NAME
  637. SYS.ALL_SEQUENCES:Attrs1=LAST_NUMBER="Last Value"::E
  638. SYS.ALL_SEQUENCES:Attrs2=INCREMENT_BY="Increment By"::E
  639. SYS.ALL_SEQUENCES:Attrs3=CYCLE_FLAG=Cycle="Cycle"::E:::VM=TCycle
  640. SYS.ALL_SEQUENCES:Attrs4=ORDER_FLAG=Order="In Order"::E:::VM=TOrder
  641. SYS.ALL_SEQUENCES:Attrs5=MIN_VALUE=MinValue="Minimum Value":2:E:::VM=TMinValue
  642. SYS.ALL_SEQUENCES:Attrs6=MAX_VALUE=MaxValue="Maximum Value":2:E:::VM=TMaxValue
  643. SYS.ALL_SEQUENCES:Attrs7=CACHE_SIZE=Cache="Cache Size":2:E:::VM=TCache
  644.  
  645. SYS.ALL_TRIGGERS:Key=TABLE_OWNER,TABLE_NAME,OWNER,TRIGGER_NAME
  646. SYS.ALL_TRIGGERS:Name=OWNER,TRIGGER_NAME
  647. SYS.ALL_TRIGGERS:Attrs1=TRIGGERING_EVENT="Events"::ER
  648. SYS.ALL_TRIGGERS:Attrs2=TRIGGER_TYPE="Type"::E:::VM=TRowStatement
  649. SYS.ALL_TRIGGERS:Attrs3=REFERENCING_NAMES="Referencing Names":0:E
  650. SYS.ALL_TRIGGERS:Attrs4=WHEN_CLAUSE="When":2:E::PStripWhen
  651. SYS.ALL_TRIGGERS:Attrs5=DESCRIPTION="Description":0
  652. SYS.ALL_TRIGGERS:Attrs6=TRIGGER_BODY="Text":3:ER
  653. ; !!! Fix REFERENCING_NAMES
  654.  
  655. SYS.ALL_CONSTRAINTS:Key=OWNER,TABLE_NAME,CONSTRAINT_NAME
  656. SYS.ALL_CONSTRAINTS:Name=CONSTRAINT_NAME
  657. SYS.ALL_CONSTRAINTS:Attrs1=STATUS="Disabled"::E:::VM=TDisabled
  658.  
  659. SYS.ALL_CONS_COLUMNS:Key=OWNER,TABLE_NAME,CONSTRAINT_NAME,COLUMN_NAME
  660. SYS.ALL_CONS_COLUMNS:Name=Column
  661. SYS.ALL_CONS_COLUMNS:Order=POSITION
  662. SYS.ALL_CONS_COLUMNS:Objects1=P:R:M1::"Column":Column:<<>Column
  663. SYS.ALL_CONS_COLUMNS:Attrs1=POSITION="Order":2:ER
  664. SYS.ALL_CONS_COLUMNS:Reference:"Column"=OWNER,TABLE_NAME,COLUMN_NAME
  665.  
  666. SYS.SYSFILES:Key=TSNAME,FNAME
  667. SYS.SYSFILES:Name=FNAME
  668. SYS.SYSFILES:Attrs=FNAME=:3,BLOCKS="Blocks"
  669.  
  670. SYS.USER_CLUSTERS:Name=CLUSTER_NAME
  671. SYS.USER_CLUSTERS:Objects1=T:P:1M::"Columns":ClusterColumn
  672. SYS.USER_CLUSTERS:Objects2=P:R:M1::"TableSpace":TableSpace
  673. SYS.USER_CLUSTERS:Attrs1=CLUSTER_TYPE="Type":::::VM=TCluster
  674. SYS.USER_CLUSTERS:Attrs2=FUNCTION="Hash Fn":::::VM=THashFn
  675. SYS.USER_CLUSTERS:Attrs3=PCT_FREE="Block Min % Free":2
  676. SYS.USER_CLUSTERS:Attrs4=PCT_USED="Block Min % Used":2
  677. SYS.USER_CLUSTERS:Attrs5=INI_TRANS="Initial Transactions":2::::VM=TBlank0
  678. SYS.USER_CLUSTERS:Attrs6=MAX_TRANS="Maximum Transactions":2::::VM=TBlank0
  679. SYS.USER_CLUSTERS:Attrs7=INITIAL_EXTENT="Initial Extent (B)":2
  680. SYS.USER_CLUSTERS:Attrs8=NEXT_EXTENT="Other Extents (B)":2
  681. SYS.USER_CLUSTERS:Attrs9=MIN_EXTENTS="Minimum Extents":2
  682. SYS.USER_CLUSTERS:Attrs10=MAX_EXTENTS="Maximum Extents":2
  683. SYS.USER_CLUSTERS:Attrs11=PCT_INCREASE="Extent Size % Increase":2
  684. SYS.USER_CLUSTERS:Attrs12=KEY_SIZE="Key Size":2
  685. SYS.USER_CLUSTERS:Attrs13=HASHKEYS="Hash Keys":2
  686. SYS.USER_CLUSTERS:Attrs14=AVG_BLOCKS_PER_KEY="Blocks / Key":2
  687. SYS.USER_CLUSTERS:Reference:"TableSpace"=TABLESPACE_NAME
  688.  
  689. SYS.USER_CLU_COLUMNS:Key=CLUSTER_NAME,CLU_COLUMN_NAME
  690. SYS.USER_CLU_COLUMNS:Name=CLU_COLUMN_NAME
  691. SYS.USER_CLU_COLUMNS:Attrs1=TABLE_NAME="Table"
  692. SYS.USER_CLU_COLUMNS:Attrs2=TAB_COLUMN_NAME="Column"
  693.  
  694. SYS.USER_TABLESPACES:Name=TABLESPACE_NAME
  695. SYS.USER_TABLESPACES:Attrs1=STATUS="Status":::::VM=TTSStatus
  696. SYS.USER_TABLESPACES:Attrs2=INITIAL_EXTENT="Initial Extent (B)":2:E
  697. SYS.USER_TABLESPACES:Attrs3=NEXT_EXTENT="Other Extents (B)":2:E
  698. SYS.USER_TABLESPACES:Attrs4=MIN_EXTENTS="Minimum Extents":2:E
  699. SYS.USER_TABLESPACES:Attrs5=MAX_EXTENTS="Maximum Extents":2:E
  700. SYS.USER_TABLESPACES:Attrs6=PCT_INCREASE="% Increase":2:E
  701.  
  702. CheckConstraint:Definition=Root=SYS.ALL_CONSTRAINTS
  703. CheckConstraint:Category=Expression
  704. CheckConstraint:Values=A.CONSTRAINT_TYPE = 'C'
  705. CheckConstraint:Attrs1=SEARCH_CONDITION=Text="Constraint Text":2:ER
  706. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  707. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  708. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N` `\N`  CHECK (`=Text`)
  709. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  710. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  711. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  712.  
  713. Cluster:Definition=Root=SYS.USER_CLUSTERS
  714. Cluster:EAttrs=
  715.  
  716. ClusterColumn:Definition=Root=SYS.USER_CLU_COLUMNS
  717. ClusterColumn:EAttrs=
  718.  
  719. Column:Definition=Root=SYS.ALL_TAB_COLUMNS
  720. Column:Category=Column
  721. Column:EAttrs=Text,New,Delete,Modify,Rename
  722. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  723.  
  724. KeyColumn:Definition=Root=SYS.ALL_CONS_COLUMNS
  725. KeyColumn:Category=ColumnReference
  726. KeyColumn:Attrs:R=Column:::2:ER
  727. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  728. KeyColumn:Text:Get=`N`
  729.  
  730. ForeignKey:Definition=Root=SYS.ALL_CONSTRAINTS
  731. ForeignKey:Category=ForeignKey
  732. ForeignKey:Values=A.CONSTRAINT_TYPE = 'R'
  733. ForeignKey:Objects1=T:P:1M::"Columns":KeyColumn
  734. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  735. ForeignKey:Attrs=DELETE_RULE="Delete Rule":2
  736. ; !!! Fix Attrs:T self-joins and convert Q to T 
  737. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  738. ForeignKey:Attrs:R=Table::::ER
  739. ForeignKey:AttrReference:ReferenceTable1=SELECT TABLE_NAME FROM SYS.ALL_CONSTRAINTS
  740. ForeignKey:AttrReference:ReferenceTable2=WHERE CONSTRAINT_TYPE IN ('P', 'U')
  741. ForeignKey:AttrReference:ReferenceTable3=AND OWNER=`:R_OWNER`
  742. ForeignKey:AttrReference:ReferenceTable4=AND CONSTRAINT_NAME=`:R_CONSTRAINT_NAME`
  743. ForeignKey:Reference:"Reference Table"=R_OWNER,ReferenceTable
  744. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  745. ForeignKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `N`
  746. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [KeyColumn:%s, %s:N] ')'`
  747. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  748. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  749.  
  750. Parameter:Definition=Root=SYS.ALL_TAB_COLUMNS
  751. Parameter:Category=Column
  752. Parameter:EAttrs=Text
  753. Parameter:Text:Get=`N`
  754.  
  755. Function:Definition=Root=SYS.ALL_OBJECTS
  756. Function:Category=Executable
  757. Function:Values=A.OBJECT_TYPE = 'FUNCTION'
  758. Function:Objects=T:P:0M::"Parameters":Parameter
  759. Function:Attrs:Q=Text=Memo::"Text"::ER
  760. Function:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  761. Function:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  762. Function:AttrReference:Text3=order by LINE
  763. Function:Warning=Loss
  764. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  765. Function:Text:Get=CREATE `=Text`
  766. Function:Text:Init1=CREATE FUNCTION `EDefaultName`
  767. Function:Text:Init2=RETURN datatype AS `\N`BEGIN`\N`END;
  768. Function:Text:NameRE=Text:FUNCTION\_(\_*\w+)
  769. Function:Text:NameSet=1=`N`
  770. Function:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(FUNCTION\_+(\w+)\_.*)
  771. Function:Text:Set=1=`''`,Text=2,*N=3
  772. Function:Modify:RE=(CREATE)\_+FUNCTION
  773. Function:Modify:Set=1=`'CREATE OR REPLACE'`
  774. Function:Delete:Text=DROP FUNCTION `O`
  775. Function:Actions="Compile"
  776. Function:"Compile":Text=ALTER FUNCTION `N` COMPILE
  777.  
  778. Index:Definition=Root=SYS.ALL_INDEXES
  779. Index:Category=Index
  780. ; Index:Values=B.OBJECT_TYPE = 'INDEX'
  781. Index:Attrs:R=TableSpace::INITIAL_EXTENT:2:E
  782. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  783. Index:Text:Get1=CREATE `=UNIQUENESS` INDEX `N`
  784. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  785. Index:Text:Get3=`! \N '  TABLESPACE ' =TableSpace`
  786. Index:Text:Get4=`! \N '  PCTFREE ' =PCT_FREE`
  787. Index:Text:Get5=`! \N '  INITRANS ' =INI_TRANS`
  788. Index:Text:Get6=`! \N '  MAXTRANS ' =MAX_TRANS`
  789. Index:Text:Get7=`! \N '  STORAGE (' ETemplates ObjectStorage ')'`
  790. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  791. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  792. Index:Delete:Text=DROP INDEX `O`
  793.  
  794. IndexColumn:Definition=Root=SYS.ALL_IND_COLUMNS
  795. IndexColumn:Category=ColumnReference
  796. IndexColumn:Attrs:R=Column:::2:ER
  797. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  798. IndexColumn:Text:Get=`N`
  799.  
  800. Package:Definition=Root=SYS.ALL_OBJECTS
  801. Package:Values=A.OBJECT_TYPE = 'PACKAGE'
  802. Package:Objects=P:R:M0::"Package Body":PackageBody
  803. Package:Attrs:Q=Text=Memo::"Text"::ER
  804. Package:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  805. Package:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  806. Package:AttrReference:Text3=and TYPE=`:OBJECT_TYPE` order by LINE
  807. Package:Warning=Loss
  808. Package:EAttrs=Text,New,Delete,Modify,Rename,Save
  809. Package:Text:Get=CREATE `=Text`
  810. Package:Text:Init=CREATE PACKAGE `EDefaultName` AS`\N`END;
  811. Package:Text:NameRE=Text:PACKAGE\_(\_*\w+)
  812. Package:Text:NameSet=1=`N`
  813. Package:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PACKAGE\_+(\w+)\_.*)
  814. Package:Text:Set=1=`''`,Text=2,*N=3
  815. Package:Modify:RE=(CREATE)\_+PACKAGE
  816. Package:Modify:Set=1=`'CREATE OR REPLACE'`
  817. Package:Delete:Text=DROP PACKAGE `O`
  818. Package:Actions="Compile","Compile All":';'
  819. Package:"Compile All":Text1=ALTER PACKAGE `N` COMPILE PACKAGE;
  820. Package:"Compile All":Text2=ALTER PACKAGE `N` COMPILE BODY
  821. Package:"Compile":Text=ALTER PACKAGE `N` COMPILE PACKAGE
  822.  
  823. PackageBody:Definition=Root=SYS.ALL_OBJECTS
  824. PackageBody:Values=A.OBJECT_TYPE = 'PACKAGE BODY'
  825. PackageBody:Objects=P:R:M0::"Package":Package
  826. PackageBody:Attrs:Q=Text=Memo::"Text"::ER
  827. PackageBody:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  828. PackageBody:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  829. PackageBody:AttrReference:Text3=and TYPE=`:OBJECT_TYPE` order by LINE
  830. PackageBody:Warning=Loss
  831. PackageBody:EAttrs=Text,New,Delete,Modify,Rename,Save
  832. PackageBody:Text:Get=CREATE `=Text`
  833. PackageBody:Text:Init=CREATE PACKAGE BODY `EDefaultName` AS`\N`END;
  834. PackageBody:Text:NameRE=Text:PACKAGE\_+BODY\_(\_*\w+)
  835. PackageBody:Text:NameSet=1=`N`
  836. PackageBody:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PACKAGE\_+BODY\_+(\w+)\_.*)
  837. PackageBody:Text:Set=1=`''`,Text=2,*N=3
  838. PackageBody:Modify:RE=(CREATE)\_+PACKAGE\_+BODY
  839. PackageBody:Modify:Set=1=`'CREATE OR REPLACE'`
  840. PackageBody:Delete:Text=DROP PACKAGE BODY `O`
  841. PackageBody:Actions="Compile"
  842. PackageBody:"Compile":Text=ALTER PACKAGE `N` COMPILE BODY
  843.  
  844. PrimaryKey:Definition=Root=SYS.ALL_CONSTRAINTS
  845. PrimaryKey:Category=PrimaryKey
  846. PrimaryKey:Values=A.CONSTRAINT_TYPE = 'P'
  847. PrimaryKey:Objects=T:P:1M::"Columns":KeyColumn
  848. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  849. PrimaryKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `N`
  850. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [KeyColumn:%s, %s:N] ')'`
  851. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  852.  
  853. Procedure:Definition=Root=SYS.ALL_OBJECTS
  854. Procedure:Category=Executable
  855. Procedure:Values=A.OBJECT_TYPE = 'PROCEDURE'
  856. Procedure:Objects=T:P:0M::"Parameters":Parameter
  857. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  858. Procedure:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  859. Procedure:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  860. Procedure:AttrReference:Text3=order by LINE
  861. Procedure:Warning=Loss
  862. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  863. Procedure:Text:Get=CREATE `=Text`
  864. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS `\N`BEGIN`\N`END;
  865. Procedure:Text:NameRE=Text:PROCEDURE\_(\_*\w+)
  866. Procedure:Text:NameSet=1=`N`
  867. Procedure:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PROCEDURE\_+(\w+)\_.*)
  868. Procedure:Text:Set=1=`''`,Text=2,*N=3
  869. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  870. Procedure:Modify:Set=1=`'CREATE OR REPLACE'`
  871. Procedure:Delete:Text=DROP PROCEDURE `O`
  872. Procedure:Actions="Compile"
  873. Procedure:"Compile":Text=ALTER PROCEDURE `N` COMPILE
  874.  
  875. Sequence:Definition=Root=SYS.ALL_SEQUENCES
  876. Sequence:Values=B.OBJECT_TYPE = 'SEQUENCE'
  877. Sequence:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::LAST_NUMBER
  878. Sequence:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::LAST_NUMBER
  879. Sequence:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::LAST_NUMBER
  880. Sequence:Warning=Loss
  881. Sequence:EAttrs=Text,New,Delete,Modify,Rename,Save
  882. Sequence:Text:Get1=CREATE SEQUENCE `N`
  883. Sequence:Text:Get2=`! \N '  START WITH ' =LAST_NUMBER`
  884. Sequence:Text:Get3=`! \N '  INCREMENT BY ' =INCREMENT_BY`
  885. Sequence:Text:Get4=`! \N '  ' =MaxValue`
  886. Sequence:Text:Get5=`! \N '  ' =MinValue`
  887. Sequence:Text:Get6=`! \N '  ' =Cycle`
  888. Sequence:Text:Get7=`! \N '  ' =Cache`
  889. Sequence:Text:Get8=`! \N '  ' =Order`
  890. Sequence:Delete:Text=DROP SEQUENCE `O`
  891.  
  892. Snapshot:Definition=Root=SYS.ALL_SNAPSHOTS
  893. Snapshot:Warning=DataLoss
  894. ; Snapshot:Values=B.OBJECT_TYPE = 'SNAPSHOT'
  895. Snapshot:EAttrs=Text,New,Delete,Modify,Rename,Save
  896. Snapshot:Text:Get1=CREATE SNAPSHOT `N \N` `! ' REFRESH ' =TYPE \N`
  897. ; Snapshot:Text:Get1.5=`! ' START WITH ' =START_WITH \N`
  898. Snapshot:Text:Get2=`! ' NEXT ' =NEXT \N` AS `=QUERY`
  899. Snapshot:Delete:Text=DROP SNAPSHOT `O`
  900. Snapshot:OnAfterLoad=SnapshotLoaded
  901.  
  902. Synonym:Definition=Root=SYS.ALL_SYNONYMS
  903. Synonym:Category=Dataset
  904. Synonym:Values=B.OBJECT_TYPE = 'SYNONYM'
  905. Synonym:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::TABLE_OWNER
  906. Synonym:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::TABLE_OWNER
  907. Synonym:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::TABLE_OWNER
  908. Synonym:Warning=Loss
  909. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  910. Synonym:Text:Init=CREATE SYNONYM `EDefaultName \N`FOR "owner"."object"
  911. Synonym:Text:Get1=CREATE `ESynonymName N \N`FOR "`=TABLE_OWNER`"."`=TABLE_NAME`"
  912. Synonym:Delete:Text=DROP `ESynonymName O`
  913.  
  914. Table:Definition=Root=SYS.ALL_TABLES
  915. Table:Category=Dataset
  916. Table:Values=B.OBJECT_TYPE = 'TABLE'
  917. Table:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::BACKED_UP
  918. Table:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::BACKED_UP
  919. Table:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::BACKED_UP
  920. Table:Attrs:R1=TableSpace::PCT_FREE:2:E
  921. Table:Attrs:R2=Cluster::PCT_FREE:2:E
  922. Table:Warning=DataLoss
  923. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  924. Table:Text:Get1=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  925. Table:Text:Get2=`! \N '  TABLESPACE ' =TableSpace`
  926. Table:Text:Get3=`! \N '  PCTFREE ' =PCT_FREE`
  927. Table:Text:Get4=`! \N '  PCTUSED ' =PCT_USED`
  928. Table:Text:Get5=`! \N '  INITRANS ' =INI_TRANS`
  929. Table:Text:Get6=`! \N '  MAXTRANS ' =MAX_TRANS`
  930. Table:Text:Get7=`! \N '  STORAGE (' ETemplates ObjectStorage ')'`
  931. Table:Rename:Text=RENAME "`O1`" TO "`N1`"
  932. Table:Delete:Text=DROP TABLE `O`
  933.  
  934. Trigger:Definition=Root=SYS.ALL_TRIGGERS
  935. Trigger:Category=Executable
  936. Trigger:Attrs:P=WhenEvent=Boolean::"Event Time":1:ER:::VM=TBeforeAfter
  937. Trigger:Attrs:R=WhenEvent::"Event"
  938. Trigger:OnAfterLoad=TriggerLoaded
  939. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  940. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName`
  941. Trigger:Text:Init2=AFTER INSERT OR DELETE OR UPDATE`\N`
  942. Trigger:Text:Init3=ON `{<}N \N`
  943. Trigger:Text:Init4=FOR EACH ROW`\N`
  944. Trigger:Text:Init5=BEGIN`\N`END;
  945. Trigger:Text:Get1=CREATE TRIGGER `N ' ' =WhenEvent ' ' =TRIGGERING_EVENT`
  946. Trigger:Text:Get2=`\N`ON `{<}N``! \N =TRIGGER_TYPE`
  947. Trigger:Text:Get3=`! \N 'WHEN (' =WHEN_CLAUSE ')'`` \N =TRIGGER_BODY`
  948. Trigger:Text:RE1=CREATE\_+(OR\_+REPLACE\_+)?TRIGGER\_+(\w+)\_+(\w+)\_+(.*)\_ON
  949. Trigger:Text:RE2=(\_*\w+)\_*(FOR EACH ROW)?\_*(WHEN\_*\(.*\)\_+)?(BEGIN\_.*)
  950. Trigger:Text:Set1=1=`''`,*N=2,WhenEvent=3,-TRIGGERING_EVENT=4,5=`{<}N`
  951. Trigger:Text:Set2=TRIGGER_TYPE=6,WHEN_CLAUSE=7,TRIGGER_BODY=8
  952. Trigger:Modify:RE=(CREATE)\_+TRIGGER
  953. Trigger:Modify:Set=1=`'CREATE OR REPLACE'`
  954. Trigger:Delete:Text=DROP TRIGGER `O`
  955.  
  956. UniqueConstraint:Definition=Root=SYS.ALL_CONSTRAINTS
  957. UniqueConstraint:Category=UniqueConstraint
  958. UniqueConstraint:Values=A.CONSTRAINT_TYPE = 'U'
  959. UniqueConstraint:Objects=T:P:1M::"Columns":KeyColumn
  960. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  961. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  962. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [KeyColumn:%s, %s:N] ')'`
  963. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  964.  
  965. View:Definition=Root=SYS.ALL_OBJECTS
  966. View:Category=Dataset
  967. View:Values=A.OBJECT_TYPE = 'VIEW'
  968. View:Objects=T:P:0M:NMDR:"Columns":Column
  969. View:Attrs:Q=Text=Memo::"Text"::ER
  970. View:AttrReference:Text1=select TEXT from SYS.ALL_VIEWS
  971. View:AttrReference:Text2=where OWNER=`OQ0` and VIEW_NAME=`OQ1`
  972. View:Warning=Loss
  973. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  974. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM "owner"."object"
  975. View:Text:Get=CREATE VIEW `N` AS `\N '  ' =Text`
  976. View:Text:RE=CREATE\_+VIEW\_+(\w+)\_+AS\_+(.*)
  977. View:Text:Set=Text=2,*N=1
  978. View:Rename:Text=RENAME "`O1`" TO "`N1`"
  979. View:Delete:Text=DROP VIEW `O`
  980.  
  981. TableSpace:Definition=Root=SYS.USER_TABLESPACES
  982. TableSpace:Objects=T:C:1M::"Files":File
  983. TableSpace:Reference:"Files":Text=`[File:%s,%s:\N '    ' \Q * \Q]`
  984. TableSpace:Warning=Loss
  985. TableSpace:EAttrs=Text
  986. TableSpace:Text:Get1=CREATE TABLESPACE `N \N`
  987. TableSpace:Text:Get2= DATAFILE `{>File}*\N`
  988. TableSpace:Text:Get3=`! ' DEFAULT STORAGE (' ETemplates Storage ')' \N`
  989. TableSpace:Text:Get9=`! ' ' =STATUS \N`
  990. TableSpace:Delete:Text=DROP TABLESPACE `O`
  991.  
  992. File:Definition=Root=SYS.SYSFILES
  993. File:Category=System
  994. File:NameRE=.*
  995. File:EAttrs=Text
  996. File:Text:Get=`N`
  997.  
  998. [Oracle 7.2 Properties]
  999.  
  1000. SYS.ALL_CLUSTERS:Name=OWNER,CLUSTER_NAME
  1001. SYS.ALL_CLUSTERS:Objects1=T:P:1M::"Columns":ClusterColumn
  1002. SYS.ALL_CLUSTERS:Objects1=P:R:M1::"TableSpace":TableSpace
  1003. SYS.ALL_CLUSTERS:Attrs1=CLUSTER_TYPE="Type":::::VM=TCluster
  1004. SYS.ALL_CLUSTERS:Attrs2=FUNCTION="Hash Fn":::::VM=THashFn
  1005. SYS.ALL_CLUSTERS:Attrs3=PCT_FREE="Block Min % Free":2
  1006. SYS.ALL_CLUSTERS:Attrs4=PCT_USED="Block Min % Used":2
  1007. SYS.ALL_CLUSTERS:Attrs5=INI_TRANS="Initial Transactions":2::::VM=TBlank0
  1008. SYS.ALL_CLUSTERS:Attrs6=MAX_TRANS="Maximum Transactions":2::::VM=TBlank0
  1009. SYS.ALL_CLUSTERS:Attrs7=INITIAL_EXTENT="Initial Extent (B)":2
  1010. SYS.ALL_CLUSTERS:Attrs8=NEXT_EXTENT="Other Extents (B)":2
  1011. SYS.ALL_CLUSTERS:Attrs9=MIN_EXTENTS="Minimum Extents":2
  1012. SYS.ALL_CLUSTERS:Attrs10=MAX_EXTENTS="Maximum Extents":2
  1013. SYS.ALL_CLUSTERS:Attrs11=PCT_INCREASE="Extent Size % Increase":2
  1014. SYS.ALL_CLUSTERS:Attrs12=KEY_SIZE="Key Size":2
  1015. SYS.ALL_CLUSTERS:Attrs13=HASHKEYS="Hash Keys":2
  1016. SYS.ALL_CLUSTERS:Attrs14=AVG_BLOCKS_PER_KEY="Blocks / Key":2
  1017. SYS.ALL_CLUSTERS:Reference:"ClusterColumn"=CLUSTER_NAME
  1018. SYS.ALL_CLUSTERS:Reference:"TableSpace"=TABLESPACE_NAME
  1019.  
  1020. ; Add FREELISTS and FREELIST_GROUPS for Oracle 7.2+
  1021.  
  1022. Template:ObjectStorage1=`ETemplates Storage`
  1023. Template:ObjectStorage2=`! \N '    FREELISTS ' =FREELISTS`
  1024. Template:ObjectStorage3=`! \N '    FREELIST GROUPS ' =FREELIST_GROUPS`
  1025.  
  1026. SYS.ALL_TABLES:Attrs1=BACKED_UP="Backed Up":::::VM=TBooleanNY
  1027. SYS.ALL_TABLES:Attrs2=PCT_FREE="Block Min % Free":2:E
  1028. SYS.ALL_TABLES:Attrs3=PCT_USED="Block Min % Used":2:E
  1029. SYS.ALL_TABLES:Attrs4=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  1030. SYS.ALL_TABLES:Attrs5=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  1031. SYS.ALL_TABLES:Attrs6=INITIAL_EXTENT="Initial Extent (B)":2:E
  1032. SYS.ALL_TABLES:Attrs7=NEXT_EXTENT="Next Extent (B)":2:E
  1033. SYS.ALL_TABLES:Attrs8=MIN_EXTENTS="Min Extents":2:E
  1034. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2:E
  1035. SYS.ALL_TABLES:Attrs10=PCT_INCREASE="Extent Size % Increase":2:E
  1036. SYS.ALL_TABLES:Attrs11=FREELISTS="Free Lists":2:E
  1037. SYS.ALL_TABLES:Attrs12=FREELIST_GROUPS="Free List Groups":2:E
  1038. SYS.ALL_TABLES:Attrs13=NUM_ROWS="Row Count":2
  1039. SYS.ALL_TABLES:Attrs14=CHAIN_CNT="Chained Rows":2
  1040. SYS.ALL_TABLES:Attrs15=BLOCKS="Data Block Count":2
  1041. SYS.ALL_TABLES:Attrs16=EMPTY_BLOCKS="Empty Data Blocks":2
  1042. SYS.ALL_TABLES:Attrs17=AVG_SPACE="Avg Bytes Free / Block":2
  1043. SYS.ALL_TABLES:Attrs18=AVG_ROW_LEN="Avg Row Length":2
  1044.  
  1045. ; !!! Use ALL_CLUSTERS instead of USER_CLUSTERS for 7.2+
  1046. ; Need DBA_CLU_COLUMNS (or ALL_CLU_COLUMNS) owner to fully qualify
  1047. ; which is not defined in 7.2
  1048. ; Cluster:Definition=Root=SYS.ALL_CLUSTERS
  1049. ; SYS.ALL_TABLES:Reference:"Cluster"=OWNER,CLUSTER_NAME
  1050.  
  1051.  
  1052. [MSSQL Properties]
  1053. TBooleanYN:Values=Closed,0="No",-1="Yes"
  1054. TPhysicalType:Values1=Closed,34=image:"Image",35=text:"Text"
  1055. TPhysicalType:Values2=37=varbinary:"VarBinary"
  1056. TPhysicalType:Values3=38=int:"Int"
  1057. TPhysicalType:Values4=39=varchar:"VarChar"
  1058. TPhysicalType:Values5=45=binary:"Binary"
  1059. TPhysicalType:Values6=47=char:"Char"
  1060. TPhysicalType:Values7=48=tinyint:"TinyInt"
  1061. TPhysicalType:Values8=50=bit:"Bit"
  1062. TPhysicalType:Values9=52=smallint:"SmallInt"
  1063. TPhysicalType:Values10=55=decimal:"Decimal"
  1064. TPhysicalType:Values11=56=int:"Int"
  1065. TPhysicalType:Values12=58=smalldatetime:"SmallDateTime"
  1066. TPhysicalType:Values13=59=real:"Real"
  1067. TPhysicalType:Values14=60=money:"Money"
  1068. TPhysicalType:Values15=61=datetime:"DateTime"
  1069. TPhysicalType:Values16=62=float:"Float"
  1070. TPhysicalType:Values17=63=numeric:"Numeric"
  1071. TPhysicalType:Values18=106=decimal:"Decimal"
  1072. TPhysicalType:Values19=108=numeric:"Numeric"
  1073. TPhysicalType:Values20=109=float:"Float"
  1074. TPhysicalType:Values21=110=money:"Money"
  1075. TPhysicalType:Values22=111=datetime:"DateTime"
  1076. TPhysicalType:Values23=122=smallmoney:"SmallMoney"
  1077. TNull01:Values=Closed,0=not null:"No",-1=null:"Yes"
  1078. TObjectType:Values1=Closed,S="System Table",U="Table",V="View",L="Log",P="Procedure",
  1079. TObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  1080. TObjectStatus:Values=Closed,256="Read Only",4096="RamboIX"
  1081. TColumnStatus:Values=Closed,8=NULL:"Null"
  1082. TIndexStatus:Values1=Closed,2=UNIQUE:"Unique",16=CLUSTERED:"Clustered"
  1083. TIndexStatus:Values2=1=:"Dup Key Abort",4=:"Dup Row Abort"
  1084. TIndexStatus:Values3=64=:"Allow Dup Rows",32768=:"Suspect"
  1085. TLoginStatus:Values=Closed,1=:"Small Password",2=:"Locked account",4=:"Password Expired"
  1086. TDeviceType:Values1=Closed,0=0:"Database",2=2:"Disk Dump",3=3:"Tape Dump",4=4:"Tape Dump"
  1087. TDeviceType:Values2=5=5:"Tape Dump",6=6:"Tape Dump",7=7:"Tape Dump",8=8:"Tape Dump"
  1088. TDeviceStatus:Values1=Closed,1=:"Default",2=:"Physical Disk",4=:"Logical Disk"
  1089. TDeviceStatus:Values2=8=:"Skip Header",16=:"Dump Device",32=:"Serial Writes"
  1090. TDeviceStatus:Values3=64=:"Device Mirrored",128=:"Reads Mirrored"
  1091. TDeviceStatus:Values4=256=:"Half-Mirrored",512=:"Mirror Enabled"
  1092. TSegmentStatus:Values=Closed,1=:"Default"
  1093.  
  1094. MSSQL:UserName=select user_name()
  1095. MSSQL:Comments=--;/*,*/
  1096.  
  1097. MSSQL:Objects1=O:C:0M::"Data Types":Type
  1098. MSSQL:Objects2=O:C:0M::"Tables":Table
  1099. MSSQL:Objects3=O:C:0M::"Views":View
  1100. MSSQL:Objects4=O:C:0M::"Procedures":Procedure
  1101. MSSQL:Objects5=O:C:0M::"Defaults":Default
  1102. MSSQL:Objects6=O:C:0M::"Rules":Rule
  1103. MSSQL:Objects7=O:C:0M::"Logins":Login
  1104. MSSQL:Objects8=O:C:0M::"Groups":Group
  1105. MSSQL:Objects9=O:C:0M::"Users":User
  1106. MSSQL:Objects10=O:C:0M::"Segments":Segment
  1107. MSSQL:Objects11=O:C:0M::"Devices":Device
  1108.  
  1109. dbo.sysobjects:Key=id
  1110. dbo.sysobjects:Name=Owner,name
  1111. dbo.sysobjects:Attrs1=crdate="Creation Date"
  1112. dbo.sysobjects:Attrs2=sysstat="Status":::::VS=TObjectStatus:$1100
  1113. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  1114.  
  1115. dbo.syscolumns:Key=id,colid
  1116. dbo.syscolumns:Name=name
  1117. dbo.syscolumns:Order=colid
  1118. dbo.syscolumns:Objects1=P:R:M1::"Type":Type
  1119. dbo.syscolumns:Objects2=P:R:M1::"Default Value":Default
  1120. dbo.syscolumns:Objects3=P:R:M1::"Domain Rule":Rule
  1121. dbo.syscolumns:Reference:"Type"=usertype
  1122. dbo.syscolumns:Reference:"Default Value"=cdefault
  1123. dbo.syscolumns:Reference:"Domain Rule"=domain
  1124. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1125. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1126. dbo.syscolumns:Attrs3=status="Status"::E:::VS=TColumnStatus:$8
  1127.  
  1128. dbo.sysindexes:Key=id,indid
  1129. dbo.sysindexes:Name=name
  1130. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1131. dbo.sysindexes:Attrs1=status="Status":::::VS=TIndexStatus:$F77F
  1132. dbo.sysindexes:Attrs2=indid="Index Id":2
  1133. dbo.sysindexes:Attrs3=rowpage="Rows per page":2
  1134. dbo.sysindexes:Attrs4=minlen="Minimum row size":2
  1135. dbo.sysindexes:Attrs5=maxlen="Maximum row size":2
  1136.  
  1137. dbo.systypes:Key=usertype
  1138. dbo.systypes:Name=name
  1139. dbo.systypes:Objects1=P:R:M1::"Default Value":Default
  1140. dbo.systypes:Objects2=P:R:M1::"Domain Rule":Rule
  1141. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1142. dbo.systypes:Attrs2=length=Length="Length"::E
  1143. dbo.systypes:Attrs3=allownulls=Null="Nulls"::E:::VM=TNull01
  1144. dbo.systypes:Attrs4=variable="Variable Length":::::VM=TBooleanYN
  1145. dbo.systypes:Reference:"Default Value"=tdefault
  1146. dbo.systypes:Reference:"Domain Rule"=domain
  1147.  
  1148. dbo.syssegments:Key=segment
  1149. dbo.syssegments:Name=name
  1150. dbo.syssegments:Attrs1=status="Status":::::VS=TSegmentStatus:$FFFF
  1151.  
  1152. dbo.sysusers:Key=uid
  1153. dbo.sysusers:Name=name
  1154.  
  1155. master.dbo.syslogins:Dataset1=suid,status,accdate,totcpu,totio,spacelimit
  1156. master.dbo.syslogins:Dataset2=timelimit,resultlimit,dbname,name,language
  1157. master.dbo.syslogins:Key=suid
  1158. master.dbo.syslogins:Name=name
  1159. master.dbo.syslogins:Attrs1=dbname="Default Database"
  1160. master.dbo.syslogins:Attrs2=accdate="Last Access"
  1161. master.dbo.syslogins:Attrs3=status="Status":::::VS=TLoginStatus:$FFF7
  1162. master.dbo.syslogins:Attrs4=language="Default Language"
  1163. master.dbo.syslogins:Attrs5=totcpu="Total CPU":2
  1164. master.dbo.syslogins:Attrs6=totio="Total IO":2
  1165.  
  1166. master.dbo.sysdevices:Name=name
  1167. master.dbo.sysdevices:Attrs1=cntrltype="Type":::::VM=TDeviceType
  1168. master.dbo.sysdevices:Attrs2=status="Status":::::VS=TDeviceStatus:$FFFF
  1169. master.dbo.sysdevices:Attrs3=phyname="Physical Name"
  1170. master.dbo.sysdevices:Attrs4=mirrorname="Mirror Name"
  1171. master.dbo.sysdevices:Attrs5=low="First Page"
  1172. master.dbo.sysdevices:Attrs6=high="Last Page"
  1173.  
  1174. Table:Definition=Root=dbo.sysobjects
  1175. View:Definition=Root=dbo.sysobjects
  1176. Procedure:Definition=Root=dbo.sysobjects
  1177. Default:Definition=Root=dbo.sysobjects
  1178. Rule:Definition=Root=dbo.sysobjects
  1179. Trigger:Definition=Root=dbo.sysobjects
  1180. Type:Definition=Root=dbo.systypes
  1181. Index:Definition=Root=dbo.sysindexes
  1182. Column:Definition=Root=dbo.syscolumns
  1183. Parameter:Definition=Root=dbo.syscolumns
  1184. Segment:Definition=Root=dbo.syssegments
  1185. User:Definition=Root=dbo.sysusers
  1186. Group:Definition=Root=dbo.sysusers
  1187. Database:Definition=Root=master.dbo.sysdatabases
  1188. Login:Definition=Root=master.dbo.syslogins
  1189. Device:Definition=Root=master.dbo.sysdevices
  1190.  
  1191. Table:Category=Dataset
  1192. Table:Values=A.type IN ('U', 'S')
  1193. Table:Objects1=T:P:1M::"Columns":Column
  1194. Table:Objects2=T:O:0M::"Indices":Index
  1195. Table:Objects3=T:O:0M::"Triggers":Trigger
  1196. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *] \N`
  1197. Table:Reference:"Triggers"=id=deltrig
  1198. Table:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1199. Table:AttrReference:Owner=uid=uid
  1200. Table:FilterSystemObjects=A.type <> 'S'
  1201. Table:Warning=DataLoss
  1202. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1203. Table:Text:Get=CREATE TABLE `N` (`{>Column}*`)
  1204. Table:Delete:Text=DROP TABLE `O`
  1205. Table:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1206.  
  1207. View:Category=Dataset
  1208. View:Values=A.type = 'V'
  1209. View:Objects1=T:P:0M:NMDR:"Columns":Column
  1210. View:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1211. View:Attrs:Q=Text=String:255:"Text"::ER
  1212. View:AttrReference:Owner=uid=uid
  1213. View:AttrReference:Text1=select text from dbo.syscomments
  1214. View:AttrReference:Text2=where id=`:id` order by colid
  1215. View:Warning=Loss
  1216. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1217. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM owner.object
  1218. View:Text:Get=`=Text`
  1219. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  1220. View:Text:NameSet=1=`N`
  1221. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  1222. View:Text:Set=Text=0,*N=2
  1223. View:Delete:Text=DROP VIEW `O`
  1224.  
  1225. Procedure:Category=Executable
  1226. Procedure:Values=A.type = 'P'
  1227. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1228. Procedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1229. Procedure:Attrs:Q=Text=String:255:"Text"::ER
  1230. Procedure:AttrReference:Owner=uid=uid
  1231. Procedure:AttrReference:Text1=select text from dbo.syscomments
  1232. Procedure:AttrReference:Text2=where id=`:id` order by colid
  1233. Procedure:Warning=Loss
  1234. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1235. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS
  1236. Procedure:Text:Get=`=Text`
  1237. Procedure:Text:NameRE=Text:PROC(EDURE)?\_(\_*\w+)
  1238. Procedure:Text:NameSet=2=`N`
  1239. Procedure:Text:RE=^(.*\_)?CREATE\_+(PROC(EDURE)?)\_+(\w+)\_.*$
  1240. Procedure:Text:Set=2=`'PROCEDURE'`,Text=0,*N=4
  1241. Procedure:Delete:Text=DROP PROCEDURE `O`
  1242. Procedure:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1243.  
  1244. Default:Category=Expression
  1245. Default:Values=A.type = 'D'
  1246. Default:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1247. Default:Attrs:Q=Text=String:255:"Text":2:ER:PGetDefaultText
  1248. Default:AttrReference:Owner=uid=uid
  1249. Default:AttrReference:Text1=select text from dbo.syscomments
  1250. Default:AttrReference:Text2=where id=`:id` order by colid
  1251. Default:Warning=Loss
  1252. Default:EAttrs=Text,New,Delete,Modify,Rename,Save
  1253. Default:Text:Init=CREATE DEFAULT `EDefaultName` AS NULL
  1254. Default:Text:Get=CREATE DEFAULT `N` AS `=Text`
  1255. Default:Text:NameRE=Text:DEFAULT\_(\_*\w+)
  1256. Default:Text:NameSet=1=`N`
  1257. Default:Text:RE=CREATE\_+DEFAULT\_+(\w+)\_+AS\_(.*)
  1258. Default:Text:Set=*N=1,Text=2
  1259. Default:Delete:Text=DROP DEFAULT `O`
  1260.  
  1261. Rule:Category=Expression
  1262. Rule:Values=A.type = 'R'
  1263. Rule:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1264. Rule:Attrs:Q=Text=String:255:"Text"::ER
  1265. Rule:AttrReference:Owner=uid=uid
  1266. Rule:AttrReference:Text1=select text from dbo.syscomments
  1267. Rule:AttrReference:Text2=where id=`:id` order by colid
  1268. Rule:EAttrs=Text,New,Delete,Modify,Rename,Save
  1269. Rule:Text:Init=CREATE RULE `EDefaultName` AS NULL
  1270. Rule:Text:Get=`=Text`
  1271. Rule:Text:NameRE=Text:RULE\_+(\w+)
  1272. Rule:Text:NameSet=1=`N`
  1273. Rule:Text:RE=^(.*\_)?CREATE\_+RULE\_+(\w+)\_+.*$
  1274. Rule:Text:Set=*N=2,Text=0
  1275. Rule:Delete:Text=DROP RULE `O`
  1276.  
  1277. Trigger:Category=Executable
  1278. Trigger:Values=A.type = 'TR'
  1279. Trigger:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1280. Trigger:Attrs:Q=Text=String:255:"Text"::ER:PROOName
  1281. Trigger:AttrReference:Owner=uid=uid
  1282. Trigger:AttrReference:Text1=select text from dbo.syscomments
  1283. Trigger:AttrReference:Text2=where id=`:id` order by colid
  1284. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1285. Trigger:Text:Init=CREATE TRIGGER `EDefaultName` ON `{<}N` FOR INSERT, UPDATE, DELETE AS`\N`
  1286. Trigger:Text:Get=`=Text`
  1287. Trigger:Text:NameRE=Text:TRIGGER\_+(\w+)\_+ON\_+(\w+)
  1288. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  1289. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_+ON\_+(\w+).*$
  1290. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  1291. Trigger:Delete:Text=DROP TRIGGER `O`
  1292.  
  1293. RIConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1294. RIConstraint:AttrReference:Owner=uid=uid
  1295.  
  1296. Column:Category=Column
  1297. Column:Attrs:R=Type:"Type":"Length":1:ER
  1298. Column:EAttrs=Text,New,Delete,Modify,Rename
  1299. Column:Text:Get=`N ' ' EType EDefault``! ' ' =status`
  1300.  
  1301. Index:Category=Index
  1302. Index:Values=A.keycnt > 0
  1303. Index:Attrs:R=status::::+E
  1304. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  1305. Index:Text:Get1=CREATE `=status` INDEX `N`
  1306. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  1307. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  1308. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  1309. Index:Delete:Text=DROP INDEX `{<}O`.`O`
  1310.  
  1311. IndexColumn:Category=ColumnReference
  1312. IndexColumn:Name=Column
  1313. IndexColumn:Order=Id
  1314. IndexColumn:Definition1=Dataset=
  1315. IndexColumn:Definition2=select Id=c.colid, TabId=c.id, ColId=i.colid
  1316. IndexColumn:Definition3=from sysindexes x, syscolumns c, syscolumns i
  1317. IndexColumn:Definition4=where (x.id=`:id`) and (x.id=c.id) and (x.id=i.id) and
  1318. IndexColumn:Definition5=(x.name=`OQ`) and (c.colid<=keycnt) and
  1319. IndexColumn:Definition6=(i.name=INDEX_COL(`{<}OQ`,x.indid,c.colid))
  1320. IndexColumn:Dataset=Id=Word,TabId=Word,ColId=Word
  1321. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1322. IndexColumn:Attrs1=Id="Order":2:ER
  1323. IndexColumn:Attrs:R=Column:::2:ER
  1324. IndexColumn:Reference:"Column"=TabId,ColId
  1325. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  1326. IndexColumn:Text:Get=`N`
  1327.  
  1328. Parameter:Category=Column
  1329. Parameter:Attrs:R=Type:"Type":"Length":1
  1330. Parameter:EAttrs=
  1331.  
  1332. Type:Category=Type
  1333. Type:Attrs:T=dbo.sysusers.name=Owner:"Owner":Type:1
  1334. Type:AttrReference:Owner=uid=uid
  1335. Type:Warning=Loss
  1336. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  1337. Type:Text:Init=sp_addtype "`EDefaultName`", "varchar(255)", "null"
  1338. Type:Text:Get=sp_addtype "`N`", "`EType`"`! ', "' =Null '"'`
  1339. Type:Delete:Text=sp_droptype "`O`"
  1340.  
  1341. Login:Attrs:P=Password=String
  1342. Login:Attrs:R=Password:"Password":"Default Language":2
  1343. Login:EAttrs=Text
  1344. Login:Text:Get=sp_addlogin "`N`", "`=Password`", "`=dbname`", "`=language`"
  1345. Login:Delete:Text=sp_droplogin "`O`"
  1346.  
  1347. Group:Values=A.uid = A.gid
  1348. ; !!! Group:Objects=P:R:0M::"Users":User
  1349. Group:Reference:"Users"=uid=gid
  1350. Group:EAttrs=Text
  1351. Group:Text:Get=sp_addgroup "`N`"
  1352. Group:Delete:Text=sp_dropgroup "`O`"
  1353.  
  1354. User:Values=A.uid <> A.gid
  1355. User:Objects1=P:R:M1::"Login":Login
  1356. User:Objects2=P:R:M1::"Group":Group
  1357. User:Reference:"Login"=suid
  1358. User:Reference:"Group"=gid
  1359. User:EAttrs=Text
  1360. User:Text:Get=sp_adduser "`=Login`", "`N`", "`=Group`"
  1361. User:Delete:Text=sp_dropuser "`O`"
  1362.  
  1363. Segment:Objects=P:R:M0::"Device":Device
  1364. Segment:Attrs:P=DeviceName=String:::0
  1365. Segment:Reference:"Device"=DeviceName
  1366. Segment:EAttrs=Text
  1367. Segment:Text:Get=sp_addsegment "`N`","`=Device`"
  1368. Segment:Delete:Text=sp_dropsegment "`O`"
  1369.  
  1370. Device:EAttrs=Text
  1371. Device:Text:Get1=DISK INIT NAME="`N`",`\N'  '`PHYSNAME="`=phyname`",
  1372. Device:Text:Get2=`\N'  '`VDEVNO=?,`\N'  '`SIZE=?,
  1373. Device:Text:Get3=`\N'  '`CNTRLTYPE=`=cntrltype`
  1374. Device:Delete:Text=sp_dropdevice "`O`"
  1375.  
  1376. [MSSQL 6 Properties]
  1377. MSSQL:Objects1=O:C:0M::"Data Types":Type
  1378. MSSQL:Objects2=O:C:0M::"Tables":Table
  1379. MSSQL:Objects3=O:C:0M::"Views":View
  1380. MSSQL:Objects4=O:C:0M::"Procedures":Procedure
  1381. MSSQL:Objects5=O:C:0M::"Extended Procedures":ExtendedProcedure
  1382. MSSQL:Objects6=O:C:0M::"Defaults":Default
  1383. MSSQL:Objects7=O:C:0M::"Rules":Rule
  1384. MSSQL:Objects8=O:C:0M::"Logins":Login
  1385. MSSQL:Objects9=O:C:0M::"Groups":Group
  1386. MSSQL:Objects10=O:C:0M::"Users":User
  1387. MSSQL:Objects11=O:C:0M::"Segments":Segment
  1388. MSSQL:Objects12=O:C:0M::"Devices":Device
  1389.  
  1390. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1391. dbo.systypes:Attrs2=length=Length="Length"::E
  1392. dbo.systypes:Attrs3=prec=Precision="Precision":2:E
  1393. dbo.systypes:Attrs4=scale=Scale="Scale":2:E
  1394. dbo.systypes:Attrs5=allownulls=Null="Nulls"::E:::VM=TNull01
  1395. dbo.systypes:Attrs6=variable="Variable Length":::::VM=TBooleanYN
  1396.  
  1397. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1398. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1399. dbo.syscolumns:Attrs3=prec=Precision="Precision":2:E
  1400. dbo.syscolumns:Attrs4=scale=Scale="Scale":2:E
  1401. dbo.syscolumns:Attrs5=status="Status"::E:::VS=TColumnStatus:$8
  1402.  
  1403. dbo.sysconstraints:Key=id,constid
  1404. dbo.sysconstraints:Name=name
  1405.  
  1406. dbo.sysreferences:Key=fkeyid,constid
  1407. dbo.sysreferences:Name=name
  1408.  
  1409. Table:Objects1=T:P:1M::"Columns":Column
  1410. Table:Objects2=T:O:0M::"Indices":Index
  1411. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  1412. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  1413. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  1414. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  1415. Table:Objects7=T:O:0M::"Triggers":Trigger
  1416.  
  1417. KeyColumn:Category=ColumnReference
  1418. KeyColumn:Definition=Dataset
  1419. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer
  1420. KeyColumn:Name=Column
  1421. KeyColumn:Order=ItemNo
  1422. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1423. KeyColumn:Attrs1=ItemNo="Order":2:ER
  1424. KeyColumn:Attrs:R=Column:::2:ER
  1425. KeyColumn:Reference:"Column"=,ColNo
  1426. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  1427. KeyColumn:Text:Get=`N`
  1428.  
  1429. PrimaryKey:Definition=Root=dbo.sysconstraints
  1430. PrimaryKey:Category=PrimaryKey
  1431. PrimaryKey:Values=A.status & 15 = 1
  1432. ; B.type = 'K'  
  1433. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  1434. PrimaryKey:Objects2=Q:P:1M::"Columns":IndexColumn
  1435. PrimaryKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1436. PrimaryKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1437. PrimaryKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1438. PrimaryKey:Attrs:T4=dbo.sysindexes.indid=indid:::0
  1439. PrimaryKey:Reference:"Index"=,indid
  1440. PrimaryKey:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1441. PrimaryKey:AttrReference:name=constid=id
  1442. PrimaryKey:AttrReference:crdate=constid=id
  1443. PrimaryKey:AttrReference:sysstat=constid=id
  1444. PrimaryKey:AttrReference:indid=B.name=name
  1445. ; and status & 0x1800 <> 0
  1446. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1447. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1448. PrimaryKey:Text:Init2= PRIMARY KEY (`{>IndexColumn}*`)
  1449. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1450. PrimaryKey:Text:Get2= PRIMARY KEY (`{>IndexColumn}*`)
  1451. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1452.  
  1453. ForeignKey:Definition=Root=dbo.sysreferences
  1454. ForeignKey:Category=ForeignKey
  1455. ; ForeignKey:Values=(B.status & 15 = 3) and (C.type = 'RI')
  1456. ForeignKey:Objects1=M:P:1M::"Columns":KeyColumn:GetKeyColumns
  1457. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  1458. ForeignKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1459. ForeignKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1460. ForeignKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1461. ForeignKey:Attrs:R=Table::::ER
  1462. ForeignKey:Reference:"Columns":Text=`[KeyColumn:%s, %s:*]`
  1463. ForeignKey:Reference:"Reference Table"=rkeyid
  1464. ForeignKey:AttrReference:name=constid=id
  1465. ForeignKey:AttrReference:crdate=constid=id
  1466. ForeignKey:AttrReference:sysstat=constid=id
  1467. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1468. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1469. ForeignKey:Text:Init2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1470. ForeignKey:Text:Init3= REFERENCES `=Table`
  1471. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1472. ForeignKey:Text:Get2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1473. ForeignKey:Text:Get3= REFERENCES `=Table`
  1474. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1475.  
  1476. UniqueConstraint:Definition=Root=dbo.sysconstraints
  1477. UniqueConstraint:Category=UniqueConstraint
  1478. UniqueConstraint:Values=A.status & 15 = 2
  1479. ; B.type = 'K'
  1480. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  1481. UniqueConstraint:Objects2=Q:P:1M::"Columns":IndexColumn
  1482. UniqueConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1483. UniqueConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1484. UniqueConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1485. UniqueConstraint:Attrs:T4=dbo.sysindexes.indid=indid:::0
  1486. UniqueConstraint:Reference:"Index"=,indid
  1487. UniqueConstraint:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1488. UniqueConstraint:AttrReference:name=constid=id
  1489. UniqueConstraint:AttrReference:crdate=constid=id
  1490. UniqueConstraint:AttrReference:sysstat=constid=id
  1491. UniqueConstraint:AttrReference:indid=B.name=name
  1492. ; and status & 0x1800 <> 0
  1493. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1494. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1495. UniqueConstraint:Text:Init2= UNIQUE (`{>IndexColumn}*`)
  1496. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1497. UniqueConstraint:Text:Get2= UNIQUE (`{>IndexColumn}*`)
  1498. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1499.  
  1500. CheckConstraint:Definition=Root=dbo.sysconstraints
  1501. CheckConstraint:Values=A.status & 15 = 4
  1502. ; B.type = 'C'
  1503. CheckConstraint:Category=Expression
  1504. CheckConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1505. CheckConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1506. CheckConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1507. CheckConstraint:Attrs:Q=Text=String:255:"Constraint Text":2:ER:PStripParens
  1508. CheckConstraint:AttrReference:name=constid=id
  1509. CheckConstraint:AttrReference:crdate=constid=id
  1510. CheckConstraint:AttrReference:sysstat=constid=id
  1511. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  1512. CheckConstraint:AttrReference:Text2=where id=`:constid` order by colid
  1513. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1514. CheckConstraint:Text:Init=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  1515. CheckConstraint:Text:Get=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`  CHECK (`=Text`)
  1516. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  1517. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  1518. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1519.  
  1520. ExtendedProcedure:Definition=Root=dbo.sysobjects
  1521. ExtendedProcedure:Category=Executable
  1522. ExtendedProcedure:Values=A.type = 'X'
  1523. ExtendedProcedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1524. ExtendedProcedure:Attrs:Q=DLLName=String:255:"DLL Name":2:ER
  1525. ExtendedProcedure:AttrReference:Owner=uid=uid
  1526. ExtendedProcedure:AttrReference:DLLName1=select text from dbo.syscomments
  1527. ExtendedProcedure:AttrReference:DLLName2=where id=`:id` order by colid
  1528. ExtendedProcedure:Warning=Loss
  1529. ExtendedProcedure:EAttrs=Text,New,Delete,Modify,Rename,Save
  1530. ExtendedProcedure:Text:Init=sp_addextendedproc '`EDefaultName`', 'dllname.dll'
  1531. ExtendedProcedure:Text:Get=sp_addextendedproc `NQ`, `:DLLName`
  1532. ExtendedProcedure:Text:RE=sp_addextendedproc\_+'(\w+)',\_+'(\w+)'
  1533. ExtendedProcedure:Text:Set=*N=1,DLLName=2
  1534. ExtendedProcedure:Delete:Text=sp_dropextendedproc `OQ`
  1535.  
  1536. [SYBASE Properties]
  1537. TBooleanYN:Values=Closed,0="No",-1="Yes"
  1538. TPhysicalType:Values1=Closed,34=image:"Image",35=text:"Text"
  1539. TPhysicalType:Values2=37=varbinary:"VarBinary"
  1540. TPhysicalType:Values3=38=int:"Int"
  1541. TPhysicalType:Values4=39=varchar:"VarChar"
  1542. TPhysicalType:Values5=45=binary:"Binary"
  1543. TPhysicalType:Values6=47=char:"Char"
  1544. TPhysicalType:Values7=48=tinyint:"TinyInt"
  1545. TPhysicalType:Values8=50=bit:"Bit"
  1546. TPhysicalType:Values9=52=smallint:"SmallInt"
  1547. TPhysicalType:Values10=55=decimal:"Decimal"
  1548. TPhysicalType:Values11=56=int:"Int"
  1549. TPhysicalType:Values12=58=smalldatetime:"SmallDateTime"
  1550. TPhysicalType:Values13=59=real:"Real"
  1551. TPhysicalType:Values14=60=money:"Money"
  1552. TPhysicalType:Values15=61=datetime:"DateTime"
  1553. TPhysicalType:Values16=62=float:"Float"
  1554. TPhysicalType:Values17=63=numeric:"Numeric"
  1555. TPhysicalType:Values18=106=decimal:"Decimal"
  1556. TPhysicalType:Values19=108=numeric:"Numeric"
  1557. TPhysicalType:Values20=109=float:"Float"
  1558. TPhysicalType:Values21=110=money:"Money"
  1559. TPhysicalType:Values22=111=datetime:"DateTime"
  1560. TPhysicalType:Values23=122=smallmoney:"SmallMoney"
  1561. TNull01:Values=Closed,0=not null:"No",-1=null:"Yes"
  1562. TObjectType:Values1=Closed,S="System Table",U="Table",V="View",L="Log",P="Procedure",
  1563. TObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  1564. TObjectStatus:Values=Closed,256="Read Only",4096="RamboIX"
  1565. TColumnStatus:Values=Closed,8=NULL:"Null"
  1566. TIndexStatus:Values1=Closed,2=UNIQUE:"Unique",16=CLUSTERED:"Clustered"
  1567. TIndexStatus:Values2=1=:"Dup Key Abort",4=:"Dup Row Abort"
  1568. TIndexStatus:Values3=64=:"Allow Dup Rows",32768=:"Suspect"
  1569. TLoginStatus:Values=Closed,1=:"Small Password",2=:"Locked account",4=:"Password Expired"
  1570. TDeviceType:Values1=Closed,0=0:"Database",2=2:"Disk Dump",3=3:"Tape Dump",4=4:"Tape Dump"
  1571. TDeviceType:Values2=5=5:"Tape Dump",6=6:"Tape Dump",7=7:"Tape Dump",8=8:"Tape Dump"
  1572. TDeviceStatus:Values1=Closed,1=:"Default",2=:"Physical Disk",4=:"Logical Disk"
  1573. TDeviceStatus:Values2=8=:"Skip Header",16=:"Dump Device",32=:"Serial Writes"
  1574. TDeviceStatus:Values3=64=:"Device Mirrored",128=:"Reads Mirrored"
  1575. TDeviceStatus:Values4=256=:"Half-Mirrored",512=:"Mirror Enabled"
  1576. TSegmentStatus:Values=Closed,1=:"Default"
  1577.  
  1578. SYBASE:UserName=select user_name()
  1579. SYBASE:Comments=--;/*,*/
  1580.  
  1581. SYBASE:Objects1=O:C:0M::"Data Types":Type
  1582. SYBASE:Objects2=O:C:0M::"Tables":Table
  1583. SYBASE:Objects3=O:C:0M::"Views":View
  1584. SYBASE:Objects4=O:C:0M::"Procedures":Procedure
  1585. SYBASE:Objects5=O:C:0M::"Defaults":Default
  1586. SYBASE:Objects6=O:C:0M::"Rules":Rule
  1587. SYBASE:Objects7=O:C:0M::"Logins":Login
  1588. SYBASE:Objects8=O:C:0M::"Groups":Group
  1589. SYBASE:Objects9=O:C:0M::"Users":User
  1590. SYBASE:Objects10=O:C:0M::"Segments":Segment
  1591. SYBASE:Objects11=O:C:0M::"Devices":Device
  1592.  
  1593. dbo.sysobjects:Key=id
  1594. dbo.sysobjects:Name=Owner,name
  1595. dbo.sysobjects:Attrs1=crdate="Creation Date"
  1596. dbo.sysobjects:Attrs2=sysstat="Status":::::VS=TObjectStatus:$1100
  1597. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  1598. dbo.sysobjects:Dataset1=name,id,uid,type,userstat,sysstat,indexdel,
  1599. dbo.sysobjects:Dataset2=crdate,expdate,deltrig,instrig,updtrig,seltrig
  1600.  
  1601. dbo.syscolumns:Key=id,colid
  1602. dbo.syscolumns:Name=name
  1603. dbo.syscolumns:Order=colid
  1604. dbo.syscolumns:Objects1=P:R:M1::"Type":Type
  1605. dbo.syscolumns:Objects2=P:R:M1::"Default Value":Default
  1606. dbo.syscolumns:Objects3=P:R:M1::"Domain Rule":Rule
  1607. dbo.syscolumns:Reference:"Type"=usertype
  1608. dbo.syscolumns:Reference:"Default Value"=cdefault
  1609. dbo.syscolumns:Reference:"Domain Rule"=domain
  1610. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1611. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1612. dbo.syscolumns:Attrs3=status="Status"::E:::VS=TColumnStatus:$8
  1613.  
  1614. dbo.sysindexes:Key=id,indid
  1615. dbo.sysindexes:Name=name
  1616. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1617. dbo.sysindexes:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1618. dbo.sysindexes:Attrs1=status="Status":::::VS=TIndexStatus:$8077
  1619. dbo.sysindexes:Attrs2=minlen="Minimum row size":2
  1620. dbo.sysindexes:Attrs3=maxlen="Maximum row size":2
  1621.  
  1622. dbo.systypes:Key=usertype
  1623. dbo.systypes:Name=name
  1624. dbo.systypes:Objects1=P:R:M1::"Default Value":Default
  1625. dbo.systypes:Objects2=P:R:M1::"Domain Rule":Rule
  1626. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1627. dbo.systypes:Attrs2=length=Length="Length"::E
  1628. dbo.systypes:Attrs3=allownulls=Null="Nulls"::E:::VM=TNull01
  1629. dbo.systypes:Attrs4=variable="Variable Length":::::VM=TBooleanYN
  1630. dbo.systypes:Reference:"Default Value"=tdefault
  1631. dbo.systypes:Reference:"Domain Rule"=domain
  1632.  
  1633. dbo.syssegments:Key=segment
  1634. dbo.syssegments:Name=name
  1635. dbo.syssegments:Attrs1=status="Status":::::VS=TSegmentStatus:$FFFF
  1636.  
  1637. dbo.sysusers:Key=uid
  1638. dbo.sysusers:Name=name
  1639.  
  1640. master.dbo.syslogins:Dataset1=suid,status,accdate,totcpu,totio,spacelimit
  1641. master.dbo.syslogins:Dataset2=timelimit,resultlimit,dbname,name,language
  1642. master.dbo.syslogins:Key=suid
  1643. master.dbo.syslogins:Name=name
  1644. master.dbo.syslogins:Attrs1=dbname="Default Database"
  1645. master.dbo.syslogins:Attrs2=accdate="Last Access"
  1646. master.dbo.syslogins:Attrs3=status="Status":::::VS=TLoginStatus:$FFF7
  1647. master.dbo.syslogins:Attrs4=language="Default Language"
  1648. master.dbo.syslogins:Attrs5=totcpu="Total CPU":2
  1649. master.dbo.syslogins:Attrs6=totio="Total IO":2
  1650.  
  1651. master.dbo.sysdevices:Name=name
  1652. master.dbo.sysdevices:Attrs1=cntrltype="Type":::::VM=TDeviceType
  1653. master.dbo.sysdevices:Attrs2=status="Status":::::VS=TDeviceStatus:$FFFF
  1654. master.dbo.sysdevices:Attrs3=phyname="Physical Name"
  1655. master.dbo.sysdevices:Attrs4=mirrorname="Mirror Name"
  1656. master.dbo.sysdevices:Attrs5=low="First Page"
  1657. master.dbo.sysdevices:Attrs6=high="Last Page"
  1658.  
  1659. Table:Definition=Root=dbo.sysobjects
  1660. View:Definition=Root=dbo.sysobjects
  1661. Procedure:Definition=Root=dbo.sysobjects
  1662. Default:Definition=Root=dbo.sysobjects
  1663. Rule:Definition=Root=dbo.sysobjects
  1664. Trigger:Definition=Root=dbo.sysobjects
  1665. Type:Definition=Root=dbo.systypes
  1666. Index:Definition=Root=dbo.sysindexes
  1667. Column:Definition=Root=dbo.syscolumns
  1668. Parameter:Definition=Root=dbo.syscolumns
  1669. Segment:Definition=Root=dbo.syssegments
  1670. User:Definition=Root=dbo.sysusers
  1671. Group:Definition=Root=dbo.sysusers
  1672. Database:Definition=Root=master.dbo.sysdatabases
  1673. Login:Definition=Root=master.dbo.syslogins
  1674. Device:Definition=Root=master.dbo.sysdevices
  1675.  
  1676. Table:Category=Dataset
  1677. Table:Values=A.type IN ('U', 'S')
  1678. Table:Objects1=T:P:1M::"Columns":Column
  1679. Table:Objects2=T:O:0M::"Indices":Index
  1680. Table:Objects3=T:O:0M::"Triggers":Trigger
  1681. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *] \N`
  1682. Table:Reference:"Triggers"=id=deltrig
  1683. Table:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1684. Table:AttrReference:Owner=uid=uid
  1685. Table:FilterSystemObjects=A.type <> 'S'
  1686. Table:Warning=DataLoss
  1687. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1688. Table:Text:Get=CREATE TABLE `N` (`{>Column}*`)
  1689. Table:Delete:Text=DROP TABLE `O`
  1690. Table:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1691.  
  1692. View:Category=Dataset
  1693. View:Values=A.type = 'V'
  1694. View:Objects1=T:P:0M:NMDR:"Columns":Column
  1695. View:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1696. View:Attrs:Q=Text=String:255:"Text"::ER
  1697. View:AttrReference:Owner=uid=uid
  1698. View:AttrReference:Text1=select text from dbo.syscomments
  1699. View:AttrReference:Text2=where id=`:id` order by colid
  1700. View:Warning=Loss
  1701. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1702. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM owner.table
  1703. View:Text:Get=`=Text`
  1704. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  1705. View:Text:NameSet=1=`N`
  1706. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  1707. View:Text:Set=Text=0,*N=2
  1708. View:Delete:Text=DROP VIEW `O`
  1709.  
  1710. Procedure:Category=Executable
  1711. Procedure:Values=A.type = 'P'
  1712. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1713. Procedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1714. Procedure:Attrs:Q=Text=String:255:"Text"::ER
  1715. Procedure:AttrReference:Owner=uid=uid
  1716. Procedure:AttrReference:Text1=select text from dbo.syscomments
  1717. Procedure:AttrReference:Text2=where id=`:id` order by colid
  1718. Procedure:Warning=Loss
  1719. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1720. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS
  1721. Procedure:Text:Get=`=Text`
  1722. Procedure:Text:NameRE=Text:PROC(EDURE)?\_(\_*\w+)
  1723. Procedure:Text:NameSet=2=`N`
  1724. Procedure:Text:RE=^(.*\_)?CREATE\_+(PROC(EDURE)?)\_+(\w+)\_.*$
  1725. Procedure:Text:Set=2=`'PROCEDURE'`,Text=0,*N=4
  1726. Procedure:Delete:Text=DROP PROCEDURE `O`
  1727. Procedure:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1728.  
  1729. Default:Category=Expression
  1730. Default:Values=A.type = 'D'
  1731. Default:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1732. Default:Attrs:Q=Text=String:255:"Text":2:ER:PGetDefaultText
  1733. Default:AttrReference:Owner=uid=uid
  1734. Default:AttrReference:Text1=select text from dbo.syscomments
  1735. Default:AttrReference:Text2=where id=`:id` order by colid
  1736. Default:Warning=Loss
  1737. Default:EAttrs=Text,New,Delete,Modify,Rename,Save
  1738. Default:Text:Init=CREATE DEFAULT `EDefaultName` AS NULL
  1739. Default:Text:Get=CREATE DEFAULT `N` AS `=Text`
  1740. Default:Text:NameRE=Text:DEFAULT\_(\_*\w+)
  1741. Default:Text:NameSet=1=`N`
  1742. Default:Text:RE=CREATE\_+DEFAULT\_+(\w+)\_+AS\_(.*)
  1743. Default:Text:Set=*N=1,Text=2
  1744. Default:Delete:Text=DROP DEFAULT `O`
  1745.  
  1746. Rule:Category=Expression
  1747. Rule:Values=A.type = 'R'
  1748. Rule:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1749. Rule:Attrs:Q=Text=String:255:"Text"::ER
  1750. Rule:AttrReference:Owner=uid=uid
  1751. Rule:AttrReference:Text1=select text from dbo.syscomments
  1752. Rule:AttrReference:Text2=where id=`:id` order by colid
  1753. Rule:EAttrs=Text,New,Delete,Modify,Rename,Save
  1754. Rule:Text:Init=CREATE RULE `EDefaultName` AS NULL
  1755. Rule:Text:Get=`=Text`
  1756. Rule:Text:NameRE=Text:RULE\_+(\w+)
  1757. Rule:Text:NameSet=1=`N`
  1758. Rule:Text:RE=^(.*\_)?CREATE\_+RULE\_+(\w+)\_+.*$
  1759. Rule:Text:Set=*N=2,Text=0
  1760. Rule:Delete:Text=DROP RULE `O`
  1761.  
  1762. Trigger:Category=Executable
  1763. Trigger:Values=A.type = 'TR'
  1764. Trigger:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1765. Trigger:Attrs:Q=Text=String:255:"Text"::ER:PROOName
  1766. Trigger:AttrReference:Owner=uid=uid
  1767. Trigger:AttrReference:Text1=select text from dbo.syscomments
  1768. Trigger:AttrReference:Text2=where id=`:id` order by colid
  1769. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1770. Trigger:Text:Init=CREATE TRIGGER `EDefaultName` ON `{<}N` FOR INSERT, UPDATE, DELETE AS`\N`
  1771. Trigger:Text:Get=`=Text`
  1772. Trigger:Text:NameRE=Text:TRIGGER\_+(\w+)\_+ON\_+(\w+)
  1773. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  1774. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_+ON\_+(\w+).*$
  1775. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  1776. Trigger:Delete:Text=DROP TRIGGER `O`
  1777.  
  1778. RIConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1779. RIConstraint:AttrReference:Owner=uid=uid
  1780.  
  1781. Column:Category=Column
  1782. Column:Attrs:R=Type:"Type":"Length":1:ER
  1783. Column:EAttrs=Text,New,Delete,Modify,Rename
  1784. Column:Text:Get=`N ' ' EType EDefault``! ' ' =status`
  1785.  
  1786. Index:Category=Index
  1787. Index:Values=A.keycnt > 0
  1788. Index:Attrs:R=status::::+E
  1789. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  1790. Index:Text:Get1=CREATE `=status` INDEX `N`
  1791. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  1792. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  1793. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  1794. Index:Delete:Text=DROP INDEX `{<}O`.`O`
  1795.  
  1796. IndexColumn:Category=ColumnReference
  1797. IndexColumn:Name=Column
  1798. IndexColumn:Order=Id
  1799. IndexColumn:Definition1=Dataset=
  1800. IndexColumn:Definition2=select Id=c.colid, TabId=c.id, ColId=i.colid
  1801. IndexColumn:Definition3=from sysindexes x, syscolumns c, syscolumns i
  1802. IndexColumn:Definition4=where (x.id=`:id`) and (x.id=c.id) and (x.id=i.id) and
  1803. IndexColumn:Definition5=(x.name=`OQ`) and (c.colid<=keycnt) and
  1804. IndexColumn:Definition6=(i.name=INDEX_COL(`{<}OQ`,x.indid,c.colid))
  1805. IndexColumn:Dataset=Id=Word,TabId=Word,ColId=Word
  1806. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1807. IndexColumn:Attrs1=Id="Order":2:ER
  1808. IndexColumn:Attrs:R=Column:::2:ER
  1809. IndexColumn:Reference:"Column"=TabId,ColId
  1810. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  1811. IndexColumn:Text:Get=`N`
  1812.  
  1813. Parameter:Category=Column
  1814. Parameter:Attrs:R=Type:"Type":"Length":1
  1815. Parameter:EAttrs=
  1816.  
  1817. Type:Category=Type
  1818. Type:Attrs:T=dbo.sysusers.name=Owner:"Owner":Type:1
  1819. Type:AttrReference:Owner=uid=uid
  1820. Type:Warning=Loss
  1821. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  1822. Type:Text:Init=sp_addtype "`EDefaultName`", "varchar(255)", "null"
  1823. Type:Text:Get=sp_addtype "`N`", "`EType`"`! ', "' =Null '"'`
  1824. Type:Delete:Text=sp_droptype "`O`"
  1825.  
  1826. Login:Attrs:P=Password=String
  1827. Login:Attrs:R=Password:"Password":"Default Language":2
  1828. Login:EAttrs=Text
  1829. Login:Text:Get=sp_addlogin "`N`", "`=Password`", "`=dbname`", "`=language`"
  1830. Login:Delete:Text=sp_droplogin "`O`"
  1831.  
  1832. Group:Values=A.uid = A.gid
  1833. ; !!! Group:Objects=P:R:0M::"Users":User
  1834. Group:Reference:"Users"=uid=gid
  1835. Group:EAttrs=Text
  1836. Group:Text:Get=sp_addgroup "`N`"
  1837. Group:Delete:Text=sp_dropgroup "`O`"
  1838.  
  1839. User:Values=A.uid <> A.gid
  1840. User:Objects1=P:R:M1::"Login":Login
  1841. User:Objects2=P:R:M1::"Group":Group
  1842. User:Reference:"Login"=suid
  1843. User:Reference:"Group"=gid
  1844. User:EAttrs=Text
  1845. User:Text:Get=sp_adduser "`=Login`", "`N`", "`=Group`"
  1846. User:Delete:Text=sp_dropuser "`O`"
  1847.  
  1848. Segment:Objects=P:R:M0::"Device":Device
  1849. Segment:Attrs:P=DeviceName=String:::0
  1850. Segment:Reference:"Device"=DeviceName
  1851. Segment:EAttrs=Text
  1852. Segment:Text:Get=sp_addsegment "`N`","`=Device`"
  1853. Segment:Delete:Text=sp_dropsegment "`O`"
  1854.  
  1855. Device:EAttrs=Text
  1856. Device:Text:Get1=DISK INIT NAME="`N`",`\N'  '`PHYSNAME="`=phyname`",
  1857. Device:Text:Get2=`\N'  '`VDEVNO=?,`\N'  '`SIZE=?,
  1858. Device:Text:Get3=`\N'  '`CNTRLTYPE=`=cntrltype`
  1859. Device:Delete:Text=sp_dropdevice "`O`"
  1860.  
  1861. [SYBASE 10 Properties]
  1862. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1863. dbo.systypes:Attrs2=length=Length="Length"::E
  1864. dbo.systypes:Attrs3=prec=Precision="Precision":2:E
  1865. dbo.systypes:Attrs4=scale=Scale="Scale":2:E
  1866. dbo.systypes:Attrs5=allownulls=Null="Nulls"::E:::VM=TNull01
  1867. dbo.systypes:Attrs6=variable="Variable Length":::::VM=TBooleanYN
  1868.  
  1869. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1870. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1871. dbo.syscolumns:Attrs3=prec=Precision="Precision":2:E
  1872. dbo.syscolumns:Attrs4=scale=Scale="Scale":2:E
  1873. dbo.syscolumns:Attrs5=status="Status"::E:::VS=TColumnStatus:$8
  1874.  
  1875. dbo.sysconstraints:Key=tableid,constrid
  1876. dbo.sysconstraints:Name=name
  1877.  
  1878. dbo.sysreferences:Key=tableid,constrid
  1879. dbo.sysreferences:Name=name
  1880.  
  1881. Table:Objects1=T:P:1M::"Columns":Column
  1882. Table:Objects2=T:O:0M::"Indices":Index
  1883. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  1884. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  1885. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  1886. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  1887. Table:Objects7=T:O:0M::"Triggers":Trigger
  1888.  
  1889. KeyColumn:Category=ColumnReference
  1890. KeyColumn:Definition=Dataset
  1891. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer
  1892. KeyColumn:Name=Column
  1893. KeyColumn:Order=ItemNo
  1894. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1895. KeyColumn:Attrs1=ItemNo="Order":2:ER
  1896. KeyColumn:Attrs:R=Column:::2:ER
  1897. KeyColumn:Reference:"Column"=,ColNo
  1898. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  1899. KeyColumn:Text:Get=`N`
  1900.  
  1901. PrimaryKey:Definition=Root=dbo.sysindexes
  1902. PrimaryKey:Category=PrimaryKey
  1903. PrimaryKey:Values=(A.status2 & 2 <> 0) and (A.status & 2048 <> 0)
  1904. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  1905. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1906. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1907. PrimaryKey:Text:Init2= PRIMARY KEY (`{>IndexColumn}*`)
  1908. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1909. PrimaryKey:Text:Get2= PRIMARY KEY (`{>IndexColumn}*`)
  1910. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1911.  
  1912. ForeignKey:Definition=Root=dbo.sysreferences
  1913. ForeignKey:Category=ForeignKey
  1914. ; ForeignKey:Values=C.type = 'RI'
  1915. ForeignKey:Objects1=M:P:1M::"Columns":KeyColumn:GetKeyColumns
  1916. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  1917. ForeignKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1918. ForeignKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1919. ForeignKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1920. ForeignKey:Attrs:R=Table::::ER
  1921. ForeignKey:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  1922. ForeignKey:Reference:"Reference Table"=reftabid
  1923. ForeignKey:AttrReference:name=constrid=id
  1924. ForeignKey:AttrReference:crdate=constrid=id
  1925. ForeignKey:AttrReference:sysstat=constrid=id
  1926. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1927. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1928. ForeignKey:Text:Init2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1929. ForeignKey:Text:Init3= REFERENCES `=Table`
  1930. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1931. ForeignKey:Text:Get2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1932. ForeignKey:Text:Get3= REFERENCES `=Table`
  1933. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1934.  
  1935. UniqueConstraint:Definition=Root=dbo.sysindexes
  1936. UniqueConstraint:Category=UniqueConstraint
  1937. UniqueConstraint:Values=(A.status2 & 2 <> 0) and (A.status & 2048 = 0)
  1938. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  1939. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1940. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1941. UniqueConstraint:Text:Init2= UNIQUE (`{>IndexColumn}*`)
  1942. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1943. UniqueConstraint:Text:Get2= UNIQUE (`{>IndexColumn}*`)
  1944. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1945.  
  1946. CheckConstraint:Definition=Root=dbo.sysconstraints
  1947. CheckConstraint:Values=B.sysstat & 15 = 7
  1948. ; B.type = 'R'
  1949. CheckConstraint:Category=Expression
  1950. CheckConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1951. CheckConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1952. CheckConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1953. CheckConstraint:Attrs:Q=Text=String:255:"Constraint Text":2:ER:PStripCheck
  1954. CheckConstraint:AttrReference:name=constrid=id
  1955. CheckConstraint:AttrReference:crdate=constrid=id
  1956. CheckConstraint:AttrReference:sysstat=constrid=id
  1957. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  1958. CheckConstraint:AttrReference:Text2=where id=`:constrid` order by colid
  1959. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1960. CheckConstraint:Text:Init=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  1961. CheckConstraint:Text:Get=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`  CHECK (`=Text`)
  1962. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  1963. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  1964. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1965.  
  1966. [INTRBASE Properties]
  1967. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  1968. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  1969. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  1970. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  1971. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  1972. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  1973. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  1974. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  1975. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  1976. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  1977. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  1978. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  1979. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  1980. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  1981.  
  1982. INTRBASE:Comments=/*,*/
  1983.  
  1984. INTRBASE:Objects1=O:C:0M::"Domains":Type
  1985. INTRBASE:Objects2=O:C:0M::"Tables":Table
  1986. INTRBASE:Objects3=O:C:0M::"Views":View
  1987. INTRBASE:Objects4=O:C:0M::"Procedures":Procedure
  1988. INTRBASE:Objects5=O:C:0M::"Functions":Function
  1989. INTRBASE:Objects6=O:C:0M::"Generators":Generator
  1990. INTRBASE:Objects7=O:C:0M::"Exceptions":Exception
  1991. INTRBASE:Objects8=O:C:0M::"Blob Filters":BlobFilter
  1992.  
  1993. RDB$RELATIONS:Name=RDB$RELATION_NAME
  1994. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  1995. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  1996. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  1997.  
  1998. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  1999. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  2000. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  2001. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  2002. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  2003. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  2004. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  2005. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  2006.  
  2007. RDB$FIELDS:Name=RDB$FIELD_NAME
  2008. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  2009. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  2010. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  2011. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  2012. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  2013. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  2014. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  2015. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Rule="Constraint":2:E
  2016. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  2017.  
  2018. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  2019. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  2020. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  2021. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  2022. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  2023. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  2024.  
  2025. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  2026. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  2027. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  2028. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  2029. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  2030. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2031.  
  2032. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  2033. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  2034. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  2035. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  2036. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  2037. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  2038. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  2039. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  2040.  
  2041. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  2042. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  2043. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  2044. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  2045. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  2046. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  2047. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2048.  
  2049. RDB$INDICES:Name=RDB$INDEX_NAME
  2050. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  2051. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  2052. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  2053. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2054.  
  2055. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  2056. RDB$INDEX_SEGMENTS:Name=Column
  2057. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  2058. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  2059. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  2060. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  2061.  
  2062. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  2063. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  2064. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2065.  
  2066. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  2067. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  2068. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  2069. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  2070. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  2071. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  2072. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  2073.  
  2074. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  2075. RDB$TYPES:Name=RDB$TYPE_NAME
  2076. RDB$TYPES:Order=RDB$TYPE
  2077. RDB$TYPES:Attrs=RDB$TYPE="Value"
  2078.  
  2079. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  2080. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2081.  
  2082. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  2083. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  2084.  
  2085. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  2086. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  2087. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE=Type="Type"::ER:::VM=TTriggerType
  2088. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE=Position="Position"::ER
  2089. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2090.  
  2091. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  2092. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  2093. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  2094. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  2095. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  2096.  
  2097. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  2098. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  2099. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  2100. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  2101. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  2102. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  2103. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  2104. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  2105. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  2106. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2107.  
  2108. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  2109. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  2110.  
  2111. Table:Definition=Root=RDB$RELATIONS
  2112. View:Definition=Root=RDB$RELATIONS
  2113. Procedure:Definition=Root=RDB$PROCEDURES
  2114. Function:Definition=Root=RDB$FUNCTIONS
  2115. Trigger:Definition=Root=RDB$TRIGGERS
  2116. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  2117. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  2118. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  2119. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  2120. Exception:Definition=Root=RDB$EXCEPTIONS
  2121. Generator:Definition=Root=RDB$GENERATORS
  2122. Index:Definition=Root=RDB$INDICES
  2123. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  2124. Column:Definition=Root=RDB$RELATION_FIELDS
  2125. Type:Definition=Root=RDB$FIELDS
  2126. Enumeration:Definition=Root=RDB$TYPES
  2127. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  2128. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  2129. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  2130. BlobFilter:Definition=Root=RDB$FILTERS
  2131. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  2132.  
  2133. Exception:Warning=Loss
  2134. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  2135. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  2136. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  2137. Exception:Text:Set=*N=1,Message=2
  2138. Exception:Delete:Text=DROP EXCEPTION `O`
  2139.  
  2140. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  2141. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  2142. Generator:Warning=Loss
  2143. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  2144. Generator:Text:Init1=CREATE GENERATOR `EDefaultName ';' \N`
  2145. Generator:Text:Init2=SET GENERATOR `EDefaultName` TO 0
  2146. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  2147. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  2148. Generator:Text:Set=*N=1,gen_id=3
  2149. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  2150. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME=`OQ`
  2151.  
  2152. Table:Category=Dataset
  2153. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  2154. Table:Objects1=T:P:1M::"Columns":Column
  2155. Table:Objects2=T:O:0M::"Indices":Index
  2156. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  2157. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2158. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  2159. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  2160. Table:Objects7=T:O:0M::"Triggers":Trigger
  2161. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  2162. Table:Warning=DataLoss
  2163. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2164. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  2165. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  2166. Table:Text:Set=*N=1
  2167. Table:Delete:Text=DROP TABLE `O`
  2168.  
  2169. View:Category=Dataset
  2170. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  2171. View:Objects=T:P:0M:NMDR:"Columns":Column
  2172. View:Attrs:Q=Text=Memo::"Text"::ER
  2173. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  2174. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  2175. View:Warning=Loss
  2176. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  2177. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  2178. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS`=Text`
  2179. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  2180. View:Text:Set=Text=3,*N=1
  2181. View:Delete:Text=DROP VIEW `O`
  2182.  
  2183. Index:Category=Index
  2184. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2185. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  2186. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  2187. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2188. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2189. Index:Delete:Text=DROP INDEX `O`
  2190.  
  2191. Column:Category=Column
  2192. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::PResetType
  2193. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::PResetType
  2194. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::PResetType
  2195. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::PResetType
  2196. Column:Attrs:R=Type:"Domain":"Type":1:E::PSetType
  2197. Column:OnAfterLoad=ColumnLoaded
  2198. Column:OnCopyFrom=CopyWithDomain
  2199. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  2200. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  2201. Column:AttrReference:Length=RDB$FIELD_SOURCE
  2202. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  2203. Column:EAttrs=Text,New,Delete,Modify,Rename
  2204. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  2205.  
  2206. IndexColumn:Category=ColumnReference
  2207. IndexColumn:Attrs:R=Column:::2:ER
  2208. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2209. IndexColumn:Text:Get=`N`
  2210.  
  2211. Type:Category=Type
  2212. Type:Objects1=T:P:0M::"Dimensions":Dimension
  2213. Type:Objects2=T:C:0M::"Values":Enumeration
  2214. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Rule
  2215. Type:OnAfterLoad=TypeLoaded
  2216. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  2217. Type:Warning=Loss
  2218. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  2219. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  2220. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  2221. Type:Text:Get3=`!\N '  ' =Null`
  2222. Type:Text:Get4=`!\N '  CHECK (' =Rule ')'`
  2223. Type:Delete:Text=DROP DOMAIN `O`
  2224.  
  2225. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  2226. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  2227.  
  2228. Procedure:Category=Executable
  2229. Procedure:Objects=T:P:0M::"Parameters":Parameter
  2230. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  2231. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  2232. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  2233. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  2234. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME=`OQ`
  2235. Procedure:Warning=Loss
  2236. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2237. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS`\N`BEGIN`\N`END
  2238. Procedure:Text:Get1=CREATE PROCEDURE `N`
  2239. Procedure:Text:Get2=`{>Parameter} *`
  2240. Procedure:Text:Get3=AS `=Text`
  2241. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  2242. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  2243. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  2244. Procedure:Modify:Set=1=`'ALTER'`
  2245. Procedure:Delete:Text=DROP PROCEDURE `O`
  2246.  
  2247. Parameter:Category=Column
  2248. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::PResetType
  2249. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::PResetType
  2250. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::PResetType
  2251. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::PResetType
  2252. Parameter:Attrs:R=Type:"Domain":"Type":1:::PSetType
  2253. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  2254. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  2255. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  2256. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  2257. Parameter:EAttrs=Text
  2258. Parameter:Text:Get=`N ' ' EType`
  2259. Parameter:OnAfterLoad=AdjustTypeInfo
  2260. Parameter:OnCopyFrom=CopyWithDomain
  2261.  
  2262. Function:Category=Executable
  2263. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  2264. Function:Objects2=T:P:11::"Result":FunctionResult
  2265. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  2266. Function:Reference:"Result":Text=`[FunctionResult::*]`
  2267. Function:Warning=Loss
  2268. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  2269. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  2270. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  2271. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  2272. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  2273. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  2274.  
  2275. FunctionParameter:Category=Column
  2276. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  2277. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  2278. FunctionParameter:Text:Get=`EPhysicalType`
  2279.  
  2280. FunctionResult:Category=Column
  2281. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  2282. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  2283. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  2284. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  2285.  
  2286. BlobFilter:Category=Executable
  2287. BlobFilter:Warning=Loss
  2288. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  2289. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  2290. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  2291. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  2292. BlobFilter:Delete:Text=DROP FILTER `O`
  2293.  
  2294. CheckConstraint:Category=Expression
  2295. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  2296. CheckConstraint:Attrs:Q=Text=Memo::"Constraint Text":2:ER:PStripCheck
  2297. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  2298. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  2299. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  2300. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  2301. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME=`OQ`
  2302. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2303. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  2304. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  2305. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  2306. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  2307. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2308.  
  2309. UniqueConstraint:Category=UniqueConstraint
  2310. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  2311. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  2312. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  2313. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  2314. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  2315. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2316. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  2317. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  2318. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2319.  
  2320. PrimaryKey:Category=PrimaryKey
  2321. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  2322. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  2323. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  2324. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  2325. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  2326. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2327. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  2328. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  2329. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2330.  
  2331. ForeignKey:Category=ForeignKey
  2332. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  2333. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  2334. ForeignKey:Objects2=T:P:1M::"Columns":IndexColumn
  2335. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  2336. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  2337. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  2338. ForeignKey:Reference:"Reference Table"=ReferenceTable
  2339. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  2340. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  2341. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  2342. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  2343. ForeignKey:Attrs:R=Table::::ER
  2344. ForeignKey:AttrReference:ReferenceTable1=select RDB$RELATION_NAME
  2345. ForeignKey:AttrReference:ReferenceTable2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  2346. ForeignKey:AttrReference:ReferenceTable3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  2347. ForeignKey:AttrReference:ReferenceTable4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  2348. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2349. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2350. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2351. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2352. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  2353. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  2354. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  2355. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2356.  
  2357. Trigger:Category=Executable
  2358. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  2359. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  2360. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME=`OQ`
  2361. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  2362. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName` FOR `{<}N`
  2363. Trigger:Text:Init2=AFTER UPDATE POSITION 0 AS`\N`BEGIN`\N`END
  2364. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  2365. Trigger:Text:Get2=`=Type` POSITION `=Position` `=Text`
  2366. Trigger:Text:RE=CREATE\_+TRIGGER\_+(\w+)\_+FOR\_+(\w+)\_+(\w+\_\w+)\_+POSITION\_+(\w+)\_+(.*)
  2367. Trigger:Text:Set=*N=1,2=`{<}N`,Type=3,Position=4,Text=5
  2368. Trigger:Delete:Text=DROP TRIGGER `O`
  2369.  
  2370. [INFORMIX Properties]
  2371. TLockMode:Values=Closed,B=PAGE:"Page",P=PAGE:"Page",R=ROW:"Row"
  2372. TUnique:Values=Closed,-=:"No",U=UNIQUE:"Yes",D=:"No"
  2373. TClustered:Values=Closed,=:"No",-=:"No",C=CLUSTER:"Yes"
  2374. TDescending:Values=Closed,1=ASC:"No",-1=DESC:"Yes"
  2375. TMode:Values=Closed,P=DBA,O=Owner
  2376. TRule:Values=Closed,R=RESTRICT:"Restrict"
  2377. TDataType:Values1=Closed,0=`'CHAR(' =Length ')'`:CHAR,1=SMALLINT,2=INTEGER,3=FLOAT
  2378. TDataType:Values2=4=SMALLFLOAT,5=DECIMAL,6=SERIAL(1):SERIAL,7=DATE
  2379. TDataType:Values3=8=MONEY,10=DATETIME,11=BYTE,12=TEXT,13=VARCHAR,14=INTERVAL
  2380. TNull01:Values=Closed,0=:"Yes",1=NOT NULL:"No"
  2381.  
  2382. INFORMIX:UserName=select user from informix.systables where tabid=99
  2383. INFORMIX:Comments=--
  2384.  
  2385. INFORMIX:Objects1=O:C:0M::"Tables":Table
  2386. INFORMIX:Objects2=O:C:0M::"Views":View
  2387. INFORMIX:Objects3=O:C:0M::"Synonyms":Synonym
  2388. INFORMIX:Objects4=O:C:0M::"Procedures":Procedure
  2389.  
  2390. informix.systables:Key=tabid
  2391. informix.systables:Name=owner,tabname
  2392. informix.systables:Attrs1=created="Created"
  2393. informix.systables:Attrs2=locklevel="Lock Mode":2::::VM=TLockMode
  2394. informix.systables:Attrs3=fextsize="Initial Extent (K)":2
  2395. informix.systables:Attrs4=nextsize="Extent (K)":2
  2396. informix.systables:Attrs5=rowsize="Row Size":2
  2397. informix.systables:Attrs6=nrows="Rows":2
  2398. informix.systables:Attrs7=npused="Pages":2
  2399.  
  2400. informix.sysconstraints:Key=tabid,constrid
  2401. informix.sysconstraints:Name=owner,constrname
  2402.  
  2403. informix.sysindexes:Key=tabid,owner,idxname
  2404. informix.sysindexes:Name=owner,idxname
  2405. informix.sysindexes:Attrs1=idxtype="Unique"::E:::VM=TUnique
  2406. informix.sysindexes:Attrs2=clustered="Clustered"::E:::VM=TClustered
  2407. informix.sysindexes:Attrs3=levels="Levels":2,leaves="Leaves":2
  2408. informix.sysindexes:Attrs4=clust="Clustering Factor":2
  2409.  
  2410. informix.sysprocedures:Key=procid
  2411. informix.sysprocedures:Name=owner,procname
  2412. informix.sysprocedures:Attrs1=mode="Mode":::::VM=TMode
  2413. informix.sysprocedures:Attrs2=codesize="Code Size"
  2414. informix.sysprocedures:Attrs3=datasize="Data Size"
  2415. informix.sysprocedures:Attrs4=retsize="Values Size":2
  2416. informix.sysprocedures:Attrs5=symsize="Symbols Size":2
  2417.  
  2418. Table:Definition=Root=informix.systables
  2419. View:Definition=Root=informix.systables
  2420. Synonym:Definition=Root=informix.systables
  2421. Index:Definition=Root=informix.sysindexes
  2422. PrimaryKey:Definition=Root=informix.sysconstraints
  2423. ForeignKey:Definition=Root=informix.sysconstraints
  2424. UniqueConstraint:Definition=Root=informix.sysconstraints
  2425. CheckConstraint:Definition=Root=informix.sysconstraints
  2426. Procedure:Definition=Root=informix.sysprocedures
  2427.  
  2428. Table:Category=Dataset
  2429. Table:Values=A.tabtype = 'T'
  2430. Table:Objects1=Q:P:1M::"Columns":Column
  2431. Table:Objects2=T:O:0M::"Indices":Index
  2432. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  2433. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2434. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  2435. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  2436. Table:Attrs:R=locklevel::::E,fextsize::::E,nextsize::::E
  2437. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *]\N`
  2438. Table:Warning=DataLoss
  2439. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2440. Table:Text:Get1=CREATE TABLE `N` (`{>Column}*`)
  2441. Table:Text:Get2=`! ' EXTENT SIZE ' =fextsize``! ' NEXT SIZE ' =nextsize`
  2442. Table:Text:Get3=`! ' LOCK MODE ' =locklevel`
  2443. Table:Delete:Text=DROP TABLE `O`
  2444. Table:Rename:Text=RENAME TABLE `O` TO `N1`
  2445.  
  2446. View:Category=Dataset
  2447. View:Values=A.tabtype = 'V'
  2448. View:Objects=Q:P:0M:NMDR:"Columns":Column
  2449. View:Attrs:Q=Text=String::"Text"::ER
  2450. View:AttrReference:Text1=select viewtext, seqno from informix.sysviews
  2451. View:AttrReference:Text2=where tabid=`:tabid` order by seqno
  2452. View:Warning=Loss
  2453. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2454. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  2455. View:Text:Get=`=Text`
  2456. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  2457. View:Text:NameSet=1=`N`
  2458. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  2459. View:Text:Set=Text=0,*N=2
  2460. View:Delete:Text=DROP VIEW `O`
  2461.  
  2462. Synonym:Category=Dataset
  2463. Synonym:Values=A.tabtype IN ('P', 'S')
  2464. Synonym:Objects=P:R:M1::"Local Target":Table
  2465. Synonym:Attrs:T1=informix.syssyntable.servername=SName:"Server":::E
  2466. Synonym:Attrs:T2=informix.syssyntable.dbname=SDatabase:"Database":::E
  2467. Synonym:Attrs:T3=informix.syssyntable.owner=SOwner:"Owner":::E
  2468. Synonym:Attrs:T4=informix.syssyntable.tabname=STable:"Table":::E
  2469. Synonym:Attrs:T5=informix.syssyntable.btabid=TargetId:::0
  2470. Synonym:Attrs:R=Table::::E
  2471. Synonym:AttrReference:SName=tabid=tabid
  2472. Synonym:AttrReference:SDatabase=tabid=tabid
  2473. Synonym:AttrReference:SOwner=tabid=tabid
  2474. Synonym:AttrReference:STable=tabid=tabid
  2475. Synonym:AttrReference:TargetId=tabid=tabid
  2476. Synonym:Reference:"Local Target"=TargetId
  2477. Synonym:Warning=Loss
  2478. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2479. Synonym:Text:Get1=CREATE SYNONYM `N` FOR
  2480. Synonym:Text:Get2=`!=SName'@'``!=SDatabase'.'``!=SOwner'.'``=STable``=Table`
  2481. Synonym:Text:RE=CREATE\_+SYNONYM\_+(\w+)
  2482. Synonym:Text:Set=*N=1
  2483. Synonym:Delete:Text=DROP SYNONYM `O`
  2484.  
  2485. Column:Definition1=Dataset=
  2486. Column:Definition2=SELECT tabid,colno,colname,collength as Length,colmin,colmax,
  2487. Column:Definition3=coltype-trunc(coltype/256)*256 as Type,trunc(coltype/256) as Null
  2488. Column:Definition4=FROM informix.syscolumns WHERE tabid=`=tabid`
  2489. Column:Dataset1=tabid=Integer,colname=String,colno=Word,Length=Integer
  2490. Column:Dataset2=colmin=Integer,colmax=Integer,Type=Word,Null=Word
  2491. Column:Category=Column
  2492. Column:Key=tabid,colno
  2493. Column:Name=colname
  2494. Column:Order=colno
  2495. Column:Attrs1=colno="Order":2:ER
  2496. Column:Attrs2=Type="Type"::ER:::VM=TDataType
  2497. Column:Attrs3=Length="Length"::E
  2498. Column:Attrs4=Null="Nulls"::E:::VM=TNull01
  2499. Column:EAttrs=Text,New,Delete,Modify,Rename
  2500. Column:Text:Get=`N ' ' EType``! ' ' =Null`
  2501.  
  2502. Index:Category=Index
  2503. Index:Objects=M:P:1M::"Columns":IndexColumn:GetIndexColumns
  2504. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2505. Index:Text:Get1=CREATE `=idxtype``! ' ' =clustered` INDEX `N`
  2506. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  2507. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2508. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2509. Index:Delete:Text=DROP INDEX `O`
  2510. Index:Reference:"Columns":Text=`[IndexColumn:%s,%s:\N '  ' *]`
  2511.  
  2512. IndexColumn:Category=ColumnReference
  2513. IndexColumn:Definition=Dataset
  2514. IndexColumn:Dataset=ItemNo=Integer,ColNo=Integer,Descending=Integer
  2515. IndexColumn:Name=Column
  2516. IndexColumn:Order=ItemNo
  2517. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2518. IndexColumn:Attrs1=ItemNo="Order":2:ER
  2519. IndexColumn:Attrs2=Descending="Descending"::E:::VM=TDescending
  2520. IndexColumn:Attrs:R=Column::Descending:2:ER
  2521. IndexColumn:Reference:"Column"=,ColNo
  2522. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2523. IndexColumn:Text:Get=`N ' ' =Descending`
  2524.  
  2525. KeyColumn:Category=ColumnReference
  2526. KeyColumn:Definition=Dataset
  2527. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer,Descending=Integer
  2528. KeyColumn:Name=Column
  2529. KeyColumn:Order=ItemNo
  2530. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2531. KeyColumn:Attrs1=ItemNo="Order":2:ER
  2532. KeyColumn:Attrs:R=Column::Descending:2:ER
  2533. KeyColumn:Reference:"Column"=,ColNo
  2534. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  2535. KeyColumn:Text:Get=`N`
  2536.  
  2537. PrimaryKey:Category=PrimaryKey
  2538. PrimaryKey:Values=A.constrtype = 'P'
  2539. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  2540. PrimaryKey:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2541. PrimaryKey:Reference:"Index"=owner=owner,idxname=idxname
  2542. PrimaryKey:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]`
  2543. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2544. PrimaryKey:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2545. PrimaryKey:Text:Init2=PRIMARY KEY (`{>IndexColumn}*`) `\N`
  2546. PrimaryKey:Text:Init3=CONSTRAINT `EDefaultName`
  2547. PrimaryKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2548. PrimaryKey:Text:Get2=PRIMARY KEY (`{>IndexColumn}*`) `\N`
  2549. PrimaryKey:Text:Get3=CONSTRAINT `N`
  2550. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2551.  
  2552. ForeignKey:Category=ForeignKey
  2553. ForeignKey:Values=A.constrtype = 'R'
  2554. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  2555. ForeignKey:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2556. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  2557. ForeignKey:Attrs:T1=informix.sysreferences.ptabid=ReferenceTable:::0
  2558. ForeignKey:Attrs:T2=informix.sysreferences.primary=ReferenceConstraint:::0
  2559. ForeignKey:Attrs:R=Table::::ER
  2560. ForeignKey:Reference:"Index"=owner=owner,idxname=idxname
  2561. ForeignKey:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]`
  2562. ForeignKey:Reference:"Reference Table"=ReferenceTable
  2563. ForeignKey:AttrReference:ReferenceTable=constrid=constrid
  2564. ForeignKey:AttrReference:ReferenceConstraint=constrid=constrid
  2565. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2566. ForeignKey:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2567. ForeignKey:Text:Init2=FOREIGN KEY (`{>IndexColumn}*`)
  2568. ForeignKey:Text:Init3=REFERENCES `=Table \N`
  2569. ForeignKey:Text:Init4=CONSTRAINT `EDefaultName`
  2570. ForeignKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2571. ForeignKey:Text:Get2=FOREIGN KEY (`{>IndexColumn}*`) `\N`
  2572. ForeignKey:Text:Get3=REFERENCES `=Table \N`
  2573. ForeignKey:Text:Get4=CONSTRAINT `N`
  2574. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2575.  
  2576. CheckConstraint:Category=Expression
  2577. CheckConstraint:Values=A.constrtype = 'C'
  2578. CheckConstraint:Attrs:Q=Text=String::"Constraint Text":2:ER:PStripParens
  2579. CheckConstraint:AttrReference:Text1=select checktext, seqno from "informix".syschecks
  2580. CheckConstraint:AttrReference:Text2=where constrid=`:constrid` and type='T'
  2581. CheckConstraint:AttrReference:Text3=order by seqno
  2582. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2583. CheckConstraint:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2584. CheckConstraint:Text:Init2=CHECK () `\N`
  2585. CheckConstraint:Text:Init3=CONSTRAINT `EDefaultName`
  2586. CheckConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `\N`
  2587. CheckConstraint:Text:Get2=CHECK (`=Text`) `\N`
  2588. CheckConstraint:Text:Get3=CONSTRAINT `N`
  2589. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+CHECK\_*\((.*)\)\_+CONSTRAINT\_+(\w+)
  2590. CheckConstraint:Text:Set=1=`{<}N`,Text=2,*N=3
  2591. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2592.  
  2593. UniqueConstraint:Category=UniqueConstraint
  2594. UniqueConstraint:Values=A.constrtype = 'U'
  2595. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  2596. UniqueConstraint:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2597. UniqueConstraint:Reference:"Index"=owner=owner,idxname=idxname
  2598. UniqueConstraint:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]`
  2599. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2600. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2601. UniqueConstraint:Text:Init2=UNIQUE (`{>IndexColumn}*`) `\N`
  2602. UniqueConstraint:Text:Init3=CONSTRAINT `EDefaultName`
  2603. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2604. UniqueConstraint:Text:Get2=UNIQUE (`{>IndexColumn}*`) `\N`
  2605. UniqueConstraint:Text:Get3=CONSTRAINT `N`
  2606. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2607.  
  2608. Procedure:Category=Executable
  2609. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  2610. Procedure:AttrReference:Text1=select data, datakey, seqno from informix.sysprocbody
  2611. Procedure:AttrReference:Text2=where procid=`:procid` and datakey='T'
  2612. Procedure:AttrReference:Text3=order by datakey, seqno
  2613. Procedure:Warning=Loss
  2614. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2615. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName`
  2616. Procedure:Text:Get=`=Text`
  2617. Procedure:Text:NameRE=Text:PROCEDURE\_(\_*\w+)
  2618. Procedure:Text:NameSet=1=`N`
  2619. Procedure:Text:RE=CREATE(\_+DBA)?\_+PROCEDURE\_+(\w+).*
  2620. Procedure:Text:Set=Text=0,*N=2
  2621. Procedure:Delete:Text=DROP PROCEDURE `O`
  2622.  
  2623. [DB2 Common Server Properties]
  2624. TBooleanNY:Values=Closed,N=:"No",Y=:"Yes"
  2625. TBoolean01:Values=Closed,0=:"No",1=:"Yes"
  2626. TUpdateStatistics:Values=Closed,-1=
  2627. TNullNY:Values=Closed,N=NOT NULL:"No",Y=:"Yes"
  2628. TLoggedNY:Values=Closed,N=NOT LOGGED:"No",Y=LOGGED:"Yes"
  2629. TCompactNY:Values=Closed,N=NOT COMPACT:"No",Y=COMPACT:"Yes"
  2630. TDescending:Values=Closed,+=ASC:"No",-=DESC:"Yes"
  2631. TTypeKind:Values=Closed,S=:"System",T=:"Distinct"
  2632. TTypeId:Values1=Closed,124=BLOB,112=BOOLEAN,60=CHARACTER,44=CLOB,100=DATE,16=DECIMAL
  2633. TTypeId:Values2=8=DOUBLE,24=INTEGER,52=LONG VARCHAR,28=SMALLINT,104=TIME
  2634. TTypeId:Values3=108=TIMESTAMP,56=VARCHAR
  2635. TFunctionKind:Values=Closed,B=:"Built-in",E=:"External",U=:"Derived External",S=:"Generated"
  2636. TFunctionScalar:Values=Closed,C=:"No",S=:"Yes"
  2637. TVariantNY:Values=Closed,N=NOT VARIANT:"No",Y=VARIANT:"Yes"
  2638. TFencedNY:Values=Closed,N=NOT FENCED:"No",Y=FENCED:"Yes"
  2639. TNullCallNY:Values=Closed,N=NOT NULL CALL:"No",Y=NULL CALL:"Yes"
  2640. TExternalActionNY:Values=Closed,N=NO EXTERNAL ACTION:"No",E=EXTERNAL ACTION:"Yes"
  2641. TScratchPadNY:Values=Closed,N=NO SCRATCHPAD:"No",Y=SCRATCHPAD:"Yes"
  2642. TFinalCallNY:Values=Closed,N=NO FINAL CALL:"No",Y=FINAL CALL:"Yes"
  2643. TUnique:Values=Closed,D=:"No",U=UNIQUE:"Yes"
  2644. TValid:Values=Closed,N=:"No",Y=:"Yes",X=:"Rebind"
  2645. TDTFormat:Values=Closed,0=:"Country Code",1=:"USA",2=:"EUR",3=:"ISO",4=:"JIS",5="Local"
  2646. TIsolation:Values1=Closed,RR=:"Repeatable Read",RS=:"Read Stability"
  2647. TIsolation:Values2=CS=:"Cursor Stability",UR=:"Uncommitted Read"
  2648. TCursorBlocking:Values=Closed,N=:"No",U=:"Unambiguous",B=:"All"
  2649. TLanguageLevel:Values=Closed,0=SAA1,1=MIA
  2650. TExplainLevel:Values=Closed,A="All",P="Package"
  2651. TRule:Values1=Closed,A=NO ACTION:"No Action",C=CASCADE:"Cascade"
  2652. TRule:Values2=N=SET NULL:"Set Null",R=RESTRICT:"Restrict"
  2653. TTableStatus:Values=Closed,N=,C=:"Check pending",X=:"Inoperative"
  2654. TDataCaptureNY:Values=Closed,N=NONE:"No",Y=CHANGES:"Yes"
  2655. TTableSpaceType:Values1=Closed,S=SYSTEM USING ('filepath'):"System"
  2656. TTableSpaceType:Values2=D=DATABASE USING (DEVICE 'devicepath' size):"Database"
  2657. TTableSpaceData:Values=Closed,A=REGULAR:"All Permanent",L=LONG:"Long Data",T=TEMPORARY:"Temporary"
  2658. TTriggerValid:Values=Closed,X=:"No",Y=:"Yes"
  2659. TTriggerOrder:Values=Closed,B=:"Before",A=:"After"
  2660. TTriggerEvent:Values=Closed,I=:"On Insert",D=:"On Delete",U=:"On Update"
  2661. TTriggerGranularity:Values=Closed,S=:"Statement",R=:"Row"
  2662. TViewCheck:Values=Closed,N=,L=:"Local",C=:"Cascade"
  2663.  
  2664. DB2:UserName=select distinct user from syscat.datatypes
  2665. DB2:Comments=--
  2666.  
  2667. DB2:Objects1=O:C:0M::"Data Types":Type
  2668. DB2:Objects2=O:C:0M::"Tables":Table
  2669. DB2:Objects3=O:C:0M::"Views":View
  2670. DB2:Objects4=O:C:0M::"TableSpaces":TableSpace
  2671. DB2:Objects4=O:C:0M::"Aliases":Synonym
  2672. DB2:Objects5=O:C:0M::"Packages":Package
  2673. DB2:Objects6=O:C:0M::"Functions":Function
  2674.  
  2675. SYSCAT.CHECKS:Key=TABSCHEMA,TABNAME,CONSTNAME
  2676. SYSCAT.CHECKS:Name=CONSTNAME
  2677. SYSCAT.CHECKS:Attrs1=DEFINER="Owner"
  2678. SYSCAT.CHECKS:Attrs2=CREATE_TIME="Created"
  2679. SYSCAT.CHECKS:Attrs3=FUNC_PATH="Function Path":2
  2680. SYSCAT.CHECKS:Attrs4=TEXT="Constraint Text":2:ER
  2681.  
  2682. SYSCAT.COLCHECKS:Key=TABSCHEMA,TABNAME,CONSTNAME
  2683. SYSCAT.COLCHECKS:Name=CONSTNAME
  2684.  
  2685. SYSCAT.COLUMNS:Key=TABSCHEMA,TABNAME,COLNAME
  2686. SYSCAT.COLUMNS:Name=COLNAME
  2687. SYSCAT.COLUMNS:Order=COLNO
  2688. SYSCAT.COLUMNS:Objects=P:R:M1::"Type":Type
  2689. SYSCAT.COLUMNS:Attrs1=COLNO="Order":2:ER
  2690. SYSCAT.COLUMNS:Attrs2=LENGTH=Length="Length"::E
  2691. SYSCAT.COLUMNS:Attrs3=SCALE=Scale="Scale"::E
  2692. SYSCAT.COLUMNS:Attrs4=NULLS=Null="Nulls"::E:::VM=TNullNY
  2693. SYSCAT.COLUMNS:Attrs5=DEFAULT=Default="Default":2:E
  2694. SYSCAT.COLUMNS:Attrs6=LOGGED="Logged":2:E:::VM=TLoggedNY
  2695. SYSCAT.COLUMNS:Attrs7=COMPACT="Compacted":2:E:::VM=TCompactNY
  2696. SYSCAT.COLUMNS:Attrs8=CODEPAGE="Code Page":2
  2697. SYSCAT.COLUMNS:Attrs9=REMARKS="Comments":2
  2698. SYSCAT.COLUMNS:Reference:"Type"=TYPESCHEMA,TYPENAME
  2699.  
  2700. SYSCAT.DATATYPES:Name=TYPESCHEMA,TYPENAME
  2701. SYSCAT.DATATYPES:Attrs1=DEFINER="Owner"
  2702. SYSCAT.DATATYPES:Attrs2=METATYPE="Kind":::::VM=TTypeKind
  2703. SYSCAT.DATATYPES:Attrs3=LENGTH=Length="Length"::E
  2704. SYSCAT.DATATYPES:Attrs4=SCALE=Scale="Scale"::E
  2705. SYSCAT.DATATYPES:Attrs5=CREATE_TIME="Created"
  2706. SYSCAT.DATATYPES:Attrs6=CODEPAGE="Code Page":2
  2707. SYSCAT.DATATYPES:Attrs7=REMARKS="Comments":2
  2708.  
  2709. SYSCAT.FUNCPARMS:Key=FUNCSCHEMA,SPECIFICNAME,ORDINAL
  2710. SYSCAT.FUNCPARMS:Name=ORDINAL
  2711. SYSCAT.FUNCPARMS:Objects=P:R:M1::"Type":Type
  2712. SYSCAT.FUNCPARMS:Attrs1=LENGTH=Length="Length"::E
  2713. SYSCAT.FUNCPARMS:Attrs2=SCALE=Scale="Scale"::E
  2714. SYSCAT.FUNCPARMS:Attrs3=CODEPAGE="Code Page":2
  2715. SYSCAT.FUNCPARMS:Reference:"Type"=TYPESCHEMA,TYPENAME
  2716.  
  2717. SYSCAT.FUNCTIONS:Key=FUNCSCHEMA,SPECIFICNAME
  2718. SYSCAT.FUNCTIONS:Name=FUNCSCHEMA,SPECIFICNAME
  2719. SYSCAT.FUNCTIONS:Objects1=T:P:0M::"Parameters":FunctionParameter
  2720. SYSCAT.FUNCTIONS:Objects2=T:P:0M::"Result":Result
  2721. SYSCAT.FUNCTIONS:Attrs1=FUNCNAME="Function"
  2722. SYSCAT.FUNCTIONS:Attrs2=DEFINER="Owner"
  2723. SYSCAT.FUNCTIONS:Attrs3=ORIGIN="Origin":::::VM=TFunctionKind
  2724. SYSCAT.FUNCTIONS:Attrs4=TYPE="Scalar":::::VM=TFunctionScalar
  2725. SYSCAT.FUNCTIONS:Attrs5=CREATE_TIME="Created"
  2726. SYSCAT.FUNCTIONS:Attrs6=LANGUAGE="Language":2
  2727. SYSCAT.FUNCTIONS:Attrs7=IMPLEMENTATION="Implementation":2
  2728. SYSCAT.FUNCTIONS:Attrs8=VARIANT="Variant":2::::VM=TVariantNY
  2729. SYSCAT.FUNCTIONS:Attrs9=SIDE_EFFECTS="Side Effects":2::::VM=TExternalActionNY
  2730. SYSCAT.FUNCTIONS:Attrs10=FENCED="Fenced":2::::VM=TFencedNY
  2731. SYSCAT.FUNCTIONS:Attrs11=NULLCALL="NullCall":2::::VM=TNullCallNY
  2732. SYSCAT.FUNCTIONS:Attrs12=CAST_FUNCTION="Cast":2::::VM=TBooleanNY
  2733. SYSCAT.FUNCTIONS:Attrs13=ASSIGN_FUNCTION="Assignment":2::::VM=TBooleanNY
  2734. SYSCAT.FUNCTIONS:Attrs14=SCRATCHPAD="ScratchPad":2::::VM=TScratchPadNY
  2735. SYSCAT.FUNCTIONS:Attrs15=FINAL_CALL="Final Call":2::::VM=TFinalCallNY
  2736. SYSCAT.FUNCTIONS:Attrs16=REMARKS="Comments":2
  2737. SYSCAT.FUNCTIONS:Reference:"Parameters":Text=`[FunctionParameter:%s,%s:*]`
  2738. SYSCAT.FUNCTIONS:Reference:"Result":Text=`[Result:%s CAST FROM %s:*]`
  2739.  
  2740. SYSCAT.INDEXES:Name=INDSCHEMA,INDNAME
  2741. SYSCAT.INDEXES:Attrs1=DEFINER="Owner"
  2742. SYSCAT.INDEXES:Attrs2=UNIQUERULE="Unique"::E:::VM=TUnique
  2743. SYSCAT.INDEXES:Attrs3=USER_DEFINED="User Defined":::::VM=TBoolean01
  2744. SYSCAT.INDEXES:Attrs4=SYSTEM_REQUIRED="System Required":::::VM=TBoolean01
  2745. SYSCAT.INDEXES:Attrs5=CREATE_TIME="Created"
  2746. SYSCAT.INDEXES:Attrs6=STATS_TIME="Last Update Statistics"
  2747. SYSCAT.INDEXES:Attrs7=REMARKS="Comments":2
  2748. SYSCAT.INDEXES:Attrs8=NLEAF="Leaf Pages":2::::VM=TUpdateStatistics
  2749. SYSCAT.INDEXES:Attrs9=NLEVELS="Index Levels":2::::VM=TUpdateStatistics
  2750. SYSCAT.INDEXES:Attrs10=FIRSTKEYCARD="Distinct First Values":2::::VM=TUpdateStatistics
  2751. SYSCAT.INDEXES:Attrs11=FULLKEYCARD="Distinct Values":2::::VM=TUpdateStatistics
  2752. SYSCAT.INDEXES:Attrs12=CLUSTERRATIO="Cluster Ratio":2::::VM=TUpdateStatistics
  2753. SYSCAT.INDEXES:Attrs13=CLUSTERFACTOR="Cluster Factor":2::::VM=TUpdateStatistics
  2754. SYSCAT.INDEXES:Attrs14=COLNAMES=:4
  2755.  
  2756. SYSCAT.KEYCOLUSE:Key=TABSCHEMA,TABNAME,CONSTNAME,COLNAME
  2757. SYSCAT.KEYCOLUSE:Name=Column
  2758. SYSCAT.KEYCOLUSE:Order=COLSEQ
  2759. SYSCAT.KEYCOLUSE:Objects1=P:R:M1::"Column":Column:<<>Column
  2760. SYSCAT.KEYCOLUSE:Attrs1=COLSEQ="Order":2:ER
  2761. SYSCAT.KEYCOLUSE:Reference:"Column"=,,COLNAME
  2762.  
  2763. SYSCAT.PACKAGES:Name=PKGSCHEMA,PKGNAME
  2764. SYSCAT.PACKAGES:Objects=Q:C:0M::"Sections":Section
  2765. SYSCAT.PACKAGES:Attrs1=BOUNDBY="Bound By"
  2766. SYSCAT.PACKAGES:Attrs2=VALID="Valid":::::VM=TValid
  2767. SYSCAT.PACKAGES:Attrs3=TOTAL_SECT="Sections"
  2768. SYSCAT.PACKAGES:Attrs4=LAST_BIND_TIME="Last Bind"
  2769. SYSCAT.PACKAGES:Attrs5=EXPLICIT_BIND_TIME="Explicit Bind"
  2770. SYSCAT.PACKAGES:Attrs6=ISOLATION="Isolation Level":2::::VM=TIsolation
  2771. SYSCAT.PACKAGES:Attrs7=BLOCKING="Cursor Blocking":2::::VM=TCursorBlocking
  2772. SYSCAT.PACKAGES:Attrs8=LANG_LEVEL="Language Level":2::::VM=TLanguageLevel
  2773. SYSCAT.PACKAGES:Attrs9=FUNC_PATH="Function Path":2
  2774. SYSCAT.PACKAGES:Attrs10=FORMAT="Date Time Format":2::::VM=TDTFormat
  2775. SYSCAT.PACKAGES:Attrs11=CODEPAGE="Code Page":2
  2776. SYSCAT.PACKAGES:Attrs12=SQLWARN="SQL Warnings On":2::::VM=TBooleanNY
  2777. SYSCAT.PACKAGES:Attrs13=QUERYOPT="Optimization Class":2
  2778. SYSCAT.PACKAGES:Attrs14=EXPLAIN_LEVEL="Explain Level":2::::VM=TExplainLevel
  2779. SYSCAT.PACKAGES:Attrs15=EXPLAIN_SNAPSHOT="Explain Snapshot Active":2::::VM=TBooleanNY
  2780. SYSCAT.PACKAGES:Attrs16=REMARKS="Comments":2
  2781.  
  2782. SYSCAT.TABCONST:Key=TABSCHEMA,TABNAME,CONSTNAME
  2783. SYSCAT.TABCONST:Name=CONSTNAME
  2784. SYSCAT.TABCONST:Attrs1=DEFINER="Owner"
  2785. SYSCAT.TABCONST:Attrs2=REMARKS="Comments":2
  2786.  
  2787. SYSCAT.REFERENCES:Key=TABSCHEMA,TABNAME,CONSTNAME
  2788. SYSCAT.REFERENCES:Name=CONSTNAME
  2789. SYSCAT.REFERENCES:Objects1=T:P:1M::"Columns":KeyColumn
  2790. SYSCAT.REFERENCES:Objects2=P:R:M1::"Reference Table":Table
  2791. SYSCAT.REFERENCES:Attrs1=DEFINER="Owner"
  2792. SYSCAT.REFERENCES:Attrs2=CREATE_TIME="Created"
  2793. SYSCAT.REFERENCES:Attrs3=REFKEYNAME="Primary Key":2
  2794. SYSCAT.REFERENCES:Attrs4=DELETERULE="Delete Rule":2:E:::VM=TRule
  2795. SYSCAT.REFERENCES:Attrs5=UPDATERULE="Update Rule":2:E:::VM=TRule
  2796. SYSCAT.REFERENCES:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  2797. SYSCAT.REFERENCES:Reference:"Reference Table"=REFTABSCHEMA,REFTABNAME
  2798.  
  2799. SYSCAT.TABLES:Name=TABSCHEMA,TABNAME
  2800. SYSCAT.TABLES:Attrs1=DEFINER="Owner"
  2801. SYSCAT.TABLES:Attrs2=STATUS="Status":::::VM=TTableStatus
  2802. SYSCAT.TABLES:Attrs3=CREATE_TIME="Created"
  2803.  
  2804. SYSCAT.TABLESPACES:Name=TBSPACE
  2805. SYSCAT.TABLESPACES:Attrs1=DEFINER="Owner"
  2806. SYSCAT.TABLESPACES:Attrs2=TBSPACETYPE="Type":::::VM=TTableSpaceType
  2807. SYSCAT.TABLESPACES:Attrs3=DATATYPE="Data":::::VM=TTableSpaceData
  2808. SYSCAT.TABLESPACES:Attrs4=CREATE_TIME="Created"
  2809. SYSCAT.TABLESPACES:Attrs5=EXTENTSIZE="Extent Size":2
  2810. SYSCAT.TABLESPACES:Attrs6=PREFETCHSIZE="Prefetch Size":2
  2811. SYSCAT.TABLESPACES:Attrs7=OVERHEAD="Overhead":2
  2812. SYSCAT.TABLESPACES:Attrs8=TRANSFERRATE="Transfer Rate":2
  2813. SYSCAT.TABLESPACES:Attrs9=REMARKS="Comments":2
  2814.  
  2815. SYSCAT.TRIGGERS:Name=TRIGSCHEMA,TRIGNAME
  2816. SYSCAT.TRIGGERS:Attrs1=DEFINER="Owner"
  2817. SYSCAT.TRIGGERS:Attrs2=CREATE_TIME="Created"
  2818. SYSCAT.TRIGGERS:Attrs3=VALID="Valid":::::VM=TTriggerValid
  2819. SYSCAT.TRIGGERS:Attrs4=TRIGTIME="Order":::::VM=TTriggerOrder
  2820. SYSCAT.TRIGGERS:Attrs5=TRIGEVENT="On Event":::::VM=TTriggerEvent
  2821. SYSCAT.TRIGGERS:Attrs6=GRANULARITY="Granularity":::::VM=TTriggerGranularity
  2822. SYSCAT.TRIGGERS:Attrs7=FUNC_PATH="Function Path":2
  2823. SYSCAT.TRIGGERS:Attrs8=REMARKS="Comments":2
  2824.  
  2825. SYSCAT.VIEWS:Name=VIEWSCHEMA,VIEWNAME
  2826. SYSCAT.VIEWS:Attrs1=VIEWCHECK="Check Option":::::VM=TViewCheck
  2827. SYSCAT.VIEWS:Attrs2=READONLY="Read Only":::::VM=TBooleanNY
  2828. SYSCAT.VIEWS:Attrs3=FUNC_PATH="Function Path"
  2829.  
  2830. CheckConstraint:Category=Expression
  2831. CheckConstraint:Definition=Root=SYSCAT.TABCONST
  2832. CheckConstraint:Values=A.TYPE = 'K'
  2833. CheckConstraint:Attrs:T1=SYSCAT.CHECKS.CREATE_TIME=Created::REMARKS
  2834. CheckConstraint:Attrs:T2=SYSCAT.CHECKS.FUNC_PATH=FunctionPath::REMARKS
  2835. CheckConstraint:Attrs:T3=SYSCAT.CHECKS.TEXT=Text::REMARKS
  2836. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2837. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N` ADD CONSTRAINT `EDefaultName` CHECK ()
  2838. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  2839. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  2840. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  2841. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2842.  
  2843. Column:Category=Column
  2844. Column:Definition=Root=SYSCAT.COLUMNS
  2845. Column:Attrs:R=Type:"Type":"Length":1:ER
  2846. Column:EAttrs=Text,New,Delete,Modify,Rename
  2847. Column:Text:Get=`N` `EType``! ' ' =Null``! ' WITH DEFAULT ' =Default``! ' ' =LOGGED``! ' ' =COMPACT`
  2848. Column:New:Text=ALTER TABLE `{<}N` ADD COLUMN `*`
  2849.  
  2850. Type:Category=Type
  2851. Type:Definition=Root=SYSCAT.DATATYPES
  2852. Type:Objects=P:R:M1::"Base Type":Type
  2853. Type:Attrs:R=Type::"Length":1:ER
  2854. Type:Warning=Loss
  2855. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  2856. Type:Reference:"Base Type"=SOURCESCHEMA,SOURCENAME
  2857. Type:Text:Init=CREATE DISTINCT TYPE `EDefaultName` AS `EType`
  2858. Type:Text:Get=CREATE DISTINCT TYPE `N` AS `EType`
  2859. Type:Delete:Text=DROP DISTINCT TYPE `O`
  2860.  
  2861. FunctionParameter:Category=Column
  2862. FunctionParameter:Definition=Root=SYSCAT.FUNCPARMS
  2863. FunctionParameter:Values=A.ROWTYPE = 'P'
  2864. FunctionParameter:Order=ORDINAL
  2865. FunctionParameter:Attrs1=ORDINAL="Order":2:ER
  2866. FunctionParameter:EAttrs=Text
  2867. FunctionParameter:Text:Get=`EType`
  2868.  
  2869. Result:Category=Column
  2870. Result:Definition=Root=SYSCAT.FUNCPARMS
  2871. Result:Values=A.ROWTYPE IN ('R', 'C')
  2872. Result:EAttrs=Text
  2873. Result:Text:Get=`EType`
  2874.  
  2875. Function:Category=Executable
  2876. Function:Definition=Root=SYSCAT.FUNCTIONS
  2877. Function:Objects=P:R:M1::"Source":Function
  2878. Function:Warning=Loss
  2879. Function:EAttrs=Text
  2880. Function:Text:Get1=CREATE FUNCTION `=FUNCNAME` (`{>FunctionParameter}*`)`\N ' '`
  2881. Function:Text:Get2=`' RETURNS ' {>Result}*` SPECIFIC `N``\N '  '`
  2882. Function:Text:Get3=`!'EXTERNAL NAME ' \Q =IMPLEMENTATION \Q`
  2883. Function:Text:Get4=`!' LANGUAGE ' =LANGUAGE ' PARAMETER STYLE DB2SQL ' =VARIANT ' ' =FENCED ' ' =NULLCALL ' NO SQL ' =SIDE_EFFECTS ' ' =SCRATCHPAD ' ' =FINAL_CALL`
  2884. Function:Text:Get5=`!'SOURCE SPECIFIC ' =Function`
  2885. Function:Delete:Text=DROP SPECIFIC FUNCTION `O`
  2886.  
  2887. Index:Category=Index
  2888. Index:Definition=Root=SYSCAT.INDEXES
  2889. Index:Objects=M:P:1M::"Columns":IndexColumn:GetIndexColumns
  2890. Index:Values=A.UNIQUERULE <> 'P'
  2891. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2892. Index:Text:Get1=CREATE `=UNIQUERULE` INDEX `N`
  2893. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  2894. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2895. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2896. Index:Delete:Text=DROP INDEX `O`
  2897. Index:Reference:"Columns":Text=`[IndexColumn:%s,%s:*]`
  2898.  
  2899. IndexColumn:Category=ColumnReference
  2900. IndexColumn:Definition=Dataset
  2901. IndexColumn:Dataset1=ItemNo=Integer,ColName=String,Descending=String:1
  2902. IndexColumn:Name=Column
  2903. IndexColumn:Order=ItemNo
  2904. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2905. IndexColumn:Attrs1=ItemNo="Order":2:ER
  2906. IndexColumn:Attrs2=Descending="Descending"::E:::VM=TDescending
  2907. IndexColumn:Attrs:R=Column::Descending:2:ER
  2908. IndexColumn:Reference:"Column"=,,ColName
  2909. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2910. IndexColumn:Text:Get=`N ' ' =Descending`
  2911.  
  2912. Package:Definition=Root=SYSCAT.PACKAGES
  2913. Package:EAttrs=Delete,Save
  2914. Package:Delete:Text=DROP PACKAGE `O`
  2915.  
  2916. Section:Key=PKGSCHEMA,PKGNAME,SECTNO
  2917. Section:Name=SECTNO
  2918. Section:Definition1=Dataset=
  2919. Section:Definition2=SELECT SECTNO FROM SYSCAT.STATEMENTS
  2920. Section:Definition3=WHERE PKGSCHEMA=`OQ0` AND PKGNAME=`OQ1`
  2921. Section:Dataset=SECTNO=Integer
  2922. Section:Objects=Q:C:0M::"Statements":Statement
  2923. Section:EAttrs=
  2924.  
  2925. Statement:Name=STMTNO
  2926. Statement:Definition1=Dataset=
  2927. Statement:Definition2=SELECT STMTNO FROM SYSCAT.STATEMENTS
  2928. Statement:Definition3=WHERE PKGSCHEMA=`{<}OQ0` AND PKGNAME=`{<}OQ1` AND
  2929. Statement:Definition4=SECTNO=`:SECTNO`
  2930. Statement:Dataset=STMTNO=Integer
  2931. Statement:Attrs:Q=Text=Memo::"Text"
  2932. Statement:EAttrs=Text
  2933. Statement:Text:Get=`=Text`
  2934. Statement:AttrReference:Text1=SELECT TEXT, SEQNO FROM SYSCAT.STATEMENTS
  2935. Statement:AttrReference:Text2=WHERE PKGSCHEMA=`{<<}OQ0` AND PKGNAME=`{<<}OQ1`
  2936. Statement:AttrReference:Text3=AND SECTNO=`{<}:SECTNO` AND STMTNO=`:STMTNO`
  2937. Statement:AttrReference:Text4=ORDER BY SEQNO
  2938.  
  2939. PrimaryKey:Category=PrimaryKey
  2940. PrimaryKey:Definition=Root=SYSCAT.TABCONST
  2941. PrimaryKey:Values=A.TYPE = 'P'
  2942. PrimaryKey:Objects=T:P:1M::"Columns":KeyColumn
  2943. PrimaryKey:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  2944. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2945. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `EDefaultName \N '  '`
  2946. PrimaryKey:Text:Init2=PRIMARY KEY (`{>KeyColumn}*`)
  2947. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `N \N '  '`
  2948. PrimaryKey:Text:Get2=PRIMARY KEY (`{>KeyColumn}*`)
  2949. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2950.  
  2951. ForeignKey:Category=ForeignKey
  2952. ForeignKey:Definition=Root=SYSCAT.REFERENCES
  2953. ForeignKey:Attrs:T=SYSCAT.TABCONST.REMARKS=Comments
  2954. ForeignKey:Attrs:R=Table::::ER
  2955. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2956. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `EDefaultName`
  2957. ForeignKey:Text:Init2=`\N`  FOREIGN KEY (`{>KeyColumn}*`) REFERENCES `=Table`
  2958. ForeignKey:Text:Init3=`\N`  ON DELETE RESTRICT ON UPDATE RESTRICT
  2959. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `N`
  2960. ForeignKey:Text:Get2=`\N`  FOREIGN KEY (`{>KeyColumn}*`) REFERENCES `=Table \N`
  2961. ForeignKey:Text:Get3= ON DELETE `=DELETERULE \N '  '`ON UPDATE `=UPDATERULE`
  2962. ForeignKey:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+.*REFERENCES\_+(\w+)?.*\_ON\_+DELETE\_+(.*)\_ON\_+UPDATE\_+(.*)
  2963. ForeignKey:Text:Set=1=`{<}N`,*N=2,Table=3,DELETERULE=4,UPDATERULE=5
  2964. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2965.  
  2966. KeyColumn:Category=ColumnReference
  2967. KeyColumn:Definition=Root=SYSCAT.KEYCOLUSE
  2968. KeyColumn:Attrs:R=Column:::2:ER
  2969. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  2970. KeyColumn:Text:Get=`N`
  2971.  
  2972. Table:Category=Dataset
  2973. Table:Definition=Root=SYSCAT.TABLES
  2974. Table:Values=A.TYPE = 'T'
  2975. Table:Objects1=T:P:1M::"Columns":Column
  2976. Table:Objects2=T:O:0M::"Indices":Index
  2977. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  2978. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2979. Table:Objects5=T:O:0M::"Check Constraints":CheckConstraint
  2980. Table:Objects6=T:O:0M::"Triggers":Trigger
  2981. Table:Objects7=P:R:M1::"Table Space":TableSpace
  2982. Table:Objects8=P:R:M1::"Index Space":TableSpace
  2983. Table:Objects9=P:R:M1::"Long Space":TableSpace
  2984. Table:Attrs1=DATACAPTURE="Data Capture":2:E:::VM=TDataCaptureNY
  2985. Table:Attrs2=STATS_TIME="Update Statistics":2
  2986. Table:Attrs3=CARD="Row Count":2::::VM=TUpdateStatistics
  2987. Table:Attrs4=NPAGES="Used Pages":2::::VM=TUpdateStatistics
  2988. Table:Attrs5=FPAGES="Total Pages":2::::VM=TUpdateStatistics
  2989. Table:Attrs6=OVERFLOW="Overflow Rows":2::::VM=TUpdateStatistics
  2990. Table:Attrs7=REMARKS="Comments":2
  2991. Table:Attrs:R1="Table Space"::::E
  2992. Table:Attrs:R2="Index Space"::::E
  2993. Table:Attrs:R3="Long Space"::::E
  2994. Table:Warning=DataLoss
  2995. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2996. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *]\N`
  2997. Table:Reference:"Indices"=TABSCHEMA=TABSCHEMA,TABNAME=TABNAME
  2998. Table:Reference:"Triggers"=TABSCHEMA=TABSCHEMA,TABNAME=TABNAME
  2999. Table:Reference:"Table Space"=TBSPACE
  3000. Table:Reference:"Index Space"=INDEX_TBSPACE
  3001. Table:Reference:"Long Space"=LONG_TBSPACE
  3002. Table:Text:Get1=CREATE TABLE `N` (`{>Column}*`)
  3003. Table:Text:Get2=`!\N'  DATA CAPTURE ' =DATACAPTURE`
  3004. Table:Text:Get3=`!\N'  IN ' ="Table Space"`
  3005. Table:Text:Get4=`!\N'  INDEX IN ' ="Index Space"`
  3006. Table:Text:Get5=`!\N'  LONG IN ' ="Long Space"`
  3007. Table:Delete:Text=DROP TABLE `O`
  3008.  
  3009. TableSpace:Definition=Root=SYSCAT.TABLESPACES
  3010. TableSpace:Warning=Loss
  3011. TableSpace:EAttrs=Text
  3012. TableSpace:Text:Get1=CREATE `=DATATYPE` TABLESPACE `N\N`
  3013. TableSpace:Text:Get2=MANAGED BY `=TBSPACETYPE`
  3014. TableSpace:Text:Get3=`! ' EXTENTSIZE ' =EXTENTSIZE`
  3015. TableSpace:Text:Get4=`! ' PREFETCHSIZE ' =PREFETCHSIZE`
  3016. TableSpace:Text:Get5=`! ' OVERHEAD ' =OVERHEAD`
  3017. TableSpace:Text:Get6=`! ' TRANSFERRATE ' =TRANSFERRATE`
  3018. TableSpace:Delete:Text=DROP TABLESPACE `O`
  3019.  
  3020. Synonym:Category=Dataset
  3021. Synonym:Definition=Root=SYSCAT.TABLES
  3022. Synonym:Values=A.TYPE = 'A'
  3023. Synonym:Attrs1=BASE_TABSCHEMA="Target Schema"
  3024. Synonym:Attrs2=BASE_TABNAME="Target Object"
  3025. Synonym:Attrs3=REMARKS="Comments":2
  3026. Synonym:Warning=Loss
  3027. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  3028. Synonym:Text:Get1=CREATE ALIAS `N` FOR `' '`
  3029. Synonym:Text:Get2=`! '"' =BASE_TABSCHEMA '".' ``'"' =BASE_TABNAME '"'`
  3030. Synonym:Delete:Text=DROP ALIAS `O`
  3031.  
  3032. View:Category=Dataset
  3033. View:Definition=Root=SYSCAT.TABLES
  3034. View:Values=A.TYPE = 'V'
  3035. View:Objects=T:P:0M:NMDR:"Columns":Column
  3036. View:Attrs=REMARKS="Comments":2
  3037. View:Attrs:T1=SYSCAT.VIEWS.VIEWCHECK=ViewCheck
  3038. View:Attrs:T2=SYSCAT.VIEWS.READONLY=ReadOnly
  3039. View:Attrs:T3=SYSCAT.VIEWS.FUNC_PATH=FunctionPath
  3040. View:Attrs:Q=Text=Memo::"Text"::ER
  3041. View:AttrReference:Text1=SELECT TEXT, SEQNO FROM SYSCAT.VIEWS
  3042. View:AttrReference:Text2=WHERE VIEWSCHEMA=`OQ0` AND VIEWNAME=`OQ1`
  3043. View:AttrReference:Text3=ORDER BY SEQNO
  3044. View:Warning=Loss
  3045. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  3046. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM "owner"."table"
  3047. View:Text:Get=`=Text`
  3048. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  3049. View:Text:NameSet=1=`N`
  3050. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  3051. View:Text:Set=Text=0,*N=2
  3052. View:Delete:Text=DROP VIEW `O`
  3053.  
  3054. Trigger:Category=Executable
  3055. Trigger:Definition=Root=SYSCAT.TRIGGERS
  3056. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  3057. Trigger:AttrReference:Text1=SELECT TEXT FROM SYSCAT.TRIGGERS
  3058. Trigger:AttrReference:Text2=WHERE TRIGSCHEMA=`OQ0` AND TRIGNAME=`OQ1`
  3059. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  3060. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName`
  3061. Trigger:Text:Init2=AFTER INSERT `\N`
  3062. Trigger:Text:Init3=ON `{<}N \N`
  3063. Trigger:Text:Init4=FOR EACH ROW  MODE DB2SQL`\N`
  3064. Trigger:Text:Init5=BEGIN ATOMIC`\N '   <statement>;' \N` END
  3065. Trigger:Text:Get=`=Text`
  3066. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_.*\_ON\_+(\w+)\_.*$
  3067. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  3068. Trigger:Text:NameRE=Text:TRIGGER\_(\_*\w+)
  3069. Trigger:Text:NameSet=1=`N`
  3070. Trigger:Delete:Text=DROP TRIGGER `O`
  3071.  
  3072.