Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Getting unknown operator error while using a function
Top Forums Shell Programming and Scripting Getting unknown operator error while using a function Post 302995789 by Samah on Wednesday 12th of April 2017 09:45:57 AM
Old 04-12-2017
Getting unknown operator error while using a function
Hi,

I wrote a function for the first time and not able to get the desired result.

I have requirement to execute 10 queries. For this i wrote a function like below.
Code:
function Command {
  typeset var SOL;
  if [ ${1:-0} -ne 0 ]; then CONNECTION="${CONNECTION} -e -time";
  else SOL="`nzsql ${CONNECTION} -c "${1}"`";
  fi;
  echo "${SOL}";
}

CHECK1="$(Command "SELECT COUNT(*) FROM ${DATABASE}..EMPLOYEE WHERE NVL(EMPLOYEE_ID, 0) <= 0;")"
if [ ${?} -ne 0 ] ; then
echo "CHECK1 : ${CHECK1}";
fi;

Above code is throwing an error.
Code:
.[16]: Command[10]: [: COUNT(*): unknown operator

I need to put the check 1 result in a file and need to attach the file to email and send once all the 10 checks performed.

Could any one please tell me what went wrong in this function!?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

:0: unknown test operator

I have gotten the script up to this point and it works fine a system but when i copy it to another unix server running solaris 9 as the original one , its gives an error './mon_fs.sh: 0: unknown test operator' . (see script bellow) can the Gurus see to this as i am just a beginner with... (2 Replies)
Discussion started by: ibroxy
2 Replies

2. UNIX for Advanced & Expert Users

unknown test operator

Hi, I have the following shell script : Nbr_BD_Link=0 Nbr_BD_Link=` sqlplus sysadm/${PSWD}@${DB_Name} << EOF | tail -4 | head -1 2>/dev/null set head off feedback off ; select count(*) from dba_db_links ; exit ; EOF ` echo ${Nbr_BD_Link} if ; then ... (4 Replies)
Discussion started by: big123456
4 Replies

3. Shell Programming and Scripting

test: unknown operator status

hi I get test: unknown operator status if then echo "OK." return 0 else echo "not ok" 2>&1 exit -1 fi I tried to change "A" with 'A' --> same error I tried to change if , I am getting: (3 Replies)
Discussion started by: melanie_pfefer
3 Replies

4. Shell Programming and Scripting

syntax error in shell test: unknown operator

Hi All, can some one figure out the syntax issue here. How to overcome this? #!/bin/sh $ HFR_MAIL=NO $ PRP_MAIL=NO $ MC_MAIL=NO $ if && && ]; then > echo "NO " > else > echo "YES" > fi test: unknown operator NO $ if && && ]; then > echo "NO" > else > echo "YES" >... (4 Replies)
Discussion started by: shellscripter
4 Replies

5. Shell Programming and Scripting

if returns "unknown test operator"

Greetings, using ksh on Solaris, I am trying to identify the current version of a package installed on multiple servers using if statement in a precursor to upgrading. I have searched the forums and have found many hits, reviewed 3 pages and have tried the different variations noted there. Also... (3 Replies)
Discussion started by: 22blaze
3 Replies

6. Shell Programming and Scripting

unknown test operator

hi all, i am using the below command in my script if ; then This statement is causing the problme "ScriptName.ksh: XXX-XXX: unknown test operator" could you please suggest me , how can i avoid these messages. Singhal (7 Replies)
Discussion started by: singhald
7 Replies

7. Shell Programming and Scripting

Unknown error - ``' unmatched

Hi Guys, I get the error while running below commands. Earlier the command used to execute, but after enclosing them in a function, the error is occuring backupPath=`echo $folderName | sed -e 's,/vobs/dte/itgClient/client/RegressionTestLibPostOHS/,,'` check_event=`cat... (7 Replies)
Discussion started by: ajincoep
7 Replies

8. Programming

Help Unknown Syntax Error

Please excuse me if this is an easy fix, for I am new to Unix and C '/problem1.c: line2: syntax error near unexpected token ` '/problem1.c: line2: `main() and for one program it has : command not found2: (above the syntax error) As mentioned this is in C not C++, I have complied all... (3 Replies)
Discussion started by: apolo93
3 Replies

9. Shell Programming and Scripting

Unknown test operator

Hi , Os - Solaris Shell - Ksh I am getting below error in if condition + id + ./om_wf_complete.sh: gid=4081(Infadmn): unknown test operator + exit 1 if ; then touch /home/odwt/1.0.0/out/oworkflow.dat chmod 777 /home/odwt/1.0.0/out/oworkflow.dat elif ; then touch... (8 Replies)
Discussion started by: nag_sathi
8 Replies

10. Shell Programming and Scripting

Unknown test operator

O/S solaris 9 shell ksh if then chk_op="WARNING...reboot within the last 24hrs, restarted at `who -r | awk '{print $4$5"@"$6}'`" ; else if ; then last_reboot1=`who -b | awk '{print $4" "$5" "$6}'` last_reboot2='..OK..'`uptime | awk '{print$3" "$4}'` ... (4 Replies)
Discussion started by: squrcles
4 Replies

LEARN ABOUT OSX

libipmiconsole

libipmiconsole(3)						  System Commands						 libipmiconsole(3)

NAME

       libipmiconsole - IPMI SOL library

SYNOPSIS

       #include <ipmiconsole.h>

       int ipmiconsole_engine_init(unsigned int thread_count, unsigned int debug_flags);

       int ipmiconsole_engine_submit(ipmiconsole_ctx_t c, Ipmiconsole_callback callback, void *callback_arg);

       int ipmiconsole_engine_submit_block(ipmiconsole_ctx_t c);

       void ipmiconsole_engine_teardown(int cleanup_sol_sessions);

       ipmiconsole_ctx_t  ipmiconsole_ctx_create(char  *hostname,  struct ipmiconsole_ipmi_config *ipmi_config, struct ipmiconsole_protocol_config
       *protocol_config);

       int ipmiconsole_ctx_errnum(ipmiconsole_ctx_t c);

       char *ipmiconsole_ctx_strerror(int errnum);

       ipmiconsole_ctx_status_t ipmiconsole_ctx_status(ipmiconsole_ctx_t c);

       int ipmiconsole_ctx_fd(ipmiconsole_ctx_t c);

       int ipmiconsole_ctx_generate_break(ipmiconsole_ctx_t c);

       int ipmiconsole_ctx_destroy(ipmiconsole_ctx_t c);

DESCRIPTION

       Libipmiconsole implements a high level serial-over-lan (SOL) API for remote console access. It can be used to establish and manage multiple
       IPMI  2.0 SOL sessions. The goal of this library is to abstract away all of the underlying IPMI/SOL details away from the user into a rela-
       tively simple file descriptor interface.

FILES

       /usr/include/ipmiconsole.h

REPORTING BUGS

       Report bugs to <freeipmi-users@gnu.org> or <freeipmi-devel@gnu.org>.

COPYRIGHT

       Copyright (C) 2007-2012 Lawrence Livermore National Security, LLC.
       Copyright (C) 2006-2007 The Regents of the University of California.

       This library is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as  published	by
       the Free Software Foundation; either version 3 of the License, or (at your option) any later version.

SEE ALSO

       ipmiconsole(8)

       http://www.gnu.org/software/freeipmi/

libipmiconsole 1.1.5						    2012-06-15							 libipmiconsole(3)
All times are GMT -4. The time now is 10:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy