DSXchange

Hi , I am facing the following error while viewing data:- Error: Property 'Context' for 'ODBC_Connector_0' is required but empty Error: Property 'Lookup Type' for 'ODBC_Connector_0' is required but empty I am not able to find any of these properties to set in ODBC Connector Stage. Please provide you...

Hi , In a jon I am try to populate Oracle table BY a source dataset with RCP Enabled. In ODBC Connector Stage , Table Action = CREATE OR REPLACE then no warning is coming up. bUT Table Action = APPEND then the mentioned warning is coming up :p- TgtCDLTblODBC: The length of VARCHAR column STAT cannot...

Hi ArndW,

The data type in the source dataset is Time . It is RCP enabled.
So I am not coding any metadata and it is coming as Timestamp in Output.

Craig ,

The datatype of that field is coming as Timestamp. I checked.
As per the requirement , my job is creating this table with this field as Timestamp in destination.

So this means as you have also said that only way to store time is to store as VARCHAR.

Thanks,
Ankur

Craig , Can my output can only be a time . I have to make the destination table means creating Table @ runtime. I was seeing the manual of Oracle Datatype but did not find anything being specific to time . So Oracle table by itself converting it to valid timestamp? Is there output can only be a time.

Hi , I want the Source Time Field should be coming as a time only in a job . But It is converted to Timestamp. Source Dataset -> 14:28:29 Destination Oracle Coming as -> 2010-02-15 14:28:29 Is there any way to do so. Please not I am using RCP in Job so not touching metadata at all. Thanks, Ankur

Try unbounded LongVarchar as suggested by craig, it should work...

[quote="chulett"]Oracle DATE fields always carry a time portion, therefore they are a timestamp data type. If you don't supply the time it defaults to "00:00:00". [quote]

Thanks craig ... I do not know that In Oracle Date field get stored as a timestamp . Thanks for inputs .

The source dataset have some date fields with format 2009-11-18 . But when the data is loaded intp Oracle Table , it converts its format to Tuesday,November 17 ,2009 12:00:00 AM GMT + 00:00. So... are you seriously saying that 2009-11-18 is getting converted to November *17* or is that a typo? Obvi...

Hi ArndW, When i made the select query on the database the date field comes as 2009-11-18 00:00:00.0. This means that source date 2009-11-18 got converted into a timestamp. I am not coding column metadata in the job . So Please let me know which setting if required to be changed. I am not understand...

Hi ArndW, When i made the select query on the database the date field comes as 2009-11-18 00:00:00.0. This means that source date 2009-11-18 got converted into a timestamp. I am not coding column metadata in the job . So Please let me know which setting if required to be changed. I am not understand...

The default format for database is "YYYY-MM-DD" and you cannot change it. In this format only the data will get stored in the database. Hi datsaq , I also want to store in the format "YYYY-MM-DD" but the data is stored in the database as Tuesday,November 17 ,2009 12:00:00 AM GMT...

Try to analyze the score to confirm. "In case APT_NO_PART_INSERTION = FALSE, auto partitioning will not override the partitioning algorithm specified and it wont insert an auto partitioning before that". In case there is no partitioning algorithm is specified (auto partitioning) it will i...

This Job is a multiple instance common job which accepts these Dataset name supoose A as a paramter and loading into the Oracle Table . Here RCP is enabled is used so need of writing metadata in it . The source dataset have some date fields with format 2009-11-18 . But when the data is loaded intp O...

Hi priyadarshikunal , This is one of the Best practise which i have mentioned. I am very sure on this if APT_NO_PART_INSERTION = FALSE then it will first do the Auto as specified and then partioning as specified in the stage itself. Kindly further to Datastage Parallel Job Advanced Developer's Guide...