Regression_Demo.ipynb Notebook - Create LINREG.GSTEST_STD table as Row Org to allow Alter Table

[db2Dean]

You will get an error in the "Standardize AGE in Test Data" cell if you are using Db2 Warehouse or other database that defaults to a column organized tables. The error happens in the step where the column is renamed in this cell. It appears that you can't rename columns in a column organized table. I fix this by changing this line:

sql = "CREATE TABLE LINREG.GSTEST_STD AS (SELECT * FROM LINREG.GSTEST) WITH DATA"

to this:

sql = "CREATE TABLE LINREG.GSTEST_STD AS (SELECT * FROM LINREG.GSTEST) WITH DATA ORGANIZE BY ROW"

[kdrodger]

Thanks @db2Dean . Let me see if I can route this to the right people for their thoughts.