#DateForumTypeThreadPost
82130 Dec 2015 @ 01:27 PSTConnectivityReplypassword expired ado and vb6Good point. Simply closing the connection object isn't enough. The original session would have to be logged off, which is hard to ensure if you are using Resource Pooling or Session Pooling (an...
82029 Dec 2015 @ 01:59 PSTGeneralReplySample teradata databaseThe Teradata Express images contain several small sample databases - though depending on the TD version & size of image, definitions may vary and some tables may not be populated. At ...
81929 Dec 2015 @ 01:34 PSTConnectivityReplypassword expired ado and vb6After a 3032 warning, you should be connected but the only valid statement would be: MODIFY USER oixxxx AS PASSWORD=newpassword; Or you can close the connection, append PWD2=newpassword to the con...
81828 Dec 2015 @ 02:25 PSTTeradata ApplicationsReplyLoad Flat File using TDE 12.1.5.0The first thing that jumps out is that tbuild doesn't read stdin for the script. You need to supply the script filename via the -f option on the tbuild command line. And you also presumabl...
81728 Dec 2015 @ 02:20 PSTGeneralReplyConvert a column into distinct comma separated list in teradataYou need to use a nested query with GROUP BY PRIMARY_NAME, BR_CD to return only distinct combinations, then use XMLAGG in the outer query to concatenate into one row.
81622 Dec 2015 @ 10:32 PSTDatabaseReplyStatistics on STJIs vs Base ColumnsYou SHOULD collect PARTITION stats on the JI if it has a PPI. Whether you need to collect all the "recommended" stats for the JI is a separate question, just as it is for the base ta...
81521 Dec 2015 @ 01:23 PSTDatabaseReplyStatistics on STJIs vs Base ColumnsPARTITION is not actually a base table column. Even if the partitioning expressions happen to match between the base table and a single-table non-aggregate JI, stats for the PARTITION "co...
81421 Dec 2015 @ 01:18 PSTDatabaseReplyDynamic partition not workingSending a bunch of rows to NO RANGE partition would eliminate the error, but is unlikely to be the desired result. Note that the definition of partitions based on CURRENT_DATE (what you ...
81321 Dec 2015 @ 01:10 PSTDatabaseReplyCollecting table level stats in TD14.10 with ONE pass through the table?The optimizer will attempt to re-use spool files for additional statistics, and may change the order in which stats are collected to improve re-use.  But no, it does not guarantee stats can be...
81221 Dec 2015 @ 12:55 PSTViewpointReplyMonitor PartitionYou can query DBC.SessionInfoV to see which sessions are currently logged on to the Monitor partition. There is a limit to the number of Monitor sessions allowed per PE (IFPNo in SessionInfoV).
81118 Dec 2015 @ 09:28 PSTAnalyticsReplyLooking for broken views in a databaseNote that the referenced article is talking about coding a Stored Procedure and the code snippets are just some key parts of that procedure. This is not valid as stand-alone SQL, e.g. in a BTE...
81018 Dec 2015 @ 09:07 PSTDatabaseReplyUsing variable in Teradata SIGNALIt's a bug.
80917 Dec 2015 @ 04:13 PSTToolsReplyHow to call TPT scripts from Shell ScriptsOn Windows, it would be the PATH environment variable in the registry, not .bash_profile. How are you launching PowerShell and what environment is it inheriting? PATH should include C:\Progra...
80817 Dec 2015 @ 03:12 PSTDatabaseReplyUsing variable in Teradata SIGNALThe handler in L2 does receive the custom SQLSTATE (though it does not RESIGNAL it correctly, so it doesn't solve your problem).
80716 Dec 2015 @ 11:34 PSTToolsReplyHow to call TPT scripts from Shell ScriptsWhen you say "in a shell script" do you really mean "in a shell script run via cron"?
80616 Dec 2015 @ 11:32 PSTDatabaseReplyRunning bteq scripts through crontabDid you not read the posts above? When cron runs your script, it does not source your user profile. Some options are given above, or Google search for cron profile environment to see some other ide...
80516 Dec 2015 @ 11:05 PSTConnectivityReplyAccess VBA connection to Teradata Express VM 15.10Seems the PWD value isn't being passed through MSDASQL to TD ODBC. Try cn.Open "DSN=TDE;Database=PVDATA;Uid=dbc;Pwd=dbc;PersistSecurityInfo=true;"
80416 Dec 2015 @ 10:55 PSTToolsReplyTPT17122: Error: unable to connect to data source(oracle using TPT script)Please start a new topic for new questions. The EXPORT operator only reads from Teradata, so uses a Tdpid not a DSN. If you want to read from Oracle via a DSN, you need to use the ODBC operator.
80316 Dec 2015 @ 10:49 PSTDatabaseReplyUsing variable in Teradata SIGNALI meant you can copy (or move) code like your GET DIAGNOSTICS / INSERT into the SQLEXCEPTION handler in TEST_L2.   Someone at your site should have access to Teradata at Your Service http://...
80216 Dec 2015 @ 09:15 PSTGeneralReplyCreate a user with privileges to reset any user passwordTo MODIFY another user's password, or to have dbc.UsersV return info for another user, the new user must have DROP USER permission on that other user. (So to meet your state...
80115 Dec 2015 @ 04:16 PSTToolsReplyTransformations in BTEQ vs TPTBTEQ doesn't perform transformations, though you can submit SQL to transform already-loaded data inside the database. TPT provides limited transformations via expressions in the SELECT stateme...
80015 Dec 2015 @ 03:58 PSTDatabaseReplyUsing variable in Teradata SIGNALIf you move the logging into the handler block in TEST_L2, you'll see it actually does receive the SQLSTATE. And if you don't handle the exception in TEST_L2, it gets passed back to th...
79914 Dec 2015 @ 04:10 PSTDatabaseReplyLeft Join check for Nulls not workingPutting filter conditions on the inner table (e.g. "And tbl2.TableName = cte.Table2 And tbl2.DatabaseName = cte.DB" in the first subquery) into the WHERE clause effectively makes&nbs...
79814 Dec 2015 @ 04:00 PSTDatabaseReplyNot able to understand what this query is doing:END_DATE is a host variable. The value will be supplied as a parameter.  
79714 Dec 2015 @ 03:55 PSTToolsReplyBTEQ behaviour for Decimal(10,0) and Deciamal(18,2)There is no single FORMAT that handles both cases as you would like.  For CUSTOMER_IDENTIFIER, FORMAT '-(10)9' would suffice. Note that this allows for 11 total characters, the &...

Pages