10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Following is the output of a command ran inside the script:
2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5... (8 Replies)
Discussion started by: Devendra Hupri
8 Replies
2. Programming
Hi, I have 2 different values in the same column and two different values in other column
Query 1
ins name value
1 Test 12345
1 TestV1 12/10/2014
8 Test 85435
8 TestV1 11/11/2005
9 Test 42232
9 TestV1 19/10/2000
6 Test 54321... (6 Replies)
Discussion started by: faka
6 Replies
3. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
4. Shell Programming and Scripting
I have sql query in shell script.
select distinct account_no from adj order by account_no;
This query returns account number daily.Sometimes it may return 90 rows sometime it may return 1 row only and someday it may return 0 rows
I am storing the output of this query in sql_output.txt.
... (5 Replies)
Discussion started by: rafa_fed2
5 Replies
5. Shell Programming and Scripting
hi ..
i have a isql session which inside which i have two variables defined.. i wanna calculate % based on those variables. i knw i can easily do % calculation in csh if i could get the value of these variables passed outside the isql session . is tat possible ?? pls advice
somthin like below... (1 Reply)
Discussion started by: Rahul619
1 Replies
6. Shell Programming and Scripting
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies
7. Shell Programming and Scripting
Hi
i want write a script for list of sysbase are having access or open.
then i wrote like:
USER="abc"
PASS="xyz"
SERVER="SCCS"
DB="blue"
WORK_DIR="/usr/home/ramakrishna"
set -x
isql -U${USER} -P${PASS} -S${SERVER}<<EOF>$WORK_DIR/output.log
go
use blue (database name)
go
use... (0 Replies)
Discussion started by: koti_rama
0 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
9. Shell Programming and Scripting
Hi All-
First time using iSql.
I have 4 query files - some have more than 1 line of sql statements
After a bit of research it appears I can just use the -i command and specify the input file.
Questions:
Does it matter that there are multiple queries in each file? Do I need to have... (3 Replies)
Discussion started by: Cailet
3 Replies
10. Shell Programming and Scripting
Dear all
I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.
isql -U -P
use gdb_1
go
select count (*) from table_x
go (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies