26 | 24 May 2013 @ 07:23 PDT | keep it simple | Calculation of Table Hash Values to Compare Table Content | Hi Suhail,
sorry no :).
Ulrich
|
25 | 21 May 2013 @ 01:01 PDT | UDA | Introducing TDM into a production Dual System environment | Hi 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;
... |
24 | 24 Apr 2013 @ 02:42 PDT | Applications | In-database analytics with TeradataR | R 3.0.0 would require a new version. Are there any plance to recompile it?
|
23 | 23 Apr 2013 @ 07:42 PDT | keep it simple | Extract and Analyse Database Object Dependencies | Hi 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... |
22 | 09 Nov 2012 @ 03:41 PST | Aster | Eclipse - The other Aster Data SQL client | greate! works also for mac :-) |
21 | 26 Oct 2012 @ 05:08 PDT | keep it simple | Update on copy / move data between systems | You 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.
|
20 | 23 Oct 2012 @ 12:47 PDT | Über SQL | How to simplify your statistics collection with a queue table | Very nice idea! Thanks for sharing |
19 | 22 Oct 2012 @ 07:24 PDT | keep it simple | Update on copy / move data between systems | Hi,
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... |
18 | 21 Oct 2012 @ 03:02 PDT | keep it simple | Update on copy / move data between systems | Yes, thats right. It is using the load operator. |
17 | 18 Oct 2012 @ 07:36 PDT | keep it simple | Update on copy / move data between systems | you owe me a drink in case you join Partners next week ;-) |
16 | 18 Oct 2012 @ 06:17 PDT | keep it simple | Update on copy / move data between systems | Haha, 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. |
15 | 17 Oct 2012 @ 08:23 PDT | keep it simple | Update on copy / move data between systems | Current tool doesn't support this option.
Might check possibilities the next days but can't promise anything. |
14 | 06 Aug 2012 @ 12:04 PDT | keep it simple | Update on copy / move data between systems | Sorry 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... |
13 | 23 Mar 2012 @ 01:52 PDT | RobG's blog | Determining Month-End Date for a Date Dimension | date-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. |
12 | 03 Jan 2012 @ 12:09 PST | keep it simple | Extract 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... |
11 | 28 Dec 2011 @ 09:02 PST | Über SQL | How to decode the binary statistics stored in dbc tables | Thank 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 ... |
10 | 20 Dec 2011 @ 11:40 PST | keep it simple | Extract 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 ... |
9 | 17 Dec 2011 @ 11:55 PST | keep it simple | Extract and Analyse Database Object Dependencies | As 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... |
8 | 12 Dec 2011 @ 09:50 PST | keep it simple | Extract and Analyse Database Object Dependencies | Procedures - 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... |
7 | 05 Dec 2011 @ 05:53 PST | keep it simple | Extract and Analyse Database Object Dependencies | I used mathematica to create these pictures. |
6 | 20 Oct 2011 @ 11:26 PDT | Tools | Access to the Job Identifier in Teradata PT job scripts | Hi,
good news.
Are there more internal variables like $JOBID?
Ulrich |
5 | 30 Jul 2011 @ 12:40 PDT | keep it simple | Update on copy / move data between systems | Hi WOJO,
same experiance as Dharmendra. Since I implemented the named pipe version arcmain was always faster and no no special parameter settings. |
4 | 02 Nov 2010 @ 02:26 PDT | Database | Configure Teradata Express 12.0 for Amazon EC2 | Hi, 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 |
3 | 08 Apr 2010 @ 05:44 PDT | Michael McIntire | A 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... |
2 | 16 Mar 2010 @ 11:22 PDT | Connectivity | Speed up your JDBC/ODBC applications | Hi, 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... |