#DateForumTypeThreadPost
8010 May 2007 @ 09:13 PDTToolsReplyWhere 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)
7909 May 2007 @ 07:57 PDTToolsReplyMLoad script from JCL - Error messageHmm.... 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...
7809 May 2007 @ 07:47 PDTToolsReplyMLoad script from JCL - Error messagemload 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...
7709 May 2007 @ 01:35 PDTToolsReplyFastlod via Teradata Clienyyou 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.
7608 May 2007 @ 11:44 PDTToolsReplymissing comments in viewsI think the "before comments" stuff is fixed with TTU 8.2 ( v7.2 of SQL Assistant) or so I heard.
7508 May 2007 @ 05:26 PDTToolsReplyUsing mload to load datetime fieldSince 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...
7408 May 2007 @ 03:37 PDTToolsReplyFastLoad Error: FDL4830 CHAR/BYTE Type - record too shortSince 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 ?
7307 May 2007 @ 01:16 PDTToolsReplyJon Index - Compression & PPIThere'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...
7204 May 2007 @ 12:23 PDTUDAReplyConverting Decimal to CHARif 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.
7104 May 2007 @ 12:17 PDTToolsReplyCan 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...
7003 May 2007 @ 12:56 PDTDatabaseReplyDatabase StatisticsIf 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...
6903 May 2007 @ 12:29 PDTConnectivityReplyUDF in place of a MacroCan't you just join your table with the calendar table on calendar_date = yourtable.datecol ?
6803 May 2007 @ 12:28 PDTUDAReplyConverting Decimal to CHARPlay around with the FORMAT clause.SELECT DecimalCol (FORMAT 'Z9') (CHAR(7)) FROM MyTable;
6702 May 2007 @ 05:41 PDTDatabaseReplyQuery 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...
6601 May 2007 @ 07:45 PDTToolsReplyCompare database objectsif you are bothered about verifying just column names and it's attributes, you can do it using a self join of DBC.Columns view.
6527 Apr 2007 @ 03:49 PDTDatabaseReplyTeradata Database CertificationYou 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...
6427 Apr 2007 @ 03:47 PDTDatabaseReplyRequired helpThe 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...
6326 Apr 2007 @ 04:03 PDTDatabaseReplyTeradata Database CertificationCertifications 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...
6226 Apr 2007 @ 02:29 PDTDatabaseReplyRequired helpSince 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...
6126 Apr 2007 @ 01:47 PDTDatabaseReplyLast Day of Previous MonthOther 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...
6020 Apr 2007 @ 07:54 PDTToolsReplyCreating a table part 2To 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...
5918 Apr 2007 @ 11:44 PDTToolsReplyNeed to read date field from table in BTEQIf you were using unix, you could resort to Shell variables.#!/usr/bin/kshrun_date=`date '+%Y%m%d'`bteq
5818 Apr 2007 @ 01:47 PDTDatabaseReplyhiDELETE 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...
5718 Apr 2007 @ 01:10 PDTToolsReplyPlease 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...
5616 Apr 2007 @ 11:42 PDTAnalyticsReplyTranfer query results to file from stored procedureFor 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.

Pages