JDBC Driver for Redis

Build 22.0.8462

RunBatchCommand

Sequentially executes a batch of Redis commands using either a temporary table or a batch file.

Batch commands are much more efficient because the driver does not need to send and wait for single commands to complete. Instead, the driver will send several commands and wait for them as a group.

Method 1: Batch File

Create a text document and populate it with one Redis command per line without any delimiters. Empty lines are skipped.

For example:

set key1 value1
set key2 value2
set key3 value3

Then, invoke the procedure with the path to the file supplied in the CommandFile input.

EXECUTE RunBatchCommand CommandFile = "C:\\Users\\username\\Public Documents\\batchfile.txt"

TEMP Tables

Populate a temporary table with Redis commands.

INSERT INTO Commands#TEMP(CommandLine) VALUES ("rpush mylist value1")
INSERT INTO Commands#TEMP(CommandLine) VALUES ("rpush mylist value2")
INSERT INTO Commands#TEMP(CommandLine) VALUES ("rpush mylist value3")

Then, invoke the procedure with the name of the temporary table provided in the CommandTable input.

EXECUTE RunBatchCommand CommandTable = "Commands#TEMP"

Input

Name Type Required Description
CommandTable String False Specifies a temporary table to be used in generating a batch of Redis commands for direct execution on the Redis server.
CommandFile String False The path to a file containing a batch of Redis commands. These commands will be sequentially and directly executed on the Redis server.
KeyType String False The format for the Redis server output. 'AUTO' returns the keys in list format (nested lists will each be one compound result). 'HASH' returns the keys as a hash (each group is a row, each property gets its own column).

The allowed values are AUTO, HASH.

The default value is AUTO.

Result Set Columns

Name Type Description
* String Output will vary for each collection.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462