#DateForumTypeThreadPost
23722 Aug 2012 @ 01:59 PDTToolsReplyExporting data using a BTEQ You should RTFM: .EXPORT DATA FILE DATA         Returns the results of a query to a file for processing by other programs. BTEQ returns data in Re...
23601 Aug 2012 @ 11:53 PDTDatabaseReplyQuery to generate collect stats statement automatically Hi: I use this query: http://carlosal.wordpress.com/2012/08/02/generar-collect-statistics-para-los-indices-primarios-secundarios-y-primarios-particionados/ HTH. Cheers. Carlo...
23525 Jul 2012 @ 11:53 PDTDatabaseReplybteq export line width Sorry. My crystal ball is out of order today. You fail to provide the Operating System & version, Teradata version, bteq version, DDL, script... and you still expect that someone can fig...
23423 Jul 2012 @ 01:48 PDTTeradata ApplicationsReplyTeradata Query resolving Mohan: If you want to rip off the letters from the strings, take a look at Oracle UDF oTranslate(). HTH. Cheers. Carlos.
23316 Jul 2012 @ 08:22 PDTDatabaseReplyDateTime Function Format @ Conversion of SQL Server Query to Teradata Query ISMAİL: Either I don't get it or the query does not make sense even in SQLServer... It seems you are looking for a final string (VARCHAR) with format YYYY-MM-DD. In this case: S...
23212 Jul 2012 @ 04:16 PDTDatabaseReplyCLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failed Mohammad: What is your LD_LIBRARY_PATH variable? ( echo $LD_LIBRARY_PATH ) Cheers. Carlos.
23111 Jul 2012 @ 12:01 PDTDatabaseReplyCOALESCE on timestamp(2) datatype column Srinivas:   Type mismatch:  BTEQ -- Enter your SQL request or BTEQ command: SELECT TYPE(CURRENT_TIMESTAMP(2));  *** Query completed. One row found. One colum...
23009 Jul 2012 @ 03:40 PDTDatabaseReplySql to delete duplicates in Teradata No it won't. Please, do not post if you don't know what you are talking about. Cheers. Carlos.
22903 Jul 2012 @ 11:58 PDTDatabaseReplyTemporary Tables in Teradata Hi. Just to clarify about GTT's: >>"The defination is stored in data dictionary hence it can be accessed by other users" The contents of the (local copies of the)...
22829 Jun 2012 @ 12:24 PDTToolsReplyHow to bypass the valid comma separator during the fastload Anubha:   10000 records is peanuts. If I were you, I'd load the file with bteq (more versatile) with some kind of magic with SUBSTR and POSITION/INDEX.   HTH ...
22727 Jun 2012 @ 08:08 PDTCloud ComputingReplyDatabase Crashes after few seconds - Teradata 13 on SLES VM image Hi Murali: It seems that /var/log/messages is a good place to start looking... HTH. Cheers. Carlos.
22627 Jun 2012 @ 07:11 PDTGeneralReplyRecursive SQL combining Dates Steve: You need to limit the infinite loop with some aditional condition. For example: ...   from Holiday H, DIM_DATE D WHERE H.HOLIDAY_IND=D.HOLIDAY_IND   ...
22521 Jun 2012 @ 07:51 PDTDatabaseReplyExplicit Casting Govi: CAST is the preferred method. In your second query there is an implicit conversion:  BTEQ -- Enter your SQL request or BTEQ command: select type(1111);  ***...
22415 Jun 2012 @ 12:54 PDTToolsReplyFastexport ASCII character removal Steven: >>"Therefore, TEXT should not contain any VARCHARs because those require field length bytes." That was exactly my point. Cheers. Carlos.
22314 Jun 2012 @ 01:49 PDTToolsReplyFastexport ASCII character removal Steven: bteq: select * from CARLOS.prueba01 ORDER BY 1;  *** Query completed. 3 rows found. 2 columns returned.  *** Total elapsed time was 1 second.  &nbs...
22213 Jun 2012 @ 05:50 PDTToolsReplyFastexport ASCII character removal Hi: This has been discussed over and over... The ASCI chars are the size of the varchar that you defined in the SELECT statement. If you don't want this, you must declare the output ...
22112 Jun 2012 @ 01:39 PDTCloud ComputingReplyConnection issues from ALL applications to TD Express 13.10 and 14.00 through VMWare Steve: That's OK on the VMware player side. Om the VM side: logon to the SuSE linux (as root) and go to computer->control center->Network card and configure there the network s...
22011 Jun 2012 @ 08:40 PDTCloud ComputingReplyConnection issues from ALL applications to TD Express 13.10 and 14.00 through VMWare Steve: If you configured the VM network as NAT (VMware Player-> Virtual Machine-> Virtual Machine Settings-> Network adapter ) the other machines(PC's) in your network won't...
21910 Jun 2012 @ 11:52 PDTCloud ComputingReplyConnection issues from ALL applications to TD Express 13.10 and 14.00 through VMWare Hi Steve. Difficult to say without knowing the errors you get, but first place to look at is the network configuration in the VM. If you want others machines accesing the VM, you should ...
21806 Jun 2012 @ 05:54 PDTDatabaseReplyCreating UPI/USI on Primary Key coloumn Rakesh Primary keys are a logical, not physical, and they are implemented as UPI's or USI's. In your case, the PRIMARY KEY clause makes TD create a UPI on the column 'a', and...
21705 Jun 2012 @ 11:49 PDTGeneralReplyFull row duplicate update No, you cannot (you can try a workaround though). Note that your table is not even in 1FN! Cheers. Carlos.
21604 Jun 2012 @ 06:12 PDTGeneralReplyFile export from BTEQ HI.   .OS rm -f directory_path/XYZ.txt; .EXPORT report File = directory_path/XYZ.txt; ...   HTH. Cheers. Carlos.
21501 Jun 2012 @ 03:22 PDTDatabaseReplyPopulating column with constant day-of-week value? Hi: I think this may work for you:   select whatever_date, (whatever_date) - ((whatever_date - date '1900-01-05') mod 7) "Last Friday"   Examples:...
21430 May 2012 @ 10:22 PDTGeneralReplyInsert and Delete in Merge Into Hi: The MERGE statement is INTENDED TO insert new records or UPDATE existing ones (as per SQL 2003 standarsd), never to DELETE records. I don't know much about DB2, but the Oracle im...
21324 May 2012 @ 11:58 PDTConnectivityReplyWhy is TeraData JDBC complaining about these parameters? Yeah! It seems to me that choice num 2 is the good one (more elegant, and possibly more performant). I said I'm not a java expert ;-) Cheers. Carlos.

Pages