JPEG in DB/2-Tabelle

[chrisi]

Hallo DB/2-Gurus

wir möchten eine JPEG-Datei in einer Tabelle
auf der /400 ablegen und dieses Bild von einem PC-programm (Visual Basic) aus anzeigen. Hat jemand einen Tip, wie ich das JPEG in die Tabelle bringe und nachher aulesen muß?
Muß die Spalte als BLOB definiert werden ?
Für Tips wäre ich sehr dankbar.

Chrisi

[delphix]

hi chrisi,


ja!du mußt die spalte als BLOB definieren!

[chrisi]

Hallo delphix,

vielen Dank für die Antwort.
Kannst Du mir auch zufällig sagen, wie ich ein jpeg in das blob bekomme ?

Viele Grüße, Chrisi

[rmittag]

jpeg als BLOB in DB2 ist m.E. nicht so günstig, denn a) wie da reinbekommen, b) wie anzeigen, c) wie bearbeiten, d-z) ...

Eine bessere Alternative bietet das DB2 Handbuch (Hanbuch lesen ist eigentlich immer eine gute Idee, besser als lesen lassen ) :

DataLink Values

A DataLink value is an encapsulated value that contains a logical reference from the database to a file stored outside the database. The attributes of this encapsulated value are as follows:


link type
The currently supported type of link is a URL (Uniform Resource Locator).

scheme
For URLs, this is a value such as HTTP or FILE. The value, no matter what case it is entered in, is stored in the database in upper case.

file server name
The complete address of the file server. The value, no matter what case it is entered in, is stored in the database in upper case.

file path
The identity of the file within the server. The value is case sensitive and therefore it is not converted to upper case when stored in the database.

access control token
When appropriate, the access token is embedded within the file path. It is generated dynamically and is not a permanent part of the DataLink value that is stored in the database.

comment
Up to 254 bytes of descriptive information. This is intended for application specific uses such as further or alternative identification of the location of the data.
The characters used in a DataLink value are limited to the set defined for a URL. These characters include the uppercase (A through Z) and lower case (a through z) letters, the digits (0 through 9) and a subset of special characters ($, -, _, @, ., &, +, !, *, ", ', (, ), =, ;, /, #, ?, :, space, and comma).

The first four attributes are collectively known as the linkage attributes. It is possible for a DataLink value to have only a comment attribute and no linkage attributes. Such a value may even be stored in a column but, of course, no file will be linked to such a column.

It is important to distinguish between these DataLink references to files and the LOB file reference variables described in References to LOB File Reference Variables. The similarity is that they both contain a representation of a file. However:


DataLinks are retained in the database and both the links and the data in the linked files can be considered as a natural extension of data in the database.

File reference variables exist temporarily and they can be considered as an alternative to a host program buffer.
Built-in scalar functions are provided to build a DataLink value (DLVALUE) and to extract the encapsulated values from a DataLink value (DLCOMMENT, DLLINKTYPE, DLURLCOMPLETE, DLURLPATH, DLURLPATHONLY, DLURLSCHEME, DLURLSERVER).

[chrisi]

Hallo rmittag,

natürlich habe ich auch schon im Handbuch
gestöbert, ich dachte nur, daß es vielleicht über ein BLOB einfach zu lösen ist und ich
Daten und Bilder in einer Tabelle habe.
Aber vielen Dank für den Auszug und ein schönes Wochenende.
Chrisi