OCI has fetched truncated data
Moderators: chulett, rschirm, roy
OCI has fetched truncated data
Hi,
I know it has been posted in the past. These posts helped me to solve my problem.
we are using Oracle database as a source, one column data type in Oracle table is "date". when we are trying to retrieve data from this date column by using OCI stage, it is giving error "OCI has fetched truncated data". But we declared datatype for this date column is "char(10)" in OCI stage. It is working in pre-prod environment but it is giving error in prod environment. After changed the datatype from char(10) to Timestamp, it is working in prod environment also.
why it is still working in pre-prod environment?
we verified database level date formate settings in prod and pre-prod, both are same.
we verified datastage level NLS property tab is disabled in prod and pre-prod.
please help me regarding the same.
Thanks
I know it has been posted in the past. These posts helped me to solve my problem.
we are using Oracle database as a source, one column data type in Oracle table is "date". when we are trying to retrieve data from this date column by using OCI stage, it is giving error "OCI has fetched truncated data". But we declared datatype for this date column is "char(10)" in OCI stage. It is working in pre-prod environment but it is giving error in prod environment. After changed the datatype from char(10) to Timestamp, it is working in prod environment also.
why it is still working in pre-prod environment?
we verified database level date formate settings in prod and pre-prod, both are same.
we verified datastage level NLS property tab is disabled in prod and pre-prod.
please help me regarding the same.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for spending your valueble time, I tried to get the more information regarding date default settings in msg.txt file. I couldn't get any info. I am able to see some sample below entries in msg.txt file.
DLM0040 Process sig (%d) has date of %ld\n
GNS0002 genser: cannot decode date\n
UVR0018 to expiry date of %s for %d CPU's\n
UVR0012 %-15s package is installed. \n\tExpiry date = %s\n
UVR0003 Only one date option may be specified\n
can you give me more details on date default settings?
DLM0040 Process sig (%d) has date of %ld\n
GNS0002 genser: cannot decode date\n
UVR0018 to expiry date of %s for %d CPU's\n
UVR0012 %-15s package is installed. \n\tExpiry date = %s\n
UVR0003 Only one date option may be specified\n
can you give me more details on date default settings?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It means that the default date format is the one you would get by executing the following query.
Code: Select all
SELECT CURRENT_DATE CONV 'D' FMT '20L' FROM VOC FIRST 1;
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.