RE: Images stored in DB2

Bob,
That is good information.....I really appreciate the info, as I definitely 
want to do this via RPG initially and then later on via VB for those 
connecting remotely via the web.

Thanks again for the feedback.

Douglas


On Mon, 14 Feb 2005 08:46:20 -0600, Bob Cozzi wrote
> 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.
> 
> -- 
> 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.


--
Open WebMail Project (http://openwebmail.org)