Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: error in insert statement
Top Forums Shell Programming and Scripting error in insert statement Post 302265579 by ragavhere on Monday 8th of December 2008 02:16:56 AM
Old 12-08-2008
error in insert statement
hi,

When i try to run the code below, i get the following error

"ksh: syntax error: `(' unexpected"

i am not able to figure it out. Can anyone help me?

Code:
Quote:
ERROR_CD=$1
PARAM_PASSED=$#
CUR_YEAR=`date | awk '{print$6}'`
CUR_MONTH=`date +%m`
CUR_DAY=`date +%d`
CUR_TIME=`date | awk '{print$4}' | sed -e 's/:/./g'`
TODAY_DATE=`echo $CUR_YEAR-$CUR_MONTH-$CUR_DAY-$CUR_TIME.00`
if [ $PARAM_PASSED = 1 ]; then
if [ $ERROR_CD = 01 ]; then
db2 connect to databasename user <username> using <password>
insert into <tablename> (col1,col2,col3,col4,col5,col6) values('$TODAY_DATE','$ERROR_CD','Val1','Val2','VAl3','Val4');
terminate
elif [ $ERROR_CD = 02 ]; then
db2 connect to databasename user <username> using <password>
insert into <tablename> (col1,col2,col3,col4,col5,col6) values('$TODAY_DATE','$ERROR_CD','Val1','Val2','VAl3','Val4');
terminate
elif [ $ERROR_CD = 03 ]; then
db2 connect to databasename user <username> using <password>
insert into <tablename> (col1,col2,col3,col4,col5,col6) values('$TODAY_DATE','$ERROR_CD','Val1','Val2','VAl3','Val4');
terminate
fi
else
exit
fi
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk command for INSERT statement

Hi, I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this: INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL, PROPERTYNR) VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70) I... (4 Replies)
Discussion started by: nattynatty
4 Replies

2. Shell Programming and Scripting

Insert TAB in echo statement

Hi, Can some1 help me to output a tab in an echo statement. I have tried echo "RNC: \t NODEB" but dont get the correct output. I am a beginnger to unix, so pls hold back the laughs....if u can (5 Replies)
Discussion started by: sunils27
5 Replies

3. Shell Programming and Scripting

Script does not execute Insert Statement

Hi I have a text file , contents are Line1:field1,field2,field3,field4,field5,field6.......field20 Line2:field1,field2,field3,field4,field5,field6.......field20 Line3:field1,field2,field3,field4,field5,field6.......field20 ....and so on... I want to read this file and insert the data into... (4 Replies)
Discussion started by: Amruta Pitkar
4 Replies

4. Shell Programming and Scripting

How is use sselect statement o/p in insert statement.

