Changeset 262 for SH_SHM/trunk/source/seed_io/sfd_from_sfdb.csh

Timestamp:

08/11/2010 04:20:09 PM (13 years ago)

Author:

marcus

Message:

r135 | klaus | 2010-08-11 16:18:22 +0200 (Mi, 11 Aug 2010) | 1 line

sfd_from_sfdb for Linux systems

File:

• SH_SHM/trunk/source/seed_io/sfd_from_sfdb.csh (modified) (2 diffs)

SH_SHM/trunk/source/seed_io/sfd_from_sfdb.csh

@@ -4 +4 @@
 #      =================
 #
-# $Revision: 16 $, $Date: 2008-01-25 16:30:13 +0100 (Fr, 25 Jan 2008) $
+# $Revision: 135 $, $Date: 2010-08-11 16:18:22 +0200 (Mi, 11 Aug 2010) $
 #
 # Create sfdfile (db type) for given time window
@@ -48 +48 @@
 set etime=`printf "%02d%02d%02d.%03d" $hour $min $sec $ms`
 
-$SH_UTIL/sol_sql_call.csh $SFDBHOST "select * from sftab where ((sdate = $edate and stime <= $etime ) or sdate < $edate) and ((edate = $sdate and etime >= $stime) or edate > $sdate)"
+if ("`uname`" == "Linux")  then
+    mysql -h $SFDBHOST sfdb -B -e "select * from sftab where ((sdate = $edate and stime <= $etime ) or sdate < $edate) and ((edate = $sdate and etime >= $stime) or edate > $sdate)"
+else
+    $SH_UTIL/sol_sql_call.csh $SFDBHOST "select * from sftab where ((sdate = $edate and stime <= $etime ) or sdate < $edate) and ((edate = $sdate and etime >= $stime) or edate > $sdate)"
+endif