11-25-2008
Hi Frank,
shall i know meaning 047 what you have used in between the print command.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ?
Thanks,
Sateesh (2 Replies)
Discussion started by: kotasateesh
2 Replies
2. Web Development
I have following.
.
.
.
$userid = 2
.
$query = "select username from users where userid = ".$userid.";";
.
$username = $line;
$data="Some Data Here";
.
$query = "insert into logger (username, data) valuse ($username, $data);";
.
I would like to not have 2 database calls. (3 Replies)
Discussion started by: Ikon
3 Replies
3. Shell Programming and Scripting
Hi,
I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use..
Please can any body help me in this regards
Thanks & Regards
Abdul Hafeez Shaik (17 Replies)
Discussion started by: abdulhafeez
17 Replies
4. Shell Programming and Scripting
count.sh#!/bin/ksh
SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3`
SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3`
LIST="Count Select_All"
select i in $LIST
do
if
then
echo $SQL1
elif
then
echo $SQL2
fi
done (2 Replies)
Discussion started by: killboy
2 Replies
5. Shell Programming and Scripting
Hi there
I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this
SN=123456
n=server1
m=x4140
sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';"
echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Discussion started by: hcclnoodles
4 Replies
6. Shell Programming and Scripting
I know I know..
for sure one of the easier mysql statements. But somehow I can not figure out this.
I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row)
data_12 ... (6 Replies)
Discussion started by: lowmaster
6 Replies
7. Programming
Hello people,
as wrote in title I'm going crazy with a "complex" SQL select.
This is the seelct:
select T_ADDRESS, T_MCC,T_MNC,T_MSIN,T_IM_MNC, COUNT(*) FROM TABLETEST
WHERE T_MCC=123 AND (T_MNC=11 OR T_MNC=01)
GROUP BY T_ADDRESS,T_MCC,T_MNC,T_MSIN,T_IM_MNC HAVING count(*) > 5;This select... (7 Replies)
Discussion started by: Lord Spectre
7 Replies
8. Programming
Hi All,
I had a query related to sql select update replace command.
i have a table named clusters and it looks like this
name model characteristics
sample1.1 +123 parent
sample1.2 -456 clone
sample1.3 +122 ... (5 Replies)
Discussion started by: sonia102
5 Replies
9. Programming
Hi All,
I had a query related to sql select replace command.
i have a table named clusters and it looks like this
Code:
name characteristics
sample 1.1 parent
sample 1.2 ... (2 Replies)
Discussion started by: siya@
2 Replies
10. Shell Programming and Scripting
Hi Forum.
Need your expertise on the following question.
I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited):
Old File:
SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */
... (5 Replies)
Discussion started by: pchang
5 Replies
LEARN ABOUT DEBIAN
comedi_command
COMEDI_COMMAND(3) Comedi reference COMEDI_COMMAND(3)
NAME
comedi_command - start streaming input/output
SYNOPSIS
#include <comedilib.h>
int comedi_command(comedi_t * device, comedi_cmd * command);
DESCRIPTION
The function comedi_command starts a streaming input or output. The command structure pointed to by command specifies settings for the
acquisition. The command must be able to pass comedi_command_test with a return value of 0, or comedi_command will fail. For input
subdevices, sample values are read using the function read on the device file. For output subdevices, sample values are written using the
function write.
RETURN VALUE
If successful, 0 is returned, otherwise -1.
AUTHORS
David Schleef <ds@schleef.org>
Author.
Frank Mori Hess <fmhess@users.sourceforge.net>
Author.
Herman Bruyninckx <Herman.Bruyninckx@mech.kuleuven.ac.be>
Author.
Bernd Porr <tech@linux-usb-daq.co.uk>
Author.
Ian Abbott <abbotti@mev.co.uk>
Author.
COPYRIGHT
Copyright (C) 1998-2003 David Schleef
Copyright (C) 2001-2003, 2005, 2008 Frank Mori Hess
Copyright (C) 2002-2003 Herman Bruyninckx
Copyright (C) 2012 Bernd Porr
Copyright (C) 2012 Ian Abbott
This document is part of Comedilib. In the context of this document, the term "source code" as defined by the license is interpreted as the
XML source.
This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as
published by the Free Software Foundation, version 2.1 of the License.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
Comedi 07/06/2012 COMEDI_COMMAND(3)