Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables.
I tried to create an alias over the table and then create the view but that is not allowed. I also tried to create a Logical file only over the specific member, but you can't use logical files in a view either. I know I could create a stored proc to do the join, but the vendor that installed our Reporting app(webfocus, which all this is for) has yet to give us details on how to setup WebFocus to use Iseries stored procs.
Does anyone have a an idea how to create a view over members in a table?