#DateForumTypeThreadPost
54815 Feb 2014 @ 10:27 PSTViewpointReplyTASM and States definition in 14.00Do you mean query session state? BTW .... its not V2R* anymore .... its Teradata 12 and Teradata 14. Teradata changed its versioning from V2R6.x onwards and moved to Teradata xx. versioning.
54715 Feb 2014 @ 10:24 PSTViewpointReplyCan Viewpoint be started and run in TDExpress14.10_Sles11?That is fine, as internet may not be available on VM. You can start Viewpoint from other browser as well.
54615 Feb 2014 @ 10:21 PSTViewpointReplySession expiration timeCan you share how you stopped/started the viewpoint portal?
54515 Feb 2014 @ 09:53 PSTGeneralReplyDifference between TeradataForum and Forums.TeradataYou can use which ever you wish too .... am sure you will get the answers of your questions.
54415 Feb 2014 @ 09:42 PSTDatabaseReplyInvalid timestamp literal detected.Database forum is for Teradata Database .... not all RDBMSs. :)
54315 Feb 2014 @ 09:38 PSTDatabaseReplyOnline backup performanceOnline backups are slower than regular backups. During online backup DB stays available and in regular/offline there is a DB outage. Hence it depends on your needs and environment if you can afford...
54214 Feb 2014 @ 06:58 PSTGeneralReplyparametrics queryYou can use parameters in multiple ways .... using a USING clause, using Macro or using Stored-Procedures.   But there isn't any way to use a variable like you wrote in your example, its...
54114 Feb 2014 @ 06:54 PSTDatabaseReplyMacro Execution- Retreive 0 results Can you share the sample data values and required output?
54008 Feb 2014 @ 10:10 PSTDatabaseReplyProblem in connecting ACCESS DB to TERADATA DBBasically, you need to create a link with Teradata table using LDAP/ODBC connection via VB script from MS Access.   You would be requiring someone good with VB scripting to help you out in t...
53908 Feb 2014 @ 10:00 PSTToolsReplySkip header row of file using TDLoadIf by tdload  you mean TPT, i dont think the situation has changed from what is mentioned in the post below:   http://forums.teradata.com/forum/tools/using-tpt-how-to-specify-...
53808 Feb 2014 @ 09:57 PSTToolsReplyTTU for solarisPlease have a look at following link:   http://forums.teradata.com/forum/tools/installing-bteq-on-solaris
53708 Feb 2014 @ 09:54 PSTDatabaseReplyHow to filter NULL from the macro outputHave you executed the same query with same parameters .... do you still get the row with NULL? Its a FULL OUTER JOIN hence you will get all rows from both tables. You need to restrict dataset withi...
53608 Feb 2014 @ 01:19 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesWelcome Richard! :)
53508 Feb 2014 @ 01:18 PSTDatabaseReplyCROSS JOIN in for Rule CheckFrom table-names i assume the data-set wont be huge, otherwise the join-condition can slow down the query. And a very good practice of sharing the solution. Thanks :)
53408 Feb 2014 @ 01:16 PSTDatabaseReplyTemporal conceptTemporal tables are introduced to help reduce the [same] SCD logic to be re-developed on every other project. Hence it achieves the same functionality but without any logic to be developed rather a...
53308 Feb 2014 @ 01:11 PSTDatabaseReplyConcerning implementing an equivalent of the ORA / DB2 Sequence Object in TeradataUsing tables instead of sequences can work. But while migrating from Oracle/DB2/etc DBs one must take care of the logic .... like in PL/SQL .... everything is executed via cursor .... implicit or e...
53207 Feb 2014 @ 04:08 PSTGeneralReplyTeradata Learning MaterialsYou can start as per Raja's suggestions. ANSI SQL works fine with Teradata. Hence you can have a good start .... in case you face any issue, you are always welcome to ask. :)
53107 Feb 2014 @ 04:07 PSTGeneralReplyCreate a macro that chooses from teo different select staments depending on a given parameter.If select list would be same, Macro could have solved the issue .... but in the example they are not. SP would be a better [only] option with seperate columns selected and changed WHERE clauses. &...
53007 Feb 2014 @ 04:02 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesYou could use Global Temporary Table, and yes they persist on the server.   Other way around is to just pull the data to MS SQL Server and make this join there.
52907 Feb 2014 @ 03:57 PSTDatabaseReplyDatablocksize and FreespacepercentData block is the physical I/O unit for the Teradata file system. Hence it should be the same.   FreeSpacePercent is the x percent free space that remains on each cylinder during bulk data l...
52807 Feb 2014 @ 03:47 PSTDatabaseReplySpecifying partition names for a PPII dont think its possible, why would you want to have this?
52707 Feb 2014 @ 03:44 PSTDatabaseReplySQL WorkaroundK, its a good practice to share a solution. Thanks.
52606 Feb 2014 @ 11:25 PSTToolsReplyBTEQ and the Commit statementTransactions are always implicit in ANSI session mode and in Teradata session mode, they can be defined explicitly or implicitly. So you should consider using ANSI mode.
52506 Feb 2014 @ 11:18 PSTGeneralReplyDelete a post in the forum - TPT - ODBC connector missingDone.
52405 Feb 2014 @ 11:55 PSTCloud ComputingReplyTeradata Express AMP DOWNAs Dieter suggested in following link, you might try re-downloading image?   http://forums.teradata.com/forum/cloud-computing/teradata-dbms-is-in-bad-state-in-td-express-12-images-40gb-as-...

Pages