#DateForumTypeThreadPost
16624 Feb 2012 @ 03:01 PSTDatabaseReplyProblems 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  
16524 Feb 2012 @ 02:38 PSTToolsReplyRemove 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...
16424 Feb 2012 @ 02:05 PSTDatabaseReplycast from decimal to float Just type   SHOW  in front of your SELECT ... ; statement and submit the query. 
16324 Feb 2012 @ 02:03 PSTToolsReplyRemove column headings from Fexport output can you share your fastexp script? Which export format did you use?  
16224 Feb 2012 @ 01:59 PSTDatabaseReplyInserting 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 ...
16124 Feb 2012 @ 12:37 PSTDatabaseReplyIs 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...
16024 Feb 2012 @ 12:09 PSTPrivate Forum
15923 Feb 2012 @ 11:50 PSTPrivate Forum
15823 Feb 2012 @ 11:47 PSTGeneralReplyHow 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...
15723 Feb 2012 @ 06:50 PSTDatabaseReplyEnding 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...
15622 Feb 2012 @ 11:55 PSTTeradata ApplicationsReplyexception 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...
15522 Feb 2012 @ 10:07 PSTDatabaseReplyDatabase 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.  
15422 Feb 2012 @ 07:38 PSTDatabaseReplyDatabase 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...
15322 Feb 2012 @ 07:33 PSTToolsReplyLocatio 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...
15222 Feb 2012 @ 01:50 PSTGeneralReplypermanent space availability,space,permanent space yes, I was wrong. Confused myself with the empty table space requirements.
15122 Feb 2012 @ 01:33 PSTDatabaseReplyProblem 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 ...
15022 Feb 2012 @ 01:02 PSTDatabaseReplyProblem with an insert statement... most likely the date conversion fails - what is your error message?
14921 Feb 2012 @ 12:24 PSTDatabaseReplyString Concat - returning multiple rows in one string cocat row sorry - you need to remove the \...
14821 Feb 2012 @ 12:24 PSTDatabaseReplyString 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 ...
14721 Feb 2012 @ 11:17 PSTDatabaseReplyOLAP 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 ...
14621 Feb 2012 @ 06:51 PSTDatabaseReplyWhy 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 ...
14521 Feb 2012 @ 04:52 PSTDatabaseReplyINSERT 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...
14421 Feb 2012 @ 04:12 PSTDatabaseReplyINSERT 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...
14320 Feb 2012 @ 10:32 PSTAnalyticsReplyget 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  
14220 Feb 2012 @ 12:22 PSTDatabaseReplyCreating 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...

Pages