bcp_bind

関数

一括コピーでプログラム変数を表の列に結び付ける。

DLLodbcbcp.dll呼出規約winapi

シグネチャ

// odbcbcp.dll
#include <windows.h>

SHORT bcp_bind(
    void* param0,
    BYTE* param1,
    INT param2,
    INT param3,
    BYTE* param4,
    INT param5,
    INT param6,
    INT param7
);

パラメーター

名前	型	方向	説明
param0	void*	inout	BCP操作のODBC接続ハンドル。
param1	BYTE*	inout	プログラム変数(データ)のアドレス。バインド元バッファ。
param2	INT	in	データ前に置く標識バイトの長さ。標識なしなら0。
param3	INT	in	プログラム変数内のデータの最大バイト長。
param4	BYTE*	inout	終端文字列(ターミネータ)へのポインタ。可変長データで使用。
param5	INT	in	ターミネータの長さ(バイト数)。
param6	INT	in	プログラム変数のデータ型(BCPデータ型)を指定する。
param7	INT	in	対応するテーブル列の序数。1始まりで指定する。

戻り値の型: SHORT

各言語での呼び出し定義

// odbcbcp.dll
#include <windows.h>

SHORT bcp_bind(
    void* param0,
    BYTE* param1,
    INT param2,
    INT param3,
    BYTE* param4,
    INT param5,
    INT param6,
    INT param7
);

[DllImport("odbcbcp.dll", ExactSpelling = true)]
static extern short bcp_bind(
    IntPtr param0,   // void* in/out
    IntPtr param1,   // BYTE* in/out
    int param2,   // INT
    int param3,   // INT
    IntPtr param4,   // BYTE* in/out
    int param5,   // INT
    int param6,   // INT
    int param7   // INT
);

<DllImport("odbcbcp.dll", ExactSpelling:=True)>
Public Shared Function bcp_bind(
    param0 As IntPtr,   ' void* in/out
    param1 As IntPtr,   ' BYTE* in/out
    param2 As Integer,   ' INT
    param3 As Integer,   ' INT
    param4 As IntPtr,   ' BYTE* in/out
    param5 As Integer,   ' INT
    param6 As Integer,   ' INT
    param7 As Integer   ' INT
) As Short
End Function

' param0 : void* in/out
' param1 : BYTE* in/out
' param2 : INT
' param3 : INT
' param4 : BYTE* in/out
' param5 : INT
' param6 : INT
' param7 : INT
Declare PtrSafe Function bcp_bind Lib "odbcbcp" ( _
    ByVal param0 As LongPtr, _
    ByVal param1 As LongPtr, _
    ByVal param2 As Long, _
    ByVal param3 As Long, _
    ByVal param4 As LongPtr, _
    ByVal param5 As Long, _
    ByVal param6 As Long, _
    ByVal param7 As Long) As Integer
' VBA7前提(PtrSafe)。32bit Office では LongPtr→Long。Integer=16bit / Long=32bit / LongLong=64bit。

import ctypes
from ctypes import wintypes

bcp_bind = ctypes.windll.odbcbcp.bcp_bind
bcp_bind.restype = ctypes.c_short
bcp_bind.argtypes = [
    ctypes.POINTER(None),  # param0 : void* in/out
    ctypes.POINTER(ctypes.c_ubyte),  # param1 : BYTE* in/out
    ctypes.c_int,  # param2 : INT
    ctypes.c_int,  # param3 : INT
    ctypes.POINTER(ctypes.c_ubyte),  # param4 : BYTE* in/out
    ctypes.c_int,  # param5 : INT
    ctypes.c_int,  # param6 : INT
    ctypes.c_int,  # param7 : INT
]

require 'fiddle'
require 'fiddle/import'

lib = Fiddle.dlopen('odbcbcp.dll')
bcp_bind = Fiddle::Function.new(
  lib['bcp_bind'],
  [
    Fiddle::TYPE_VOIDP,  # param0 : void* in/out
    Fiddle::TYPE_VOIDP,  # param1 : BYTE* in/out
    Fiddle::TYPE_INT,  # param2 : INT
    Fiddle::TYPE_INT,  # param3 : INT
    Fiddle::TYPE_VOIDP,  # param4 : BYTE* in/out
    Fiddle::TYPE_INT,  # param5 : INT
    Fiddle::TYPE_INT,  # param6 : INT
    Fiddle::TYPE_INT,  # param7 : INT
  ],
  Fiddle::TYPE_SHORT)

#[link(name = "odbcbcp")]
extern "system" {
    fn bcp_bind(
        param0: *mut (),  // void* in/out
        param1: *mut u8,  // BYTE* in/out
        param2: i32,  // INT
        param3: i32,  // INT
        param4: *mut u8,  // BYTE* in/out
        param5: i32,  // INT
        param6: i32,  // INT
        param7: i32  // INT
    ) -> i16;
}
// crates: windows-sys provides ready-made bindings for this API.

$sig = @"
[DllImport("odbcbcp.dll")]
public static extern short bcp_bind(IntPtr param0, IntPtr param1, int param2, int param3, IntPtr param4, int param5, int param6, int param7);
"@
$api = Add-Type -MemberDefinition $sig -Name 'odbcbcp_bcp_bind' -Namespace Win32 -PassThru
# $api::bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)

#uselib "odbcbcp.dll"
#func global bcp_bind "bcp_bind" sptr, sptr, sptr, sptr, sptr, sptr, sptr, sptr
; bcp_bind param0, varptr(param1), param2, param3, varptr(param4), param5, param6, param7   ; 戻り値は stat
; param0 : void* in/out -> "sptr"
; param1 : BYTE* in/out -> "sptr"
; param2 : INT -> "sptr"
; param3 : INT -> "sptr"
; param4 : BYTE* in/out -> "sptr"
; param5 : INT -> "sptr"
; param6 : INT -> "sptr"
; param7 : INT -> "sptr"
; ※HSP3.7は #func のため戻り値はシステム変数 stat に格納されます。

出力引数:

#uselib "odbcbcp.dll"
#cfunc global bcp_bind "bcp_bind" sptr, var, int, int, var, int, int, int
; res = bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
; param0 : void* in/out -> "sptr"
; param1 : BYTE* in/out -> "var"
; param2 : INT -> "int"
; param3 : INT -> "int"
; param4 : BYTE* in/out -> "var"
; param5 : INT -> "int"
; param6 : INT -> "int"
; param7 : INT -> "int"
; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。#uselib "odbcbcp.dll"
#cfunc global bcp_bind "bcp_bind" sptr, sptr, int, int, sptr, int, int, int
; res = bcp_bind(param0, varptr(param1), param2, param3, varptr(param4), param5, param6, param7)
; param0 : void* in/out -> "sptr"
; param1 : BYTE* in/out -> "sptr"
; param2 : INT -> "int"
; param3 : INT -> "int"
; param4 : BYTE* in/out -> "sptr"
; param5 : INT -> "int"
; param6 : INT -> "int"
; param7 : INT -> "int"
; ※出力/バッファ引数はポインタ方式(token=sptr / 呼び出しは varptr(変数))。

出力引数:

; SHORT bcp_bind(void* param0, BYTE* param1, INT param2, INT param3, BYTE* param4, INT param5, INT param6, INT param7)
#uselib "odbcbcp.dll"
#cfunc global bcp_bind "bcp_bind" intptr, var, int, int, var, int, int, int
; res = bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
; param0 : void* in/out -> "intptr"
; param1 : BYTE* in/out -> "var"
; param2 : INT -> "int"
; param3 : INT -> "int"
; param4 : BYTE* in/out -> "var"
; param5 : INT -> "int"
; param6 : INT -> "int"
; param7 : INT -> "int"
; ※出力/バッファ引数は var 方式(変数を直接渡す)。varptr 方式にも切替可。; SHORT bcp_bind(void* param0, BYTE* param1, INT param2, INT param3, BYTE* param4, INT param5, INT param6, INT param7)
#uselib "odbcbcp.dll"
#cfunc global bcp_bind "bcp_bind" intptr, intptr, int, int, intptr, int, int, int
; res = bcp_bind(param0, varptr(param1), param2, param3, varptr(param4), param5, param6, param7)
; param0 : void* in/out -> "intptr"
; param1 : BYTE* in/out -> "intptr"
; param2 : INT -> "int"
; param3 : INT -> "int"
; param4 : BYTE* in/out -> "intptr"
; param5 : INT -> "int"
; param6 : INT -> "int"
; param7 : INT -> "int"
; ※出力/バッファ引数はポインタ方式(token=intptr / 呼び出しは varptr(変数))。

import (
	"golang.org/x/sys/windows"
	"unsafe"
)

