ALTER DOMAIN Sample Clauses

ALTER DOMAIN. Changes a domain definition. Available in SQL, DSQL, and isql. Syntax ALTER DOMAIN name { [SET DEFAULT {literal | NULL | USER}] | [DROP DEFAULT] | [ADD [CONSTRAINT] CHECK (<dom_search_condition>)] | [DROP CONSTRAINT] }; Important In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in isql, the semicolon is a terminating symbol for the statement, so it must be included. <dom_search_condition> = { VALUE <operator> <val> | VALUE [NOT] BETWEEN <val> AND <val> | VALUE [NOT] LIKE <val> [ESCAPE <val>] | VALUE [NOT] IN (<val> [, <val> ...]) | VALUE IS [NOT] NULL | VALUE [NOT] CONTAINING <val> | VALUE [NOT] STARTING [WITH] <val> | (<dom_search_condition>) | NOT <dom_search_condition> | <dom_search_condition> OR <dom_search_condition> | <dom_search_condition> AND <dom_search_condition> } SET DEFAULT Specifies a default column value that is entered when no other entry is made. Values: • literal—Inserts a specified string, numeric value, or date value. • NULL—Enters a NULL value. • USER—Enters the user name of the current user. Col- umn must be of compatible text type to use the default. Defaults set at column level override defaults set at the domain level. DROP DEFAULT Drops existing default. ADD [CONSTRAINT] CHECK Adds a CHECK constraint to the domain definition. A domain definition can include only one CHECK constraint. DROP CONSTRAINT Drops CHECK constraint from the domain definition. A domain can be altered by its creator, the SYSDBA user, and any users with operating system root privileges. Example The following isql statements create a domain that must have a value > 1,000, then alter it by setting a default of 9,999: CREATE DOMAIN CUSTNO AS INTEGER CHECK (VALUE > 1000); ALTER DOMAIN CUSTNO SET DEFAULT 9999; For a complete discussion of creating domains, and using them to create column definitions, see the Data Definition Guide. Changes the message associated with an existing exception. Available in DSQL and isql. Syntax ALTER EXCEPTION name "<message>" name Name of an existing exception message. "<message>" Quoted string containing ASCII values. An exception can be altered by its creator, the SYSDBA user, and any users with operating system root privileges. Example This isql statement alters the message of an exception: ALTER EXCEPTION CUSTOMER_CHECK "Hold shipment for customer remittance."; For more information on creating, raising, and handling exceptions, see the Data Definition Guide. Activa...
AutoNDA by SimpleDocs
ALTER DOMAIN. This data structure will be used to make changes to the domain information. All fields, including the domain name itself, can be changed by the user. All demographic fields will be overwritten with the new values, so care must be taken to fill fields with all values, even the ones that have not changed. struct T_DOMAIN_EDIT{ struct T_DOMAIN Domain; char szNewDomainName[32]; int bRegisterDomain; char szNewUserName[32]; int bPasswordChanged; char szNewPassword[16]; }; The usage of the fields is as follows. nCOMMAND: CMD_ALTER. eSERVERTYPE: SERVER_DOMAIN. szDOMAINNAME: Old domain name. szUSERNAME: Old user name. szPASSWORD: Old password. szNEWDOMAINNAME: New domain name. If old and new domain names are the same, no domain name changes are made. This field is filled on input. bREGISTERDOMAIN: Defines whether domain should be registered or not. This permits users to move the account to a domain registered through some other means. No DNS server checks will be made while changing the domain name. This field is filled on input. szNEWUSERNAME: New Admin user name. If old and new admin user names are the same, no user account changes are made. This field is filled on input. szNEWPASSWORD: Holds the new password for the admin user account. This field is filled on input.

