To view the InventoryLevelsData interface that you generated:
import com.ibm.pdq.annotation.Select; import com.ibm.pdq.annotation.Update;
// Select all GOSALES.INVENTORY_LEVELSs @Select(sql = "SELECT INVENTORY_YEAR, INVENTORY_MONTH, WAREHOUSE_BRANCH_CODE," + " PRODUCT_NUMBER, OPENING_INVENTORY, QUANTITY_SHIPPED, ADDITIONS," + " UNIT_COST, CLOSING_INVENTORY, AVERAGE_UNIT_COST" + " FROM GOSALES.INVENTORY_LEVELS") Iterator<InventoryLevels> getInventoryLevelss();
// Select GOSALES.INVENTORY_LEVELS by parameters @Select(sql = "SELECT INVENTORY_YEAR, INVENTORY_MONTH, WAREHOUSE_BRANCH_CODE," + " PRODUCT_NUMBER, OPENING_INVENTORY, QUANTITY_SHIPPED, ADDITIONS," + " UNIT_COST, CLOSING_INVENTORY, AVERAGE_UNIT_COST" + " FROM GOSALES.INVENTORY_LEVELS" + " WHERE INVENTORY_YEAR = ? AND INVENTORY_MONTH = ? AND WAREHOUSE_BRANCH_CODE = ?" + " AND PRODUCT_NUMBER = ?") InventoryLevels getInventoryLevels(short inventoryYear, short inventoryMonth, int warehouseBranchCode, int productNumber);
// Select GOSALES.INVENTORY_LEVELS by InventoryLevels object @Select(sql = "SELECT INVENTORY_YEAR, INVENTORY_MONTH, WAREHOUSE_BRANCH_CODE," + " PRODUCT_NUMBER, OPENING_INVENTORY, QUANTITY_SHIPPED, ADDITIONS," + " UNIT_COST, CLOSING_INVENTORY, AVERAGE_UNIT_COST" + " FROM GOSALES.INVENTORY_LEVELS" + " WHERE INVENTORY_YEAR = :inventoryYear AND INVENTORY_MONTH = :inventoryMonth" + " AND WAREHOUSE_BRANCH_CODE = :warehouseBranchCode" + " AND PRODUCT_NUMBER = :productNumber") InventoryLevels getInventoryLevels(InventoryLevels i);
// Create GOSALES.INVENTORY_LEVELS by parameters @Update(sql = "INSERT INTO GOSALES.INVENTORY_LEVELS (INVENTORY_YEAR, INVENTORY_MONTH," + " WAREHOUSE_BRANCH_CODE, PRODUCT_NUMBER, OPENING_INVENTORY, QUANTITY_SHIPPED," + " ADDITIONS, UNIT_COST, CLOSING_INVENTORY, AVERAGE_UNIT_COST)" + " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)") int createInventoryLevels(short inventoryYear, short inventoryMonth, int warehouseBranchCode, int productNumber, int openingInventory, int quantityShipped, int additions, BigDecimal unitCost, int closingInventory, BigDecimal averageUnitCost);
// Create GOSALES.INVENTORY_LEVELS by InventoryLevels Object @Update(sql = "INSERT INTO GOSALES.INVENTORY_LEVELS (INVENTORY_YEAR, INVENTORY_MONTH," + " WAREHOUSE_BRANCH_CODE, PRODUCT_NUMBER, OPENING_INVENTORY, QUANTITY_SHIPPED," + " ADDITIONS, UNIT_COST, CLOSING_INVENTORY, AVERAGE_UNIT_COST)" + " VALUES (:inventoryYear, :inventoryMonth, :warehouseBranchCode," + " :productNumber, :openingInventory, :quantityShipped, :additions," + " :unitCost, :closingInventory, :averageUnitCost)") int createInventoryLevels(InventoryLevels i);
// Update GOSALES.INVENTORY_LEVELS by parameters @Update(sql = "UPDATE GOSALES.INVENTORY_LEVELS" + " SET INVENTORY_YEAR = ?, INVENTORY_MONTH = ?, WAREHOUSE_BRANCH_CODE = ?," + " PRODUCT_NUMBER = ?, OPENING_INVENTORY = ?, QUANTITY_SHIPPED = ?," + " ADDITIONS = ?, UNIT_COST = ?, CLOSING_INVENTORY = ?, AVERAGE_UNIT_COST = ?" + " WHERE INVENTORY_YEAR = ? AND INVENTORY_MONTH = ? AND WAREHOUSE_BRANCH_CODE = ?" + " AND PRODUCT_NUMBER = ?") int updateInventoryLevels(short inventoryYear, short inventoryMonth, int warehouseBranchCode, int productNumber, int openingInventory, int quantityShipped, int additions, BigDecimal unitCost, int closingInventory, BigDecimal averageUnitCost, short inventoryYear_K, short inventoryMonth_K, int warehouseBranchCode_K, int productNumber_K);
// Update one GOSALES.INVENTORY_LEVELS by InventoryLevels object @Update(sql = "UPDATE GOSALES.INVENTORY_LEVELS" + " SET OPENING_INVENTORY = :openingInventory, QUANTITY_SHIPPED = :quantityShipped," + " ADDITIONS = :additions, UNIT_COST = :unitCost, CLOSING_INVENTORY = :closingInventory," + " AVERAGE_UNIT_COST = :averageUnitCost" + " WHERE INVENTORY_YEAR = :inventoryYear AND INVENTORY_MONTH = :inventoryMonth" + " AND WAREHOUSE_BRANCH_CODE = :warehouseBranchCode" + " AND PRODUCT_NUMBER = :productNumber") int updateInventoryLevels(InventoryLevels i);
// Delete GOSALES.INVENTORY_LEVELS by parameters @Update(sql = "DELETE FROM GOSALES.INVENTORY_LEVELS" + " WHERE INVENTORY_YEAR = ? AND INVENTORY_MONTH = ? AND WAREHOUSE_BRANCH_CODE = ?" + " AND PRODUCT_NUMBER = ?") int deleteInventoryLevels(short inventoryYear, short inventoryMonth, int warehouseBranchCode, int productNumber);
// Delete one GOSALES.INVENTORY_LEVELS by InventoryLevels object @Update(sql = "DELETE FROM GOSALES.INVENTORY_LEVELS" + " WHERE INVENTORY_YEAR = :inventoryYear AND INVENTORY_MONTH = :inventoryMonth" + " AND WAREHOUSE_BRANCH_CODE = :warehouseBranchCode" + " AND PRODUCT_NUMBER = :productNumber") int deleteInventoryLevels(InventoryLevels i);