![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The INSERT statement adds a new occurrence to a table. Occurrences within a table must have unique primary keys. No field selection is possible; the WHERE clause can specify only parameter values.
Signaled if an error is detected in the specification of selection criteria Signaled if an attempt is made to insert an occurrence with a primary key that already exists
• Example 2 inserts data into the parameterized CARS table. The values for the parameter CITY are provided by INPUT.CITY.
• Example 3 inserts data into the EXPENSE_DATA screen table in the EMPLOYEE_EXPENSE screen.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |