#DateForumTypeThreadPost
5516 Apr 2007 @ 12:43 PDTDatabaseReplyPrior week from current dateWHERE ORDER_CREATE_DT(DATE) >= CURRENT_DATE - 7
5416 Apr 2007 @ 12:36 PDTDatabaseReplyAutomatically RoundingI presume you are querying from queryman. in that case go to tools->options and in the answerset tab look from something like "number of decimal places to display for float".
5313 Apr 2007 @ 12:39 PDTToolsReplyAccessRight definitionsFrom DD manual.IX INDEXRF REFERENCE
5213 Apr 2007 @ 12:30 PDTDatabaseReplystring with single quotesIf you are using bteq, you can also try just plain format command.SELECT CURRENT_DATE (FORMAT '''YYYY-MM-DD''');
5130 Mar 2007 @ 01:16 PDTUDAReplybteqNormally people would resort to using the .export command in the bteq ......
5030 Mar 2007 @ 01:05 PDTDatabaseReplyCalculate age from birth dateThere must be an easier way than this :oSELECT EXTRACT (YEAR FROM CURRENT_DATE) - EXTRACT (YEAR FROM DOB ) + CASE WHEN EXTRACT(MONTH FROM CURRENT_DATE) < EXTRACT (MONTH FROM DOB) THEN -1 ...
4930 Mar 2007 @ 12:34 PDTDatabaseReplyMasking commas within a macro parameterI don't know if this is a good solution, but now that it sprouted up, I might as well throw it....(0) Create a stored proc that accepts a string as argument (say a string like '12,13' ). Use it to ...
4829 Mar 2007 @ 01:05 PDTUDAReplySQL Query to modify a column datatype lenght.!!!You can't alter CHAR(n) types for their length. TD let's you alter the types/lengths of only a small set of data types. You can refer the data types & literals manual for more detail.
4728 Mar 2007 @ 03:03 PDTUDAReplySQL Query to modify a column datatype lenght.!!!There's no such thing as modify on column name, you use the same syntax as ADD columnalter table xxx add emp_name varchar(20)that will make it varchar(20) from (10)
4628 Mar 2007 @ 02:53 PDTUDAReplyJoin Indexes v/s classic Denormalized base tableThe changes are real time (not so in denormalized tables).Single Table JIs with different PIs are quite helpful in speeding up joins ..Sp**** Indexes possible for a subset of data ....You can't use...
4528 Mar 2007 @ 02:45 PDTToolsReplyBTEQ examplesFrom your example it looks like you are running on windows, In case you are using unix for production, something like this might help ....bteq < mybteq.btq 2>&1 | awk '/^BTEQ/,/Starting Row/ /F...
4416 Mar 2007 @ 12:42 PDTToolsReplyI am receiving error 2679 on Error TableMost likely it's a mismatch between your export and load formats ...... if you can post those scripts, might be able to help ...but if you have exported in TEXT format, you might as well try changi...
4315 Mar 2007 @ 01:45 PDTDatabaseReplySequential Execution of the Stmts within the MacroIn fact, one of the criteria that any distributed computing platform has to satisfy while translating the input instructions to a set of internal parallel execution instructions is to preserve it f...
4214 Mar 2007 @ 12:14 PDTDatabaseReplySequential Execution of the Stmts within the MacroI think only those statements which are independent of each other (in terms of outcome) are executed in parallel. Otherwise they would be executed sequentially.
4113 Mar 2007 @ 11:57 PDTDatabaseReplyCopy Dictionary & error 2654To the best of my understanding, copy dictionary only copies the data dictionary rows for the table. It does not create the Table headers in the AMPS. that's where BUILD DATA TABLES comes into pict...
4013 Mar 2007 @ 11:50 PDTToolsReplyExport Import from one database to another.Use Arcmain to do a archive , copy ..... the sytnax is relatively simple ... refer the Archive/Recovery manual for more details.
3913 Mar 2007 @ 12:22 PDTDatabaseReplyASCIICan you paste the tabled definition ?Any chance that column_A is an integer or so ?Also you can try using DBQL to log the SQLs being fired ... might get something out of it if you are lucky !
3807 Mar 2007 @ 06:00 PSTToolsReplyFastload logoncreate a file logon.txt.logon dbhostid/user,pass;in your fastload..RUN logon.txt;
3707 Mar 2007 @ 02:47 PSTDatabaseReplyTables to Views Cross ReferenceOne of my "to do" list include dumping the output of explain select * from mydb.mytablesview and parsing the output for getting referenced tables using shell script .Have been a lazy year so far th...
3607 Mar 2007 @ 02:39 PSTToolsReply.Logon ... using DMTEQ Capability---problemOne suggestion I can make is to put the login command ( .logon hostid/user,pass; )in a file somewhereand in your scripts just mention..run file c:\logonfiles\.logon.txt;
3505 Mar 2007 @ 11:02 PSTDatabaseReplyChallenges of migration from oracle to TeradataSome of the points to ponder are. (These are not necessarily the "Golden Rules", just pointers, the right combination to choose would largely depend on the scenario)Try to take the data model to so...
3405 Mar 2007 @ 10:46 PSTDatabaseReplyHow to recover a table once its droppedOnly if your DBAs have taken a backup...
3305 Mar 2007 @ 04:30 PSTDatabaseReplyCOALESCE OR CASE?Actually it doesn't matter because COALESCE is implemented as CASE expression, it's just a nice shorthand to have for simple situations like the one you mentioned.
3203 Mar 2007 @ 03:00 PSTDatabaseReplyLPAD Function equivalent in TeradataIf your SEQ_NO, is a CHAR column, then you can try.SELECT SEQ_NO (INTEGER FORMAT '9999').
3103 Mar 2007 @ 02:51 PSTAnalyticsReplyKilling queries in TeradataI am suspecting that application is not closing it's connections. Does the sessions still exist in DB even after the application is closed ? Anyways killing DB sessions manually is not a good habit...

Pages