All forum activity

#DateUserForumTypeThreadPost
5899407 Aug 2016 @ 09:28 PDTrdeshpandeDatabaseReplyNeed recursive SQL codeI 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
5899307 Aug 2016 @ 09:26 PDTrdeshpandeDatabaseReplyNeed recursive SQL codeDear 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...
5899207 Aug 2016 @ 06:09 PDTSmarakDasDatabaseReplyMy data mover job sometimes work and sometimes hangHello Neeraj,   Investigation of Hanging DM Jobs requires TD Support assistance. You should submit an Incident with T@Ys.   Thanks, Smarak
5899107 Aug 2016 @ 06:06 PDTSmarakDasDatabaseReplyMove 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 ...
5899006 Aug 2016 @ 09:05 PDTfgrimmerTeradata StudioReplyTeradata 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...
5898906 Aug 2016 @ 01:53 PDTabhishek.jadhavDatabaseReplyCannot view internal dbs control settings through viewpoint -teradata 1650 - Error Illegal optionTo 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...
5898806 Aug 2016 @ 01:31 PDTabhishek.jadhavDatabaseReplyUser's DDLLike 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....
5898706 Aug 2016 @ 04:57 PDTJohannes VinkDatabaseReplyUser's DDLMaybe, but I did not check, the new Teradata Studio can generate the SQL for you.
5898606 Aug 2016 @ 04:55 PDTJohannes VinkTeradata Database on VMWareReplyODBC on Teradata on VMIf 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.
5898506 Aug 2016 @ 04:41 PDTDPKKUMARARORADatabaseReplyConsolidate rows Please use below query for TD-14  or prior versions.       CREATE TABLE TEST.TEST_SCENARIO1   (   CATEGORY VARCHAR(2),   ...
5898406 Aug 2016 @ 03:15 PDTWAQDatabaseReplyTeredata Error 5497: CALL cannot be submitted in multi-statement requestThanks 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?
5898305 Aug 2016 @ 08:14 PDTFredGeneralReplyMulti Column Primary Index and Secondary IndexSo 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...
5898205 Aug 2016 @ 07:39 PDTFredToolsReplyFastload error: I/O Error on File Open 34Use a comma before FILE, not a semicolon.
5898105 Aug 2016 @ 07:34 PDTFredDatabaseReplyTeredata Error 5497: CALL cannot be submitted in multi-statement requestThe body of a macro is executed as a single request. If the macro contains more than one statement, it is a multi-statement request.
5898005 Aug 2016 @ 07:27 PDTFredDatabaseReplyUser's DDLThere 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...
5897905 Aug 2016 @ 07:20 PDTFredDatabaseReplyA table with non-latin characters in table name and column names doesn't display properlyWhat 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.
5897805 Aug 2016 @ 03:42 PDTtdcvgraoTeradata StudioReplyTeradata 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...
5897705 Aug 2016 @ 03:10 PDTfgrimmerTeradata StudioReplyTeradata session for volatile tablesYes, 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...
5897605 Aug 2016 @ 02:12 PDTfgrimmerTeradata StudioReplyGetting row countsWolfgang, 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).
5897505 Aug 2016 @ 02:06 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagOK, Let me know. We have fixed this issue in our upcoming 15.12 release (scheduled for mid September.
5897405 Aug 2016 @ 10:53 PDTpinkus05Teradata Database on VMWareTopicODBC on Teradata on VMI'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....
5897305 Aug 2016 @ 10:11 PDTmpmchicToolsTopicFastload error: I/O Error on File Open 34I 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)  ...
5897205 Aug 2016 @ 09:58 PDTNetFxConnectivityReplyConnecting to Teradata through PYODBC on MacLoad 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. ...
5897105 Aug 2016 @ 09:27 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagVery 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.
5897005 Aug 2016 @ 09:26 PDTSNguyenWFTeradata StudioReplyTeradata session for volatile tablesThere'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...

Pages