Using variable as table name in… – Informix Archive

Paul Watson — Wed, 31 Jan 2001 09:28:21 -0000 — source: Informix-list mailing list archive (1991-1998)

Download Paul Browns Dynamic-SPL bladelet from www.iiug.org (won't allow you to drop dynamically named tables though) This should probably be in the FAQ?? > -----Original Message----- > From: Andrew Hamm [mailto:ahamm@sanderson.net.au] > Sent: Wednesday, January 31, 2001 3:35 AM > To: informix-list@iiug.org > Subject: Re: Using variable as table name in a stored procedure ? > > > Jerzy Tomasik wrote in message <3A7774FF.5ADE4AC5@ti.com>... > >Is there a way to pass and use a table name as a variable in a stored > >procedure? > > Not in ordinary stored procedures - ie the ones from engines > 5.XX to 7.XX > > I hear people mumbling about UDR's in the 9.XX or 2000 engines... > > >

↪ replying to Paul Watson

Jerzy Tomasik — Wed, 31 Jan 2001 11:39:13 -0800 — source: Informix-list mailing list archive (1991-1998)

Thanks for the info. I'll give it a try. Jerzy Paul Watson wrote: > Download Paul Browns Dynamic-SPL bladelet from www.iiug.org (won't allow you > > to drop dynamically named tables though) > > This should probably be in the FAQ?? > > > -----Original Message----- > > From: Andrew Hamm [mailto:ahamm@sanderson.net.au] > > Sent: Wednesday, January 31, 2001 3:35 AM > > To: informix-list@iiug.org > > Subject: Re: Using variable as table name in a stored procedure ? > > > > > > Jerzy Tomasik wrote in message <3A7774FF.5ADE4AC5@ti.com>... > > >Is there a way to pass and use a table name as a variable in a stored > > >procedure? > > > > Not in ordinary stored procedures - ie the ones from engines > > 5.XX to 7.XX > > > > I hear people mumbling about UDR's in the 9.XX or 2000 engines... > > > > > >

↪ replying to Paul Watson

Jerzy Tomasik — Wed, 31 Jan 2001 11:40:14 -0800 — source: Informix-list mailing list archive (1991-1998)

Thanks for the info. I'll give it a try. Jerzy Paul Watson wrote: > Download Paul Browns Dynamic-SPL bladelet from www.iiug.org (won't allow you > > to drop dynamically named tables though) > > This should probably be in the FAQ?? > > > -----Original Message----- > > From: Andrew Hamm [mailto:ahamm@sanderson.net.au] > > Sent: Wednesday, January 31, 2001 3:35 AM > > To: informix-list@iiug.org > > Subject: Re: Using variable as table name in a stored procedure ? > > > > > > Jerzy Tomasik wrote in message <3A7774FF.5ADE4AC5@ti.com>... > > >Is there a way to pass and use a table name as a variable in a stored > > >procedure? > > > > Not in ordinary stored procedures - ie the ones from engines > > 5.XX to 7.XX > > > > I hear people mumbling about UDR's in the 9.XX or 2000 engines... > > > > > >

RE: Using variable as table name in a stored procedure ?

Your privacy choices