database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
ㆍDB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
DB2 Q&A 83 게시물 읽기
No. 83
Re: db2 억세스 하는 c 소스 있으신분...
작성자
조율제
작성일
2001-06-28 14:13
조회수
14,502

DB2 정보센터를 실행시킨담에...

서적 탭을 클릭 하시면...

CLI Guide and Reference 메뉴가 있습니다.

그 메뉴를 클릭하시면....

CLI에 대해서 나오는데...그 쪽에 아마 원하는 소스가 있을겁니다.

그 도움말에 있는 샘플 아무거나 뽑았습니다.

도움이 되시길...

/******************************************************************************

**

** Source File Name = samputil.c 1.3

**

** Licensed Materials - Property of IBM

**

** (C) COPYRIGHT International Business Machines Corp. 1995, 1999

** All Rights Reserved.

**

** US Government Users Restricted Rights - Use, duplication or

** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

**

**

** PURPOSE :

** - contains various sample functions, used by most other samples:

** - check_error

** - DBconnect

** - prompted_connect

** - print_connect_info

** - print_error

** - print_results

** - check_error

** - terminate

**

** For more information about these samples see the README file.

**

** For more information on programming in CLI see the:

** - "Building CLI Applications" section of the Application Building Guide, and the

** - CLI Guide and Reference.

**

** For more information on the SQL language see the SQL Reference.

**

******************************************************************************/

 

#include <stdio.h>

#include <stdlib.h>

#include <string.h>

#include <sqlcli1.h>

#include "samputil.h"

 

#define MAXCOLS 255

 

#ifndef max

#define max(a,b) (a > b ? a : b)

#endif

 

/*

* Global Variables for user id and password, defined in main module.

* To keep samples simple, not a recommended practice.

* The INIT_UID_PWD macro is used to initialize these variables.

*/

SQLCHAR server[SQL_MAX_DSN_LENGTH + 1] ;

SQLCHAR uid[MAX_UID_LENGTH + 1] ;

SQLCHAR pwd[MAX_PWD_LENGTH + 1] ;

 

/* check_error - calls print_error(), checks severity of return code */

 

SQLRETURN check_error( SQLSMALLINT htype, /* A handle type identifier */

SQLHANDLE hndl, /* A handle */

SQLRETURN frc, /* Return code to be included with error msg */

int line, /* Used for output message, indcate where */

char * file /* the error was reported from */

) {

 

print_error( htype, hndl, frc, line, file ) ;

 

switch ( frc ) {

case SQL_SUCCESS:

break ;

case SQL_INVALID_HANDLE:

printf( "\n>------ ERROR Invalid Handle --------------------------\n" ) ;

case SQL_ERROR:

printf( "\n>--- FATAL ERROR, Attempting to rollback transaction --\n" ) ;

if ( SQLEndTran( htype, hndl, SQL_ROLLBACK ) != SQL_SUCCESS )

printf( ">Rollback Failed, Exiting application\n" ) ;

else

printf( ">Rollback Successful, Exiting application\n" ) ;

return( terminate( hndl, frc ) ) ;

case SQL_SUCCESS_WITH_INFO:

printf( "\n> ----- Warning Message, application continuing ------- \n" ) ;

break ;

case SQL_NO_DATA_FOUND:

printf( "\n> ----- No Data Found, application continuing --------- \n" ) ;

break ;

default:

printf( "\n> ----------- Invalid Return Code --------------------- \n" ) ;

printf( "> --------- Attempting to rollback transaction ---------- \n" ) ;

if ( SQLEndTran( htype, hndl, SQL_ROLLBACK ) != SQL_SUCCESS )

printf( ">Rollback Failed, Exiting application\n" ) ;

else

printf( ">Rollback Successful, Exiting application\n" ) ;

return( terminate( hndl, frc ) ) ;

}

 

return ( frc ) ;

 

}

 

/* connect without prompt */

 

