| 59144 | 15 Aug 2016 @ 04:18 PDT | sk8s3i | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | Thank 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... |
| 59143 | 14 Aug 2016 @ 01:03 PDT | dnoeth | Database | Reply | Bteq 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... |
| 59142 | 14 Aug 2016 @ 11:43 PDT | HanC | Database | Topic | Bteq 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).
... |
| 59141 | 14 Aug 2016 @ 03:12 PDT | dnoeth | Tools | Reply | Understanding teradata sample scripts | You 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... |
| 59140 | 13 Aug 2016 @ 10:19 PDT | kchinnasamy@snaplogic.com | Tools | Topic | Understanding teradata sample scripts | Hi 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... |
| 59139 | 13 Aug 2016 @ 07:52 PDT | AVOT | Viewpoint | Topic | How to connect to viewpoint postgres database | Hi 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... |
| 59138 | 13 Aug 2016 @ 05:37 PDT | AVOT | Viewpoint | Topic | Restoring a Viewpoint database failed due to td_portal database | Hi 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... |
| 59137 | 13 Aug 2016 @ 05:12 PDT | sainagabharadwaj | Database | Reply | utf8TO16 : 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... |
| 59136 | 13 Aug 2016 @ 02:58 PDT | dnoeth | Tools | Reply | BTEQ and OReplace | Check 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.
|
| 59135 | 13 Aug 2016 @ 12:23 PDT | CarlosAL | Tools | Reply | BTEQ and OReplace | Hi.
And if the problem is in the .sql, why don't you post it instead of the shell script?
Cheers.
Carlos.
|
| 59134 | 12 Aug 2016 @ 12:57 PDT | BRIANH | Connectivity | Topic | CLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGON | I 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... |
| 59133 | 12 Aug 2016 @ 12:55 PDT | KellnerK | Tools | Topic | BTEQ and OReplace | I 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... |
| 59132 | 12 Aug 2016 @ 09:28 PDT | dnoeth | Database | Reply | Need help with interdependent calculation using result from previous row | This 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 ... |
| 59131 | 12 Aug 2016 @ 08:36 PDT | dbrown | Database | Reply | Need help with interdependent calculation using result from previous row | Anyone? Surely this can be done?
|
| 59130 | 12 Aug 2016 @ 08:17 PDT | dnoeth | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | Those 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 (... |
| 59129 | 12 Aug 2016 @ 08:06 PDT | ruhickson | Tools | Reply | Any way to find the original query that created a table? | Thanks for the tips, guys. Very useful!
|
| 59128 | 12 Aug 2016 @ 07:00 PDT | sk8s3i | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | I 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 ... |
| 59127 | 12 Aug 2016 @ 06:09 PDT | dnoeth | General | Reply | Improve performance on an analytical query , mulitple columns using same set of partitions | This 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... |
| 59126 | 12 Aug 2016 @ 06:05 PDT | dnoeth | General | Reply | Looking for help with regards to nested aggregates | Sorry, 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... |
| 59125 | 12 Aug 2016 @ 05:52 PDT | dnoeth | Tools | Reply | Any 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
|
| 59124 | 12 Aug 2016 @ 05:50 PDT | dnoeth | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | td_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
|
| 59123 | 12 Aug 2016 @ 04:22 PDT | sk8s3i | Database | Reply | Capturing MAX marks for Each Student when the MArks are in Columns | I 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... |
| 59122 | 12 Aug 2016 @ 04:10 PDT | nuaimi | Database | Reply | Teradata Tools and Utilities - Windows Installation Package Release 15.00.00.00 | yes its safe
|
| 59121 | 12 Aug 2016 @ 03:29 PDT | AtardecerR0j0 | Tools | Reply | Any 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... |
| 59120 | 12 Aug 2016 @ 01:14 PDT | ruhickson | Tools | Topic | Any 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?
|
