#DateForumTypeThreadPost
1230 Nov 2007 @ 04:50 PSTToolsReplytimestamp sortingThat is strange.... I'm not getting any errors, the result set is just coming back unsorted on that column. I'm running in SQL Assistant so maybe that is the issue.
1130 Nov 2007 @ 03:15 PSTToolsTopictimestamp sortingI running the following from the dbc query log tables and can't get the timestamp field to sort. Can anybody see anything that I am doing wrong?sel a.starttime,a.firststeptime,a.firstresptime,a.la...
1010 Oct 2007 @ 01:39 PDTToolsTopicgrant drop indexIn Administrator, what is the best way to grant a user or a role create and drop index privs?Thanks,Joe
914 Aug 2007 @ 04:07 PDTToolsTopicFrom clause 'Select * from table@ a 'Does anybody know what the significance of the @ sign is in the following Teradata SQL?SELECT COALESCE(a.LISTED_TN_NPA, 'D8'XC) LISTED_TN_NPA, COALESCE(a.LISTED_TN_COP, 'D8'XC) LISTED_TN_COP,COAL...
824 Jul 2007 @ 11:41 PDTDatabaseTopicReferencial Integrity in an EDWI'm curious to know how may people who have actually developed a relational data warehouse on a Teradata platform actually enforced RI during their loads? I know there is a huge cost in doing this...
724 Jul 2007 @ 11:36 PDTDatabaseTopicPrimary Key vs Primary IndexI realize that a primary key is defined in a logical model while a primary/seconday index is defined during database design. I also understand that a primary index may or may not consist of all, o...
603 May 2007 @ 05:30 PDTToolsReplyTPT - Oracle Date to Teradata Timestamp(0) SelectStmt = 'SELECT CHANNEL_CODE,CHANNEL_ABBR,CHANNEL_NAME,CTRL_DATA_LOP_ID,to_charCTRL_DATA_LOP_DT,''yyyy/mm/dd:hh24:mi:ss'') FROM REFWORK.CHANNEL;',
503 May 2007 @ 05:28 PDTToolsReplyCan INMOD routines be used when creating a script in TPT Wizard?I'm in the process of trying to figure out how to point tbuild to the correct odbc.ini file. I can't imagine the install not creating it's own odbc.ini. What if I don't have an existing odbc.ini ...
402 May 2007 @ 05:45 PDTToolsReplyCan INMOD routines be used when creating a script in TPT Wizard?Thanks Chris,I agree that the TPT wizard is for creating a shell of a script. I had a heck of a time loading a data field from Oracle to Teradata using the wizard. It required quite a bit of edit...
323 Apr 2007 @ 03:59 PDTToolsReplyTPT - Oracle Date to Teradata Timestamp(0)This is in directly from Teradata:When sourcing an Oracle DATE to be loaded into a date field in a Teradata table, the following has to be done:Oracle Teradata Source Definition ...
223 Apr 2007 @ 03:50 PDTToolsTopicCan INMOD routines be used when creating a script in TPT Wizard?I haven't seen any documentation suggesting that a fastload INMOD routine can be called from a script created and run from within the TPT Wizard. Has anybody else ever used fastload INMOD routines...
117 Apr 2007 @ 12:40 PDTToolsTopicTPT - Oracle Date to Teradata Timestamp(0)I just upgraded from ttu8.1 to ttu8.2. I am loading a Teradata table via the TPT wizard from an Oracle table via fastload (load). When selecting the source table and fields, the tpt wizard does n...