Archives of the TeradataForum
Message Posted: Mon, 29 Nov 2004 @ 14:04:47 GMT
| Subj: | | Re: Fast Export Decimal problem |
| |
| From: | | Geoffrey Rommel |
| | Since BTEQ and FASTLOAD were normally used to load data from the mainframe, the data normally came from DB2 and they know about null
bits | |
Not sure what you mean here, Michael. As far as I know, DB2 (officially DB2 UDB for z/OS) will not unload data with the null bits packed into
bytes as Teradata does. You could write your own program, though ... hmm ...
| | would it not follow in a logical progression that DB2 load and unload utilities know how to create and interpret the null
bits? | |
No. DB2 has always sublimely disregarded Teradata.
In the early releases of DB2, there was a LOAD utility but no UNLOAD. The NULLIF parameter in the load utility allows you to check only whole
bytes, not individual bits.
There was a "sample program" called DSNTIAUL that would unload data from a DB2 table, but it wasn't officially supported. In V6, the REORG
UNLOAD EXTERNAL command was added; this is a supported unload utility. I believe it indicates nulls by means of a separate byte either before or
after the nullable field.
| 
