06-14-2019
Hi RudiC,
Yes i changes column names and used '|' as delimiter.
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 HPUX
priv_str_to_set
priv_str_to_set(3) Library Functions Manual priv_str_to_set(3)
NAME
priv_str_to_set(), priv_set_to_str() - privilege name to set conversion function
SYNOPSIS
Parameters
priv_list The list of privilege names, passed as a string, separated by one or more characters from delimiter. It may also
contain the compound privileges (basic, basicroot, and policy).
delimiter Separates the privileges in priv_list.
index_ptr If an error occurs while parsing the list of privilege names, the pointer pointed to by index_ptr is set to point to
the remainder of the string after the error occurred, so long as index_ptr is not a NULL pointer.
delimiter Separates the individual privilege names by any of the specified characters. If delimiter is a NULL character, the
default delimiter of comma is used.
flag Bit mask with the following bit positions defined: Exactly one of the two flags must be passed. When flag is the
resulting string uses the compound privileges and to arrive at a short representation.
priv_vec Specifies privilege set.
DESCRIPTION
priv_str_to_set Conversion
converts a list of privilege names to a privilege set.
priv_list is a string consisting of privilege names and/or compound privileges. The individual elements in the string are separated by one
or more characters of delimiter .
Any privilege in the list priv_list can be optionally preceded by an exclamation mark to be interpreted as removal. For example, means all
privileges in the compound privilege except the privilege.
The string is case-insensitive. prefix is optional to a privilege name. For example, and all have the same meaning.
priv_list is interpreted left to right, so the string is the same as an empty list of privileges, while is the same as
For a list of valid privileges (both individual privileges and compound privileges), see privileges(5).
priv_set_to_str Conversion
converts a privilege set to a string of privilege names separated by the character specified by delimiter .
RETURN VALUE
and return the following values:
pointer Successful completions. Returns a non-null pointer. The caller of is responsible for freeing the result using the The
caller of is responsible for freeing the result using the
NULL pointer
Function failed. Returns a null pointer and sets to indicate the error .
ERRORS
If any of the following conditions occur, the functions fail and set
Cannot allocate enough memory for the given data.
One or more arguments are invalid.
EXAMPLES
#include <stdio.h>
#include <sys/types.h>
#include <sys/privileges.h>
#define priv_list "PRIV_CHOWN,PRIV_CHROOT,PRIV_DACREAD"
main()
{
char *index;
priv_set_t * priv_vector;
if ( (priv_vector = priv_str_to_set( priv_list,
NULL,
&index)) == NULL )
{
perror("priv_str_to_set Failed");
if (index)
printf("Invalid privilege name starting at %s
", index);
exit(1);
}
printf("The privileges in the given privilege vector are %s
",
priv_set_to_str( priv_vector, NULL, PRIV_STR_SHORT) );
}
DEPENDENCIES
and are both part of the library.
SEE ALSO
privset_free(3), privileges(5).
priv_str_to_set(3)