141 | 05 Nov 2014 @ 09:34 PST | General | Reply | Converting Mainframe Copybook's to TD DDL | Yes, the copybooks includes the layput of header, trailer & detail record.
Below is one sample copybook
01 DUMMYPT-INPUT-AREA.
... |
140 | 05 Nov 2014 @ 12:34 PST | General | Topic | Converting Mainframe Copybook's to TD DDL | Is 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.
|
139 | 19 Feb 2014 @ 11:08 PST | Database | Topic | EXEC 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 ... |
138 | 09 Jan 2014 @ 03:59 PST | Database | Reply | Find out all the groups in a data. | Any1??
|
137 | 08 Jan 2014 @ 04:08 PST | Database | Reply | Find 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... |
136 | 08 Jan 2014 @ 04:04 PST | Database | Reply | Find 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.
... |
135 | 07 Jan 2014 @ 10:26 PST | Database | Topic | Find 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
... |
134 | 20 Dec 2013 @ 03:26 PST | Database | Topic | Finding 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. |
133 | 03 Oct 2013 @ 06:10 PDT | Tools | Reply | Converting 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... |
132 | 03 Oct 2013 @ 01:32 PDT | Tools | Topic | Converting 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... |
131 | 03 Oct 2013 @ 12:39 PDT | Tools | Topic | waht 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... |
130 | 13 Sep 2013 @ 12:34 PDT | Tools | Reply | Keeping idle connections alive! | Thanks Dieter :-)
|
129 | 06 Sep 2013 @ 01:46 PDT | Database | Reply | Leading Spaces in answer set in SQLA | Thanks Khurram for the information :-)
|
128 | 06 Sep 2013 @ 12:47 PDT | Database | Reply | Leading Spaces in answer set in SQLA | He 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.
|
127 | 05 Sep 2013 @ 11:27 PDT | Database | Reply | Leading Spaces in answer set in SQLA | Hi,
I have ran the same query in my machine i am not getting any leading space. My version is TD14.
|
126 | 05 Sep 2013 @ 11:25 PDT | Training | Reply | Authorized study guides for teradata 14 | Yes, so far the TD14 basics is the only authorized guide. For the remaining exams they havent released it yet.
|
125 | 04 Sep 2013 @ 03:10 PDT | Tools | Reply | Keeping 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 ... |
124 | 29 Aug 2013 @ 05:11 PDT | Tools | Topic | Keeping 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... |
123 | 27 Aug 2013 @ 03:42 PDT | Tools | Reply | FLOAD: How to load different flat files to a single table using fastload without merging the flat files | For 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.... |
122 | 23 Aug 2013 @ 08:17 PDT | Database | Reply | volatile table as select..with data - not loading data | Hi,
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.
|
121 | 22 Aug 2013 @ 10:26 PDT | Database | Reply | Refreshing 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... |
120 | 22 Aug 2013 @ 08:19 PDT | Database | Reply | Refreshing View? | Thanks Dieter :-)
|
119 | 22 Aug 2013 @ 06:51 PDT | Database | Topic | Refreshing 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... |
118 | 19 Aug 2013 @ 12:57 PDT | Database | Reply | Primary 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... |
117 | 16 Aug 2013 @ 03:58 PDT | Database | Topic | Primary key and Primary index on a same column | Hi 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... |