#DateForumTypeThreadPost
4708 May 2013 @ 07:57 PDTToolsReplyFastLoad Error: FDL4830 CHAR/BYTE Type - record too shortIf the source table has some DECIMAL column and the precision is higher than 18 (i.e. the precision is 19 or more), then in the fastexport script you should add a "DECIMALDIGITS 38" speci...
4621 May 2012 @ 03:03 PDTDatabaseReplyTIME() issue Hi Dieter, aren't the "DateFld,TimeFld" fields evaluated at log-time? Shouldn't it be correct to use the "LogonDate, LogonTime" fields from the EventLog table...
4524 Feb 2011 @ 02:57 PSTDatabaseReplyGrant rights by scriptSelect rows from DBC.AccessRights and generate proper "GRANT ... TO ..." SQL statements to be then executed...
4424 Feb 2011 @ 02:51 PSTDatabaseReplyRetrieving metadata about most recent queryUse the "ACTIVITY_COUNT" status variable after a DML statement. Pay attention that it is an INTEGER typed variable, limited to values up to 2^32-1
4331 Mar 2010 @ 11:27 PDTToolsReplyFastExport to Windows Named PipeTo use a named pipe you need to 1) install a named pipe access module (Teredata provides one) 2) you have to add a parameter to the EXPORT command, like: .export outfile \\.\pipe\tddemopip...
4227 Jul 2007 @ 09:36 PDTDatabaseReplyAnalysis on tera data1.1) Repeat this SQL statement: "show procedure MyProc;" for each Stored Procedure "MyProc" you can find in the system. You can't lookup the "requesttext" field of dbc.tables to get affordable resu...
4105 Jul 2007 @ 08:53 PDTToolsReplyDeclaring variables in TERADATA BTEQsYou can define variables inside a Teradata's Stored Procedure, just like SQL Server's Stored Procedures. BTEQ is not a Stored Procedure, is a tool to submit SQL statements (e.g.: "call MyStoredProc...
4002 Jul 2007 @ 11:09 PDTToolsReplyTPump ConnectivityYou may find answers in the manual:http://www.info.ncr.com/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=CTPUMP&sbrn=7&nm=Teradata+Tools+and+Utilities+-+Teradata+Parallel+Data+Pump
3902 Jul 2007 @ 08:01 PDTUDAReply3707, Syntax error expected something like a name between ',' and the 'TYPE' keyword.Could you please attach the whole script?Informatica is an ETL tool that should generate Teradata scripts accordingly to what you have defined. So, could the problem be related to Informatica?
3802 Jul 2007 @ 07:51 PDTUDAReplyTeraData vs OracleFor more info:Software: http://mediaproducts.gartner.com/reprints/ncr/vol3/article2/article2.htmlHardware: http://mediaproducts.gartner.com/reprints/ncr/vol3/article1/article1.html
3702 Jul 2007 @ 07:35 PDTDatabaseReplyCertification Practice Testhttp://www.google.com/search?hl=en&q=Teradata+practice+test
3602 Jul 2007 @ 07:23 PDTDatabaseReplyTable definitionsTo get the DDL of a Teradata Table, the most affordable way is by issuing a "Show table" SQL statement to a TD database.So, to get the complete set of DDLs from a database, you'd better generate th...
3522 Jun 2007 @ 05:04 PDTDatabaseReplyDifference Between Cylinder Migrate and Cylinder Split"Not enough cylinders" means: "not enough free space"... For which you can just list the free space available per VProc (AMP).In a typical configuration, a cylinder is made of 3872 sectors (having ...
3418 Jun 2007 @ 06:14 PDTDatabaseReplyConnect two different teradata box and retreive datayou could use "linked tables" in an MSAccess database... and perfrom the minus operation inside MSAccess
3318 Jun 2007 @ 05:36 PDTUDAReplyTeradata CRMYou could start with these readings:Teradata Customer ManagementMagic Quadrant for MultichannelCampaign Management, 1Q07
3213 Jun 2007 @ 07:28 PDTUDAReplyRegarding Data Extraction.......Besides some Teradata PS offer solutions, the market offers a plethora of ETL tools to do the job. Look for Oracle Data Integrator (former Sunopsis), Informatica, IBM WebSphere DataStage (former As...
3113 Jun 2007 @ 07:23 PDTUDAReplyDetails on Teradat MLDM (Manufacturing Logical Data Model) required...Hi Manik,the LDMs are something that Teradata sells... so, you'd better contact a Teradata commercial for any freely distributable information about them.While searching the Teradata.com web site, ...
3012 Oct 2006 @ 09:45 PDTToolsReplyTeradata export file contains junk charactersWhenever you export data to a file with the mentioned method, data is being appended to the file.You have to manually delete the file before running the script or issue an ".OS" command inside the ...
2912 Oct 2006 @ 06:09 PDTAnalyticsReplyConnecting Business Objects to TeradataYou need to use the Teradata Data Connector from Business Objects (NCR\Teradata V2 Rx\Teradata ODBC Driver)... (which is sold separately).From Tools Menu\Connections, click on Add; from the wizard,...
2812 Oct 2006 @ 06:02 PDTToolsReplyBTQMAINYou'd better refer to the documetation:http://www.info.ncr.com/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=CBTEQ&sbrn=7&nm=Teradata+Tools+and+Utilities+-+Basic+Teradata+Query+(...
2712 Oct 2006 @ 04:28 PDTToolsReplyTeradata export file contains junk charactersWhile using the "DATA" keyword in an "EXPORT" command you should consider the following:"BTEQ returns data in Record mode and stores it in FastLoad format output file. Use this format to interchang...
2612 Oct 2006 @ 03:22 PDTDatabaseReplySELECT "TOP" FROM...Try this one...SELECT KeyID ,Language ,ROW_NUMBER() OVER (PARTITION BY KeyID ORDER BY Language DESC) as TheTopFROM tblMyTable qualify TheTop = 1
2511 Jun 2006 @ 08:03 PDTToolsReplytranspose dataLook at how to pivot a table (in your case, rows to columns) in the answer from Dieter at:http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=1285
2411 Jun 2006 @ 07:55 PDTDatabaseReplyPaging in Teradata for Web applicationPaging requires the answer set to be cached somewhere on a server. Teradata does not have this kind of facility, so you have to build your own or use one from an existing Application Servers.
2311 Jun 2006 @ 07:51 PDTDatabaseReplyODBC Driver changing submitted SQLBefore going further on investigating, you'd try to enclose the case expression between parenthesis:cast( (case....end) as ...)Also, try executing the query via CLI (using BTEQ, for example). And l...

Pages