Subject | Re: Problem with reserved words and going from IB5.6 to 6 |
---|---|
Author | john@equatorIT.com |
Post date | 2001-11-08T15:36:51Z |
Sorry for my ignorance, but I can find no information about what
switches / options I should use to achieve this with gpre.
Thanks for your time Ann,
John Newcombe
john@...
switches / options I should use to achieve this with gpre.
Thanks for your time Ann,
John Newcombe
john@...
--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> At 09:13 PM 11/7/2001 +0000, john@e... wrote:
>
> >I now find one of my customers has updated to IB6 before updating
the
> >procedures. The restore worked ok, but now I cannot drop the
> >procedures with the reserved word (name).
>
> Probably the easiest thing is to regress the database to 5.6. To
> do that, find your V5.6 gpre and use it to backup the database -
> it will run through the V6 engine just fine. Then restore that
> backup on a system that has V5.6 installed, replace the procedures
> and move the database back to V6.
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.