Script
Usage
You have to change following settings.- user_id
- password
- proxy_serer
- proxy port
- Num of messages
#!/bin/sh
JOB_NET=$1
echo "ajsentry -n -w $JOB_NET"
ajsentry -n -w $JOB_NET
echo "ajsshow -l -k -T $JOB_NET"
ajsshow -l -k -T $JOB_NET
ajsrun.sh JOBNET_NAME
bash-2.05$ ajsrun.sh /aaaa/bbbb/JOBNET01/
ajsentry -n -w /aaaa/bbbb/JOBNET01/
ajsshow -l -k -T /aaaa/bbbb/JOBNET01/
AJSPATH = /aaaa/bbbb/JOBNET01 net 正常終了 *** 2006/02/14 0:19 2006/02/14 0:20
bash-2.05$
Digit place | high digit | low digit | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
&hx0 | &hx1 | &hx2 | &hx3 | &hx4 | &hx5 | &hx6 | &hx7 | &hx8 | &hx9 | ||
Higher than tenths place digit | &h3x | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
ones place digit(positive) | &h4x | @ | A | B | C | D | E | F | G | H | I |
ones place digit(negative) | &h5x | P | Q | R | S | T | U | V | W | X | Y |
123@ | +1230 |
200E | -2005 |
123P | -1230 |
102T | -1024 |
sqlplus user/pass @expSeq.sql
Example
bash-2.05$ sqlplus mais/mais @expSeq.sql
SQL*Plus: Release 9.2.0.6.0 - Production on 日 Dec 4 01:19:02 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
に接続されました。
-- シーケンスを削除する
DROP SEQUENCE aaaaSEQ;
DROP SEQUENCE bbbbSEQ;
DROP SEQUENCE ccccSEQ;
(省略)
-- シーケンスを生成する
CREATE SEQUENCE aaaaSEQ START WITH 26857 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9999999 CYCLE CACHE 20;
CREATE SEQUENCE bbbbSEQ START WITH 34343 INCREMENT BY 1 MINVALUE 30000 MAXVALUE 49999 CYCLE CACHE 20;
CREATE SEQUENCE ccccSEQ START WITH 33367 INCREMENT BY 1 MINVALUE 30000 MAXVALUE 49999 CYCLE CACHE 20;
(省略)
quit
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Productionとの接続が切断されました。