APT_FileExportOperator unable to export record: Record large
Moderators: chulett, rschirm, roy
APT_FileExportOperator unable to export record: Record large
I have oracle target stage and use load medhod.I want to fill timestamp column with current timestamp.In transformer stage ,i use CurrentTimestamp function but i take warnings like this and no load data.
Oracle_Enterprise_50,1: APT_FileExportOperator unable to export record: Record larger than fixed-length record stream [impexp/recordstream.C:1362]
this column in oracle has timestamp data type and also in DS.
Oracle_Enterprise_50,1: APT_FileExportOperator unable to export record: Record larger than fixed-length record stream [impexp/recordstream.C:1362]
this column in oracle has timestamp data type and also in DS.
The function that you use will give the current time stamp in internal Datastage format. But you need to pass the value into to Oracle to its requried value. You need to use TO_DATE() function to convert it into oracle format while loading it.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
What if you load it as varchar? Run a test on a table using the load method which does not have timestamp in it. Is it really a timestamp issue? All that the error says is that the record is larger than the fixed length. We dont know for sure it really is a timestamp issue.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Your change will only be at the datastage level. Not at the database level. How will that effect BO again? BO has no visibility to DataStage metadata.dsisbank wrote:if target column is varchar,it's not a problem.it works fine and when i look data,data format is ok.But i cant change target column from timestamp to varchar because Business objects' reports will be effected.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
I mean db level and also i solved load problem using OCI bulk loader.Bu i havent solved micrasecond problem.I search forum but i couldnt find any solution.there are many solution recomended but they have no affect.
My source is 30.03.2005 23:57:32.150000 but i load this data like 30.03.2005 23:57:32.000000
microseccond is missing
Do you know how can i solve this?
My source is 30.03.2005 23:57:32.150000 but i load this data like 30.03.2005 23:57:32.000000
microseccond is missing
Do you know how can i solve this?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes target column is timestamp(6) and timestamp format in DS is %yyyy-%mm-%dd %hh:%nn:%ss.6
i take data from DB2 both varchar and timestamp,When i use timestamp,it doesnt work but i use varchar it works but milisecond is missing.
as i read Parallel Job Developers Guide page 13-7,DS doesnt support milisecond
i take data from DB2 both varchar and timestamp,When i use timestamp,it doesnt work but i use varchar it works but milisecond is missing.
as i read Parallel Job Developers Guide page 13-7,DS doesnt support milisecond
For this case, you can change the source to Char/varcahr using To_Char function and convert it back to Date with Timestamp with to_date function in the load stage. But you will need to use User Defined SQL for that.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'