RE: Option to have sql in SPL start returning data immediately ...

Posted in 2013

Plugge, Joe R. — Fri, 7 Jun 2013 08:10:10 -0500 — source: Usenet: comp.databases.informix

Thanks John ... I knew it was out there, just could not remember what the actual command was .. Joe From: John Miller iii [mailto:miller3@us.ibm.com] Sent: Friday, June 07, 2013 2:53 AM To: Plugge, Joe R. Cc: informix-list@iiug.org Subject: Option to have sql in SPL start returning data immediately ... Set optimization first rows will tell the optimizer to avoid using blocking operations and use inline operators. John F. Miller III -----informix-list-bounces@iiug.org<mailto:-----informix-list-bounces@iiug.org> wrote: ----- >To: "informix-list@iiug.org<mailto:informix-list@iiug.org>" <informix-list@iiug.org<mailto:informix-list@iiug.org>> >From: "Plugge, Joe R." >Sent by: informix-list-bounces@iiug.org<mailto:informix-list-bounces@iiug.org> >Date: 06/06/2013 11:36PM >Subject: Option to have sql in SPL start returning data immediately >... > >I cannot remember the command that tells Informix to start returning >data immediately within a stored procedure. It tells the procedure >to start returning rows right away ... anybody out there know what I >am referring to? Joe >_______________________________________________ Informix-list mailing >list Informix-list@iiug.org<mailto:Informix-list@iiug.org> >http://www.iiug.org/mailman/listinfo/informix-list