Re: Drop table and create again in same RUNSQLSTM source member

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rick

There's no check for error level in the source member. You just need to set 
a higher tolerance level in the RUNSQLSTM command - use F9 to see the 
parameter.

HTH
Vern

At 03:44 PM 4/21/2004, you wrote:
> content-class: urn:content-classes:message
> Content-Type: multipart/related; type="multipart/alternative";
>         boundary="----_=_NextPart_001_01C427E1.71A783A8"
>
> A while back there was a post to the list that included an example of 
> dropping a table and then recreating it in a single source member that was 
> used with RUNSQLSTM.  I would like to do the same thing but can't seem to 
> locate the post in either the midrange or RPG list archives.  Would anyone 
> be able to point me to the post or repost the technique?
>
> What I'm missing is how to check for the error if the table doesn't 
> already exist when the drop is executed.  It works fine if the table 
> already exists.
>
> Thanks,
>
> Rick Chevalier