Regarding Oracle Enterprise Stage Warnings
Posted: Thu Aug 31, 2006 3:29 am
Hi,
I am extracting data from Oracle 9i Database to a sequential file using Oracle Enterprise Stage.
The following are the NACHAR settings on the Oracle database:
NLS_CHARACTERSET= ALT32UTF8
NLS_NCHAR_CHARACTERSET=ALT16UTF16.
The columns in the table are defiend as Varchar2(50 CHAR). I have defiened them as Varchar(50) in Oracle Enterprise Stage. When I run the job the job log shows the following warning messges for each of the varchar fields:
Implict conversion from source type 'string max[200] to result type max=50. Possible truncation of variable length string
NSL on the Datastage is not enabled(since only ASCII characters are expected in the data).
Can any one tell where I am doing wrong? Are there any other settings on the datastage that should be checked to ensure that the Enterprise stage interprets the field lenghts correctly?
Any pointers on the above issue would be very helpful.
Thanks & Regards,
Vijay
I am extracting data from Oracle 9i Database to a sequential file using Oracle Enterprise Stage.
The following are the NACHAR settings on the Oracle database:
NLS_CHARACTERSET= ALT32UTF8
NLS_NCHAR_CHARACTERSET=ALT16UTF16.
The columns in the table are defiend as Varchar2(50 CHAR). I have defiened them as Varchar(50) in Oracle Enterprise Stage. When I run the job the job log shows the following warning messges for each of the varchar fields:
Implict conversion from source type 'string max[200] to result type max=50. Possible truncation of variable length string
NSL on the Datastage is not enabled(since only ASCII characters are expected in the data).
Can any one tell where I am doing wrong? Are there any other settings on the datastage that should be checked to ensure that the Enterprise stage interprets the field lenghts correctly?
Any pointers on the above issue would be very helpful.
Thanks & Regards,
Vijay