Chapter 3 DBMS Reference Guide
You can define values for the following common entries for the Procedure object in the DBMS definition.
| Entry | Example (Sybase Adaptive Server Anywhere 6) |
|---|---|
| Enable | Enable = Yes |
| Maxlen | Maxlen = 128 |
| Create |
create procedure %PROC%[(%PROCPRMS%)] %TRGDEFN% |
| Drop |
if exists(select 1 from sys.sysprocedure where proc_name = '%PROC%') then drop procedure %PROC% end if |
| SqlListQuery |
{OWNER, @OBJTCODE}
SELECT U.USER_NAME, P.PROC_NAME
FROM SYSUSERPERMS U,SYSPROCEDURE P
WHERE [%SCHEMA% ? U.USER_NAME='%SCHEMA%' AND] P.CREATOR=U.USER_ID
|
| SqlAttrQuery |
{OWNER, @OBJTCODE, SCRIPT, @OBJTLABL}
SELECT U.USER_NAME, P.PROC_NAME, P.PROC_DEFN, P.REMARKS
FROM SYSUSERPERMS U,SYSPROCEDURE P
WHERE [%SCHEMA% ? U.USER_NAME='%SCHEMA%' AND] P.CREATOR=U.USER_ID
ORDER BY U.USER_NAME
|
| ModifiableAttributes | List of extended attributes that will be taken into account in the merge dialog box during database synchronization |
| ReversedStatements | List of statements that will be reverse engineered |
For a description of each of the common object entries, see section "Common object entries".
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |