#DateForumTypeThreadPost
107116 Aug 2016 @ 09:01 PDTToolsReplyFatal Error with TD TPT APIOn current releases of TD the number of sessions is limited via TASM/TIWM settings. You can't have more instances than sessions, and you can't have more sessions than workload man...
107015 Aug 2016 @ 12:16 PDTToolsReplyCasting Date in Bteq utilitiesFastLoad supports only limited data type conversions, either implicit or using Teradata-style syntax. And at a minimum you would need to change the input to always have 2 digits for the h...
106915 Aug 2016 @ 11:50 PDTDatabaseReplyA table with non-latin characters in table name and column names doesn't display properlyhelp session;
106815 Aug 2016 @ 11:44 PDTUDAReplyBT/ETNot sure what you mean by "in Unix". Do you mean "in BTEQ?" By default SQL Assistant stops executing SQL when an error is encountered. In BTEQ you must explicitly check&n...
106715 Aug 2016 @ 11:21 PDTGeneralReplyMulti Column Primary Index and Secondary IndexNon-unique PI(acctid) may be best choice if number of rows per acctid isn't too huge. Partitioning on bus_dt may be better choice than USI. Again, somewhat depends on avg / max number of ...
106605 Aug 2016 @ 08:14 PDTGeneralReplyMulti Column Primary Index and Secondary IndexSo with either PI, you will scan the table. If you partition on BUS_DATE then you don't have to scan the entire table; you can do that with either PI.   If you need the database to enfor...
106505 Aug 2016 @ 07:39 PDTToolsReplyFastload error: I/O Error on File Open 34Use a comma before FILE, not a semicolon.
106405 Aug 2016 @ 07:34 PDTDatabaseReplyTeredata Error 5497: CALL cannot be submitted in multi-statement requestThe body of a macro is executed as a single request. If the macro contains more than one statement, it is a multi-statement request.
106305 Aug 2016 @ 07:27 PDTDatabaseReplyUser's DDLThere is nothing like a "SHOW" statement that will generate a CREATE USER for you. You would need to reverse engineer the values from the dictionary columns yourself. Also the UsersV view...
106205 Aug 2016 @ 07:20 PDTDatabaseReplyA table with non-latin characters in table name and column names doesn't display properlyWhat is your session character set? Both the CREATE and the SHOW need to use something other than ASCII, e.g. UTF8, UTF16, or one of the optional special character sets.
106104 Aug 2016 @ 12:21 PDTGeneralReplyMulti Column Primary Index and Secondary IndexHow often will you retrieve a specific (acctid, Bus_date) combination? How often will you retrieve data for an acctid but not know the specific Bus_date?  
106004 Aug 2016 @ 11:31 PDTGeneralReplyerror table's are invalid state or table is being loadedYes, this error comes from Data Connector. When you do DEFINE SCHEMA schemaname FROM TABLE tablename, the schema is generated based on the column names and data types. If your input data...
105903 Aug 2016 @ 08:07 PDTGeneralReplyerror table's are invalid state or table is being loadedThe LOAD operator should truncate oversize strings without an issue. I suspect the problem is that the SCHEMA is being generated based on the table definition, and the error is really com...
105803 Aug 2016 @ 07:58 PDTConnectivityReplyUnable to Connect to Teradata Database from Teradata Studio on iOS (Mac)Can you "ping" ICW_Iberiacop1? What does your connection string look like? (Just in general, mask any sensitive info.)
105701 Aug 2016 @ 03:08 PDTGeneralReplyerror table's are invalid state or table is being loadedHave you verified in those cases that you don't have error tables left from a non-fatal error (i.e. some rejected rows) in the prior LOAD?    
105601 Aug 2016 @ 02:57 PDTDatabaseReplyHow to use UTC ??What does "use UTC" mean? You can specify a TIMESTAMP WITH TIME ZONE value with +00:00 as the offset, or use the "AT time zone" modifier, or MODIFY USER to set a defa...
105501 Aug 2016 @ 02:49 PDTDatabaseReplyHow to Enable UTC using TimeDateWZControl cmdNot sure what you mean by "enable" UTC. You can certainly play with TimeDateWZControl setting on a TD Express VM; but please contact Teradata support for assistance before changing t...
105431 Jul 2016 @ 09:52 PDTGeneralReplyerror table's are invalid state or table is being loadedThis message can be interpreted as "Previous load attempt failed, and this job is not a valid restart from the point of failure." So you would need to figure out why the prior load failed...
105331 Jul 2016 @ 09:32 PDTDatabaseReplyDBC - CURRENTPERM EXCEEDS MAXPERMSome things charged against DBC in space accounting are not subject to PermSpace limits, other things (like DDL inserting rows in the tables when you create an object) observe the normal rules...
105230 Jul 2016 @ 04:36 PDTGeneralReplyFinding the Sub String Between < and >In (?<=<) the first < is special (combined with ? and =  makes a lookbehind rather than lookahead) but the second is treated as a literal '<' character based...
105129 Jul 2016 @ 03:17 PDTToolsReplySQL Assistant 15.00 Cursor lagging problems There is a newer version in the TTU15.10 bundle currently available from the Developer Exchange http://download.teradata.com/downloads page. For patch levels other than the ones on this site, see ...
105027 Jul 2016 @ 03:05 PDTDatabaseReplyVolatile Table Vs Derived Table ... Which is best in terms of performance when used in a Join? - - Had a confusion..It depends. Derived table potentially allows for more global query optimization; volatile table gives you more control e.g. PI for data distribution. If the optimizer chooses to materialize the d...
104927 Jul 2016 @ 02:57 PDTDatabaseReplyHow to Write the correct syntax for JoinThink about what the query you wrote is doing. You are joining each row from the first table with all rows in the second table that have the same Store, then doing it again with the third tabl...
104827 Jul 2016 @ 09:24 PDTUDAReplyCollect Stats n Refresh StatsStats are important for source tables in the INSERT/SELECT query. Stats on the target table are not (unless that table is also a source).
104727 Jul 2016 @ 09:10 PDTToolsReplyDelimiter issue in FastloadFastLoad, or more specifically the legacy Data Connector (PIOM) does not provide special handling for quoted data. Consider using TPT LOAD. The TPT Data Connector operator does support "optio...

Pages