I looked through the IBI Tech site and searched on the forums but didn't find anything specifically related to my question.

In Dev Studio 7.6.4 I created a new master that has a cluster JOIN of 2 existing masters and the corresponding access file. I then created a Business View of that new master with a small subset of the fields. I then proceeded to FTP the new master and access file with the cluster JOIN and the new business view to our mainframe where we're running FOCUS 7.6.5.

I tried out the new master with the cluster JOIN and it works fine.
I then tried out the new BV, making sure to have SET FOCTRANSFORM=ON in my code. I PRINTed several fields in the BV with no problems.

I then tried a query of:

TABLE FILE <my Business View>
PRINT *
IF RECORDLIMIT EQ 10
END

The results showed every single field in the master with the cluster JOIN that my BV is a view of. I thought that a PRINT * would only print all fields *in the BV*, not all fields in the master it's a view of. I've tried out Report Painter with my new BV and, obviously, only the fields in the BV show up there so I see its usefulness there.

Is the "hiding of fields" in BVs only really useful when using Report Painter in Dev Studio or graphical tools? Should PRINT * really print every field in my master and not just all fields in my BV? This isn't a huge problem if PRINT * does print every single field in the base master. This is just more of a question of *why* does it do that vs. just printing all fields in the BV. I'll be using BVs primarily on the mainframe rather than from Dev Studio for the time being.

Thanks,
James

hmmm
very interesting
i have some bv's on a dev box
i'll go see and report back.

hmmm seems my bv from 764 doesn't work in 765
and my syn editor in DevStu never worked...
so i'm on hold on this project until i can find some doc on cluster joins by hand...

This message has been edited. Last edited by: susannah,

Not only does

PRINT *

expose all fields in the orginal master even when using a BV of the master, but any field in the original master can be used even when you are using:

TABLE FILE <business view>

I tried it yesterday and was able to PRINT some fields not in my BV but that are in the master it's a view of. I guess that means that BVs really only visually limit what fields are available from a master or masters. Still useful but I mistakenly thought they were more like RDBMS views. No biggie though.

James