Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Null vs Empty
Thanks for the inputs As there is no space in the column D, so trim does not work, neither does (D IS NULL) It's very strange, I don't understand why that sort of data could be entered into the table Here is the column info Type: CV Nullable:Y Format: X(255) MaxLength: 255 UpperCase: N...- mittit
- Post #4
- Forum: NCR: Teradata
-
Null vs Empty
I have got a problem handling some records which have a couple of columns (A, B, C) with Null value representing with the ? sign. Also, those records have another column (D) which is totally empty. I want to exclude those records with empty D column but don't know what criteria to put in to...- mittit
- Thread
- Replies: 5
- Forum: NCR: Teradata
-
Import data from a tap-delimited file
Well, this is the scenario I am working with Teradata RDBMS from 2 servers P, D. I have got an answer set from P and exported to a txt file in my workstation and want to import that table into the D server. Given that I have only Queryman 6 to do the task and don't want to create a table...- mittit
- Post #3
- Forum: NCR: Teradata
-
Import data from a tap-delimited file
Could anyone show me how to import data from a tab-delimited file (txt or csv) into a new Teradata table without having to write the CREATE TABLE statement again, given the column names defined in the source txt file? Is there a import function similar to the DTS in SQL Server?- mittit
- Thread
- Replies: 3
- Forum: NCR: Teradata
