ibm_db 1.0.7

A tool for DB2 connectivity using CLI Driver
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

use ibm_db::{create_environment_v3, Statement,ResultSetState::Data};
use std::error::Error;

fn main() {
    test_me().unwrap()
}

fn test_me() -> std::result::Result<(), Box<dyn Error>> {
    let env = create_environment_v3().expect("Can't create ODBC environment");
    let connection_string = "DRIVER={IBM DB2 ODBC DRIVER};DATABASE=SAMPLE;HOSTNAME=db.example.com;PORT=50000;UID=db_user;PWD=YourPassword123";
    let conn = env.connect_with_connection_string(connection_string)?;
    let stmt = Statement::with_parent(&conn)?.prepare(
        "select * from test where COL3 = ?",
    )?;

    let param = "Binit";

    let stmt = stmt.bind_parameter(1, &param)?;
    /*let stmt = stmt.bind_parameter(2, &param)?;
    let stmt = stmt.bind_parameter(3, &param)?;
    let stmt = stmt.bind_parameter(4, &param)?;*/

    let stmt = match stmt.execute()? { Data(mut stmt) => {
        if let Some(mut cursor) = stmt.fetch()? {
            println!("{}", cursor.get_data::<String>(1)?.unwrap());
        }
        stmt.close_cursor()?
    } _ => {
        panic!("SELECT statement returned no result set");
    }};

    let stmt = stmt.reset_parameters()?;

    let param = 128u8;

    let stmt = stmt.bind_parameter(1, &param)?;
    let stmt = stmt.bind_parameter(2, &param)?;

    let stmt = match stmt.execute()? { Data(mut stmt) => {
        if let Some(mut cursor) = stmt.fetch()? {
            println!("{}", cursor.get_data::<String>(1)?.unwrap());
        }
        stmt.close_cursor()?
    } _ => {
        panic!("SELECT statement returned no result set");
    }};
    stmt.reset_parameters().unwrap();

    Ok(())
}