#DateForumTypeThreadPost
1509 Nov 2012 @ 02:56 PSTDatabaseReplyUpdate queryHi,   Try the following query.it shld work syntactically UPDATE A FROM test1 A, test2 B SET A.WK = B.PER_NO WHERE A.data BETWEEN 1 AND 4 AND A.T_Date = B.T_Date + 7 AND A.T_DT > ...
1414 May 2012 @ 02:24 PDTDatabaseReply"bteq << !@! > $LOGFILE 2> $LOGFILE" in the shell script Hi Its used to indicate the end of that bteq inside a shell script. for ex: bteq << !@! > $LOGFILE 2> $LOGFILE .LOGIN **** sel * from *** .LOGOUT !@! ...
1314 May 2012 @ 01:14 PDTDatabaseReplyTrimming Inner Spaces Hi Neetu, you can try select 'A01 567 8 ' as X, trim(substring(X from 1 for 1)) || trim(substring(X from 2 for 1)) || trim(substring(X from 3 for 1)) || trim(...
1211 May 2012 @ 02:45 PDTDatabaseReplyAvoid prdct join Hi Karthik It ill throw syntax error. we can't update a derived table. I guess the only option is to collect stats on recommended columns.
1110 May 2012 @ 11:31 PDTDatabaseReplyHow to call unix commands with in the BTEQ script? Hi I guess you cant use if statement inside a BTEQ. .OS is used only to execute UNIX commands inside BTEQ and if is not a command. u can try if  [ cond1 ] then  &nb...
1010 May 2012 @ 09:57 PDTDatabaseReplyDoubt in SELECT CASE WHEN EXISTS statement Hi , Can you be specific about your requirement? Don think we can use subqueries inside CASE statement. Instead you can join TBL1 and TBL2 and use IN in CASE statement like SELECT TB...
916 Feb 2012 @ 08:39 PSTDatabaseReplySet unix variable inside bteq Hi Srinivas, you can export your select query result into a param file and then use the same in other sql's before startin the BTEQ in shell script jus refer to the path of the param...
814 Feb 2012 @ 08:51 PSTDatabaseReplyBTEQ Login without passing password Hi, You can save your password and login id in a file and use it inside the BTEQ for login. you can save the following line .LOGON DBNAME/LOGINID,PASSSWORD; inside a file (ie) h...
714 Feb 2012 @ 02:24 PSTDatabaseReplytranslate join on two conditions to a select statement Thanks Diether.. I jus copied frm previous one.Forgot to add the ON condition.
614 Feb 2012 @ 02:16 PSTToolsReplyTime column - changing format. Hi Try this one sel cast(cast(column_name as INTERVAL DAY TO minute) as interval minute(3))
513 Feb 2012 @ 11:02 PSTDatabaseReplytranslate join on two conditions to a select statement is End_dt on tableB is populated with blanks? If thats the case you can't use your query. you can try sel * from A left outer join (sel * from B where End_dt is null) B ...
413 Feb 2012 @ 07:53 PSTToolsReplyPassing Parameter to BTEQ If you are using UNIX to run the BTEQ u can try parm file.. create a param  file and  assign value for your DB ex:userfolder/param inside that create a variable that your going...
313 Feb 2012 @ 03:48 PSTDatabaseReplyImport Problem - Date field Hi yamu If ur using queryman to import,its better to copy the content from excel into a notepad/textpad and try.set delimiter optinon to {TAB} for import in queryman..Even i got the same err...
208 Feb 2012 @ 03:49 PSTDatabaseReplyNeed help for classification look up table If u don want to consider rows that are not present in classification table then u can try sel b.sCol 1,a.cCol3,a.cCol2,b.sCo1 3,c.tCol3 from classification a join Source b on ...
108 Feb 2012 @ 03:38 PSTDatabaseReplyNeed help for classification look up table Hi, Do u want to verify for those rows which doesn't have their entry in classification table also??