Send LONG values to the database using static SQL from an embedded SQL application.
Prerequisites
There are no prerequisites for this task.
Task- Declare a host variable of type DECL_LONGVARCHAR, DECL_LONGNVARCHAR, or DECL_LONGBINARY, as appropriate.
- If you are sending NULL, set the indicator variable to a negative value.
- Set the stored_len field of the host variable structure to the number of bytes of data in the array field.
- Send the data by opening the cursor or executing the statement.
The embedded SQL application is ready to send LONG values to the database.