Hi Jeff,
I'll recommend a Dynamic UniVerse file (TYPE 30) for storing binary data
like images.
Most likely all records will be stored as "large records" giving almost
direct assess.
It performs fine and there is no practical limits in the total size or the
no. of records to be stored in a 64BIT file.
Alternatively, you could for administrative reasons spread the images in
more 32BIT files each holding maybe 2GB.
The internal format of Dynamic files makes it also a protected way of
storing READONLY images.
Using TYPE 1 or 19 files will slow down the OS system, if you have hundreds
of thousands or millions of images
You will need a TYPE 1or 19 file as a temporary place for moving binary
files to and from the Dynamic file.
Any UniVerse reads and writes to the TYPE 1 or 19 file must by binary.
E.g.:
READ IMAGE.RECORD FROM F.DYNAMIC.FILE, IMAGE.ID ELSE
END
ASSIGN SYSTEM(1017) TO 1 ;* binary on
WRITE IMAGE.RECORD TO F.TYPE19_FILE, IMAGE.ID
ASSIGN SYSTEM(1017) TO 0 ;* binary off
The method may be different in UniData.
Regards,
Uffe Toft
Steria Denmark
- -----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Marcos
Sent: 18 December 2006 07:47
To: [email protected]
Subject: [U2] Storing images on U2 database.
Hi all,
Has anyone had experience with storing images (gif, tiff, bmp or jpg)
files on Universe database?
If so, how or what documents describe this feature?
Thanks in advance.
Regards,
Jeff Marcos
Corporate Express Aust. Ltd
Masterpack (ERP) Technical Lead (BIS)
* Phone: +612 9335 0104
* Fax: +612 9335 0753
h Support: +612 9335 0501
* Email: [EMAIL PROTECTED]
* Web site: www.ce.com.au <http://www.ce.com.au/>
------------------------------------------------------------------------------------
This email originates from Steria A/S, Tonsbakken 16-18, DK-2740 Skovlunde -
www.steria.dk.
This email and any attachments may contain confidential/intellectual
property/copyright information and is only for the use of the addressee(s). You
are prohibited from copying, forwarding, disclosing, saving or otherwise using
it in any way if you are not the addressee(s) or responsible for delivery.
If you receive this email by mistake, please advise the sender and cancel it
immediately.
Steria may monitor the content of emails within its network to ensure
compliance with its policies and procedures.
Any email is susceptible to alteration and its integrity cannot be assured.
Steria shall not be liable if the message is altered, modified, falsified, or
even edited.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
