All forum activity

#DateUserForumTypeThreadPost
109207 Jun 2006 @ 11:08 PDTj355gaDatabaseReplyFinding Foreign Key for Primary Key ColumnIf 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...
109107 Jun 2006 @ 11:05 PDTDEEPUDatabaseReplywhy 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) ...
109007 Jun 2006 @ 10:59 PDTDEEPUDatabaseReplyFinding Foreign Key for Primary Key ColumnYou can use the following system views.DBC.RI_CHILD_TABLESDBC.RI_DISTINCT_CHILDRENDBC.RI_DISTINCT_PARENTSDBC.RI_PARENT_TABLES
108907 Jun 2006 @ 09:56 PDTPGFConnectivityTopicError 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...
108807 Jun 2006 @ 06:05 PDTmaheshgodiDatabaseReplyQuestion 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.
108707 Jun 2006 @ 05:47 PDTmanneDatabaseReplyQuestion Regarding from sub tables?users cannot retrieve the data from subtables directly, Optimizer uses this subtables to fetch the data to requesting user.
108607 Jun 2006 @ 05:39 PDTmanneDatabaseReplyDifference between Teradata Utilities and ETL ProcessThe 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 :-)
108507 Jun 2006 @ 04:54 PDTalphajetDatabaseTopicMultiload questionfor a multi load , How many IMPORT, DELETE tasks can be run in parallel ??
108407 Jun 2006 @ 04:52 PDTalphajetDatabaseTopicMultiload questionfor a multi load , How many IMPORT, DELETE tasks can be run in parallel ??
108307 Jun 2006 @ 04:52 PDTalphajetDatabaseTopicMultiload questionfor a multi load , How many IMPORT, DELETE tasks can be run in parallel ??
108207 Jun 2006 @ 02:48 PDTakhil.bansal@gmail.comConnectivityTopicExtended Stored Procedure to send mailHi,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...
108107 Jun 2006 @ 02:26 PDTakhil.bansal@gmail.comDatabaseTopicFinding Foreign Key for Primary Key ColumnHi,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...
108007 Jun 2006 @ 02:09 PDTrgans_99DatabaseReply10065 WSA E HostUnreachHi,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...
107906 Jun 2006 @ 04:54 PDTDaveHConnectivityReply.Net driverI downloaded and installed all those.. Is there a way to confirm the proper DLL versions are actually found?
107806 Jun 2006 @ 03:38 PDTFredConnectivityReply.Net driverThe .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...
107706 Jun 2006 @ 03:24 PDTemooreConnectivityReplyTeradata ODBC Trouble in MS/AccessI 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 ...
107606 Jun 2006 @ 01:21 PDTJim ChapmanDatabaseReplywhy 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) = '...
107506 Jun 2006 @ 09:40 PDTstami27-2406DatabaseTopicCollecting Statistics on multiple ColumnsHi 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...
107406 Jun 2006 @ 07:12 PDTmaheshgodiDatabaseTopicQuestion Regarding from sub tables?Can any body know how to see or retrieve data from sub tables? Regards,Mahesh
107305 Jun 2006 @ 09:35 PDTjufuDatabaseReplywhy this error was raised? help me!Thanks, Jim Chapman!It's work, but runs slowly! Maybe due to using distinct.
107205 Jun 2006 @ 07:58 PDTDaveHConnectivityTopic.Net driverJust 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...
107105 Jun 2006 @ 05:50 PDTnaveenUDAReplyTeradata UpgradeWill I get the release note for this? Can any one help me in this?
107005 Jun 2006 @ 02:47 PDTJim ChapmanUDAReplyTeradata UpgradeEvery new release contains many bug fixes, performance/availability/usability improvements, and new features. Consult the release documentation for details.
106905 Jun 2006 @ 01:59 PDTnaveenUDATopicTeradata UpgradeWhat are the changes in V2R6.1 and TTU8.1?
106805 Jun 2006 @ 01:13 PDTJim ChapmanDatabaseReplywhy 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...

Pages