Command Reference > infacmd sql Command Reference > UpdateColumnOptions
  

UpdateColumnOptions

Sets column options to determine what happens when a user selects a restricted column in a query. You can substitute the value with NULL or with a constant value.
The infacmd sql UpdateColumnOptions command uses the following syntax:
UpdateColumnOptions

<-DomainName|-dn> domain_name

<-ServiceName|-sn> service_name

<-UserName|-un> user_name

<-Password|-pd> password

[<-SecurityDomain|-sdn> security_domain]

[<-ResilienceTimeout|-re> timeout_period_in_seconds]

<-SQLDataService|-sqlds> sql_data_service

<-Table|-t> schema.table

<-Column|-c> column_name

<-Options|-o> options
The following table describes infacmd sql UpdateColumnOptions options and arguments:
Option
Argument
Description
-DomainName
-dn
domain_name
Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-ServiceName
-sn
service_name
Required. Name of the Data Integration Service where the application is deployed.
-UserName
-un
user_name
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
security_domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-ResilienceTimeout
-re
timeout_period_in_seconds
Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. You can set the resilience timeout period with the -re option or the environment variable INFA_CLIENT_RESILIENCE_TIMEOUT. If you set a the resilience timeout period with both methods, the -re option takes precedence.
-SQLDataService
-sqlds
sql_data_service
Required. Name of the SQL data service with the virtual table.
You must prefix the SQL data service name with the application name.
Use the following syntax:
<application_name>.<SQL_data_service_name>
-Table
-t
schema.table
Required. Name of the virtual table. Enter table in the following format:
<schema_name>.<table_name>
-Column
-c
column
Column name.
-Options
-o
options
Required. Enter each option separated by a space. To view current options, run the infacmd sql ListColumnOptions command.

Column Options

Use column options to update a column. Use the column options with the infacmd sql UpdateColumnOptions command.
Enter column options in the following format:
... -o UpdateColumnOptions.option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes column options:
Options
Description
ColumnOptions.DenyWith
When you use column level security, this property determines whether to substitute the restricted column value or to fail the query. If you substitute the column value, you can choose to substitute the value with NULL or with a constant value.
Select one of the following options:
  • - ERROR. Fails the query and returns an error.
  • - NULL. Returns null values for a restricted column in each row.
  • - VALUE. Returns a constant value in place of the restricted column in each row. Configure the constant value in the InsufficientPermissionValue option.
ColumnOptions.InsuffiicientPermissionValue
Substitutes the restricted column value with a constant value. The default is an empty string. If you do not configure ColumnOptions.DenyWith the Data Integration Service ignores the InsufficientPermissionValue option.