#DateForumTypeThreadPost
4412 Apr 2009 @ 07:14 PDTDatabaseTopicvariable in a SAMPLE clause in a stored procedureCan one use a variable in a SAMPLE clause in a stored procedure?If so, is there any special syntax?I've declared my input variables as SMALLINT (& tried INTEGER).My query is INSERT INTO fooSELECT f...
4313 May 2008 @ 10:02 PDTThird Party SoftwareTopicAtanaSuite EssentialDoes anyone here use AtanaSuite Essential (or any AtanaSoft products for that matter)?Any idea what their pricing is? (Any time a vendor refuses to list prices, I immediately suspect that the prod...
4210 Apr 2008 @ 08:42 PDTAnalyticsTopicApplication development toolsCan anyone suggest application development tools that work on top of a Teradata database, but which provide better debugging support than do Teradata stored procedures?I'm thinking of tools like th...
4111 Jan 2008 @ 05:30 PSTAnalyticsTopicPricing of new SAS/ Teradata partnershipHas anyone heard what the pricing will be for users of the new SAS/ Teradata partnership?Nolan
4014 Nov 2007 @ 11:15 PSTToolsTopicTPT and VPNI frequently work at home and use a VPN set up by my employer to connect to the company network.When I work at home over the VPN, TPT scripts which run in a reasonable amount of time at work, run 5...
3924 Oct 2007 @ 06:02 PDTUDAReplyThe positional assignment list has too many valuesIt really was a matter of too many values. I had two commas after one input variable, which, of course, FastLoad took to mean was supposed to be two variables.
3823 Oct 2007 @ 10:55 PDTUDATopicThe positional assignment list has too many valuesAre there other reasons why one might receive the error message "The positional assignment list has too many values"?I've counted four times and the count of values in my input file, the table I cr...
3718 Sep 2007 @ 03:08 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?We're running on V26.1.1.My understanding is that granting access to DBC.sysexecsql allows you to run dynamic SQL. Our DBAs' contention is that a developer can create uncontrolled SQL which consum...
3613 Sep 2007 @ 02:13 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?I am both the creator and the immediate owner. Even when I try to create a stored procedure with the Collect Stats statement, I get the same error message.
3512 Sep 2007 @ 01:14 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?(At least in my environment) a stored procedure cannot collect statistics on a temporary table without permission to run Dynamic SQL.I have a test SP which inserts rows into a global temporary tabl...
3411 Sep 2007 @ 12:33 PDTDatabaseReplycollect stats programatically without use of dynamic SQL?So I take it, the answer is "no"?I'm still dealing with this issue and haven't come up with a solution.Am I the only developer whose DBA's won't grant him permsssion to write dynamic SQL?Nolan
3303 Aug 2007 @ 07:05 PDTAnalyticsTopicWebsphere Information IntegratorDoes anyone here use IBM's Websphere Information Integrator in an environment that includes a Teradata data source?I'd be interested in hearing about any solutions involving such an architecture.Nolan
3203 Aug 2007 @ 06:57 PDTAnalyticsReplyTeradata Value Analyzer - Activity Based Costing?I'm sure your Teradata rep would love to talk to you about Teradata Value Analyzer (TVA); give him/her a call.The way TVA was explained and demo'd to us, it is more than an Activity Based Costing s...
3120 Jul 2007 @ 01:34 PDTAnalyticsTopicFormat to provide comma separators?Can anyone tell me how to get the FORMAT function to supply comma separators? The following syntax doesn't work.Select s.scnro_ky, Substr(scnro_desc,1,20), i.RecNum (Format 'ZZZ,ZZZ,ZZ9'), scnro_b...
3017 Jul 2007 @ 07:01 PDTToolsTopicpass parameter to BTEQ script from a Windows batch fileIs there a way to pass a parameter to a BTEQ script that is called by a Windows batch file?I tried the lineselect count(*) from tbl_%1 where %1 is 200612, but I get an error message.N.
2913 Jul 2007 @ 06:31 PDTToolsTopicTPT and stored procedure(s)I'm sure there are many ways of skinning this cat and I'd appreciate any suggestions.What I need to to is export account data on >200k accounts from one Teradata database (TD #1), import it into an...
2814 Jun 2007 @ 12:43 PDTDatabaseReplyMS Word document as LOBWe haven't actually started loading documents into Teradata; I had just read a white paper from Teradata which talked about LOB's which implied that a Word document is one of the types of files tha...
2713 Jun 2007 @ 07:33 PDTDatabaseTopicMS Word document as LOBI assume that one can store an MS Word document as a LOB (BLOB? CLOB?). But how do you get it back out? If we use Teradata to store MS Word documents, what sort of application would we need to de...
2613 Apr 2007 @ 07:00 PDTDatabaseTopiccollect stats programatically without use of dynamic SQL?Is there any way to collect stats programatically when you are restricted from using dynamic SQL? I don't think you can invoke a macro which collects stats from within a stored procedure. Can you...
2513 Apr 2007 @ 06:38 PDTAnalyticsReplyAccessing Teradata Data from Microsoft Access Form.Have you tried linking the Teradata table via ODBC?If the Teradata table is large, your query could take quite a while, but for small tables this works.Just curious, how do you link to a Teradata t...
2409 Feb 2007 @ 09:33 PSTToolsReplyTeradata Parallel Transporter ODBC connection failsAn update - I was able to create a TPT script using an ODBC connection to DB2. It seems as tho TPT has some problems with my Oracle ODBC driver than SQL Assistant and other tools don't.Nolan
2309 Feb 2007 @ 09:30 PSTToolsTopicsyntax for WHERE conditions in Teradata Parallel TransporterCan anyone give me an example of the syntax to use in WHERE conditions including strings in TPT?The tail end of my script in [B] below. I only inserted line 86 to the job script that the TPT wizar...
2205 Feb 2007 @ 02:33 PSTToolsReplyTeradata Parallel Transporter ODBC connection failsI think somebody responded to my personal email (which I can't access at work) rather than here. If I remember the questions they were about the Oracle ODBC driver I've successfully used with SQL ...
2105 Feb 2007 @ 02:27 PSTUDAReplyNeed a Teradata SQL reference guidehttp://www.info.ncr.com/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=SQLREF&kword2=TNTSEQ&sbrn=7&nm=Teradata+Database+-+SQL+ReferenceShow table {tablename} or if you're using SQ...
2001 Feb 2007 @ 01:55 PSTToolsTopicTeradata Parallel Transporter ODBC connection failsI've just started working the Teradata Parallel Transporter utility. I'm attempting to import data from an Oracle datable. However, when I attempt to establish the connection, I get an error mess...

Pages