FW: Notification: Inbound Mail Failure

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BF164C.E618885A Content-Type: text/plain; charset="iso-8859-1" vanle ho no longer at this address -----Original Message----- From: HA/TMA Postmaster Sent: Thursday, October 14, 1999 6:21 AM To: HA/TMA Postmaster Subject: Notification: Inbound Mail Failure The following recipients did not receive the attached mail. A NDR was not sent to the originator for the following recipients for one of the following reasons: * The Delivery Status Notification options did not request failure notification, or requested no notification. * The message was of precedence bulk. NDR reasons are listed with each recipient, along with the notification requested for that recipient, or the precedence. <VanLe.Ho@tma.osd.mil> VanLe.Ho@tma.osd.mil MSEXCH:IMS:ORGANIZATION:ha:DDDC025 0 (000C05A6) Unknown Recipient Precedence: bulk The message that caused this notification was: <<RE: Dynamic SQL inside stored procedure>> ------_=_NextPart_000_01BF164C.E618885A Content-Type: message/rfc822 Message-ID: <7u47sv$cjs$1@lola.ctv.es> From: Cecilio Albero <eos@ctv.es> Reply-To: Cecilio Albero <eos@ctv.es> To: informix-list@iiug.org Subject: RE: Dynamic SQL inside stored procedure Date: Thu, 14 Oct 1999 05:33:26 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable You can create a synonym to your table before calling SPL function, and = work with synonym inside the SPL (always the same name): create synonym syn for TBL23; execute procedure xx() drop synonym syn; create synonym syn for TBL24; execute procedure xx() procedure xx() .. select * from syn ... .. end <bharathdvs@my-deja.com> escribi=F3 en el mensaje de noticias 7u2u01$cis$1@nnrp1.deja.com... > Hi! > > We are working on maintaining an existing > application, with an Informix database. > > We have some tables that are created and dropped > at run time: these are NOT temp tables. All > tables have the same column structure, i.e. > TableA, TableB and TableC all have exactly the > same # of columns, with the same names, in the > same order with the same data types. > > We need to fetch some rows from these tables. > > **We do not know the table names until runtime**. > > I was exploring the use of stored procedures in > this scenario. > > Can we pass a tablename across to a stored > procedure and have it target the right table > dynamically? > > If we can use a stored proc, would there be any > performance gains over sending the full SQL from > the client side (ignoring gains from the network)? > > Thanks a lot. > > Regards, > Bharath. > > > Sent via Deja.com http://www.deja.com/ > Before you buy. ------_=_NextPart_000_01BF164C.E618885A--