#DateForumTypeThreadPost
2308 Aug 2016 @ 08:35 PDTData ModelingTopicHow to transform an LDM to a PDM / Building block or Datamart?We were starting the eDWH in the early 2000 by impleting the FS-LDM as a physical model (more or less, slightly adapted to our needs). This is working fine, but there are also, let's say from ...
2229 Apr 2014 @ 01:02 PDTToolsReplyFastloading csv file with double quotesAfter testing with data, we encountered following situation: Snapshot of input data: "D9F570F6-538B-4795-98A4-021D99C03576"|"""BUREAU,TARIFICATION""" ...
2115 Apr 2014 @ 12:15 PDTToolsReplyFastloading csv file with double quotesHi Sudhansu, thank you very much. We installed the version some days ago. This is great news. Koen.  
2008 Apr 2014 @ 05:54 PDTToolsTopicFastloading csv file with double quotesHow are you fast loading a csv file where the fields are enclosed by double quotes? Eg. “Field 1”;”Field 2”;”Field 3” “Fi””eld 1”;&rdq...
1904 Jan 2013 @ 07:00 PSTToolsTopicMainframe VB piped input file - How to defineAll our mainframe fastloads are done with a fixed blocked input file. This is working fine. Now I've to fastload a variable blocked piped delimited input file. Since the command 'Set R...
1812 Mar 2012 @ 02:09 PDTDatabaseReplyWith recursive in a Select Ulrich, thank you for this quick response. Another solotion could be a volatile table... but it's a more general question. How to combine a With Recursive part in a bigger query, ...
1711 Mar 2012 @ 12:46 PDTDatabaseTopicWith recursive in a Select How can I use a WITH RECURSIVE as Derived table in a (complex) Select? Below a small part of the query. The query contains lots of Inner and Left Outer Joins, and 1 of them should be a hiera...
1601 Apr 2011 @ 12:45 PDTDatabaseReplyon product joinI you follow the explain plan, you will see that Teradata is reading the small table first. This table is then duplicated (copied) to all amps. Now the big table and the small (duplicated) table a...
1501 Apr 2011 @ 12:34 PDTDatabaseReplyteradata update syntaxCan you add an example of what you want to do? It's difficult to give the correct answer now.
1401 Apr 2011 @ 12:28 PDTDatabaseReplyLinux - Bteq - Export data to file - How can I remove the extra spaces?I know, bteq can generate output files, but it's slow and not made for this kind of work. Use fast export, extremely fast and easy to use. By adding an Outmod function, you can have a pipe delimi...
1316 Dec 2010 @ 01:17 PSTDatabaseTopicCLOB and FastExportWhat is the correct syntax to export a CLOB in fastexport. Now I'm using: .export Outfile koen.dat Outmod /bipt/dwh/dvw/app/operations/dlmt_vchar.so Mode Record Format Text ; b...
1212 Nov 2009 @ 09:26 PSTDatabaseTopicSQL ParserFor Meta Data Management reasons we’re looking for a java sql parser.The goal is to find a JAVA class where you can pass your sequel.As result we want to know the tables used by the query. In a l...
1119 Jan 2009 @ 09:27 PSTDatabaseReplyFastload from a mainframe (usage comp - format)Thanks for this information but I'm not sure.The definition on mainframe is:10 RMGLV026-AORG-CD PIC X(5). 10 RMGLV026-GLIN-AMT PIC S9(11)V9(2) USAGE COMP.10 ...
1015 Jan 2009 @ 07:41 PSTDatabaseTopicFastload from a mainframe (usage comp - format)How to fastload a USAGE COMP from mainframe to Teradata?An USAGE COMP-3 can be defined as Decimal(12,2) or something like that in the DEFINE section.Signed fields can be loaded by using a FORMAT in...
913 Dec 2008 @ 06:00 PSTDatabaseReplyStatistics information retrieved in dbc for Teradata 12This is really what I wanted to have.Thanks a lot for this quick response.Koen.
812 Dec 2008 @ 07:43 PSTDatabaseTopicStatistics information retrieved in dbc for Teradata 12What is the query to read the statistics information in dbc for Teradata 12?We had something for previous releases.Or is there no impact due to the new release on dbc level?
709 Mar 2008 @ 04:40 PDTDatabaseTopicCollect statistics in 1 scan?When a new table is created,we're also defining the statistics on different columns (with Collect statistics on ... column ...).These statistics are refreshed with the command Collect statistics on...
614 Nov 2007 @ 09:31 PSTToolsTopicNumber of rows written by FastExportHi,for tracing/audit reasons,we want to store the number of rows fastexport is writing/is generating.Fastexport gives a 'Notify' like '**** 15:16:11 UTY8722 93 total records written to output file....
502 Mar 2007 @ 02:28 PSTDatabaseReplyHow to count total row count for each table in entire databaseHi,when I want to count,I generate a query by using following SQL:Select 'Select ''' || Database_Id || ''', ''' || Name || ' '', Count(*) From ' || Trim(Database_Id) || '.' || Trim(Na...
411 Oct 2006 @ 05:04 PDTDatabaseReplyHow to read Collect Statistics informationDieter,thanks a lot.This was what I'm looking for...Koen.
309 Oct 2006 @ 05:07 PDTDatabaseTopicHow to read Collect Statistics informationWhen you are execution HELP STATISTICS you're receiving 4 columns with information.How can I insert this information in a (temporary) table?Can I read this information from dbc immediately?Thanks,...
202 Jun 2006 @ 10:39 PDTUDATopicUnloads from DB2 (nullable fields) - How to manage this with Fastload?When unloading nullable data from DB2,you receive always two fields.Field one = ValueField two = Indicator if the field is null or not.Can you use fastload (eg. decimals) without creating two field...
111 Mar 2006 @ 05:59 PSTConnectivityTopicHow to use Decimal(15,2)Can someone give me an example for a very simple UDF. I just want to have the C-code and the definition of the function.Name: UDF_Multiplyby2()Input: Decimal(15,2)Output: Decimal(15,2)To do: Multip...