Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
-set systype oss -set FLOATTYPE IEEE_FLOAT -call_shared -set data_model lp64 \
-set highpin on -set highrequestor on \
-lcpp3 -lcppc -lcrtl -lcre -linet -lyputdll \
-l<Location of yodbcdll>/yodbcdll /usr/lib/cmain64.o Thread_PUT_Test.o
ThreadODBCTestAppl.o
Execution and Testing of Sample ODBC Application
To run the sample test application, issue any of the following commands on the OSS shell:
OSS> ./ODBCTest <DS Name>
OSS> ./ODBCTest –help
Considerations
• Ensure that the location of the OSS ODBC/MX driver (ZODBCDLL) is set as the env variable
_RLD_FIRST_LIB_PATH. To set the _RLD_FIRST_LIB_PATH variable, run the following
command:
• Ensure that the ODBCDSN file is present in the same location as that of the sample application.
If not present, ensure that the default ODBCDSN file is present in $SYSTEM.SYSTEM.
• To enable tracing, ensure that the TraceStart parameter in the ODBCDSN file is set to one
(1).
The ODBCDSN file must be edited to include the DSN you wish to use, with all the mandatory
fields.
Sample ODBC Application Code
/***************************************************************
*****
//
// @@@ START COPYRIGHT @@@
//
// Copyright 2007
//
// HP CONFIDENTIAL: NEED TO KNOW ONLY
//
// Copyright Hewlett-Packard Development Company, L.P.
// Protected as an unpublished work.
//
// The computer program listings, specifications and
// documentation herein are the property of Hewlett-Packard
// Development Company, L.P., or a third party supplier and
// shall not be reproduced, copied, disclosed, or used in whole
// or in part for any reason without the prior express written
// permission of Hewlett-Packard
// Development Company, L.P.
//
// @@@ END COPYRIGHT @@@
***************************************************************/
/***************************************************************
@@@@ ODBC TEST APPLICATION @@@
================================================================
This application utilizes ::
- Multiple connections
- Gives information about DBMS NAME
- ODBC API's
- Uses insertion through parameter marker,
- Setting the transaction isolation level as serializable and
fetches the data.
****************************************************************
******/
54 Sample ODBC Application