Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Pipe SQL select statement results to script Post 42623 by oombera on Friday 31st of October 2003 12:20:28 PM
Old 10-31-2003
Wow, someone actually revisited the boards to post their solution! lol Smilie
 

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Want to use the output of Select statement in Unix script

Hi, I have a UNIX script which calls SQL Select statement: Now i want to use the output of that select statement within my UNIX script so as to call different shell script depending upon the output of the select statement. Can anyone help me in this regard. TIA Akhil Goel (4 Replies)
Discussion started by: akhilgoel9
4 Replies

2. Shell Programming and Scripting

Supress ' quotes in a select statement inside Shell Script

Hi I have a shell script in which a string variable is saving following query. SqlQuery="select a||'|'||b||'|'||c from dual" I am trying to pass above query as a parameter to some script but its giving me error for "single quote". I tried suppressing it using \' instead of just ' but it... (1 Reply)
Discussion started by: mahabunta
1 Replies

3. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell... (1 Reply)
Discussion started by: skyineyes
1 Replies

4. 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... (4 Replies)
Discussion started by: hcclnoodles
4 Replies

5. Shell Programming and Scripting

Read SQL statement in Script

Hi Guys.. need some urgent help... I am stuck in something badly I need to write a script which would read a sql statement (which might be a join/inner join/select/sub select etc. ) I need to read that sql statement ... and in the output I want all the table names and columns (doesn't... (4 Replies)
Discussion started by: freakygs
4 Replies

6. Shell Programming and Scripting

sql select command output formatting in shell script

Hi, I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification in short select var,data from usage; o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies

7. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

8. UNIX for Dummies Questions & Answers

SQL statement is not work on unix script

Hi, I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? :mad: echo " Column filename format a30"|sqlplus4 echo Input file list to check: read filelist for file in `cat $filelist.txt` do... (1 Reply)
Discussion started by: happyv
1 Replies

9. 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) */ ... (5 Replies)
Discussion started by: pchang
5 Replies

10. UNIX for Dummies Questions & Answers

Emailing results of a pl sql procedure from UNIX shell script

Hello All, I am writing the below unix script to email the result of a small pl sql procedure: #!/bin/bash ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME SQLPLUS=$ORACLE_HOME/bin/sqlplus sqlplus -s user/pass@Db_instance<<EOF set echo off set feedback off set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies
HOOLA(6)							     board_gen								  HOOLA(6)

NAME
make-gnome-freecell-board, make-aisleriot-freecell-board, make-microsoft-freecell-board, make-pysol-freecell-board - Programs to generate boards to be used as input to Freecell Solver. SYNOPSIS
program [-t] board-number or for make-pysol-freecell-board: program [-t] [-F] board-number [game-string] or for make-aisleriot-freecell-board: program [-t] board-number [game-string] DESCRIPTION
These programs are command-line programs that can generate the initial board of the Freecell games of several popular Solitaire implementations. Those boards can be in turn be inputted to fc-solve by means of a pipeline, or placed inside a file for safe-keeping. make-pysol-freecell-board and make-aisleriot-freecell-board also accept an optional third argument which indicates the game type. This type defaults to Freecell, but is useful for generating the boards of other games. Note that using this flag does not preclude one from using the "--game" flag of fc-solve. make_pysol_freecell_board.py accepts another parameter called -F or --pysolfc that deals the PySolFC boards instead of the classic PySol ones. A common paradigm for using those programs is something like: bash:~$ make-microsoft-freecell-board 11982 | fc-solve -l gi If the "-t" option is specified, then the 10 cards are printed with "T"'s, instead of "10"'s. While this does not have any effect on fc- solve it may prove useful for other solvers or solitaire implementations which do not accept "10"'s. Here is a short description of each program: make-gnome-freecell-board Generate the boards of the standalone Freecell program that comes with the GNOME desktop. make-aisleriot-freecell-board Generate the Freecell boards of GNOME's AisleRiot. make-pysol-freecell-board A Python script that generates the boards of the various games of PySol. make-microsoft-freecell-board A program that generates the boards of Microsoft Freecell and of the Freecell Pro implementation of Freecell. OPTIONS
board-number is the board number as a decimal number. game-string is a string describing the game. Valid strings and their respective games are: bakers_game - Baker's Game (*) bakers_dozen - Baker's Dozen (Broken) (*) beleaguered_castle - Beleaguered Castle (*) citadel - Citadel cruel - Cruel der_katz - Der Katzenschwantz die_schlange - Die Schlange eight_off - Eight Off (*) fan - Fan forecell - Forecell freecell - Freecell (the default) good_measure - Good Measure ko_bakers_game - Kings' Only Baker's Game relaxed_freecell - Relaxed Freecell relaxed_seahaven - Relaxed Seahaven Towers seahaven - Seahaven Towers (*) simple_simon - Simple Simon (*) streets_and_alleys - Streets and Alleys make-aisleriot-freecell-board supports only the games marked with an asterisk (*). SEE ALSO
fc-solve (6) /usr/share/doc/freecell-solver-bin/README.board_gen AUTHOR
Shlomi Fish, <http://www.shlomifish.org/> . board_gen 3.12.0 2012-06-22 HOOLA(6)
All times are GMT -4. The time now is 06:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy