58992 | 07 Aug 2016 @ 09:28 PDT | rdeshpande | Database | Reply | Need recursive SQL code | I asked the same question on Oracle forum and got the answer but unable to convert the syntax to Teradata.
Here is the link.
https://community.oracle.com/thread/3949146
|
58991 | 07 Aug 2016 @ 09:26 PDT | rdeshpande | Database | Reply | Need recursive SQL code | Dear AtardecerR0j0,
Sorry for late reply. Thanks for your help. But their is one problem with your code.
For mobile number F here is the output from your code:
F 1/1/2016 19:51:09.000000... |
58990 | 07 Aug 2016 @ 06:09 PDT | SmarakDas | Database | Reply | My data mover job sometimes work and sometimes hang | Hello Neeraj,
Investigation of Hanging DM Jobs requires TD Support assistance. You should submit an Incident with T@Ys.
Thanks, Smarak
|
58989 | 07 Aug 2016 @ 06:06 PDT | SmarakDas | Database | Reply | Move data from one Teradata DB(Prod Server)to another Teradata DB (dev Server) | Hello Kartaj,
DM can moves 40 tables in a single DM Job {It can move multiple databases in 01 Job as well}. You just need to create the DM Job once & run it as per your requirement. Depending ... |
58988 | 06 Aug 2016 @ 09:05 PDT | fgrimmer | Teradata Studio | Reply | Teradata Studio does not show all of my authorized tables- | @tdcvgrao, Are you connecting to Teradata? One possibility is that the Views used to load the Databases list was changed in the preference. The default is set tos us the DBC.DatabasesV. Can y... |
58987 | 06 Aug 2016 @ 01:53 PDT | abhishek.jadhav | Database | Reply | Cannot view internal dbs control settings through viewpoint -teradata 1650 - Error Illegal option | To view DBS Control Record - Internal Fields, enter the following command
mod systemfe=T
It will say
WARNING: Running DBSControl in SystemFE mode may result in inconsistent system behavior... |
58986 | 06 Aug 2016 @ 01:31 PDT | abhishek.jadhav | Database | Reply | User's DDL | Like others mentioned there is no direct way that will show the DDL of any user.In addition what is mentioned in above replies you can try the below steps and see if thats what you are looking for.... |
58985 | 06 Aug 2016 @ 04:57 PDT | Johannes Vink | Database | Reply | User's DDL | Maybe, but I did not check, the new Teradata Studio can generate the SQL for you.
|
58984 | 06 Aug 2016 @ 04:55 PDT | Johannes Vink | Teradata Database on VMWare | Reply | ODBC on Teradata on VM | If I remember it correct tdicu is listed as a dependency for tdodbc, but I never installed it. tdicu is for some language dependend messages. We stayed on English and no problems so far.
|
58983 | 06 Aug 2016 @ 04:41 PDT | DPKKUMARARORA | Database | Reply | Consolidate rows |
Please use below query for TD-14 or prior versions.
CREATE TABLE TEST.TEST_SCENARIO1
(
CATEGORY VARCHAR(2),
... |
58982 | 06 Aug 2016 @ 03:15 PDT | WAQ | Database | Reply | Teredata Error 5497: CALL cannot be submitted in multi-statement request | Thanks Fred for your response. So Can't we do it the way I am trying to do?
Macros can have more than one SQL statement but can't we add a SP call with the SQL or any other statement in the macro? |
58981 | 05 Aug 2016 @ 08:14 PDT | Fred | General | Reply | Multi Column Primary Index and Secondary Index | So with either PI, you will scan the table. If you partition on BUS_DATE then you don't have to scan the entire table; you can do that with either PI.
If you need the database to enfor... |
58980 | 05 Aug 2016 @ 07:39 PDT | Fred | Tools | Reply | Fastload error: I/O Error on File Open 34 | Use a comma before FILE, not a semicolon.
|
58979 | 05 Aug 2016 @ 07:34 PDT | Fred | Database | Reply | Teredata Error 5497: CALL cannot be submitted in multi-statement request | The body of a macro is executed as a single request.
If the macro contains more than one statement, it is a multi-statement request.
|
58978 | 05 Aug 2016 @ 07:27 PDT | Fred | Database | Reply | User's DDL | There is nothing like a "SHOW" statement that will generate a CREATE USER for you. You would need to reverse engineer the values from the dictionary columns yourself. Also the UsersV view... |
58977 | 05 Aug 2016 @ 07:20 PDT | Fred | Database | Reply | A table with non-latin characters in table name and column names doesn't display properly | What is your session character set? Both the CREATE and the SHOW need to use something other than ASCII, e.g. UTF8, UTF16, or one of the optional special character sets.
|
58976 | 05 Aug 2016 @ 03:42 PDT | tdcvgrao | Teradata Studio | Reply | Teradata Studio does not show all of my authorized tables- | Hi mhussy, I have similar issue of showing first day all the databases and then disappeared on the second day. I have been trying all the possible ways and following forums... it seems it worked fo... |
58975 | 05 Aug 2016 @ 03:10 PDT | fgrimmer | Teradata Studio | Reply | Teradata session for volatile tables | Yes, it should persist the same connection across multiple files. Although I am finding an issue when I try this. I will look into it further, but that it what it is supposed to do.
If the s... |
58974 | 05 Aug 2016 @ 02:12 PDT | fgrimmer | Teradata Studio | Reply | Getting row counts | Wolfgang, The fix for 'the actual row count to be displayed in the pop up window' is available in our upcoming 15.12 release (scheduled for mid September).
|
58973 | 05 Aug 2016 @ 02:06 PDT | fgrimmer | Teradata Studio | Reply | Studio Express severe keyboard lag | OK, Let me know. We have fixed this issue in our upcoming 15.12 release (scheduled for mid September.
|
58972 | 05 Aug 2016 @ 10:53 PDT | pinkus05 | Teradata Database on VMWare | Topic | ODBC on Teradata on VM | I'm trying to connect to Teradata Express on Vmware, and I get this error: {error} STATE=01000 CODE=0 MSG=[unixODBC][Driver Manager]Can't open lib '/opt/teradata/client/odbc/tdata.... |
58971 | 05 Aug 2016 @ 10:11 PDT | mpmchic | Tools | Topic | Fastload error: I/O Error on File Open 34 | I have a large text file with 366 columns, pipe delimited. Fastload fails with this error: Error : I/O Error on File Open: 34, Text: pmUnxDskOpen: fopen error (Invalid argument)
... |
58970 | 05 Aug 2016 @ 09:58 PDT | NetFx | Connectivity | Reply | Connecting to Teradata through PYODBC on Mac | Load the iODBC Data Source Administrator tool; select the Drivers tab and check for the Teradata Driver. Most likely the Teradata ODBC Driver is not registered with the iODBC Driver Manager. ... |
58969 | 05 Aug 2016 @ 09:27 PDT | SNguyenWF | Teradata Studio | Reply | Studio Express severe keyboard lag | Very interesting. I double click words all the time! That could be the issue. I'll try to avoid doing that and see if the issue goes away.
|
58968 | 05 Aug 2016 @ 09:26 PDT | SNguyenWF | Teradata Studio | Reply | Teradata session for volatile tables | There's an option in preferences labeled "Persist the target connection information when executing multiple SQL files". Does this persist the same connection across multiple tab... |