166 | 24 Feb 2012 @ 03:01 PST | Database | Reply | Problems with two views on different Databases |
The database where the view is stored need select rights with grant option on the source table (or DB).
check http://www.teradataforum.com/teradata/20040908_102929.htm
|
165 | 24 Feb 2012 @ 02:38 PST | Tools | Reply | Remove column headings from Fexport output |
And by the way - did you recognise the
MLSCRIPT option in the EXPORT command?
It can be quite nice.
Also TPT would allow you to move data between systems without lan... |
164 | 24 Feb 2012 @ 02:05 PST | Database | Reply | cast from decimal to float |
Just type
SHOW
in front of your
SELECT ...
;
statement and submit the query.
|
163 | 24 Feb 2012 @ 02:03 PST | Tools | Reply | Remove column headings from Fexport output |
can you share your fastexp script?
Which export format did you use?
|
162 | 24 Feb 2012 @ 01:59 PST | Database | Reply | Inserting values to a created table - syntax help |
The problem is that the target table has more colums - so how should the DB system know which is the right one.
just add the target columnname after the tablename like ... |
161 | 24 Feb 2012 @ 12:37 PST | Database | Reply | Is this a valid insert? |
Hi,
I run SQLs below and it worked as I would expect. It's a nice way of handling this.
CREATE VOLATILE TABLE table_partial
(id integer, part_add1 VARCHAR(50), part_add2... |
160 | 24 Feb 2012 @ 12:09 PST | Private Forum |
159 | 23 Feb 2012 @ 11:50 PST | Private Forum |
158 | 23 Feb 2012 @ 11:47 PST | General | Reply | How to calculate query cost and compare 2 queries which gives the same result set? |
It is as you stated - the query cost depend on your workload and system. In an IO bound system you would rate IO higher than in a CPU bound system. But I think there is no golden rule... |
157 | 23 Feb 2012 @ 06:50 PST | Database | Reply | Ending Parameters |
I guess you are using SQL assistent - correct?
Documentation is indicating that it will not work.
Named Parameters are indicated by a "?" immediately followed by a n... |
156 | 22 Feb 2012 @ 11:55 PST | Teradata Applications | Reply | exception handling in Store Procedure |
@vishnoiprem:
it would be better to open a new thread on this as your question is not related to the topic in this thread...
Are you sure that your TD is running?
check also htt... |
155 | 22 Feb 2012 @ 10:07 PST | Database | Reply | Database command execution |
Will not work - TD system will not let you get access to nodw file system with native commands. At least I am not aware and I really would wonder if it will work.
|
154 | 22 Feb 2012 @ 07:38 PST | Database | Reply | Database command execution |
Don't be sure that I get this right.
Can't you connect via ssh (user and password required) to the linux and run the command there?
Or do you want to call the action out of... |
153 | 22 Feb 2012 @ 07:33 PST | Tools | Reply | Locatio of output file |
I am not sure if you really want this to be done from the TD server.
I would expect to do this much more on the load utlities client machines.
But if TD should do this check the external... |
152 | 22 Feb 2012 @ 01:50 PST | General | Reply | permanent space availability,space,permanent space |
yes, I was wrong.
Confused myself with the empty table space requirements.
|
151 | 22 Feb 2012 @ 01:33 PST | Database | Reply | Problem with an insert statement... |
I guess .net is handling conversions differently as ODBC.
But as you have a date column you should be save if you convert your string explicitly into a date in the insert. This will prevent ... |
150 | 22 Feb 2012 @ 01:02 PST | Database | Reply | Problem with an insert statement... |
most likely the date conversion fails - what is your error message?
|
149 | 21 Feb 2012 @ 12:24 PST | Database | Reply | String Concat - returning multiple rows in one string cocat row |
sorry - you need to remove the \...
|
148 | 21 Feb 2012 @ 12:24 PST | Database | Reply | String Concat - returning multiple rows in one string cocat row |
this can give you an idea how it can work
WITH RECURSIVE base (c_year,c_month,c_date,day_of _month,c_list)
as
(
select year_of _calendar as c_year
,month_of _year as c_month
... |
147 | 21 Feb 2012 @ 11:17 PST | Database | Reply | OLAP Sliding Windows..... Max amount |
Hi,
I can reproduce this on a 13.10 system with below SQL based on sys_calendar.
Would consider this as a bug as NULL is not the correct value for this. So would expect either a correct ... |
146 | 21 Feb 2012 @ 06:51 PST | Database | Reply | Why Timestamp(6) precision only upto 2 fractional seconds? |
Hi,
this is from the TD manual - SQL->functions&
"Precision
The seconds precision of the result of CURRENT_TIMESTAMP is limited to hundredths of a
... |
145 | 21 Feb 2012 @ 04:52 PST | Database | Reply | INSERT SELECT will it rollback? |
If tabB contains already rows and is defined as set table you can have again lower row numbers if tabA contains rows which are allready in TabB...
|
144 | 21 Feb 2012 @ 04:12 PST | Database | Reply | INSERT SELECT will it rollback? |
Hi, I am not sure that I understand the question fully.
Let's assume
you have table TabA and TabB.
Do you mean
Insert into TabA
Se... |
143 | 20 Feb 2012 @ 10:32 PST | Analytics | Reply | get the max from table that has 2 columns unique and one duplicate |
select *
from table
qualify row_number() over (partition by TelephoneNO order by Start_Date desc) = 1
should work
|
142 | 20 Feb 2012 @ 12:22 PST | Database | Reply | Creating Dynamic columns... |
P.S. real dynamic - in the meaning that you don't know how much columns will be needed before executing the query would require a dynamic SQL stored procedure...
|