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