Re: SQL Blob CCSID

The error I'm receiving is:

Error opening file /PublicAS400/Images/INTER/189320.jpg
Conversion error. RC(2) errno(3490).

We are using BVSTOOLS getURI to send a JPG to AWS. When we were using a
test JPG with CCSID 1252., we had to specify 1252 in GETURI.

Now I'm trying to send a JPG that was retrieved from our production
database and it is CCSID was 65535 so I assumed that was my problem.

Thanks, Art

On Thu, Feb 20, 2020 at 3:46 PM Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
wrote:

Hi Art,

The "B" in "BLOB" stands for "binary". Therefore, the concept of a
CCSID doesn't really apply...

Are you thinking of a CLOB or DBCLOB instead?

-SK

On 2/20/2020 2: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.

--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com