Related to ALTER DOMAIN

  • Contractor Designation of Trade Secrets or Otherwise Confidential Information If the Contractor considers any portion of materials to be trade secret under section 688.002 or 812.081, F.S., or otherwise confidential under Florida or federal law, the Contractor must clearly designate that portion of the materials as trade secret or otherwise confidential when submitted to the Department. The Contractor will be responsible for responding to and resolving all claims for access to Contract-related materials it has designated trade secret or otherwise confidential.

  • Trade Secrets and Proprietary Information (a) Executive recognizes and acknowledges that the Company, through the expenditure of considerable time and money, has developed and will continue to develop in the future information concerning customers, clients, marketing, products, services, business, research and development activities and operational methods of the Company and its customers or clients, contracts, financial or other data, technical data or any other confidential or proprietary information possessed, owned or used by the Company, the disclosure of which could or does have a material adverse effect on the Company, its business, any business it proposes to engage in, its operations, financial condition or prospects and that the same are confidential and proprietary and considered “confidential information” of the Company for the purposes of this Agreement. In consideration of his employment, Executive agrees that he will not, during or after the Term, without the consent of the Board make any disclosure of confidential information now or hereafter possessed by the Company, to any person, partnership, corporation or entity either during or after the term here of, except that nothing in this Agreement shall be construed to prohibit Executive from using or disclosing such information (a) if such disclosure is necessary in the normal course of the Company’s business in accordance with Company policies or instructions or authorization from the Board, (b) such information shall become public knowledge other than by or as a result of disclosure by a person not having a right to make such disclosure, or (c) subsequent to the Term, if such information shall have either (i) been developed by Executive independent of any of the Company’s confidential or proprietary information or (ii) been disclosed to Executive by a person not subject to a confidentiality agreement with or other obligation of confidentiality to the Company. For the purposes of Sections 6, 7 and 8 of this Agreement, the term “Company” shall include the Company, its parent, its subsidiaries and affiliates, other than affiliates whose relationship as an affiliate is derived solely from Executive’s interest in or position at the affiliate. (b) In the event that any trade secrets or other confidential information covered by Section 6(a) of this Agreement is required to be produced by Executive pursuant to legal process, Executive shall give the Company notice of such legal process within a reasonable time, but not later than ten (10) business days prior to the date such disclosure is to be made, unless Executive has received less notice, in which event Executive shall immediately notify the Company. The Company shall have the right to object to any such disclosure, and if the Company objects (at the Company’s cost and expense) in a timely manner so that Executive is not subject to penalties for failure to make such disclosure, Executive shall not make any disclosure until there has been a court determination on the Company’s objections. If disclosure is required by a court order, final beyond right of review, or if the Company does not object to the disclosure, Executive shall make disclosure only to the extent that disclosure is unequivocally required by the court order, and Executive will exercise reasonable efforts at the Company’s expense, to obtain reliable assurance that confidential treatment will be accorded the Confidential Information.

  • Ownership of Software and Related Material All computer programs, magnetic tapes, written procedures, and similar items purchased and/or developed and used by Price Associates in performance of this Agreement shall be the property of Price Associates and will not become the property of the Funds.

  • CONFIDENTIAL AND PROPRIETARY EXECUTION VERSION

  • Confidentiality Intellectual Property The Executive agrees that during the Executive’s employment with the Company, whether or not under this Agreement, and at all times thereafter: (a) The Executive will not at any time, directly or indirectly, disclose or divulge any Confidential Information (as hereinafter defined), except as required in connection with the performance of the Executive’s duties for the Company, and except to the extent required by law (but only after the Executive has provided the Company with reasonable notice and opportunity to take action against any legally required disclosure). As used herein, “Confidential Information” means all trade secrets and all other information of a business, financial, marketing, technical or other nature relating to the business of the Company including, without limitation, any customer or vendor lists, prospective customer names, financial statements and projections, know-how, pricing policies, operational methods, methods of doing business, technical processes, formulae, designs and design projects, inventions, computer hardware, software programs, business plans and projects pertaining to the Company and including any information of others that the Company has agreed to keep confidential; provided, however, that Confidential Information shall not include any information that has entered or enters the public domain through (i) no fault of the Executive, and (ii) no breach by any other current or former employee of his/her confidentiality obligations to the Company.

  • Return or Destruction of Confidential Information If an Interconnection Party provides any Confidential Information to another Interconnection Party in the course of an audit or inspection, the providing Interconnection Party may request the other party to return or destroy such Confidential Information after the termination of the audit period and the resolution of all matters relating to that audit. Each Interconnection Party shall make Reasonable Efforts to comply with any such requests for return or destruction within ten days of receiving the request and shall certify in writing to the other Interconnection Party that it has complied with such request.

  • No Unauthorized Use or Disclosure Executive agrees that he will not, at any time during or after Executive’s employment by Company, make any unauthorized disclosure of, and will prevent the removal from Company premises of, Confidential Information or Work Product of Company (or its affiliates), or make any use thereof, except in the carrying out of Executive’s responsibilities during the course of Executive’s employment with Company. Executive shall use commercially reasonable efforts to cause all persons or entities to whom any Confidential Information shall be disclosed by him hereunder to observe the terms and conditions set forth herein as though each such person or entity was bound hereby. Executive shall have no obligation hereunder to keep confidential any Confidential Information if and to the extent disclosure thereof is specifically required by law; provided, however, that in the event disclosure is required by applicable law, Executive shall provide Company with prompt notice of such requirement prior to making any such disclosure, so that Company may seek an appropriate protective order. At the request of Company at any time, Executive agrees to deliver to Company all Confidential Information that he may possess or control. Executive agrees that all Confidential Information of Company (whether now or hereafter existing) conceived, discovered or made by him during the period of Executive’s employment by Company exclusively belongs to Company (and not to Executive), and Executive will promptly disclose such Confidential Information to Company and perform all actions reasonably requested by Company to establish and confirm such exclusive ownership. Affiliates of Company shall be third party beneficiaries of Executive’s obligations under this Article 6. As a result of Executive’s employment by Company, Executive may also from time to time have access to, or knowledge of, Confidential Information or Work Product of third parties, such as customers, suppliers, partners, joint venturers, and the like, of Company and its affiliates. Executive also agrees to preserve and protect the confidentiality of such third party Confidential Information and Work Product to the same extent, and on the same basis, as Company’s Confidential Information and Work Product.

  • Unauthorised Use of Intellectual Property a) The Supplier/Service Provider agrees to notify Transnet in writing of any conflicting uses of, and applications of registrations of Patents, Designs and Trade Marks or any act of infringement, unfair competition or passing off involving the Intellectual Property of Transnet of which the Supplier/Service Provider acquires knowledge and Transnet shall have the right, as its own option, to proceed against any party infringing its Intellectual Property. b) It shall be within the sole and absolute discretion of Transnet to determine what steps shall be taken against the infringer and the Supplier/Service Provider shall co-operate fully with Transnet, at Transnet’s cost, in whatever measure including legal action to bring any infringement of illegal use to an end. c) The Supplier/Service Provider shall cooperate to provide Transnet promptly with all relevant ascertainable facts. d) If proceedings are commenced by Transnet alone, Transnet shall be responsible for all expenses but shall be entitled to all damages or other awards arising out of such proceedings. If proceedings are commenced by both Parties, both Parties will be responsible for the expenses and both Parties shall be entitled to damages or other awards arising out of proceedings.

  • Confidentiality/Trade Secrets Executive specifically agrees that Executive will not at any time, whether during or subsequent to the Term, in any fashion, form or manner, except in furtherance of Executive’s duties at the Company or with the specific written consent of the Company, either directly or indirectly use, divulge, disclose or communicate to any person in any manner whatsoever, any confidential information or trade secrets of any kind, nature or description concerning any matters affecting or relating to the business of the Company (the “Proprietary Information”), including (a) all information, design or software programs (including object codes and source codes), techniques, drawings, plans, experimental and research work, inventions, patterns, processes and know-how, whether or not patentable, and whether or not at a commercial stage related to the Company or any subsidiary thereof, (b) buying habits or practices of any of its customers or vendors, (c) the Company’s marketing methods, sales activities, promotion, credit and financial data and related information, (d) the Company’s costs or sources of materials, (e) the prices it obtains or has obtained or at which it sells or has sold its products or services, (f) lists or other written records used in the Company’s business, (g) compensation paid to employees and other terms of employment, or (h) any other confidential information of, about or concerning the business of the Company, its manner of operation, or other confidential data of any kind, nature, or description (excluding any information that is or becomes publicly known or available for use through no fault of Executive or as directed by court order). The Parties hereto stipulate that as between them, Proprietary Information constitutes trade secrets that derive independent economic value, actual or potential, from not being generally known to the public or to other persons who can obtain economic value or cause economic harm to the Company from its disclosure or use and that Proprietary Information is the subject of efforts which are reasonable under the circumstances to maintain its secrecy and of which this Section 8 is an example, and that any breach of this Section 8 shall be a material breach of this Agreement. All Proprietary Information shall be and remain the Company’s sole property.

  • Unauthorized Use or Disclosure The Contractor shall notify COMMERCE within five (5) working days of any unauthorized use or disclosure of any confidential information, and shall take necessary steps to mitigate the harmful effects of such use or disclosure.

Draft better contracts in just 5 minutes Get the weekly Law Insider newsletter packed with expert videos, webinars, ebooks, and more!