Comment on: SQL7008
Posted: 10 years 2 months 24 days 20 hours 52 minutes ago
Edited: Mon, 03 Feb, 2014 at 08:52:20 (3735 days ago)
Posted: 10 years 2 months 24 days 20 hours 52 minutes ago
Edited: Mon, 03 Feb, 2014 at 08:52:20 (3735 days ago)
Looks like Commitment Control may be the issue or perhaps NULL-capable defaults on ODBC vs DB2/400.
Check out this link: http://www.querytool.com/help/876.htm
Comment on: SQL7008
Posted: 10 years 2 months 24 days 4 hours 56 minutes ago
Posted: 10 years 2 months 24 days 4 hours 56 minutes ago
Thank you Bob - I added a little more detail regarding the sql problem. I copied and pasted the verbiage below from an
email I got from the programmer involved. Thanks.
I can create views based on any existing table
and I can create new tables with no issue
unless they contain numeric fields.
Executing this from an ODBC link works fine:
CREATE TABLE HEFILE.XOX
(VNAME VARCHAR(40),
HERMVEND VARCHAR(10),
XOVEND VARCHAR(10));
However, if you I change the data type
of a column to INTEGER it fails.
CREATE TABLE HEFILE.XOX
(VNAME VARCHAR(40),
HERMVEND INTEGER,
XOVEND INTEGER);
Comment on: SQL7008
Posted: 10 years 2 months 24 days 17 minutes ago
Posted: 10 years 2 months 24 days 17 minutes ago
CREATE TABLE HEFILE.XOX (VNAME VARCHAR(40), HERMVEND INTEGER NOT NULL DEFAULT 0, XOVEND INTEGER NOT NULL DEFAULT 0 )