348 | 13 Oct 2011 @ 01:31 PDT | UDA | Reply | Stored Procedure Issue |
Hi,
Can you try re-structuring it to following format:
FOR CurrentRow AS SourceCursor CURSOR FOR
SELECT
COL1,COL2
FR... |
347 | 13 Oct 2011 @ 01:25 PDT | General | Reply | ORACLE TO TERADATA MIGRATION |
Hi,
For new question please use new thread!
You can simply use following to do that:
CREATE PROCEDURE TotalCount()
BEGIN
... |
346 | 13 Oct 2011 @ 01:20 PDT | Database | Reply | how to make Compression Equal?! |
I do agree with Jim's statement, can you please confirm it will serve your purpose?
Regards, MAC
|
345 | 13 Oct 2011 @ 01:18 PDT | Database | Reply | teradata procedure |
Hi,
Do you have any specific question or you plan to learn them from start?
Regards, Adeel
|
344 | 13 Oct 2011 @ 01:17 PDT | General | Reply | Problem with Timestamp in SQL assistant |
Have you tried .NET connection?
And can you provide example including DDL, sample data and SELECT statement you are using?
Regards, Adeel
|
343 | 12 Oct 2011 @ 04:27 PDT | Database | Reply | Random record selection in the subquery |
Hi,
You can have one SELECT as below:
SELECT
1,
A.Cust_type_CD,
B.Cust_Location
FROM
TableX A
JOIN
TableY B
ON RAND... |
342 | 12 Oct 2011 @ 04:13 PDT | Database | Reply | Merge Vs Delete/Insert |
Do share results of your benchmarking for our learning.
Regards, MAC
|
341 | 11 Oct 2011 @ 11:08 PDT | Analytics | Reply | String Search and Replace. |
And we are for sure working on improving the function set!
|
340 | 11 Oct 2011 @ 11:05 PDT | Database | Reply | What is Spool Space? Why do you get spool space errors? How do trouble-shoot them? |
Hi,
Spool space is an intermediate dataset storage space. Usually spool space errors occur due to stale stats resulting in product joins. To troubleshoot them, fix the query which... |
339 | 11 Oct 2011 @ 11:02 PDT | Database | Reply | User Defined Function/Procedure |
Hi,
Seems fine, can you share the code files which may have any issue?
Regards, MAC
|
338 | 11 Oct 2011 @ 10:57 PDT | Database | Reply | Query to Delete all the records in a table in Teradata |
Hi,
In case the table is huge, you can also use DROP TABLE and CREATE TABLE commands.
HTH!
Regards, MAC
|
337 | 11 Oct 2011 @ 10:55 PDT | Database | Reply | Execute Multiple Drop Table Statements in single Procedure |
Hi,
You can issue multiple DROP TABLE commands in a stored-procedure using dynamic SQL as below:
CALL DBC.SysExecSQL ('DROP TABLE TABLE1;');
CALL DBC.Sy... |
336 | 11 Oct 2011 @ 10:53 PDT | Database | Reply | how to make Compression Equal?! |
Hi,
The CPU consumption can surely be due to uncompressing and recompressing the values.
Regarding moving data from one database to another .... if the only concern... |
335 | 11 Oct 2011 @ 10:45 PDT | UDA | Reply | Compiling Stored Proc - VC++ not installed error |
Hi,
Thanks for sharing the piece of information .... from TD version 12 and above .... simple installation (no renaming or changing of registry manually) of VC++ 2005 Express edit... |
334 | 11 Oct 2011 @ 10:42 PDT | Database | Reply | Random record selection in the subquery |
Hi,
You obviously need to change your approach of writting INSERT/SELECT query. Easier approach should be to write one SELECT statement first, before generating it in SP dynamical... |
333 | 11 Oct 2011 @ 10:38 PDT | Database | Reply | Merge Vs Delete/Insert |
Hi,
It can vary from case to case depending on index selection and stats on the table .... have you benchmarked MERGE and DELETE/INSERT approaches?
Generally MERGE ... |
332 | 11 Oct 2011 @ 10:34 PDT | General | Reply | Teradata database software and its availability. |
Hi,
You can download a fully working demo from following link:
http://downloads.teradata.com/download/database
It does include all the tools and util... |
331 | 03 Aug 2011 @ 01:41 PDT | Database | Reply | Data Cleansing using SQL | Are the values of Col1 in sequence .... as in .... in order .... 1,2,3,4.... ? |
330 | 03 Aug 2011 @ 01:09 PDT | Database | Reply | Stored Procedures - Use dynamic cursor for any table | Hi,
From what I have understood .... you can use Volatile-table .... insert in this table the list of columns of the P_TABLE_NAME from DBC.COLUMNS .... and iterate through the volatile-table to ... |
329 | 03 Aug 2011 @ 01:04 PDT | Database | Reply | Error when calling an UDF | Hi,
Firstly, what exact format are you returning the output in?
Secondly, do you really require a UDF for finding 1st day of a month?
Regards, MAC |
328 | 03 Aug 2011 @ 01:00 PDT | Database | Reply | how to store the very big integer in Teradata | Hi,
For storing such a value, consider thinking if you really need it as numeric value .... meaning if you are going to use it in some calculations or not. In case you are not going to use it in... |
327 | 03 Aug 2011 @ 12:52 PDT | Database | Reply | Inner Join using SubQuery bring me the table name | Can you please be more descriptive? |
326 | 03 Aug 2011 @ 12:48 PDT | Database | Topic | Difference of rows in SELECT COUNT(*) and SELECT * | Hi,
I am facing a weird problem of which can not really figure out what could be the reason of that. Consider following SELECT statement:
SELECT
Col1, Col2, Col3
FROM
View1
QUALIFY ROW_NU... |
325 | 13 Jun 2011 @ 05:33 PDT | Database | Reply | how to move UDFs from one teradata DB to another? | Hi,
You need to get the code .... which if you dont have .... can get using:
SHOW FUNCTION .
As an output you will get 2 files .... one a C code and two the command to compile it which can... |
324 | 13 Jun 2011 @ 02:52 PDT | Database | Reply | Coverting INTEGER value to Date format | @CarlosAL .... indeed a cool solution!! :) |