|21552||03 Nov 2011 @ 03:41 PDT||venugopal2705||Database||Reply||Object dependency||
I am not sure abt dependency even I am searching for that but you can use top down approach.....This wont work for bottom up approach
SHOW sel * from tablename
|21551||03 Nov 2011 @ 02:18 PDT||Anand.Louis||Database||Topic||Activity Count from DBC.SYSEXECSQL in a Stored Procedure ||
I am executing a SQL using DBC.SYSEXECSQL in a Store Procedure .
Can any one suggest me way to capture the activity count of sql executed
Anand ... |
|21550||03 Nov 2011 @ 12:45 PDT||Amirtharaj.u||Database||Reply||Help required in query||
Use the below query and check whether its satifying your conditions.
|21549||02 Nov 2011 @ 10:30 PDT||Amirtharaj.u||Database||Reply||Format funciton ignored from SQL Assistant||
SQL assistant has its own format for Date and timestamp values. In SQL assistant , You can't see the date output in the format specified in the query while it displays. ... |
|21548||02 Nov 2011 @ 10:28 PDT||pmurthy||Third Party Software||Topic||Teradata ODBC Connector||
Hi, does anyone know if it is possible to connect to the teradata database, from within a BizTalk project, using the ODBC connector for teradata. I am new to this, and unsure as to how this can ... |
|21547||02 Nov 2011 @ 06:25 PDT||Tim_Qiu||Database||Reply||Question on restoring database using Teradata Arcmain||
Thanks so much, Garlos.
|21546||02 Nov 2011 @ 02:41 PDT||alexcol||General||Topic||Managing Datastage Applications for execution||
I need your help please:
Let me describe briefly the scenario to understand better my concern:
In a Datastage application there are 1 sequential jobs and ab... |
|21545||02 Nov 2011 @ 01:59 PDT||K-MAN||Tools||Reply||SQL Assistant 13.10 ODBC test connect||
Did you make sure the Service Name, User Name, and Password was all correct, in case-sensitive?
|21544||02 Nov 2011 @ 12:20 PDT||K-MAN||Tools||Topic||Conversion from type "DBNull" to type 'Integer' is not valid.||
Would anybody know why I would be getting this error with Teradata 13.10.0.08, and not with Teradata 12?
Conversion from type "DBNull" to type 'Integer' is not valid.
|21543||02 Nov 2011 @ 12:09 PDT||m.tahoon||Database||Topic||Format funciton ignored from SQL Assistant||
Format funciton is kind of ignored from SQL Assistant
SELECT CURRENT_TIME (FORMAT 'HH-MI-SS');
SELECT CURRENT_DATE (FORMAT 'DD-MM-YY');
|21542||02 Nov 2011 @ 08:42 PDT||CarlosAL||Database||Reply||Question on restoring database using Teradata Arcmain||
COPY DATA TABLE (tbase) -->> Destination Table
FROM (tbase) -->>Name of the table archived (source).
FILE = tbase -->>Name of the file used when... |
|21541||02 Nov 2011 @ 07:49 PDT||smeher||Tools||Reply||Fastload: Incorrect number of bytes returned from a File Read||
Sometime teradata behaves strangely... this error may be coming because of incorrect order of fileds in the control file. Recheck/regenerate the control file and try again.
I had faced this ... |
|21540||02 Nov 2011 @ 07:25 PDT||pandeesh||Database||Topic||Help required in query||
My requirement is as given below:
My table contains three columns:
|21539||02 Nov 2011 @ 07:09 PDT||Tim_Qiu||Database||Topic||Question on restoring database using Teradata Arcmain||
It's my first encounter with teradata, the following question might be stupid :)
I was told to use Teradata Arcmain to restore database, but I have a query for the follow... |
|21538||02 Nov 2011 @ 05:10 PDT||kashifriaz||Tools||Topic||Handling mutli-value columns in ODI||
Could anybody please tell me whether we have any built-in functionality for handling mutli-value columns in ODI (Oracle Data Integrator)?
I mean, can we transform a multi-va... |
|21537||02 Nov 2011 @ 03:14 PDT||rohanpatil008||Database||Topic||Need teradata material||
Can anyone please suggest me a link to a pdf which contains manual for teradata architecture, mload, fast export, tpump, fast load, amps and other teradata related stuffs. Please reply m... |
|21536||02 Nov 2011 @ 01:12 PDT||Andreas||Tools||Reply||Issues with 'Teradata.Client.Provider.TdType' in Port of .NET Application using Teradata Client 13.11.00.01||
You might want to take a look at the Teradata .Net Provider documentation to be found here:
|21535||01 Nov 2011 @ 07:51 PDT||ftshtl||Marketing & CRM||Topic||[ARM6.4] Unable to get password from PasswordManager. Proceeding and assuming that the password is unencrypted||
I try intstalling ARM6.4.
Database Initialization And Migration , Install Metadata Administrator Utility And Install or Update TRM.WAR are All successfully.
When I ... |
|21534||01 Nov 2011 @ 06:06 PDT||geo_edwards||Jobs||Topic||Atlanta, GA - FT Senior DBA with Delta Community Credit Union||
Delta Community Credit Union is hiring for a full-time Senior DBA position managing a large Teradata warehouse and a set of SQL Server application servers. Experience in Busines... |
|21533||01 Nov 2011 @ 12:56 PDT||tjwong||Connectivity||Topic||SQL Server linked server to Teradata specifying authentication mechanism (LDAP)||
Have had success establishing and using SQL Server linked server (SQL Server 2008 R2) connected to Teradata using OLE DB Provider for Teradata (Version 18.104.22.168) using native Teradata (TD2) aut... |
|21532||01 Nov 2011 @ 12:35 PDT||dvsathishkumar||Tools||Topic||Load Testing on Teradata Unity - Help required||
I am working on a POC on Teradata Unity. One of the tests we are planning to execute is to simulate huge load on the Teradata databases systems without using Unity and then repeat the sa... |
|21531||01 Nov 2011 @ 11:08 PDT||teradatatester||Database||Reply||Best practice for backing up Teradata Table Structures (DLLs)?||
With a Netezza database I run one job and all the tables structures are backup to a file. Does Teradata have anything similar?
|21530||01 Nov 2011 @ 10:34 PDT||Tnewbee||Database||Reply||Tune qry||
Dieter , can you help me please?
|21529||01 Nov 2011 @ 09:25 PDT||Sreenath||Connectivity||Topic||Connecting to Suse linux VMware database while on VPN||
I have a problem connecting to Suse VMware image for Teradata database. It works OK at work place. But at home, when I am on VPN, I can't access the database from the Windows 7 h... |
|21528||01 Nov 2011 @ 06:57 PDT||Amykk||Training||Reply||Want Teradata SQL Tutorial||
Can you please send me the Teradata basic Certificate Material to firstname.lastname@example.org