RE: Images stored in DB2

The problem with BLOB files is that you can (A) only create one using SQL
and (B) you cannot read a file containing a BLOB with RPG.
Now, problem (A) isn't too big an issue, just do something like this:

CREATE TABLE LEASES (                          
  CONTRACTID CHAR(10) NULL WITH DEFAULT,    
  CONTRACTTITLE CHAR(30) NOT NULL WITH DEFAULT,
  CONTRACT BLOB(1048576) DEFAULT NULL
 ) ;      
  
To solve problem (B), create a logical view over the file, omitting the BLOB
field, then you can read it in RPG IV and not worry about the blob itself.

-Bob
                                           

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of rob@xxxxxxxxx
Sent: Monday, February 14, 2005 8:32 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Images stored in DB2

Two suggestions:  BLOB, and DATALINK.  BLOB holds them directly.  DATALINK 
holds a value like
//myserver/myShare/MyDir/MyFile.ext
Depends on how you plan on gathering, and accessing the data, which method 
you choose.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Douglas W. Palme" <dpalme@xxxxxxxxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/14/2005 09:13 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Images stored in DB2






We have received a request from our Cylinder control department for the 
ability to scan in and view our cylinder lease contracts.

I was wondering if these can be stored in a DB2 physical file and if so, 
what should the field type be?

other Suggestinos?

Douglas

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.