Re: CPYF = UNION ?

Thx, that's going to work just fine.

Just as a thought - do you need the views for separate usage? If not, you could put the SELECT statements that define the views into one view with a UNION of them - of course, you may already have done that!!

Regards
Vern

On 10/21/2014 5:59 PM, Hoteltravelfundotcom wrote:

i want to create a view that would do a union on 2 logical views.
basically, in our system, we have open orders in 2 places. in the details
file and in history. I need to report on all open orders. it was fine doing
the 'old' way
of 2 queries and then the CPYF.

I changed the queries to views. now i want to add them together.

On Tue, Oct 21, 2014 at 6:55 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

I really need more information - I'll take a stab at something, however.

CPYF is a command, UNION is an SQL keyword.

There is nothing about UNION that makes things any more dynamic, so far as
I can see.

But I don't know where you are getting the data.

Besides, look at the MBROPT parameter of CPYF.



On 10/21/2014 5:38 PM, Hoteltravelfundotcom wrote:

I have gotten the data as I need using CPYF.

Now to make this dynamic, I want to use UNION

Will this be the same as CPYF that is, if all fields are the same legnths
and
# of fields are the same, we get the add perfectly.

--
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.