KFAA31264-E


      
         The specification method of aa....aa of bb....bb is invalid. <SQLSTATE:427M6>

         
               aa....aa: Location of invalid specification

               
                        access key string: Access key string

                     
                        secret key string: Secret key string

                     
                        endpoint string: Endpoint string

                     
                        foreign server option: Foreign server option

                     
                        ALTER SERVER option: Foreign server definition modification option

                     
               bb....bb: Invalid SQL statement

               
                        ALTER SERVER statement: ALTER SERVER statement

                     
                        CREATE SERVER statement: CREATE SERVER statement

                     
               cc....cc: Reason for the error

               
                  The reason for the error and an example of how this message is output are shown below.

                  
                                 Value of cc....cc

                              
                                 Description

                              
                                 Example of how this message is output

                              
                                 the data length exceeds the range that can be specified

                              
                                 The data length has exceeded the range that can be specified.

                              
                                 The data length of the access key string, secret key string, or endpoint string exceeds 100 bytes.

                              
                                 the specified option is duplicated

                              
                                 The specified option is specified more than once.

                              
                                 The same foreign server option (underlined) is
                                    specified in the CREATE SERVER
                                    statement as follows.

                                 Example:

                                 CREATE SERVER "S001" OPTIONS (

                                 ACCESS_KEY 'ACCESS1'

                                 ,SECRET_KEY 'SECRET1'

                                 ,SECRET_KEY 'SECRET2')

                              
                                 the ALTER SERVER options for a different operation cannot be specified

                              
                                 When multiple foreign server definition modification options are specified, different operations cannot be specified.

                              
                                 Different operations (underlined) are specified in the foreign
                                    server definition modification option of the ALTER SERVER statement as follows.

                                 Example:

                                 ALTER SERVER "S001" OPTIONS (

                                 ADD ACCESS_KEY 'ACCESS1'

                                 ,SET
                                    SECRET_KEY 'SECRET1')

                              
                                 the same option with ALTER SERVER options cannot be specified

                              
                                 When multiple foreign server definition modification options are specified, the same foreign server option cannot be specified.

                              
                                 The same foreign server option (underlined) is specified in the
                                    foreign server definition modification option of the ALTER SERVER statement as follows.

                                 Example:

                                 ALTER SERVER "S001" OPTIONS (

                                 SET SECRET_KEY 'SECRET1'

                                 ,SET SECRET_KEY 'SECRET2')

                              
               S:

               
                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               
               Action:

               
                  Correct the SQL statement.

Value of cc....cc	Description	Example of how this message is output
the data length exceeds the range that can be specified	The data length has exceeded the range that can be specified.	The data length of the access key string, secret key string, or endpoint string exceeds 100 bytes.
the specified option is duplicated	The specified option is specified more than once.	The same foreign server option (underlined) is specified in the CREATE SERVER statement as follows. Example: CREATE SERVER "S001" OPTIONS ( ACCESS_KEY 'ACCESS1' ,SECRET_KEY 'SECRET1' ,SECRET_KEY 'SECRET2')
the ALTER SERVER options for a different operation cannot be specified	When multiple foreign server definition modification options are specified, different operations cannot be specified.	Different operations (underlined) are specified in the foreign server definition modification option of the ALTER SERVER statement as follows. Example: ALTER SERVER "S001" OPTIONS ( ADD ACCESS_KEY 'ACCESS1' ,SET SECRET_KEY 'SECRET1')
the same option with ALTER SERVER options cannot be specified	When multiple foreign server definition modification options are specified, the same foreign server option cannot be specified.	The same foreign server option (underlined) is specified in the foreign server definition modification option of the ALTER SERVER statement as follows. Example: ALTER SERVER "S001" OPTIONS ( SET SECRET_KEY 'SECRET1' ,SET SECRET_KEY 'SECRET2')