All forum activity

#DateUserForumTypeThreadPost
5796722 Jun 2016 @ 11:26 PDTtinazmuDatabaseReplyResponse Row size or Constant Row size overflowI know this post is quite old, but in case someone hits this problem and can't solve it by reducing the results: the same error is produced if the IN clause has too many items (or, perhaps, lar...
5796622 Jun 2016 @ 10:18 PDTjhsun3DatabaseTopichow to create variable table nameHi there,             I have a query that requires reading data from one table on weekly basis, however, when it is end of month, all queries...
5796522 Jun 2016 @ 06:13 PDTfeinholzToolsReplyTPT and Windows PowerShellCan you print out the PATH environment variable and send it? TPT looks at that in order to start up the application.
5796422 Jun 2016 @ 04:59 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagSteven, Have you looked into your graphics card. I found one thread that mentioned this same issue and when they switched the driver version for their NVIDIA card, it resolved the issue. Just wonde...
5796322 Jun 2016 @ 04:54 PDTtomnolanDatabaseReplyISOLATING A BLOCK OF TEXT FROM A LARGER BLOCK OF TEXT WITHIN 1 COLUMNThe regexp_similar function should provide what you need. select regexp_similar(results, '.*TITLE OF BLOCK.*(WORD2.*WORD4|WORD4.*WORD2).*Signed By.*', 'c') as words2and4 , resul...
5796222 Jun 2016 @ 04:43 PDTtomnolanDatabaseReplyHow to query specific time select * from MyTable where scan_tm = time '11:22:33'  
5796122 Jun 2016 @ 03:51 PDTfeinholzToolsReplyTdload failing with TPT02638: Error: Conflicting data lengthHow are you specifying the username, and what is the error you get?  
5796022 Jun 2016 @ 03:38 PDTFredTeradata Database on VMWareReplyConfused over which VM to downloadNote that this forum is intended mainly for Teradata Virtual Machine Edition on VMWare ESX / ESXi (TVME). See the Cloud Computing forum on this site for discussions related to Teradata Express for...
5795922 Jun 2016 @ 03:10 PDTGETeraTigerToolsReplyTdload failing with TPT02638: Error: Conflicting data lengthThis worked for me... Thanks!!!!   One more question tho... If I should open new thread, let me know and I will do it, but is there a way for TPT to accept usernames that start with an integ...
5795822 Jun 2016 @ 01:39 PDTrnadjafiDatabaseTopicISOLATING A BLOCK OF TEXT FROM A LARGER BLOCK OF TEXT WITHIN 1 COLUMNI'm a novice with SQL, but hoping someone can help.   It's for a cancer project, so you will be helping us save lives with your efforts.  Any assistance would be greatly appreciat...
5795722 Jun 2016 @ 01:33 PDTsrivigneshknToolsTopicTPT Failure : Output schema mismatch - Output varies from Server to Server. Hi All,    I am facing a strange issue with TPT script, I am trying to run TPT script against the same table in 2 different servers.   In the First Server : &n...
5795622 Jun 2016 @ 01:20 PDTzszmigieroAsterTopicHow to list all seqeunces?There is not system view to list all sequences. I found some information inside nc_all_columns but Aster provides GRANT on sequence without simple way to identify their names.
5795522 Jun 2016 @ 01:07 PDTopenboxDatabaseTopicHow to query specific timeHi, I'm just new in TD, need help on how to select a specific time?  the columns look like this:      store_id INTEGER NOT NULL,      scan_dt DATE F...
5795422 Jun 2016 @ 12:01 PDTSNguyenWFTeradata StudioTopicStudio Express severe keyboard lagI am experiencing severe keyboard lag with Studio Express ever since I installed it couple months ago.  It started with the previous version (15.10.1.1) and still exists with 15.11. My laptop...
5795322 Jun 2016 @ 11:27 PDTSunny445ToolsReplyBteq - Maintain Audit Infohey tushar, we are looking for the exact solution in our project. Did you get a change to develop the shell script..please share the logic if you did.   Thanks..!!
5795222 Jun 2016 @ 10:56 PDTfeinholzToolsReplyNeed Help regarding TPT ODBC OperatorYou are correct, my bad. I was unaware that our bundled drivers would act that way (but checked with the developer to make sure and you are correct). The bundled drivers will allow a 15 day trial...
5795122 Jun 2016 @ 10:54 PDTfeinholzToolsReplyTPT Work/error Tables always protected (FALLBACK) ?The error tables are created as FALLBACK for the protection of the user so that the jobs can run in the event of a down AMP in a cluster. Right now there is no way for the user to indicate to us t...
5795022 Jun 2016 @ 09:00 PDTfgrimmerTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Teradata has the ability to nest Databases and Users within other Databases and Users. You can also turn off the 'Show Databaseas and Users in Hierarchical Display' preference if you just w...
5794922 Jun 2016 @ 06:55 PDTNiteshMDatabaseReplyRecursive Query Vs UNIONHi Dieter, Thanks a lot , this saved our day :)    Thanks
5794822 Jun 2016 @ 06:44 PDTmhusseyTeradata StudioReplyTeradata Studio does not show all of my authorized tables-Thanks Fred! That helps out a ton. I appreciate all of your help. At this point, my issue has been resolved. You are all great!
5794722 Jun 2016 @ 06:24 PDTAtardecerR0j0GeneralReplyRetrieve columns having a specific valueThe columntype filter depends on data type, I was supposing the data type was char or varchar
5794622 Jun 2016 @ 06:23 PDTAtardecerR0j0GeneralReplyRetrieve columns having a specific valueYou can write the filter condition using a dynamic SQL like this: select trim(columnname)||'=''ABC'' or ' from dbc.columns where databasename='YourDabaBase' ...
5794522 Jun 2016 @ 04:23 PDTstami27ToolsReplyTPT Work/error Tables always protected (FALLBACK) ?Thank you, but your contribution does not help me. Reques for a response from a TPT specialist. Thanks
5794422 Jun 2016 @ 04:08 PDTAtardecerR0j0DatabaseReplyIdentifying which column is throwing error on INSERT select * from YOUR_TABLE where to_number(trim(COL_N),'9999999999') is null With this one you can discover about wrong data. Repead this operation with all the columns or include the ...
5794322 Jun 2016 @ 01:24 PDTM.Saeed KhurramToolsReplyTPT Work/error Tables always protected (FALLBACK) ?Hi, I think you need to contact Customer Support, there is a global paramter for tables to be fallback or not fallback. But you will have to consider lot of things before disabling this option. B...

Pages