273 | 31 Mar 2010 @ 11:53 PDT | General | Reply | sample input files to load table using Fastload utility | Hi,
For that my suggestion will be to use Teradata Documentation, which is copied to your local system in TD Express installation .... you can get sample script and data file format from there.
... |
272 | 31 Jul 2009 @ 06:32 PDT | Database | Reply | How to check if data is in upper case or not | Hello,I believe there is no built-in function to do that .... though, you can use UPPER/LOWER functions to get the desired case of the data.Though, there are ways to check the case of the given cha... |
271 | 30 Jul 2009 @ 05:39 PDT | UDA | Reply | to get datatypes of all column from table | Usually it is good to try your best as well! :)Here is the link: http://www.info.teradata.com/Why don't you just do a "SELECT * FROM DBC.COLUMNS" and checkout the columns .... they are pretty self-... |
270 | 30 Jul 2009 @ 05:06 PDT | UDA | Reply | to get datatypes of all column from table | SELECT TRIM(DatabaseName) AS "DatabaseName", TRIM(TableName) AS "TableName", TRIM(ColumnName) AS "ColumnName", ColumnType FROM DBC.COLUMNS WHERE TableName = 'TableName';For exact data-types and t... |
269 | 27 Jul 2009 @ 11:40 PDT | Database | Reply | Tab in column | Hello,CHR and ASCII are not Teradata built-in functions. If anyone is able to execute those functions, then off-course UDFs (most probably OracleUDFs) are installed on that Teradata system.And it h... |
268 | 22 Jul 2009 @ 11:11 PDT | UDA | Reply | Teradata V2 R13 | a small correction .... there is nothing called as 'Teradata V2 R13', it is instead 'Teradata 13'.Regards,Adeel |
267 | 14 Jul 2009 @ 11:58 PDT | UDA | Reply | Formatting decimal fields while exporting | Nice Dieter! :) |
266 | 14 Jul 2009 @ 07:14 PDT | UDA | Reply | Formatting decimal fields while exporting | By the way .... why exactly do you need "0.123" to be ".123" .... ?What you can do is, in your SELECT cast the formated value to VARCHAR and TRIM the LEADING "0"s. That should work.Regards,Adeel |
265 | 14 Jul 2009 @ 01:54 PDT | UDA | Reply | Formatting decimal fields while exporting | Hello,You can use anyone of the following:- TRIM(LEADING '0' FROM fld) or- TRIM(BOTH '0.' FROM fld) or- Cast it to VARCHAR and then export, or- Use FORMAT as follows: SELECT CAST('0.001' AS DECIM... |
264 | 13 Jul 2009 @ 07:06 PDT | Database | Reply | Strange Problem | interesting .... but there must be someone or something causing 'data to disappear'! .... thinking aloud .... have you tried copying to other DB? and/or checking with peers if anybody is doing this... |
263 | 13 Jul 2009 @ 06:57 PDT | Database | Reply | Strange Problem | Hello,Can you provide the sample insert script you are using? And are you using temporary tables or not?Regards,Adeel |
262 | 13 Jul 2009 @ 06:19 PDT | Tools | Reply | Query execution in teradatea sql assistant 12.0 | Hello,In the SQL Assistant goto:Tools => Options => Query TabAnd check the following:"Submit only the selected query text, when highlighted"HTH!Regards,Adeel |
261 | 08 Jul 2009 @ 09:37 PDT | Database | Reply | Problems when I'm creating a stored procedure | As clearly defined in the error message .... you need to have CREATE PROCEDURE rights on the database for the user you are using!You (DB admin) can either do that using Teradata Administrator or by... |
260 | 06 Jul 2009 @ 03:52 PDT | Database | Reply | Bind Variables | Hello,What exactly are you trying to do?If you are using SQL Assistant and need to take user's input and then use it, you may please refer to following:http://www.teradata.com/teradataforum/Topic12... |
259 | 06 Jul 2009 @ 02:33 PDT | UDA | Reply | TeraData vs Oracle | Hello,I don’t intent to say anything bad about any individual or any RDBMS .... no offense at all! :)I genuinely believe it all depends on the requirements & exactly how you plan to use the RDBMS... |
258 | 03 Jul 2009 @ 05:36 PDT | Tools | Reply | Using Parameter in BTEQ | Hello,Following can solve your problem:Suppose we have BTEQ script as Script.bteq, which contains following calls (SP or Macro whatever it may be):.logon .... ; EXEC Macro1(DATE_PARAMETER_VALUE); E... |
257 | 02 Jul 2009 @ 07:10 PDT | Database | Reply | Urgent Need | Thanks! .... the priceless happiness & joy in such replies in the motivating factor to provide more answers! :) |
256 | 02 Jul 2009 @ 06:16 PDT | Database | Reply | Urgent Need | Hello,How about only using 1 parameter with following query:SELECT * FROM Table1 WHERE DateColumn1 >= ADD_MONTHS(:Month_Start,-1) AND DateColumn1 < Month_Start;Or, you can do following in the... |
255 | 28 Jun 2009 @ 11:22 PDT | Database | Reply | SELECT as a field into an INSERT | Hello,You can also use the following:INSERT Table1 (ID, Field1, Field2)SELECT MAX(ID) + 1 AS "ID" ,'Name' AS "Field1" ,'001' AS "Field2"FROM Table2;HTH!Regards,Adeel |
254 | 28 Jun 2009 @ 11:15 PDT | Tools | Reply | Differences between Macro and Stored procedue | Hello,Following are few differences between MACRO and Stored-Procedure:MACRO:- Limited procedural logic- Can return multi row answer sets for the same request- Multi-statement request paralleliz... |
253 | 26 Jun 2009 @ 05:49 PDT | Tools | Reply | Issues with EXPORT OUTPUT DATE FIELD is not coming correctly | Hello,Integer-date has a length 4, there is no issue with that. Try by casting it to CHAR/VARCHAR, that should solve the issue.HTH!Regards,Adeel |
252 | 25 Jun 2009 @ 05:45 PDT | UDA | Reply | Seaching for particular databases | Hello,Couple points to share, one DBC.Columns contains all the Columns information system-wide. Second, how about adding the limit on DatabaseName's length to 8?HTH!Regards,Adeel |
251 | 24 Jun 2009 @ 07:23 PDT | UDA | Reply | Update Strategy with Teradata | Hello,The concepts of INDEX and KEY, though share some common attributes, but are pretty different. INDEX is the physical concept where as KEY is the logical concept.All you need to do is to mark t... |
250 | 17 Jun 2009 @ 01:01 PDT | Database | Reply | How to speed up inserting data into volatile table ? | We once faced such scenario in one of the projects, we had to insert around 40 rows in VT table having single column .... with INSERT statement in SQL Assistant it was taking about 2-3 minutes. Aft... |
249 | 17 Jun 2009 @ 12:25 PDT | Database | Reply | How to speed up inserting data into volatile table ? | Hello,You can try by removing SET from the CREATE command and ensuring uniqueness of records while inserting into it or while retrieving data from the volatile table.And you may also check the curr... |