Updating a Sybase database

To update a Sybase database, you must setup the properties of the Sybase Enterprise stage appropriately. You must specify appropriate values for the sub-properties of the Target, Connection, and Option properties.

To setup the properties of the stage, double-click the Sybase Enterprise icon. You see fields and properties under the Properties tab by default.

1. Under the Target category, specify the update method as follows:
   • Select IQ Upsert or ASE Upsert as the Write Method.
   • Specify the table to which to write data.
   • For the Auto-generate Upsert SQL option, select Yes if you wish to use a statement automatically generated by the IBM® InfoSphere® DataStage®. Select No if you wish to specify your own SQL statement. If you select No, then you must specify the Insert/ Update/ Delete SQL statement to use according to the Upsert Mode selection. If you select Yes, you can edit the automatically generated statement as required.
   • Choose the Upsert Mode. Specify whether to insert/update/delete/insert then update/update then insert/delete then insert data.
2. Under the Connection category, specify connection details for server, user, and password. You can enter these values directly or insert the values by using the job parameter popup list. In case you want to create a new job parameter, you must create a new environment variable for that parameter. You can create parameters at the job level or at the project level. By default, the InfoSphere DataStage connects to the Sybase default database. However, you can specify a different database if required.
3. Under the Options category:
   • Output Reject Records: This appears only for the Write Method of IQ Upsert, IQ Write, or ASE Write. It is False by default. Set it to True to send rejected records to the reject link.