#DateForumTypeThreadPost
27331 Mar 2010 @ 11:53 PDTGeneralReplysample input files to load table using Fastload utilityHi, 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. ...
27231 Jul 2009 @ 06:32 PDTDatabaseReplyHow to check if data is in upper case or notHello,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...
27130 Jul 2009 @ 05:39 PDTUDAReplyto get datatypes of all column from tableUsually 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-...
27030 Jul 2009 @ 05:06 PDTUDAReplyto get datatypes of all column from tableSELECT 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...
26927 Jul 2009 @ 11:40 PDTDatabaseReplyTab in columnHello,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...
26822 Jul 2009 @ 11:11 PDTUDAReplyTeradata V2 R13a small correction .... there is nothing called as 'Teradata V2 R13', it is instead 'Teradata 13'.Regards,Adeel
26714 Jul 2009 @ 11:58 PDTUDAReplyFormatting decimal fields while exportingNice Dieter! :)
26614 Jul 2009 @ 07:14 PDTUDAReplyFormatting decimal fields while exportingBy 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
26514 Jul 2009 @ 01:54 PDTUDAReplyFormatting decimal fields while exportingHello,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...
26413 Jul 2009 @ 07:06 PDTDatabaseReplyStrange Probleminteresting .... 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...
26313 Jul 2009 @ 06:57 PDTDatabaseReplyStrange ProblemHello,Can you provide the sample insert script you are using? And are you using temporary tables or not?Regards,Adeel
26213 Jul 2009 @ 06:19 PDTToolsReplyQuery execution in teradatea sql assistant 12.0Hello,In the SQL Assistant goto:Tools => Options => Query TabAnd check the following:"Submit only the selected query text, when highlighted"HTH!Regards,Adeel
26108 Jul 2009 @ 09:37 PDTDatabaseReplyProblems when I'm creating a stored procedureAs 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...
26006 Jul 2009 @ 03:52 PDTDatabaseReplyBind VariablesHello,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...
25906 Jul 2009 @ 02:33 PDTUDAReplyTeraData vs OracleHello,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...
25803 Jul 2009 @ 05:36 PDTToolsReplyUsing Parameter in BTEQHello,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...
25702 Jul 2009 @ 07:10 PDTDatabaseReplyUrgent NeedThanks! .... the priceless happiness & joy in such replies in the motivating factor to provide more answers! :)
25602 Jul 2009 @ 06:16 PDTDatabaseReplyUrgent NeedHello,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...
25528 Jun 2009 @ 11:22 PDTDatabaseReplySELECT as a field into an INSERTHello,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
25428 Jun 2009 @ 11:15 PDTToolsReplyDifferences between Macro and Stored procedueHello,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...
25326 Jun 2009 @ 05:49 PDTToolsReplyIssues with EXPORT OUTPUT DATE FIELD is not coming correctlyHello,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
25225 Jun 2009 @ 05:45 PDTUDAReplySeaching for particular databasesHello,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
25124 Jun 2009 @ 07:23 PDTUDAReplyUpdate Strategy with TeradataHello,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...
25017 Jun 2009 @ 01:01 PDTDatabaseReplyHow 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...
24917 Jun 2009 @ 12:25 PDTDatabaseReplyHow 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...

Pages