Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Dynamic update loop query on Sybase database
Top Forums Shell Programming and Scripting Dynamic update loop query on Sybase database Post 302150338 by Vicky Narayan on Tuesday 11th of December 2007 03:58:44 AM
Old 12-11-2007
Alaeddin,

TempFile1: its the name of a temproary file. Suppose if due to some prob the shell script is not able to connect to your database and you want the error in some file...We ve used temp file for this purpose. If you dont specify this den the error will be displayed on the shell prompt. If dis is ok wid u den u need not use d temp file.

Or u can do something like....declare the tempfile as u ve declared the other variables(specify d full path).

For the query:
Use the database query using while loop between the middle brackets...
You can use only database queries once the connection to database is eastablished....
And the database connection gets eastablished just after you give the isql command...
Try using the below code snippet in place of middle brackets.:

declare @i int
select @i = 1
while(@i <= 3)
begin
Insert into TEST values (3,"Test","TestDesc")
select @i = @i + 1
end


U should not use middle brackets dere..I had used it just to let you know the area where u need to write the query.
Try it out,buddy.....
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connect to sybase database using Korn shell script

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

Print out loop index on the console after executing each sybase DB query

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

Need help with complex SQL query (Sybase)

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

how to connect to sybase database?

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

Execute stored procedure through script in sybase database and store the output in a .csv file

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 OF A DYNAMIC DATABASE

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

Hierarchical Query for Sybase database

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

Sybase ASE: Query to find correct format issue.

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

Sybase ASE - Query Tuning - Need Suggestion

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

Update a database table in a for loop

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 DEBIAN

mongo

MONGO(1)							  Mongo Database							  MONGO(1)

NAME

       mongo - the Mongo command-line tool

SYNOPSIS

       mongo [OPTIONS] [DB_ADDRESS] [FILE+]

DESCRIPTION

       mongo  is  a JavaScript shell (with GNU readline capabilities).	It supports interactive and non-interactive use.  When used interactively,
       JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey.  Database output  is  dis-
       played in JSON format.

       If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting.

EXAMPLES

       mongo  start the shell, connecting to the server at localhost:27017 and using the test database

       mongo foo
	      start the shell using the foo database at localhost:27017

       mongo 192.169.0.5/foo
	      start the shell using the foo database at 192.169.0.5:27017

       mongo 192.169.0.5:9999/foo
	      start the shell using the foo database at 192.169.0.5:9999

       mongo script1.js script2.js script3.js
	      run three scripts and exit

OPTIONS

       --shell
	      run the shell after executing files

       --help show usage information

       --host HOST
	      server to connect to (default HOST=localhost)

       --port PORT
	      port to connect to (default PORT=27017)

       --nodb do not connect to mongod

       --eval SCRIPT
	      evaluate JavaScript

       -u USERNAME
	      specify user to log in as

       -pPASSWORD
	      specify password of user (notice there is no space)

COPYRIGHT

       Copyright 2007-2009 10gen

SEE ALSO

       For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.

AUTHOR

       Kristina Chodorow

10gen								     June 2009								  MONGO(1)
All times are GMT -4. The time now is 08:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy