Tibero
		Next

Tibero Utility Guide

Tibero 5 SP1

Copyright © 2014 TmaxData Co., Ltd. All Rights Reserved.

Restricted Rights Legend

All TmaxData Software (Tibero^®) and documents are protected by copyright laws and international convention. TmaxData software and documents are made available under the terms of the TmaxData License Agreement and may only be used or copied in accordance with the terms of this agreement. No part of this document may be transmitted, copied, deployed, or reproduced in any form or by any means, electronic, mechanical, or optical, without the prior written consent of TmaxData Co., Ltd.

Trademarks

Tibero^® is a registered trademark of TmaxData Co., Ltd. Other products, titles or services may be registered trademarks of their respective companies.

Open Source Software Notice

This product includes open source software developed and/or licensed by "OpenSSL," "RSA Data Security, Inc.," "Apache Foundation," "Jean-loup Gailly and Mark Adler," and "Paul Hsieh's hash". Information about the aforementioned and the related open source software can be found in the "${INSTALL_PATH}/license/oss_licenses" directory.

Manual Information

Title: Tibero Utility Guide

Publication Date: 2014-08-01

Product Number: Tibero 5 SP1

Edition: 2.1.1

Table of Contents

About This Document

1.1. Overview

1.2. Quick Start

1.2.1. Executing Utility
1.2.2. Accessing Database
1.2.3. Interface
1.2.4. Configuration Environment
1.2.5. Terminating Utility

1.3. System Variables

1.4. Basic Functions

1.4.1. Entering Commands
1.4.2. Executing Commands
1.4.3. Other Functions

1.5. Advanced Functions

1.5.1. Script Functions
1.5.2. DBA Functions
1.5.3. Encrypting Connection String

1.6. Command

1.7. Column Format

1.7.1. Character Type
1.7.2. Numeric Type

2. tbMigrator 2.0

2.1. Overview

2.2. Screen Layout

2.2.1. Main Screen
2.2.2. Option Screen
2.2.3. Progress Screen
2.2.4. Report Screen

2.3. Target Object

2.4. Access User Permission

2.5. Operation Example

3. tbExport

3.1. Overview

3.2. Features

3.3. Quick Start

3.3.1. Preparation before Execution
3.3.2. Export Mode
3.3.3. Executing tbExport

3.4. Specifying Parameters in the Command Prompt

3.4.1. List of Parameters

3.5. Operation Example

4. tbImport

4.1. Overview

4.2. Quick Start

4.2.1. Preparation before Execution
4.2.2. Import Mode
4.2.3. Executing tbImport

4.3. Operation Method

4.3.1. Importing the Table that Has Constraints
4.3.2. Importing the Compatible Table
4.3.3. Importing Data into a Table that Already Exists

4.4. Specifying Parameters in the Command Prompt

4.4.1. List of Parameters

4.5. Operation Example

5. tbLoader

5.1. Overview

5.2. Quick Start

5.3. I/O File

5.3.1. Control File
5.3.2. Data File
5.3.3. Log File
5.3.4. Error File

5.4. Load Methods

5.5. Constraints

5.5.1. Use of the Same Separator
5.5.2. When the ESCAPED BY Option Is Not Specified

5.6. Whitespace Policy

5.6.1. When an Entire Field Value Is Whitespace
5.6.2. When the Part of a Field Value Is Whitespace
5.6.3. When Spaces in a Field Value Are Recognized As Data

5.7. Specifying Parameters in the Command Prompt

5.7.1. List of Parameters

5.8. Advanced Functions

5.8.1. Parallel DPL
5.8.2. Access Information Encryption

5.9. Specifying Control File Options

5.9.1. CHARACTERSET
5.9.2. INFILE
5.9.3. LOGFILE
5.9.4. BADFILE
5.9.5. Handling Existing Data
5.9.6. PRESERVE BLANKS
5.9.7. Specifying Tables
5.9.8. Creating Indexes
5.9.9. FIELDS TERMINATED BY
5.9.10. FIELDS OPTIONALLY ENCLOSED BY
5.9.11. FIELDS ENCLOSED BY
5.9.12. LINES FIX
5.9.13. LINES STARTED BY
5.9.14. LINES TERMINATED BY
5.9.15. TRAILING NULLCOLS
5.9.16. IGNORE LINES
5.9.17. Target Column and Properties
5.9.18. Comment Insertion

5.10. Operation Example

5.10.1. Separated Record Format
5.10.2. Fixed Record Format - When Record Separator is EOL
5.10.3. Fixed Record Format - In the Case of a Fixed Length Record
5.10.4. When Mass Object Type Data Is Included

6. Utility API

6.1. Header File

6.2. Structure

6.3. Utility API List

6.3.1. TBConnect
6.3.2. TBDisconnect
6.3.3. TBExport
6.3.4. TBImport

List of Figures

[Figure 2.1] Main Screen
[Figure 2.2] Full Mode
[Figure 2.3] Schema Mode
[Figure 2.4] Table Mode
[Figure 2.5] Option Screen
[Figure 2.6] Object Type Selection
[Figure 2.7] Progress Screen
[Figure 2.8] Report Screen
[Figure 2.9] Main Screen
[Figure 2.10] Migration - Source Database Access Information
[Figure 2.11] Migration - Target Database Access Information
[Figure 2.12] Migration -The Setting of Migration Options
[Figure 2.13] Migration-Warning Message
[Figure 2.14] Migration - Selecting Targets and Performing Migration
[Figure 2.15] Migration- Checking Migration Progress
[Figure 2.16] Migration - Migration Report Screen
[Figure 2.17] Migration - Migration Complete
[Figure 2.18] Migration - Migration Complete Dialog
[Figure 3.1] Export Mode
[Figure 4.1] Import Mode

List of Examples

[Example 1.1] Executing tbSQL utility
[Example 1.2] Accessing Database by using the tbSQL Utility
[Example 3.1] Executing the tbExport utility
[Example 3.2] Executing Export by Using the tbExport Utility
[Example 4.1] Executing the tbImport Utility
[Example 4.2] Executing Import using the tbImport utility
[Example 5.1] Executing the tbLoader Utility
[Example 5.2] Parameters of the tbLoader Utility that can be Specified in the Command Prompt
[Example 5.3] tbLoader Execution Example using Parallel DPL
[Example 5.4] tbLoader Execution Example using the Encryption File (wallet)

		Next
		About This Document

Copyright © 2014 TmaxData Co., Ltd. All Rights Reserved.