#DateForumTypeThreadPost
1914 Mar 2012 @ 01:17 PDTToolsReplyRowhash deadlock during BTEQ insert More info:   http://forums.teradata.com/forum/tools/bteq-pack-and-deadlock
1814 Nov 2011 @ 12:08 PSTPrivate Forum
1711 Oct 2011 @ 12:27 PDTDatabaseReplyMerge Vs Delete/Insert //have you benchmarked MERGE and DELETE/INSERT approaches?// I am going to.   //Generally MERGE should be faster in execution, but I have seen DELETE/INSERT queries working fast...
1611 Oct 2011 @ 07:49 PDTDatabaseTopicMerge Vs Delete/Insert Recently I encountered an interesting discussion with one of my fellow developer. I have a following scenario:   I have staged data with 56 millions rows. Some of the column val...
1527 Jun 2011 @ 01:42 PDTToolsReplyPipes in BTEQYou can use the following command in shell script to create named pipes mknod tran_data.out p Let us say, if you want to export data in named pipes, embed bteq in the same shell script . ...
1402 May 2011 @ 12:37 PDTToolsReplyBteq Import HelpSure
1329 Apr 2011 @ 06:12 PDTToolsReplyBteq Import HelpDATA, INDICDATA modes are binary formatted. You cannot read it in text editor. When you export using INICDATA, then you have to import using INDICDATA. EXPORT ---> IMPORT DATA ---> DATA IND...
1229 Apr 2011 @ 02:56 PDTToolsReplyBteq Import HelpAnantha '.IMPORT VARTEXT' interprets input file content as variable length characters. Please note that only acceptable datatype for VARTEXT are VARCHAR, VARBYTE, and LONG VARCHAR. If you use ot...
1129 Apr 2011 @ 02:43 PDTToolsReplybteq export issue@Jimm Cool. Thanks for the nice bteq. Pardon my ignorance on DD tables. I just wanted to get something quick. I thought requesttext was suitable to get table definition.
1029 Apr 2011 @ 02:39 PDTToolsReplybteq export issue@Jim Chapman : Yes, Your solution worked. Why couldn't .width size handle? So, formatting X(255) suppress rest of the text? I am wondering how does the SQL assistant manage to get full text?
928 Apr 2011 @ 02:25 PDTToolsTopicbteq export issueI was trying to export DDLs for the existing tables. I wrote a bteq script as follows. Although width is set to 20000, it exports partial row. I tried to increase width size to max 60000, still I h...
828 Apr 2011 @ 08:07 PDTToolsReplyBTEQ .PACK and deadlockFLOAD and MLOAd use data blocks to load tables. They are much faster than BTEQ multistatement requests (PACK). I prefer to use BTEQ for small set data load.
721 Apr 2011 @ 02:06 PDTToolsReplyBTEQ .PACK and deadlockLearned few things new. Thanks Dieter.
620 Apr 2011 @ 02:08 PDTToolsReplyBTEQ .PACK and deadlockThanks Dieter. I have not used TPUMP much. Once I had same deadlock behavior when I used TPUMP PACK without SERIALIZE option. SERIALIZE eliminated the deadlock.I will find out more information ...
518 Apr 2011 @ 06:55 PDTToolsTopicBTEQ .PACK and deadlockI am trying to understand why BTEQ .PACK command creates dead lock on tables with NUPI. I had a scenario where I needed to load nearly 2 million rows on mutiset table with NUPI. I had lot of dup...
408 Apr 2010 @ 11:21 PDTDatabaseReplyScript to send a mail to the Recipients in BTEQ...Use unix script to invoke bteq script and get the return code of bteq script. Use unix email command to send mail based on bteq script's return code.
313 Feb 2010 @ 08:18 PSTDatabaseTopicCapturing ERRORCODE in BTEQ from stored ProcedureI am new to stored procedure. We might need to capture error code from store procedure in bteq to take decision based on success/failure of stored procedure.How can I return ERRORCODE from store pr...
208 Feb 2010 @ 10:44 PSTDatabaseReplybteq script and password policy@emilwu @vador Hmm... going with encryption/decryption program may bring up another layer. I just wanted to see any ready made program available with Teradata for password encryption. However I am ...
105 Feb 2010 @ 06:21 PSTDatabaseTopicbteq script and password policyMy connectivity with TD is almost from third party ETL tool. ETL tool can create encrypted password to logon teradata. I am wondering that how is it possible to connect with teradata without ex...