DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
NDE
Participant



Joined: 08 Aug 2006
Posts: 3

Points: 31

Post Posted: Tue Aug 08, 2006 1:58 am Reply with quote    Back to top    

First sorry for my english, I'm french Laughing

I have to create a job which insert the current date and time in a field in TIMESTAMP format (oracle version is 10.2.0)


I can't transform the field in DATE format.
I can't had colums in the table

I tried to do it with varchar format but each time I got the same message:

Oracle_Enterprise_0: Column NDE_TS has an unsupported type.

(Oracle_Enterprise_0 is the default name of the stage)

Someone has a solution ?
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Tue Aug 08, 2006 2:16 am Reply with quote    Back to top    

Hello NDE,

welcome to DSXchange. You will need to post your queries in the appropriate forum, this is the "FAQ Discussion" and has nothin to do with your question. The correct forum is IBM® Websphere® DataStage Enterprise Edition (Formerly Parallel Extender/PX) and when you post there you can enter your OS and DS Version as part of your post instead of as parts of the subject line.

PX is a very datatype sensitive and you can only put a timestamp type column into the database if it actually contains a timestamp.

- What is your ORACLE definition for the column "NDE_TS"?
- How are you generating your timestamp (i.e. is it coming in as a column or are you creating it in the job)?

_________________

Image
Rate this response:  
Not yet rated
NDE
Participant



Joined: 08 Aug 2006
Posts: 3

Points: 31

Post Posted: Tue Aug 08, 2006 2:23 am Reply with quote    Back to top    

OK, sorry, Embarassed

Can you lock or delete this topic, I'm goind to create it at the right place.

thx!
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours