30 | 18 Oct 2011 @ 05:13 PDT | Database | Topic | Queryband |
How does queryband help in getting skew information ?
I was reading one of the manual and it says that by using substr in queryband , we can get the skew information , can someone shed ... |
29 | 17 Oct 2011 @ 04:16 PDT | Database | Topic | Logging SYSTEMFE. |
In the document --> TD13 DBQL logging and maintenance.doc
It is written that to log the SystemFE user.
"If using this documented DDL, Macros, and example script, you must log SYS... |
28 | 29 Jan 2011 @ 04:09 PST | General | Reply | Error trying to create table from select while select work perfectly fine by itself | ||substring(dt,1,1) else substr
----------------------------
create table tb2 as(
select
Rcrd_No,
compltn_dt,
substr(compltn_dt,1,position(' ' in compltn_dt )) as dt,
trim(substr(... |
27 | 09 Oct 2010 @ 11:58 PDT | Tools | Reply | fastload error message: Not enough fields in vartext data record number: 1 | Hello ayyappan,
Its time you learn Perl :-), Perl can handle this kind of files, where you can change your Delimiter from , to say | ; this will not change the data which is inside " ", so the d... |
26 | 27 Sep 2010 @ 01:04 PDT | Tools | Topic | Eclipse IDE for C/C++ Developers | Hello All,
I want to know whether we can use the "Eclipse IDE for C/C++ Developers" with Teradata for creation of C UDF's on Teradata Database under syslib? If yes, please can someone let me kn... |
25 | 22 Sep 2010 @ 07:19 PDT | Tools | Reply | Can a BTEQ script be called from another BTEQ script? | Q1 ) Yes ,
BTEQ
.LOGON username,password
.RUN FILE=[qualifier]filename = 1 then .GOTO SECTIONB
.label SECTIONA
.REMARK ’Zero Hours on Account’
.label SECTIONB
.REMARK ’Total Hours... |
24 | 27 Jul 2010 @ 03:01 PDT | Tools | Reply | Need Header Row in FastExport / TPT Export.? | Thanks Carlos, yes it really helped.
So there is no direct approach either via some options in FastExport or some Attributes in TPT to do this?
Thx,
Mtlrsk. |
23 | 26 Jul 2010 @ 01:49 PDT | Tools | Topic | Need Header Row in FastExport / TPT Export.? | Hi,
Please can someone send a sample script to export the columnname as the header row using FastExport / TPT Export.?
I am able to do this using Bteq Export, but facing difficulty with FastExp... |
22 | 13 Mar 2010 @ 10:44 PST | Database | Reply | difference of values with datatype Time | to be more precise, u can also use format commands to format ur answerset accordingly:-
sel (time'17:39:07' - time'17:31:10') hour to second(0); |
21 | 13 Mar 2010 @ 10:41 PST | Database | Reply | difference of values with datatype Time | sel (time'17:39:07' - time'17:31:10') hour to second;
HTH. |
20 | 27 May 2009 @ 01:25 PDT | Tools | Topic | 2665 Invalid Date error in Teradata Parallel Transporter. | Hi All,I have a file with 9k records which gets successfully loaded by using Traditional Fastload Utility.The same file when i try to load using Teradata Parallel Transporter LOAD Operator , all th... |
19 | 27 May 2009 @ 01:18 PDT | Database | Topic | Testing Records in Two RDBMS. | Hi,I have started working on a Migration Project from DB2 to Teradata,As per requirement , i have been asked to compare the table before and after migration for all the records and column by column... |
18 | 07 Apr 2009 @ 07:23 PDT | Database | Topic | List of Objects in Stored Procedure | Hi All,I have a got many stored procedures , and need to list out the tables/view they are referring in.Is thier any dbc tables/view in which i can get the info in one go .?Your help is highly appr... |
17 | 11 Feb 2009 @ 01:02 PST | Tools | Reply | Mainframe 2 Non-Mainframe Load | Thanks Fred.Rgds,Mtlrsk |
16 | 06 Feb 2009 @ 12:47 PST | Tools | Topic | Mainframe 2 Non-Mainframe Load | Hi All,Please can anyone let me know the points to remember while Fastexporting data from Mainframes system and loadingthe data back onto a Non Mainframe system using Fastload/Multiload.?I have Fas... |
15 | 24 Dec 2008 @ 02:58 PST | Tools | Topic | Error Loading File. | Hi All,Need your urgent help in this,I have received a file which was Fastexported from Mainframe Platformusing Fastload Format.Now i want to load this onto Teradata Box via Linux Platform.On linu... |
14 | 24 Nov 2008 @ 12:18 PST | Tools | Topic | TPT DDL Operator | Hi All,I have a file with has many DDL statments. Is thier any way i can use this file in the TPT DDL operator.I mean to say , can i reference this file using the TPT DDL operator.?So that it creat... |
13 | 19 Nov 2008 @ 05:16 PST | Database | Topic | Teradata OLEDB Error | Hi All,I am getting the error attached while accessing Teradata OLEDB .Please can advise what is the cause, i have reinstalled the application but still in vane.rgds,mtlrsk. |
12 | 18 Nov 2008 @ 06:37 PST | Database | Reply | DBQL - Database Query Logging | Thanks Adeel, ya it has helped me .But I just doubt then how DBQL help developer to do some analysis on the queries they fire.As they need access to DBC tables/views which only DBA's have.?rgds,mt... |
11 | 18 Nov 2008 @ 04:30 PST | Database | Topic | DBQL - Database Query Logging | Hi All,I am using DBQL for some analysis work on TD12.0 Express Edition Demo version,But have a space issue with the DBC database.Please can anyone advise if i can change the DBQL setting so that ... |
10 | 13 Nov 2008 @ 11:47 PST | Tools | Reply | Release Lock - LOAD Operator - TPT | Hi Rgs,I am not running any fastload jobs, nor my any of the previous fastload job is in abend.I have a tpt script in which i have a load operator , and it has failed in the middle .Now it tell 265... |
9 | 13 Nov 2008 @ 01:25 PST | Tools | Reply | Release Lock - LOAD Operator - TPT | Hi ,Can any one advise if it is possible to release LOAD operator locks in TPTthe way we do in Fastload.Begin Loading ...End LoadingRegards,mtlrsk. |
8 | 13 Nov 2008 @ 01:14 PST | Tools | Topic | Fastload Error | Hi All,I have Fastexported a table using indicator mode.Now i want to fastload a table with this exported file.Please can anyone advise which .set record _______ i have to usein order to load the ... |
7 | 13 Nov 2008 @ 12:19 PST | Tools | Topic | tbuild / tbuildexe -- Difference | Hi All,I've installed Teradata Express Edition Demo Version on my system, at the path belowC:\Program Files\NCR\Teradata Parallel Transporter\12.0\binI can find two copies of executable files for T... |
6 | 07 Nov 2008 @ 01:08 PST | Database | Reply | difference between version V2R6 and V2R12 | Thanks Fred,I was under an impression that it is V2R12, because as mentioned in TD 12.0 Overview pdf.How the new release numbering works:-Starting with Teradata12.0, there is only one release numbe... |