× 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.



There were other good responses regarding using RUNSQLSTM. That may work best for you.

Regarding your errors:
The first error message says that the table doesn't exist. That's pretty straight forward.
The 2nd message is less clear - I think the problem is with the %10,%7 - I tested that here and my sql session does not know what to make of those.


Paul Therrien
Orion South, Inc.
504-374-9551
800-437-7173; Ext. 551
ptherrien@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Wednesday, August 15, 2012 10:50 AM
To: Midrange Systems Technical Discussion
Subject: 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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.