|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Dynamic update loop query on Sybase database
Post 302150334 by Alaeddin on Tuesday 11th of December 2007 03:26:51 AM
12-11-2007
Thanks Johan, but i'm planning to use perl as a Plan B, if i totally screwed up with Shell. "I'll revert to you on this as well once testing".
Hey Vicky
,
Thanks for your response, i want to clear out these points:
1) What is $TempFile1 for, cause once i execute the script, i got this error
"./test3.sh: $TempFile1: ambiguous redirect".
2) Regarding the query, i want to do a loop on update, so teh loop will be shell script on DB update query, so shall i make while or for loop before the bracket, and then inculde the update query in-between !!!
Below is my code that is what i'v written:
#=======================================================
# Get the Connection String for isql
#=======================================================
SERVER=127.0.0.1
SYBASE_USERNAME=sa
DATABASE=mmsdb
SYBASE_PASSWORD=test
connection_str="-S $SERVER -U $SYBASE_USERNAME -D $DATABASE"
isql $connection_str <<EOF | egrep -v "Password:" > $TempFile1
$SYBASE_PASSWORD
{
#"Please write your Sybase query in between this middle bracket."
Insert into TEST values (3,"Test","TestDesc")
go
}
go
EOF
Hey Vicky
,Thanks for your response, i want to clear out these points:
1) What is $TempFile1 for, cause once i execute the script, i got this error
"./test3.sh: $TempFile1: ambiguous redirect".
2) Regarding the query, i want to do a loop on update, so teh loop will be shell script on DB update query, so shall i make while or for loop before the bracket, and then inculde the update query in-between !!!
Below is my code that is what i'v written:
#=======================================================
# Get the Connection String for isql
#=======================================================
SERVER=127.0.0.1
SYBASE_USERNAME=sa
DATABASE=mmsdb
SYBASE_PASSWORD=test
connection_str="-S $SERVER -U $SYBASE_USERNAME -D $DATABASE"
isql $connection_str <<EOF | egrep -v "Password:" > $TempFile1
$SYBASE_PASSWORD
{
#"Please write your Sybase query in between this middle bracket."
Insert into TEST values (3,"Test","TestDesc")
go
}
go
EOF
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone please give me a script or let me know how to connect to a sybase database and execute a query using Korn shell scripts.Am new to Unix but i need to do this ASAP.
Please help.
Thanks,
Gops (7 Replies)
Discussion started by: bhgopi
7 Replies
2. Shell Programming and Scripting
Hello Guys,
Well, using shell script, I'm doing loop on DB query as below:
isql -Usa -Ptest -I /opt/sybase/interfaces << EOF
use testdb
go
declare @i int
select @i = 1
while(@i <= 5)
begin
Insert into TEST values (@i,"Test","TestDesc")
select @i = @i + 1
end
go
EOF
The Issue... (2 Replies)
Discussion started by: Alaeddin
2 Replies
3. Programming
Hello,
I have three tables.
I need an SQL query (preferably Sybase) that will return all of the stringID values of table B where the following conditions exist:
(1) B.intID = A.intID
(2) B.intID != C.intID
or (B.intID = C.intID and
(C.v1 = 0 or C.v2... (2 Replies)
Discussion started by: chatieremerrill
2 Replies
4. Windows & DOS: Issues & Discussions
hi,
I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys.
The database is running on solaris 10.
I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Discussion started by: danin
3 Replies
5. Shell Programming and Scripting
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies
6. Shell Programming and Scripting
REINDEXING A DATABASE
Hello,
I have a database which in fact is a personal dictionary of a special kind to handle name homophones The structure is as follows:
a=b=c=d=e=f
This structure is an instruction to the program that whenever it encounters such a set of correlations it should treat them... (2 Replies)
Discussion started by: gimley
2 Replies
7. Programming
Team
I am using DBartisan tool for sybase database.
I have a table that has below fields Employee_ID,EMP_Name,First_Nm,Last_Nm,Emp_Designation,Employee's_Manager
is it possible to retrieve hierarchical data based on below fields
Emp_Designation will have Soft Engg,SSE,Team Lead,... (6 Replies)
Discussion started by: Perlbaby
6 Replies
8. Programming
Hi Team ,
I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column.
SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS
It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Discussion started by: Perlbaby
2 Replies
9. Programming
Dear Team
Please provide suggestion on below query which is used in Sybase Adaptive Server Enterprise/15.7 (ASE).
Query takes more time > 30 Mins to 1 Hr
All required indexes are built
Can we have any efficient approach to get the data retrieval faster for below query.Any help... (0 Replies)
Discussion started by: Perlbaby
0 Replies
10. Shell Programming and Scripting
Im trying to update an informix database table for each occurance of a head_barcode in a file called mw within a for loop
please see below - cant get the syntax correct. any help please?
for a in `cat /tmp/mw`
do
sql image - << STOP > /dev/null 2>&1
update doc_table set status =... (4 Replies)
Discussion started by: worky
4 Replies
LEARN ABOUT NETBSD
util
UTIL(3) BSD Library Functions Manual UTIL(3) NAME
util, libutil -- system utilities library LIBRARY
System Utilities Library (libutil, -lutil) DESCRIPTION
The util library is the system utilities library and contains various system-dependent utility routines used in a wide variety of system dae- mons. The abstracted functions are mostly related to pseudo-terminals and login accounting. These routines are NetBSD-specific and are not portable. Their use should be restricted. Declarations for these functions may be obtained from the include file <util.h>. The util library and the associated functions are imple- mented within the /usr/src/lib/libutil directory. LIST OF FUNCTIONS
Name Description disklabel_dkcksum(3) compute the checksum for a disklabel disklabel_scan(3) scan a buffer for a valid disklabel forkpty(3) tty utility function getbootfile(3) get the name of the booted kernel file getlabeloffset(3) get the sector number and offset of the disklabel getlabelsector(3) get the sector number and offset of the disklabel getmaxpartitions(3) get the maximum number of partitions allowed per disk getrawpartition(3) get the system ``raw'' partition login(3) login utility function login_cap(3) query login.conf database about a user class login_close(3) query login.conf database about a user class login_getcapbool(3) query login.conf database about a user class login_getcapnum(3) query login.conf database about a user class login_getcapsize(3) query login.conf database about a user class login_getcapstr(3) query login.conf database about a user class login_getcaptime(3) query login.conf database about a user class login_getclass(3) query login.conf database about a user class login_tty(3) tty utility function loginx(3) login utility function logout(3) login utility function logoutx(3) login utility function logwtmp(3) login utility function logwtmpx(3) login utility function opendisk(3) open a disk partition openpty(3) tty utility function pidfile(3) write a daemon pid file pidlock(3) locks based on files containing PIDs pw_abort(3) passwd file update function pw_copy(3) utility function for interactive passwd file updates pw_edit(3) utility function for interactive passwd file updates pw_error(3) utility function for interactive passwd file updates pw_getconf(3) password encryption configuration access function pw_getprefix(3) passwd file update function pw_init(3) utility function for interactive passwd file updates pw_lock(3) passwd file update function pw_mkdb(3) passwd file update function pw_prompt(3) utility function for interactive passwd file updates pw_scan(3) utility function for interactive passwd file updates pw_setprefix(3) passwd file update function secure_path(3) determine if a file appears to be ``secure'' setclasscontext(3) query login.conf database about a user class setusercontext(3) query login.conf database about a user class snprintb(3) bitmask output conversion sockaddr_snprintf(3) socket address formatting function strpct(3) decimal percent formatter ttyaction(3) ttyaction utility function ttylock(3) locks based on files containing PIDs ttymsg(3) ttymsg utility function ttyunlock(3) locks based on files containing PIDs FILES
/usr/lib/libutil.a static util library /usr/lib/libutil.so dynamic util library /usr/lib/libutil_p.a static util library compiled for profiling SEE ALSO
efun(3), intro(3) BSD
August 29, 2011 BSD