More About SQL Correlation Names
March 12, 2008 Hey, Ted
|
I hope my question is an easy one to answer. I have a file that stores the location of inventory in a warehouse. Location consists of a row (an aisle), column, and level. Why will an SQL UPDATE let me change the column and level, but not the row? –Scott You can update the column like this: update qtemp/inventory set column=4 where item = 'SL-701' But updating the row gives you error SQL0104. (Token 4 was not valid. Valid tokens: ( : DAY CAST CHAR DATE DAYS HOUOUR LEFT TIME TRIM YEAR COUNT MONTH.) update qtemp/inventory set row=4 where item |
