Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Jul 2003 @ 16:05:54 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Simple TData "How-Tos'
 
From:   Thom Chichester

To all,

I've got some simple (hopefully) questions about "how do you do this with Teradata".

I'm an application developer who is just getting into Teradata. I'm porting a data warehouse application that's written in Visual FoxPro. The application currently accesses VFP and Sql Server databases through ODBC.

1) How can I get the value of ACTIVITY_COUT via ODBC. With Sql Server it would be something like SQLEXEC(, "SELECT @@ROWCOUNT")

2) How can I determine if a database object exists:

a) A permanent table in a database.

b) A volatile table.

c) An index.

3) How can I change substrings in a string with other substrings. Again, with Sql Server I would use REPLACE(, , ) e.g. REPLACE("All good boys", "good", "bad") => "All bad boys"

4) How can I "justify" a string... IOW pad a string with leading or trailing blanks.

5) How can I translate a date or date-time value into a string (and vice versa). I suspect you'd use the CAST() function, but I'm fuzzy on how to establish the formatting.


TIA,

Thom Chichester



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016