Re: SQL Blob CCSID

....a BLOB contains binary data so it makes no sense to have a CCSID.

Tim

Get Outlook for Android<https://aka.ms/ghei36>

________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Art Tostaine, Jr. <atostaine@xxxxxxxxx>
Sent: Thursday, 20 February 2020, 20:23
To: Midrange Systems Technical Discussion
Subject: Re: SQL Blob CCSID

Sorry here is my SQL D BLOB s SQLTYPE(BLOB_FILE) EXEC SQL Declare C1 Cursor for Select iimage from images where fid = :ppMid and IIMAGE_F IS NOT NULL; EXEC SQL Fetch Next from C1 into :blob; On Thu, Feb 20, 2020 at 3:16 PM Art Tostaine, Jr. wrote: > Using SQL to retrieve a JPG to a STMF. How do I specify the CCSID? I'm > setting these variables: > > BLOB_NAME = filepath > blob_nl = %len(filepath) > blob_fo =SQFOVR > > I'm googling trying to figure this out. Thank you. > -- > Art Tostaine > -- Art Tostaine -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7Cc2f21df381b54ff2b0d708d7b642b823%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637178269975209891&sdata=Nwty65gRTLqGdGKQ52MNWEhPhN6fPDiwDkBuArh7oqk%3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7Cc2f21df381b54ff2b0d708d7b642b823%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637178269975209891&sdata=qXRc%2FslkYTxq7KLYh%2FtA%2BH7twrcJqAOPVoDwamfnOwc%3D&reserved=0. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com&data=02%7C01%7C%7Cc2f21df381b54ff2b0d708d7b642b823%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637178269975209891&sdata=2W4lkG0X5Km8aTw4TIvfhl3WNHp4ZfzpunxXv7nQMOY%3D&reserved=0