it's quite a long piece of code. I've used the awk commands in ksh. Tried with (for i=2..) but in vain...
set -x gave me the following output..
writer_reader is the name of the function where this command is used. I've put only a part of the console o/p above (the one that concerns the error).
---------- Post updated at 01:45 PM ---------- Previous update was at 10:59 AM ----------
what does the number in the [] bracket indicate exactly? It is not the line number, of that i am sure. Then what is it and how do i identify the location of the error?
Hi All,
When i run the below code :
v_shortfield = ""
if ; then
echo "ravi"
else
echo "kumar"
fi
i am getting output as :
sam.ksh: test: argument expected
kumar
Why i am getting error test:argument expected
and why i am not getting output as "ravi" :confused: (5 Replies)
I am trying to compare two integer variables in the if statement, but i am getting this "test:argument expected".
What am i missing?
Why is the if loop not executing correctly?
trunkPCM="100000";
more $FILE |while read line
do
PCM=`echo $line | awk '{ print $2 }'`
... (4 Replies)
Hi,
No need to say I'm new to unix shell scripting.
I have a very simple script that goes this way:
for datos in `ls -rt $UNXLOG/26-Jan*`
do
export arch=`echo $datos |cut -d, -f1`
if
then
export linea1=`grep Debut ${arch}`
export horatot=`echo $linea1 |cut -d' ' -f5`
... (7 Replies)
# to search a file if it exists and whether its readable or not
# if yes print its first 5 lines
echo enter the filename to be searched
read fname
if #-d $fname
then
echo file doesn exists
elif
then
echo its a directory
elif
then
cat $fname
else
echo its not readable
fi
# end of... (9 Replies)
Hi,
I having trouble with a test numeric value.
Here is my code :
nb_wanted=$(cat ${type_proto} | grep "#nbr_#branche#" | grep $branche | awk '{print $3}')
if ;
then
nb_ready=$(cat ${fic_tmp_listeSTAF} | wc -l)
... (2 Replies)
Hello all,
I am trying to figure out why i am getting an error while executing the script...altought it seems like its work...but still get the test arguement error...any help would be appericiate...this script basically connects to any oracle db ( just have to pass db name to it)... (4 Replies)
Hi All,
I am running the script
VBoxManage list vms |sed 's/"//g' | cut -d " " -f1 > har1out.mytxt
result=`cat har1out.mytxt | grep $1'
echo $result
echo $1
{
if
then
echo pass
else
echo fail
fi (2 Replies)
check_build_info_table()
{
if
then
export build_info_table=`sqlplus -s sna/dbmanager <<!
set pagesize 0 heading off feedback off
SELECT DISTINCT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'XYZ' AND TABLE_NAME = 'MY_TABLE';
exit
!`
... (3 Replies)
Hi,
I am trying to write a small script that validates if there exist files that start with a pattern in a given directory. Below is the piece of my script:
#!/usr/bin/ksh
BTFDIR=/opt/ships/temp
if
then
echo 'found'
else
echo 'not found'
fi
When I run this... (2 Replies)
I want to make a script that check for the argument passed to it and generates an error in case any character/string argument passed to it.
I am using below code, but its not working. can anyone help.
#!/bin/bash
if ]; then
echo 'An integer argument is passed to the script hence... (3 Replies)
Discussion started by: mukulverma2408
3 Replies
LEARN ABOUT SUSE
drop_operator
DROP OPERATOR(7) SQL Commands DROP OPERATOR(7)NAME
DROP OPERATOR - remove an operator
SYNOPSIS
DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]
DESCRIPTION
DROP OPERATOR drops an existing operator from the database system. To execute this command you must be the owner of the operator.
PARAMETERS
IF EXISTS
Do not throw an error if the operator does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of an existing operator.
lefttype
The data type of the operator's left operand; write NONE if the operator has no left operand.
righttype
The data type of the operator's right operand; write NONE if the operator has no right operand.
CASCADE
Automatically drop objects that depend on the operator.
RESTRICT
Refuse to drop the operator if any objects depend on it. This is the default.
EXAMPLES
Remove the power operator a^b for type integer:
DROP OPERATOR ^ (integer, integer);
Remove the left unary bitwise complement operator ~b for type bit:
DROP OPERATOR ~ (none, bit);
Remove the right unary factorial operator x! for type bigint:
DROP OPERATOR ! (bigint, none);
COMPATIBILITY
There is no DROP OPERATOR statement in the SQL standard.
SEE ALSO
CREATE OPERATOR [create_operator(7)], ALTER OPERATOR [alter_operator(7)]
SQL - Language Statements 2010-05-14 DROP OPERATOR(7)