RE: Help with SQL script

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.