#DateForumTypeThreadPost
3115 Aug 2014 @ 11:07 PDTDatabaseReplyError: LOBs are not allowed to be hashedcan you paste the table ddl which gives this error? and possibly the sql too ?
3013 Nov 2006 @ 10:49 PSTDatabaseReplyCapturing OUT parameter value from SP, from with in BTEQ ???thanks Vinay, that was a good idea.but, i have one more alternative of creating one anonymous procedure from bteq and calling the required procedure from the anonymous procedure and capture and ins...
2912 Nov 2006 @ 10:28 PSTDatabaseReplyCapturing OUT parameter value from SP, from with in BTEQ ???Thanks Mate :-) well , that was a good idea, but, i ve been jst thinkin of, there must be a direct way to capture n process this values in BTEQ.Forum Gurus,I too am searching the TD reference mater...
2811 Nov 2006 @ 04:49 PSTDatabaseReplyGenerating Sequence Numbertry csum(1,1,1) as a separate column along with your other columns. it would generate the seq nums. starting from 1...incremented by 1.e.gselect empno, csum(1,1,1) from stumark
2711 Nov 2006 @ 04:39 PSTDatabaseReplyResolve this SQL Querysample output: empno empname maths english science 100 sarathy 40 80 60
2611 Nov 2006 @ 04:38 PSTDatabaseReplyResolve this SQL Queryselect a.empno,a.empname,max(a.maths) maths,max(a.english) english, max(a.science) science from(select s.empno, s.empname,(case when m.subj='maths' then m.mark else nullend) Maths,(c...
2511 Nov 2006 @ 01:09 PSTDatabaseReplyHow to use/enable Parsing Engine?PE is a built in virtual processor and we dont need to enable them, to execute/optimize the SQLs. cos, without PE, any SQL query cant get executed.In order to optimize your SQL query, you could alw...
2411 Nov 2006 @ 01:03 PSTDatabaseTopicCapturing OUT parameter value from SP, from with in BTEQ ???Hi there,could anyone help me out on this.I jst am calling one procudeure "CALL myproc....." from with in BTEQ and it contains 2 OUT parameters.How do I capture those two return variable's values i...
2311 Nov 2006 @ 12:59 PSTToolsReplyWhy Teradata use sub-table for Secondary Indexhi anand,PI and SI are not we could say conceptually same. Becoz, PI is primarily used for Data Distribution( the way, TD stores the data), and SIdex never used for Data Distribution. there r many...
2211 Nov 2006 @ 12:50 PSTAnalyticsReplyvolatile table disappearsits a matter of sessions. when u logon thru Access, u ll get one session established and the VT you create in that session would get visibility only to that session. When u come to SQLA and log in ...
2111 Nov 2006 @ 12:42 PSTDatabaseReplyIdentity Column as Composite UPIhi,as per the Teradata Documentations, an identity column can not be a part of a composite primary index.pls refer the TD docs for further reference.
2011 Nov 2006 @ 12:36 PSTDatabaseReplyRDBMS failure in Macro Build: 3524, The user does not have CREATE MACRO access to database...is it possible to post the fastload log?
1911 Nov 2006 @ 12:33 PSTDatabaseReplyGenerating Sequence Numbercould you pls post, a sample of your espected output?i beleive, with rownum itself, we could generate this.
1825 Oct 2006 @ 11:35 PDTUDAReplyUse Macro to generate Primary key while Inserting recordscant you byepass the macro and directly select from the sequence table by some sub query or something like that?what does the macro do? it simply fetches the max+1 value?
1717 Oct 2006 @ 02:18 PDTUDATopicColstats privileges???HiCould any one explain, what are the privileges(access rights) required to Collect Statistics on any Table?Also, which is the exact DBC table to look in to for obtaining all the privileges one use...
1613 Oct 2006 @ 12:49 PDTDatabaseReplyselect a row previous from the Max value.here is a alternate approach which doesnt use any volatile tables but a subquery.select Home_router_code from where plcmt_end_dt = (select max(plcmt_end_dt) from T where T.plcmnt_end_dt NE (sel...
1512 Oct 2006 @ 05:46 PDTDatabaseReplyHow to find out the table create date?hope it would suffice to solve your prob....select tablename, databasename, createtimestamp, lastaltertimestamp from dbc.tables where tablekind in ('T','V')order by 4 desc
1412 Oct 2006 @ 05:28 PDTDatabaseReplywhether row hash changes when new nodes or Amp added?RowHash is getting generated from the Primary Index value. Given the Primary Index value to the Hashing Algo, it will generate the row hash. So, RowHash is always dependant on the primary index val...
1309 Oct 2006 @ 05:13 PDTDatabaseTopicIs there any way to select "ROWID" of a record?Hi everyone,is there any way to select the "ROWID" of a record? as we could do in Oracle?My requrement is to delete the duplicate records(based on some particular group of coluns) from a table.sele...
1205 Oct 2006 @ 02:36 PDTToolsReplyCan BTEQ Prompt User for Password in Scriptsalternatively you can use the 'ftppwd' utility in UNIX. where in, you could store your personalized pairs of DBServername and Passwd and retrive them, dynamically from the BTEQ script. hope dis wou...
1126 Sep 2006 @ 10:44 PDTToolsReplyProblem in loading data with Fastloadcould u pls post a extract of the script u use?
1025 Sep 2006 @ 11:25 PDTToolsReplyProblem in loading data with FastloadAre you using INDICATOR mode??try setting the separator which your flat file uses.SET RECORD VARTEXT ",";remove INDICATORS from the begin loading, if your flat file is pure text mode.BEGIN LOADING ...
925 Sep 2006 @ 08:55 PDTDatabaseTopicrollback in TD.Could anyone pls explin , how we do rollback in TD?
825 Sep 2006 @ 08:53 PDTDatabaseReplyCOALESCE with ELSE error in CASE STATEMENTjst givit a try! hope dis ll wrk!select casewhen cust_sys_cd='CI' then 'wholesale'when cust_sys_cd='LT' then 'retail'else (coalesce(OS_CUST_SYS_cd,'xyz','abc'))endfrom cust
719 Sep 2006 @ 12:50 PDTToolsReplyMultiload Unformat CommandHi,Could you pls post the extract of the script you used?

Pages