13 | 03 May 2013 @ 01:26 PDT | Database | Reply | SQL to import string with comma (,) from a file using SQL Assistant | No, 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... |
12 | 02 May 2013 @ 08:02 PDT | Database | Reply | Recursive View | May 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... |
11 | 02 May 2013 @ 07:49 PDT | Database | Reply | SQL to import string with comma (,) from a file using SQL Assistant | ok. 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!
|
10 | 30 Apr 2013 @ 01:42 PDT | Database | Topic | SQL to import string with comma (,) from a file using SQL Assistant | Hi, 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... |
9 | 24 Apr 2013 @ 01:05 PDT | Tools | Reply | Updating data in a table for multiple records from a file using Import | Thanks, 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... |
8 | 24 Apr 2013 @ 12:38 PDT | General | Reply | Automated 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... |
7 | 24 Apr 2013 @ 12:15 PDT | Tools | Reply | Updating 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... |
6 | 24 Apr 2013 @ 06:55 PDT | Tools | Topic | Updating data in a table for multiple records from a file using Import | hi , 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... |
5 | 04 Feb 2013 @ 09:10 PST | Connectivity | Topic | Teradata_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 ... |
4 | 16 Jan 2013 @ 01:56 PST | Teradata Applications | Reply | SQL to pull data | Thank 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
|
3 | 11 Jan 2013 @ 11:39 PST | Teradata Applications | Topic | SQL to pull data | Hi, 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.
... |
2 | 05 Apr 2012 @ 08:08 PDT | Database | Topic | Difference between 'Number' and 'Integer' |
Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?
Thanks,
Kumar
|
1 | 29 Sep 2011 @ 07:47 PDT | Database | Topic | Date 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... |