Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Built-In Services | pub.jdbcAdapter:updateServiceSchema
 
pub.jdbcAdapter:updateServiceSchema
 
Configuring the updateServiceSchema Service
Setting Input Fields
The pub.jdbcAdapter:updateServiceSchema Java service enables you to change the schema settings associated with an adapter service without having to manually update the service from the Designer Adapter Service Editor.
This service supports the following types of services: InsertSQL, DeleteSQL, UpdateSQL, SelectSQL, StoredProcedure, and StoredProcedureWithSignature.
Unlike the pub.jdbcAdapter:updateServiceSchema service, the pub.jdbcAdapter:updateServiceSchema service does not validate the new schemas against the service settings.
Input Parameters
nodeName
String. Required. Sets the name of the service to be updated.
allSchemaChange
Record. Optional. Indicates that the update is to occur on every schema name in the adapter service.
allSchemaChange.useCurrentSchema
Boolean. Optional. It sets all schema names to <current schema>.
allSchemaChange.schemaName
String. Optional. Sets all schema names to the value of this field.
schemaChanges
Record List. Optional. Makes individual schema changes, replacing the schema identified by the existingSchema field with the new name set in the newSchema field.
schemaChanges.existingSchema
Record. Required. Identifies the schema name to change.
schemaChanges.existingSchema.useCurrentSchema
Boolean. Optional. Identifies the <current schema>.
schemaChanges.existingSchema.SchemaName
String. Optional. Specifies an existing schema name for the SchemaName field.
Output Parameters
None.