Multi-Format logical Files (with keys) cannot be converted into an SQL
Index.
You can create a view with UNION Clauses, but Views cannot be keyed.
Indexes can only be created on a single file (or format) but not for
multiple formats.
The best way is to create a view and convert your native I/O into embedded
SQL or continue to use the keyed multiple-format logical file with native
I/O
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Smith, Mike
Sent: Mittwoch, 23. Mai 2018 19:46
To: Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx)
<midrange-l@xxxxxxxxxxxx>
Subject: multi format logical in sql
I have a multi format logical file. This file has some select omit criteria
and a couple of the formats use fields not in the others, and is keyed.
I'm trying to determine if I can recreate this via sql.
I think I have successfully created a select statement, but I'm not having
much luck creating a view or index
I thought that I might be able to remove the selection criteria and order
and create a view, then maybe create an index over the view
But I'm not having any luck at all.
Can I do this?
Any examples on how to accomplish this?
Thanks
Mike
NOTICE: This message, including any attachment, is intended as a
confidential and privileged communication. If you have received this message
in error, or are not the named recipient(s), please immediately notify the
sender and delete this message.
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