var (
	odbcbcp = windows.NewLazySystemDLL("odbcbcp.dll")
	procbcp_bind = odbcbcp.NewProc("bcp_bind")
)

// param0 (void* in/out), param1 (BYTE* in/out), param2 (INT), param3 (INT), param4 (BYTE* in/out), param5 (INT), param6 (INT), param7 (INT)
r1, _, err := procbcp_bind.Call(
	uintptr(param0),
	uintptr(param1),
	uintptr(param2),
	uintptr(param3),
	uintptr(param4),
	uintptr(param5),
	uintptr(param6),
	uintptr(param7),
)
_ = err  // syscall.Errno (valid when the call sets last-error)
_ = r1   // SHORT

function bcp_bind(
  param0: Pointer;   // void* in/out
  param1: Pointer;   // BYTE* in/out
  param2: Integer;   // INT
  param3: Integer;   // INT
  param4: Pointer;   // BYTE* in/out
  param5: Integer;   // INT
  param6: Integer;   // INT
  param7: Integer   // INT
): Smallint; stdcall;
  external 'odbcbcp.dll' name 'bcp_bind';

result := DllCall("odbcbcp\bcp_bind"
    , "Ptr", param0   ; void* in/out
    , "Ptr", param1   ; BYTE* in/out
    , "Int", param2   ; INT
    , "Int", param3   ; INT
    , "Ptr", param4   ; BYTE* in/out
    , "Int", param5   ; INT
    , "Int", param6   ; INT
    , "Int", param7   ; INT
    , "Short")   ; return: SHORT

●bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7) = DLL("odbcbcp.dll", "int bcp_bind(void*, void*, int, int, void*, int, int, int)")
# 呼び出し: bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
# param0 : void* in/out -> "void*"
# param1 : BYTE* in/out -> "void*"
# param2 : INT -> "int"
# param3 : INT -> "int"
# param4 : BYTE* in/out -> "void*"
# param5 : INT -> "int"
# param6 : INT -> "int"
# param7 : INT -> "int"
# なでしこ1は32bit・ANSI(Shift_JIS)。文字列=char*(ANSI)、ポインタ/ハンドル=void*(4byte)。

const std = @import("std");

extern "odbcbcp" fn bcp_bind(
    param0: ?*anyopaque, // void* in/out
    param1: [*c]u8, // BYTE* in/out
    param2: i32, // INT
    param3: i32, // INT
    param4: [*c]u8, // BYTE* in/out
    param5: i32, // INT
    param6: i32, // INT
    param7: i32 // INT
) callconv(std.os.windows.WINAPI) i16;

proc bcp_bind(
    param0: pointer,  # void* in/out
    param1: ptr uint8,  # BYTE* in/out
    param2: int32,  # INT
    param3: int32,  # INT
    param4: ptr uint8,  # BYTE* in/out
    param5: int32,  # INT
    param6: int32,  # INT
    param7: int32  # INT
): int16 {.importc: "bcp_bind", stdcall, dynlib: "odbcbcp.dll".}

pragma(lib, "odbcbcp");
extern(Windows)
short bcp_bind(
    void* param0,   // void* in/out
    ubyte* param1,   // BYTE* in/out
    int param2,   // INT
    int param3,   // INT
    ubyte* param4,   // BYTE* in/out
    int param5,   // INT
    int param6,   // INT
    int param7   // INT
);

ccall((:bcp_bind, "odbcbcp.dll"), stdcall, Int16,
      (Ptr{Cvoid}, Ptr{UInt8}, Int32, Int32, Ptr{UInt8}, Int32, Int32, Int32),
      param0, param1, param2, param3, param4, param5, param6, param7)
# param0 : void* in/out -> Ptr{Cvoid}
# param1 : BYTE* in/out -> Ptr{UInt8}
# param2 : INT -> Int32
# param3 : INT -> Int32
# param4 : BYTE* in/out -> Ptr{UInt8}
# param5 : INT -> Int32
# param6 : INT -> Int32
# param7 : INT -> Int32
# stdcall は 32bit のみ意味を持つ(x64 では無視)。

