#DateForumTypeThreadPost
6230 Jun 2010 @ 08:20 PDTToolsReplyBTEQ + QUERY_BAND -> ERROR: Unrecognized command QUERY_BANDSET QUERY_BAND is Teradata DDL, not a bteq command. You must use it without leading dot (.) SET QUERY_BAND = 'JobID=PIYULA;' FOR SESSION; HTH Cheers. Carlos.
6123 Jun 2010 @ 06:30 PDTUDAReplyOracle Reports connectiing to TERADATAIt's spanish. http://translate.google.com/ Cheers. carlos.
6023 Jun 2010 @ 01:50 PDTUDAReplyOracle Reports connectiing to TERADATAYou may take a look here: http://carlosal.wordpress.com/2009/06/18/heterogeneous-services-sql-a-teradata-desde-oracle/ HTH Cheers. carlos.
5909 Jun 2010 @ 12:23 PDTDatabaseReplyBasic SQL questionsThe differences with the LEFT OUTER JOIN are explained with examples here (in spanish): http://carlosal.wordpress.com/2009/06/03/ansi-outer-joins-parecido-no-es-igual/ HTH. Cheers. Carlos.
5821 May 2010 @ 12:24 PDTToolsReplyUsing environment variable in mload scriptLinux 'sed' command can be an alternative too. HTH. Cheers. Carlos.
5720 May 2010 @ 07:46 PDTDatabaseReplyquery not giving desired result"Also, using a where clause in left or right outer joins makes it an inner join...always keep your conditions in on clause" Could you please elaborate? Cheers. Carlos.
5607 May 2010 @ 12:40 PDTDatabaseReplyTemporary Tables in TeradataFrom de docco: "Although space usage for materialized global temporary tables is charged to temporary space, creating the global temporary table definition requires an adequate amount of permane...
5529 Apr 2010 @ 02:41 PDTDatabaseReplyHow to create records from a defined rangeThis happens when you don't provide enough information. You can always do: select * from my_db.prueba20; *** Query completed. One row found. 3 columns returned. *** Total elapsed time...
5428 Apr 2010 @ 08:37 PDTDatabaseReplyHow to create records from a defined rangeFor example: BTEQ -- Enter your DBC/SQL request or BTEQ command: create table my_db.prueba20 (id_n integer not null, hi_n integer not null, ...
5326 Apr 2010 @ 12:23 PDTUDAReplyETL CLOB from Oracle to TeradataMultiload reference: "The maximum row size for a MultiLoad job, data plus indicators, is approximately 64,000 bytes. This limit is a function of: • The row size limit of the Teradata Databas...
5223 Apr 2010 @ 02:14 PDTDatabaseReplyInteger to time conversionYou mast CAST to CHAR previous to CAST to TIME: BTEQ -- Enter your DBC/SQL request or BTEQ command: SELECT CAST ( CAST( TIME_INT AS CHAR(6)) AS TIME(0) FORMAT 'HHMISS') FROM ( SELECT 91623...
5121 Apr 2010 @ 06:31 PDTUDAReplyETL CLOB from Oracle to TeradataCherry: You can load LOBs in many different ways ( http://carlosal.wordpress.com/2008/11/23/insertar-ficheros-de-imagen-en-teradata-usando-windows-scripting-host-y-ado/ ), BUT Teradata load util...
5021 Apr 2010 @ 12:46 PDTUDAReplyETL CLOB from Oracle to TeradataCherry: You can load CLOBs with bteq, but version must be 12.00.00.02 or posterior. There is an example here: http://carlosal.wordpress.com/2010/01/25/insertar-ficheros-en-teradata-como-bl...
4909 Feb 2010 @ 11:37 PSTDatabaseReplyhow to enable insertion values in dbc.dependenciesI think you mean dbc.dependency.Its intended for UDT's.Read the f[abulous] manual:"DependencyStores relationships among a UDT, its dependent routines, User-Defined Casts, User-DefinedTransforms, Us...
4805 Feb 2010 @ 08:07 PSTDatabaseReplycheck for numeric values in a string>> The only reliable way is a UDF.Not necessarily (well, yes: oTranslate(), but not one UDF 'ad-hoc').If you are looking for NUMBERS AND ONLY NUMBERS (no dots, signs, etc...) in a string you ...
4727 Jan 2010 @ 11:45 PSTDatabaseReplySave BLOB content as a File... BTEQ / SPIf in windows, you could try an ADO/OLEDB/WSH/VBS solution like I did here:http://carlosal.wordpress.com/2010/01/26/guardar-datos-de-columnas-blob-en-teradata-como-ficheros-usando-windows-scripting...
4622 Jan 2010 @ 03:53 PSTAnalyticsReplyHow to identify PPI columnsShow table?HTH.Cheers.Carlos.
4520 Jan 2010 @ 10:32 PSTToolsReplydelete & insert vs updateYou 'small' POC is a VERY SMALL POC and not accurate at all:Here is a counterexample: BTEQ -- Enter your DBC/SQL request or BTEQ command:CREATE SET TABLE MY_DB.PRUEBA01, NO JOURNAL, NO ...
4419 Jan 2010 @ 03:42 PSTToolsReplydelete & insert vs update>>"If you want to update very less amount of data (ex out of 1 million records) some 1 to 5% records you want update, then we can consider going for UPDATE dml.">>"In case out of 1 mill...
4314 Jan 2010 @ 10:39 PSTDatabaseReplyTo select columns as rows from a tableUse a recursive query.There is an example here:http://carlosal.wordpress.com/2008/10/15/queries-recursivas-en-teradata/HTH.Cheers.Carlos.
4214 Jan 2010 @ 10:32 PSTDatabaseReplyMultiple Rows into One Row (concatenation?)Use a recursive query.There is an example here:http://carlosal.wordpress.com/2008/10/15/queries-recursivas-en-teradata/HTH.Cheers.Carlos.
4114 Jan 2010 @ 10:24 PSTAnalyticsReplyHow to identify PPI columnsThere are no such things as 'partitioning columns' but 'partitioning EXPRESSIONS' -which can be, of course, based on column values, but they are different things-.HTH Cheers.Carlos.
4007 Dec 2009 @ 11:35 PSTUDAReplyRemoving duplicatesIf you have a big table with few duplicated rows and you don't want to do a massive INSERT...SELECT DISTINCT into a brand new table, you could do something like this - though this could be called ...
3922 Oct 2009 @ 06:36 PDTAnalyticsReplyStoring multiple values in a column BTEQ -- Enter your DBC/SQL request or BTEQ command:CREATE TABLE DB_USER001.TEST1FN1(RECORD_TYPE SMALLINT NOT NULL, C_TXT VARCHAR(10)) ...
3822 Oct 2009 @ 06:11 PDTDatabaseReplyORacle to Teradata update query conversionLook for UPDATE...FROM sintaxis in Teradata.Cheers.Carlos.

Pages