RE: BLOB, CLOB, GRAPHIC, VARGRAPHIC, DATALINK

["Andrew Lutz" <andrew.lutz@xxxxxxxxxxxx>]

I use Graphic & VarGraphic for UniCode support.  Set the ccsid to 13488
and you have Unicode, which by the way RPG supports.


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] 
Sent: Monday, July 14, 2003 9:15 AM
To: Midrange Systems Technical Discussion
Subject: BLOB, CLOB, GRAPHIC, VARGRAPHIC, DATALINK

I've actually used a DATALINK.  Has anyone used a BLOB, or the other 
fields listed in the subject line?

Here is the application.  We have a web application.  We want to store a

PDF in a DB2 file field.

If we were to use a BLOB then how would our web application access that 
data?  I know that traditional RPG has no host type variable that would 
support a blob, like
Select IDESC, myblobfield
  From IIM
  Into :wDesc, :wMyBlb
  Where...
Would be a real trip.

So, provided we had an application that would create this PDF, how would

we get it into DB2, and then how would our, (let's say Domino), 
application retrieve the data from DB2 and display it?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.