All forum activity

#DateUserForumTypeThreadPost
5914215 Aug 2016 @ 04:18 PDTsk8s3iDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsThank you Dieter!   I did check using dbc.FunctionsV for the function 'GREATEST', and I got one row in result set:   Databasename: SYSLIB FunctionName: GREATEST SpecificName...
5914114 Aug 2016 @ 01:03 PDTdnoethDatabaseReplyBteq import the output characters got cut off by 2 #: When you define IMPORT VARTEXT all fields must be defined a VARCHAR #2: You need to quote the filename when you want to add command options: #3: You better add PACK to speed up the import &nb...
5914014 Aug 2016 @ 11:43 PDTHanCDatabaseTopicBteq import the output characters got cut off by 2 Can anyone please help? I have a source text file look like below char(10), 20K count of records,  but the output got only 8 characters and the last two got cut off (i.e. 12345678).   ...
5913914 Aug 2016 @ 03:12 PDTdnoethToolsReplyUnderstanding teradata sample scriptsYou mean the scripts found in Teradata\Client...? Those are examples for TPT (Teradata Parallel Transporter).   Files in quickstart are based on the TPT Quick Start Guide and userguide...
5913813 Aug 2016 @ 10:19 PDTkchinnasamy@snaplogic.comToolsTopicUnderstanding teradata sample scriptsHi Guys, I'm new to Terdata so trying to understand the sample/qstart programs in the Teradata dir. I was looking into the qstart1, and didn't understand where definition of the OPERA...
5913713 Aug 2016 @ 07:52 PDTAVOTViewpointTopicHow to connect to viewpoint postgres databaseHi all, How can i connect to postgres Viewpoint database.  I would like to dcs db, cam db and other related databases and run queries against that schema.  Please let me know how to co...
5913613 Aug 2016 @ 05:37 PDTAVOTViewpointTopicRestoring a Viewpoint database failed due to td_portal databaseHi all, I have tried the following scenario: 1. I have created a tar.zip file for the /data/backup directory in Viewpoint Application Server. This folder consists of the td_portal, td_portlets, c...
5913513 Aug 2016 @ 05:12 PDTsainagabharadwajDatabaseReplyutf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?Hi Dieter, Thanks for sharing the info. One issue am facing currently. Inserting chinese characters (for eg) into a table with Unicode column is working fine but running the same via worflow...
5913413 Aug 2016 @ 02:58 PDTdnoethToolsReplyBTEQ and OReplaceCheck the datatype returned by oReplace, it's probably a VarChar(8000), but your .WIDTH is set to 2000, which leads to truncation. You need to cast to a properly sized VarChar.
5913313 Aug 2016 @ 12:23 PDTCarlosALToolsReplyBTEQ and OReplaceHi. And if the problem is in the .sql, why don't you post it instead of the shell script? Cheers. Carlos.
5913212 Aug 2016 @ 12:57 PDTBRIANHConnectivityTopicCLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGONI have run several tests using BTEQ and have altered between logging on using an IP and a name in the Windows hosts file. I have noticed that the logon process takes an extended period of time whe...
5913112 Aug 2016 @ 12:55 PDTKellnerKToolsTopicBTEQ and OReplaceI have written a SQL statement using the oReplace function and it works fine within SQL Assistant.  When I run the .sql file through BTEQ however and output the resulting file as a .CSV, every...
5913012 Aug 2016 @ 09:28 PDTdnoethDatabaseReplyNeed help with interdependent calculation using result from previous rowThis seems to be similar to forums.teradata.com/forum/database/calculation-of-prescription-drug-adherence   If this matches you need to materialize a row_number in a Volatile table and ...
5912912 Aug 2016 @ 08:36 PDTdbrownDatabaseReplyNeed help with interdependent calculation using result from previous rowAnyone? Surely this can be done?
5912812 Aug 2016 @ 08:17 PDTdnoethDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsThose functions found in syslib are some old pre-TD14.10 UDFs, if you don't qualify the function name they will be found/used instead of td_sysfnlib.greatest. The names are due to overloading (...
5912712 Aug 2016 @ 08:06 PDTruhicksonToolsReplyAny way to find the original query that created a table?Thanks for the tips, guys. Very useful!
5912612 Aug 2016 @ 07:00 PDTsk8s3iDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsI checked for any other UDF with the same name and I found just one function with this name.   I issued the folloing query to check if there are any other functions with the same name and I ...
5912512 Aug 2016 @ 06:09 PDTdnoethGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitionsThis is the best plan you can get, the optimizer combines all OLAP steps with the same partition/order.   Standard SQL syntax supports a WINDOW clause (not supported in Teradata) which avoid...
5912412 Aug 2016 @ 06:05 PDTdnoethGeneralReplyLooking for help with regards to nested aggregatesSorry, but I don't get what you're trying to do with your sample data and expected result.   If your "reporting solution" doesn't support subqueries/Derived Table you b...
5912312 Aug 2016 @ 05:52 PDTdnoethToolsReplyAny way to find the original query that created a table?Or you check the CreatorName & CreateTimestamp and try to find the query in the QueryLog history
5912212 Aug 2016 @ 05:50 PDTdnoethDatabaseReplyCapturing MAX marks for Each Student when the MArks are in Columnstd_sysfnlib.GREATEST accepts up to 10 parameters. Check if there's another UDF with the same name in the search path:  default database -> syslib -> td_sysfnlib
5912112 Aug 2016 @ 04:22 PDTsk8s3iDatabaseReplyCapturing MAX marks for Each Student when the MArks are in ColumnsI am using TD14.10 release and SELECT GREATEST (50,100,70) throws an error in TERA Mode. The error I got was: "SELECT Failed. 9881: Function 'greatest' called with an invalid number or...
5912012 Aug 2016 @ 04:10 PDTnuaimiDatabaseReplyTeradata Tools and Utilities - Windows Installation Package Release 15.00.00.00yes its safe
5911912 Aug 2016 @ 03:29 PDTAtardecerR0j0ToolsReplyAny way to find the original query that created a table? select requestText from dbc.tables where tablename='tablename' and databasename='databasename' ; Keep in mind that on this way if you modified a table with "Alter tabl...
5911812 Aug 2016 @ 01:14 PDTruhicksonToolsTopicAny way to find the original query that created a table?Hi everyone, Is there a quick way to find the query used to create a table in SQL Assistant? Not the SHOW TABLE function, but a function to recreate the original query?

Pages