#DateForumTypeThreadPost
76617 Dec 2014 @ 03:54 PSTDatabaseReplyExtra space is getting added with data while loading data into varchar data type column you rely on implicit conversions (you insert a int to a varchar) and that is never recommended as you don't know which rules are followed.  I guess you see the placeholder for the possibl...
76516 Dec 2014 @ 01:41 PSTDatabaseReplyStoring with recursive result setYou didn't specify the PI in your create table as syntax.  -> first column is used by default. This can result in many hash synonyms. -> define a good PI or define the table as NO ...
76409 Dec 2014 @ 11:35 PSTDatabaseReplyWhere clause in MLOAD import mode"exact reason" - what do you expect? multiload was designed to avoid journaling and therefore it came up with some rules - one is that the full PI has to be refered as it need to know wh...
76308 Dec 2014 @ 07:56 PSTGeneralReplyHandling Bad datavery generic question - generic answer is yes where there will be always constrains. For example does TPT update handle data type issues but still requires static number of columns... You won'...
76208 Dec 2014 @ 07:49 PSTToolsReplybteq utilityAs long as you are not sharing your bteq file it is difficult to give you the best choices... can't you simply query the table with some count(*)?
76104 Dec 2014 @ 02:11 PSTDatabaseReplyCreate multiple tables using select statement  you can write a stored procedure with dynamic sql - if you have the right to use dynamic sql. Alternative approach is to use SQL to generate the statement based on a small reference table ...
76003 Dec 2014 @ 12:59 PSTGeneralReplyDBC.COLUMNS ... contains duplicate rows for a tableOpen an incident with TD - saw this also in a production system after an upgrade to 14.10
75902 Dec 2014 @ 12:17 PSTDatabaseReplyCREATE TABLE Failed [3737] Name requires more than 30 bytes in LATIN internal form???@Srilamaiti  You should open a new discussion for a new topic. On the different behaviour between two systems both on 14.10: 14.10 is long object name enabled - this means dbc tables and V ...
75830 Nov 2014 @ 01:06 PSTDatabaseReplyQUERY OPTIMIZATIONnot sure that Dieters SQL works out. The where condition will exclude all older sessions -> all cust_ids with one session will be returned...And I don't read the question that only one sess...
75726 Nov 2014 @ 12:01 PSTDatabaseReplyIdentify the queriesAs above statements indicate it also depends on how you connect to the DB - but so far you didn't say which tool you use, how you connect (.net, ODBC, JDBC) etc. Did you try the queryband opti...
75625 Nov 2014 @ 11:45 PSTTrainingReplyI looking Best institute For SAP ABAP in HyderabadHi Rahul, why do you ask for SAP ABAP training in a Teradata forum?
75525 Nov 2014 @ 11:44 PSTDatabaseReplyRow counts of tablesthis had been discussed many times check https://forums.teradata.com/forum/analytics/row-counts-for-every-table-in-a-given-database or ask google teradata Row counts of tables you will get man...
75425 Nov 2014 @ 11:36 PSTDatabaseReplycopy/backup table copy or backup? on the same server? create table mydb.myname as source_db.source_table with data and stats;   would create a copy of the table with a different name on the same server. On a...
75325 Nov 2014 @ 02:16 PSTDatabaseReplyIssues with Decimal Field in Fastload ScriptThe issue is  , Charge Decimal(3) You don't specify the decimal fraction so it will be 0. try   , Charge Decimal(6,3)
75224 Nov 2014 @ 11:28 PSTDatabaseReplyConnecting Multiple Teradata ServersIf you have 15.0 installed check also the easy loader from tpt   Purpose The Teradata PT Easy Loader command, tdload, loads data into a Teradata Database table from a comma-delimited flat f...
75120 Nov 2014 @ 12:48 PSTDatabaseReplyIdentify the queriesSET QUERY_BAND = 'sqltype=perftest;sqlnr=1;runid=1;' UPDATE for SESSION; and you need to run this before each SQL and change the numbers; try  /*my query 1 */ at least I see someti...
75019 Nov 2014 @ 11:14 PSTDatabaseReplyIdentify the queriesCheck the queryband option - you can set for each query a different queryband parameter. This will be visiable in DBQL. Or add a comment to the query text like select -- my query 1 col1, c...
74919 Nov 2014 @ 12:13 PSTDatabaseReplyDECIMAL REPRESENTATION IN EXPORTED FILE AND TABLE which tool do you use to query the DB? Which DB version? Which Tool version? How do you connect? JDBC, ODBC, CLI? Which ODBC/JDBC version?
74805 Nov 2014 @ 08:21 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)very little information provided by you - what do you expect??? check AVG Ordered Analytical / Window Aggregate Functions syntax
74705 Nov 2014 @ 01:23 PSTGeneralReplyConverting Mainframe Copybook's to TD DDLThere shouldn't be a big deal to extract this and map this for simple copy books - where they can be also quite comprex (e.g. defining different record layouts in one copy book) and in this cas...
74604 Nov 2014 @ 04:45 PSTDatabaseReplyUsing result of HELP column within a querynot nice but might be sufficient for you... 1. create a table where you store the results. 2. generate per view 3 statements which a. create a table dummy as select * from your view b. insert s...
74503 Nov 2014 @ 11:52 PSTDatabaseReplyDistinct periodical  I guess this somehow pseudo-code as the join column is missing in both derived tables. And giving that you don’t give the ddls and some test data it is a bit of guessing. You mi...
74402 Nov 2014 @ 11:44 PSTDatabaseReplyPerformance Tips for Group by on all columnsmutiset tables became popular in some areas as they are sometimes faster while inserting data. There are cases where it makes sensce - but as you figured out if you have to pay a lot of resources t...
74331 Oct 2014 @ 08:37 PDTDatabaseReplySize of a data type : check dbc.columns but this holds only the info for data types in use. only other source I am aware of is the documentation...  
74230 Oct 2014 @ 08:56 PDTDatabaseReplylength of a stringwhere characters(variable1) = 3

Pages