Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Error- test: argument expected
Top Forums Shell Programming and Scripting Error- test: argument expected Post 302601542 by ambarginni on Friday 24th of February 2012 01:08:10 AM
Old 02-24-2012
Power Error- test: argument expected
Code:
check_build_info_table()
{
        if [ $DB_SYSTEM = "ORACLE" ]
    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
        !`        
    elif [ $DB_SYSTEM = "MYSQL" ]
    then
            export  build_info_table=$(db_query.pl " select distinct TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='XYZ' and TABLE_NAME='MY_TABLE';")
        echo "test1"
        echo"$build_info_table"
        fi

        if [ -z "$build_info_table"]
        then
          echo "test2"
          if [ $DB_SYSTEM = "ORACLE" ]
          then
              sqlplus -s xyz/mypassword <<!
              CREATE TABLE MY_TABLE(RELEASEID VARCHAR(15) NOT NULL,COMPONENT VARCHAR(10) NOT NULL,BUILD VARCHAR(20) NOT NULL,BUILD_TIME   VARCHAR(20) NOT NULL,INSTALL_TIME VARCHAR(20) NOT NULL);

              INSERT INTO XYZ.MY_TABLE(COMPONENT,BUILD,BUILD_TIME,INSTALL_TIME) VALUES ('SNA',EMLR9501_136A,now(),now());

          commit;    
          exit
!
          elif [ $DB_SYSTEM = "MYSQL" ]
          then
          mysql --user=${OSMDB_USR} --password=${OSMDB_PWD} ${DB_NAME} <<!
              SET storage_engine=INNODB;

          CREATE TABLE MY_TABLE(RELEASEID VARCHAR(15) NOT NULL,COMPONENT VARCHAR(10) NOT NULL,BUILD VARCHAR(20) NOT NULL,BUILD_TIME   VARCHAR(20) NOT NULL,INSTALL_TIME VARCHAR(20) NOT NULL);

              INSERT INTO SNA.MY_TABLE(COMPONENT,BUILD,BUILD_TIME,INSTALL_TIME) VALUES ('SNA',EMLR9501_136A,now(),now());

          commit;
          exit
!
              fi
fi
}


Script Output
Code:
The DB is MYSQL
test1

check_build_info_table: test: argument expected
DBD::mysql::st execute failed:

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Facing test: argument expected 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)
Discussion started by: rkrgarlapati
5 Replies

2. Shell Programming and Scripting

ERROR-> test: argument expected , what does it mean?

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)
Discussion started by: tan102938
4 Replies

3. UNIX for Dummies Questions & Answers

test:argument expected

Hi all, I am getting "test:argument expected" error in the following script LOGDIR=$XXAR_TOP/log PROGRAM_NAME=XXAR_GPS_LBFDMSGEN .. .. .. Check_Errors() { sqllogfile=$1 cd ${LOGDIR} countfile=${LOGDIR}/${PROGRAM_NAME}.tmp echo "countfile is " $countfile >> $LOGFILE echo... (4 Replies)
Discussion started by: rrs
4 Replies

4. Shell Programming and Scripting

test: argument expected

Can someone help me with a very simple query I have the following script: #!/bin/sh VAR1="" if then VAR1="Message" fi echo $VAR1 put when i run it i get the following error test_job.sh: test: argument expected (5 Replies)
Discussion started by: andy202
5 Replies

5. Shell Programming and Scripting

test: argument expected

I'm newbie to coding script so i found test: argument expected when i run it. please help me a=`df -k |awk '{print $5 }'|egrep "(100%|%)"|cut -d"%" -f1|tail -1` if then df -k|egrep "(100%|%)"|awk '{print $1,$5,$6}' else echo "No disk capacity more than 80%" fi thk in advance (7 Replies)
Discussion started by: unitipon
7 Replies

6. Shell Programming and Scripting

Test: argument expected.

Hi, Since i am new to Unix and on suggestion on some smart guys on unix... i have decide to learn more deeply on Unix...so i was kind of playing with if statements and found this error... though i tried to correct is for hours now i couldnt find whats wrong in my loop. if then ... (4 Replies)
Discussion started by: bhagya2340
4 Replies

7. Shell Programming and Scripting

error : test: argument expected

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)
Discussion started by: abdul.irfan2
4 Replies

8. UNIX for Advanced & Expert Users

Error:--test: argument expected--Even though i give an argument.

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)
Discussion started by: harsha85
2 Replies

9. UNIX for Dummies Questions & Answers

Test: argument expected error in shell script

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)
Discussion started by: snvniranjanrao
2 Replies

10. Shell Programming and Scripting

Test: argument expected

The following example prompts are passed into the shell script. $1 = /tmp/dir/ $2 = varies (test.txt, test1.txt, test2.txt...) $3 = test_YYYYMMDD.txt --------------------------------------------------------------------------- #!/bin/sh cd $1 if ; then if ; then ... (3 Replies)
Discussion started by: smkremer
3 Replies

LEARN ABOUT CENTOS

paps

PAPS(1) 						      General Commands Manual							   PAPS(1)

NAME

       paps - UTF-8 to PostScript converter using Pango

SYNOPSIS

       paps [options] files...

DESCRIPTION

       paps reads a UTF-8 encoded file and generates a PostScript language rendering of the file. The rendering is done by creating outline curves
       through the pango ft2 backend.

OPTIONS

       These programs follow the usual GNU command line syntax, with long options starting with  two  dashes  (`-').   A  summary  of  options	is
       included below.

       --landscape
	      Landscape output. Default is portrait.

       --columns=cl
	      Number of columns output. Default is 1.

       --font=desc
	      Set the font description. Default is Monospace 12.

       --rtl  Do rtl layout.

       --paper ps
	      Choose paper size. Known paper sizes are legal, letter, a4. Default is A4.

       --bottom-margin=bm
	      Set bottom margin in postscript points (1/72 inch). Default is 36.

       --top-margin=tm
	      Set top margin. Default is 36.

       --left-margin=lm
	      Set left margin. Default is 36.

       --right-margin=rm
	      Set right margin. Default is 36.

       --help Show summary of options.

       --header
	      Draw page header for each page.

       --markup
	      Interpret the text as pango markup.

       --encoding=ENCODING
	      Assume the documentation encoding is ENCODING.

       --lpi  Set the lines per inch. This determines the line spacing.

       --cpi  Set the characters per inch. This is an alternative method of specifying the font size.

       --stretch-chars
	      Indicates  that  characters  should be stretched in the y-direction to fill up their vertical space. This is similar to the texttops
	      behaviour.

AUTHOR

       paps was written by Dov Grobgeld <dov.grobgeld@gmail.com>.

       This manual page was written by Lior Kaplan <kaplan@debian.org>, for the Debian project (but may be used by others).

								  April  17, 2006							   PAPS(1)
All times are GMT -4. The time now is 10:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy