SPL return help
Posted in 2011
Topics: Stored Procedures & SPL, Data Types & Schema Design
Hello All, IDS 11.50 I have written an SPL which returns a LVARCHAR IF I do NOT give the "RETURNING LVARCHAR AS somename;" then my output header show "expression " and else it prints "somename" Like we can output to '/file' without headings, Is there any way I suppress this "expression" and see only the data returned by the SPL with out any headers? Regards, Vikas
On Mon, Aug 29, 2011 at 22:17, VIKAS HIVARKAR <vikas.hivarkar@gmail.com>wrote: > IDS 11.50 > > I have written an SPL which returns a LVARCHAR > > IF I do NOT give the "RETURNING LVARCHAR AS somename;" then my output > header > show "expression " and else it prints "somename" > > Like we can output to '/file' without headings, Is there any way I suppress > this "expression" and see only the data returned by the SPL without any > headers? > OUTPUT TO "./file" WITHOUT HEADINGS SELECT ... ? -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --90e6ba1eff44aaa64204abb29667