SQL0104 - DB2/400

[José Carlos Cunha]

Hi,

I don´t can create a table (DB2 UDS/400) width Blob and Clob fields because
I receive the following message:

SQL0104 - Token BLOB was not valid. Valid tokens: SMALLINT INT REAL DATE
TIME TIMESTAMP DOUBLE CHARACTER FLOAT G.

You can help me,

Thanks

Jose Carlos (jcarlo...@mail.telepac.pt)

Portugal

[Rolf Mittag]

The "F4" = prompt key and/or "F1" = help key :

create table -> "F4" -> go to the data type field -> "F1"
now you get all the valid data types.

If BLOB is not within the choices you're not the appropriate
Version of OS/400.

CREATE TABLE SD/X (Z BLOB NOT NULL WITH DEFAULT) or
CREATE TABLE SD.X (Z BLOB NOT NULL WITH DEFAULT)

works (OS/400 : V4R4M0)

Rolf

--

Dipl.Inf.(FH) Rolf P Mittag
IBM Partner In Development
Leipziger Str. 50
D-69214 Eppelheim
eMl: r...@r-m-e-d-v.de
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26

[Karl Hanson]

Rolf Mittag wrote:
>
> The "F4" = prompt key and/or "F1" = help key :
>
> create table -> "F4" -> go to the data type field -> "F1"
> now you get all the valid data types.
>
> If BLOB is not within the choices you're not the appropriate
> Version of OS/400.
>
> CREATE TABLE SD/X (Z BLOB NOT NULL WITH DEFAULT) or
> CREATE TABLE SD.X (Z BLOB NOT NULL WITH DEFAULT)
>
> works (OS/400 : V4R4M0)
>

(sorry for late response - I have been gone)
To get BLOB functionality in V4R4, you will want the latest fixpack (aka
group PTF). This is available at:
http://www.as400.ibm.com/db2/db2tch_m.htm
Click in "DB2 UDB for AS/400 Fixpack Information", and see infor for
SF99104.

--

Karl Hanson