Tags for array
Data loading using Array data type
Hi All,  I would like to load the array data type data into table. I've created like ' CREATE TYPE sysudtlib.person AS(id_num VARCHAR (10),first_name VARCHAR (20), Salary VARCHAR (20)) NOT FINAL; CREATE  TYPE ID_NBR AS sysudtlib.person  ARRAY [1]; CREATE MULTISET  TABLE temp_work.EMP ,NO FALLBACK ,
array Varray array INSERT
Ordered Analytical Functions: Translating SQL Functions to Set SQL
Many experienced SQL and procedure developers use SQL functions to perform common tasks and simplify their code narratives.
array cursor loop plsql set logic set sql sqlpl t-sql
Teradata 13.10 Replication of Array Logic
Hello, I am having difficulty storing multiple column values within the same row, since I am unable to group by only the identifying value, according to the sample code below, "ID." I believe creating an array for each unique ID would solve this problem, but I am using Teradata 13.10, and the array UDF is not supported within this version.
ARRAY Data Type Scenario
SQL ARRAY/VARRAY Data Type This feature was introduced in Teradata Database 14.00.
scenario array data type array v_database
ARRAY structure in UDF
Hi. I am trying the built-in C functions for ARRAY handling in Teradata 14. Basically, I copied the code below from the FNC_GetArrayElementCount function in the manual TD 14 External Routine Programming: 
array function FNC_GetArrayElementCount
Derived Tables with Ordered Analytical Functions to Translate Flat Logic
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.
loop cursor set logic set sql array plsql t-sql sqlpl
Loops to Sets: A Brief History of Database Programming Logic
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.
sql loop cursor set logic set sql array plsql t-sql sqlpl programming history aster
Converting Complex Procedure Logic to Set SQL Using Derived Tables
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.
sql loop cursor set logic set sql array plsql t-sql sqlpl
Using Derived Tables as a Shortcut to Set SQL
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.
sql loop cursor set logic set sql array plsql t-sql sqlpl
From Flat Logic to Set Logic - a basic approach
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.
migration oracle sql loop cursor set logic set sql array plsql t-sql sqlpl