SQLRETURN DBconnect( SQLHANDLE henv,

SQLHANDLE * hdbc

) {

 

/* allocate a connection handle */

if ( SQLAllocHandle( SQL_HANDLE_DBC,

henv,

hdbc

) != SQL_SUCCESS ) {

printf( ">---ERROR while allocating a connection handle-----\n" ) ;

return( SQL_ERROR ) ;

}

 

/* Set AUTOCOMMIT OFF */

if ( SQLSetConnectAttr( * hdbc,

SQL_ATTR_AUTOCOMMIT,

( void * ) SQL_AUTOCOMMIT_OFF, SQL_NTS

) != SQL_SUCCESS ) {

printf( ">---ERROR while setting AUTOCOMMIT OFF ------------\n" ) ;

return( SQL_ERROR ) ;

}

 

if ( SQLConnect( * hdbc,

server, SQL_NTS,

uid, SQL_NTS,

pwd, SQL_NTS

) != SQL_SUCCESS ) {

printf( ">--- Error while connecting to database: %s -------\n",

server

) ;

SQLDisconnect( * hdbc ) ;

SQLFreeHandle( SQL_HANDLE_DBC, * hdbc ) ;

return( SQL_ERROR ) ;

}

else /* Print Connection Information */

printf( ">Connected to %s\n", server ) ;

 

return( SQL_SUCCESS ) ;

 

}

 

/* print connection information */

 

SQLRETURN print_connect_info( SQLHANDLE hdbc ) {

 

SQLCHAR buffer[255] ;

SQLSMALLINT outlen ;

SQLRETURN rc ;

 

printf( "-------------------------------------------\n" ) ;

 

rc = SQLGetInfo( hdbc, SQL_DATA_SOURCE_NAME, buffer, 255, &outlen ) ;

CHECK_HANDLE( SQL_HANDLE_DBC, hdbc, rc ) ;

printf( "Connected to Server: %s\n", buffer ) ;

 

rc = SQLGetInfo( hdbc, SQL_DATABASE_NAME, buffer, 255, &outlen ) ;

CHECK_HANDLE( SQL_HANDLE_DBC, hdbc, rc ) ;

printf( " Database Name: %s\n", buffer ) ;

 

rc = SQLGetInfo( hdbc, SQL_SERVER_NAME, buffer, 255, &outlen ) ;

CHECK_HANDLE( SQL_HANDLE_DBC, hdbc, rc ) ;

printf( " Instance Name: %s\n", buffer ) ;

 

rc = SQLGetInfo( hdbc, SQL_DBMS_NAME, buffer, 255, &outlen ) ;

CHECK_HANDLE( SQL_HANDLE_DBC, hdbc, rc ) ;

printf( " DBMS Name: %s\n", buffer ) ;

 

rc = SQLGetInfo( hdbc, SQL_DBMS_VER, buffer, 255, &outlen ) ;

CHECK_HANDLE( SQL_HANDLE_DBC, hdbc, rc ) ;

printf( " DBMS Version: %s\n", buffer ) ;

 

printf( "-------------------------------------------\n" ) ;

 

return( rc ) ;

 

}

 

/*--> SQLL1X32.SCRIPT */

/* print_error - calls SQLGetDiagRec(), displays SQLSTATE and message **

** - called by check_error */

 

SQLRETURN print_error( SQLSMALLINT htype, /* A handle type identifier */

SQLHANDLE hndl, /* A handle */

SQLRETURN frc, /* Return code to be included with error msg */

int line, /* Used for output message, indcate where */

char * file /* the error was reported from */

) {

 

SQLCHAR buffer[SQL_MAX_MESSAGE_LENGTH + 1] ;

SQLCHAR SQLSTATE[SQL_SQLSTATE_SIZE + 1] ;

SQLINTEGER sqlcode ;

SQLSMALLINT length, i ;

 

printf( ">--- ERROR -- RC = %d Reported from %s, line %d ------------\n",

frc,

file,

line

) ;

 

i = 1 ;

while ( SQLGetDiagRec( htype,

hndl,

i,

SQLSTATE,

&sqlcode,

buffer,

SQL_MAX_MESSAGE_LENGTH + 1,

&length

) == SQL_SUCCESS ) {

printf( " SQLSTATE: %s\n", SQLSTATE ) ;

printf( "Native Error Code: %ld\n", sqlcode ) ;

printf( "%s \n", buffer ) ;

i++ ;

}

 

printf( ">--------------------------------------------------\n" ) ;

 

return( SQL_ERROR ) ;

 

}

