Versions Compared

Old Version 16

changes.mady.by.user OO_heerock

Saved on

compared with

New Version Current

changes.mady.by.user OO_heerock

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents


Overview

ALTIBASE HDB's directory object is almost identical to ORACLE.

Notices

There are some notices to bear in mind prior to handling DIRECTORY object.

  • To use a DIRECTORY, the creation of the DIRECTORY object should be in advance.
  • READ/WRITE Privilege for corresponding directory should be granted to user.
  • The directory parameter must be specified in upper-case letters.
    v1 := fopen(‘MYDIR’, ‘data1.dat’, ‘w’);
  • File open mode should be in the lower case, duplicate use is prohibited.
     

Restriction on the Directory name

Even if the name of the directory object was specified in lower-case letters, the names of all objects are stored in upper-case letters in the database.

Therefore when specifying the name of a directory object as a parameter for a system procedure or function, it is necessary to use upper-case letters.

Example

ORACLE

ALTIBASE HDB

Comments

CREATE [OR REPLACE] DIRECTORY mydir AS '/dir/file_data';
DROP DIRECTORY mydir;

CREATE [OR REPLACE] DIRECTORY mydir AS '/dir/file_data' ;
DROP DIRECTORY mydir;

 

CREATE DIRECTORY ALTI AS ‘/altibase’;

CREATE OR REPLACE PROCEDURE bulk_insert
AS
  vFile UTL_FILE.FILE_TYPE;
  c1 INTEGER;
BEGIN
  vFile := UTL_FILE.FOPEN(‘ALTI’, ‘data1.dat’, ‘w’);
  FOR c1 IN 1 .. 5000000 LOOP
    UTL_FILE.PUT_LINE(vFile, c1||','||c1||','||LPAD(c1,10,'0')||','||
LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||','||
LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||','||
TO_CHAR(sysdate,'YYYYMMDDHHMISS'));
  END LOOP;
  UTL_FILE.FFLUSH(vFile);
  UTL_FILE.FCLOSE(vFile);
END;
/

CREATE OR REPLACE DIRECTORY alti AS ‘/altibase’;

CREATE OR REPLACE PROCEDURE bulk_insert
AS  v1 FILE_TYPE;
c1 INTEGER;
BEGIN
v1 := fopen(‘ALTI’, ‘data1.dat’, ‘w’);
FOR c1 IN 1 .. 5000000 LOOP
PUT_LINE(v1, c1||','||c1||','||LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||','||
LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||','||LPAD(c1,10,'0')||
','||TO_CHAR(sysdate,'YYYYMMDDHHMISS'));
END LOOP;
FFLUSH(v1);
FCLOSE(v1);
END;/