Votes - 0, Average rating: 0
(
)
)
|
Other manuals for this model:
manual abstract
Document Outline
- HP NonStop SQL/MX Reference Manual
- Legal Notices
- Contents
- What's New in This Manual
- Manual Information
- New and Changed Information
- About This Manual
- 1 Introduction
- 2 SQL/MX Statements
- Categories
- Data Definition Language (DDL) Statements
- Data Manipulation Language (DML) Statements
- Transaction Control Statements
- Prepared SQL Statements
- Embedded-Only SQL/MX Statements
- Resource Control and Optimization Statements
- Control Statements
- Object Naming Statements
- Alias Statements
- Stored Procedure Statements
- Trigger Statements
- ALTER INDEX Statement
- ALTER SQLMP ALIAS Statement
- ALTER TABLE Statement
- ALTER TRIGGER Statement
- BEGIN WORK Statement
- CALL Statement
- COMMIT WORK Statement
- CONTROL QUERY DEFAULT Statement
- CONTROL QUERY SHAPE Statement
- CONTROL TABLE Statement
- CREATE CATALOG Statement
- CREATE INDEX Statement
- CREATE PROCEDURE Statement
- CREATE SCHEMA Statement
- CREATE SQLMP ALIAS Statement
- CREATE TABLE Statement
- CREATE TRIGGER Statement
- CREATE VIEW Statement
- DELETE Statement
- DROP CATALOG Statement
- DROP INDEX Statement
- DROP PROCEDURE Statement
- DROP SCHEMA Statement
- DROP SQL Statement
- DROP SQLMP ALIAS Statement
- DROP TABLE Statement
- DROP TRIGGER Statement
- DROP VIEW Statement
- EXECUTE Statement
- EXPLAIN Statement
- GRANT Statement
- GRANT EXECUTE Statement
- INITIALIZE SQL Statement
- INSERT Statement
- LOCK TABLE Statement
- PREPARE Statement
- REGISTER CATALOG Statement
- REVOKE Statement
- REVOKE EXECUTE Statement
- ROLLBACK WORK Statement
- SELECT Statement
- SET Statement
- SET CATALOG Statement
- SET MPLOC Statement
- SET NAMETYPE Statement
- SET SCHEMA Statement
- SET TABLE TIMEOUT Statement
- SET TRANSACTION Statement
- SIGNAL SQLSTATE Statement
- TABLE Statement
- UNLOCK TABLE Statement
- UNREGISTER CATALOG Statement
- UPDATE Statement
- UPDATE STATISTICS Statement
- VALUES Statement
- Categories
- 3 Embedded-Only SQL/MX Statements
- ALLOCATE CURSOR Statement
- ALLOCATE DESCRIPTOR Statement
- BEGIN DECLARE SECTION Declaration
- CLOSE Statement
- Compound (BEGIN...END) Statement
- DEALLOCATE DESCRIPTOR Statement
- DEALLOCATE PREPARE Statement
- DECLARE CATALOG Declaration
- DECLARE CURSOR Declaration
- DECLARE MPLOC Declaration
- DECLARE NAMETYPE Declaration
- DECLARE SCHEMA Declaration
- DESCRIBE Statement
- END DECLARE SECTION Declaration
- EXEC SQL Directive
- EXECUTE IMMEDIATE Statement
- FETCH Statement
- GET DESCRIPTOR Statement
- GET DIAGNOSTICS Statement
- IF Statement
- INVOKE Directive
- MODULE Directive
- OPEN Statement
- SET (Assignment) Statement
- SET DESCRIPTOR Statement
- WHENEVER Declaration
- 4 MXCI Commands
- ADD DEFINE Command
- ALTER DEFINE Command
- CD Command
- DELETE DEFINE Command
- DISPLAY USE OF Command
- DISPLAY USE OF SOURCE
- DISPLAY USE OF ALL | INVALID MODULES
- DISPLAY_QC Command
- DISPLAY_QC_ENTRIES Command
- DISPLAY STATISTICS Command
- ENV Command
- ERROR Command
- Exclamation Point (!) Command
- EXIT Command
- FC Command
- GTACL Command
- HISTORY Command
- INFO DEFINE Command
- INVOKE Command
- LOG Command
- LS Command
- MODE Command
- MXCI Command
- OBEY Command
- REPEAT Command
- RESET PARAM Command
- SET LIST_COUNT Command
- SET PARAM Command
- SET SHOWSHAPE Command
- SET STATISTICS Command
- SET TERMINAL_CHARSET Command
- SET WARNINGS Command
- SH Command
- SHOW PARAM Command
- SHOW PREPARED Command
- SHOW SESSION Command
- SHOWCONTROL Command
- SHOWDDL Command
- SHOWLABEL Command
- SHOWSHAPE Command
- 5 SQL/MX Utilities
- Privileges Required to Execute Utilities
- Checking File Locks
- DUP Utility
- FASTCOPY Utility
- FIXUP Operation
- GOAWAY Operation
- import Utility
- INFO Operation
- migrate Utility
- MODIFY Utility
- mxexportddl Utility
- MXGNAMES Utility
- mximportddl Utility
- mxtool Utility
- POPULATE INDEX Utility
- PURGEDATA Utility
- RECOVER Utility
- VERIFY Operation
- 6 SQL/MX Language Elements
- 7 SQL/MX Clauses
- 8 SQL/MX File Attributes
- 9 SQL/MX Functions and Expressions
- Categories
- ABS Function
- ACOS Function
- ASCII Function
- ASIN Function
- ATAN Function
- ATAN2 Function
- AVG Function
- CASE (Conditional) Expression
- CAST Expression
- CEILING Function
- CHAR Function
- CHAR_LENGTH Function
- CODE_VALUE Function
- COMPILERCONTROLS Function
- CONCAT Function
- CONVERTTIMESTAMP Function
- COS Function
- COSH Function
- COUNT Function
- CURRENT Function
- CURRENT_DATE Function
- CURRENT_TIME Function
- CURRENT_TIMESTAMP Function
- CURRENT_USER Function
- DATEFORMAT Function
- DAY Function
- DAYNAME Function
- DAYOFMONTH Function
- DAYOFWEEK Function
- DAYOFYEAR Function
- DEGREES Function
- DIFF1 Function
- DIFF2 Function
- EXP Function
- EXPLAIN Function
- EXTRACT Function
- FLOOR Function
- HASHPARTFUNC Function
- HOUR Function
- INSERT Function
- JULIANTIMESTAMP Function
- LASTNOTNULL Function
- LCASE Function
- LEFT Function
- LOCATE Function
- LOG Function
- LOG10 Function
- LOWER Function
- LPAD Function
- LTRIM Function
- MAX Function
- MIN Function
- MINUTE Function
- MOD Function
- MONTH Function
- MONTHNAME Function
- MOVINGAVG Function
- MOVINGCOUNT Function
- MOVINGMAX Function
- MOVINGMIN Function
- MOVINGSTDDEV Function
- MOVINGSUM Function
- MOVINGVARIANCE Function
- OCTET_LENGTH Function
- OFFSET Function
- PI Function
- POSITION Function
- POWER Function
- QUARTER Function
- QUERYCACHE Function
- QUERYCACHEENTRIES Function
- RADIANS Function
- REPEAT Function
- REPLACE Function
- RIGHT Function
- ROWS SINCE Function
- RPAD Function
- RTRIM Function
- RUNNINGAVG Function
- RUNNINGCOUNT Function
- RUNNINGMAX Function
- RUNNINGMIN Function
- RUNNINGSTDDEV Function
- RUNNINGSUM Function
- RUNNINGVARIANCE Function
- SECOND Function
- SESSION_USER Function
- SIGN Function
- SIN Function
- SINH Function
- SPACE Function
- SQRT Function
- STDDEV Function
- SUBSTRING Function
- SUM Function
- TAN Function
- TANH Function
- THIS Function
- TRANSLATE Function
- TRIM Function
- UCASE Function
- UPPER Function
- UPSHIFT Function
- USER Function
- VARIANCE Function
- WEEK Function
- YEAR Function
- 10 Metadata Tables
- Migrating SQL/MP Metadata
- SQL/MX Metadata Catalogs
- SQL/MX Metadata Schemas and Tables
- System Schema Tables
- Definition Schema Tables
- ACCESS_PATHS Table
- ACCESS_PATH_COLS Table
- CK_COL_USAGE Table
- CK_TBL_USAGE Table
- COLS Table
- COL_PRIVILEGES Table
- DDL_LOCKS Table
- KEY_COL_USAGE Table
- MP_PARTITIONS Table
- OBJECTS Table
- PARTITIONS Table
- REF_CONSTRAINTS Table
- REPLICAS Table
- RI_UNIQUE_USAGE Table
- ROUTINES Table
- TBL_CONSTRAINTS Table
- TBL_PRIVILEGES Table
- TEXT Table
- TRIGGERS Table
- TRIGGERS_CAT_USAGE Table
- TRIGGER_USED Table
- VWS Table
- VW_COL_TBLS Table
- VW_COL_TBL_COLS Table
- VW_COL_USAGE Table
- VW_TBL_USAGE Table
- System Defaults Table
- SYSTEM_DEFAULTS Table
- Overriding System-Defined Default Settings
- Default Attributes
- Constraint Droppable Options
- Data Types
- Function Control
- Histograms
- Isolation Level
- Locking
- Local Autonomy
- Module Management
- National Character Set
- Nonaudited Tables
- Object Naming
- Partition Management
- Query Optimization and Performance
- Query Plan Caching
- Referential Action
- Row Maintenance
- Scratch Disk Management
- Sequence Functions
- Statement Atomicity
- Statement Recompilation
- Stored Procedures in Java
- Stream Access
- Table Management
- Trigger Management
- Examples of SYSTEM_DEFAULTS Table
- User Metadata Tables (UMD): Histogram Tables
- MXCS Metadata Tables
- A Quick Reference
- B Reserved Words
- C Limits
- D Sample Database
- E Standard SQL and SQL/MX
- Index
- Content Feedback