In my code this condition is not working. not sure my syntax is wrong. any inputs please.
Syntax chek :
cat shell.sh
#!/bin/sh
while IFS='[,]' read locationinp sales; do
location_id=`echo $locationinp | cut -d' ' -f2`
sqlplus -S /NOLOG << EOF
CONNECT xxxx/password@xxxxdbt
set echo off
set heading off
set feedback off
set pagesize 0
CONNECT xxxx/password@xxxxdbt
SET head off
select count(*) into :loc_count from location_count where location_id='$location_id' and sales=$sales; if [[ $loc_count > 1]]; then
delete from location_count where location_id='$location_id' and sales=$sales;
exit
EOF
done < queryout.txt
Hello Arun,
I think you need to close the if condition properly as follows.
Hope this helps.
Thanks,
R. Singh
Last edited by RavinderSingh13; 07-29-2015 at 06:00 AM..
Reason: Added quote section now
Here is my test.in file
Case Modify 10001 20002 30003 40004|Report Create 3417176211|Case Modify 10002 20002 30003 40004|
Script:
Remove.ksh
This script to remove $1 which I type in:
$ cat test.in
Case Modify 10001 20002 30003 40004|Report Create 3417176211|Case Modify 10002 20002 30003... (0 Replies)
Hi
I am trying to create a modify a txt file via a sh script and I'm not sure how to do it.
I have this:
data1a#data2a#data3aµ data1b#data2b#data3bµ data1c#data2c#data3cµ
and I want to have this (more or less)
data1a data2a data3a
data1b data2b data3b
data1c data2c data3c
I know... (5 Replies)
Hi all, I have a basic doubt. Is there any way to use external
functions (i.e. functions not defined in AWK), in AWK.
I have a shell script in which I'm using a AWK snippet. In this
snippet I'm calling a function defined in the shell script. But the AWK
snippet is not working. I figured that... (5 Replies)
Hello,
Can someone pls help me with some statistical calculation in awk
In excel there is a statistical function called "Mode".
How Mode works:
MODE returns the most frequently occurring, or repetitive, value in array or range.
Eg if we have 5 numbers in 5 different columns... (12 Replies)
Actually I got a list of file end with *.txt
I want to use the same command apply to all the *.txt
Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics.
For example:
I got the file below:
file1.txt
file2.txt
file3.txt... (4 Replies)
Hi, I would like to know what is the correct syntax to perform a function in awk. Although I have seen several examples, not get it to work, this is what I'm trying:
#!/bin/bash
awk
function multi (number) {
return number * 3
}
print multi (4)Thanks (2 Replies)
Hi,
I have file with below format and sample data - File is pipe delimited
Col1|col2|Account|Bal1|Bal2
1|2|1|10|5
1|2|2|10|2
1|3|3|10|3
I want output as
SUM|1|2|2|20|7
SUM|1|3|1|10|3
Can anyone give me awk command (4 Replies)
Hi all,
I need to have informations in a URL :
https://www.autolib.eu/stations/
Valors I need are in bold:
{"charging_status": "nonexistent", "rental_status": "future", "subscription_status": "nonexistent", "station_id": 791, "address": "10 rue de Rome, 93110 Rosny-sous-Bois", "lat":... (3 Replies)
Hello Friends,
I have written a script like below,
I aimed to move some CDR files (call data record) whose the last field is "1" (NF=1 ) from a spesific directory to a new directory
Field Seperator is pipe.
If the directory does not exitst i should create it.
I will give the script two... (5 Replies)
Hi,
I am having script which contains many functions. Need to print each function name at the starting of the function. Like below,
functionname()
{
echo "functionname"
commands....
}
I've tried like below,
func=`grep "()" scriptname | cut -d "(" -f1`
for i in $func
do
nawk -v... (4 Replies)
Discussion started by: Sumanthsv
4 Replies
LEARN ABOUT HPUX
create_object
create object(1m) create object(1m)NAME
create object - Creates an object entry
SYNOPSIS
cdscp create object object-name [CDS_Class = class-name CDS_ClassVersion = value]
ARGUMENTS
The full name of the object entry. The class of object entry being created. You can specify an application-defined class name. A class is
specified as a simple name limited to 31 characters. The version of the class assigned to the object entry. Specify the value as v.n,
where v defines the major release number and n specifies the minor version number. Specifying a class version is useful as it allows the
definition of a class to evolve as the application is revised.
DESCRIPTION
The create object command creates an object entry. This task is usually done through a client application.
Privilege Required
You must have insert permission to the parent directory.
NOTE
This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.
EXAMPLE
The following command creates an object entry named /.:/sales/east/floor1cp. The object entry describes a color printer on the first floor
of a company's eastern sales office. cdscp> create object /.:/sales/east/floor1cp CDS_Class = printer CDS_ClassVersion = 1.0
RELATED INFORMATION
Commands: delete object(1m), list object(1m), set object(1m), show object(1m)
create object(1m)