21 | 24 May 2006 @ 04:50 PDT | Tools | Reply | Loading Data from a file recieved from Mainframes | Teradata 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... |
20 | 11 May 2006 @ 11:41 PDT | Analytics | Reply | 3706: Syntax error: expected something between ')' and ','. For derived | Is 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... |
19 | 06 May 2006 @ 02:47 PDT | Tools | Reply | Importing with BTEQ | If 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. ... |
18 | 04 May 2006 @ 05:06 PDT | Tools | Reply | delete primary index | The 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. |
17 | 03 May 2006 @ 02:10 PDT | Third Party Software | Reply | SSH for MP-RAS | Since 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... |
16 | 03 May 2006 @ 01:59 PDT | Connectivity | Reply | *** Failure 7566 The protected mode user is not defined; cannot execute UDF | Are you certain tdatuser is defined on ALL nodes in your system? |
15 | 27 Apr 2006 @ 12:06 PDT | Database | Reply | TD olap func need help | You 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... |
14 | 27 Mar 2006 @ 11:57 PST | UDA | Reply | Default spaces | In 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.... |
13 | 23 Mar 2006 @ 06:27 PST | UDA | Reply | Default spaces | Not 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... |
12 | 23 Mar 2006 @ 06:01 PST | Database | Reply | why 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. |
11 | 20 Mar 2006 @ 10:29 PST | Tools | Reply | Monitoring rollback / abort progress | In 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 ... |
10 | 17 Mar 2006 @ 01:15 PST | Tools | Reply | BTEQ logon problem | BTEQ 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... |
9 | 17 Mar 2006 @ 12:42 PST | Tools | Reply | import data from text file | The 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... |
8 | 17 Mar 2006 @ 12:34 PST | Connectivity | Reply | ODBC- 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. |
7 | 17 Mar 2006 @ 12:28 PST | Tools | Reply | Code = 2644 No more room in database | Space 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... |
6 | 17 Mar 2006 @ 12:12 PST | Connectivity | Reply | How 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... |
5 | 02 Feb 2006 @ 12:45 PST | Connectivity | Reply | Teradata ODBC Trouble in MS/Access | Probably 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. |
4 | 02 Feb 2006 @ 12:38 PST | Tools | Reply | Can 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"... |
3 | 02 Feb 2006 @ 12:34 PST | Tools | Reply | can we force mload to check the Application error table | Certainly. 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... |
2 | 19 Jan 2006 @ 11:00 PST | Database | Reply | duplicate unique primary key error | GENERATED 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... |
1 | 19 Jan 2006 @ 10:43 PST | Database | Reply | PUBLIC User | If 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. |