#DateForumTypeThreadPost
401 Aug 2007 @ 07:59 PDTUDAReplyTeraData vs Oraclenicky,Your assertions are not quite right :its too expensive. you need long pockets to work with teradata.==> this is not a technical issue so I won't answer (though it's wrth considering this poin...
313 Oct 2006 @ 12:06 PDTDatabaseReplySELECT "TOP" FROM...Why not simply using :SELECTKeyId,max("Language")from tblMyTablegroup by 1(Note : Language is a keyword)
205 Oct 2006 @ 07:32 PDTToolsReplyCan BTEQ Prompt User for Password in Scriptsbteq cannot prompt the user for anything but korn shell can.your script becomes:#!/bin/ksh#prepare your scriptfil=$1;scmd=s/\$infil/$fil/gsed $scmd ~/bin/cmds.scr > tmp#prompt for username and pass...
116 Aug 2006 @ 07:13 PDTDatabaseReplyAdd a number to next rowHello,you can try this SQL:select col2,col3,(sum(col3) over (order by col2 rows between unbounded preceding and 1 preceding) - (sum(col3) over (order by col2 rows between unbounded preceding and 1...