MX Release 3.2 (H06.25+, J06.14+)

-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).

• Ensure that the ODBCMSG is present in $SYSTEM.SYSTEM.

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 @@@

// 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.

Execution and Testing of Sample ODBC Application 51