#DateForumTypeThreadPost
817 Jul 2010 @ 06:27 PDTToolsTopicHelp Needed on bteq export/import optionHi, I am using the bteq import export option,I have followed the following steps in order: Step 1 ------ export data from table to file .set width 900 .export data file=myoutput.txt Se...
710 Jul 2010 @ 07:49 PDTToolsTopicIf you are going to use the teradata utilities ,will it change the Architecture or SDLC?If you are going to use the teradata utilities ,will it change the Architecture or SDLC? If yes then why and how?
609 Jul 2010 @ 07:33 PDTDatabaseReplyHelp Neeed: conditional execution in macro@Jimm The macro should execute one of the statements in IF..ELSE Block,not both.This is the requirement. @Carlos..Cannot we handle this in a macro?
508 Jul 2010 @ 07:38 PDTDatabaseTopicHelp Neeed: conditional execution in macroHi, Is it possible to do conditional execution in macro based on the input parameter passed: For example: create macro Mymacro( id integer, param_2 varchar(10), param_3 date forma...
406 Jul 2010 @ 06:08 PDTDatabaseReplyCreating a Procedure to turn off Online Archiving - Need help!Hi Thomas, Can you please specify the syntax of OVERRIDE command (in the above Stored Proc)?
324 Jun 2010 @ 08:12 PDTDatabaseTopicHelp reqd on Partition KeyJust came across the ddl of a table, which is as follows: CREATE TABLE db.tab_1 ( item_id CHAr(10), Vendor_id INTEGER, .. ..., rptg_dt date format 'YYYY-MM-DD' ) PRIMARY INDEX xnupi_tab...
213 Jun 2010 @ 07:08 PDTDatabaseTopicUDF CompilationHi, I created an UDF in teradata recently.The UDF was created with some warnings. The following is the UDF and associated C program: REPLACE FUNCTION DB.GetSum(a integer,b integer) RETUN INTE...
101 Jun 2010 @ 07:05 PDTDatabaseTopicPermSpace RelatedHi, I want to know the actual space consumed by the data in a table. I create a sample table: CREATE TABLE tab_1(col_1 varchar(20)); INSERT INTO tab_1('abc'); INSERT INTO tab_1('xyz'); Th...

Pages