#DateForumTypeThreadPost
8726 Sep 2012 @ 03:21 PDTDatabaseReplyHelp in Recursive query requiredGoood... Enjoy!! :P -- Qaisar
8626 Sep 2012 @ 01:35 PDTGeneralReplyForum email notifications temporarily disabledYes my profile settings are the same as yours...
8526 Sep 2012 @ 01:31 PDTDatabaseReplyStrange(?) error creating FK constraintsI am not sure why you are getting the error while adding the FK constraints. I tried the same on TD 12 & 13.00.01, and haven't faced any issue on both empty or populated tables. I guess yo...
8426 Sep 2012 @ 01:25 PDTDatabaseReplyHelp in Recursive query requiredFarhan, Does the SQL I posted few minutes ago meets your requirements? If not then whats missing? -- Qaisar
8326 Sep 2012 @ 12:33 PDTDatabaseReplyHelp in Recursive query requiredFarhan, The below SQL will return the 5 columns in one row. Each column has the content between two pipes. Is this what you need? Have fun... WITH RECURSIVE recursive_T1 (row_id, text, ...
8226 Sep 2012 @ 12:19 PDTDatabaseReplyHelp in Recursive query requiredHi Farhan, Yes you are creating the confusion just like good old day :) The solution posted earlier solves the problem that was mentioned initially. Re parsing from the right, that is not possibl...
8126 Sep 2012 @ 12:06 PDTDatabaseReplystrange error SELECT failed 3707 syntax error, expected something '(' between ')' and IN keywordKindly share the view definition so that someone can help you!
8025 Sep 2012 @ 02:24 PDTDatabaseReplyHelp in Recursive query requiredYou need to test it comprehensively as I can only help you with limited test cases :)
7925 Sep 2012 @ 02:15 PDTDatabaseReplyHelp in Recursive query requiredHere you go... LEFT_WORD in resultset is youre desired output. DROP TABLE T1; CREATE TABLE T1 ( row_id INT NOT NULL, text VARCHAR(991) NOT NULL ); INSERT INTO T1 VALUES (1,'A...
7825 Sep 2012 @ 01:18 PDTDatabaseReplyExperts Need Help!!!Here you go... CREATE TABLE T1(A INTEGER, B INTEGER, C INTEGER) PRIMARY INDEX (A); INSERT INTO T1(100,10,1); INSERT INTO T1(200,20,2); CREATE TABLE T2(ID INTEGER, ...
7725 Sep 2012 @ 12:55 PDTUDAReplyconvert varchar to timestampTry select cast ('2012-09-25 00:49:59' as timestamp(0) format 'yyyy-mm-ddBhh:mi:ss') 'B' is used to represent the space in the format string!
7625 Sep 2012 @ 12:33 PDTDatabaseReplyCode ConversionWhy don't you test it on some sample data!
7525 Sep 2012 @ 12:31 PDTGeneralReplyForum email notifications temporarily disabledI am using Firefox as well and I can see the mail icon on forum's main page :)
7424 Sep 2012 @ 02:10 PDTToolsReplyDate (Y2K) IssueTeradata stores the dates internally in the INTEGER format consisting of CYYMMDD. C=0 means 19th Century and C=1 means 20th Century. Because there is no century mentioned in the data '23-DEC-...
7324 Sep 2012 @ 02:03 PDTDatabaseReplyCompression on IndexesBTW you can't have multivalue compression on JI. But you can compress the index by grouping the columns in select statement in fixed portion and repeated portion. Something like this SELECT (c...
7224 Sep 2012 @ 01:51 PDTDatabaseReplyCompression on IndexesYou should find the syntax in Teradata SQL Reference for Data Definition Statements... I guess this is the link www.teradataforum.com/teradata_pdf/b035-1144-115a.pdf In my personal view adding th...
7124 Sep 2012 @ 01:33 PDTDatabaseReplyRegarding inserting a unicode character into Teradata tableIf you are using ODBC connection, then you can change the session's charset usind ODBC Data Source Administrator. Open it and configure the DSN, there is a list of Session Character Sets availa...
7024 Sep 2012 @ 01:02 PDTDatabaseReplydiagnostic ... statementsThe following SQL Reference manual for Data Definition Statements... www.info.teradata.com/edownload.cfm?itemid=072600011
6924 Sep 2012 @ 12:49 PDTDatabaseReply3706 Syntax error with select statementThe Substring syntax is not correct. You either use SUBSTR(text, 0, 11) OR SUBSTRING(text FROM 0 FOR 11)  
6824 Sep 2012 @ 09:58 PDTDatabaseReplyRegarding inserting a unicode character into Teradata tableWhat is your session characterset set to?
6724 Sep 2012 @ 12:03 PDTDatabaseReplyFrom which Table?If you mean Column name by the 'variable' then you can find all the available columns in the system in dbc.columns  
6622 Sep 2012 @ 03:31 PDTDatabaseReplyObtaining DDL Information From The System TablesIf you want to get this information through dbc metadata tables then as Dieter mentioned, it is not possible to get all 'possible' parameter information. You can get the latest table defin...
6522 Sep 2012 @ 03:08 PDTDatabaseReplyHow to check access privileges??You can use the view DBC.ALLRIGHTS and DBC.ALLROLERIGHTS to get the rights granted directly to a database and the ones that are granted through a role...
6422 Sep 2012 @ 03:02 PDTDatabaseReplyStored Procedure ErrorYou can call the stored procedure using the statement CALL MyFirstProc(1077, saleamt, 0); The Rule is - IN parameters, you have to pass the value - OUT parameters, you have to specify a variabl...
6322 Sep 2012 @ 02:49 PDTDatabaseReplyPartition Violation ErrorGood that you know the reason for getting the error! Having a partition defined on the integer value of dates doesn't seem logical to me. Normaly the tables are partitioned based on the interv...

Pages