#DateForumTypeThreadPost
1529 Jun 2011 @ 08:02 PDTDatabaseTopicissue with Decimal(38,0) im trying to insert data from data files through informatica to teradata target tables one of the column is decimal(38,0) and input in the file for this field as 20710376814033754942922071775...
1427 Jun 2011 @ 07:08 PDTDatabaseReplyNeed to insert 39 digit integer value in teradata its not working for me
1327 Jun 2011 @ 06:28 PDTDatabaseReplyNeed to insert 39 digit integer value in teradata create table d9_stg_gwa.smpl( id byte(16) ) insert into D9_STG_GWA.Smpl values (245897415178077719586663693772824060732)
1227 Jun 2011 @ 06:24 PDTDatabaseReplyNeed to insert 39 digit integer value in teradata i tried with this id byte(16) ) insert into D9_STG_GWA.Smpl values (245897415178077719586663693772824060732) but it is throwing me an error "too many digits in integer or decimal" ....
1127 Jun 2011 @ 05:06 PDTDatabaseTopicNeed to insert 39 digit integer value in teradata I need to insert 39 digit integer value into Teradata ,can anyone suggest me which data type will be suitable for this . Value will be like this and generated by MD5 in oracle : 14614359055...
1023 Jun 2011 @ 12:01 PDTDatabaseReplyInteger value conversion to Time format Thanks Dnoeth for your reply . yes the format is like that . thank you it is working .
922 Jun 2011 @ 11:09 PDTDatabaseReplyInteger value conversion to Time format can any one help me out its urgent , please help me
822 Jun 2011 @ 10:51 PDTDatabaseTopicInteger value conversion to Time format Hi Team , im trying to convert the Integer value to Time field .But while inserting data to Database we facing an issue with an error INVALID OPERATION ON ANSI DATE/TIME we are trying t...
717 Jun 2011 @ 05:39 PDTDatabaseReplyNeed different values for same column thank u
617 Jun 2011 @ 03:57 PDTDatabaseTopicNeed different values for same column Need suggestion on my query . I have a query like this SELECT SUB.emp_id , SUB.VISIT_NUMBER , SUB.VISIT_DATETIME , SUB.VISIT_LENGTH , SUB.VIEW_LENGTH , COALESCE(ORD.ORDER_CHECKOUT,...
507 Jun 2011 @ 08:33 PDTDatabaseReplyCoverting INTEGER value to Date format Thank you for your reply carlosAL
407 Jun 2011 @ 05:24 PDTDatabaseReplyCoverting INTEGER value to Date format Thank you mjj ,But it is wrong for this format 100221
307 Jun 2011 @ 05:01 PDTDatabaseReplyCoverting INTEGER value to Date format any one please help me its urgent
207 Jun 2011 @ 04:13 PDTDatabaseTopicCoverting INTEGER value to Date format I have a scenario where my date value is there in INTEGER and the format is 40205 . Here 4 means 2004 and 02 is Month and 05 is Day i wanna convert this in to Date . When try to conv...
131 May 2011 @ 02:50 PDTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums!why period data type is powerful in teradata 13.0 . can any one explain how will period data type will improve the performance in teradata 13.0 instead of using general columns with date data typ...

Pages