RE: RUNSQLSTM drop/create alias error

Fran, I think it's time for RCLSTG SELECT(*DBXREF).
Your crossreference files must be damaged. I don't what else could explain
this behavior.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: RUNSQLSTM drop/create alias error

Vern, Elvis, Chuck
I tried several different variations including this last one. Tried deleting
the file as suggested. [dltf trsfdd/impactb - not found]
This is over a copy of the original file. Tried it with ERRLVL(30) and (31).
Same results.
Went to the site suggested. Still not working.

drop alias trsfdd/IMPACTB;
Create alias trsfdd/IMPACTB FOR TRsfdd/TRIMPCPNEW;
UPDATE trsfdd/IMPACTB
set PCPROC = ' ';

RUNSQLSTM SRCFILE(TRSFDD/SQLSRC) SRCMBR(UPDATEIMP) COMMIT(*NONE) ERRLVL(31)


IMPACTB in TRSFDD type *FILE not found.
Message ID . . . . . . : SQL0204 Severity . . . . . . . : 30

Message type . . . . . : Diagnostic

Date sent . . . . . . : 05/12/08 Time sent . . . . . . :
08:46:01


Message . . . . : IMPACTB in TRSFDD type *FILE not found.

Alternative name for file IMPACTB not allowed.
Message ID . . . . . . : CPF327E Severity . . . . . . . : 40
Message type . . . . . : Diagnostic

Date sent . . . . . . : 05/12/08 Time sent . . . . . . :
08:46:01


Message . . . . : Alternative name for file IMPACTB not allowed.

Cause . . . . . : An attempt was made to create, move, or change database

file IMPACTB with alternative name *N into library TRSFDD. However, the

operation was not done for reason code 2. The reason codes are:

1 - The alternative name is not a valid database alternative name.

2 - The alternative name is a duplicate of the alternative name for

database file IMPACTB that already exists in library TRSFDD.

File IMPACTB not created in library TRSFDD.
IMPACTB in TRSFDD type *FILE already exists.
Message ID . . . . . . : SQL0601 Severity . . . . . . . : 30

Message type . . . . . : Diagnostic

Date sent . . . . . . : 05/12/08 Time sent . . . . . . :
08:46:01


Message . . . . : IMPACTB in TRSFDD type *FILE already exists.

Cause . . . . . : An attempt was made to create IMPACTB in TRSFDD or to

rename a table, view, alias, or index to IMPACTB, but IMPACTB already

exists. All tables, views, aliases, indexes, SQL packages, constraints,

triggers, and user-defined types in the same schema must have unique
names.
-- If IMPACTB is a temporary table, it cannot be replaced unless the
WITH
REPLACE clause is specified.

-- If the schema name is *N, this is a CREATE SCHEMA statement. If
this
is a CREATE TABLE or ALTER TABLE statement and the type is *N, IMPACTB is
a
constraint.

Object IMPACTB in TRSFDD type *FILE not found.
IMPACTB in TRSFDD type *FILE not found.

Fran Denoncourt