#DateForumTypeThreadPost
7726 May 2009 @ 03:21 PDTToolsTopicArchive & RestoreDoes having hash indices impact the the archive run time for a database?thx
7606 Aug 2008 @ 11:48 PDTToolsReplyPutting 0's in front of the number if it is less than 19 in lengthHi,This should do the trick.SEL SUBSTR('000000000000000000',1,(18-CHARACTER_LENGTH(TRIM('9050'))))||'9050';Replace '9050' with column name and it should format all rows in the table.reg,
7505 Aug 2008 @ 02:59 PDTDatabaseReplyextracting table names given a Column name from different databaseshi,**Robert's solution will provide you what you want.I have just split up his query since these are huge views.CREATE VOLATILE TABLE DBC_VT AS (SEL DATABASENAME FROM DBC.DATABASESWHERE DATABASENAM...
7405 Aug 2008 @ 01:37 PDTToolsReplyRTWPR_TDW_Staging.STG_ADDRESS_DETAILS is being MLoadedhi,can you paste your MLoad script? you might be using the stmt in wrong place.reg,
7305 Aug 2008 @ 10:40 PDTToolsReplyhow to avaoid Junk values in Fast Exporthi,you cannot load data into tables using fast xport. I assume it was a typo... did you mean fastload?reg,
7205 Aug 2008 @ 10:27 PDTToolsReplyhow to find sysdate and time valuehi,this should help - SEL DATE,TIMEthx,
7101 Aug 2008 @ 03:47 PDTToolsReplyDOUBLE QUOTES as string delimiters in source filehi,two options I can think of...1. Use INMOD and format the data before it passes on the data to MLoad2. or try SUBSTR with INDEX/LENGTH options in MLoad script if you can extract just the data wit...
7031 Jul 2008 @ 11:04 PDTUDAReplyData conversions/validations in mload or bteq?hi,Its better to do the conversions/validations duinrg MLoad - and if you use INMOD then it will be fast to do these priliminary data conditioning before you apply the data from temp to target wher...
6931 Jul 2008 @ 10:51 PDTDatabaseReplyOptimizing Viewhi,As with any join, the table size matters most and also the joining columns.-> If possible have the primay indexes on respective tables as join columns-> Join index is a worthy option to ex...
6831 Jul 2008 @ 10:32 PDTDatabaseTopicPermant JournalWe have a large databse which houses everyday updates with change data capture (CDC). The weekly archive process takes really long hours to complete everytime and I suggetsed to implement PJ and ar...
6730 Jul 2008 @ 02:17 PDTToolsReplyBTEQ Problemhi,consider using a stored procedure instead.thx,
6630 Jul 2008 @ 02:03 PDTDatabaseReplyincomplete result by show viewhi,Try to export the resultset to a file using the 'File -> Export Results' option, if you are using Teradata SQL Assistant.HTH,
6530 Jul 2008 @ 11:46 PDTUDAReplyNeed SQL help to remove repeated records...hi,You said you have a primary index - if it a non-unique PI then you can very well retain all records and do the udate.If its a Unique PI, its obvious that table A will not have repeating values (...
6429 Jul 2008 @ 09:53 PDTDatabaseReplyPlease help me with this Querycan you give the error code?
6329 Jul 2008 @ 09:45 PDTDatabaseReplyextracting table names given a Column name from different databaseshi,I see that you already posted this query and got the response from Robert F. Brooks.
6229 Jul 2008 @ 09:42 PDTUDAReplyVARCHAR fieldsjust to add to the comments here......any VARCHAR field consumes extra bytes (than actual data length) to hold the data length of the data.So, unless there is lot of varied data legth data coming i...
6129 Jul 2008 @ 09:30 PDTDatabaseReplyStatistics in Teradatahi,just an excerpt from one of the reference manuals - refer manuals for detailed undestanding of statistics- The purpose of collecting statistics is to compute statistical data that theOptimizer u...
6028 Jul 2008 @ 11:53 PDTToolsReplyteradata load utilityhi,TPUMP is apt for continuous near real-time updates whereas MLOAD is used for batch updates with very high volume.thx,
5928 Jul 2008 @ 11:27 PDTDatabaseReplyconverting timestamp to date in where clausehi,how did you define 'date_timestamp' field in your table?
5828 Jul 2008 @ 11:16 PDTConnectivityReplyUNION Vs Inner joinhi,here's my suggestion...-> Use 'GROUP BY' instead of DISTINCT-> Use a volatile table to populate with records qualifying the conditions on ypheading1,ypheading2,ypheading3 and ypheading4. ...
5725 Jul 2008 @ 11:48 PDTDatabaseReplyError-Missing/Invalid SQL statement'E(3706):Syntax errorFor DATEPART you can use the EXTRACT and AFAIK there is no direct funtion for date diff, instead you can directly subtract two dates - sel '2008-07-28' - '2008-07-25'. for further date logics you c...
5624 Jul 2008 @ 11:17 PDTDatabaseReplyError-Missing/Invalid SQL statement'E(3706):Syntax errorthis should work.........THEN EXTRACT(YEAR FROM (ADD_MONTHS(:ITERATNGDATE,-12))) || .......I am not sure if you are trying to add '4' to the year or aoncatenate (||) it as varchar and also the cat ...
5524 Jul 2008 @ 11:04 PDTAnalyticsReplyif and else condition in bteqjust to add to it...while using IF...THEN - when the condition evaluates to false, the it ignores the action in THEN clause and proceeds with the next command. so, nor explicit ELSE stmt with BTEQ ...
5424 Jul 2008 @ 10:44 PDTDatabaseReplywhich utility is to keep back up data in a channel attached(mainframe) client environment?hi,can you rephrase your question..??if database backup is your concern then you have the archive utility to archive your data off the TD and store in as tape datasets.thx
5324 Jul 2008 @ 10:41 PDTDatabaseReplyError-Missing/Invalid SQL statement'E(3706):Syntax errorhi,try to replicate the EXTRACT stmts as in above sample. and can you be specific about what you want to do with the date arithmetic in the CASE stmts - I see you concatenating '||' with year and ...

Pages