SQL Select and awk Post: 302261612

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formatting the sql select result

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. Web Development

SQL Select inside Insert

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. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

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

4. Shell Programming and Scripting

Select SQL Queries Option

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

5. Shell Programming and Scripting

using SELECT sql statement in shell script

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...

6. Shell Programming and Scripting

SQL select all but not if it is already in an other column

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 ...

7. Programming

I'm going crazy with SQL select. Please help!

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...

8. Programming

[Solved] SQL SELECT REPLACE

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 ...

9. Programming

Sql select replace

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 ...

10. Shell Programming and Scripting

Parse SQL text and only format first SELECT statement.

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) */ ...

LEARN ABOUT DEBIAN

nwpjmv

NWPJMV(1)							      nwpjmv								 NWPJMV(1)

NAME

       nwpjvm - Move print job to Unix queue

SYNOPSIS

       nwpjmv [ -S server ] [ -h ] [ -U user name ] [ -P password | -n ] [ -C ] [ -q queue name ] [ -c command ] [ -j job number ] [ -d ]

DESCRIPTION

       nwpjmv is a program that connects to print queues on NetWare servers and moves a designated print job to a Unix queue.

OPTIONS

       -h
	  -h is used to print out a short help text.

       -S server
	  server is the name of the server you want to use.

       -U user
	  user is the print server name at the server.

       -P password
	  password  is the password to use for the print server at the server. If neither -n nor -P are given, and the user has no open connection
	  to the server, pserver prompts for a password.

       -n
	  -n should be given if the print server does not require a password.

       -C
	  By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
	  this conversion by -C.

       -q queue name
	  queue name is the name of the print queue you want to service.

       -c command
	  nwpjmv  removes  the designated job from the Novell queue and feeds the job file to stdin.  command is the printing command that is exe-
	  cuted for each job. The default command is 'lpr'.

	  You can insert several flags into the command, preceded by %. These are replaced with values retrieved from the queue structure for  the
	  print job.

	  %u: This field will be replaced by the name of the user who posted this print job.

	  %d: This field will be replaced by the job description field of this print job.

       -j job number
	  This designates the ID number of the print job to be moved.

       -d causes extra error messages to be logged.

SEE ALSO

       nwclient(5), slist(1), pqlist(1), ncpmount(8), ncpumount(8), pserver(1)

CREDITS

       nwpjmv was written by Bruno Browning (bruno@lss.wisc.edu) based on pserver by Volker Lendecke (lendecke@math.uni-goettingen.de)

nwpjmv								    03/15/2003								 NWPJMV(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formatting the sql select result

Discussion started by: kotasateesh

2. Web Development

SQL Select inside Insert

Discussion started by: Ikon

3. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

Discussion started by: abdulhafeez

4. Shell Programming and Scripting

Select SQL Queries Option

Discussion started by: killboy