IDS Forum

Re: dbaccessdemo and the blob columns in catalog t

Posted By: JACOB SALOMON
Date: Tuesday, 12 December 2017, at 8:05 p.m.

In Response To: RE: dbaccessdemo and the blob columns in catalog t (Luis Filipe Silvestre Marques)

The bottom line of this post is a request for help on the FILETOBLOB function and how I would avoid the errors in the explicit update of a blob column for a file.

But first, I need to thank Luis for pointing me to the the alternative script:

Luis,

Thanks. I had never heard of the dbaccessdemo_ud before. I already have plenty of DBspaces do draw from:

DBspace DNum Type k/pg Chunks NumPages FreePgs %-Full
rootdbs 1 ---M 2 1 500000 487303 2.54
plog_dbs 2 ---N 2 1 400000 24947 93.76
llog_dbs 3 ---N 2 1 250100 47 99.98
tmpdbs01 4 T--N 8 1 25000 24947 0.21
tmpdbs02 5 T--N 8 1 25000 24947 0.21
data_dbs 6 ---M 16 4 43750 41089 6.08
index_dbs 7 ---M 8 1 50000 49923 0.15
blobs_dbs 8 -B-N 6 1 50000 49859 0.28
sbdbs01 9 --SN 2 1 12500 644 94.85
syssbdbs01 10 --SN 2 1 12500 644 94.85

Unfortunately, the above will get is spaces squeezed out of it so that you can't see how neat the columns are. But I will have no problem specifying a DBspace for the data. Now if I could only manipulate the script to create the indexes in index_dbs. But I digress..

My attempts to update the byte-blob column of the first row in catalog has opened my eyes to an area whence I have never ventured: The explicit setting of a blob column in a SQL statement in dbaccess. As all could see, my use of the filetoblob() SQL function was failing. Can anyone point me to the correct syntax to accomplish that?

I thought that I might gain some insight from the .unl file for catalog. Here's the first line:

0|1|HRO|case|ROW(/tmp/cn_1001.gif,"Your First Season's Baseball Glove")|0,62,/tmp/catalog.des|

(Please widen your window if that wrapped)

Interesting syntax in that last column: |0,62,/tmp/catalog.des|
Where is this documented? I think I have all of the 12.10 manuals in PDF so it's a matter where where to look in that haystack. But the .des file is all text so I don't follow how that relates to a blob. And the meaning of that 0,62? My ignorance is on display here. HELP!

Can someone point me to working example of this? As I mentioned, I find only insert statements with FILETOBLOB calls, no updates. I have yet to start playing with the inserts to see if I can *those* working.

Thanks much for advice here.

-- Jacob S.

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.