ALTER Datalake TABLE statement results in SQL0104N

SQL104N returned when altering a Datalake table specifying multiple element changes.

Symptoms

When altering a Datalake table, you might see the following error if you specify more than one element in the statement:

db2 "ALTER Datalake TABLE ICE_ADD_DROP add column col_double1 double add column col_double2 double"
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "add" was found following "column col_double1 
double".  Expected tokens may include:  "".  SQLSTATE=42601

Causes

When altering a Datalake table, only one alter is possible per statement. Altering multiple elements requires multiple ALTER Datalake TABLE statements.

Resolving the problem

Use multiple ALTER statements to make the updates that are needed.