#DateForumTypeThreadPost
7207 Feb 2007 @ 11:47 PSTDatabaseReplyReducing colum lengthI dont think this can be done on a populated column.You have to drop and re-create table.
7116 Jan 2007 @ 10:58 PSTDatabaseReplyUpdate Query FailingUPDATE TARGET_TABLE SET COL_VARCHAR = 'a';
7020 Nov 2006 @ 06:06 PSTDatabaseTopicTabel overhead error 5708How can i get the overhead (value) on a table.we were creating a table and ran into an error 5708 (exceeding table overhead).we removed some of the compression values in the create table and it wor...
6905 Oct 2006 @ 01:43 PDTDatabaseReplyCollect statistics questionLeo thanks for the information.I tried it out and it worked fine, But there is a catch. When we use sample the stats are collected on one AMP and then the value is multiplied by the number of amps....
6804 Oct 2006 @ 01:16 PDTDatabaseReplyupdate problemA target table row must be matching more than one row in the source table.Do a select and see which target table row is matching multiple source rows.
6704 Oct 2006 @ 01:12 PDTDatabaseTopicCollect statistics questionALL,We have a job that collect statistics on a huge table and it takes aroung 6 hours.I heard that we can take collect statistics on a few amps instead of all the data, How can we do this? and is t...
6615 Sep 2006 @ 06:30 PDTToolsReplyRDBMS error 8018 while running fastload.solved this issue bu reducing the number of seesions assigned in the multiload and fastload scripts.in multiload and fastload scriptssessions 1;it worked fine with no errors, our environment has 3 ...
6515 Sep 2006 @ 03:46 PDTUDAReplyformatting datesel cast((current_date (format 'yydd')) as char(4))
6415 Sep 2006 @ 11:52 PDTAnalyticsReplysimple formatting questionif you want to see a number in decimal format cast the numbercast(10 as decimal(5,2))if you have divisions thencast(15 as decimal(5,2))/NumAccts as NewNum2this should display decimal values.Select ...
6308 Sep 2006 @ 07:36 PDTThird Party SoftwareReplyIssue using Informatica to load Teradata tables.Thanks Mahesh and all,I used the external loader fastload option to load the data, It did save a lot of time.
6208 Sep 2006 @ 02:10 PDTDatabaseReplyHow to modify datatype of a column using alter table commandPrabaharan,the add option will not add new coloum in this case.it will just modify the length of the column.
6106 Sep 2006 @ 11:51 PDTDatabaseReplyHow to modify datatype of a column using alter table commandalter table empadd salary decimal(15,2);This will alter the col length, the length can be increased but cannot be decreased.
6005 Sep 2006 @ 12:21 PDTToolsReplyLoading space into a Decimal(15,2) columnAnand,Could you add a case statement in the Mload to check for space in the source file and the load only the valid decimal values.
5905 Sep 2006 @ 12:05 PDTDatabaseReplySQL Qery Performance ProblemI am not sure if it should matter to move the joins around. Best thing would be to run an explain with "diagnostics on" and then collect the statistics this will make a huge difference. The planne...
5831 Aug 2006 @ 06:38 PDTDatabaseTopicExpanding the column sizeAll,I have a tabel that has a column defined as varchar(20)I expanded this column to varchar(30)after expanding the column it adds FORMAT 'X(20)' to the columnHere is the scenario.create table devd...
5729 Aug 2006 @ 09:36 PDTDatabaseReplyConfiguring a Teradata Relational Database Connection for informatica(Informatica Workflow Monitor)Mahesh, I am not sure if you got answer for your question or not.try this.First on the informatica server create an ODBC connection to your Teradata database.assume you gave the name as Retail_Prod...
5603 Aug 2006 @ 01:08 PDTDatabaseReplySpool Space Issuesdo an explain on this query withdiagnostic helpstats on for session;This will show if there are any statistics that should be collected.collect the statistics and then run your query.that will help.
5517 Jul 2006 @ 12:28 PDTToolsReplyTeradata load utility : Fast loadThe fastload only loads data into empty tables.when a job fails after a certain checkpoint and when the job is rerun, this does not mean that the table has data in it. The table is still in loading...
5417 Jul 2006 @ 12:22 PDTToolsReplyProblem in fast load (Urgent)try thisset record vartext "|" NOSTOP;sessions 2;.errlimit 50;.LOGON DemoTDAT/dbc,dbc;.set record textDATABASE ez;DROP table CartLine1;drop table CartLine1_ERR1;drop table CartLine1_ERR2;CREATE TAB...
5314 Jul 2006 @ 03:02 PDTToolsTopicRDBMS error 8018 while running fastload.All, I get this error while running the fastload.the table is locked and i had to drop and recreate the table, and I still get this error.**** 10:34:38 Number of recs/msg: 103**** 10:34:38 Starting...
5206 Jul 2006 @ 06:37 PDTDatabaseTopicerror while using fastload. ?All,I am trying to use fastload (interactive mode) and i get this error.I am able to connect using ODBC (sql assistant)i am using windows environment, and i added the server name and IP address in ...
5106 Jul 2006 @ 06:36 PDTToolsTopicerror while using fastload. ?All,I am trying to use fastload (interactive mode) and i get this error.I am able to connect using ODBC (sql assistant)i am using windows environment, and i added the server name and IP address in ...
5021 Jun 2006 @ 02:49 PDTThird Party SoftwareTopicIssue using Informatica to load Teradata tables.I have an issue while loading data from sql server to Teradata database. It takes a very long time to load 100K rows. when i checked the log I guess it is doing a row level insert instead of a bulk...
4921 Jun 2006 @ 02:46 PDTAnalyticsTopicproblem using Informatica to load Teradata tables.I have an issue while loading data from sql server to Teradata database. It takes a very long time to load 100K rows. when i checked the log I guess it is doing a row level insert instead of a bulk...
4826 May 2006 @ 12:16 PDTDatabaseReplyComparing two tablesThank you very much!I really appreciate it.

Pages