<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE DatabaseProfile SYSTEM "dbvis-defs.dtd" [
<!ENTITY generic-commands SYSTEM "generic-commands.xml">
<!ENTITY generic-view SYSTEM "generic-view.xml">
]>
<!--
Copyright (c) 2004 Onseven Software AB. All Rights Reserved.
-->
<DatabaseProfile
name="sybase-ase"
desc="Profile for Sybase ASE"
version="$Revision: 1.7 $"
date="$Date: 2005/09/21 15:00:07 $">
<!-- =================================================================== -->
<!-- Definition of the commands -->
<!-- =================================================================== -->
<Commands>
&generic-commands;
<Command id="sybase-ase.getObjects">
<SQL>
<![CDATA[
select owner = user_name(uid), name, crdate "Creation Date"
from ${database}.dbo.sysobjects where type = '${type}' order by name
]]>
</SQL>
<Input>
<Column name="database" value=""/>
<Column name="type" value=""/>
</Input>
</Command>
<Command id="sybase-ase.getObjectSource">
<SQL>
<![CDATA[
select text from ${database}.dbo.syscomments c, ${database}.dbo.sysobjects s
where s.id = c.id and s.name = '${name}'
]]>
</SQL>
<Input>
<Column name="database" value=""/>
<Column name="owner" value=""/>
<Column name="name" value=""/>
</Input>
</Command>
<Command id="sybase-ase.getTriggers">
<SQL>
<![CDATA[
use ${database}
select 'name' = object_name(o.instrig),
'insert' 'type', 'owner' = user_name(o.uid), 'table' = object_name(o.id)
from ${database}.dbo.sysobjects o where o.type = 'U' and object_name(instrig) is not null
union
select 'name' = object_name(o.updtrig),
'update' 'type', 'owner' = user_name(o.uid), 'table' = object_name(o.id)
from ${database}.dbo.sysobjects o where o.type = 'U' and object_name(updtrig) is not null
union
select 'name' = object_name(o.deltrig),
'delete' 'type', 'owner' = user_name(o.uid), 'table' = object_name(o.id)
from ${database}.dbo.sysobjects o where o.type = 'U' and object_name(deltrig) is not null
]]>
</SQL>
<Input>
<Column name="database" value=""/>
<Column name="owner" value=""/>
</Input>
</Command>
<Command id="sybase-ase.getTableTriggers">
<SQL>
<![CDATA[
use ${database}
select name = object_name(o.instrig),
'insert' 'type', 'owner' = user_name(o.uid), 'table' = object_name(o.id), sc.text 'source'
from ${database}.dbo.sysobjects o, ${database}.dbo.syscomments sc
where o.instrig = sc.id and o.id = object_id('${name}') and object_name(instrig) is not null
union
select name = object_name(o.updtrig),
'update' 'type', 'owner' = user_name(o.uid), 'table' = object_name(o.id), sc.text 'source'
from ${database}.dbo.sysobjects o, ${database}.dbo.syscomments sc
where o.updtrig = sc.id and o.id = object_id('${name}') and object_name(updtrig) is not null
union
select name = object_name(o.deltrig),
'delete' 'type', 'owner' = user_name(o.uid), 'table' = object_name(o.id), sc.text 'source'
from ${database}.dbo.sysobjects o, ${database}.dbo.syscomments sc
where o.deltrig = sc.id and o.id = object_id('${name}') and object_name(deltrig) is not null
]]>
</SQL>
<Input>
<Column name="database" value=""/>
<Column name="owner" value=""/>
<Column name="name" value=""/>
</Input>
</Command>
<Command id="sybase-ase.getUsers">
<SQL>
<![CDATA[
${database}.dbo.sp_helpuser
]]>
</SQL>
<Input>
<Column name="database" value="${catalog}"/>
</Input>
</Command>
<Command id="sybase-ase.getGroups">
<SQL>
<![CDATA[
${database}.dbo.sp_helpgroup
]]>
</SQL>
<Input>
<Column name="database" value="${catalog}"/>
</Input>
<Output>
<Column id="sybase-ase.getGroups.Group_name" index="1"/>
</Output>
</Command>
<Command id="sybase-ase.getGroupUsers">
<SQL>
<![CDATA[
select a.name from ${database}.dbo.sysusers a, ${database}.dbo.sysusers b
where b.name = '${name}' and a.gid = b.gid and a.uid != a.gid and a.uid != 1
]]>
</SQL>
<Input>
<Column name="database" value="${catalog}"/>
<Column name="name" value="${sybase-ase.getGroups.Group_name}"/>
</Input>
</Command>
<Command id="sybase-ase.getUserTypes">
<SQL>
<![CDATA[
select t.name 'Data Type', p.name 'System Type', b.name 'Creator',
t.allownulls 'Allow Nulls', t.length 'Length', t.prec 'Precision', t.scale 'Scale'
from ${database}.dbo.systypes t, ${database}.dbo.sysusers b, ${database}.dbo.systypes p
where t.uid = b.uid and t.usertype >= 100 and t.type = p.type and p.usertype =
(select min(usertype) from ${database}.dbo.systypes where type = t.type)
]]>
</SQL>
<Input>
<Column name="database" value="${catalog}"/>
</Input>
</Command>
<!-- ================================================================= -->
<!-- DBA related commands requiring certain privileges in the database -->
<!-- ================================================================= -->
<Command id="sybase-ase.getLogins">
<SQL>
<![CDATA[
select name "Name", suid, dbname "Default Database", fullname "Full Name",
language "Default Language", totcpu "CPU Time", totio "I/O Time", pwdate "Password Set"
from master.dbo.syslogins
]]>
</SQL>
<Output>
<Column id="sybase-ase.getLogins.Name" index="1"/>
<Column id="sybase-ase.getLogins.suid" index="2"/>
</Output>
</Command>
<Command id="sybase-ase.getLoginDatabases">
<SQL>
<![CDATA[
select a.name "Name", sum(c.size / 512) "Size (MB)"
from master.dbo.sysdatabases a, master.dbo.syslogins b, master.dbo.sysusages c
where (a.suid = b.suid) and (b.suid = ${suid}) and a.dbid = c.dbid group by a.name
]]>
</SQL>
<Input>
<Column name="suid" value="${sybase-ase.getLogins.suid}"/>
</Input>
</Command>
<Command id="sybase-ase.getLoginRoles">
<SQL>
<![CDATA[
select role_name(lr.srid) "Name", lr.status "Status"
from master.dbo.sysloginroles lr, master.dbo.syslogins l
where lr.suid = l.suid and l.name = '${login}' and lr.status = 1
]]>
</SQL>
<Input>
<Column name="login" value="${sybase-ase.getLogins.Name}"/>
</Input>
</Command>
<Command id="sybase-ase.getServerRoles">
<SQL>
<![CDATA[
select * from master.dbo.syssrvroles
]]>
</SQL>
<Output>
<Column id="sybase-ase.getServerRoles.NAME" index="2"/>
</Output>
</Command>
<Command id="sybase-ase.getRoleLogins">
<SQL>
<![CDATA[
select l.name "Name", lr.status "Status"
from master.dbo.syslogins l, master.dbo.sysloginroles lr
where lr.srid = role_id('${name}') and l.suid = lr.suid and lr.status = 1
]]>
</SQL>
<Input>
<Column name="name" value="${sybase-ase.getServerRoles.NAME}"/>
</Input>
</Command>
<Command id="sybase-ase.getDevices">
<SQL>
<![CDATA[
select a.name "Name", a.phyname "Pysical Name",
(a.high - a.low + 1) / 512 "Size (MB)",
(select (a.high - a.low + 1) / 512 - (sum(size / 512) * (2048 / 2048))
from master.dbo.sysusages
where (vstart <= a.high) and (vstart >= a.low)) "Free (MB)"
from master.dbo.sysdevices a where (a.cntrltype = 0) group by a.name
]]>
</SQL>
<Output>
<Column id="sybase-ase.getDevices.Name" index="1"/>
</Output>
</Command>
<Command id="sybase-ase.getDeviceDatabases">
<SQL>
<![CDATA[
select a.name "Name", sum(b.size) / 512 "Size (MB)",
(select l.name from master.dbo.syslogins l where l.suid = a.suid) "Creator"
from master.dbo.sysdatabases a, master.dbo.sysusages b, master.dbo.sysdevices c
where (a.dbid = b.dbid) and (b.vstart <= c.high) and
(b.vstart >= c.low) and (c.name = '${name}') group by a.name
]]>
</SQL>
<Input>
<Column name="name" value="${sybase-ase.getDevices.Name}"/>
</Input>
</Command>
<Command id="sybase-ase.serverInfo">
<SQL>
<![CDATA[
exec sp_server_info
]]>
</SQL>
</Command>
<Command id="sybase-ase.getRemoteServers">
<SQL>
<![CDATA[
select s.srvid, s.srvname, s.srvnetname, s.srvclass, v.name
from master.dbo.sysservers s, master.dbo.spt_values v
where s.srvclass = v.number and v.type = 'X' and v.name not in ('access_server', 'sds')
order by s.srvname
]]>
</SQL>
</Command>
<Command id="sybase-ase.getCaches">
<SQL>
<![CDATA[
select a.name, a.status, a.value, (select b.value from master.dbo.syscurconfigs b
where b.config = a.config and b.comment = a.name)
from master.dbo.sysconfigures a where parent = 19 and config = parent order by 2
]]>
</SQL>
</Command>
<Command id="sybase-ase.getProcesses">
<SQL>
<![CDATA[
select p.spid, p.program_name, p.cmd, l.name, p.status, p.suid
from master.dbo.sysprocesses p, master.dbo.syslogins l
where p.suid *= l.suid order by 1
]]>
</SQL>
</Command>
<Command id="sybase-ase.getCharSet">
<SQL>
<![CDATA[
select name, description from master.dbo.syscharsets
where id = (select value from master.dbo.syscurconfigs where config = 131) ;
]]>
</SQL>
</Command>
<Command id="sybase-ase.getTransactions">
<SQL>
<![CDATA[
select type = convert(char(11),v3.name), coordinator = convert(char(10), v4.name),
starttime=convert(char(20), starttime), state = convert(char(17),v1.name),
connection = convert(char(9), v2.name), dbid=masterdbid, spid, loid, namelen, xactname
from master.dbo.systransactions ts, master.dbo.spt_values v1,
master.dbo.spt_values v2, master.dbo.spt_values v3, master.dbo.spt_values v4
where ts.state = v1.number and v1.type = 'T1' and ts.connection = v2.number and
v2.type = 'T2' and ts.type = v3.number and v3.type = 'T3'
and ts.coordinator = v4.number and v4.type = 'T4'
]]>
</SQL>
</Command>
<Command id="sybase-ase.getLocks">
<SQL>
<![CDATA[
select fid, spid, loid, locktype = v1.name, table_id = id, page, row,
dbname = db_name(dbid), class, context = v2.name
from master.dbo.syslocks l, master.dbo.spt_values v1, master.dbo.spt_values v2
where l.type = v1.number and v1.type = 'L' and (l.context + 2049) = v2.number and v2.type = 'L2'
]]>
</SQL>
</Command>
</Commands>
<!-- =================================================================== -->
<!-- Definition of the database objects tree structure -->
<!-- This definition do not list catalogs as these are not supported -->
<!-- by Oracle. -->
<!-- =================================================================== -->
<ObjectsTreeDef id="sybase-ase">
<GroupNode type="Databases" label="Databases">
<DataNode type="Catalog" label="${getCatalogs.TABLE_CAT}"
is-empty-output="continue">
<SetVar name="catalog" value="${getCatalogs.TABLE_CAT}"/>
<Command idref="getCatalogs">
<Filter type="Catalog" name="Catalog">
<Column index="TABLE_CAT" name="Name"/>
</Filter>
</Command>
<GroupNode type="Tables" label="Tables">
<DataNode type="Table" label="${getTables.TABLE_SCHEM}.${getTables.TABLE_NAME}" isLeaf="true">
<SetVar name="schema" value="${getTables.TABLE_SCHEM}"/>
<SetVar name="table" value="${getTables.TABLE_NAME}"/>
<SetVar name="rowcount" value="true"/>
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="tableType" value="TABLE"/>
</Input>
<Filter type="Table" name="Table">
<Column index="TABLE_NAME" name="Name"/>
</Filter>
</Command>
</DataNode>
</GroupNode>
<GroupNode type="SystemTables" label="System Tables">
<DataNode type="SystemTable" label="${getTables.TABLE_SCHEM}.${getTables.TABLE_NAME}" isLeaf="true">
<SetVar name="schema" value="${getTables.TABLE_SCHEM}"/>
<SetVar name="table" value="${getTables.TABLE_NAME}"/>
<SetVar name="rowcount" value="true"/>
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="tableType" value="SYSTEM TABLE"/>
</Input>
<Filter type="SystemTable" name="System Table">
<Column index="TABLE_NAME" name="Name"/>
</Filter>
</Command>
</DataNode>
</GroupNode>
<GroupNode type="Views" label="Views">
<DataNode type="View" label="${getTables.TABLE_SCHEM}.${getTables.TABLE_NAME}" isLeaf="true">
<SetVar name="schema" value="${getTables.TABLE_SCHEM}"/>
<SetVar name="table" value="${getTables.TABLE_NAME}"/>
<SetVar name="rowcount" value="true"/>
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="tableType" value="VIEW"/>
</Input>
<Filter type="View" name="View Table">
<Column index="TABLE_NAME" name="Name"/>
</Filter>
</Command>
</DataNode>
</GroupNode>
<GroupNode type="Users" label="Users" isLeaf="true"/>
<GroupNode type="Groups" label="Groups">
<DataNode type="Group" label="${sybase-ase.getGroups.Group_name}" isLeaf="true">
<Command idref="sybase-ase.getGroups"/>
</DataNode>
</GroupNode>
<GroupNode type="Types" label="User Defined Data Types" isLeaf="true"/>
<GroupNode type="Triggers" label="Triggers">
<DataNode type="Trigger" label="${sybase-ase.getTriggers.name} (${sybase-ase.getTriggers.owner}.${sybase-ase.getTriggers.table})" isLeaf="true">
<SetVar name="schemaName" value="${sybase-ase.getTriggers.owner}"/>
<Command idref="sybase-ase.getTriggers">
<Input>
<Column name="database" value="${catalog}"/>
</Input>
</Command>
</DataNode>
</GroupNode>
<GroupNode type="Procedures" label="Stored Procedures">
<DataNode type="Procedure" label="${sybase-ase.getObjects.owner}.${sybase-ase.getObjects.name}" isLeaf="true">
<SetVar name="schemaName" value="${sybase-ase.getObjects.owner}"/>
<SetVar name="procedureName" value="${sybase-ase.getObjects.name}"/>
<Command idref="sybase-ase.getObjects">
<Input>
<Column name="database" value="${catalog}"/>
<Column name="type" value="P"/>
</Input>
</Command>
</DataNode>
</GroupNode>
</DataNode>
</GroupNode>
<!-- ================================================================= -->
<!-- DBA Nodes -->
<!-- ================================================================= -->
<GroupNode type="DBA" label="DBA Views">
<GroupNode type="ServerInfo" label="Server Info" isLeaf="true"/>
<GroupNode type="Logins" label="Logins">
<DataNode type="Login" label="${sybase-ase.getLogins.Name}" isLeaf="true">
<Command idref="sybase-ase.getLogins"/>
</DataNode>
</GroupNode>
<GroupNode type="Devices" label="Database Devices">
<DataNode type="Device" label="${sybase-ase.getDevices.Name}" isLeaf="true">
<Command idref="sybase-ase.getDevices"/>
</DataNode>
</GroupNode>
<GroupNode type="RemoteServers" label="Remote Servers" isLeaf="true"/>
<GroupNode type="Processes" label="Processes" isLeaf="true"/>
<GroupNode type="ServerRoles" label="Roles">
<DataNode type="ServerRole" label="${sybase-ase.getServerRoles.NAME}" isLeaf="true">
<Command idref="sybase-ase.getServerRoles"/>
</DataNode>
</GroupNode>
<GroupNode type="Transactions" label="Transactions" isLeaf="true"/>
<GroupNode type="Locks" label="Locks" isLeaf="true"/>
</GroupNode>
</ObjectsTreeDef>
<!-- =================================================================== -->
<!-- Definition of the database objects views -->
<!-- =================================================================== -->
<!-- Include the generic-view -->
&generic-view;
<ObjectsViewDef id="sybase-ase" extends="generic">
<ObjectView type="Catalog">
<!-- Drop all views since these are available for type="Tables" -->
<DataView type="Tables" action="drop"/>
<DataView type="References" action="drop"/>
</ObjectView>
<ObjectView type="Tables">
<DataView type="Tables" label="Tables" viewer="grid">
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="tableType" value="TABLE"/>
</Input>
</Command>
<Action name="Script: SELECT ALL" template="SelectAllCommand">
<Map from="TABLE_SCHEM" to="schema"/>
<Map from="TABLE_NAME" to="table"/>
</Action>
<Action name="Script: DROP TABLE" template="DropTableCommand">
<Map from="TABLE_SCHEM" to="schema"/>
<Map from="TABLE_NAME" to="table"/>
</Action>
</DataView>
<DataView type="References" label="References" viewer="tables-refs">
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="schemaName" value="${getSchemas.TABLE_SCHEM}"/>
<Column name="tableName" value="%"/>
<Column name="tableType" value="TABLE"/>
</Input>
</Command>
</DataView>
</ObjectView>
<!-- Sub def of the Table type view -->
<ObjectView type="Table">
<!-- Add the Trigger view -->
<DataView type="Trigger" label="Triggers" viewer="form">
<Command idref="sybase-ase.getTableTriggers">
<Input>
<Column name="database" value="${getTables.TABLE_CAT}"/>
<Column name="owner" value="${getTables.TABLE_SCHEM}"/>
<Column name="name" value="${getTables.TABLE_NAME}"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="SystemTables">
<DataView type="SystemTables" label="SystemTables" viewer="grid">
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="tableType" value="SYSTEM TABLE"/>
</Input>
</Command>
<Action name="Script: SELECT ALL" template="SelectAllCommand">
<Map from="TABLE_SCHEM" to="schema"/>
<Map from="TABLE_NAME" to="table"/>
</Action>
</DataView>
<DataView type="References" label="References" viewer="tables-refs">
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="schemaName" value="${getSchemas.TABLE_SCHEM}"/>
<Column name="tableName" value="%"/>
<Column name="tableType" value="SYSTEM TABLE"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="SystemTable">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Columns" label="Columns" viewer="grid">
<Command idref="getColumns">
<Input>
<Column name="catalogName" value="${getTables.TABLE_CAT}"/>
<Column name="schemaName" value="${getTables.TABLE_SCHEM}"/>
<Column name="tableName" value="${getTables.TABLE_NAME}"/>
</Input>
</Command>
</DataView>
<DataView type="Data" label="Data" viewer="table-data">
<Message>
<![CDATA[
<html>
Note: This is a system table. Do not edit unless you are really sure what you're
doing!
</html>
]]>
</Message>
</DataView>
<DataView type="RowCount" label="Row Count" viewer="table-rowcount"/>
</ObjectView>
<ObjectView type="Views">
<DataView type="Views" label="Views" viewer="grid">
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="tableType" value="VIEW"/>
</Input>
</Command>
<Action name="Script: SELECT ALL" template="SelectAllCommand">
<Map from="TABLE_SCHEM" to="schema"/>
<Map from="TABLE_NAME" to="table"/>
</Action>
</DataView>
<DataView type="References" label="References" viewer="tables-refs">
<Command idref="getTables">
<Input>
<Column name="catalogName" value="${getCatalogs.TABLE_CAT}"/>
<Column name="schemaName" value="${getSchemas.TABLE_SCHEM}"/>
<Column name="tableName" value="%"/>
<Column name="tableType" value="VIEW"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="View">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Columns" label="Columns" viewer="grid">
<Command idref="getColumns">
<Input>
<Column name="catalogName" value="${getTables.TABLE_CAT}"/>
<Column name="schemaName" value="${getTables.TABLE_SCHEM}"/>
<Column name="tableName" value="${getTables.TABLE_NAME}"/>
</Input>
</Command>
</DataView>
<DataView type="Data" label="Data" viewer="table-data"/>
<DataView type="RowCount" label="Row Count" viewer="table-rowcount"/>
<DataView type="Index" label="Indexes" viewer="grid">
<Command idref="getIndexes"/>
</DataView>
<DataView type="Source" label="Source" viewer="text">
<Command idref="sybase-ase.getObjectSource">
<Input>
<Column name="database" value="${catalog}"/>
<Column name="owner" value="${getTables.TABLE_SCHEM}"/>
<Column name="name" value="${getTables.TABLE_NAME}"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="Users">
<DataView type="Users" label="Users" viewer="grid">
<Command idref="sybase-ase.getUsers"/>
</DataView>
</ObjectView>
<ObjectView type="Groups">
<DataView type="Groups" label="Groups" viewer="grid">
<Command idref="sybase-ase.getGroups"/>
</DataView>
</ObjectView>
<ObjectView type="Group">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Users" label="Users" viewer="grid">
<Command idref="sybase-ase.getGroupUsers"/>
</DataView>
</ObjectView>
<ObjectView type="Triggers">
<DataView type="Triggers" label="Triggers" viewer="grid">
<Command idref="sybase-ase.getTriggers">
<Input>
<Column name="database" value="${catalog}"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="Trigger">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Source" label="Source" viewer="text">
<Command idref="sybase-ase.getObjectSource">
<Input>
<Column name="database" value="${catalog}"/>
<Column name="owner" value="${sybase-ase.getTriggers.owner}"/>
<Column name="name" value="${sybase-ase.getTriggers.name}"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="Types">
<DataView type="Types" label="User Defined Data Types" viewer="grid">
<Command idref="sybase-ase.getUserTypes"/>
</DataView>
</ObjectView>
<ObjectView type="Procedures">
<DataView type="Procedures" label="Procedures" viewer="grid">
<Command idref="sybase-ase.getObjects">
<Input>
<Column name="database" value="${catalog}"/>
<Column name="type" value="P"/>
</Input>
</Command>
</DataView>
</ObjectView>
<ObjectView type="Procedure">
<DataView type="Columns" action="drop"/>
<DataView type="Interface" label="Interface" viewer="form">
<Command idref="getProcedureColumns">
<Input>
<Column name="catalogName" value="${catalog}"/>
<Column name="schemaName" value="${sybase-ase.getObjects.owner}"/>
<Column name="procedureName" value="${sybase-ase.getObjects.name}"/>
</Input>
</Command>
</DataView>
<DataView type="Source" label="Source" viewer="text">
<Command idref="sybase-ase.getObjectSource">
<Input>
<Column name="database" value="${catalog}"/>
<Column name="owner" value="${sybase-ase.getObjects.owner}"/>
<Column name="name" value="${sybase-ase.getObjects.name}"/>
</Input>
</Command>
</DataView>
</ObjectView>
<!-- ================================================================= -->
<!-- DBA Views -->
<!-- ================================================================= -->
<ObjectView type="ServerInfo">
<DataView type="Info" label="Server Info" viewer="grid">
<Command idref="sybase-ase.serverInfo"/>
</DataView>
<DataView type="Info" label="Character Set" viewer="grid">
<Command idref="sybase-ase.getCharSet"/>
</DataView>
</ObjectView>
<ObjectView type="Logins">
<DataView type="Logins" label="Logins" viewer="grid">
<Command idref="sybase-ase.getLogins"/>
</DataView>
</ObjectView>
<ObjectView type="Login">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Databases" label="Databases" viewer="grid">
<Command idref="sybase-ase.getLoginDatabases"/>
</DataView>
<DataView type="Roles" label="Roles" viewer="grid">
<Command idref="sybase-ase.getLoginRoles"/>
</DataView>
</ObjectView>
<ObjectView type="Devices">
<DataView type="Devices" label="Database Devices" viewer="grid">
<Command idref="sybase-ase.getDevices"/>
</DataView>
</ObjectView>
<ObjectView type="Device">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Databases" label="Databases" viewer="grid">
<Command idref="sybase-ase.getDeviceDatabases"/>
</DataView>
</ObjectView>
<ObjectView type="RemoteServers">
<DataView type="RemoteServers" label="Remote Servers" viewer="grid">
<Command idref="sybase-ase.getRemoteServers"/>
</DataView>
</ObjectView>
<ObjectView type="ServerRoles">
<DataView type="ServerRoles" label="Roles" viewer="grid">
<Command idref="sybase-ase.getServerRoles"/>
</DataView>
</ObjectView>
<ObjectView type="ServerRole">
<DataView type="Info" label="Info" viewer="node-form"/>
<DataView type="Logins" label="Logins" viewer="grid">
<Command idref="sybase-ase.getRoleLogins"/>
</DataView>
</ObjectView>
<ObjectView type="Processes">
<DataView type="Processes" label="Processes" viewer="grid">
<Command idref="sybase-ase.getProcesses"/>
</DataView>
</ObjectView>
<ObjectView type="Transactions">
<DataView type="Transactions" label="Transactions" viewer="grid">
<Command idref="sybase-ase.getTransactions"/>
</DataView>
</ObjectView>
<ObjectView type="Locks">
<DataView type="Locks" label="Locks" viewer="grid">
<Command idref="sybase-ase.getLocks"/>
</DataView>
</ObjectView>
</ObjectsViewDef>
</DatabaseProfile>
|
