Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
ADS Build 8 5.3
zOS 8.0 version
Schema CLARKG
I didnt create these tables - TESTU2 and TESTU3. Some one else used the syntax for Varying-length graphic strings.
In the Server Tree Node, ADS displays VARGRAPHIC(32) and LONGVARG for the columns. When I script the tables, it is as shown below. We dont have option in Create Table GUI, as well as these 2 are not in the list of data types in the Documentation. But there is a mention of this in page 1313 in the document DB2zSeries-V8.pdf PAGE 1313
VARG and LONGVARG are Varying-length graphic strings
CREATE TABLE CLARKG.TESTU2 (
A VARG
)
GO
CREATE TABLE CLARKG.TESTU3 (
A LONGVARG
)
GO
Do we need to support the Syntax ?
DB2 zos v8 handles the following chart for datatypes. It stores some things that we have to handle on our side and I missed a few but now should be resolved. varg and longvarg are both vargraphics with a diffrent length. they are properly been extracted and displayed now.
There are however some other issues with these datatypes. They can only be created in specific CCSIDs so if you wanted to create them you would have to specify CCSID UNICODE as a table option...>>-+-SMALLINT----------------------------------------------------------------------------+-><
+-+-INTEGER-+-------------------------------------------------------------------------+
| '-INT-----' |
| .-(5,0)--------------------. |
+-+-DECIMAL-+--+--------------------------+-------------------------------------------+
| +-DEC-----+ '-(integer-+-----------+-)-' |
| '-NUMERIC-' '-, integer-' |
| .-(53)------. |
+-+-FLOAT--+-----------+--+-----------------------------------------------------------+
| | '-(integer)-' | |
| +-REAL------------------+ |
| | .-PRECISION-. | |
| '-DOUBLE--+-----------+-' |
| .-(1)-------. |
+-+-+-+-CHARACTER-+--+-----------+----------+--+----------------------+-------------+-+
| | | '-CHAR------' '-(integer)-' | '-FOR--+-SBCS--+--DATA-' | |
| | '-+-+-CHARACTER-+--VARYING-+--(integer)-' +-MIXED-+ | |
| | | '-CHAR------' | '-BIT---' | |
| | '-VARCHAR----------------' | |
| | .-(1M)-------------. | |
| '-+-+-CHARACTER-+--LARGE OBJECT-+--+------------------+--+----------------------+-' |
| | '-CHAR------' | '-(integer-+---+-)-' '-FOR--+-SBCS--+--DATA-' |
| '-CLOB------------------------' +-K-+ '-MIXED-' |
| +-M-+ |
| '-G-' |
| .-(1)-------. |
+-+-GRAPHIC--+-----------+-------+----------------------------------------------------+
| | '-(integer)-' | |
| +-VARGRAPHIC--(integer)--------+ |
| | .-(1M)-------------. | |
| '-DBCLOB--+------------------+-' |
| '-(integer-+---+-)-' |
| +-K-+ |
| +-M-+ |
| '-G-' |
| .-(1M)-------------. |
+-+-BINARY LARGE OBJECT-+--+------------------+---------------------------------------+
| '-BLOB----------------' '-(integer-+---+-)-' |
| +-K-+ |
| +-M-+ |
| '-G-' |
+-+-DATE------+-----------------------------------------------------------------------+
| +-TIME------+ |
| '-TIMESTAMP-' |
'-ROWID-------------------------------------------------------------------------------'
fixed... the proper default values should be getting extracted and displayed and scripted now...
fixed... the proper default values should be getting extracted and displayed and scripted now...
Issue #3188 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |