Re: Differences between STRSQL and RUNSQLSTM

["Glenn Gundermann" <ggundermann@xxxxxx>]

Unfortunately, RUNSQLSTM does not support SELECT.

Glenn Gundermann
ggundermann@xxxxxx
(647) 272-3295

> I get the impression that there are differences in how the above two
> products treat SQL, but I can't find any specific documentation on what
> the differences might be..
>
> The following test SQL runs correctly through STRSQL:
>
>
>
> select agtbra from (select * from anvfiles/agtmas) as x
>
>
>
> When I put this statement into a script I get the following (cut &
> paste):
>
>
>
> Record  *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
> ...+... 7 .
>
>        1 select agtbra from (select * from anvfiles/agtmas) as x;
>
>
>                                   * * * * *  E N D  O F  S O U R C E  *
> * * * *
>
>  SQL0084  30       1  Position 1 SQL statement not allowed.
>
>
>                      Message Summary
>
>
>    Total     Info   Warning      Error   Severe  Terminal
>
>
>        1        0         0          0        1         0
>
>
>  30 level severity errors found in source
>
>
>
> Should I expect the two products to behave exactly the same way?
>
>
>
> Thanks