#DateForumTypeThreadPost
2124 May 2006 @ 04:50 PDTToolsReplyLoading Data from a file recieved from MainframesTeradata utilities expect input data to be in a "native" format for the platform on which the client is running. So mainframe format data is handled nicely when your Teradata system is channel-atta...
2011 May 2006 @ 11:41 PDTAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedIs your query perhaps being submitted in some manner that requires a name be assigned to each field? In other words, do you needCOUNT(ITM_NUM) C1,COUNT(ORD_NUM) C2,COUNT(ORD_LN) C3Also, are you rea...
1906 May 2006 @ 02:47 PDTToolsReplyImporting with BTEQIf you are using VARTEXT format for the input file, all the fields in the USING clause should be declared as VARCHAR, with the max allowable length. You may need to use explicit FORMAT, CAST, etc. ...
1804 May 2006 @ 05:06 PDTToolsReplydelete primary indexThe Primary Index is part of the table structure and not a separate object. You'll have to do something like create a new table, copy (INSERT/SELECT) the data, drop the old, rename.
1703 May 2006 @ 02:10 PDTThird Party SoftwareReplySSH for MP-RASSince you're running MP-RAS 3.02, get Open Source Tool Set packages (openssl, openssh, prngd at a minimum) from the patch server or MySupportLink. Your Teradata service contact should be able to he...
1603 May 2006 @ 01:59 PDTConnectivityReply*** Failure 7566 The protected mode user is not defined; cannot execute UDFAre you certain tdatuser is defined on ALL nodes in your system?
1527 Apr 2006 @ 12:06 PDTDatabaseReplyTD olap func need helpYou specified an ORDER BY for purposes of calculating the windowed OLAP function, but if you want the result set ordered you need an ORDER BY clause at the end.It's "Remaining" sum because you said...
1427 Mar 2006 @ 11:57 PSTUDAReplyDefault spacesIn my test example, I included ten spaces after the word Long for this statement:insert into showVarchar values (2, 'Long ');Somehow it appears to have been truncated to a single blank in the post....
1323 Mar 2006 @ 06:27 PSTUDAReplyDefault spacesNot quite accurate, and a frequent misconception. Trimming trailing spaces from VARCHAR doesn't happen by magic - you need to be careful on the client side and/or use the TRIM function:CREATE TABLE...
1223 Mar 2006 @ 06:01 PSTDatabaseReplywhy does sql cannot pass systax?Or use quotes to force the p****r to treat the token as an identifier rather than a keyword: "MONTH", "YEAR", etc.
1120 Mar 2006 @ 10:29 PSTToolsReplyMonitoring rollback / abort progressIn V2R5.1 and later, the Recovery Manager (rcvmanager) utility LIST ROLLBACK TABLES command gives progress information related to long rollbacks.RcvManager can be accessed via the Teradata Manager ...
1017 Mar 2006 @ 01:15 PSTToolsReplyBTEQ logon problemBTEQ only accepts the "batch mode" form of .LOGON while it is reading commands from a file, e.g. when input is redirected on the command line that invokes BTEQ.You can use the .RUN FILE= command to...
917 Mar 2006 @ 12:42 PSTToolsReplyimport data from text fileThe result of the concatenation operator || is of type VARCHAR, so the exported record contains a two-byte length field at the beginning.If you want to use "unformatted" data without the delimiters...
817 Mar 2006 @ 12:34 PSTConnectivityReplyODBC- Enable MS-ACCESS Interoperability Mode"Advanced Options" selections vary depending on the exact level of the Teradata ODBC driver; they can even change from one patch level to another within the same version.
717 Mar 2006 @ 12:28 PSTToolsReplyCode = 2644 No more room in databaseSpace is managed on a "per-AMP" basis. If one AMP is out of space, the database is full. select VProc, CurrentPerm, MaxPerm from dbc.DiskSpace where DatabaseName='SMB_ETLBASE';Data skew such as thi...
617 Mar 2006 @ 12:12 PSTConnectivityReplyHow to use Decimal(15,2)Note that though the logic inside the function body may be "simple", you can't code the prototype as a "simple C function". In other words,DECIMAL8 *udf_m_2(DECIMAL8 *in_val){...}will not work.If y...
502 Feb 2006 @ 12:45 PSTConnectivityReplyTeradata ODBC Trouble in MS/AccessProbably DR 90597 (bug in driver on TTU7.1 CD's). Fixed in ODBC 3.3.0.8 and later. Get updated driver from Teradata.Com downloads area or the patch server.
402 Feb 2006 @ 12:38 PSTToolsReplyCan we call bteq script in mload script.At least in a network attached environment you can use .SYSTEM to invoke any command line including BTEQ or something that calls BTEQ. On the mainframe you'd probably have to write your own "shell"...
302 Feb 2006 @ 12:34 PSTToolsReplycan we force mload to check the Application error tableCertainly. Use .IF statements testing built-in variables such as &SYSETCNT1 to check for rows in the error table, and use .SYSTEM to execute some external command to send the page. See the manual f...
219 Jan 2006 @ 11:00 PSTDatabaseReplyduplicate unique primary key errorGENERATED BY DEFAULT columns are not guaranteed to be unique anyway, but if you're sure that's what you want: create another table but specify that generated values START WITH a value beyond anythi...
119 Jan 2006 @ 10:43 PSTDatabaseReplyPUBLIC UserIf the user holds a right WITH GRANT OPTION, he is free to grant that right to ANY database, user, or role. And the creator of a table automatically is given rights WITH GRANT OPTION.

Pages