All forum activity

#DateUserForumTypeThreadPost
5896905 Aug 2016 @ 07:30 PDTfranceszhuDatabaseTopicA table with non-latin characters in table name and column names doesn't display properlyHi, I created a table with non-latin letters in both table name and its column names without any error. However, the table name and its column names are not displayed properly. They are all in rand...
5896805 Aug 2016 @ 06:38 PDTGlassDatabaseReplyUser's DDLsel * from dbc.users where username = 'youruser';   logon status from dbc.logonrules.   Rglass
5896705 Aug 2016 @ 06:24 PDTCescoDatabaseTopicUser's DDLHello everybody, Do you know if there is a way to know the DDL of an existing user? In addition, I need to know if a user has the logon privilege or not, but I can't find how can do it. &nbs...
5896605 Aug 2016 @ 05:58 PDTwolfgang.neurauterTeradata StudioReplyGetting row countsAny news? I use Teradata Studio Version 15.10.01 and it seems not working.    
5896505 Aug 2016 @ 05:33 PDTjester666Teradata Database on AWSReplypkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0I do not need to use exactly tdc-init and tdc-start, maybe there is other tools and scripts to init, reinit and start Teradata DB (f.i.  vprocmanager and tpa).  If so kindly ask you...
5896405 Aug 2016 @ 02:50 PDTWAQDatabaseTopicTeredata Error 5497: CALL cannot be submitted in multi-statement requestHi, I have a macro in which I have two statements. One is the SP call and the other one is a SELECT statement. The body of both SP and macro is given below: REPLACE PROCEDURE WAQ.DATA_VALIDATIO...
5896305 Aug 2016 @ 02:08 PDTVidhya Praveen PrabhuGeneralReplyConcatenate Hi All,   Finally I made it to simple  Sel DECODE(COL1,1,'COL1,') || DECODE(COL2,1,'COL2,') || DECODE(COL3,1,'COL3,') || DECODE(COL4,1,'COL4,') as...
5896205 Aug 2016 @ 02:07 PDTlarun1616DatabaseTopicUNABLE TO CONNECT TERADATA STORED PROCEDURE FROM TABLEAUI would need to pass value in the form of a Tableau Parameter to a Teradata Stored Procedure. On doing this I am getting an error "The stored procedure "[DATABASE].[PROCEDURE_NAME]" ...
5896105 Aug 2016 @ 02:03 PDTfrozenshineDatabaseReplyHow do i write qualify rank() over (partition.....questionHi, subscriber1  ||   pkg1  ||  23 Subscriber2 ||    pkg2  || 42  . . . SubscriberN || pkg1  || 50 ----------------------------------------------...
5896005 Aug 2016 @ 01:59 PDTamitteraDatabaseReplyTPT load in informatica giving CLI ErrorIf its nothing at the TPT end, then you can refer below that we did : 1)  increasing the timeout value to 740 seconds , but that s not the perm fix and can be checked with GSC. 2) We ch...
5895905 Aug 2016 @ 01:45 PDTjester666Teradata Database on AWSReplypkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0 mc200018, thank you for your reply! But all my links are in proper state. They link to python2.7. There are either no python 2.6 or links to python 2.6 in the system:   ...
5895805 Aug 2016 @ 01:13 PDTmc200018Teradata Database on AWSReplypkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0Please try make symbolic link python with installed python2.7 under /usr/bin directory. # python file linked with python2.6 ip-172-xx-xx-xx:/usr/bin # ls -ltr|grep -i python -rwxr-xr-x 1 root...
5895705 Aug 2016 @ 12:28 PDTSmacGeneralReplyMulti Column Primary Index and Secondary IndexThanks Fred. Basically its an snapshot table going to hold daily date. We will retrive the data on daily basis based on date and used to join multiple summary tables to generate report.   &...
5895604 Aug 2016 @ 11:50 PDTVidhya Praveen PrabhuGeneralReplyConcatenate Hi, Some how I have the got result using the DECODE function Sel DECODE(COL1,1,'COL1) || DECODE(COL2,1,'COL2) || DECODE(COL3,1,'COL3) || DECODE(COL4,1,'COL4) But now I need to add...
5895504 Aug 2016 @ 11:13 PDTNewbieTDDatabaseReplyComparing current column with next column and generating values dynamicallyHi All, Any input on this. Is there any way to do it in sql. Please help to solve this. Thanks in advance .   Thanks
5895404 Aug 2016 @ 10:38 PDTkamlesh114DatabaseReplyskew factorThenk you Pierre.. It happens some time when our database behave unexpectedly..   Even i checked practically and found that null values create same hash code ..so more nulls can cause high ...
5895304 Aug 2016 @ 09:50 PDTrakzrakzDatabaseTopicHow to check View size in TeradataIn Teradata DB, generally expectation would be to get the data size for a table, but for my task I need to identify size of a View. This view contains joins from 3 different tables and all I could ...
5895204 Aug 2016 @ 05:38 PDTfgrimmerTeradata StudioReplyTeradata session for volatile tablesEach SQL Editor tab uses its own connection/session. This allows for concurrent execution. You must perform your tasks on the volatile table within the same editor that the table is created.
5895104 Aug 2016 @ 05:36 PDTfgrimmerTeradata StudioReplyNot working: Default connection for new SQL filesBecause it grabs all of the known connection types and versions supported for this preference. You could select Teradata using the SQL File Editor but you don't get any of the features we have ...
5895004 Aug 2016 @ 05:34 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagSteven I have found a bug with the double click handler for the SQL Editor. Do you still see the problem if you don't double click on words in the editor?
5894904 Aug 2016 @ 05:10 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI also installed 32-bit version of Studio Express, but I still get the same issue.  I also uninstalled and then re-installed Java -- Issue still persists.  Same as before: Once I've b...
5894804 Aug 2016 @ 05:02 PDTSNguyenWFTeradata StudioTopicTeradata session for volatile tablesWhat constitutes a session for volatile tables.  I would naturally have thought that when opening multiple tabs that are connected to the same connection profile, volatile tables would be shar...
5894704 Aug 2016 @ 05:00 PDTSNguyenWFTeradata StudioReplyNot working: Default connection for new SQL filesThat's interesting.  Then how come selecting Teradata is an option in the preferences?
5894604 Aug 2016 @ 04:36 PDTPrashant_20986DatabaseTopicConcatenate, remove space, and convert into multiple records Compare table with spaces in between data, with table without spaces   Example:-     Table A has three fields: ID, Cd_1, and Cd_2   Fields: Cd_1 o...
5894504 Aug 2016 @ 03:25 PDTdbrownDatabaseReplyNeed help with interdependent calculation using result from previous rowDieter, you're right that this would work in the example given, but there are some instances where there are gaps between the end_date and the next sell_date, in which case I need to use the se...

Pages