Changing the primary table in a joined BSVW

Frosty the Coder

Legendary Poster
I have a custom joined BSVW where the tables were joined in the incorrect order.
I went into design, changed the primary table, and submitted it for DV build/deploy.

Today, I installed that DV package.

When I go into design, the correct table is listed as the primary.

When I look at the SQL statement generated when the BSVW is used,
it appears that my changes did not take effect (or at least not locally).

To address this, I plan on creating a NEW BSVW, w/the tables in the correct sequence,
however I am curious as to why the SQL does not reflect yesterday's change.

Can someone explain this to me?

Thanks
 
I have a custom joined BSVW where the tables were joined in the incorrect order.
I went into design, changed the primary table, and submitted it for DV build/deploy.

Today, I installed that DV package.

When I go into design, the correct table is listed as the primary.

When I look at the SQL statement generated when the BSVW is used,
it appears that my changes did not take effect (or at least not locally).

To address this, I plan on creating a NEW BSVW, w/the tables in the correct sequence,
however I am curious as to why the SQL does not reflect yesterday's change.

Can someone explain this to me?

Thanks

You might try clearing some of the global defs

C:\YOURE1PATH\YOURENV\specs\

on my fat client it here

C:\E910\DV910\spec

see attached for the file list, reboot fat client after

good luck
 

Attachments

  • 4-16-2015 1-06-57 PM.png
    4-16-2015 1-06-57 PM.png
    5.4 KB · Views: 7
Per your suggestion, I cleared "the big six" (via OWDLC) and rebooted, but still see the original SQL statement.
 
I have seen weird things with the SQL packages on the iSeries and how thy interact with JDE. I know it does not seem like it should mater but you could try clearing those out?
 
I know that changing a table requires deleting the SQL packages,
and I think you're correct in that this has something to do with the SQL packages as well.

However, at my current site, this would be a CNC request, which would require some downtime, which is frowned upon.
Further, it would not have been timely.

I went the route of creating a new BSVW and it works as I desired.

This does not mean that I'm disinterested in learning/understanding more, it's just a "not here, not now" issue.

Thanks!
 
Back
Top