10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings Experts,
I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to execute the contents in the file (there are around 300 view creation and grant statements) in Oracle and... (4 Replies)
Discussion started by: chill3chee
4 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
I have 250 files that have 16 columns each - all numbered as follows stat.1000, stat.1001, stat.1002, stat.1003....stat.1250.
I would like to join all 250 of them together tail by tail as follows. For example
stat.1000
a b c
d e f
stat.1001
g h i
j k l
So that my output... (2 Replies)
Discussion started by: kayak
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to execute the below statment in my script.am getting the error as " syntax error near unexpected token 'else'. Is If statement is correct.
if ];
then
if ];
then
cp $src_dir/import-serv/$q_dirs*.txt $tgt_dir/$q_dirs/import-serv/
else
cdsgq_dir=`echo... (3 Replies)
Discussion started by: kirankumar
3 Replies
5. Shell Programming and Scripting
I have an expect script that interrogates several hundred unix servers for both access and directories therein using "ssh user@host ls -l /path". The combination of host/path are unique but the host may be interrogated multiple times if there are multiple paths to test.
The expect script is run... (2 Replies)
Discussion started by: twk
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
i am using PUTTY 0.51 release for connecting the Red hate linux box in SSH mode. its working fine but i can't able to scoll the scoll bar using scroll wheel inthe mouse. please suggest me how to solve it.
thanks in advance.
thanks and regards,
ilayans (2 Replies)
Discussion started by: ilayans
2 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
In my ksh script, if the conditions of a if statement are true, then do nothing; otherwise, execute some commands.
How do I write the "do nothing" statement in the following example?
Example:
if (( "$x"="1" && "$y"="a" && "$z"="happy" ))
then
do nothing
else
command
command
fi... (3 Replies)
Discussion started by: april
3 Replies
9. Shell Programming and Scripting
Hi ,
I want gzip a folder te55 which has got 3 files test1.test2,test3
the name of the gzipped folder should be te55.gz with the 3 files as test1,test2,test3 itself...
Is it possible...
thanks in advance
sam (5 Replies)
Discussion started by: sam99
5 Replies
10. UNIX for Dummies Questions & Answers
Hi all,
Could someone please explain to me the shell invocation process when running a script. How do I stop the shell from logging out when it reaches an exit statement in the script?
if ; then
echo 'Failed to copy ${FILE}.fmx to ${J2_HOME}/dev/rsc'
... (3 Replies)
Discussion started by: richgi
3 Replies
TCRTEST(1) Tokyo Tyrant TCRTEST(1)
NAME
tcrtest - test cases of the remote database API
DESCRIPTION
The command `tcrtest' is a utility for facility test and performance test. This command is used in the following format. `host' specifies
the host name of the server. `rnum' specifies the number of iterations.
tcrtest write [-port num] [-cnum num] [-tout num] [-nr] [-rnd] host rnum
Store records with keys of 8 bytes. They change as `00000001', `00000002'...
tcrtest read [-port num] [-cnum num] [-tout num] [-mul num] [-rnd] host
Retrieve all records of the database above.
tcrtest remove [-port num] [-cnum num] [-tout num] [-rnd] host
Remove all records of the database above.
tcrtest rcat [-port num] [-cnum num] [-tout num] [-shl num] [-dai|-dad] [-ext name] [-xlr|-xlg] host rnum
Store records with partway duplicated keys using concatenate mode.
tcrtest misc [-port num] [-cnum num] [-tout num] host rnum
Perform miscellaneous test of various operations.
tcrtest wicked [-port num] [-cnum num] [-tout num] host rnum
Perform updating operations of list and map selected at random.
tcrtest table [-port num] [-cnum num] [-tout num] [-exp num] host rnum
Perform miscellaneous test of the table extension.
Options feature the following.
-port num : specify the port number.
-cnum num : specify the number of connections.
-tout num : specify the timeout of each session in seconds.
-nr : use the function `tcrdbputnr' instead of `tcrdbput'.
-rnd : select keys at random.
-mul num : specify the number of records for the mget command.
-shl num : use `tcrdbputshl' and specify the width.
-dai : use `tcrdbaddint' instead of `tcrdbputcat'.
-dad : use `tcrdbadddouble' instead of `tcrdbputcat'.
-ext name : call a script language extension function.
-xlr : perform record locking.
-xlg : perform global locking.
-exp num : specify the lifetime of expiration test.
If the port number is not more than 0, UNIX domain socket is used and the path of the socket file is specified by the host parameter. This
command returns 0 on success, another on failure.
SEE ALSO
ttserver(1), ttultest(1), ttulmgr(1), tcrmttest(1), tcrmgr(1), ttutil(3), tcrdb(3)
Man Page 2010-01-20 TCRTEST(1)