× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.