Re: Help with SQL script

paultherrien@xxxxxxxxxxxxxxxxxx wrote:

For something like this I think I would load the script into iNavigator and
execute each statement individually until I found the failing statement(s).

What errors do you get?

Unfortunately, we're not an iNav shop, and never have been. And while I can establish an iNav connection (someone from IBM had to literally talk me through it the first time, in order to send them a spool file on an entirely different matter), all I get are "Messages," "Printer Output," "Printers," and "Jobs."

As to the compilation listing, I already pulled an excerpt of that, for the individual responsible for the script:

1 --==============================================================
2 -- DBMS name: IBM DB2 UDB 9.7 Common Server 3 -- Created on: 2012/8/7 0:46:18 4 --==============================================================
5 6 alter table B_User_Roles 7 drop foreign key F_Relationship_20; 8 . . .

331 --============================================================== 332 -- Table: SM_Addresses 333 --============================================================== 334 create table SM_Addresses 335 ( 336 address_id NUMERIC(20), 337 type INTEGER, 338 country VARCHAR(50),
339 state VARCHAR(50),
340 city VARCHAR(50),
341 road VARCHAR(50),
342 road_number VARCHAR(50),
343 building VARCHAR(50),
344 unit VARCHAR(50), 345 logtitude Decimal (%10,%7), 346 latitude Decimal (%10,%8), 347 postal_code VARCHAR(10), 348 owner_id NUMERIC(20), 349 owner_type INTEGER 350 );
. . .
* * * * * E N D O F S O U R C E * * * * * SQL0204 30 1 Position 1 B_USER_ROLES in *LIBL type *FILE not found. SQL0104 30 345 Position 31 Token ( was not valid. Valid tokens: AS NO FOR NOT FILE WITH CCSID CHECK LOGGED UNIQUE COMPACT DEFAULT.

and for some reason, the line number of the first error message doesn't line up with the line number of the statement to which it refers, so I don't know how reliable the second one is.

--
JHHL