1 Usage
: cachetable
[ -U <username
> ] [ -P <password
> ]
2 [ -t <tblName
> [-D] [ -c "condition" ]
3 [-f "fieldListToCache"]
4 [ -p <fieldName
> [-F] ]
11 U
-> Username to connect with csql.
12 P
-> Password
for above username.
13 t
-> Table name to be cached
in csql from target db.
14 D
-> Enable direct access option to target database.
15 c
-> Conditional expression used
in std SQL WHERE clause.
16 f
-> List of field names to be cached. Comma separated.
17 p
-> Not Null unique index field name
for Bidirectional
18 caching on
which trigger needs to be run.
19 d
-> Cache the table from the specified DSN.
20 l
-> Retrieves all the cached tables from the specified DSN.
21 F
-> Forceful caching.
22 s
-> Load only the records from target db.
23 Assumes table is already created
in csql.
24 u
-> Unload the table. If used with
-s option
,
25 removes only records and preserves the schema.
26 r
-> Reload the table. Get the latest image of table from target db.
27 E
-> Elevate table status from Replicated to Cached and Replicated.
28 S
-> Cache Description
for cached tables.
29 R
-> Recover all cached tables from the target database.