|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
Not able to write SQL query output in to .csv file with shell script.
Post 303036108 by sandeepgoli53 on Friday 14th of June 2019 08:19:42 AM
06-14-2019
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
Discussion started by: pharos467
8 Replies
2. Shell Programming and Scripting
Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Discussion started by: n2ekhil
0 Replies
3. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
4. Shell Programming and Scripting
I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ?
I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
Discussion started by: Sriranga
4 Replies
5. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
6. Shell Programming and Scripting
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies
7. Shell Programming and Scripting
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies
8. Shell Programming and Scripting
Hi Guys,
I need to write a simple shell script which will generate a .csv file/report by calling .sql file inside a shell script.
Can somebody help me on this.
Thanks in advance!
Regards,
LK (7 Replies)
Discussion started by: lakshmanraok117
7 Replies
9. Shell Programming and Scripting
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
10. Shell Programming and Scripting
I am writing the following script to create the file v_out.txt.
sqlplus -s /nolog << EOF
CONNECT scott/tiger@orcl;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET VERIFY OFF;
SET LINESIZE 100;
set tab off;
set... (7 Replies)
Discussion started by: itzkashi
7 Replies
LEARN ABOUT DEBIAN
gemdropx
GEMDROPX(6) Games Manual GEMDROPX(6) NAME
gemdropx - an interesting one-player puzzle game for X-Window SYNOPSIS
gemdropx [--help] [--version] [--usage] [--nomusic] DESCRIPTION
This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page. Instead, it has documentation in /usr/share/doc/gemdropx/README.txt.gz gemdropx is an interesting one-player puzzle game for X-Window. It is a direct port of Gem Drop, an Atari 8-bit game written in Action! (a very fast C- and Pascal-like compiled language for the Atari). The concept of the game Gem Drop is based on an arcade game for the Neo- Geo system called "Magical Drop III" by SNK. If you're familiar with games like Jewels, Klax, Bust-A-Move or Tetris, this game is similar to them all. I consider it closest to Klax. OPTIONS
--help Show a quick help page. --version Show version of program. --usage Show the command line arguments which gemdropx accepts. --nomusic Disable the music of the game (if sound was enabled during compile time). --nosound Disable all sound (including music). CONTROLS
Left/Right Move left/right K/L Move left/right Up/Down Throw/Grab A/Z Throw/Grab Return Get more gems immediately Space / P Pause S Toggle sound Q/Escape Abort game MOUSE
Click Left/Right of Man Move left/right Left-click Above Man Grab Right-click Above man Throw JOYSTICK
Left/Right Move left/right Button 1/2 Throw/Grab Button 3/4 Get more gems immediately AUTHOR
This manual page was written by Christian T. Steigies <cts@debian.org>, for the Debian GNU/Linux system (but may be used by others). December 29, 1999 GEMDROPX(6)