Re: What fool proof way exist to initiate PC Activities (from 5250 and Browser(Webfacing)) with the possibilitie to send/retrieve parameters??

CREATE TABLE *LIRARY/*TABLE (*FIELD1 CHAR ( 8) CCSID 37 WITH 
DEFAULT NULL, *FIELD2 CHAR ( 100) CCSID 37 WITH DEFAULT NULL, 
*FIELD3 BLOB ( 10 M) WITH DEFAULT NULL, UNIQUE (FIELD1, FIELD2))

I used this to create a table that contains attachments of various sorts. 
Field1 is the key for the database, Field2 was the name of the attachement 
(ie Picture.jpg) And Field3 was the binary data that was the attachment. 
The 10 M specifies that the largest file it can contain is 10 Meg.  You 
could set it to more.  HTH,

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




"James H H Lampert" <jamesl@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
2006/11/24 02:47 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


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

Subject
Re: What fool proof way exist to initiate PC Activities (from   5250 and 
Browser(Webfacing)) with the possibilitie to send/retrieve parameters??






eduard@xxxxxxxxxxxxxxxxxxxxxxx wrote:

James,

I'm a quick learner.....
Learn we what a Datalink field is and how this could 
help me.

A Datalink field is a field in a database file, that 
explicitly points to some other object (generally in the 
IFS), in a way that is managed by DB2. It was introduced 
after V4R2, but by V4R4.

As I recall (and it's been a few years since I dabbled in 
datalinks), to create a file with datalink (or BLOB or 
CLOB) fields, you have to do it from SQL, rather than from 
DDS, and you have to either have journaling enabled on the 
library, or use special options to bypass a lot of the 
checking DB2 does on datalinks, in order to do it.

I'm sure there's someone else who knows more about 
datalinks than I do; all I managed to accomplish with them 
was to get QuestView (tm) to provide minimal support for 
them.

At any rate, from what I've said, it should be clear that 
a datalink field would allow you to put a protected 
reference to your captured signature image into a 
database, and assuming you need to deal with the file from 
a terminal environment, it would certainly be easier to 
deal with than sticking the image into a BLOB (binary 
large object) field.

--
JHHL