Altibase Performance Solutions

AID (Altibase Information Directory)1-10 / 44건

  • ERR-31283 Unable to create a primary key or a unique key constraint in the local non-prefixed indexㅣ 2014-10-16
    Version 6.1.1 or below Explanation Unable to create a non-prefixed index on a partitioned table using the primary key or unique key. This error message is output when a user tries to create a primary key or a unique key constraint in the local non-prefixed in
    [FAQ(English)]
  • ERR-31283 Unable to create a primary key or a unique key constraint in the local non-prefixed index.ㅣ 2014-08-18
    UNIQUE INDEX로 생성할 수 있습니다. 3. 알티베이스를 6.3.1 이상 버전으로 업그레이드 하면 global index로 PK나 UNIQUE INDEX 생성이 가능합니다. # 예제 iSQL> CREATE TABLE REALSET_CONTENTS 2 ( 3 CT_ID VARCHAR (32) NOT NULL, 4
    [FAQ(한국어)]
  • Table/Column Definitionㅣ 2021-03-24
    UNIQUE', 3, 'PK', 4, 'NULL', 5, 'TIMESTAMP', 6, 'LOCAL UNIQUE', 7, 'CHECK') CONST_TYPE , CONST.CHECK_CONDITION , C.COLUMN_ORDER 'COLUMN_ORDER' FROM SYSTEM_.SYS_USERS_ U , SYSTEM_.SYS_TABLES_ T , SYSTEM_.SYS_COLUMNS_ C LEFT OUTER JOIN system_.SYS_CONSTRAINT_C
    [FAQ(English)]
  • Notes/Considerations when changing TRANSACTION_TABLE_SIZEㅣ 2021-03-11
    TABLE_SIZE in altibase.propertiesRecreate databaseUpload data to the backup backed up in 2Startup Altibase serverWhen it is possible to change to offlineSecuring service downtimeAltibase server shutdownChange TRANSACTION_TABLE_SIZE in altibase.propertiesStart
    [FAQ(English)]
  • Create database object and upload dataㅣ 2021-03-18
    tables $ ls -l *.log|wc -l # Check the number of log files created by running run_il_in.sh $ cat *.log | grep 'Error Row Count' | awk -F: '{print $2' | wc -l # The number of these results should match the number of the two results above. If it is different, i
    [FAQ(English)]
  • 2. SQL Conversionㅣ 2020-08-11
    CREATE OR REPLACE PROCEDURE ForCursor_TestASBEGINDECLARE CURSOR dept_sum ISSELECT b.dname, COUNT(a.empno) cnt, SUM(a.sal) salaryFROM emp a, dept bWHERE a.deptno = b.deptnoGROUP BY b.dname;– Execute Cursor in the FOR statement. BEGINFOR emp_list IN dept_
    [Technical Documents(English)]
  • 1. Object 변환ㅣ 2014-12-03
    UNIQUE UNIQUE CLUSTERED | NONCLUSTERED N/A ASC | DESC ASC | DESC INCLUDE N/A filter_predicate N/A partition_scheme_name PARTITION ON Local Index만 지원 ON filegroup_name N/A table_or_view_name Table_name View는 지원하지 않음 PAD_INDEX N/A FILLFACTOR
    [Technical Documents(한국어)]
  • 1. Object Conversionㅣ 2020-08-11
    UNIQUE UNIQUE CLUSTERED, NONCLUSTERED N/A FOREIGN KEY REFERENCES FOREIGN KEY REFERENCES partition_scheme_name PARTITION BY RANGE | HASH | LIST When creating a table, specify the partition table type 4. computed column definition Not supported 5. table constra
    [Technical Documents(English)]
  • 65. MSSQL to Altibase 변환가이드ㅣ 2014-12-03
    TABLE VIEW 지원 지원하지 않음 SEQUENCE 지원 지원 STORED FUNCTION/PROCEDURE 지원 지원 SYNONYM 지원 지원 TABLE Temporary Table 지원 지원 Temporary Table은 Volatile Table Space 이용 USER 지원 지원 REPLICATION 지원 지원 CREATE T
    [Technical Documents(한국어)]
  • 2-1 Object Conversionㅣ 2020-08-11
    UNIQUE are specified, only the Tablespace clause, Parallel clause, Logging clause, and Force clause can be specified in the Using Index clause. That is, the index name and CREATE INDEX clause are not provided. Ref Constraint statement - Since the REF column i
    [Technical Documents(English)]