SEO

#1 (**permalink**) 04-08-2008, 03:23 PM

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

#2 (**permalink**) 04-08-2008, 03:23 PM

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

--
Arki

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Discern T-SQL and WATCOM in ASA7