#DateForumTypeThreadPost
3530 Nov 2009 @ 09:03 PSTDatabaseReplyHow to find the associated tables or view in teradata?You can find the same by using the following Query:It'll show all the Tables/Views referenced...SHOW SELECT * FROM DatabaseName.TableName;In the answerset, you'll get different tabs.
3428 Oct 2009 @ 11:20 PDTDatabaseReplyserach for "?"I've tried the following query in Queryman - it's perfectly giving the expected data. SELECT COLUMN_NAME FROM TABLE_NAME WHERE COLUMN_NAME LIKE '%?%';You can also try this one - same result would ...
3325 Sep 2009 @ 09:04 PDTDatabaseReplyStrange Problem on "qualify"Hi Gary,Your 2nd query will also not run. It'll throw the same error - as you got in the First Query.How you're getting the result!The Column4 has to be there in Select if you partition by Column4....
3225 Sep 2009 @ 05:54 PDTDatabaseReplyReversing of the fieldRead the following post in TeradataForumIt's regarding the Reverse of a String...http://www.teradata.com/teradataForum/Topic8565-5-1.aspx
3107 Sep 2009 @ 06:28 PDTDatabaseReplyCreate table and insert data into Teradata database from MS SQL ServerAre you using any ETL tool! Then that would be easiest.Otherwise export the data from MS server to a Flat File and Import the Flat File in Teradata Database using Loaders.Regards,ANIMESH DUTTA
3007 Sep 2009 @ 06:24 PDTDatabaseReplySubqueries WorkaroundIt's not that Sub-queries are not allowed in Teradata. It has to be handelled properly.Check - if the following query is giving the same result or not.SELECT PATIENT_NAME ,PATIENT_AGE ,PATIENT_WEI...
2907 Sep 2009 @ 03:00 PDTDatabaseReplyRecursive Updation in QueryJimm - It's a very good solution indeed from you, for the current data I've provided.But suppose the data is as follows - then it's giving no result.For the below example it should give ONE Group a...
2803 Sep 2009 @ 04:43 PDTDatabaseTopicRecursive Updation in QueryI'm stuck with the Query as described below:I've a table (T1) with following data.Col1 Col2 Col3 Expected/Output--------------------------------------------------10 20 ? G120 30 ? G140 50 ? G130 50...
2731 Aug 2009 @ 05:09 PDTDatabaseReplyHow to fetch the data from one server and insert in to other server in SQL Assistance?Raja is correct - there is no option in Teradata to load data from one server to another.If data volume is less, then you can use the same process as mentioned by Sachin.But in this case - you've t...
2629 Aug 2009 @ 05:14 PDTToolsReplyMLoad IssueHave you checked the record number 5789498 - where it's failing.Probably that line has less number of arguments - that's why read error!!!Regards,ANIMESH DUTTA
2529 Aug 2009 @ 04:35 PDTToolsTopicData Loading in Views using FastloadCan I able to Load data in Views using Fastload ???As if I've tried to load the data in a view using Fastload - it's throwing error!!!But loading data in a view using Multiload is working ...
2427 Aug 2009 @ 08:35 PDTToolsReplyTeradata sql assistant - Tools/List Columns issue with wildcard %I've tried the same thing to fetch the list of columns with % as table name - and it's resulting out with all the columns in that database. So % should work...Currently I'm using version 7.2.0.03 o...
2327 Aug 2009 @ 07:21 PDTDatabaseReplyTeradata Error PrecedenceAt the first - if you try to insert ONE ROW (Table is empty) with Null in NOT NULL Column - then Unique constraint error will not come at all - not null error will come.if you try to insert ONE ROW...
2227 Aug 2009 @ 06:48 PDTDatabaseReplyTeradata formatting using pipes.I've tested the same query in my tables in both Queryman & BTEQ - it's fetching correct result as expected.If you're getting spaces after column-value (e.g. PRODUCT_NUM |) - then try using T...
2127 Aug 2009 @ 06:29 PDTToolsTopicQueryman Export Results Error (InitExportFile Code=75)I'm trying to export the result from an SQL query through Queryman (SQL Assistant) [version 7.2, TD # V2R6.2].Whenever I'm going to run the query - instead of asking the path where to save the re...
2025 Aug 2009 @ 10:18 PDTDatabaseReplyHow to get the position of special char in a stringTo remove all the Special Characters (Or anything you don't want) from a String - just create the following procedure and Run that for any String as shown below:/* Procedure Start */REPLACE PROCEDU...
1921 Aug 2009 @ 03:53 PDTToolsReplyHow to COLLECT STATS in BTET Mode in Multi-Statement BTEQ Scripts!Yeah - we need to use an ET after COLLECT STATSthat's working fine....there is no error in the last statement...thanks Dieter...
1821 Aug 2009 @ 03:47 PDTToolsReplycan not drop table stay lockFirst drop that table/view where it's referenced.Drop the child table - then Parent table...
1721 Aug 2009 @ 03:45 PDTToolsReplyPerformance monitorYOu can not able to increase the performance of a query from PMON. But obviously by looking at the execution plan - you can tune your query. Check the CPU usage, Skew Factor et. al.Also you can inc...
1621 Aug 2009 @ 03:42 PDTToolsReplyMload IssueJust abort those sessions from Teradata Performance Monitor - if you've access OR ask your DBA to abort.Also you can grab the PID from UNIX box (from where you've run) and just kill the process.Don...
1521 Aug 2009 @ 03:32 PDTToolsReplyFastload and MultiloadIn Acquisation phase - suppose your checkpoint is 1k and your load fails at 9200 records.Those 200 records - it'll not insert at all.You can again restart the Mload by not deleting the Log/Error ta...
1421 Aug 2009 @ 03:22 PDTToolsReplyUse of Delimiter in FastloadI've tried this - not working. But if you observe the records are enclosed with double quotes (" ").In the table I don't want those double quotes obviously.For example - first column has a length o...
1321 Aug 2009 @ 03:16 PDTToolsReplyHow to get latest record for the same customerIf the Customer ID is an identity column - I mean if it's not randomly generated - then simply use Max & Min.Use ROW_NUMBER if your Customer ID is unique... it'll give the same Rank...
1221 Aug 2009 @ 02:40 PDTToolsReplyMload locksIf your Multiload job fails at Application Phase - you've to use the following statement to release the lock on the Mloaded table.RELEASE MLOAD (TableName) IN APPLY
1121 Aug 2009 @ 02:37 PDTToolsReplyDifference between select * from Table & select individual columnsI don't think any difference as such.But if you use to fetch records from a subquery and use those columns in the outer query - you need to specify column names exclusively in the sub-query.As a st...

Pages