/*<-- */

 

/*--> SQLL1X10.SCRIPT */

/* print_results */

 

SQLRETURN print_results( SQLHANDLE hstmt ) {

 

SQLCHAR colname[32] ;

SQLSMALLINT coltype ;

SQLSMALLINT colnamelen ;

SQLSMALLINT nullable ;

SQLUINTEGER collen[MAXCOLS] ;

SQLSMALLINT scale ;

SQLINTEGER outlen[MAXCOLS] ;

SQLCHAR * data[MAXCOLS] ;

SQLCHAR errmsg[256] ;

SQLRETURN rc ;

SQLSMALLINT nresultcols, i ;

SQLINTEGER displaysize ;

 

rc = SQLNumResultCols( hstmt, &nresultcols ) ;

CHECK_HANDLE( SQL_HANDLE_STMT, hstmt, rc ) ;

if( rc != SQL_SUCCESS )

{

return( rc );

}

for ( i = 0; i < nresultcols; i++ ) {

SQLDescribeCol( hstmt,

( SQLSMALLINT ) ( i + 1 ),

colname,

sizeof(colname),

&colnamelen,

&coltype,

&collen,

&scale,

NULL

) ;

/* get display length for column */

SQLColAttribute( hstmt,

( SQLSMALLINT ) ( i + 1 ),

SQL_DESC_DISPLAY_SIZE,

NULL,

0,

NULL,

&displaysize

) ;

 

/*

Set column length to max of display length,

and column name length. Plus one byte for

null terminator.

*/

collen = max( displaysize,

strlen( ( char * ) colname )

) + 1 ;

 

printf( "%-*.*s",

( int ) collen,

( int ) collen,

colname

) ;

 

/* allocate memory to bind column */

data = ( SQLCHAR * ) malloc( ( int ) collen ) ;

 

/* bind columns to program vars, converting all types to CHAR */

SQLBindCol( hstmt,

( SQLSMALLINT ) ( i + 1 ),

SQL_C_CHAR,

data,

collen,

&outlen

) ;

}

 

printf( "\n" ) ;

/* display result rows */

rc = SQLFetch( hstmt ) ;

while ( (rc == SQL_SUCCESS) || (rc == SQL_SUCCESS_WITH_INFO) ) {

 

errmsg[0] = '\0' ;

for ( i = 0; i < nresultcols; i++ ) {

/* Check for NULL data */

if ( outlen == SQL_NULL_DATA )

printf( "%-*.*s",

( int ) collen,

( int ) collen,

"NULL"

) ;

else { /* Build a truncation message for any columns truncated */

if ( outlen >= collen ) {

sprintf( ( char * ) errmsg + strlen( ( char * ) errmsg ),

"%d chars truncated, col %d\n",

( int ) outlen - collen + 1,

i + 1

) ;

}

/* Print column */

printf( "%-*.*s",

( int ) collen,

( int ) collen,

data

) ;

}

} /* for all columns in this row */

 

printf( "\n%s", errmsg ) ; /* print any truncation messages */

rc = SQLFetch( hstmt ) ;

} /* while rows to fetch */

if ( rc != SQL_NO_DATA_FOUND )

{

CHECK_HANDLE( SQL_HANDLE_STMT, hstmt, rc );

}

 

 

/* free data buffers */

for ( i = 0; i < nresultcols; i++ ) {

free( data ) ;

}

 

return( SQL_SUCCESS ) ;

 

} /* end print_results */

/*<-- */

 

/* prompted_connect - prompt for connect options and connect */

 

