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 |