Hi All, I am using Unix ksh script. I need to insert values to a table using the o/p from a slelect statement. Can anybody Help! My script looks like tihs. ---`sqlplus -s username/password@SID << EOF set heading off set feedback off set pages 0 insert into ${TB_NAME}_D... (2 Replies)
Discussion started by: nkosaraju
2 Replies

5. Programming

Dynamic Insert statement

I have a form , where i will put the values to a table. I wrote a insert statement for the same. Table structure is ename | character varying(30) | eadd | character varying(30) | eid | integer | sal | integer In the statements, i don't... (1 Reply)
Discussion started by: pritish.sas
1 Replies

6. Programming

Assign variable for INSERT INTO statement

Hello, Can anyone tell me that, How can I assign variable to shell script variable, which i need to use in INSERT INTO statement? my shell script variables are, EMPNAME=`regular expression` EMPID=`regular expression` EMPBDATE=`regular expression` Now through ksh script I am... (16 Replies)
Discussion started by: Poonamol
16 Replies

7. Shell Programming and Scripting

How to insert numbers to a in between statement

Hi Guys, I want to create a shell script that will give me the output below. I want to insert the numbers from the input file to my url addresses below. And from the numbers below, I want to separate the last digit with a period (i.e. from 222222222222 to 22222222222.2). Appreciate any help.... (14 Replies)
Discussion started by: pinpe
14 Replies

8. Shell Programming and Scripting

How to insert date in a statement?

Hi Guys, Can somebody help me in inserting today's DATE format (20110709) in my awk statement. I have a script but its not working. inputfile.txt: 269,1,0,AAA,430 231,2,0,BBB,430 252,3,0,CCC,430 214,4,0,DDD,430 script.sh #!/bin/bash DATE="`date +%Y%m%d`" cd /var/opt/ (8 Replies)
Discussion started by: pinpe
8 Replies

9. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies

10. Shell Programming and Scripting

Single quotes insert statement using awk

Hi, Need help, using awk command to insert statement awk -v q="'" '{ print "db2 connect to repolab > /dev/null; " "\n" "db2 -x \" select name from IBMPDQ.PROFILE where managed_database = " q $1"_"$3"__0" q "\"" } ' profile.txt | sh - | awk -v i="'" ' { print "db2 connect to repolab >... (1 Reply)
Discussion started by: Mathew_paul
1 Replies

LEARN ABOUT SUSE

gtk2::treestore

Gtk2::TreeStore(3)					User Contributed Perl Documentation					Gtk2::TreeStore(3)

NAME

       Gtk2::TreeStore

HIERARCHY

	 Glib::Object
	 +----Gtk2::TreeStore

INTERFACES

	 Gtk2::TreeModel
	 Gtk2::TreeDragSource
	 Gtk2::TreeDragDest
	 Gtk2::TreeSortable
	 Gtk2::Buildable

METHODS

   treestore = Gtk2::TreeStore->new (...)
       o   ... (list) of strings, package names

   treeiter = $tree_store->append ($parent)
       o   $parent (Gtk2::TreeIter or undef)

   $tree_store->clear
   $tree_store->set_column_types (...)
       o   ... (list) of strings, package names

   $tree_store->set ($iter, $col1, $val1, ...)
       o   $iter (Gtk2::TreeIter)

       o   $col1 (integer) the first column number

       o   $val1 (scalar) the first value

       o   ... (list) pairs of columns and values

   treeiter = $tree_store->insert ($parent, $position)
       o   $parent (Gtk2::TreeIter or undef)

       o   $position (integer)

   treeiter = $tree_store->insert_after ($parent, $sibling)
       o   $parent (Gtk2::TreeIter or undef)

       o   $sibling (Gtk2::TreeIter or undef)

   treeiter = $tree_store->insert_before ($parent, $sibling)
       o   $parent (Gtk2::TreeIter or undef)

       o   $sibling (Gtk2::TreeIter or undef)

   treeiter = $tree_store->insert_with_values ($parent, $position, ...)
       o   $parent (Gtk2::TreeIter or undef)

       o   $position (integer) position to insert the new row

       o   ... (list) pairs of column numbers and values

       Like doing insert followed by set, except that insert_with_values emits only the row-inserted signal, rather than row-inserted, row-
       changed, and, if the store is sorted, rows-reordered as in the multiple-operation case.	Since emitting the rows-reordered signal
       repeatedly can affect the performance of the program, insert_with_values should generally be preferred when inserting rows in a sorted tree
       store.

       Since: gtk+ 2.10

   boolean = $tree_store->is_ancestor ($iter, $descendant)
       o   $iter (Gtk2::TreeIter)

       o   $descendant (Gtk2::TreeIter)

   integer = $tree_store->iter_depth ($iter)
       o   $iter (Gtk2::TreeIter)

   boolean = $tree_store->iter_is_valid ($iter)
       o   $iter (Gtk2::TreeIter)

       Since: gtk+ 2.2

   $tree_store->move_after ($iter, $position)
       o   $iter (Gtk2::TreeIter)

       o   $position (Gtk2::TreeIter or undef)

       Since: gtk+ 2.2

   $tree_store->move_before ($iter, $position)
       o   $iter (Gtk2::TreeIter)

       o   $position (Gtk2::TreeIter or undef)

       Since: gtk+ 2.2

   treeiter = $tree_store->prepend ($parent)
       o   $parent (Gtk2::TreeIter or undef)

   boolean = $tree_store->remove ($iter)
       o   $iter (Gtk2::TreeIter)

   $tree_store->reorder ($parent, ...)
       o   $parent (Gtk2::TreeIter or undef)

       o   ... (list) of integer's, the new_order

       Since: gtk+ 2.2

   $tree_store->swap ($a, $b)
       o   $a (Gtk2::TreeIter)

       o   $b (Gtk2::TreeIter)

       Since: gtk+ 2.2

   $tree_store->set_value ($iter, $col1, $val1, ...)
       o   $iter (Gtk2::TreeIter)

       o   $col1 (integer) the first column number

       o   $val1 (scalar) the first value

       o   ... (list) pairs of columns and values

       Alias for Gtk2::TreeStore::set().

SEE ALSO

       Gtk2, Glib::Object

COPYRIGHT

       Copyright (C) 2003-2008 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.12.1							    2010-07-05							Gtk2::TreeStore(3)
All times are GMT -4. The time now is 08:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy