#DateWhereItemComment
2624 May 2013 @ 07:23 PDTkeep it simpleCalculation of Table Hash Values to Compare Table ContentHi Suhail, sorry no :).  Ulrich
2521 May 2013 @ 01:01 PDTUDAIntroducing TDM into a production Dual System environmentHi Paul, I would be careful using the checksum script above. Due to the high number of hash synonyms it can happen that different tables will create the same checksum. Check database your_db; ...
2424 Apr 2013 @ 02:42 PDTApplicationsIn-database analytics with TeradataRR 3.0.0 would require a new version. Are there any plance to recompile it?
2323 Apr 2013 @ 07:42 PDTkeep it simpleExtract and Analyse Database Object DependenciesHi eddy, no nothing I am aware of. In any case it would work only if you are not dealing with dynamic SQL. Did you consider to run them with DBQL object logging and queryband on? This should give...
2209 Nov 2012 @ 03:41 PSTAsterEclipse - The other Aster Data SQL clientgreate! works also for mac :-)
2126 Oct 2012 @ 05:08 PDTkeep it simpleUpdate on copy / move data between systemsYou should be able to read the table while arcmain is extracting the data. You won't be able to modify the table. But just try on your system.
2023 Oct 2012 @ 12:47 PDTÜber SQLHow to simplify your statistics collection with a queue tableVery nice idea! Thanks for sharing
1922 Oct 2012 @ 07:24 PDTkeep it simpleUpdate on copy / move data between systemsHi, yes tlogview is the source for your info requirement. But also did you check the arcmain statements above? So far arcmain should give you the highest transfer rate...
1821 Oct 2012 @ 03:02 PDTkeep it simpleUpdate on copy / move data between systemsYes, thats right. It is using the load operator.
1718 Oct 2012 @ 07:36 PDTkeep it simpleUpdate on copy / move data between systemsyou owe me a drink in case you join Partners next week ;-)
1618 Oct 2012 @ 06:17 PDTkeep it simpleUpdate on copy / move data between systemsHaha, nice try - no, no sources for free. But I uploaded a new version. not with lock_for_access parameter. Default is N. You would need to set it to Y.
1517 Oct 2012 @ 08:23 PDTkeep it simpleUpdate on copy / move data between systemsCurrent tool doesn't support this option. Might check possibilities the next days but can't promise anything.
1406 Aug 2012 @ 12:04 PDTkeep it simpleUpdate on copy / move data between systemsSorry for the late reply, didn't get an email notification... This demo version doesn't have the option to move a whole DB. Where it is not a problem to implement this. Send me an email if you wan...
1323 Mar 2012 @ 01:52 PDTRobG's blogDetermining Month-End Date for a Date Dimensiondate-extract(day from date) as it should be clear for everybody what you really want where date mod 100 would need knowledge about TD internal representation of dates.
1203 Jan 2012 @ 12:09 PSTkeep it simpleExtract and Analyse Database Object Dependencies@David: I implemented it this way - generate show select and show exec statements, run them and extract the info out of it. As you state, it is doable but you would also face some issues as 1. not...
1128 Dec 2011 @ 09:02 PSTÜber SQLHow to decode the binary statistics stored in dbc tablesThank for your effort to decode the stats info! I used the older versions regularly in my daily work and and will test the latest verison as well. It gives really good information and helps also ...
1020 Dec 2011 @ 11:40 PSTkeep it simpleExtract and Analyse Database Object Dependencies@yottadata: yes graphviz seems to be a tool which can be used to create similar graphs. I would be interested to see the interactive tool. It was never an intention to vote for a particular tool ...
917 Dec 2011 @ 11:55 PSTkeep it simpleExtract and Analyse Database Object DependenciesAs some requested I added the mathematica code for creating this kind of graphs as an appendix. In can become a bit more complicated in case you want some specific subgraphs but mathematica is al...
812 Dec 2011 @ 09:50 PSTkeep it simpleExtract and Analyse Database Object DependenciesProcedures - at least the one with dynamic SQL - will be always challenging as the dynamic SQL can access at each execution different DB objects. So no chance to get this. But can't comment why sho...
705 Dec 2011 @ 05:53 PSTkeep it simpleExtract and Analyse Database Object DependenciesI used mathematica to create these pictures.
620 Oct 2011 @ 11:26 PDTToolsAccess to the Job Identifier in Teradata PT job scriptsHi, good news. Are there more internal variables like $JOBID? Ulrich
530 Jul 2011 @ 12:40 PDTkeep it simpleUpdate on copy / move data between systemsHi WOJO, same experiance as Dharmendra. Since I implemented the named pipe version arcmain was always faster and no no special parameter settings.
402 Nov 2010 @ 02:26 PDTDatabaseConfigure Teradata Express 12.0 for Amazon EC2Hi, same problem. I am registered. Instance is running. Key exists. ssh with key still requires a password. Did anybody ever was able to start a Amazon Teradata instance? Ulrich
308 Apr 2010 @ 05:44 PDTMichael McIntireA few basic scalar string UDFs...Thanks! Nice list of functions! Will install and test them. Do you use the functions in your production environment? If yes, in unprotected mode? Short question to eIsInteger, eIsDecimal, eIs...
216 Mar 2010 @ 11:22 PDTConnectivitySpeed up your JDBC/ODBC applicationsHi, in "Drivers Prepare Your Statements" you mention "and the prepared statement can then be used over and over again". Will this use the statement caching feature of the PE or will it always be us...

Pages