• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Adding columns to existing view

pradeepmp

Member
Hi list,

This question seems basic, but will be very helpful.. What's the impact of
adding another column to a business view ?? Suppose if I go to a business
view design mode, add 1 or 2 columns from the table, and generate it, will
it cause any problems where this view is aleady used ?? I know if any colums
are removed it can cause problems, but adding a column shouldn't affect any
of the places where the view is used, Am I right ?? Or Do I have to open the
places (UBE/APPLN) and save them again.

Env. B7331/SunOS/NT/Oracle.

Thanks in advance.

Prads.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 

Adrian_Chimirel

Legendary Poster
Prads,

1 - You're 100% right! It's fine to add column(s) to view(s); if you are not using them (as adding'em to your app's or ube's), they're just going to be ignored. There's no need to look for/revalidate objects/statements ... :)

2 - You're right again, problems start ONLY when the apps/ubes do NOT find the deleted ones!

As far as I can tell, there are no basic/deep/hard/difficult questions, at least here, on the JDElist; they are just questions in need to find their answers. And, usually, they do, here on the JD... :)

Adrian Chimirel
Programmer Analyst
LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients
 

Zoltan_Gyimesi

Legendary Poster
Prads, Adrian

I just want to confirm Adrian's answer and make a little, maybe obvious addition.

* append you new fields to the end of the original BSVW
* never change the order of the originally existing fields of the BSVW

At last I would tell that we extended original BSVWs more times and we haven't experienced any problem.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Christian Audet

Moderator
Staff member
Hi Prads,

We already modified a business view in a existing report and the report did not work anymore. If you don't want the same error make sure all the column added are at the end of the business view and you should not have any error.

One of the reason for that is the business view "translator" from OneWorld was doing something like that : select field1, field2 from table order by 1,17,22... So you can imagine what was appening when inserting a field between column 17 and 22, Your View was still sorted on column 1,17,22... Wich is now 1,17,23...

We did a call to JDE tech support and they were supposed to fix the translator to be : select field1, field2 from table order by fieldname, fieldname, fieldname instead of 1,17,22

Christian
 

Zoltan_Gyimesi

Legendary Poster
Just a correction to my previous reply.

We extended only simple, single table based BSVWs and haven't experienced any problem.
We haven't currently any experiences about extending complex, joined BSVWs.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

haritod

Member
Dear Zoltan,

Business View Design appends new fields to the end of the original BSVW by the default and we never change the order of the fields of the BSVW. Nevertheless when I append new field to existing BSVW and generate it again it does not work. Report that uses this BSVW prints out empty fields.

Any ideas?




Env. B733/SP13.3/HP-UX/NT/Oracle
Best regards, mail to: haritod@gum.ru
 

Bill_Feeney

Active Member
I wonder if this is a case of needing to go into the 'C' code and making
sure you populate the new fields? I know sometimes even some master business
functions (Edit Line in R03B11Z1I, for instance)using a table/view don't
populate all the fields and the 'C' code had to be modified. And these were
"as is" from JDE.

Bill Feeney
JDE Technical Developer
B733.2, SP 13.1, Unix, Oracle 8.1.6
 
Top