All forum activity

#DateUserForumTypeThreadPost
44205 Mar 2006 @ 11:25 PSTBBR2DatabaseReply10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkI think your network may be behind firewall.Normally all clients communicate thru 1025 port (lets wait for experts to comment on this).Check if you can connect using this port.Other issue may be en...
44105 Mar 2006 @ 11:16 PSTBBR2ToolsReplyDate Format In Teradata SQL AssistantI believe BTEQ uses Native connections while SQL assistant use ODBC.I am not sure if we can change the ODBC settings to follow ANSI date format "AAA".I have not tried if it changes. We can probabl...
44005 Mar 2006 @ 11:10 PSTBBR2ToolsReplyBteq in Report formatTry .EXPORT REPORT FILE = FILE.TXT;Other than this there are several options that you can use for formatig. You may want to review B035-2414-093A "Basic Teradata Query"Vinay
43905 Mar 2006 @ 11:01 PSTBBR2ToolsReplymultiloadYou can monitor current MLOAD thru PMON.If there is an abend, all work tables, error tables, etc will not be dropped. I believe log tables will be used for restartablility along w/t others. At the ...
43805 Mar 2006 @ 10:52 PSTBBR2DatabaseReplyTeradata BackupStandard practice is to have two user ID Netvault1 and Netvault2 (assume you are using Netvault as your BAR solution).One user will be responsible for archiving (DUMP permissions) while other user ...
43705 Mar 2006 @ 09:31 PSTycaiToolsTopicfastexport and fastload forutf8 tableI have a script fastexport and fastload table to sync with prod and dev. That runs well on ASCII env. but it failed when table column contains Unicode columns.fastexport script:.logtable user_work....
43604 Mar 2006 @ 04:30 PSTDEEPUAnalyticsReplyFormating TIME to load using multi loadI am assuming :TIME_FLD as your host variable.1. Use SUBSTR FUNCTION SUBSTR(:TIME_FLD,1,2) || ':' || SUBSTR(:TIME_FLD,3,2) || ':' || SUBSTR (:TIME_FLD,5,2) || '.' || SUBSTR(:TIME_FLD,7,2) to...
43503 Mar 2006 @ 07:04 PSTsys-engUDATopicAWS specs neededI need some specs on the 2300-1832-8090 AWS. I did not find anything helpful in the online documents that I looked at. I need this info to create a record in our asset tracking system and for doc...
43403 Mar 2006 @ 06:46 PSTnccoyleToolsTopicTime Convert in Fast load - AM / PMHello,I am curious as to what you would recommmend in this situation. I am loading a delimited flat file with a time format as the following:HH:MM PM/AMExamples would be :9:45 AM10:25 PMUsing the F...
43303 Mar 2006 @ 03:55 PSTMNagatDatabaseTopicCompound FK allows nulls - is that normal behaviour?Hello TeraData experts,I've been surprised with the following behaviour of TD. Please see this example. Here are my tables:create table mnagat.A ( a1 INTEGER, a2 INTEGER)UNIQUE PRIMARY INDEX ( a1...
43203 Mar 2006 @ 11:16 PSTTDUser-781ToolsReplyFast ExportI think the cast should be:SELECT CAST(cast(cast(cust_id as INTEGER format ) as char(the length fo the integer format))|| '|' || cast(acct_nbr as CHAR(26)) || '|' || cast(minimum_balance as INTEGER)
43103 Mar 2006 @ 10:09 PSTBob HansonDatabaseReplyTeradata BackupYou normally have a user that is used for backup purposes.When using Arcmain to perform a backup it is true that you take two backups. I am including two examples, one for DBC and another for some...
43003 Mar 2006 @ 02:44 PSTTSToolsReplyFast ExportThis is the script that is being used:.LOGTABLE abc.datastore_log ; .logon ab/ab,;.BEGIN EXPORT SESSIONS 20 TENACITY 5 SLEEP 1;.EXPORT OUTFILE c:\OUT.txt MODE RECORDFORMAT TEXT;SELECT CAST(cast(cus...
42903 Mar 2006 @ 02:34 PSTANGELToolsReplyLoading from a .txt file using OLE loadHi,It has a graphical interface where you can just select the source database and its columns and then select the target where you want to load the tables .Once you are done with that, just tell it...
42802 Mar 2006 @ 10:59 PSTSDDatabaseReplyLocking modifer for a MSRBarry, I had not thought of the locking modifier getting used in the DDL. Thanks for pointing this out to me.
42702 Mar 2006 @ 03:59 PSTTifosiToolsTopicLoading from a .txt file using OLE loadHi,I have a .txt file that has data in the following format. "NAME"|"PLACE"|"LOCATION"I want to use OLELOAD to load my table.How shoud I go about it?
42602 Mar 2006 @ 03:44 PSTntddbaDatabaseTopicTeradata BackupHiI am new to Teradata. I understand that there are 2 types of backups required. One for DBC data dictionary and the reste for other databases. I believe that ARCUSER1 can handle the backup of othe...
42502 Mar 2006 @ 01:19 PSTCaleksToolsTopicAutonumber as Composed keySituation: At SQL Assistant, I need to create a table using an autonumber field as part of a composed primary keyComplication: When I set that autonumber field on UNIQUE PRIMARY INDEX statement, I ...
42402 Mar 2006 @ 06:12 PSTblacknightTrainingReplyPreparation for the Teradata SQL examdo refer the test papers at www.coffingdw.com . 5-10% questions, from here will definitely there in the actual exam
42302 Mar 2006 @ 03:13 PSTTDUser-781DatabaseReplyLoading 50 million rows.Hi,if your target table is empty, FLD is the fastest way to load data.As regards the 2GB size limit, what TD version are you running?In v2r4.x you have to call a dll (previously installed on your m...
42201 Mar 2006 @ 08:05 PSTshaik.feroz@aaa-calif.comDatabaseReplySecondary IndexUse PI to distribute rows evenly + use a field that is used very often in access.If you have additional fields in the table that are used very often in the queries create secondary index. or if yo...
42101 Mar 2006 @ 07:57 PSTshaik.feroz@aaa-calif.comDatabaseTopicLoading 50 million rows.We are planning to load 50 million rows (assuming it is a average size row) into a teradata table. The data is currently available on DVD's (roughly 15 of them). Do you guys know of any precautions...
42001 Mar 2006 @ 05:51 PSTAPConnectivityTopicEmbedded SQL in UDF C codeCan we include embedded SQL in UDF C Code? We want to do some business calculation through UDF. The calculation needs some info from other tables, other than the table which is queried.
41901 Mar 2006 @ 02:04 PSTRex ChanConnectivityTopicTeraResultSet:getINt: Conversion(l)We are getting error in DBMetaData.java method getProcedureMetaData in the following program.String paramType = getParamTypeDescription (rs.getShort("COLUMN_TYPE")); We...
41801 Mar 2006 @ 01:39 PSTsudhakarb1ToolsTopicMLoad ErrorHi AllI get the following error when i use the MLoad utilitycan someone please suggest me as to what i should be doing ....I am calling the MLoad utility from within a datastage job and this was a ...

Pages