Putting query result dynamically to one cell of table from shell Post: 302979152

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to store query multiple result in shell script variable(Array)

:) Suppose,I have one table A. Table A have one column. Table A have 10 rows. I want this 10 rows store into shell script variable. like #!/bin/ksh v_shell_var=Hi here in call oracle , through loop How can I store table A's 10 rows into v_shell_var (Shell Script Array). Regards, Div

2. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Hello, Can someone please advise me how to put the db2 query reult into an array? For example, the query reults are: string A string B string C Then how do I put them into array=string A array=string B ...

3. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance

4. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh...

5. Programming

Query result from shell script

Hi, I wrote the below script to get the query result from a Syabase DB. isql -s -U **** -P **** SYBASE SERVERNAME USE ***(Database name in Sybase) @command.sql But im not getting the output. Can anyone help me on this

6. Shell Programming and Scripting

Taking information from a postgres sql query and putting it into a shell script array

I have a postgres sql statement that is the following: select age from students; which gives me the entries: Age --- 10 15 13 12 9 14 10 which is about 7 rows of data. Now what I would like to do with this is use a shell script to create an array age. As a results...

7. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data....

8. UNIX and Linux Applications

SQL - how to alter info of a cell in table

Hello, I am newbie on mysql and trying to edit my database from terminal under linux. What I need to do is to change the information written in a cell in table. Let me explain what I tried: $ mysql -u mysqluser -p $ show databases; $ USE catalogue; $ show tables ; $ select * from...

9. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one...

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)