| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 13 Retrieving information with System Procedures |
|
| sp_capabilities |
Returns the SQL capabilities of an access service.
sp_capabilities
The result set contains information that allows applications to successfully interact with an access service during normal query processing.
This procedure is used by ASE/CIS to determine the capabilities of a data source such as DirectConnect, enabling ASE/CIS to send only SQL that can be handled by DirectConnect.
The following table shows the result set:
Column | Datatype | Description |
ID | int | Capability ID |
CAPABILITY_NAME | char(30) | Capability name |
VALUE | int | Capability value |
DESCRIPTION | char(128) | Capability description |
The following table shows the ID and values for several access service functional capabilities:
ID | Capability | Value Description |
101 | SQL syntax | 1=SybaseT-SQL supported 2=DB2 SQL supported |
102 | Join handling | 0=Unsupported 1=No outer join supported 2=T-SQL support 3=Oracle supported |
103 | Aggregate handling | 0=Unsupported 1=ANSI supported 2=All functions |
104 | AND predicates | 0=Unsupported 1=Supported |
105 | OR predicates | 0=Unsupported 1=Supported |
106 | LIKE predicates | 0=Unsupported 1=ANSI-style supported 2=T-SQL supported |
107 | Bulk insert handling | 0=Unsupported 1=Supported |
108 | Text and image handling | 0=Unsupported 1=Text, no textptr 2=Text and textptr |
109 | Transaction handling | 0=Unsupported 1=Local supported 2=Two-phase commit supported |
110 | Text pattern handling | 0=Unsupported 1=Pattern (text) supported |
111 | order by | 0=Unsupported 1=Supported |
112 | group by | 0=Unsupported 1=ANSI supported 2=T-SQL supported |
113 | Net password encryption | 0=Unsupported 1=Supported |
114 | Object case sensitivity | 0=Case insensitive 1=Case sensitive |
115 | distinct | 0=Unsupported 1=Supported |
116 | Wild card escape | 0=Unsupported Non-zero=Escape_char(s) |
117 | Union handling | 0=Unsupported 1=Supported |
118 | String functions | 0=Unsupported 1=Substring supported 2=Oracle subset supported 3=T-SQL supported |
119 | Expression handling | 0=Unsupported 1=ANSI supported 2=T-SQL supported |
120 | Character truncation | 0=Fixed length character parameters may contain trailing blanks 1=Fixed length character parameters will not contain trailing blanks |
121 | Language events | 0=Unsupported 1=T-SQL DML without datetime in the where clause supported 2=T-SQL DML supported |
122 | Date functions | 0=Unsupported 1=T-SQL date functions supported |
123 | Math functions | 0=Unsupported 1=Oracle functions supported 2=T-SQL math functions supported |
124 | T-SQL convert functions | 0=Unsupported 1=Supported |
125 | T-SQL delete/update | 0=Sybase extensions not supported 1=Sybase extensions supported |
126 | Insert/select handling | 0=Unsupported 1=Supported |
127 | Subquery handling | 0=Unsupported 1=Supported |
128 | IN/NOT IN support | 0=Unsupported 1=Supported |
129 | CASE support | 0=Unsupported 1=Supported |
|
|