514 Feb 2007 @ 12:03 PSTToolsReplyremove French chars from fileSince you mentioned that the data is in the file, I think it would be more efficient to cleanse it before loading into the database, as the SQLs are quite cumbersome and time consuming for such pur...
413 Feb 2007 @ 11:59 PSTDatabaseReplyLastAccessTimeStamp column in DBC.UsersLastAccessTimeStamp is for recording the last access done on the Object and is by default not turned on.What you should be looking to use is is the Logon/off date in the DBC.LogonOff as you correct...
313 Feb 2007 @ 11:55 PSTDatabaseReplyNeed a SQL Function that get me the 2nd Saturday of the monthI think you can use Sys_calendar.Calendar for that.Something likeSELECT 1 FROM Sys_Calendar.Calendar CWHERE C.calendar_date = current_dateAND C.day_of_week = 7AND C.day_of_month between 8 and 14
212 Feb 2007 @ 08:35 PSTDatabaseReplyRunning bteq scripts through crontabTo add a bit, you may want to use the . (dot) operator as well.* * * * * . $HOME/.profile; /a123b/scripts/abc.sh >> /a123b/scripts/hello1.log 2>&1
112 Feb 2007 @ 07:41 PSTDatabaseReplywants to delete rows older than 2 rows in a colomnWHERE datecol < ADD_MONTHS(CURRENT_DATE, -24);