SQL and most data-bases other than DB2 have no concept of multi-member files. Since we designed m-Power to work with any data-base, we removed the member definitions that exist in the mrc-Productivity Series data dictionaries from the m-Power data dictionaries.<\/p>\n
At first glance, you might look at this and think that means m-Power cannot handle multi-member files. But you would be wrong. Using multi-member files with m-Power on a System i is different. I’m going to show you how easy it really is with m-Power.<\/p>\n
Suppose I have a multi-member physical file called ‘myfile<\/em>‘ in a library called ‘mylib<\/em>‘ with two members called ‘mbr1<\/em>‘ and ‘mbr2<\/em>‘. Also suppose that I want to build an m-Power servlet over ‘mbr2<\/em>‘.<\/p>\n All I have to do to accomplish this is go into SQL on the System i and create an alias for the file\/member combination I want to use. In this case, the SQL command would be:<\/p>\n CREATE ALIAS mylib\/newfilenm<\/em> FOR mylib\/myfile(mbr2)<\/em><\/p>\n What I have done here is created an alias called ‘newfilen<\/em>m’ in library ‘mylib<\/em>‘. I sign on to m-Power and import ‘mylib\/newfilenm<\/em>‘ into my data dictionary just like I would any other physical file.<\/p>\n That’s it, I am ready to use it to build servlets.<\/p>\n The only functionality that you have with multi-member files in mrc-Productivity Series that you cannot get with m-Power is the ability to build something over the consolidation of all members. Perhaps, the multi-member file users out there should lobby IBM to allow a member name ‘*ALL<\/em>‘ on the CREATE ALIAS command.<\/p>\n","protected":false},"excerpt":{"rendered":" SQL and most data-bases other than DB2 have no concept of multi-member files. Since we designed m-Power to work with any data-base, we removed the member definitions that exist in the mrc-Productivity Series data dictionaries from the m-Power data dictionaries. At first glance, you might look at this and think…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-545","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=545"}],"version-history":[{"count":4,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/545\/revisions"}],"predecessor-version":[{"id":906,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/545\/revisions\/906"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=545"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-category&post=545"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-tag&post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}