Re: RUNSQLSTM drop/create alias error

[vhamberg@xxxxxxxxxxx]

Hi Fran

We need the second=level text and maybe the message ID for at least the one that says "not allowed". The top level text is almost never helpful enough, and IBM almost always gives the real reasons in the lower lever stuff.

Yes, I could go find the text, using ways we could all use, but I don't have the time - heh!

Thx
Vern

-------------- Original message -------------- 
From: "Frances Denoncourt" <Frances.Denoncourt@xxxxxxxxxxxxxx> 

> I had a sql stmt that ran just fine until this afternoon. It worked all morning 
> just fine. 
> I think it started aborting when I deleted the file, made mods, recreated it. 
>
> Found something about RCLSTG - not something I'll be doing or asking OPS. 
> I tried using a different alias. Didn't work. 
>
> How do you even view a list of aliases for a file? 
> We don't have a SQL - cannot STRSQL, but can RUNSQLSTM using a source file. 
>
> Spent a couple of hours trying to track this down. Your help would be greatly 
> appreciated. 
> Thanks, 
> Fran 
>
>
> RUNSQLSTM SRCFILE(TRSFDD/SQLSRC) SRCMBR(UPDATEIMP) COMMIT(*NONE) 
> Alternative name for file IMPACT not allowed. 
> File IMPACT not created in library TRSFDD. 
> IMPACT in TRSFDD type *FILE already exists. 
> RUNSQLSTM command failed. 
> RUNSQLSTM command failed. 
>
> After the 'already exists' I tried this: 
> *************** Beginning of data *************************** 
> --drop alias trsfdd/impact; 
> Create alias trsfdd/Impact FOR TRLIBDTA/TRIMPCP ; 
> UPDATE trsfdd/Impact 
> set PCPROC = ' '; 
>
>
> Fran Denoncourt 
> Sr. Programmer/Analyst 
> Pinal County Treasurer's Office 
> Florence, AZ 85232 
> (520) 866-6404 
>
> Receipt of this message does not grant you permission to send me 
> Unsolicited Commercial Email 
> -- 
> 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.