#DateForumTypeThreadPost
3018 Oct 2011 @ 05:13 PDTDatabaseTopicQueryband 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 ...
2917 Oct 2011 @ 04:16 PDTDatabaseTopicLogging 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...
2829 Jan 2011 @ 04:09 PSTGeneralReplyError 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(...
2709 Oct 2010 @ 11:58 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1Hello 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...
2627 Sep 2010 @ 01:04 PDTToolsTopicEclipse 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...
2522 Sep 2010 @ 07:19 PDTToolsReplyCan 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...
2427 Jul 2010 @ 03:01 PDTToolsReplyNeed 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.
2326 Jul 2010 @ 01:49 PDTToolsTopicNeed 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...
2213 Mar 2010 @ 10:44 PSTDatabaseReplydifference of values with datatype Timeto 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);
2113 Mar 2010 @ 10:41 PSTDatabaseReplydifference of values with datatype Timesel (time'17:39:07' - time'17:31:10') hour to second; HTH.
2027 May 2009 @ 01:25 PDTToolsTopic2665 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...
1927 May 2009 @ 01:18 PDTDatabaseTopicTesting 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...
1807 Apr 2009 @ 07:23 PDTDatabaseTopicList of Objects in Stored ProcedureHi 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...
1711 Feb 2009 @ 01:02 PSTToolsReplyMainframe 2 Non-Mainframe LoadThanks Fred.Rgds,Mtlrsk
1606 Feb 2009 @ 12:47 PSTToolsTopicMainframe 2 Non-Mainframe LoadHi 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...
1524 Dec 2008 @ 02:58 PSTToolsTopicError 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...
1424 Nov 2008 @ 12:18 PSTToolsTopicTPT DDL OperatorHi 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...
1319 Nov 2008 @ 05:16 PSTDatabaseTopicTeradata OLEDB ErrorHi 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.
1218 Nov 2008 @ 06:37 PSTDatabaseReplyDBQL - Database Query LoggingThanks 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...
1118 Nov 2008 @ 04:30 PSTDatabaseTopicDBQL - Database Query LoggingHi 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 ...
1013 Nov 2008 @ 11:47 PSTToolsReplyRelease Lock - LOAD Operator - TPTHi 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...
913 Nov 2008 @ 01:25 PSTToolsReplyRelease Lock - LOAD Operator - TPTHi ,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.
813 Nov 2008 @ 01:14 PSTToolsTopicFastload ErrorHi 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 ...
713 Nov 2008 @ 12:19 PSTToolsTopictbuild / tbuildexe -- DifferenceHi 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...
607 Nov 2008 @ 01:08 PSTDatabaseReplydifference between version V2R6 and V2R12Thanks 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...

Pages