![]() |
I am working on FETCH STATEMENT inside CURSOR. I need to convert a SQL server script into Teradata. SQL SERVER input:---------------------------------------
28 Jul 2016
,
|
![]() |
Hi All, Looking for recommendations on Full Text search Tagging via LIKE / LIKE ANY etc.
This has to be dynamic, from a table of terms and tags.
I have a billion row table of free text (myPK bigint + myTEXT varchar 4000).
28 Jun 2016
| 2 comments
,
|
![]() |
Hi,
20 Jul 2015
| 6 comments
,
|
![]() |
Hi Folks,
13 Mar 2015
,
|
![]() |
Hello all,
24 Oct 2014
| 3 comments
,
|
![]() |
Hi,
11 Sep 2014
| 4 comments
,
|
![]() |
Dear Experts,
16 May 2014
| 3 comments
,
|
![]() |
Many experienced SQL and procedure developers use SQL functions to perform common tasks and simplify their code narratives.
21 Jan 2014
| 3 comments
,
|
![]() |
|
![]() |
Hi.
I have a problem. I have a cursor with a select statement. The select statement returns 5 rows. Row 1-- Select col 1 Row 2 --,col2 Row3---,col3 Row4---,col4 Row5--- From table A;
14 Mar 2012
| 1 comment
,
|
![]() |
Ordered analytical functions enable parallel processing by freeing processes from flat logic. They also produce simpler Set SQL statements, which as a general rule can be expected to perform better than more complex Set SQL statements.
06 Mar 2012
,
|
![]() |
Hi All, In Teradata document, SQL Reference : Stored Procedures and Embedded SQL :Release V2R6.1 I have read something about calling MACRO inside a procedure and declaring the results in Cursor (The content is given below) When I tried the same thing in procedure, I have got a error saying it is Invalid.
11 Dec 2011
| 1 comment
,
|
![]() |
Set SQL is a way of operating on data that is radically different from historical concepts of computer programming that can be diagrammed with flow charts. Grab a cup of coffee and review some history that will explain why the industry is mired in cursor logic and loops that cannot exploit the power of today's software and hardware.
01 Nov 2011
| 2 comments
,
|
![]() |
I'm attempting to develop a stored procedure that takes a table name as a parameter, and performs column-by-column updates to whatever table is passed in. I have the dynamic SELECT query working correctly: SET CURSOR_SQL = 'SELECT * FROM ' || P_TABLE_NAME || ' ORDER BY rsid;'; Now I'm at the point where I need to fetch the cursor data into local variables...but I can't create table-specific local variables because I don't know what tables will be passed into this procedure.
01 Aug 2011
| 4 comments
,
|
![]() |
When Flat SQL looping logic involves complex processing of data elements from multiple tables, the loops can almost always be transformed into Set SQL with derived tables. By eliminating looping logic, the performance benefits of parallel processing can be exploited.
10 Jul 2011
| 2 comments
,
|
![]() |
Hi , I have a dynamic cursor like this below one is not that exact query: Declare merge_cursor_statement VARCHAR(3000); SET merge_cursor_statement='LOCKING ROW FOR ACCESS SELECT columname deom dbc.columns'; OPEN RefCursor2;
06 Jun 2011
| 15 comments
,
|
![]() |
The most difficult task when converting Flat SQL (cursor-based procedural code) to Set SQL involves translating complex logic and accounting for multiple data sources. The Derived Table feature of Set SQL simplifies this process.
31 May 2011
| 5 comments
,
|
![]() |
Perhaps the easiest way to transition from a flat logic mindset to a set logic mindset is to convert some Flat SQL to Set SQL, then stare at both of them until the logical equivalence of the two approaches becomes clear.
26 Apr 2011
| 2 comments
,
|
![]() |
Maximizing the full potential of Teradata's Massive Parallel Processing requires Set Processing.
19 Apr 2011
| 2 comments
,
|
![]() |
I want to get a recordset in asp which is returned from teradata stored procedure. Create PROCEDURE test() DYNAMIC RESULT SETS 1 Then I tried several different ways in ASP to get the result list: ***DB connection using ODBC as: Set DBConn = Server.CreateObject("ADODB.Connection")
29 Jun 2010
| 10 comments
,
|