#DateForumTypeThreadPost
2923 Jan 2013 @ 10:41 PSTDatabaseTopicOLAP functions in M:N relation  We have two record set as an input: 1.      key_1, key_2, prio, amount_1 2.      key_2, amount_2 And look for this output 1.  ...
2822 Feb 2010 @ 08:31 PSTDatabaseReplyAbout JoinHi Dieter!Thank you a lot. That's exactly, what I was looking for. Best RegardsPetr
2714 Feb 2010 @ 09:20 PSTDatabaseTopicAbout JoinHi All!We have a table with sequences of records, which need to be merged into one record if the difference between them is 1. Let's have a sample table with data as below, then we expect to return...
2611 Feb 2010 @ 08:53 PSTDatabaseTopicCreate Timestamp from Date and TimeDear All,I wonder what is the best way how to provide a Timestamp column in view based on date and time column from table. So far we have two options, both seems me still quite complicated. Thanks ...
2524 Nov 2009 @ 08:26 PSTDatabaseTopicJoining two big tablesHi All,we have two big (1 billion +) tables both having same NUPI as: PRIMARY INDEX NUPI_X (Id )PARTITION BY RANGE_N(Dt BETWEEN DATE '2007-1-01' AND DATE '2009-12-31' EACH INTERVAL '1' DAY , NO RA...
2431 Jul 2009 @ 03:29 PDTJobsTopicUrgent opening - Teradata Developer fluent in GermanHi,we are looking for Teradata Developer (SQL, Teradata Tools&Utillities - Fast Load, MultiLoad,...) with knowledge of German on communication level. In case of interest please send your CV to emai...
2318 Feb 2009 @ 09:26 PSTDatabaseReplyteradata jobsHi Kumar,where is the location?thxpetr
2205 Feb 2009 @ 12:20 PSTUDAReplyStar schema referential integrity errorThank you for explanation, it's interesting, never heard about that, but used AJI just for couple of time. Does it help Optimizer?The common limitations of AJI are outer joins and aggtegated functi...
2105 Feb 2009 @ 11:43 PSTUDAReplycast (-18989899 as date)Hi,see Teradata SQL Reference: Data type and Literars, p. 101:Internal Representation of DATEInternally, Teradata Database stores each DATE value as a four-byte signed integer using thefollowing fo...
2005 Feb 2009 @ 11:22 PSTUDAReplyWild Characteruse another simple quote, i.e. SEL '''' AS simple_quotereturns one simple quote char
1903 Feb 2009 @ 10:17 PSTUDAReplyStar schema referential integrity errorWell, I'm more pragmatic then theoretic. Regarding question # 2 - WITH CHECK OPTION controls RI on transactional level not a row level. Begin and end of transaction is influenced by session, tool a...
1802 Feb 2009 @ 07:21 PSTUDAReplyStar schema referential integrity errorHi,When I was playing with this sample, I didn’t encounter errors described above. In the pure version of sample code, there is no insert in dim tables and thus referential integrity (RI) can’t...
1702 Feb 2009 @ 06:20 PSTDatabaseReplyTime stampThe casting is similar to DDL:CAST('02/03/2009-01:25:11' AS TIMESTAMP FORMAT 'MM/DD/YYYY-HH:MI:SS')-Petr
1629 Jan 2009 @ 08:49 PSTDatabaseReply3504: Selected non-aggregate values must be part of the associated group Error on max-case statementHi,see that you are only, I'll try to reply fast as leaveing the office today:? stands for NULL and it is probably due to NULL has appered in some concateneated string use COALESCE(expre, '') to ...
1529 Jan 2009 @ 08:17 PSTDatabaseReply3504: Selected non-aggregate values must be part of the associated group Error on max-case statementKarver,Please dont'd take it amiss, I write it quite stright. It's bit difficult to jump directly in writting a query without SQL fundamental regardless of plaform.Suppose there are two tables A an...
1428 Jan 2009 @ 10:59 PSTDatabaseReply3504: Selected non-aggregate values must be part of the associated group Error on max-case statementHi, with certain level of simplification: what is in the select part must by in a group by clause or inside of some aggregation function. Applied to the first example:GROUP BY SUBSTR(a.field1,1,4)K...
1327 Jan 2009 @ 06:24 PSTToolsReplyHow to Export DML statement results to a file in BTEQHi,save the script to file, call the BTEQ from command line and redirect the standard output to file. As some symbols are difficult to write here, pls see attached sample files. You may also look a...
1226 Jan 2009 @ 02:23 PSTDatabaseReplySI - Drop / CreateHi,inclusion of create and drop USI as a part of ETL (batch) is a relevant option. If your batch runs isolated in the night without pressure to catch the "window", then create and drop, otherwise c...
1122 Jan 2009 @ 10:17 PSTDatabaseReplyCAST TIME ProblemHi,I'm just guessing. If the application would use ODBC, check the option DateTime Format (appears after pushing the button Options) default is "III" and change it to "AAA".Petr
1020 Jan 2009 @ 08:33 PSTToolsReplyHow to get return code after BTEQ excuted SQL in VBScriptuff, it's difficult to upload <, pls. replace LT resp. GT by corresponding symbols for "Less Then" and "Great Then" There should be in the quotation marks 'bteq "LT"bteq_wrap.txt "GT"bteq_out.txt'
919 Jan 2009 @ 07:39 PSTToolsReplyHow to get return code after BTEQ excuted SQL in VBScriptHi, Think, that exec should work, see: http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_pkoy.mspx?mfr=trueYou can also use bteq in batch mode and redirect stdout to file for further proc...
813 Jan 2009 @ 06:50 PSTUDAReplyHow to CREATE , INSERT TABLES INTO PERSONAL DATABASE FROM THE COMPANY'S DATA WAREHOUSEI agree with dnoeth - you use MS SQL server. Example in your last post works in your database, where default schema dbo is used, but when you try to do it in John db, the syntax should follow full ...
709 Jan 2009 @ 09:13 PSTUDAReplyWhy this SQL is not filtering recordsHi,the main difference is given by join the type. The filtering would behave identically for INNER JOIN and WHERE.Filtering in ON clause of LEFT JOIN executes conditions separately for table C and ...
618 Dec 2008 @ 06:24 PSTToolsReplyUsing SQL assistant to pull data from an ORacle DBHi,check the connection from different tool like Excel or Access or directly from ODBC (if possible).petr
518 Dec 2008 @ 06:14 PSTDatabaseReplyAdding URN or ID columnHi Andrew,you can try to create a new_table with identity column (sk_id INTEGER GENERATED ALWAYS AS IDENTITY) and insert into this new empty table INSERT INTO new_table (list of all columns except...

Pages