Home > Contents > Index >
Template Tags TOC | Alpha TOC | Tag Family TOC | Purpose TOC | Annotated TOC | Index
ics:catalogmanager.createtable
Creates a table using
ics:catalogmanager
.Syntax
<ics:catalogmanager> <ics:argument name="ftcmd" value="createtable" /> <ics:argument name="tablename" value="table" /> <ics:argument name="systable" value="no/obj"/> <ics:argument name="uploadDir" value="directory" /> <ics:argument name="aclList" value="acl1,acl2..." /> <ics:argument name="colnameN" value="name" /> <ics:argument name="colvalueN" value="value"/> </ics:catalogmanager>Parameters
ftcmd (required)
- Value must be set to
createtable
.
tablename (required)
- Name of the table to create.
systable (required)
- Allows differentiation between ContentCatalog (
systable=no
) and ObjectCatalog (systable=obj
). The default is ContentCatalog (systable=no
).
uploadDir (required)
- Server-side folder path to contain uploaded files.
aclList (optional)
- Comma-separated list of ACLs. When security is enabled, only members of the ACLs can access content in the table.
colvalueN
(required)- Database-specific field type for column.The value of
N
is 0 (zero) for the first column, 1 for the second column, and so on.
colnameN
(required)- Column field name. Each
colname
parameter corresponds to a column in the table. The value ofN
is 0 (zero) for the first column, 1 for the second column, and so on.
Description
The
createtable
command creates a table. The table's primary key field name is defined in the Sites properties file (futuretense.ini
).
Note
The default primary key used by CatalogManager is defined in the property
cc.contentkey
. Unlike a custom property for primary keys, thecc.contentkey
property does not restrict the name of the tables that you create. The Object table column, version, is reserved for future use.Error Numbers
The possible values of
errno
include:
Value Description -22 Table already exists. -105 Database error.Example
The following example creates a table by name ExampleTable.
<ics:catalogmanager>
<ics:argument name="ftcmd" value="createtable" />
<ics:argument name="tablename" value="ExampleTable" />
<ics:argument name="systable" value="no" />
<ics:argument name="uploadDir" value="/export/home/public" />
<ics:argument name="colname0" value="id" />
<ics:argument name="colvalue0" value="varchar(10) PRIMARY KEY NOT NULL" />
<ics:argument name="colname1" value="description" />
<ics:argument name="colvalue1" value="varchar(24)" />
<ics:argument name="colname2" value="quantity" />
<ics:argument name="colvalue2" value="int"/>
</ics:catalogmanager>
See Also
The following
ics:catalogmanager
command:ics:catalogmanager.deletetable
Home > Contents > Index > ![]()
Oracle JSP Tag Reference
Copyright (c) 2013, 2016, Oracle and/or its affiliates. All rights reserved.