Re: Difference between creating a View on the Production box vs. Dev-box?

"send over to AEF80" how exactly?

Save/Restore? There's got'chas on how LF (and SQL view/indexes) work..

Especially if the library names are different.

Best Practice is to recreate via the CREATE OR REPLACE <...> script itself.

Charles


On Wed, May 25, 2022 at 3:18 PM Alan Cassidy <cfuture@xxxxxxxxxxx> wrote:

I wrote an SQL statement to *CREATE OR REPLACE MYLIB.MYVIEW.*
*
*
I ran the SQL on the production box. Worked great. The command _RUNQRY
*N MYVIEW _returned the data I expected (and wanted). So my work with
getting to the code is done.
*But then.. *..I ran the /_*same exact statement*_ with the same/
_RUNSQLSTM_ on the Dev-box to create the View and then sent the View
over to AEF80. When I run _RUNQRY *N MYVIEW_, now it gives me zero records.

...You folks that have worked with SQL, any ideas? (I haven't even
gotten to where I can put it into the RPG program to work with). fI
haven't had this problem before. I even got it to work and got good data
once but had to fix some little thing, but I haven't gotten it to do
right by me since.

Anybody know what's going on here? Any suggestions? Even something in he
archives? I don't even know how to search for this kind of issue. It's
hard to believe.

--Alan

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com