The command "add partition to <scheme_name>" results in "Invalid specitication; not in key=value format" (230007)

The following errors occur when issuing the command to add a partition to a partition scheme:

sp_ctrl (alvsupu15:5438)> add partition to scheme1 set name = q1 and condition =

 "NUM_COL<10" and route =

   Invalid specitication; not in key=value format

The command “add partition….” has a series of set statements depending on the values being set thru this command. The syntax of the command is:

add partition to scheme_name set {condition = column_condition | hash = hash_value} and route = routing_map [and name = partition_name] [and tablename = target_table] [and description = description]

If one of the clause is not specified correctly, then the above error will occur. Correct the syntax of the “add partition” command and re-issue it.

In our case the following clause was incomplete as we did not specify the value for the route:

"and route ="