#DateForumTypeThreadPost
1303 May 2013 @ 01:26 PDTDatabaseReplySQL to import string with comma (,) from a file using SQL AssistantNo, Dieter. I did not try before. I tested it now. It is working by selection option: Enclose column data in "Single Quotes". Thank you! I tested with above sample code. It's workin...
1202 May 2013 @ 08:02 PDTDatabaseReplyRecursive ViewMay be this is not the right way. but just throwing an idea. How about creating a another view with the same table defintions and data? or atleast a temporary table? So that we could jon these 2 t...
1102 May 2013 @ 07:49 PDTDatabaseReplySQL to import string with comma (,) from a file using SQL Assistantok. I got the temporary solution. Because we dont get pipe in the actual data. So, I saved the file with '|' as delimiter. then I changed the delimiter from comma to a pipe in TDA. Thanks!
1030 Apr 2013 @ 01:42 PDTDatabaseTopicSQL to import string with comma (,) from a file using SQL AssistantHi, I am trying to import data from a text file using a SQLAssitant. But it is giving me an error as the string contains ",". I am using this below syntax for inserting:   CREA...
924 Apr 2013 @ 01:05 PDTToolsReplyUpdating data in a table for multiple records from a file using ImportThanks, Dieter. I think I got the solution. for this I have created the temporary table and imported data from a file  then by using this temporary table I am updating the actual table using...
824 Apr 2013 @ 12:38 PDTGeneralReplyAutomated scripts to import flat files into Teradata??Hi Bill, can you please let me know if this worked for you or is there any other soltuion to it? I have a similiar situation like this: I have created a topic for the same. http://forums.teradata...
724 Apr 2013 @ 12:15 PDTToolsReplyUpdating data in a table for multiple records from a file using Import  Thanks, Dieter. MERGE INTO function is reqally useful for me in this case when I have only couple records. But, can we use this MERGE INTO along with INSERT INTO? I wanted to...
624 Apr 2013 @ 06:55 PDTToolsTopicUpdating data in a table for multiple records from a file using Importhi , Currently by using BTEQ and Teradata SQL assitant I am able to insert records into a table. But I want to update records in a table. I have more than 2000 records in a table and i have 200 re...
504 Feb 2013 @ 09:10 PSTConnectivityTopicTeradata_ICULibraries    Hi, I am trying to understand what is Teradata_ICULibraries_D and purpose of it.   I would really appriciate If someone could provide me littlr information or point ...
416 Jan 2013 @ 01:56 PSTTeradata ApplicationsReplySQL to pull dataThank you for your response, Qaisar.  Honestly, I didn't understand the solution you provided. if you could further explain, i would really appriciate it. Thanks much, Kumar
311 Jan 2013 @ 11:39 PSTTeradata ApplicationsTopicSQL to pull dataHi, I have one scenario and I am looking for your help. we have large DW with almost 10 different soruces with 400 tables. So, I want to know what are all sources are populating each table.  ...
205 Apr 2012 @ 08:08 PDTDatabaseTopicDifference between 'Number' and 'Integer' Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?   Thanks, Kumar  
129 Sep 2011 @ 07:47 PDTDatabaseTopicDate logic for SQL Hi, I have a table called Employee with Join Date and Last Date. This table may also contain future employees. Now I want to write a View to list all employees (current and future; but not previ...