Command-line options

The following command-line options are supported.

aggregate() - Retrieve JSON documents command
Runs a sequence of tasks to retrieve documents from a collection, including attributes and calculated values. Tasks can occur multiple times as long as the syntax sequence is valid.
count() - Find the number of documents command
Finds the number of documents in a collection.
createCollection() - Creates a collection
Creates a new collection with the specified characteristics.
distinct() - Find distinct values command
Finds distinct values for the submitted query.
drop() - Drop a collection command
Drops a collection and associated objects, such as indexes on the collection.
ensureIndex() - Creates a new index
Creates a new index on a specific field of a collection.
exportFile() - Export JSON documents to a file command
Exports JSON documents from a collection into a file.
find() - Find JSON document command
Find JSON documents according to filter criteria. You can also specify fields to be included or excluded, determine the sort order, limit the number of documents, and page through results with an offset.
findAndModify() - Find and update documents command
Finds documents and updates them with new values.
findOne() - Find the first offset document
Find the first document that matches the query after you skip a specified number of rows.
getCollectionNames() - View collection names for a schema command
Returns the names of all JSON collections in a Db2 database.
getIndexes() command - View JSON indexes for a collection command
Returns index information that identifies and describes the existing indexes for a collection.
group() - Group values JSON command
Groups values for the collection in a query. More command options are available by using the aggregate() command with the $group task.
help() - Lists help commands
Lists possible commands for the collection commands.
importFile() - Import JSON documents from file command
Imports JSON documents from a file into a collection.
importMongoSample() - Import some JSON documents from MongoDB
Import a specified number of JSON documents from a collection in a MongoDB database.
importMongo() - Import JSON documents from MongoDB
Import JSON documents from a collection in a MongoDB database.
insert() - Insert a JSON document command
Inserts a JSON document into a collection. If the collection does not exist, it is created automatically.
markType() - Specifies the data type
Specifies a data type for a JSON field in a collection.
printDDL() - Print the DDL
Prints the default DDL of a collection.
remove() - Remove data from a collection command
Removes all the data or specified data from a collection. Index definitions are retained.
removeIndex() - Remove a JSON index command
Removes the specified index from a collection
rename() - Rename a collection command
Renames a collection.
sampleSchema() - Return document structure command
Returns the structure of JSON documents in a collection.
save() - Save a document command
Saves an inserted or updated JSON document in a collection. If a document in a collection has the same ID as a new document, the existing document is replaced. Otherwise, the new document is inserted.
sqlQuery() - Run a JSON SQL query command
Runs an SQL query at the database level.
sqlUpdate() - Run a JSON SQL update query command
Runs an SQL update query at the database level.
stats() - Prints collection statistics
Prints statistics for the collection. Unavailable values are set to -1.
timeTravel() - Set JSON time travel queries command
Sets system or business time for JSON time travel queries against a Db2 database.
update() - Update JSON documents command
Updates a JSON document or documents in a collection.

Parent topic: JSON command-line interface (CLI)