local ffi = require("ffi")
ffi.cdef[[
int16_t bcp_bind(
    void* param0,
    uint8_t* param1,
    int32_t param2,
    int32_t param3,
    uint8_t* param4,
    int32_t param5,
    int32_t param6,
    int32_t param7);
]]
local odbcbcp = ffi.load("odbcbcp")
-- odbcbcp.bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
-- param0 : void* in/out
-- param1 : BYTE* in/out
-- param2 : INT
-- param3 : INT
-- param4 : BYTE* in/out
-- param5 : INT
-- param6 : INT
-- param7 : INT
-- 構造体/GUIDへのポインタは cdef が通るよう void* で表記(実型は各引数コメント参照)。値渡し構造体・enum は対応する typedef を cdef に追加すること。

const koffi = require('koffi');
const lib = koffi.load('odbcbcp.dll');
const bcp_bind = lib.func('__stdcall', 'bcp_bind', 'int16_t', ['void *', 'uint8_t *', 'int32_t', 'int32_t', 'uint8_t *', 'int32_t', 'int32_t', 'int32_t']);
// bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
// param0 : void* in/out -> 'void *'
// param1 : BYTE* in/out -> 'uint8_t *'
// param2 : INT -> 'int32_t'
// param3 : INT -> 'int32_t'
// param4 : BYTE* in/out -> 'uint8_t *'
// param5 : INT -> 'int32_t'
// param6 : INT -> 'int32_t'
// param7 : INT -> 'int32_t'
// 出力ポインタは koffi.out(...) で包む。構造体は koffi.struct で定義。

const lib = Deno.dlopen("odbcbcp.dll", {
  bcp_bind: { parameters: ["pointer", "pointer", "i32", "i32", "pointer", "i32", "i32", "i32"], result: "i16" },
});
// lib.symbols.bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7)
// param0 : void* in/out -> "pointer"
// param1 : BYTE* in/out -> "pointer"
// param2 : INT -> "i32"
// param3 : INT -> "i32"
// param4 : BYTE* in/out -> "pointer"
// param5 : INT -> "i32"
// param6 : INT -> "i32"
// param7 : INT -> "i32"
// 文字列引数は "buffer"(NUL 終端のバイト列を Uint8Array で渡す)。
// 値渡し構造体は { struct: [ ...field types... ] } を使用。

<?php
$ffi = FFI::cdef(<<<C
int16_t bcp_bind(
    void* param0,
    uint8_t* param1,
    int32_t param2,
    int32_t param3,
    uint8_t* param4,
    int32_t param5,
    int32_t param6,
    int32_t param7);
C, "odbcbcp.dll");
// $ffi->bcp_bind(param0, param1, param2, param3, param4, param5, param6, param7);
// param0 : void* in/out
// param1 : BYTE* in/out
// param2 : INT
// param3 : INT
// param4 : BYTE* in/out
// param5 : INT
// param6 : INT
// param7 : INT
// 構造体/GUIDへのポインタは cdef が通るよう void* で表記(実型は各引数コメント参照)。値渡し構造体・enum は対応する typedef を cdef に追加すること。
// WINAPI(stdcall): x64 では呼出規約が統一されるため問題なし。x86 では __stdcall 対応のラッパが必要な場合あり。

import com.sun.jna.*;
import com.sun.jna.ptr.*;
import com.sun.jna.win32.StdCallLibrary;
import com.sun.jna.win32.W32APIOptions;

public interface Odbcbcp extends StdCallLibrary {
    Odbcbcp INSTANCE = Native.load("odbcbcp", Odbcbcp.class);
    short bcp_bind(
        Pointer param0,   // void* in/out
        byte[] param1,   // BYTE* in/out
        int param2,   // INT
        int param3,   // INT
        byte[] param4,   // BYTE* in/out
        int param5,   // INT
        int param6,   // INT
        int param7   // INT
    );
}

@[Link("odbcbcp")]
lib Libodbcbcp
  fun bcp_bind = bcp_bind(
    param0 : Void*,   # void* in/out
    param1 : UInt8*,   # BYTE* in/out
    param2 : Int32,   # INT
    param3 : Int32,   # INT
    param4 : UInt8*,   # BYTE* in/out
    param5 : Int32,   # INT
    param6 : Int32,   # INT
    param7 : Int32   # INT
  ) : Int16
end
# 構造体/GUID/enum は lib 内に対応する型定義が必要。
# 呼出規約: x64 は規約統一のため OK。x86(32bit)は WINAPI=stdcall だが Crystal の fun に stdcall 付与構文がなく非対応。

import 'dart:ffi';
import 'package:ffi/ffi.dart';

