80 | 10 May 2007 @ 09:13 PDT | Tools | Reply | Where do the Log files get created? | The log table get's created in user's default database. (which in most case is the same as the user id) |
79 | 09 May 2007 @ 07:57 PDT | Tools | Reply | MLoad script from JCL - Error message | Hmm.... does the error message say which database it's referring too ?I wonder if mload is trying to create tables in the user's database. can you try a create table from SQL Assistant under the us... |
78 | 09 May 2007 @ 07:47 PDT | Tools | Reply | MLoad script from JCL - Error message | mload creates error/work tables in the database, hence the user id requires CREATE TABLE access to the database. Otherwise you can specify a different database for these tables on which the user ha... |
77 | 09 May 2007 @ 01:35 PDT | Tools | Reply | Fastlod via Teradata Clieny | you would want to format it as YYYYMMDD and might also have to put a NULLIF clause for bus_date column which is spaces for some records. |
76 | 08 May 2007 @ 11:44 PDT | Tools | Reply | missing comments in views | I think the "before comments" stuff is fixed with TTU 8.2 ( v7.2 of SQL Assistant) or so I heard. |
75 | 08 May 2007 @ 05:26 PDT | Tools | Reply | Using mload to load datetime field | Since you are actually ignoring those fields, I think a quick solution would be to just declare the extra as FILLER and ignore it.ie something like.FIELD IN_BIRTHDATE * CHAR(10);.FILLER IN_BIRTHTIM... |
74 | 08 May 2007 @ 03:37 PDT | Tools | Reply | FastLoad Error: FDL4830 CHAR/BYTE Type - record too short | Since the error message says the record is short by 60 bytes, why don't you check the length of each fields in the record in input file ? |
73 | 07 May 2007 @ 01:16 PDT | Tools | Reply | Jon Index - Compression & PPI | There's no MVC available for JI. But there's another kind of compression available by grouping the columns in select statement.ie like(col1,col2) , (col3,col4,col5)so the index is compressed on col... |
72 | 04 May 2007 @ 12:23 PDT | UDA | Reply | Converting Decimal to CHAR | if you use 'Z' in the format it will return space for any value of 0 in the column, so you will have to use '9' instead of 'Z' if you want it to be zero instead of a space. |
71 | 04 May 2007 @ 12:17 PDT | Tools | Reply | Can INMOD routines be used when creating a script in TPT Wizard? | To begin with, it couldn't locate the ODBC config file as evident from the messageMSG='[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.' beca... |
70 | 03 May 2007 @ 12:56 PDT | Database | Reply | Database Statistics | If I understood your intention correctly, then this is one of the ways you can get around.-- Step 1 create a volatile table to store tablenames and record counts.CREATE VOLATILE TABLE TBLRECCNT(TAB... |
69 | 03 May 2007 @ 12:29 PDT | Connectivity | Reply | UDF in place of a Macro | Can't you just join your table with the calendar table on calendar_date = yourtable.datecol ? |
68 | 03 May 2007 @ 12:28 PDT | UDA | Reply | Converting Decimal to CHAR | Play around with the FORMAT clause.SELECT DecimalCol (FORMAT 'Z9') (CHAR(7)) FROM MyTable; |
67 | 02 May 2007 @ 05:41 PDT | Database | Reply | Query Formating in TeraData?? | if you want the count to be taken as zero even when bus_hol is null then you will have to use an ELSE 0 clause instead of the last WHEN - THEN clause in the above query.Having said that, why do you... |
66 | 01 May 2007 @ 07:45 PDT | Tools | Reply | Compare database objects | if you are bothered about verifying just column names and it's attributes, you can do it using a self join of DBC.Columns view. |
65 | 27 Apr 2007 @ 03:49 PDT | Database | Reply | Teradata Database Certification | You can get the syllabus from the website posted earlier.And this is a good place to look for most of the TD manuals.http://www.teradataforum.com/ncr_pdf.htmyou can "lift" the contents falling into... |
64 | 27 Apr 2007 @ 03:47 PDT | Database | Reply | Required help | The time displayed by explain are meager optimizer's best guesses (based on the statistics "insider" information, if there's any). They are not the final authority in deciding how long the SQL is g... |
63 | 26 Apr 2007 @ 04:03 PDT | Database | Reply | Teradata Database Certification | Certifications are for Odd number releases of Teradata. So though the current release of TD is v2r6, the current certification of TD will be for V2R5.you can find more info here ....http://www.tera... |
62 | 26 Apr 2007 @ 02:29 PDT | Database | Reply | Required help | Since your original post mentioned about insert taking long time, I think the places to look for will be Transient Journal (ie the destination table is not empty), a skewed PI on dest table, an NUP... |
61 | 26 Apr 2007 @ 01:47 PDT | Database | Reply | Last Day of Previous Month | Other than that you should reverse the order of the between conditions, I don't see any trouble. otherwise you won't get any records.where DOB between ADD_MONTHS(DATE - EXTRACT(DAY FROM DATE),-13... |
60 | 20 Apr 2007 @ 07:54 PDT | Tools | Reply | Creating a table part 2 | To give brief descriptions of things.If you did an "add database" in SQL Assistant , it just adds to the list of databases it will display on the left side of the panel. It doesn't create a new dat... |
59 | 18 Apr 2007 @ 11:44 PDT | Tools | Reply | Need to read date field from table in BTEQ | If you were using unix, you could resort to Shell variables.#!/usr/bin/kshrun_date=`date '+%Y%m%d'`bteq |
58 | 18 Apr 2007 @ 01:47 PDT | Database | Reply | hi | DELETE ALL is the same as a DELETE with no WHERE clause specified. Also called as an unconstrained DELETE. This is faster when it's the last statement of a transaction or is the only statement of t... |
57 | 18 Apr 2007 @ 01:10 PDT | Tools | Reply | Please Need Help as soon as possible. | I don't think I got the question quite right, but most likely you are looking for something like this ...SELECT TMP1.Pers_id, TMP1.Spl_Event_Date, TMP1.Name, TMP1.Address , TMP2.Rev_Mo_Salary AS S... |
56 | 16 Apr 2007 @ 11:42 PDT | Analytics | Reply | Tranfer query results to file from stored procedure | For small amounts of data, you can use the .export option of bteq. For large amounts of data use fastexport utility. Look up the manuals for syntax and sample scripts. |