#DateForumTypeThreadPost
33021 Jan 2008 @ 07:03 PSTToolsReplyFastexport outputThe default export file format is fastload, which is binary... you may want to try the TEXT format... lookup the fastexport manual for various formats and what they do.
32917 Jan 2008 @ 09:22 PSTDatabaseReplyuse macro variable in view name in create view statementYou can't generate a DDL dynamically from macro.What you need is a stored procedure with dynamic sql to generate the view definition using parameters...something like this ......REPLACE PROCEDURE G...
32817 Jan 2008 @ 09:07 PSTUDAReplyMultiload in ETLYou may want to start your analysis by checking how skewed your data is, if you have too many NUPI duplicates etc ....
32716 Jan 2008 @ 08:42 PSTDatabaseReplyPassing Date parm in BteqYou should be able to set it at the parent script or the child script, personally I would prefer the quotes to be applied at the child script.# parent script (calls child script with required date ...
32616 Jan 2008 @ 12:25 PSTToolsReplyHow to create mulitple stored procedures in one file via BTEQsome how I can't get the redirection operators to show up in the post ..Grr...so, well you know.... run the compilesps.bteq bteq file using bteq ;)
32516 Jan 2008 @ 12:23 PSTToolsReplyHow to create mulitple stored procedures in one file via BTEQoops that's again a unix syntax ... ;)you would want to put the contents .logon;.compile file = proc1.ddl;.compile file = proc2.ddl;........into a file call compilesps.bteqand then do a bteq &1tha...
32416 Jan 2008 @ 12:19 PSTToolsReplyHow to create mulitple stored procedures in one file via BTEQI am not sure if bteq can create stored procs online.....From my experience it always needs to be "compiled" if you are using bteq.so if you have multiple stored procs in different ddl files like t...
32316 Jan 2008 @ 07:04 PSTToolsReplyCan't view all the columns for a query result in BTEQoops I meant to say type .set width 300;(or some larger number)
32216 Jan 2008 @ 07:03 PSTToolsReplyCan't view all the columns for a query result in BTEQDid you check the .set width ? (do a .show controls in bteq to see all settings) it might be getting truncated to the right .....set width ;
32116 Jan 2008 @ 06:47 PSTDatabaseReplyTeradata Demo versionin the directory (if you chose the default install paths)C:\Program Files\NCR\Tdat\tdconfigyou will find two files (depends on the number of amps, default is two)Amp0-Pdisk0Amp1-Pdisk0So you can re...
32015 Jan 2008 @ 08:34 PSTToolsReplyCasting Zoned decimal into readable decimalAlso makes sure that your data content in "Field1" and the format specification match accurately or else you might get surprisesfor example'12L' with various conversionsField1 (DECIMAL(12,2), FORM...
31915 Jan 2008 @ 09:54 PSTDatabaseReplyTeradata Demo versionMost likely one of your "amp disk" files got corrupted. I've noticed this happening when the computer crashes while the db is running, which results in the db files getting corrupted.You can always...
31814 Jan 2008 @ 08:15 PSTToolsReplymaximum number of input file to fastloadAlso unix guys make use of named fifos to load multiple files in one shotit goes something like this (not a very neat code ;) )#create the fifomkfifo -m 600 $HOME/work/myfif# combine all files and...
31714 Jan 2008 @ 04:26 PSTToolsReplymaximum number of input file to fastloadUnless something interesting has happened in recent times, it was one input file per load job and the trick to load multiple files was to submit multiple fastload jobs serially with different file ...
31614 Jan 2008 @ 03:39 PSTDatabaseReplycollect statisticsTo add a few cents to Leo's dollars, also ensure that if you collected stats on any table, do keep collecting as the data in the table changes.If you can't collect it on a regular basis, make sure ...
31514 Jan 2008 @ 10:19 PSTDatabaseReplyExport to Excel Or XMLYou can export the data as comma separate values (CSV) into .csv file, and excel can open it.so in bteq.set titledashes off;.set width 1000;.export file = myfile.csv;* This is for heading in excelS...
31414 Jan 2008 @ 09:32 PSTDatabaseReplyHow do we find the data dictionary tables and views in Teradata?The data dictionary tables and view are available under the user DBC.However you are NOT supposed to access these tables directly (and you won't have permissions either), instead you should go thro...
31314 Jan 2008 @ 09:26 PSTDatabaseReplydrop statistics in teradataThis is one way of dropping a multi column stats. (There's one more syntax)DROP STATISTICS ON MyTable COLUMN(col1, col2);you will notice that the syntax is similar to the collect stats syntax.
31201 Nov 2007 @ 02:05 PDTDatabaseReply10065 WSA E HostUnreach:The Teradata server can't currently be reached over this networkI hope you have installed all the required components installed (like Bynet etc)Check if you can see in your windows services, one entry for bynet, and three entries that starts with teradata ....o...
31131 Oct 2007 @ 08:04 PDTDatabaseReplyJDBC - Problem calling macro with result-setYou cannot make use of executeQuery() because the macro modifies data. the executeUpdate() API is not designed to return resultsets either.You should use execute() and make use of the getResultSet(...
31030 Oct 2007 @ 10:34 PDTDatabaseReplyPPIThe point is with an NUPI it WILL NOT probe all partitions during insert (which is what we have been talking all along, not the read part !), but with UPI (if that was allowed theoretically) it wil...
30930 Oct 2007 @ 12:15 PDTDatabaseReplyWhat is Typical rows per value?Typical row/value for a column col1, can be explained like this ...do asel col1, count(*) cntfrom mytablegroup by col1;now check what is the maximum repeated value for cnt (ie the most recurring co...
30829 Oct 2007 @ 11:48 PDTDatabaseReplyPartition Primary Index(PPI) and PIPlease refer this thread.http://www.teradata.com/teradataForum/Topic6553-9-1.aspx
30729 Oct 2007 @ 07:47 PDTToolsReplyMultiload - Highest return code encountered = '20'Your target table has an UPI and you probably have a record in your file, which has a duplicate PI (ie PI value already there in the target table), you can check it up in the error table NEX_UV_INS...
30629 Oct 2007 @ 05:27 PDTDatabaseReplyColumn compression and Table header sizeGiven that the current table header size is around 128K, you shouldn't have too much (uh ?) problems.I am not aware of a way to check the size of the table header,but if you are interested, there's...

Pages