#DateForumTypeThreadPost
1720 Nov 2011 @ 11:55 PSTToolsTopicDELIMITER IN DATA Hello everyone, Suppose  columns in my table are - ID integer, Description varchar(100), Price decimal (5,2). Suppose my data row in flat file is like - 101,mad...
1612 Jul 2011 @ 10:27 PDTDatabaseReplymload for multiple tablesHi CarlosAL, I tried to run your script, but its giving errors. Can you please post the script with corrections needed. Thank you.
1512 Jul 2011 @ 09:53 PDTDatabaseReplymload for multiple tablesHi CarlosAL! Thanks for your reply. please let me know is there any alternate way other than 'format text' to achieve the task . MLOAD task ---------------- 1.different length rows (from di...
1412 Jul 2011 @ 07:56 PDTDatabaseReplymload for multiple tablesHi Indra, the format used is 'text'.thats why we need to use 'char'. 'filler' wont work with 'varchar'.
1312 Jul 2011 @ 06:39 PDTDatabaseTopicmload for multiple tableshello all, i have an mload script which is giving error. please help in resolving that. mload script: ---------------------- .logtable banklog; .logon xxxx/abcd,xyz; .begin mload tabl...
1209 Jun 2011 @ 11:30 PDTDatabaseTopicSQL help?an employee changed his address from 'address1' to 'address2' . i want to see both details of that employee from this time period to the last . write a query? Thanks&Regards, Vamsi.
1129 May 2011 @ 08:52 PDTGeneralTopicCLDMHI all, I want to know about Communication Logical Data Model(CLDM) and Health care Data Model (HCDM). Please help me with the information. Thank you
1026 May 2011 @ 01:31 PDTToolsReplysample FLOAD,MLOAD and FAST EXPORT scriptsHi try this. save the excel file as file.csv and try.
925 May 2011 @ 02:44 PDTDatabaseTopicdate Hi all, in my table a date column is there. It contains data as '01/12/99' '03/23/06' . how to convert them as '01/12/1999', '03/23/2006'.
824 May 2011 @ 12:45 PDTDatabaseReplycount(*)Thank you very much Jimm and Suhel.m
722 May 2011 @ 08:32 PDTDatabaseTopiccount(*)Hi all! I have tableA,tableB. COUNT(*) FROM TABLEA GIVES 1000 , COUNT(*) FROM TABLEB GIVES 2000. i need a query to get output as tablea tableb 1000 2000 i want to get both ta...
622 May 2011 @ 07:11 PDTUDATopicCLDM HI all, I want to know about Communication Logical Data Model(CLDM) and Health care Data Model (HCDM). Please help me with the information. Thank you
522 May 2011 @ 10:58 PDTGeneralTopicCLDMHI all, I want to know about Communication Logical Data Model(CLDM) and Health care Data Model (HCDM). Please help me with the information. Thank you.
421 May 2011 @ 11:35 PDTGeneralReplywithout 'LIKE'?Hi Blaine VandeBerg! Its working.Thank you very much for your support.
321 May 2011 @ 07:22 PDTGeneralTopicwithout 'LIKE'?Hi frnds! Can anybody tell me solution for this-- select all the names in a column which are starting with letter 'b' . but without using 'LIKE' operator? Vamsi.
213 May 2011 @ 02:40 PDTUDATopicwhat happens?Hi all, I am new to teradata. can anybody explain me what happens(like hashing,subtable,row distribution etc) in the PE,AMP and other componants when we are (1)inserting a row (2)retrieving a r...
101 Mar 2011 @ 11:04 PSTDatabaseTopichow to delete a journalHi in my database there is a journal with name 'journals'. using 'modify database as drop default journal journals' it is not being dropped. how to drop it? Actually I want to drop the database...