1.1 What’s New

Table of Contents Previous Next


1 Introduction : 1.1 What’s New

The following database compatibility for Oracle features have been added to Advanced Server 9.5 to create Advanced Server 9.6:
Advanced Server now supports use of the Postgres password file to initially log into EDB*Plus or to change the connection to EDB*Plus with the CONNECT command. This capability provides additional security in that the user’s password is not exposed when making the connection to EDB*Plus. For more information, see Sections 2.1 and 2.2.6.
Advanced Server now supports the SET TRIMSPOOL command in EDB*Plus to trim trailing spaces from each output line in the file specified by the SPOOL command. For more information, see Section 2.2.26.
Advanced Server now supports additional functionality for EDB*Loader including use of a column name in the field condition of the WHEN clause to control loading of data records into the specified table, the RECORDS DELIMITED BY clause to specify a character other than the default newline character to terminate each record in the data file, the BOUNDFILLER clause for preventing the use of a field in the data file for loading a column in a table, but allowing it to be used in an expression for a subsequent column, specification of the length for a data type in the control file’s description of the data record, for example CHAR(3), support of the NULLIF clause to set a column to null if the field condition evaluates to TRUE, and use of a SELECT statement in the expression of a field definition to return a value for a column. For more information, see Section 3.2.

1 Introduction : 1.1 What’s New

Table of Contents Previous Next