#DateForumTypeThreadPost
14105 Nov 2014 @ 09:34 PSTGeneralReplyConverting Mainframe Copybook's to TD DDLYes, the copybooks includes the layput of header, trailer & detail record. Below is one sample copybook 01 DUMMYPT-INPUT-AREA. ...
14005 Nov 2014 @ 12:34 PSTGeneralTopicConverting Mainframe Copybook's to TD DDLIs there tool/utilities to convert mainframe copybooks to Teradata DDL's?  Even just getting the field names and their equivalent Java data typw will do. Thanks.
13919 Feb 2014 @ 11:08 PSTDatabaseTopicEXEC Privilege & Table access?Hi All,      Lets say user1 has access to Execute macros but  in one of the macro there were two tables referenced and he doesnt have access to those two tables. Will he still ...
13809 Jan 2014 @ 03:59 PSTDatabaseReplyFind out all the groups in a data.Any1??
13708 Jan 2014 @ 04:08 PSTDatabaseReplyFind out all the groups in a data. @M.Saeed Khurram, Yes i want to find out the common groups @Raja_KT, It means that FFFF has made calls to DDDD & EEEE From Number is the number of the caller (Ex 1 is the Number of AAAA a...
13608 Jan 2014 @ 04:04 PSTDatabaseReplyFind out all the groups in a data.Sry guys for the trouble, ma bad will post it in a readable format. Here i have to find out the Groups. Group meaning they shud have called the people in that group only.     ...
13507 Jan 2014 @ 10:26 PSTDatabaseTopicFind out all the groups in a data.Hi All,   Here i have to find out the Groups. Group meaning they shud have called the people in that group only.   Name From Number To Number ...
13420 Dec 2013 @ 03:26 PSTDatabaseTopicFinding the table size alone?Hi All, How to find the table size alone? Not including the SI's and other stuffs related to a table. Thanks in advance.
13303 Oct 2013 @ 06:10 PDTToolsReplyConverting Binary extracted file using TPT to ASCII?Hi Ulrich, The problem is eventhough its binary, while exporting TPT adds some additional information it seems Taken from the TPT documentation • 'Binary' = 2-byte integer, n, follo...
13203 Oct 2013 @ 01:32 PDTToolsTopicConverting Binary extracted file using TPT to ASCII?Hi All, i know i should ask this question in some unix forums but still if anyone here has any ideas please help me. I have extracted a table in binary format using TPT, now i want to convert thi...
13103 Oct 2013 @ 12:39 PDTToolsTopicwaht is Spoolmode option in TPT script?Hi All,     Can someone please explain what does this option mean? Nospool or spool  which is advised for extractions involving huge tables with more than 100 million rows. &n...
13013 Sep 2013 @ 12:34 PDTToolsReplyKeeping idle connections alive!Thanks Dieter :-)
12906 Sep 2013 @ 01:46 PDTDatabaseReplyLeading Spaces in answer set in SQLAThanks Khurram for the information :-)
12806 Sep 2013 @ 12:47 PDTDatabaseReplyLeading Spaces in answer set in SQLAHe is already using the function to_char for which the output will be in characters rite? I think it has to be some other issue not the casting i guess.
12705 Sep 2013 @ 11:27 PDTDatabaseReplyLeading Spaces in answer set in SQLAHi, I have ran the same query in my machine i am not getting any leading space. My version is TD14.
12605 Sep 2013 @ 11:25 PDTTrainingReplyAuthorized study guides for teradata 14Yes, so far the TD14 basics is the only authorized guide. For the remaining exams they havent released it yet.
12504 Sep 2013 @ 03:10 PDTToolsReplyKeeping idle connections alive!Thanks Dieter for u r prompt response. i could have stated better. Yes the setting in the server is such that they will disconnect idle sessions(idle for 3 minutes). Is there by any mechanism ...
12429 Aug 2013 @ 05:11 PDTToolsTopicKeeping idle connections alive!Hi All,     Is there anyway to keep the connections alive in SQL Assistant. In the system i am using its expiring every 3 minutes and i have to login again. any shortcuts? Thanks i...
12327 Aug 2013 @ 03:42 PDTToolsReplyFLOAD: How to load different flat files to a single table using fastload without merging the flat filesFor the 1st and 2nd question - You can load one file per fastload job. So if you want to load multiple files you need to load that many number of time or concatenate all the files and load at a go....
12223 Aug 2013 @ 08:17 PDTDatabaseReplyvolatile table as select..with data - not loading dataHi, AND RP.REGIS_DATETM BETWEEN (CURRENT_DATE -7) and CURRENT_DATE on a.MATCHD_CNSMR_PRSNA_ID = b.MATCHD_CNSMR_PRSNA_ID   This ON is misplaced.    
12122 Aug 2013 @ 10:26 PDTDatabaseReplyRefreshing View?Thanks Todd for your time :-) Why i had this confusion is, that the view will be materialised only during the actual usage right? So my understanding was the exact query which i used to create a v...
12022 Aug 2013 @ 08:19 PDTDatabaseReplyRefreshing View?Thanks Dieter :-)
11922 Aug 2013 @ 06:51 PDTDatabaseTopicRefreshing View?Hi All,     On top of a table i am creating a view as replace view v1 as sel * from tabl1; After creating this view i have added some columns in the base table. I am able to use t...
11819 Aug 2013 @ 12:57 PDTDatabaseReplyPrimary key and Primary index on a same column Hi Chinmay,       Thanks for the response :-)  But Primary Key will be implemented as UPI only if there is no Primary Index specifi...
11716 Aug 2013 @ 03:58 PDTDatabaseTopicPrimary key and Primary index on a same columnHi All,     While creating a table if i specify both the Primary Index and Primary Key on the same column the table cretion fails. CREATE TABLE temp4243426 ( name INT NOT NUL...

Pages