0 - 8 of 8 tags for parameters
Teradata Load Errors

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

By pyite, 15 Oct 2014 | Tagged: teradata load parameters varchar parentheses | 19 comments
Cannot convert from Db.DateTimeOffset to Td.TimeStampWithZone

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).

By tekriewa, 22 Jul 2014 | Tagged: .net c# parameters | 1 comment
Parameterizing Like clause

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'

By Renji, 12 Feb 2014 | Tagged: parameters stored procedure functions | 1 comment
Performance tuning for a tpump script-

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

By Nishant.Bhardwaj, 10 Jul 2013 | Tagged: tpump performance parameters | 1 comment
Using parameters in a derived table

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)
 

By GrahamS, 28 Mar 2013 | Tagged: derived table parameters ssrs
The Initialization process of the NPAM

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.

By Sastry, 25 Apr 2012 | Tagged: teradata named pipes parameters i/o npam data transfer access module initialization pipes initialization string v_tools
Parameters in BTEQ

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

 

By karim.maarouf, 24 Sep 2011 | Tagged: bteq parameters
Global and session level parameters in SQL

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.

By dnoeth, 14 Mar 2011 | Tagged: views scalar subqueries parameters variables querybanding | 44 comments