442 | 05 Mar 2006 @ 11:25 PST | BBR2 | Database | Reply | 10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this network | I 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... |
441 | 05 Mar 2006 @ 11:16 PST | BBR2 | Tools | Reply | Date Format In Teradata SQL Assistant | I 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... |
440 | 05 Mar 2006 @ 11:10 PST | BBR2 | Tools | Reply | Bteq in Report format | Try .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 |
439 | 05 Mar 2006 @ 11:01 PST | BBR2 | Tools | Reply | multiload | You 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 ... |
438 | 05 Mar 2006 @ 10:52 PST | BBR2 | Database | Reply | Teradata Backup | Standard 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 ... |
437 | 05 Mar 2006 @ 09:31 PST | ycai | Tools | Topic | fastexport and fastload forutf8 table | I 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.... |
436 | 04 Mar 2006 @ 04:30 PST | DEEPU | Analytics | Reply | Formating TIME to load using multi load | I 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... |
435 | 03 Mar 2006 @ 07:04 PST | sys-eng | UDA | Topic | AWS specs needed | I 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... |
434 | 03 Mar 2006 @ 06:46 PST | nccoyle | Tools | Topic | Time Convert in Fast load - AM / PM | Hello,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... |
433 | 03 Mar 2006 @ 03:55 PST | MNagat | Database | Topic | Compound 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... |
432 | 03 Mar 2006 @ 11:16 PST | TDUser-781 | Tools | Reply | Fast Export | I 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) |
431 | 03 Mar 2006 @ 10:09 PST | Bob Hanson | Database | Reply | Teradata Backup | You 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... |
430 | 03 Mar 2006 @ 02:44 PST | TS | Tools | Reply | Fast Export | This 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... |
429 | 03 Mar 2006 @ 02:34 PST | ANGEL | Tools | Reply | Loading from a .txt file using OLE load | Hi,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... |
428 | 02 Mar 2006 @ 10:59 PST | SD | Database | Reply | Locking modifer for a MSR | Barry, I had not thought of the locking modifier getting used in the DDL. Thanks for pointing this out to me. |
427 | 02 Mar 2006 @ 03:59 PST | Tifosi | Tools | Topic | Loading from a .txt file using OLE load | Hi,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? |
426 | 02 Mar 2006 @ 03:44 PST | ntddba | Database | Topic | Teradata Backup | HiI 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... |
425 | 02 Mar 2006 @ 01:19 PST | Caleks | Tools | Topic | Autonumber as Composed key | Situation: 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 ... |
424 | 02 Mar 2006 @ 06:12 PST | blacknight | Training | Reply | Preparation for the Teradata SQL exam | do refer the test papers at www.coffingdw.com . 5-10% questions, from here will definitely there in the actual exam |
423 | 02 Mar 2006 @ 03:13 PST | TDUser-781 | Database | Reply | Loading 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... |
422 | 01 Mar 2006 @ 08:05 PST | shaik.feroz@aaa-calif.com | Database | Reply | Secondary Index | Use 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... |
421 | 01 Mar 2006 @ 07:57 PST | shaik.feroz@aaa-calif.com | Database | Topic | Loading 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... |
420 | 01 Mar 2006 @ 05:51 PST | AP | Connectivity | Topic | Embedded SQL in UDF C code | Can 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. |
419 | 01 Mar 2006 @ 02:04 PST | Rex Chan | Connectivity | Topic | TeraResultSet:getINt: Conversion(l) | We are getting error in DBMetaData.java method getProcedureMetaData in the following program.String paramType = getParamTypeDescription (rs.getShort("COLUMN_TYPE")); We... |
418 | 01 Mar 2006 @ 01:39 PST | sudhakarb1 | Tools | Topic | MLoad Error | Hi 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 ... |