SybaseASE and SybaseIQ - SQL script to get information about instance and configuration

Hello, I would need an SQL script that returns information about Sybase instance configuration/settings ASE and IQ. 1- The script should return all the data in a single final select. This is usually achieved by using a session temporary table which needs to be dropped at the end of the script. 2- I would then need the individual all SQL statements used to collect the data. 3 - What are the permissions required to execute the provided script. Provide it in an SQL script Note: I will for the moment run the script with the max priviledged user 'sa' I've done this for SQL Server however know nothing about Sybase, so if I missed certain information, please do add it. Here is the list of properties I would need. Please note that it must be pure SQL, I cannot execute os commands. If something like xp_shell is already configured and available to the user executing the script then ok. Properties =============== Host: Hostname: Server: Host name on whihc Sybase is installed/running Build Description: description of current build (might not apply to Sybase) Build number: patchset level ro build number (might not apply to Sybase) Product Level: what is the product level Instnace Collation: Collation name Software Path: Where is the sybase software installed --> Full path Adhoc: is the instance optimzed for (might not apply to Sybase) Startup time: when was the instance started Uptime: how long is the Instance Up Mirror Server: is thsi instance mirrored to another (might not apply to Sybase) Timezone: timzone of the Instance VIP/VSN address: what is the IP this instance is responding on. This differs from host IP when part of a cluster Dynamic Ports: configured Yes or No ? (might not apply to Sybase) Erro Log Location: Full path to Error Log Default Instance: Is this is default instance or a named instance (might not apply to Sybase) Instance Name: name of the sybase Instance Global name: What is the global name of the Instnace. If cluster the VSN name is different from instance name Memory : Max Memory Configuration Edition: Express, Standard, Enterprise etc Version: 9.0, 10.0, .... 16.0 etc Instance Type: Standalone, Standby, Cluster etc Sybase Type: is this SybaseASE or SybaseIQ etc .. Cluster: is the instance part of a cluster Backup Compression: is backup compression turned on/configured (might not apply to Sybase) Optimal Mode: is optimization turned on/configured configured (might not apply to Sybase) All features turned on/off and the ports associated Databases: list all of the databases attached to instance --> database name --> database type (user defined or system aka master database) Datafiles: Get all the files This is a rush job and a solid DBA shoudl already have this. Thanks in advance. Good bidding. JS@INTM