 |
 |
Archives of the TeradataForum
Message Posted: Mon, 05 May 2008 @ 21:43:18 GMT
| Subj: | | Loading Large Objects (with the utilities?) |
| |
| From: | | frank.c.martinez |
Hello all (but especially Mike Dempsey and Dieter Noeth),
Well, sometimes we just get crazy data. The latest thing at our shop is we're starting to get people asking us to load CLOB's (Character Large
OBjects) of sizes greater than 64K (well, ok, if we just needed 64K, we'd use VARCHAR). It was discouraging to find the following post in the
listserv from as recent as January of last year:
| | Subj: Re: How to Load CLOB into Teradata
From: Geoffrey Rommel
Message Posted: Mon, 01 Jan 2007 @ 23:05:26 GMT | |
| | LOBs cannot be loaded with the standard utilities. You must write a custom application. CLI and JDBC will work for sure; I believe ODBC and
embedded SQL are also possible. | |
Especially since this post was immediately followed by Mike Dempsey saying, "But you can load them with SQL Assistant!" Ok, so we've got data
coming in from a queue, and we can't use abInitio, since it can't use LOB's, and Fastload's largest VARTEXT is 64K. So other than the suggested
(write a custom app), can you use TPT/Warehouse Builder to do it? Does anyone have EXAMPLES? Por favor, su ayuda, amigos mios.
iv
| |
