This night give you a starting point:
Use CONNECT to connect to a local or remote SQL server, such |
| as another UniVerse system or an ORACLE, SYBASE, or INFORMIX |
| system. |
| |
| SYNTAX |
| |
| CONNECT data.source [option setting [option setting...]] |
| |
| QUALIFIERS |
| |
| data.source The name of the data source to which you want to |
| connect. The data source must be defined in the |
| uvodbc.config file. If you do not enter the name |
| of a data source, CONNECT lists all data source
| in the uvodbc.config file. |
| |
| option One of the following options to control the input |
| format or output display: |
| |
| BLOCK PREFIX |
| INVERT UVOUT |
| MVDISPLAY VERBOSE |
| NULL WIDTH |
| |
| Specify any option by typing the word or its first |
| letter. Each option must be followed by setting. |
| |
| setting The new setting for the option. |
| |
| The following sections describe each option and its possible |
| settings in detail. |
| |
| BLOCK OPTION
his option defines how input statements will be |
| terminated. setting is one of the following: |
| |
| ON Enables block mode. In this mode you can enter |
| a series of SQL statements, ending each with a |
| semicolon (;). To terminate the block of SQL |
| statements, press Return immediately after an |
| "SQL+" prompt. |
| |
| OFF (Default) Disables block mode. In this mode if |
| you type a semicolon at the end of a line of |
| input, the SQL Client terminates your input and |
| sends it to the data source. |
| |
| string |
| Enables block mode (see ON). string must be |
| from one to four characters. To terminate the |
| block of SQL statements, enter string |
| immediately after an "SQL+" prompt.
INVERT OPTION |
| |
| This option lets you control case inversion for |
| alphabetic characters you type while CONNECT is |
| running. setting is one of the following: |
| |
| ON Inverts the case of all alphabetic characters |
| you type--that is, lowercase letters change to |
| uppercase, and uppercase letters change to |
| lowercase. This is equivalent to setting PTERM |
| CASE parameters to INVERT and LC-IN. |
| |
| OFF Disables case inversion. This is equivalent to |
| setting PTERM CASE parameters to NOINVERT and |
| LC-IN. This is the default setting for non- |
| UniVerse data sources. |
| |
| INIT Sets case-inversion parameters to the values |
| they had when you invoked CONNECT. This is the |
| default setting for UniVerse data sources.
|
| When you exit from CONNECT, case inversion for input |
| is restored to the state it was in when you invoked |
| CONNECT. |
| |
| MVDISPLAY OPTION |
| |
| The MVDISPLAY option defines how to display value |
| marks in multivalued data (when connected to a |
| UniVerse data source). For each row, multiple values |
| in the same field are displayed on the same line, |
| separated by value marks. setting is one of the |
| following: |
| |
| SPACE Displays a value mark as a blank space. |
| |
| NOCONV Displays a value mark as CHAR(253). |
| |
| char Displays a value mark as char (one character).
By default, value marks are displayed as * (asterisk). |
| |
| NULL OPTION |
| |
| The NULL option defines how to display the SQL null |
| value. setting is one of the following: |
| |
| SPACE Displays SQL null as a blank space. |
| |
| NOCONV Displays SQL null as CHAR(128). |
| |
| string Displays SQL null as string. The string can be |
| from one to four characters. By default, null |
| is displayed as the four-character string NULL. |
| |
| PREFIX OPTION |
| |
| The PREFIX option defines the prefix character |
| for local commands. setting is any valid prefix |
| character. The default prefix character is a period
(.). You can use only the following characters as |
| the prefix character: |
| |
| ! exclamation point ? question mark |
| @ at sign ( left parenthesis |
| # sharp sign ) right parenthesis |
| $ dollar sign { left brace |
| % percent } right brace |
| & ampersand [ left bracket |
| * asterisk ] right bracket |
| / slash ` left quotation mark |
| \ backslash ` right quotation mark |
| : colon . period |
| __ equal sign | vertical bar |
| + plus sign " double quotation mark |
| - minus sign , comma |
| |
| UVOUT OPTION |
| |
| The UVOUT option specifies how to handle output from
SELECT commands executed on the data source. setting |
| is either: |
| |
| filename Stores output in filename on the client, |
| then displays the output from filename. If |
| the file does not exist, the CONNECT command |
| creates it. |
| |
| OFF (Default) Displays output from the data |
| source directly on the client's screen. |
| |
| VERBOSE OPTION |
| |
| The VERBOSE option displays extended column |
| information and system messages. setting is one of the |
| following: |
| |
| ON Enables verbose mode. In this mode the name, |
| SQL data type, precision, scale, and display |
| size are displayed for each column's definition
when selecting data from the data source. Error |
| messages are displayed in extended format that |
| includes the type of call issued, status, |
| SQLSTATE, error code generated by the data |
| source, and the complete error text. |
| |
| OFF (Default) Disables verbose mode. |
| |
| WIDTH OPTION |
| |
| The WIDTH option defines the width of display columns. |
| setting is one of the following: |
| |
| col#,width |
| Sets the width of column col# to width. Do not |
| type a space after the comma. Specify col# as |
| an asterisk (*) to set the width of all |
| columns. width can be between 4 and the maximum |
| line length allowed by your terminal. The |
| default width for all columns is 10.
|
| T (Default) Truncates data that is wider than the |
| specified width. |
| |
| F Folds data that is wider than the specified |
| width onto multiple lines. |
| |
| ? Displays the current column width settings, and |
| tells whether data will be truncated or folded. |
| |
| DESCRIPTION |
| |
| The CONNECT command lets you submit SQL statements to a |
| specified data source and receive results at your terminal. |
| |
| While you are connected to a data source, you can type any SQL |
| statement understood by the data source's DBMS engine, |
| including SELECT, INSERT, UPDATE, DELETE, GRANT, and CREATE |
| TABLE. You cannot, however, successfully control statements |
| such as BEGIN TRANSACTION, COMMIT, and ROLLBACK when you are |
| using CONNECT. |
| |
| If you execute a stored procedure or enter a command batch |
| with multiple SELECT statements, the results of only the first |
| SELECT statement are returned. |
| |
| UniVerse and SYBASE treat SQL identifiers and keywords case- |
| sensitively, whereas ORACLE and INFORMIX do not. UniVerse |
| requires you to specify all keywords in uppercase; SYBASE |
| requires you to specify data types (char, int, float, etc.) in |
| lowercase. In ORACLE and INFORMIX you can use either upper- or |
| lowercase letters for these keywords.
Confidentiality Notice: This e-mail and any attachments are intended solely
for the addressee and may contain confidential or privileged information. If
you are not the named addressee, or the person responsible for delivering the
message to the named addressee, please notify the sender as soon as possible
and delete the material from your computer. This message will be protected by
copyright. If it has come to you in error, you must not take any action based
on its contents nor must you copy or show the message to any person other than
the intended recipient.
_____________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
