IBM DB2 UDB Blog Center

db2batch -d 데이터베이스 -f SQL_파일명 -a ID/PWD -m 변수값 -z 출력_파일명 -iso cs -car cc -o r 1 p 2 e yes

cat > sql.db2 <<EOF
select * from emp where empno > 10 ;
EOF

* Timestamp: Tue Aug 27 2013 00:43:11 KORST
---------------------------------------------

* SQL Statement Number 1:

select * from emp where empno > 10 ;

(생략) 데이터 1건 결과

* 41 row(s) fetched, 1 row(s) output.

* Elapsed Time is:       0.011069 seconds

            Monitoring Information

Instance name                                  = db2inst

(생략)

            Application Snapshot

Application handle                         = 49923
Application status                         = UOW Waiting

(생략)

* Summary Table:

Type      Number      Repetitions Total Time (s) Min Time (s)   Max Time (s)   Arithmetic Mean Geometric Mean Row(s) Fetched Row(s) Output
--------- ----------- ----------- -------------- -------------- -------------- --------------- -------------- -------------- -------------
Statement           1           1       0.011069       0.011069       0.011069        0.011069       0.011069             41             1

* Total Entries:              1
* Total Time:                 0.011069 seconds
* Minimum Time:               0.011069 seconds
* Maximum Time:               0.011069 seconds
* Arithmetic Mean Time:       0.011069 seconds
* Geometric Mean Time:        0.011069 seconds
---------------------------------------------

cat > par.db2 <<EOF
--#PARAM 1000
--#PARAM 'M'
select * from emp where salary > ? and sex = ?;
EOF

cat > par.ins <<EOF
1000 'M'
EOF

cat > par.db2 <<EOF
select * from emp where salary > ? and sex = ?;
EOF

............

config.status: creating build/pkg/pkginfo

config.status: creating build/config_vars.sh

config.status: creating include/ap_config_auto.h

config.status: executing default commands

mkdir /usr/local/apache/man/man1

mkdir /usr/local/apache/man/man8

mkdir /usr/local/apache/manual

make[1]: Leaving directory `/usr/local/httpd-2.2.6

root 12184 1 0 11:18 ? 00:00:00 /usr/local/apache2/bin/httpd -k start

daemon 12185 12184 0 11:18 ? 00:00:00 /usr/local/apache2/bin/httpd -k start

daemon 12186 12184 0 11:18 ? 00:00:00 /usr/local/apache2/bin/httpd -k start

daemon 12187 12184 0 11:18 ? 00:00:00 /usr/local/apache2/bin/httpd –k

# Dynamic Share Object (DSO) Support

LoadModule php4_module modules/libphp4.so

#ServerName www.example.com:80

ServerName localhost:80

AddType application/x-httpd-php .php .php3 .php4 .php5 .html .htm

+--------------------------------------------------------------------+

| License: |

| This software is subject to the PHP License, available in this |

| distribution in the file LICENSE. By continuing this installation |

| process, you are bound by the terms of this license agreement. |

| If you do not agree with the terms of this license, you must abort |

| the installation process at this point. |

+--------------------------------------------------------------------+

Thank you for using PHP.

pear/PEAR can optionally use package "pear/XML_RPC" (version >= 1.4.0)

[PEAR] PEAR - installed: 1.6.1

Wrote PEAR system config file at: /usr/local/etc/pear.conf

You may want to add: /usr/local/lib/php to your php.ini include_path

Installing PDO headers: /usr/local/include/php/ext/pdo/

#> su – db2inst1
$> db2 catalog tcpip node db2node1 remote 127.0.0.1 server 50000 remote_instance DB2INST

$> db2 attach to db2node1 user db2inst using db2inst

$> db2 detach
$> db2 catalog db sample at node db2node1
$> db2 connect to sample user db2inst using db2inst

<?

$dsn="sample";

$user="db2inst";

$passwd="db2inst";

$sql="select * from employee";

if ($conn_id=odbc_connect("$dsn","$user","$passwd")){

echo "$dsn 연결 성공";

if($result=odbc_do($conn_id, $sql)) {

echo "'$sql'문 실행";

echo "result:: ";

odbc_result_all($result);

echo "freeing result";

odbc_free_result($result);

} else {

echo "'$sql' 실행에러";

}

echo "$conn_id : 연결닫음";

odbc_close($conn_id);

}else {

echo "$dsn연결실패";

}

?>

<?php

$dbh = new PDO('odbc:SAMPLE','db2inst','db2inst');

echo "Connected\n";

$stmt= $dbh->prepare("call sp_test1(?)");

$stmt->bindParam(1, $return_value, PDO::PARAM_STR, 4000);

$stmt->execute();

print ":: sp_test1 returned ret_val: $return_value\n";

?>