58967 | 05 Aug 2016 @ 07:30 PDT | franceszhu | Database | Topic | A table with non-latin characters in table name and column names doesn't display properly | Hi, 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... |
58966 | 05 Aug 2016 @ 06:38 PDT | Glass | Database | Reply | User's DDL | sel * from dbc.users where username = 'youruser';
logon status from dbc.logonrules.
Rglass
|
58965 | 05 Aug 2016 @ 06:24 PDT | Cesco | Database | Topic | User's DDL | Hello 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... |
58964 | 05 Aug 2016 @ 05:58 PDT | wolfgang.neurauter | Teradata Studio | Reply | Getting row counts | Any news?
I use Teradata Studio Version 15.10.01 and it seems not working.
|
58963 | 05 Aug 2016 @ 05:33 PDT | jester666 | Teradata Database on AWS | Reply | pkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0 | I 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... |
58962 | 05 Aug 2016 @ 02:50 PDT | WAQ | Database | Topic | Teredata Error 5497: CALL cannot be submitted in multi-statement request | Hi,
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... |
58961 | 05 Aug 2016 @ 02:08 PDT | Vidhya Praveen Prabhu | General | Reply | Concatenate | 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... |
58960 | 05 Aug 2016 @ 02:07 PDT | larun1616 | Database | Topic | UNABLE TO CONNECT TERADATA STORED PROCEDURE FROM TABLEAU | I 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]" ... |
58959 | 05 Aug 2016 @ 02:03 PDT | frozenshine | Database | Reply | How do i write qualify rank() over (partition.....question | Hi,
subscriber1 || pkg1 || 23
Subscriber2 || pkg2 || 42
.
.
.
SubscriberN || pkg1 || 50
----------------------------------------------... |
58958 | 05 Aug 2016 @ 01:59 PDT | amittera | Database | Reply | TPT load in informatica giving CLI Error | If 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... |
58957 | 05 Aug 2016 @ 01:45 PDT | jester666 | Teradata Database on AWS | Reply | pkg_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:
... |
58956 | 05 Aug 2016 @ 01:13 PDT | mc200018 | Teradata Database on AWS | Reply | pkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0 | Please 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... |
58955 | 05 Aug 2016 @ 12:28 PDT | Smac | General | Reply | Multi Column Primary Index and Secondary Index | Thanks 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.
&... |
58954 | 04 Aug 2016 @ 11:50 PDT | Vidhya Praveen Prabhu | General | Reply | Concatenate | 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... |
58953 | 04 Aug 2016 @ 11:13 PDT | NewbieTD | Database | Reply | Comparing current column with next column and generating values dynamically | Hi All,
Any input on this. Is there any way to do it in sql.
Please help to solve this. Thanks in advance .
Thanks
|
58952 | 04 Aug 2016 @ 10:38 PDT | kamlesh114 | Database | Reply | skew factor | Thenk 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 ... |
58951 | 04 Aug 2016 @ 09:50 PDT | rakzrakz | Database | Topic | How to check View size in Teradata | In 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 ... |
58950 | 04 Aug 2016 @ 05:38 PDT | fgrimmer | Teradata Studio | Reply | Teradata session for volatile tables | Each 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.
|
58949 | 04 Aug 2016 @ 05:36 PDT | fgrimmer | Teradata Studio | Reply | Not working: Default connection for new SQL files | Because 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 ... |
58948 | 04 Aug 2016 @ 05:34 PDT | fgrimmer | Teradata Studio | Reply | Studio Express severe keyboard lag | Steven 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?
|
58947 | 04 Aug 2016 @ 05:10 PDT | SNguyenWF | Teradata Studio | Reply | Studio Express severe keyboard lag | I 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... |
58946 | 04 Aug 2016 @ 05:02 PDT | SNguyenWF | Teradata Studio | Topic | Teradata session for volatile tables | What 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... |
58945 | 04 Aug 2016 @ 05:00 PDT | SNguyenWF | Teradata Studio | Reply | Not working: Default connection for new SQL files | That's interesting. Then how come selecting Teradata is an option in the preferences?
|
58944 | 04 Aug 2016 @ 04:36 PDT | Prashant_20986 | Database | Topic | Concatenate, 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... |
58943 | 04 Aug 2016 @ 03:25 PDT | dbrown | Database | Reply | Need help with interdependent calculation using result from previous row | Dieter, 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... |