Re: AW: SQL view *pointer to a BLOB

[Jack Tucky <jacktucky@xxxxxxxxx>]

Hi sorry if I missed a reply, but I can't get Interactive SQL to show me
the file name either.  Is there a function I need to use?

Thanks, Jack

On Tue, Nov 18, 2014 at 9:22 AM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

> I did that and saw hex data.  Do I need char()?
>
>
>
> > On Nov 18, 2014, at 2:05 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
> wrote:
> > Use IBM i Navigator's Run an SQL Script instead of STRSQL.
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training
> them
> > and keeping them!"
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
> Jack
> > Tucky
> > Gesendet: Tuesday, 18.11 2014 02:06
> > An: 'Midrange Systems Technical Discussion'
> > Betreff: SQL view *pointer to a BLOB
> >
> > I recall viewing the location for a BLOB in interactive SQL using CAST or
> > CHAR or some function.
> >
> >
> >
> > Lost my notes and google not helping.
> >
> >
> >
> > I thought it was select char(blob) from blobtable but that tells me
> argument
> > 1 not valid.
> >
> >
> >
> > Thanks, Jack
> >
> >
> >
> >
> >
> >
> >
> > ---
> > This email is free from viruses and malware because avast! Antivirus
> > protection is active.
> > http://www.avast.com
> > --
> > 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.