Re: QSQPTABL usage as a 1-record table for SQL functions

[Dan <dan27649@xxxxxxxxx>]

Forgot about that one.  But it's as well documented as QSQPTABL, which is to
say, not at all.  The name seems to imply its purpose is for one such as I
am looking to use it.

- Dan

On Fri, Feb 19, 2010 at 1:29 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

> What about SYSDUMMY1 in SYSIBM? Is always there. Just a dummy table for
> query.
>
> On Fri, Feb 19, 2010 at 11:06 AM, Dan <dan27649@xxxxxxxxx> wrote:
>
> > I am looking at using an SQL function on a working field that is not in a
> > table.  I've found some references in the archive about using QSQPTABL as
> > the from-table to accomplish this.
> >
> > Because I am looking to use this in a production application, I am trying
> > to
> > determine how reliable it is for me to assume that:
> >  1) the QSQPTABL will always be available, and
> >  2) it will always have ONLY one record.
> >
> > I searched for QSQPTABL in the v5r4 InfoCenter, and came up with zero
> > results.  When I searched using the "global" search box in InfoCenter,
> the
> > results were PSP (Preventive Service Planning) notices or PTF cover
> letters
> > that use QSQPTABL in example code to demonstrate how an SQL function is
> > used, with no explanation of what QSQPTABL is or why it is used.  Of
> > course,
> > the implicit reason is that it is presumed to always exist on every
> system
> > and always has one record.
> >
> > And what a weird table!  One record, with one field, a 4-byte binary
> having
> > a value of 1.  There's no description on the file object.
> >
> > Is this table documented by IBM anywhere that indicates its purpose?
> >
> > TIA,
> > Dan
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.