IDS Forum

RE: dbaccessdemo and the blob columns in catalog t

Posted By: Luis Filipe Silvestre Marques
Date: Tuesday, 12 December 2017, at 3:44 a.m.

In Response To: Re: dbaccessdemo and the blob columns in catalog t (JACOB SALOMON)

The stores_demo database uses a BYTE column in the catalog table.

If you want the BLOB/CLOB version, you need to create the superstores_demo database. For the superstores_demo to work properly, you probably need to setup a default sbspace (SBSPACENAME parameter).

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.dba.doc/ids_dba_015.htm

The gif files used in the superstores_demo are in "$INFORMIXDIR/demo/dbaccess/demo_ud/" (the dbaccessdemo_ud script that creates the superstores_demo copies the gif file to the /tmp/).

Luis Marques

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACOB SALOMON
Sent: terça-feira, 12 de dezembro de 2017 05:20
To: ids@iiug.org
Subject: Re: dbaccessdemo and the blob columns in catalog t [40363]

Following up on my option, I did download a few relevant pictures and saved them in a subdirectory of where I am playing around with this. I tried this update statement:

update catalog

set cat_picture = filetoblob('catalog-pics/10001.BaseballGlove-01.jpg',
'client')
where catalog_num = 10001

I got this error:
617: A blob data type must be supplied within this context.

I also tried it with the optional extra parameters:
update catalog

set cat_picture = filetoblob('catalog-pics/10001.BaseballGlove-01.jpg',
'client',

'catalog', 'cat_picture') -- These are optional where catalog_num = 10001

I also tried ./catalog-pics/10001.BaseballGlove-01.jpg but that was clutching at a straw already and, of course, barfed just as eloquantly. Duh, howzabout you tell me what kind of context it requires?

So now I have another question on the syntax and semantics of using filetoblob().
and I got the same error.

I don't see any examples of the update command using filetoblob(). Clues anyone?

Thanks!

-- Jacob S.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• dbaccessdemo and the blob columns in catalog table
  JACOB SALOMON -- Monday, 11 December 2017, at 11:43 p.m.
  • Re: dbaccessdemo and the blob columns in catalog t
    JACOB SALOMON -- Tuesday, 12 December 2017, at 12:19 a.m.
    • RE: dbaccessdemo and the blob columns in catalog t
      Luis Filipe Silvestre Marques -- Tuesday, 12 December 2017, at 3:44 a.m.
      • Re: dbaccessdemo and the blob columns in catalog t
        JACOB SALOMON -- Tuesday, 12 December 2017, at 8:05 p.m.
        • Re: dbaccessdemo and the blob columns in catalog t
          Andreas Legner1 -- Wednesday, 13 December 2017, at 11:26 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.