Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE EXTERNAL TABLE StatementUse the CREATE EXTERNAL TABLE statement to define an external source that is not part of your database to load and unload data for your database.
External Table Examples The examples in this section illustrate different ways to load and unload data using external tables.
Unloading Data to External Tables from HCL OneDB™You unload data by creating an external table and inserting the data into it, or by selecting data from an internal table into an external file.
Adding an End-of-Line Character to a Fixed Text FileYou can add an end-of-line character to each line of a fixed-text file to use the file for other applications.
Using a Program or ScriptTo add an end-of-line character, you can write the fixed-length records to a data file and then modify the data file with a program or script.

Using a Program or Script

To add an end-of-line character, you can write the fixed-length records to a data file and then modify the data file with a program or script.

About this task

For example, you could use a C program to find the length of each record, locate the end of a line, and then add an end-of-line character.