How to Create SQL View in Progress?

J V

New Member
I created a *.d file with this content:

CREATE VIEW sales_add (code, name, address1,address2, city, state, zip, country)
AS
SELECT SP_MSTR.SP_ADDR, SP_MSTR.SP_SORT, AD_MSTR.AD_LINE1,
AD_MSTR.AD_LINE2, AD_MSTR.AD_CITY, AD_MSTR.AD_STATE,
AD_MSTR.AD_ZIP, AD_MSTR.AD_COUNTRY
FROM SP_MSTR, LS_MSTR, AD_MSTR WHERE (SP_ADDR=LS_ADDR AND LS_TYPE='slsprsn') and
LS_ADDR = AD_ADDR
.
PSC
codepage=ibm850
.
0000008468

and tried to load it using Data Administration's Admin->Load Data and Definition->SQL View menu.

But every time it gives following error:
** _View already exists with View-Name "VIEW". (132)
>> ERROR READING LINE #1 (OFFSET=0)
** Tolerable load error rate is: 0%.
** Loading table _View is aborted.
------------------------------------------------------------------------------
** _View-Col.View-Name is mandatory, but has unknown (?) value. (110)
>> ERROR READING LINE #2 (OFFSET=24)
** Tolerable load error rate is: 0%.
** Loading table _View-col is aborted.
------------------------------------------------------------------------------
** _View-Ref.View-Name is mandatory, but has unknown (?) value. (110)
>> ERROR READING LINE #7 (OFFSET=314)
** Tolerable load error rate is: 0%.
** Loading table _View-ref is aborted.

My view does not have name "VIEW", why it continues to say me view-name "view" already exists?
Could you please tell me, what's wrong I am doing? or What is the correct way to create a view in Progress.
Thanks a lot.
 
Top