Product specifications

Contents
Document History.................................................................................................................11Chapter 1
Introduction to data access guide.........................................................................................13Chapter 2
About the data access guide..................................................................................................13
2.1
Audience of the guide............................................................................................................13
2.2
What's new?..........................................................................................................................13
2.3
Key tasks...............................................................................................................................14
2.4
Conventions of the guide.......................................................................................................15
2.5
Introduction to data access...................................................................................................17Chapter 3
About Connection Server.......................................................................................................17
3.1
Components of a connection.................................................................................................17
3.2
System architecture...............................................................................................................18
3.2.1
Data access drivers...............................................................................................................18
3.2.2
Data access configuration files...............................................................................................19
3.3
About the cs.cfg global configuration file................................................................................19
3.3.1
About the driver configuration files.........................................................................................20
3.3.2
Deployment mode..................................................................................................................21
3.4
Connectivity services.............................................................................................................22
3.5
Learning data access specifics.............................................................................................25Chapter 4
64-bit operating system support.............................................................................................25
4.1
64-bit UNIX support...............................................................................................................25
4.1.1
64-bit Microsoft Windows support.........................................................................................26
4.1.2
Installation of ODBC drivers...................................................................................................27
4.1.3
Single sign-on support...........................................................................................................27
4.2
Stored procedures.................................................................................................................28
4.3
Supported database capabilities.............................................................................................29
4.3.1
Oracle stored procedures......................................................................................................29
4.3.2
To create a cursor inside a package.......................................................................................30
4.3.3
To create an Oracle stored procedure....................................................................................30
4.3.4
Teradata stored procedures...................................................................................................31
4.3.5
2012-03-153