#DateForumTypeThreadPost
16204 Nov 2011 @ 05:40 PDTConnectivityReplyHow to install TERADATA CLI Libraries in UNIX Server(AIX-6.1) #1. Will it be possible to install TERADATA on UNIX server with the mech-id or we need root access on the server? From the docco: How to install this package: 1.  Log...
16102 Nov 2011 @ 08:42 PDTDatabaseReplyQuestion on restoring database using Teradata Arcmain Tim_Qiu:   COPY DATA TABLE (tbase) -->> Destination Table FROM (tbase) -->>Name of the table archived (source). FILE = tbase -->>Name of the file used when...
16031 Oct 2011 @ 03:08 PDTDatabaseReplyWarning: EOF On Input Stream Here is an example:    BTEQ -- Enter your SQL request or BTEQ command: CREATE SET TABLE MY_DB.PRUEBA01 (ID_N INTEGER NOT NULL,        &...
15929 Oct 2011 @ 11:19 PDTDatabaseReplyWarning: EOF On Input Stream You may take a look at this thread: http://forums.teradata.com/forum/tools/can-a-bteq-script-be-called-from-another-bteq-script HTH. Cheers. Carlos.
15828 Oct 2011 @ 12:42 PDTDatabaseReplyTeradata Stored Procedure   >>"As for stored procedures, talking in TD 13 context, is it still bad on performance ?" And you are saying this because... >>"As in doesnt utilize ...
15726 Oct 2011 @ 12:05 PDTDatabaseReplyMystery around trailing space Karam: There is no 'mystery' in that. It's only ANSI SQL. Strings are padded with spaces to match the lengths before comparision. The exception is 'LIKE'. See it your...
15625 Oct 2011 @ 02:18 PDTToolsReplyCan a BTEQ script be called from another BTEQ script? It works (even 'nested' calls), but not in 'interactive mode':   caller.sql: .logon my_db/user,password select date caller1; .run file C:\Process\called.sql se...
15525 Oct 2011 @ 12:16 PDTAnalyticsReplyCasting char(3) to integer No need to do that:    BTEQ -- Enter your SQL request or BTEQ command: CREATE TABLE MY_DB.PRUEBA01(ID_N INTEGER NOT NULL,         &n...
15424 Oct 2011 @ 12:03 PDTDatabaseReply3806: Table/view/trigger name is ambiguous >>"create volatile table tbl4 as ( sel * from tbl1 join db.tbl5 on tbl1.col1=tbl4.col1) with data;" You are making the join between tbl1 and tbl4 instead of tbl5. HTH...
15322 Oct 2011 @ 03:18 PDTCloud ComputingReplyTD express on Red Hat The VMware network must be configured BRIDGED to allow other machines reach the VMachine or You can use the VMware port redirection feature or You can use an external port redirector (ri...
15220 Oct 2011 @ 03:53 PDTGeneralReplyUSe of COMMIT and ROLLBACK in Teradata >>"Though each nd every DML statement in Teradata is Auto commit" That's not true. You can declare explicit transactions in Teradata, both in Teradata mode and ANSI mode....
15119 Oct 2011 @ 08:21 PDTConnectivityReplyHow to install TERADATA CLI Libraries in UNIX Server(AIX-6.1) Jatin: Download & Instructions here: http://downloads.teradata.com/download/connectivity/cliv2/aix HTH. Cheers. Carlos.
15018 Oct 2011 @ 08:18 PDTDatabaseReplyWhat is the difference between a YNET and BYNET? The YNET was the hardware interconnect & sorting solution in the DBC 1012. The BYNET is software solution, based on the YNET. In other words: YNET was the BYNET's grandfather ;-)...
14915 Oct 2011 @ 02:40 PDTGeneralReplyNot able to access table after Macro Fails Harish: Please post the DDL, the macro code and the especific error, because my cristal ball is malfunctioning these days... Funny how posters still think we can figure out the solution ...
14814 Oct 2011 @ 12:01 PDTDatabaseReplyBteq equivalent of Sqlplus 'whenever sql error exit failure' sunilp: Take a look at 'SET MAXERROR' in the bteq manuals. HTH. Cheers. Carlos.  
14710 Oct 2011 @ 08:22 PDTToolsReplyBTEQ date import error Try INSERT INTO my_db.my_emp_tb values ( :emp_id, CAST(:emp_dob AS DATE FORMAT 'MM-DD-YYYY'), CAST(:emp_doj AS DATE FORMAT 'DD/MM/YYYY') ); &nbs...
14603 Oct 2011 @ 03:55 PDTDatabaseReplyDeleting data from both Parent and underlying foreign key related tables at same time There is not 'ON DELETE CASCADE' in Teradata (if that's what you are looking for. You should handle the whole delete process within a transaction (implicit or explicit). HTH....
14526 Sep 2011 @ 11:55 PDTGeneralReplyControl characters while exporting the data This question has been answered over and over again. The 'control characters' that you see are the bytes indicating the length of the varchar fields. Cheers. Carlos.
14422 Sep 2011 @ 06:46 PDTDatabaseReply'Materialized View' in Teradata? Yup. In Oracle you can decide when to refresh the MV, but in Teradata you can only use a table and 'refresh' it whenever you want. Cheers. Carlos.
14322 Sep 2011 @ 02:51 PDTDatabaseReply'Materialized View' in Teradata? >>"Does teradata has the same function?"   Join Indexes in their different flavours.   HTH. Cheers. Carlos.    
14214 Sep 2011 @ 08:41 PDTDatabaseReplyUnique secondary index violation error Kishore_1: >>"There is a table with the following definition:" No, there isn't, and there cannot be. The DDL provided is incorrect. You cannot declare P...
14126 Aug 2011 @ 12:50 PDTGeneralReplyDELETING DUPLICATES I NEED SQL QUERY IN TERADATA The solution posted by akolla is taken from here: http://carlosal.wordpress.com/2009/12/07/borrando-filas-duplicadas-en-teradata/ If you cannot use 'ALTER TABLE' you could use th...
14010 Aug 2011 @ 11:50 PDTDatabaseReplymultiple inserts in one statementThe syntax referred is not ANSI. You can build a text file with the values to insert and use .IMPORT in bteq or any other tool. HTH. Cheers. Carlos.
13903 Aug 2011 @ 04:00 PDTAnalyticsReplyHow to break a date range into 2 different rows?This solution may fit: BTEQ -- Enter your SQL request or BTEQ command: SELECT * FROM MY_DB.MY_TABLE ; *** Query completed. 6 rows found. 3 columns returned. *** Total elapsed time...
13828 Jul 2011 @ 12:20 PDTDatabaseReplyTimeStamp value for every record inserted using ins/selectDieter: I think I don't get it. The SP solution will serialize the inserts and is not guaranteed to work as expected (unique timestamp(0)) in a multiuser environment (at least without explici...

Pages