SQLRETURN prompted_connect( SQLHANDLE henv,

SQLHANDLE * hdbc

) {

 

/* allocate a connection handle */

if ( SQLAllocHandle( SQL_HANDLE_DBC,

henv,

hdbc

) != SQL_SUCCESS ) {

printf( ">---ERROR while allocating a connection handle-----\n" ) ;

return( SQL_ERROR ) ;

}

 

/* Set AUTOCOMMIT OFF */

if ( SQLSetConnectAttr( * hdbc,

SQL_ATTR_AUTOCOMMIT,

( void * ) SQL_AUTOCOMMIT_OFF, SQL_NTS

) != SQL_SUCCESS ) {

printf( ">---ERROR while setting AUTOCOMMIT OFF ------------\n" ) ;

return( SQL_ERROR ) ;

}

 

printf( ">Enter Server Name:\n" ) ;

gets( ( char * ) server ) ;

printf( ">Enter User Name:\n" ) ;

gets( ( char * ) uid ) ;

printf( ">Enter Password:\n" ) ;

gets( ( char * ) pwd ) ;

 

if ( SQLConnect( * hdbc,

server, SQL_NTS,

uid, SQL_NTS,

pwd, SQL_NTS

) != SQL_SUCCESS ) {

printf( ">--- ERROR while connecting to %s -------------\n",

server

) ;

 

SQLDisconnect( * hdbc ) ;

SQLFreeHandle( SQL_HANDLE_DBC, * hdbc ) ;

return( SQL_ERROR ) ;

}

else /* Print Connection Information */

printf( "Successful Connect to %s\n", server ) ;

 

return( SQL_SUCCESS ) ;

 

}

 

/* terminate and free environment handle */

 

SQLRETURN terminate( SQLHANDLE henv,

SQLRETURN rc

) {

 

SQLRETURN lrc ;

 

printf( ">Terminating ....\n" ) ;

print_error( SQL_HANDLE_ENV,

henv,

rc,

__LINE__,

__FILE__

) ;

 

/* Free environment handle */

if ( ( lrc = SQLFreeHandle( SQL_HANDLE_ENV, henv ) ) != SQL_SUCCESS )

print_error( SQL_HANDLE_ENV,

henv,

lrc,

__LINE__,

__FILE__

) ;

 

return( rc ) ;

 

}

 

>>양승윤 님께서 쓰시길<<

 

:: db2 억세스 하는 c 소스 있으신분 셈플좀 보내주세요...

:: 코불 소스는 있는데...c 소스가 없어어요....

:: 미리 감사드리며...

:: 그럼..

::

[Top]
No.
제목
작성자
작성일
조회
89as400 db2 파워빌더에서 연결방법....
양승윤
2001-07-04
11364
111┕>Re: as400 db2 파워빌더에서 연결방법....
설덕환
2001-08-20 20:12:39
13763
86[부탁]DB2와 ASP, Java Servlet 연동 방안
완전초보
2001-06-29
10943
87┕>Re: [부탁]DB2와 ASP, Java Servlet 연동 방안 [1]
조율제
2001-06-30 01:01:36
12115
85db2 정보센터가 어디입니까...?
양승윤
2001-06-29
11052
88┕>Re: db2 정보센터가 어디입니까...?
조율제
2001-06-30 12:13:11
11703
82db2 억세스 하는 c 소스 있으신분...
양승윤
2001-06-28
11451
83┕>Re: db2 억세스 하는 c 소스 있으신분...
조율제
2001-06-28 14:13:37
14502
81에러 로그 파일의 메시지 분석....
임원희
2001-06-28
11561
84┕>Re: 에러 로그 파일의 메시지 분석....
조율제
2001-06-28 14:44:26
12019
75DB2사용방법
지서니
2001-06-16
12664
77┕>Re: DB2사용방법
김태상
2001-06-26 10:20:03
14397
74db conversion
강영은
2001-06-15
11258
76┕>Re: db conversion
조율제
2001-06-16 13:36:28
11823
78 ┕>Re: Re: db conversion
김태상
2001-06-26 10:22:42
11528
80  ┕>Re: Re: Re: db conversion
조율제
2001-06-26 15:52:37
11754
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.033초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다