#DateForumTypeThreadPost
2223 Oct 2013 @ 09:41 PDTDatabaseTopicQuery band in MacrosI have a project specific requirement where I need to set a query band dynamically based on input parameters. I'm trying to achieve this via macros(we're on version 13.10). But the issue is...
2114 Aug 2013 @ 07:46 PDTDatabaseReplyDELETE FROM PPI - VERY SLOWThank you Dieter.   -Suhail
2012 Aug 2013 @ 09:01 PDTDatabaseReplyDELETE FROM PPI - VERY SLOWHello Dieter, If we do a full partition delete, does transient journalling happen?   If we run a delete that deletes a subset of a partition or a subset of partitions(eg: table ha...
1907 May 2013 @ 07:07 PDTToolsReplybteq export and import for _ET dataparcelok Thank you Feinholz. -Suhail
1806 May 2013 @ 08:09 PDTDatabaseReplyMeasure CPU Consumption of Utility JobsAnyone? -Suhail
1706 May 2013 @ 08:07 PDTToolsReplybteq export and import for _ET dataparcelIn order to pull data from a varbyte column(with delimited data in them with any delimeter...say pipe) and insert into a varchar column, I need to be able to first "split" the data u...
1606 May 2013 @ 02:56 PDTToolsReplybteq export and import for _ET dataparcelThank you feinholz for your response. For the problem I'm having, do you have any other solution except the below one: "loading all 30 million records into a varchar only NOPI stage...
1505 May 2013 @ 03:43 PDTDatabaseTopicMeasure CPU Consumption of Utility JobsHello, Is there any way to measure the total AMPCPUTIME consumed by any MLOAD/FLOAD/FEXP job post completion? The values from the dbql(sum of ampcputime for a particular LSN number) does not ...
1404 May 2013 @ 05:50 PDTToolsReplybteq export and import for _ET dataparcelOne mistake in my previous post is that we're currently using FASTLOAD instead of the TPT LOAD operatore. But we're also open to converting the ETL of this job to TPT if handling the error...
1304 May 2013 @ 05:34 PDTToolsReplybteq export and import for _ET dataparcelHi Feinholz, You mentioned earlier that there was going to be some consideration towards building a tool that will potential be able to decode the dataparcel column in the _ET table in a convenien...
1204 May 2013 @ 02:30 PDTDatabaseTopicLoad FASTLOAD Error Records into Required FormatI need to store the value in the DataParcel column(which is of VARBYTE datatype) in the first error table of FASTLOAD into a permanent teradata table but with a proper format(The ddl of this t...
1104 May 2013 @ 01:52 PDTDatabaseReplyCast CHAR/VARCHAR to VARBYTEHi Dieter/Veskojl, I'm looking for something to do the reverse: convert a varbyte back to varchar. I'm really in search of a UDF or some method within teradata to convert varbyte to varcha...
1004 May 2013 @ 01:38 PDTDatabaseReplyConvert Varbyte to CharacterAnyone? Can I get a copy of the function: VarbyteToVarchar.c? I can't seem to find it anywere on the internet.   Regards, Suhail
902 May 2013 @ 08:05 PDTDatabaseReplyConvert Varbyte to CharacterHi JPORELL/FRED, I know this post was back in 2006, but I'm really in search of a UDF or some method within teradata to convert varbyte to varchar. So I'm hoping you guys can help me out. ...
803 Apr 2013 @ 11:36 PDTDatabaseReplyMLOAD DELETE TASKHello Dieter, Thank you for the response. I have always had this assumption that all restrictions with MULTILOAD are associated with the fact that multiload does not allow amps to talk to each ot...
702 Apr 2013 @ 10:27 PDTDatabaseTopicMLOAD DELETE TASKDoes anyone know why the mload delete task does not allow delete based on a primary index? I need the answer just out of curiosity.   Regards, -Suhail
631 Jan 2013 @ 10:35 PSTDatabaseReplySQL ParserIt will be a very complex awk command. There are several types of complex queries and the where clause can be anywhere. Not sure if this is an ideal solution to achieve what I need. Plus we certai...
531 Jan 2013 @ 10:30 PSTDatabaseReplyparse sqltextinfo column in dbc.dbqlsqltblIt will be a very complex awk command. There are several types of complex queries and the where clause can be anywhere. Not sure if this is an ideal solution to achieve what I need.   -...
429 Jan 2013 @ 02:24 PSTDatabaseTopicparse sqltextinfo column in dbc.dbqlsqltblHi, Has anyone parsed the sqltextinfo column of dbc.dbqlsqltbl? I have a requirement where I need to do analysis of what kind of sqls are running on our production system. We do have querybanding...
329 Jan 2013 @ 01:26 PSTDatabaseReplySQL ParserHi, We have a requirement where I need to find what percentage of queries are querying recent data vs the percentage of queries that are querying historical data. I went on google to find any sql...
229 Jan 2013 @ 01:26 PSTThird Party SoftwareReplyTeradata SQL ParserHi, We have a requirement where I need to find what percentage of queries are querying recent data vs the percentage of queries that are querying historical data. I went on google to find any sql...
116 Jan 2013 @ 09:31 PSTDatabaseReplyGetting a unique value for VARCHAR field.Hi Dieter, You mentioned in your previous post that : "If you're not on TD13.10 simply cut & paste the source code and replace inBytes with PROC_DESCR" We're currently on 13...

Pages