#DateForumTypeThreadPost
8712 Nov 2007 @ 11:36 PSTUDATopic3813: The positional assignment list has too many valuesThis error does not seem to generate a SQLCODE, all my error handlers are standard and use SQLCODE.How can I handle this error.
8626 Oct 2007 @ 11:52 PDTDatabaseReplyAlter TableCan you post the exact syntax.I have not been able to do this with varchar or char!
8525 Oct 2007 @ 11:49 PDTUDAReplyTIMESTAMPalso that the workaround is as I suggested which is to use(CAST(CURRENT_TIMESTAMP(2) AS TIMESTAMP(2))over (CAST(CURRENT_TIME(2) AS TIMESTAMP(2))Hope this helps.
8425 Oct 2007 @ 11:46 PDTUDAReplyTIMESTAMPFYITeradata have this raised under DR 117392.This will be shipped with v2r12.
8325 Oct 2007 @ 07:18 PDTDatabaseReplyAlter TableWith reference to SQL DDL Manual.Chapter 1, Page 40:"The Teradata ALTER TABLE statement offers many extensions not offered by ANSI SQL. For example, changing column attributes in ANSI SQL is restri...
8210 Oct 2007 @ 06:56 PDTUDAReplyHow effceint the Teradata is ?I cannot analyse this without DDL, data and the SQL Statements used.An explain plan would also help.You made need join indices on your tables for the report to be efficient.Also does yer explain pl...
8110 Oct 2007 @ 06:54 PDTUDAReplyChange in Primary Key on EDW table...also remember that if you re-define the Primary Index of your table, the skew of your data across amps will most likely change for the better or the worse. You can analyse skew with the followin...
8004 Oct 2007 @ 07:19 PDTUDATopicTeradata Software Limitations & sharesI wonder if any of you guys know whether Teradata have any plans to expand the 64kb limit on SQL Statements within a stored procedure.On another note. Does anyone think buying shares in Teradata is...
7904 Oct 2007 @ 07:01 PDTUDAReplyDifference and concepts of ETL.Lots of interesting stuff there.Cheers.
7804 Oct 2007 @ 03:58 PDTUDAReplyTIMESTAMPthanks all, i appreciate all your efforts.
7703 Oct 2007 @ 11:18 PDTUDAReplyTIMESTAMPWhen I run the below statements in Queryman the 1st gives me a wrong date and the 2nd one is correct. When my colleagues do the same they get 2 correct dates.When I run them in BTEQ they are both c...
7603 Oct 2007 @ 07:03 PDTUDAReplyTOP function and PartitioningPlease ignore thread.I found as follows:select top 2 week_id from (select distinct week_id from incptanal_ged WHERE region IN ('GNI', 'GED')) a order by week_id desc;
7503 Oct 2007 @ 06:52 PDTUDATopicTOP function and PartitioningWhen I run the following I get:SELECT distinct week_idFROM Tbl_AWHERE region IN ('GNI', 'GED');week_id ----------- 200734200735200738200739I want only to retrieve the last two weeks i.e. 200...
7403 Oct 2007 @ 06:40 PDTUDAReplyDifference and concepts of ETL.Hey Paddu,It seems you get a 'Supreme Being' on this forum after a number of questions & answers are posted on this forum. It certainly is not reflective of the experience I have with Teradata. I h...
7302 Oct 2007 @ 11:22 PDTUDAReplyTIMESTAMP1.) Depends on your definition of properly set. Timezone is set as GMT - Dublin, Edinburgh etc with automatic adjustments for Daylight Savings. We are in Ireland. The Actual time is synched...
7202 Oct 2007 @ 10:53 PDTUDAReplyQuery needs to run fasterDoes your explain show a product join/cross join?Also the actual SQL Stmt and the actual explain plan would be beneficial.Have any of the tables in the select statement got no data in them?Are your...
7102 Oct 2007 @ 10:46 PDTUDAReplyDifference and concepts of ETL.Your first port of call is to find out if there is a data warehouse already existing that you are scheduled to start supporting or if your team are building a new DW from scratch.If there is alread...
7028 Sep 2007 @ 09:35 PDTUDAReplyData Skewthankyou.
6928 Sep 2007 @ 04:35 PDTUDATopicTIMESTAMPI have a stored procedure that sets a variable as follows:SELECT CAST(CURRENT_TIME(2) AS TIMESTAMP(2)) However, it has returned '2007-09-26 09:12:12.01' when it should have returned '2007-09-27 09:...
6821 Sep 2007 @ 06:26 PDTUDAReplycalculatations on timestampsperfect Fabio.Thankyou very very much.
6720 Sep 2007 @ 12:47 PDTUDATopiccalculatations on timestampsHow can I get the difference in End_dt & Start_dt timestamps in terms of hours and minutes using the following statement? If we cannot do it on insert, can it be done using a select on existing dat...
6619 Sep 2007 @ 05:54 PDTUDAReplyUndocumented Syntax ErrorThanks, Excuse my ignorance but what exactly are the USING data & and parcel overhead?Can we determine the size of this header info? So really what we are actually left with is less than 64Kb for a...
6517 Sep 2007 @ 09:00 PDTUDAReplyUndocumented Syntax ErrorYes and the limit of a direct piece of SQL in BTEQ/Queryman is 1Mb and the limit on a full sProc 64Mb.However when I paste my SQL Statement into a text document it reads 40Kb on the surface.Does Te...
6414 Sep 2007 @ 10:08 PDTUDAReplyUndocumented Syntax ErrorI've found the following documentation:The following are some important restrictions on the size and use of stored procedures:• The p****r limits apply if the SQL statements within a stored pro...
6314 Sep 2007 @ 08:16 PDTUDATopicUndocumented Syntax ErrorWe have a stored procedure 2035 lines long.We added 50 lines of code to this procedure and got the following syntax error when compiling:SPL1077:E(L1827), Request larger than the maximum permissibl...

Pages