how to insert a text file or a picture in a cloumn

[SL23]

I have a table in teradata and want to insert a text file in one of the column.
How could I do this in teradata? Any help please.

 

[BillDHS]

What have you tried so far?
Why isn't it just a VARCHAR attribute?

 

[ripperfuel]

I think, SL23 is asking something like BLOB datatype in Oracle. In Oracle, you can store Excel or Text file (or any type file) in a column that is defined as BLOB.

I am also curious to know whether Teradata has a datatype similar to BLOB in Oracle. Thanks.

 

[SL23]

I HAVE REPLICATED A CLOB VALUES FROM ORACLE TO TERADATA TABLE. IS ANY ONE KNOW HOW TO RETRIVE THE DATA IN TERADATA.
AND THE TABLE IS LOOKS LIKE THIS:

CREATE SET TABLE DEV.t1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
USR_ID DECIMAL(18,4) NOT NULL,
USR_HTML_DESCRIPTION CLOB(10240) CHARACTER SET LATIN)
UNIQUE PRIMARY INDEX PK_T2 ( USR_ID );

I DID A COUNT THERE ARE TWO RECORDS, BUT CANT SEE THE VALUES. WHEN I BROWSE, IT SAYS "LOBs ARE NOT ALLOWED TO BE SELECTED IN RECORD OR INDICATOR MODE. PLEASE ANY ONE HAVE ANY IDEA.

THANKS!

 

[BillDHS]

Search the Teradata Forum at

http://www.teradataforum.com/index.htm