dbTalk Databases Forums  

Discern T-SQL and WATCOM in ASA7

comp.databases.sybase comp.databases.sybase


Discuss Discern T-SQL and WATCOM in ASA7 in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Arki
 
Posts: n/a

Default Discern T-SQL and WATCOM in ASA7 - 04-07-2004 , 04:02 AM






Hallo,
I unload stored procedures to file (I do this using table SYS.SYSPROCEDURE),
but I have to create two separated files for procedures created in T-SQL and
in WATCOM.
How can I check which procedures are created in which dialect?
I tried to do this by check body of procedures e.g. by occurrence mark ";"
which isn't use in T-SQL as command separator, but it can be (and is) use
in strings in procedures body.
Is any pleace in system tables (or view) where this information is stored?

Thanks.

--
Arki



Reply With Quote
  #2  
Old   
Arki
 
Posts: n/a

Default Re: Discern T-SQL and WATCOM in ASA7 - 04-09-2004 , 02:49 AM







I found:
select sqldialect(proc_defn) from sys.sysprocedur

--
Arki



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.