1092 | 07 Jun 2006 @ 11:08 PDT | j355ga | Database | Reply | Finding Foreign Key for Primary Key Column | If you are using V2R6 then this will identify all dependencies. Replace the literals with the db and table you want to trace all dependencies from. I had to use a staging table because the view db... |
1091 | 07 Jun 2006 @ 11:05 PDT | DEEPU | Database | Reply | why this error was raised? help me! | Just adding to Jim's reply- you can use 'group by' also.'GROUP BY' is faster than 'Distinct'.UPDATE TTEMP.TB_MID_NEW_INNET_SUBSCRIBERFROM (SELECT MSISDN FROM PVIEW.VW_NET_GSM_NL_200604 GROUP BY 1) ... |
1090 | 07 Jun 2006 @ 10:59 PDT | DEEPU | Database | Reply | Finding Foreign Key for Primary Key Column | You can use the following system views.DBC.RI_CHILD_TABLESDBC.RI_DISTINCT_CHILDRENDBC.RI_DISTINCT_PARENTSDBC.RI_PARENT_TABLES |
1089 | 07 Jun 2006 @ 09:56 PDT | PGF | Connectivity | Topic | Error from .Net Provider - CLI2: BADMOVEMODE(387) | Hi,I'm trying to use the new .Net provider but get an error when opening the connection - CLI2: BADMOVEMODE(387).From the messages manual:387 BADMOVEMODE loc_mode cannot be set to 'N' in Buffer Mod... |
1088 | 07 Jun 2006 @ 06:05 PDT | maheshgodi | Database | Reply | Question Regarding from sub tables? | Thanks for your reply.You mean that.. There is no way to retrieve data from sub tables-Best Regards,Mahesh Godi. |
1087 | 07 Jun 2006 @ 05:47 PDT | manne | Database | Reply | Question Regarding from sub tables? | users cannot retrieve the data from subtables directly, Optimizer uses this subtables to fetch the data to requesting user. |
1086 | 07 Jun 2006 @ 05:39 PDT | manne | Database | Reply | Difference between Teradata Utilities and ETL Process | The process of ETL using Teradata utilities will be ELTExtract, Load and Transformso, the loading will be done through Fast load, Multi load and the transofmations can be done using Bteq scripts :-) |
1085 | 07 Jun 2006 @ 04:54 PDT | alphajet | Database | Topic | Multiload question | for a multi load , How many IMPORT, DELETE tasks can be run in parallel ?? |
1084 | 07 Jun 2006 @ 04:52 PDT | alphajet | Database | Topic | Multiload question | for a multi load , How many IMPORT, DELETE tasks can be run in parallel ?? |
1083 | 07 Jun 2006 @ 04:52 PDT | alphajet | Database | Topic | Multiload question | for a multi load , How many IMPORT, DELETE tasks can be run in parallel ?? |
1082 | 07 Jun 2006 @ 02:48 PDT | akhil.bansal@gmail.com | Connectivity | Topic | Extended Stored Procedure to send mail | Hi,I am in the process of developing an extended stored prodedure that will sent mail. The Teradata system on which this prodedure will be used is a 6 node system. It is necessary to have SMTP conf... |
1081 | 07 Jun 2006 @ 02:26 PDT | akhil.bansal@gmail.com | Database | Topic | Finding Foreign Key for Primary Key Column | Hi,Is there is a way to find foreign key columns that references to a primary key ?i.e I have table PrimaryTable which has Col1 as primary key. I want to find out the tables having columns that ha... |
1080 | 07 Jun 2006 @ 02:09 PDT | rgans_99 | Database | Reply | 10065 WSA E HostUnreach | Hi,Check whether you use any Firewall S/W.If it is so,turn off and try it.If the Teradata Service is running and if you are unable to connect it thruoghSQL Assistant then this error may be reported... |
1079 | 06 Jun 2006 @ 04:54 PDT | DaveH | Connectivity | Reply | .Net driver | I downloaded and installed all those.. Is there a way to confirm the proper DLL versions are actually found? |
1078 | 06 Jun 2006 @ 03:38 PDT | Fred | Connectivity | Reply | .Net driver | The .NET Data Provider requires CLIv2, which in turn will require tdicu and TeraGSS. The download from Teradata.com "Drivers and UDFs" area is a self-extracting ZIP that includes all necessary comp... |
1077 | 06 Jun 2006 @ 03:24 PDT | emoore | Connectivity | Reply | Teradata ODBC Trouble in MS/Access | I installed and uninstalled sql assistant 7.1 and tdodbc.03.05.00.04.exe i am getting the same error: 160: Specific Driver could not be loaded due to system error 126 (teradata). I deleted the noc ... |
1076 | 06 Jun 2006 @ 01:21 PDT | Jim Chapman | Database | Reply | why this error was raised? help me! | A correlated subquery might be faster. Try this:update TTEMP.TB_MID_NEW_INNET_SUBSCRIBERset Active_Month = 200604where Active_Month is nulland substr(cast(START_DATE as format 'YYYYMM'), 1, 6) = '... |
1075 | 06 Jun 2006 @ 09:40 PDT | stami27-2406 | Database | Topic | Collecting Statistics on multiple Columns | Hi all,Is the orde of columns in the collect statistics statemen important or no?e.g. COLLECT STATISTICS ON table_1 COLUMN (column_2, column_1); orCOLLECT STATISTICS ON table_1 COLUMN (column_1, co... |
1074 | 06 Jun 2006 @ 07:12 PDT | maheshgodi | Database | Topic | Question Regarding from sub tables? | Can any body know how to see or retrieve data from sub tables? Regards,Mahesh |
1073 | 05 Jun 2006 @ 09:35 PDT | jufu | Database | Reply | why this error was raised? help me! | Thanks, Jim Chapman!It's work, but runs slowly! Maybe due to using distinct. |
1072 | 05 Jun 2006 @ 07:58 PDT | DaveH | Connectivity | Topic | .Net driver | Just saw that there was a .Net driver, and tried it right away..Maybe I installed something in the worng order? I get:"Unable to load DLL 'wincli32.dll': The specified procedure could not be found... |
1071 | 05 Jun 2006 @ 05:50 PDT | naveen | UDA | Reply | Teradata Upgrade | Will I get the release note for this? Can any one help me in this? |
1070 | 05 Jun 2006 @ 02:47 PDT | Jim Chapman | UDA | Reply | Teradata Upgrade | Every new release contains many bug fixes, performance/availability/usability improvements, and new features. Consult the release documentation for details. |
1069 | 05 Jun 2006 @ 01:59 PDT | naveen | UDA | Topic | Teradata Upgrade | What are the changes in V2R6.1 and TTU8.1? |
1068 | 05 Jun 2006 @ 01:13 PDT | Jim Chapman | Database | Reply | why this error was raised? help me! | Try this:update TTEMP.TB_MID_NEW_INNET_SUBSCRIBERfrom (select distinct MSISDN from PVIEW.VW_NET_GSM_NL_200604) aset Active_Month = 200604where Phone_No = a.MSISDN and Active_Month is nulland substr... |