Subject | External tables and null values |
---|---|
Author | Milan Babuskov |
Post date | 2002-12-23T13:56:16Z |
Hi all,
I'm trying to copy data from one database to the other via external
tables. I have problem with null values.
I first insert rows from source database to external table. Then I try
to insert from external table to destination database, but all NULL
values are converted:
integers become zero
dates become 17.11.1858
Is this behaviour expected?
If so, how to overcome it?
TIA
Milan Babuskov
P.S. I searched the newsgroups and google but couldn't find anything
about this.
I'm trying to copy data from one database to the other via external
tables. I have problem with null values.
I first insert rows from source database to external table. Then I try
to insert from external table to destination database, but all NULL
values are converted:
integers become zero
dates become 17.11.1858
Is this behaviour expected?
If so, how to overcome it?
TIA
Milan Babuskov
P.S. I searched the newsgroups and google but couldn't find anything
about this.