DB2 V7 Import/Run Script problem

**Knut Stolze** · Apr 25 '07, 08:25 AM

Re: DB2 V7 Import/Run Script problem

Graham Hobbs wrote:

does anybody by any chance have FP2?

FixPaks are cumulative, i.e. all changes in FP2 are also in FP3. That's
true to FP1 thru FP7 and FP8 thru FP14 in V7. In V8, all FPs are
cumulative.

and/or
has anybody experienced my problem, if so, which FP rectified the
problem?
--------------------------------------------------------------------------
>
My DB2 is:
Version 7
service lvl 0
release 1
mod 0
running under Windows NT4.0 SP6
>
---------------------------------------------------------------------------
>
Here's what happens:
I imported the following script (partial list only) via the Command
Centre:
>
CONNECT TO WCB3;
DROP TABLE DODBDATA;
CREATE TABLE DODBDATA (
CUSTOMER_NUMBER _AAAAAAA_NUMBER CHAR(5) NOT NULL,
CUSTOMER_NAME_B BBBBBBBBBB_NAME CHAR(33) NOT NULL,
ADDRESS_1 CHAR(33) NOT NULL,
ADDRESS_2 CHAR(31) NOT NULL,
POST_CODE CHAR(7) NOT NULL,
ATTENTION CHAR(10) NOT NULL,
VAT_REGTN_VVVVV VVVVVVVVV_REGTN CHAR(10) NOT NULL,
IN_STOCKS_TTTTT TTTTTTTTTTTTTTX DECIMAL(7,00) NOT NULL,
TOTAL_CARS DECIMAL(7,00) NOT NULL,
ZD_FIELD DECIMAL(3,01) NOT NULL,
ZU_FIELD DECIMAL(3,02) NOT NULL,
PRIMARY KEY (
CUSTOMER_NUMBER _AAAAAAA_NUMBER
)
);
CREATE INDEX DODBDATA_I2 ON DODBDATA (
CUSTOMER_NAME_B BBBBBBBBBB_NAME
ASC);
INSERT INTO DODBDATA (
CUSTOMER_NUMBER _AAAAAAA_NUMBER ,
CUSTOMER_NAME_B BBBBBBBBBB_NAME ,
ADDRESS_1,
etc
>
Then I ran the script and got the following errors (partial list
only)(sorry about the formatting):
>
---------------------------------Script-----------------------------------
E:\conrad\DODB\ ZZJ30DDL.CMD
-----------------------------------------------------------------------------
SQL1001N "WCB3;" is not a valid database name. SQLSTATE=2E000D B21034E
The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it
returned:SQL102 4N A database connection does not exist.
SQLSTATE=08003
>
DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned:SQL102 4N A database connection does not exist.
SQLSTATE=08003
etc, etc
>
... but
>
WCB3 is a database name and the 2E000 says 'Connection name is
invalid'. So I figure the semi-colon after the WCB3 must have
something to do with it and

Please look again at the error message. It says that "WCB3;" is an invalid
database name. You probably did not specify -t option when executing the
script. Thus, the trailing ';' is not treated as statement terminator as
you assumed it would.

a) the script parser ain't that smart
b) you have to tell DB2 the semi-colon is a stmt delimiter (in which
case - I ain't that smart).
>
What really puzzles me is in the old days when FP1/FP2 did the trick,
now FP2's gone (and why?), yet FP3 didn't carry the fix. Can't figure
that at all! Thought these fixpaks were cumulative.

Which "fix" are you talking about? Your mistake when running the script?

p.s: Since V7 (all FP levels) is out of service for more than 1 year,
chances are slim that you will get a lot of help here. You should consider
moving to V8 or V9 (DB2 Express-C in free of charge).

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

DB2 V7 Import/Run Script problem

DB2 V7 Import/Run Script problem

Comment