Re: AW: SQL view *pointer to a BLOB

[Jack Tucky <jacktucky@xxxxxxxxx>]

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.