Sponsored Content
Top Forums Shell Programming and Scripting Read a CSV file and generate SQL output Post 302525140 by atul9806 on Wednesday 25th of May 2011 11:04:05 PM
Old 05-26-2011
Hi Ram
You can try this

if ur csv file is like this
Code:
$ cat input.csv
razor,cts
indu,adobe
akash,daksh

u can use this code
Code:
 awk -F',' '{ print "Select * from " $1 " where user=" $2 ";" }' input.csv > output.log

$ cat output.log
Select * from razor where user=cts;
Select * from indu where user=adobe;
Select * from akash where user=daks;

hope it will help

Last edited by Scott; 05-26-2011 at 01:38 AM.. Reason: Code tags
This User Gave Thanks to atul9806 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need help in Parsing a CSV file and generate a new output file

Hi Scripting Gurus, I am trying to parse a csv file and generate a new output file. The input file will be a variable length in turns of rows and columns. output file will have 8 columns. we have three columns from the header for each set. just to give little bit more clarification each row... (15 Replies)
Discussion started by: vkr
15 Replies

2. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

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

3. Shell Programming and Scripting

SQL Script's output to a CSV file

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

4. Shell Programming and Scripting

formatting into CSV format of SQL session output

I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format . The output should be like this 'a','b','c', (4 Replies)
Discussion started by: mady135
4 Replies

5. Shell Programming and Scripting

generate PDF document on UNIX (not with GUI) from SQL*Plus output

Hi I wish to generate from CSV output of SQL*Plus a PDF. I use a Solaris 10 box. Which Open Source software can do that on CLI? (4 Replies)
Discussion started by: slashdotweenie
4 Replies

6. Shell Programming and Scripting

to read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (1 Reply)
Discussion started by: Ram.Math
1 Replies

7. Shell Programming and Scripting

Convert sql output to csv file via bash tools

hi Can anybody help me with converting such structure into csv file for windows : BAT_ID ID_num CVS_LINE A_SEG SKILL_TO A_CUSTOMER_TYPE --------- ---------- --------------------------------- ---------- ------------------ ----------- 14-MAY-11 777752 ... (4 Replies)
Discussion started by: kvok
4 Replies

8. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

9. Shell Programming and Scripting

ksh - Read input from file and output CSV i same row

Hello I have the following output and want the output to look: FROM: GigabitEthernet0/0 is up, line protocol is up 1 input errors, 0 CRC, 0 frame, 1 overrun, 0 ignored 275 output errors, 0 collisions, 3 interface resets GigabitEthernet0/1 is up, line protocol is up 0... (4 Replies)
Discussion started by: JayJay2018
4 Replies

10. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
RAZOR-ADMIN(1p)                                         User Contributed Perl Documentation                                        RAZOR-ADMIN(1p)

NAME
"razor-admin" - Razor Registering Agent SYNOPSIS
razor-admin [options] [ -register | -create | -discover ] DESCRIPTION
"razor-admin" is the Razor Agent that performs administrative functions, most notably registering (-register) USAGE
"razor-admin" must have one of the following arguments: "-register" Registers a new identity, used for authenticating with Razor Nomination Servers. Identities are a user + password pair stored in "<razorhome>/identity-<user>". The first time "razor-admin -register" exits successfully, a symlink "identity" is created to point to the active "identity-<user>" file. After that, new identities can be created, but in order to use them the symlink "identity" must be changed to point to them. In general, it should be called once from the command line. Exits 0 for success, exits 1 on failure with a human-readable output message. Both razor-report(1) and razor-revoke(1) require user authentication to work, razor-check(1) does not. This allows the Razor Nomination Server to keep track of how many messages a user reports and revokes. The more messages a user correctly reports and/or correctly revokes, the more trust the user earns. Likewise, when messages are incorrectly reported or revoked, the trust goes down for that user. Highly trusted users will have the most affect on the Razor database. "-discover" Force discovery. This will create "server.*.lst" files in <razorhome>. "-create" Explicitly creates "razor-agent.conf" file in <razorhome>, as well as <razorhome> if it does not exist. Normally loads "/etc/razor/razor-agent.conf" if it exists, using defaults for anything not found. Does not attempt to register with server, but will do discovery, see "-discover". OPTIONS
"razor-admin" takes following optional arguments: "-h" Print a usage message and exit. "-v" Print the version number and exit. "-d | --verbose" Print debugging information. "-debuglevel=n | -dl=n" Set debug level to 'n'. Default is 3 without "-d" option, 9 with. "-s" Simulate a check. Do everything except talk to the server. "-conf=filename" Specifies an alternate configuration file. If not specified, it is computed, see razor-agents(1) manpage for details. See razor-agent.conf(5) manpage for various configuration options. The default is "<razorhome>/razor-agent.conf". "-home=directory" Specify razorhome directory. This is where the configuration file, logfiles, identities, and server files live. If not specified, it is computed, see razor-agents(1) manpage for details. "-logfile=file" Specify file to log to instead of what is in the configuration file. The default is "<razorhome>/razor-agent.log". "-ident=filename" Specify an identify file to use for storing a newly registered identity. If not specified, "<razorhome>/identity-<user>" is used. "-rs=razor.server.com" Use this Razor Nomination Server instead of reading "servers.nomination.lst". "-user=user@domain.com" Request to be known as this username. Must be less than 64 chars and may contain A-Z, a-z, 0-9, as well printable chars [ex: - _ @ . + / ]. If not specified, a username will be assigned. Razor users are encouraged to use their email addresses as their username. "-pass=password" Request this password. Valid chars are the same as for -user. If not specified, it will be assigned. "-l" The identity created during this "razor-admin" becomes the default. Normally, the first identity file created by "razor-admin" is the default one used. EXAMPLES
razor-admin -d -create With no global razorhome defined (default) in /etc/razor/razor-agents.conf, creates .razor directory in user's home directory. With global razorhome defined in /etc/razor/razor-agents.conf, will try to use that one, will fail if it does not have correct permissions. razor-admin -register Registers a new identity, storing it in <lt>razorhome<gt>. User and pass will be server generated. An identity is required for razor-report(1) and razor-revoke(1). razor-admin -register -user me@a.com Attempts to register a new identity using the user name 'me@a.com'. Will fail if user is already taken. razor-admin -d -create -home=/home/me/.razor Creates .razor directory in user's home directory, which will then be the default home unless specified from cmd-line. Sends debugging information to stdout, and does not talk to any Razor Servers. razor-admin -d -create -home=/etc/razor Creates global razorhome, /etc/razor. This is the magic directory that will be consulted if no razorhome is specified on the cmd-line or found in user's home directory. AUTHORS
Vipul Ved Prakash <mail@vipul.net>, and Chad Norwood <chad@samo.org> SEE ALSO
razor-agents(1), razor-agent.conf(5), razor-check(1), razor-report(1), razor-revoke(1), razor-whitelist(5) LICENSE
This is free software, distributed under the Artistic License 2.0. perl v5.14.2 2008-07-21 RAZOR-ADMIN(1p)
All times are GMT -4. The time now is 11:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy