Convert sql output to csv file via bash tools Post: 302536383

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script to convert CSV to SQL

I am trying to write a script to convert csv files into SQL format. What I am missing is: 1. handling of the first row and create it as a insert into format 2. better handling of any other row, and create a line with the data. *The while read line needs a better work. I thought of using awk. ...

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

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

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

6. Shell Programming and Scripting

Read a CSV file and generate SQL output

7. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ...

8. Shell Programming and Scripting

Convert sql file to csv file

How to convert name.sql file into name.csv file. Basically my input source file is .sql file, I need to verify data after the import of that exported sql file. Thanks for any help.

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

LEARN ABOUT SUNOS

ddi_dma_numwin

ddi_dma_numwin(9F)					   Kernel Functions for Drivers 					ddi_dma_numwin(9F)

NAME

       ddi_dma_numwin - retrieve number of DMA windows

SYNOPSIS

       #include <sys/ddi.h>
       #include <sys/sunddi.h>

       int ddi_dma_numwin(ddi_dma_handle_t handle, uint_t *nwinp);

PARAMETERS

       handle	       The  DMA handle previously allocated by a call to  ddi_dma_alloc_handle(9F).

       nwinp	       Upon a successful return,  nwinp will contain the number of  DMA windows for this object.

INTERFACE LEVEL

       Solaris DDI specific (Solaris DDI).

DESCRIPTION

       ddi_dma_numwin() returns the number of  DMA windows for a  DMA object if partial resource allocation was permitted.

RETURN VALUES

       ddi_dma_numwin() returns:

       DDI_SUCCESS	       Successfully filled in the number of  DMA windows.

       DDI_FAILURE	       DMA windows are not activated.

CONTEXT

       ddi_dma_numwin() can be called from user, kernel, or interrupt context.

SEE ALSO

       ddi_dma_addr_bind_handle(9F), ddi_dma_alloc_handle(9F), ddi_dma_buf_bind_handle(9F), ddi_dma_unbind_handle(9F)

       Writing Device Drivers

SunOS 5.10							    29 Sep 1994 						ddi_dma_numwin(9F)