Tags for parameters
Teradata Load Errors
By pyite, 15 Oct 2014 | 19 comments
Hello, I am attempting to load a tab delimited file into a table, and I am receiving the following errors:   Row number 6,812 had an error. Cause = Unexpected number of parameters Row number 26,237 had an error. Cause = Unexpected number of parameters
teradata load parameters varchar parentheses
Cannot convert from Db.DateTimeOffset to Td.TimeStampWithZone
By tekriewa, 22 Jul 2014 | 1 comment
I am attempting to execute a parametrized non-query SQL command using TdCommand.ExecuteNonQuery().  The parameter in question is DbType.DateTimeOffset and TdType.TimestampWithZone; the parameter value was generated using DateTime.Now and appears to be completely defined (as verified via the Visual Studio debugger).
.net c# parameters
Parameterizing Like clause
By Renji, 12 Feb 2014 | 1 comment
We have a requirement to mask sensitive information being loaded into the tables. Let's say we had the first three groups in place, the fourth one came in as a new requirement, and so had to make a coding change. We currently have logic similar to this.   Case when diagnosis_description like '%psych%' Then 'sensitive info'
parameters stored procedure functions
Performance tuning for a tpump script-
By Nishant.Bhardwaj, 10 Jul 2013 | 1 comment
Hi Experts, There is a tpump which is taking 10 hours to process 7000 records, whcih earlier was taking 1 hour..  not sure why its taking  so long now. the script cotains the normal insert select statement.  just want to know that is there any optimal parametrs setting for the various TPUMP parameters.. like  PACK
tpump performance parameters
Using parameters in a derived table
By GrahamS, 28 Mar 2013
Hello, I am trying to use SSRS to pass parameters into a derived table in Teradata. The parameters represent a SQL Server table that is about 1600 rows.  The join I'm trying is  JOIN (Select ? (varchar(4)), ? (varchar(4))) as derivedtable (Col1Name, Col2Name) on (Col2Name=TDcol)  
derived table parameters ssrs
The Initialization process of the NPAM
By Sastry, 25 Apr 2012
The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad). The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer. The reader process will initialize the NPAM module via an Initialization string and this article details the various parameters that are initialized during this process.
teradata named pipes parameters i/o npam data transfer access module initialization pipes initialization string v_tools
Parameters in BTEQ
By karim.maarouf, 24 Sep 2011
Hello, I would like to know if there is a way to define and use parameters in BTEQ scripts. The only such feature i am aware of is the "using" feature when importing from files. However, What I would like to do is something like the following:   ------ define params param1 = value1 param2 = value2  
bteq parameters
Global and session level parameters in SQL
By dnoeth, 14 Mar 2011 | 44 comments
The commonly known technique to pass parameters to SQL statements at the system or session level utilizes tables (permanent or global temporary tables). In this blog post, I'll show better performing techniques for system and user level variables using views and QueryBanding. These solutions are based on TD13, but can also be used pre-TD13, although performance might be worse.
views scalar subqueries parameters variables querybanding