I have created a shell script that reads line from text file and insert into DB table. I have used IFS to separate the line text. Looks IFS is splitting text properly but while passing one of the values that has special characters in it to query, it is giving weird issue. Below is my script looks like
Below is my text file data
when I run the script, output is coming as below
I really do not understand why it is showing output like this but I investigated and found that this issue is coming due to the parameter COMPANY in the query. It has special characters. If I remove and change to simple text then it is not giving this issue and record is inserting successfully. Please suggest if any solution.
Last edited by vgersh99; 10-30-2018 at 05:29 PM..
Reason: Code tags, please!
Hi,
When i execute the below statement , the value is not getting stored in the variable.
AnneeExercice=`sqlplus $LOGSQL/$PASSWORDSQL << FIN >> $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc
SELECT bi09exercice
FROM bi09_scenario
WHERE bi09idfiliale=UPPER('de')
AND ... (1 Reply)
Unix prompt
=========
echo "Enter the query"
read q
==========
User has entered :
SELECT * FROM employee
=====================
Now the problem starts..
echo $q
Output: SELECT "all files names in the PWD" FROM employee
================================================
... (5 Replies)
Hi,
I am passing an argument for the script and that argument values should exist in database.
bill_period_input="'""$1""'"
bill_period=`sqlplus uname/pwd@dbname <<eof!
set verify off
set heading off
set feedback off
select bill_period from bill_period_ref where... (4 Replies)
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)
Hi Everyone,
Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below
i have defined two Hash %lc and %tab as below
$lc{'REFF'}='V_RES_CLASS';
$lc{'CALE'}='V_CAP_CLASS';
$lc{'XRPD'}='V_XFMR_CLASS';
$tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
I used the following code
code
select * from tablename where columnname
Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem?
Thanks
Ananth (2 Replies)
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)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
I have a postgres sql statement that is the following:
select age from students;
which gives me the entries:
Age
---
10
15
13
12
9
14
10
which is about 7 rows of data.
Now what I would like to do with this is use a shell script to create an array age. As a results... (3 Replies)
Discussion started by: JSNY
3 Replies
LEARN ABOUT PHP
read
read(1) User Commands read(1)NAME
read - read a line from standard input
SYNOPSIS
/usr/bin/read [-r] var...
sh
read name...
csh
set variable = $<
ksh
read [ -prsu [n]] [ name ? prompt] [name...]
DESCRIPTION
/usr/bin/read
The read utility will read a single line from standard input.
By default, unless the -r option is specified, backslash () acts as an escape character. If standard input is a terminal device and the
invoking shell is interactive, read will prompt for a continuation line when:
o The shell reads an input line ending with a backslash, unless the -r option is specified.
o A here-document is not terminated after a NEWLINE character is entered.
The line will be split into fields as in the shell. The first field will be assigned to the first variable var, the second field to the
second variable var, and so forth. If there are fewer var operands specified than there are fields, the leftover fields and their interven-
ing separators will be assigned to the last var. If there are fewer fields than vars, the remaining vars will be set to empty strings.
The setting of variables specified by the var operands will affect the current shell execution environment. If it is called in a subshell
or separate utility execution environment, such as one of the following:
(read foo)
nohup read ...
find . -exec read ... ;
it will not affect the shell variables in the caller's environment.
The standard input must be a text file.
sh
One line is read from the standard input and, using the internal field separator, IFS (normally space or tab), to delimit word boundaries,
the first word is assigned to the first name, the second word to the second name, and so on, with leftover words assigned to the last name.
Lines can be continued using
ewline. Characters other than NEWLINE can be quoted by preceding them with a backslash. These backslashes
are removed before words are assigned to names, and no interpretation is done on the character that follows the backslash. The return code
is 0, unless an end-of-file is encountered.
csh
The notation:
set variable = $<
loads one line of standard input as the value for variable. (See csh(1)).
ksh
The shell input mechanism. One line is read and is broken up into fields using the characters in IFS as separators. The escape character,
(), is used to remove any special meaning for the next character and for line continuation. In raw mode, -r, the character is not
treated specially. The first field is assigned to the first name, the second field to the second name, and so on, with leftover fields
assigned to the last name. The -p option causes the input line to be taken from the input pipe of a process spawned by the shell using |&.
If the -s flag is present, the input will be saved as a command in the history file. The flag -u can be used to specify a one digit file
descriptor unit n to read from. The file descriptor can be opened with the exec special command. The default value of n is 0. If name is
omitted, REPLY is used as the default name. The exit status is 0 unless the input file is not open for reading or an end-of-file is encoun-
tered. An end-of-file with the -p option causes cleanup for this process so that another can be spawned. If the first argument contains a
?, the remainder of this word is used as a prompt on standard error when the shell is interactive. The exit status is 0 unless an end-of-
file is encountered.
OPTIONS
The following option is supported:
-r Does not treat a backslash character in any special way. Considers each backslash to be part of the input line.
OPERANDS
The following operand is supported:
var The name of an existing or non-existing shell variable.
EXAMPLES
Example 1: An example of the read command
The following example for /usr/bin/read prints a file with the first field of each line moved to the end of the line:
example% while read -r xx yy
do
printf "%s %s
" "$yy" "$xx"
done < input_file
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of read: LANG, LC_ALL, LC_CTYPE, LC_MES-
SAGES, and NLSPATH.
IFS Determines the internal field separators used to delimit fields.
PS2 Provides the prompt string that an interactive shell will write to standard error when a line ending with a backslash is read and
the -r option was not specified, or if a here-document is not terminated after a newline character is entered.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 End-of-file was detected or an error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO csh(1), ksh(1), line(1), set(1), sh(1), attributes(5), environ(5), standards(5)SunOS 5.10 28 Mar 1995 read(1)