Error - Importing DATE metadata from Oracle in DS801
Posted: Tue Sep 25, 2007 11:09 am
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
##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