#DateForumTypeThreadPost
1017 Nov 2009 @ 06:12 PSTDatabaseTopicQuestion on InsertI have a table and the values need to be inserted from text file. The table is like this.Ext_id should be the first column.Ext_id Group_id Claim_Number 123 4375 12300T...
903 Nov 2009 @ 03:14 PSTDatabaseReplyLoading DateHi,Thanks for your reply. I still have issues.I created table like this.CREATE SET TABLE hccloh_ushare.test_date ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ...
802 Nov 2009 @ 11:41 PSTDatabaseTopicLoading DateI getting a records from text file and needs to be loaded into teradata. One of the filed is going to be date. The value i am getting from text file is like this '20091102'. How do I load this into...
712 Oct 2009 @ 04:35 PDTDatabaseReplyRename ViewThanks.
612 Oct 2009 @ 11:02 PDTDatabaseTopicRename ViewIs It possible to rename the VIEW itself without creating the new one?
525 Sep 2009 @ 01:50 PDTDatabaseReplyReversing of the fieldCan I Have any other better way???
424 Sep 2009 @ 05:39 PDTDatabaseTopicReversing of the fieldHi,I want to get the reverse value of the field from the table. Ex:I have field pat_name from patient table, I want to select the reverse of the pat_namePat_Name-------------JonesResult should bePa...
322 Sep 2009 @ 04:35 PDTDatabaseTopicInserting Null values into tableI am periodically updating one of my test table. When I insert a new record one of the fields is NULL. Can anyone tell me how to insert a NULL value to the field.?
203 Sep 2009 @ 10:35 PDTDatabaseReplyCount&Sub CountThanks guys. Worked Great.
102 Sep 2009 @ 11:09 PDTDatabaseTopicCount&Sub CountHi,I have table like this.compId CompName CompValue1 x ?1 x ?1 ...