Re: connect && rename && connect
Thanks Radhika, but that doesn't fix the problem.
I don't want to disconnect my current connection and I don't want to
switch to a connection to the server (but I will have to!).
I will report the bug, as soon as I know how to do it.
Thanks Jonathan.
On 5/6/08, Radhika Gadde <radhika.gadde1@gmail.com> wrote:
> can you try by adding the "EXEC SQL disconnect current" before connecting to
> test2
>
> Thanks,
> Radhika.
>
>
> On 5/4/08, Gerardo Santana <gerardo.santana@gmail.com> wrote:
> >
> > Why am I getting an SQLCODE == -425, ISAM error == -107?
> > I haven't found anything in the online documentation about making an
> > implicit connection when renaming a database.
> > onstat -u doesn't reveal any other connection different from anydb.> >
> > $ uname -a> > SunOS since 5.10 Generic_127127-11 sun4u sparc SUNW,Sun-Fire-V440
> >
> > $ esql -V> > IBM Informix CSDK Version 3.00, IBM Informix-ESQL Version 3.00.UC2
> > Software Serial Number AAA#B000000
> >
> > $ onparams -V> > IBM Informix Dynamic Server Version 11.10.UC1 Software Serial
> > Number AAA#B000000
> >
> > $ cat rename_and_connect.ec
> > #include <stdio.h>> >
> > #define psqlcode(msg) do \\
> > { \\
> > printf("%d: %s %d\\n", __LINE__, msg, SQLCODE);
> > fflush(stdout); \\
> > } while(0)
> >
> > int main(void)
> > {
> > EXEC SQL connect to 'anydb'; psqlcode("connected to anydb?");
> > EXEC SQL execute immediate 'rename database test to test2';
> > psqlcode("test renamed to test2?");
> > printf("connname == %s\\n", ifx_getcur_conn_name());
> > EXEC SQL connect to 'test2'; psqlcode("connected to test2?");
> > printf("connname == %s\\n", ifx_getcur_conn_name());
> > }
> >
> > $ esql rename_and_connect.ec -o x && ./x> > 11: connected to anydb? 0
> > 12: test renamed to test2? 0
> > connname == anydb
> > 15: connected to test2? -425
> > connname == anydb
> >
> > _______________________________________________
> > Informix-list mailing list
> > Informix-list@iiug.org
> > http://www.iiug.org/mailman/listinfo/informix-list
> >
>
--
Gerardo Santana