Subject | Blob Metadata and Scripts |
---|---|
Author | Don Gollahon |
Post date | 2002-08-29T03:39Z |
I used the "Extract Metadata DDL" button in IB_SQL and then tried to run the
script using it's "Execute Script" button. I was getting errors. Come to
find out that Blob fields (which are just memo fields I created in the
tables) are not getting extracted right by the metadata button. When I
changed the Blob field definitions from what the metadata used:
BLOB SUB_TYPE 0 SEGMENT SIZE 80 CHARACTER SET NONE
to what the table source says:
BLOB( 65535, 0 )
then it works. Is this a bug in IBO 4.2 Hf?
Thanks.
Don Gollahon
(dlgllhn@...)
"What in Eternity does it matter?"
script using it's "Execute Script" button. I was getting errors. Come to
find out that Blob fields (which are just memo fields I created in the
tables) are not getting extracted right by the metadata button. When I
changed the Blob field definitions from what the metadata used:
BLOB SUB_TYPE 0 SEGMENT SIZE 80 CHARACTER SET NONE
to what the table source says:
BLOB( 65535, 0 )
then it works. Is this a bug in IBO 4.2 Hf?
Thanks.
Don Gollahon
(dlgllhn@...)
"What in Eternity does it matter?"