adding test scripts
[csql.git] / test / cache / CacheTable / exp.test001.ksh
bloba9e2005ee264789c744030fa353a77dd36159b4c
1 Usage: cachetable [ -U <username> ] [ -P <password> ]
2 [ -t <tblName> [-D] [ -c "condition" ]
3 [-f "fieldListToCache"]
4 [ -p <fieldName> [-F] ]
5 [ -d <dsName>]
6 [ -l <dsName>|]
7 [ -u [-s] ]
8 [ -s | -r | -E ] ]
9 [ -S | -R ]
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.