Hi, just a practical question: how do you prefer to edit your 
stored procedures? I mean: in sql server and oracle I used
to edit them right there within the native admin program,
in this case SQL Studio, but here I see some inconveniences: 

1. The text of the stored procedure is not kept as 
   entered but instead is translated to uppercase

2. I have to manually drop the procedure before I save the
   changes and there 's no way to have a piece of SQL 
   that says "if exists drop it and then create it"

So, if I want to preserve the original text (all uppercase
is just awful), I have to keep my own copies in plain text.
This is not so bad, as I can also have versioning, CVS, etc.,
but ... 

So, what is the prefered method ? Also, SQL Studio is just for
Win32 clients. Any consensus on how to do it in unix ?

Regards, 

Martin






_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to