Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 
Support > Technical Documents > Document Types > Technote > Supporting Global Temporary Tables for Sybase Adap...  
RSS Feed
 
 
 

Supporting Global Temporary Tables for Sybase Adaptive Server Anywhere 6 using PowerDesigner 7 or 8


In Sybase ASA 6, support for Global Temporary Tables was added. PowerDesigner does not have built in support for this feature, but it can be implemented via changes in the XDB file and the use of Extended Attributes.  For an overview of how to use PowerDesigner Extended Attributes see one of the following Technical Documents.

Tapping the power of PowerDesigner 7.x Extended Attributes

Tapping the power of PowerDesigner 8.0 Extended Attributes

1) Create a new DBMS file
    - Select Tools>Resources>DBMS
    - Select the "new" icon to create a new DBMS file and give it a name such as Sybase AS Anywhere 6 Extended
    - Select Sybase AS Anywhere 6 in the "Copy from" drop down listbox
    - Click OK

2) In the new XDB add a new Extended Attribute Type
    - Expand the Extended Attributes node
    - Right-click on Extended Attributes>Types and select New> Extended Attribute Types
    - Expand Types and select the newly created Extended Attribute Type
    - Rename the Type to True/False
    - Add two values True and False and set the default to False
3) Add a new Extended Attribute
    - Right-click on Extended Attributes>Objects, select Add Items and select Table
    - Right-click on Extended Attributes>Objects>Table and select New>Extended Attribute
    - Expand Table and select the newly created Extended Attribute
    - Rename the Extended Attribute to GlobalTemp
    - Under Data Type, select True/False from the drop down listbox.
    - Select False as the Default Value
NOTE: The Extended Attribute name will be used as a variable in the Create Table section.  This variable name is case sensitive.

4) Modify the Create Table syntax
    The following syntax must be added to the Create Table item:
           [%variable name%=True? global temporary]
     In this example, the variable name = GlobalTemp

    - Select the Create Item under Script>Objects>Table
    - In the Value block, insert [%GlobalTemp%=True? global temporary] between create and table.

Sample code for Create Item:

create [%GlobalTemp%=True? global temporary] table [%QUALIFIER%]%TABLE%
(
    %TABLDEFN%
)
[%OPTIONS%]

5) Click OK
6) Save the new XDB file in the \\program files\PowerDesigner 7\DBMS directory using a name like sqlany6gt.xdb

To implement the GlobalTemp extended attribute
1) Change the current DBMS to Sybase AS Anywhere 6 Extended
2) Open the Table properties and select the Extended Attributes tab
3) Select the GlobalTemp extended attribute and change the Value to True

4) Click OK to apply the changes
5) Open the Table properties and select preview
 
 


 

Related Links

DOCUMENT ATTRIBUTES
Last Revised: Jun 10, 2001
Product: PowerDesigner
Hardware Platform: ANY, Windows x86
Technical Topics: Data Modeling
  
Business or Technical: Business, Technical
Content Id: 1012253
Infotype: Technote
 
 
 

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics