#DateForumTypeThreadPost
14807 Oct 2008 @ 11:16 PDTToolsReplyBTEQ- Assign Value to User Defined Variable.Hello,This link may be of some help: http://www.teradata.com/teradataforum/Topic12972-10-1.aspx#bm12976Regards,Adeel
14707 Oct 2008 @ 11:14 PDTConnectivityReplySupport of Teradata ODBC Driver for AIXHello,It definitly should not work! For compatible ODBC driver check this out: http://www.teradata.com/DownloadCenter/Forum95-1.aspxHTH!Regards,Adeel
14606 Oct 2008 @ 11:12 PDTDatabaseReplyRandom Competition DrawsHello,One of the easiest solutions may be as follows:- Create another table with two columns, one auto-generated identity, other MSN value.- Insert "Number_of_Entries" times the MSN value in the ne...
14525 Sep 2008 @ 04:07 PDTToolsReplyFAST LOAD ERRORWell, if the data file is also same, then ideally there shouldn't be any problem.Can you please check if you are using same FastLoad script as well (with different LOGON string ... offcourse)?Lastl...
14425 Sep 2008 @ 01:07 PDTToolsReplyFAST LOAD ERRORHello,First try loading after dropping USI. If it still does not work, you need to check following points:- Is the table DDL exactly same in both systems/environments- Is the data file being used s...
14323 Sep 2008 @ 10:12 PDTToolsReplyMigrating Million rows into teradata tablesHello,If disk-space is not an issue for you, you can create a flat data file from SQL Server and use FastLoad to load it to Teradata. Your second option can be using TPT with data-direct to connect...
14222 Sep 2008 @ 04:33 PDTToolsReplyBTEQ- Assign Value to User Defined Variable.Well I haven't tried it on Windows but it is do-able in UNIX. May be DOS script can be something useful.Additionally, following may be of some help:- Put a marker in place of variable in BTEQ scrip...
14122 Sep 2008 @ 04:06 PDTDatabaseReplyTrigger to invoke a jobHello,Triggers cannot be scheduled to trigger...but offcourse they are triggered by DBMS itself on a defined trigger action.Regards,Adeel
14022 Sep 2008 @ 04:01 PDTToolsReplyBTEQ- Assign Value to User Defined Variable.Hello,How about taking input in shell script and passing it to BTEQ script?Regards,Adeel
13917 Sep 2008 @ 06:29 PDTConnectivityReplyUDF not working correctlyWhy you have second input parameter as "Double"? Though you are putting in an integer. Try by changing it to integer.HTH.Regards,Adeel
13817 Sep 2008 @ 05:27 PDTConnectivityReplyUDF not working correctlyHello,Can you provide the C code?Regards,Adeel
13716 Sep 2008 @ 03:37 PDTDatabaseReplyGeeting count of data from 2 diff table swhich dont have common columns in itHello,You can use following:SELECT SUM(CountTables) FROM( SELECT COUNT(*) AS "CountTables" FROM Table1 UNION SELECT COUNT(*) AS "CountTables" FROM Table2) Alias1;HTH.Regards,Adeel
13615 Sep 2008 @ 10:01 PDTUDAReplyOnline reference to OLAP functionality in Teradata SQLHello,Yes it surely is. Goto "http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%20Database", select the Teradata version, and look for "SQL Reference: Data Manipulatio...
13513 Sep 2008 @ 08:41 PDTAnalyticsReplyUsage of Qualify in where ClauseHello,The query you provided should work (in V2R6 it does). Can you please explain what exactly you are willing to do?Regards,Adeel
13412 Sep 2008 @ 01:59 PDTConnectivityReplyODBC load performanceHello,Well we can expect abit more from ODBC, but definitely alot more from Teradata. Your best option to load data is to make a flat file and load it via FastLoad or MultiLoad or perhaps you can u...
13310 Sep 2008 @ 10:24 PDTAnalyticsReplyHiding a column from outputHello,You can also try following:SELECT CUST_ID,DTE_BIRTH,CASEWHEN (DATE-DTE_BIRTH)/365.25 < 18THEN 'Under 18'WHEN (DATE-DTE_BIRTH)/365.25 BETWEEN 18 and 65THEN 'Between 18 and 65'WHEN (DATE-DTE...
13209 Sep 2008 @ 10:00 PDTToolsReplyEXEC BTEQHello,Following are two possible cases:1. You are currently in same directory2. You are in any other directoryFor Case 1, just type "bteq < A.txt" and press enter.For Case 2, type "bteq < D:\...
13108 Sep 2008 @ 02:12 PDTConnectivityReplyTeradata with SSISHello,As far as connection to Teradata is concerned, you can use .NET or ODBC driver for Teradata. Following is the URL for that:- http://www.teradata.com/DownloadCenter/Regards,Adeel
13007 Sep 2008 @ 11:03 PDTDatabaseReplyConverting a character value to date formatHello,Your best option will be a UDF.From the values provided, only "01/20/2007" can be changed to date (any allowed format you like), rest are not valid date values.Regards,Adeel
12907 Sep 2008 @ 11:00 PDTDatabaseReplyHow to Enable/Disable Indexes in Teradata.Hello,You cannot drop UPI of a table, though you can change the values of it. Can you please provide table DDL of which you want to change UPI values?Regards,Adeel
12801 Sep 2008 @ 12:17 PDTDatabaseReplyHow to fetch only the first character from a word using FORMAT optionHello,The following query is a valid query for this task in BTEQ:SELECT 'abcd' (FORMAT 'X');Result: 'a'Running the same query in SQL Assistant will return the same whole string i.e. 'abcd'.This is ...
12728 Aug 2008 @ 12:21 PDTDatabaseReplyskew factorIn Teradata Administrator you can simply right-click the table and select "Space Summary".Regards,Adeel
12628 Aug 2008 @ 07:31 PDTDatabaseReplyCreating Volatile TableHello,Volatile tables are created in a user's session (user space) not in database. So, removing the "ABC." from the DDL will solve the issue.Regards,Adeel
12528 Aug 2008 @ 03:10 PDTDatabaseReplyConversion of ascii values to coresspondin alphabets.Hello,There is no built-in function for ASCII conversion though, a UDF or SQL (search the forum I posted similar few days back) can be written for this purpose.Regards,Adeel
12427 Aug 2008 @ 01:08 PDTDatabaseReplyskew factorHello,Skewness is the statistical term, which refers to the row distribution on AMPs. If the data is highly skewed, it means some AMPs are having more rows and some very less i.e. data is not prope...

Pages