When I import my table which has column type DATE it wouldn't let me view my data. Error below -
##I IIS-DSEE-TUTL-00031 10:48:03(001) <main_program> The open files limit is 15000; raising to 65536.
##I IIS-DSEE-TOSH-00002 10:48:03(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 10:48:03(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 10:48:03(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 10:48:03(005) <main_program> Parameter specified but not used in flow: ps_X002_P
##W IIS-DSEE-TDOR-00480 10:48:03(006) <main_program> The NLS character map <ISO-8859-1> is specified, but NLS_LANG is not set;
the NLS character map must be set to an ICU codepage which is equivalent to
the character set specified by NLS_LANG.
>##E IIS-DSEE-TFIP-00011 10:48:04(001) <Oracle_Enterprise_20> Error when checking operator: When binding output interface field "AGRMT_EFCTV_DT" to field "AGRMT_EFCTV_DT": No default type conversion from type "timestamp" to type "date".
At the sametime when I change to TIMESTAMP it lets me.
Pl. answer. Thanks
Error - Importing DATE metadata from Oracle in DS801
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's because it's a timestamp.
There is no automatic conversion to date - that's what the error message is telling you. Therefore you can not simply assert that the column is of type DATE and expect to import from an Oracle TIMESTAMP into it.
Put another way, your metadata must accord with what's out there.
There is no automatic conversion to date - that's what the error message is telling you. Therefore you can not simply assert that the column is of type DATE and expect to import from an Oracle TIMESTAMP into it.
Put another way, your metadata must accord with what's out there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.