typedef bcp_bindNative = Int16 Function(Pointer<Void>, Pointer<Uint8>, Int32, Int32, Pointer<Uint8>, Int32, Int32, Int32);
typedef bcp_bindDart = int Function(Pointer<Void>, Pointer<Uint8>, int, int, Pointer<Uint8>, int, int, int);
final bcp_bind = DynamicLibrary.open('odbcbcp.dll')
    .lookupFunction<bcp_bindNative, bcp_bindDart>('bcp_bind');
// param0 : void* in/out -> Pointer<Void>
// param1 : BYTE* in/out -> Pointer<Uint8>
// param2 : INT -> Int32
// param3 : INT -> Int32
// param4 : BYTE* in/out -> Pointer<Uint8>
// param5 : INT -> Int32
// param6 : INT -> Int32
// param7 : INT -> Int32
// 文字列は package:ffi の "...".toNativeUtf16()/toNativeUtf8() で変換。

{$mode objfpc}{$H+}
function bcp_bind(
  param0: Pointer;   // void* in/out
  param1: Pointer;   // BYTE* in/out
  param2: Integer;   // INT
  param3: Integer;   // INT
  param4: Pointer;   // BYTE* in/out
  param5: Integer;   // INT
  param6: Integer;   // INT
  param7: Integer   // INT
): Smallint; stdcall;
  external 'odbcbcp.dll' name 'bcp_bind';

import Foreign
import Foreign.C.Types
import Foreign.C.String

foreign import stdcall safe "bcp_bind"
  c_bcp_bind :: Ptr () -> Ptr Word8 -> Int32 -> Int32 -> Ptr Word8 -> Int32 -> Int32 -> Int32 -> IO Int16
-- param0 : void* in/out -> Ptr ()
-- param1 : BYTE* in/out -> Ptr Word8
-- param2 : INT -> Int32
-- param3 : INT -> Int32
-- param4 : BYTE* in/out -> Ptr Word8
-- param5 : INT -> Int32
-- param6 : INT -> Int32
-- param7 : INT -> Int32
-- 要 GHC(Windows)。stdcall は x64 では ccall として扱われる。ブロックする API は safe 呼び出し推奨。

open Ctypes
open Foreign

let bcp_bind =
  foreign "bcp_bind"
    ((ptr void) @-> (ptr uint8_t) @-> int32_t @-> int32_t @-> (ptr uint8_t) @-> int32_t @-> int32_t @-> int32_t @-> returning int16_t)
(* param0 : void* in/out -> (ptr void) *)
(* param1 : BYTE* in/out -> (ptr uint8_t) *)
(* param2 : INT -> int32_t *)
(* param3 : INT -> int32_t *)
(* param4 : BYTE* in/out -> (ptr uint8_t) *)
(* param5 : INT -> int32_t *)
(* param6 : INT -> int32_t *)
(* param7 : INT -> int32_t *)
(* foreign は cdecl 前提。x64 Windows では WINAPI と一致。構造体は ctypes structure を定義のこと。 *)

(cffi:define-foreign-library odbcbcp (t "odbcbcp.dll"))
(cffi:use-foreign-library odbcbcp)

(cffi:defcfun ("bcp_bind" bcp-bind :convention :stdcall) :int16
  (param0 :pointer)   ; void* in/out
  (param1 :pointer)   ; BYTE* in/out
  (param2 :int32)   ; INT
  (param3 :int32)   ; INT
  (param4 :pointer)   ; BYTE* in/out
  (param5 :int32)   ; INT
  (param6 :int32)   ; INT
  (param7 :int32))   ; INT
; isize/usize(INT_PTR/SIZE_T)は x64 前提で :int64/:uint64。x86 では :int32/:uint32。

use Win32::API;
my $bcp_bind = Win32::API::More->new('odbcbcp',
    'short bcp_bind(LPVOID param0, LPVOID param1, int param2, int param3, LPVOID param4, int param5, int param6, int param7)');
# my $ret = $bcp_bind->Call($param0, $param1, $param2, $param3, $param4, $param5, $param6, $param7);
# param0 : void* in/out -> LPVOID
# param1 : BYTE* in/out -> LPVOID
# param2 : INT -> int
# param3 : INT -> int
# param4 : BYTE* in/out -> LPVOID
# param5 : INT -> int
# param6 : INT -> int
# param7 : INT -> int
# 値渡し構造体は pack() した文字列、または Win32::API::Struct を使用。