[teiid-issues] [JBoss JIRA] Commented: (TEIID-1092) Request to have Global Variables

Wed May 19 12:31:06 EDT 2010

    [ https://jira.jboss.org/browse/TEIID-1092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12531531#action_12531531 ] 

Steve Hawkins commented on TEIID-1092:
--------------------------------------

Procedures do not have access to session level temp tables.  There is no metadata for session level temp tables at design time.  A workaround along the same lines would be to have a source table designated for global values.  We'd have to investigate what would be appropriate for global or at least session global variables.

> Request to have Global Variables
> --------------------------------
>
>                 Key: TEIID-1092
>                 URL: https://jira.jboss.org/browse/TEIID-1092
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>            Reporter: Debbie Steigner
>            Assignee: Steve Hawkins
>
> Customer is requesting a Global Variable.  They want the variable to persist outside of one procedure to other spawned procedures and subsequent queries. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira