#DateForumTypeThreadPost
2001 Jun 2011 @ 10:10 PDTToolsReplyBteq Import, Delete Statement on same table at once causing deadlockThanks Jimm. I think .Retry off will take care of most of the things in these cases as I am using .REPEAT * .SET REPEATSTOP ON and .PACK 5000 for the bteq import. And delete is not part of the impo...
1901 Jun 2011 @ 12:17 PDTToolsReplyBteq Import, Delete Statement on same table at once causing deadlockHi Jimm, Thank you very much for your response. I will definitely have your locking and BT ET applied. Thanks for the info. Retry off may help. And rollback 'Operation oborted' in the label is ...
1831 May 2011 @ 12:38 PDTToolsTopicBteq Import, Delete Statement on same table at once causing deadlockHi Experts, We have an application in which we load tables by using bteq import from small files. It also has a delete statement on the same table before bteq import starts. We made sure that th...
1702 May 2011 @ 12:26 PDTDatabaseReplyAutomatic compression of NULL valuesI think by default Null value will not occupy significant space in the database file system. So you don't even need to compress null values. But I have seen Teradata allowing compress nulls in DDLs...
1625 Apr 2011 @ 11:41 PDTToolsReplyNamed Pipe with axsmod bteq export to fastloadThanks Carlos. Now I am trying the same on windows.. But still no result... Its failing with the same error. If I remove the file server path and give the target file as a local file then fastloa...
1525 Apr 2011 @ 06:01 PDTToolsReplyNamed Pipe with axsmod bteq export to fastloadPlease read the .EXPORT report file=\\\Sessionfolder\my.pipe as .EXPORT report file=\\ < server name > \Sessionfolder\my.pipe. The editor is truncating < > symbols contents.
1425 Apr 2011 @ 05:59 PDTToolsTopicNamed Pipe with axsmod bteq export to fastloadHi, I have been trying to make bteq exported data to be fastloaded using named pipes on windows and cygwin. But fastload is failing and not waiting for the bteq export to populate the pipe. Plea...
1307 Apr 2011 @ 11:42 PDTAnalyticsTopicBest ways to migrate code from Mainframes to UnixHi, We have a huge system with several Teradata boxes for different applications and countries of our organization. All of the overnight batch jobs for processing the business logic are bteq, fa...
1207 Apr 2011 @ 11:29 PDTDatabaseTopicCollect stats on single and multiple columns together - Performance advantageHi All, I wanted to know what would be the behavior of the Teradata system in case of the following collect stats and select scenarios. # Collect stats on each column of the composite ...
1108 Mar 2011 @ 08:46 PSTToolsReplyHow to capture the rejected rows from BTEQ.IMPORTI dont know if Bteq supports pre defined variables like multiload SYSDATE, SYSTIME, SYSAPLYCNT. But you can use .SET REPEATSTOP ON to stop proceeding with the import.
1008 Mar 2011 @ 08:42 PSTToolsReplyHow to set BTEQ Import error records limit.SET REPEATSTOP ON Got it! This works. Thanks.
908 Mar 2011 @ 08:23 PSTToolsTopicHow to set BTEQ Import error records limitHi All, My problem is to check for any rows rejected from the source file. I have to quit with error if there are any records rejected. My script and log is .SET MAXERROR 0; +-----...
820 Jan 2011 @ 02:56 PSTDatabaseReplyAuto code generation for data movement across environment : I/P requiredHi, Your approach looks good. But we are currently facing issues with some business users who are writing insert queries for each record and submitting at once. When they submit more inserts like t...
728 Dec 2010 @ 12:59 PSTExtensibilityReplyQuerying XML Data stored in the databaseYou need to have a look at Teradata XML services orange book. It is understood to be using XALAN. Also you need to have Teradata XML services installed on your box to access these UDFs.
614 Nov 2010 @ 11:35 PSTToolsReplyRetain Previous record field valueHi Paul, You can use inmod facility of fastload/multiload(I did not try inmod on multiload before). Basically when we are using fastload through inmod, when fastload gives a return code of 0 the...
519 Oct 2010 @ 02:42 PDTUDAReplyHow to get ASCII Value of CharacterHi, Assuming only the last two characters are useful of CHAR2HEXINT function output, please find other option of getting the ascii value. SELECT 'a' AS reqchar, (((SUBSTRING(CHAR2HEXINT(reqc...
430 Sep 2010 @ 11:34 PDTExtensibilityReplyMonitorSQLCurrentStep on result set of MonitorSessionHi folks, At least where can I get the source code of these functions. I checked normal udf source code folders /teradata/tdbs_udf on one of the node but its empty as no custom made udfs were c...
328 Sep 2010 @ 01:28 PDTExtensibilityTopicMonitorSQLCurrentStep on result set of MonitorSessionHi all, Hope all is well. I wanted to know if we can pass each row of the syslib.MonitorSession(-1,'*',0) resultset to syslib.MonitorSQLCurrentStep so that I can get each session and its numb...
219 Aug 2010 @ 10:09 PDTToolsReplyInmod Compilation on Windows or Unix for FastLoad@feinholz: Thanks for your response. I have got my C Inmod Code written by some teradata guys. And it is having BLKEXIT as the entry point and we checked every thing in the C code. Our main concern...
119 Aug 2010 @ 08:27 PDTToolsTopicInmod Compilation on Windows or Unix for FastLoadHi Gurus, I got an inmod for processing one feed file and eliminate some unwanted rows and then feed the records to fastload. But I am not able to compile it and use it. I have GCC (GNU C Compil...