All forum activity

#DateUserForumTypeThreadPost
124229 Jun 2006 @ 11:47 PDTMattW At ATTDatabaseReplyHow do you declare a variable in Teradata SQL?I needed a couple variables for a start date and end date for a long stretch of code to make it more easily reusable. I settled for making a single row volatile table which holds these start and en...
124129 Jun 2006 @ 10:43 PDTDrivers and UDFsConnectivityTopicAccess to terardata through SAP BW via J2EE Engine (JDBC)Hi,I'm trying to connect to teradata through SAP BW via J2EE engine (JDBC). I'm able to connect and I can see all the objects for all the databases. But I'd like to connect to a specific database...
124029 Jun 2006 @ 09:39 PDTPervez AhmedDatabaseReplyVerification of source dataThanks a lot. This is great. Pervez Ahmed
123929 Jun 2006 @ 08:07 PDTBarry-1604AnalyticsReplyMLOAD ErrorsHave you tried defining the input layout as a single VARCHAR column? Then, you should be able to only insert the rows where the length of the column was what you are looking for (using the APPLY WH...
123829 Jun 2006 @ 07:51 PDTBarry-1604DatabaseReplyVerification of source data"Field-level" editing can take place with Multiload or Tpump(Fastload is very restrictive in what you're able to do). So, with Multiload, you can have CASE statements, which combined with function...
123729 Jun 2006 @ 04:42 PDTManoj_Kumar_ParmarDatabaseReplyJoinsDieter Thanks for reply but, Is it sure for Nested join, or can't say anything about it too.Thanks in advance
123628 Jun 2006 @ 10:23 PDTPervez AhmedDatabaseReplyVerification of source dataThanks for responding. One of the tehnial questions I was asked in an interview. How do you validate and perform editing on source data in teradata utilities like MLOAD? My understanding is that lo...
123528 Jun 2006 @ 03:53 PDTdnoethToolsReplyMLOAD .LAYOUT continueifThis can't be done within Mload using continueif.Do the concatenation before you load the file or write an Inmod to do it...Dieter
123428 Jun 2006 @ 03:50 PDTdnoethToolsReplySQL MedianDROP table median_test;CREATE MULTISET TABLE median_test( id INTEGER ,med_group INTEGER ,med_value INTEGER) PRIMARY INDEX (id);INSERT INTO median_test VALUES (1, 1, 1);INSERT INTO median_test VA...
123328 Jun 2006 @ 03:47 PDTdnoethToolsReplySize Limit on Varchar / ConcatenatingCheck the SQL manual, Data Types and Literals:Maximum size of a char/varchar is 64000Dieter
123228 Jun 2006 @ 03:46 PDTkpothenJobsTopicTeradata Developers or DBA'sI have a contract position in Canada. My client is looking for Teradata both Developers and DBA's. Please contact me to discuss further.Kim PothenP3, Inc.kim.pothen@p-3-inc.com
123128 Jun 2006 @ 03:44 PDTdnoethUDAReplyTutorialIf you installed the demo version there should be a help file with info about how to login, which example databases exist.Dieter
123028 Jun 2006 @ 03:25 PDTdnoethDatabaseReplyNeed to run many SQL's at one shot even if error occurs inbetweenIf you export using BTEQ there'll be one output file.Newer versions of QueryMan support it, too:Tools -> Options -> Export/Import -> Write all exported Answersets to a single fileDieter
122928 Jun 2006 @ 03:20 PDTdnoethDatabaseReplyLoop through a Macro?A macro can't be call itself, i.e. no recursion.Possible solutions:- Recursion within a BTEQ script, illegal, but working.- Loop within a SPDieter
122828 Jun 2006 @ 03:14 PDTdnoethDatabaseReplyget error msg: "Row size or Sort Key size overflow."I've seen this once using ODBC/Queryman, but i can't remember exactly.It could be fixed by modifying the session character set.Dieter
122728 Jun 2006 @ 03:09 PDTdnoethDatabaseReplyJoinsThere are no hints in Teradata, so you can't force the optimizer to choose a special join type.Dieter
122628 Jun 2006 @ 03:08 PDTdnoethDatabaseReplyVerification of source dataCould you please elaborate, what you're trying to achieve?Dieter
122528 Jun 2006 @ 03:04 PDTdnoethDatabaseReplyHow do you declare a variable in Teradata SQL?There are no variables outside of SPs in Teradata.But there are parameters for macros, and if it's a script, you can use shell-variables in Unix.If you provide us with more details, maybe we can sh...
122428 Jun 2006 @ 02:57 PDTFredDatabaseReplyIs there an Equivilant Function to Execute in Teradata.CALL DBC.SysExecSQL('Update temp set temp.job = ''the date is '' ' || temp.startdate)Note that to use this feature, the "owner" of the SP (the database/user in which the procedure is defined) must ...
122328 Jun 2006 @ 02:56 PDTdnoethDatabaseReplyIs there an Equivilant Function to Execute in Teradata.In your example it's not necessary to use EXECUTE :-)In general, if you want to execute dynamic sql it's only allowed within a SP using a call to dbc.sysexecsql.Of course it's possible to create a ...
122228 Jun 2006 @ 02:36 PDTdnoethDatabaseReplyLastAccessDateThat feature is enabled using dbscontrol -> general fields -> ObjectUseCountCollectRatePlease check the manuals before enabling it.Dieter
122128 Jun 2006 @ 02:33 PDTrlaskarDatabaseReplyNeed to run many SQL's at one shot even if error occurs inbetweenLet's remove UNION from end of all SQL's. It's just that I tried to execute all SQL's and output to a single file instead of multiple output files for all SQL.Thanks Deiter.rlaskar
122028 Jun 2006 @ 02:30 PDTdnoethDatabaseReplyNeed to run many SQL's at one shot even if error occurs inbetweenProbably no existing DBMS will do what you want.Of course you can remove the UNION ALL and submit seperate queries.Dieter
121928 Jun 2006 @ 01:51 PDTrlaskarDatabaseTopicNeed to run many SQL's at one shot even if error occurs inbetweenHi,I need help in executing SQL's. I have some say 50 SQL's combined using UNION ALL. Now when we ran the SQL's at one shot, it stops when it found error like "Column/table does not exist for few S...
121828 Jun 2006 @ 12:41 PDTSociodudeConnectivityTopicTrying to set up ODBC connectionI've been trying to set up the ODBC connection for Teradata while using the program Advanced Query Tool. I've already downloaded the latest driver and installed it on the computer. When I go to a...

Pages