Equivalant part numbers

Yahoo Archive
1
We are already pointing variantA to variantB.



The customer part number would work for individual customers but this is
a universal mapping that could apply to hundreds of customers.



Thanks for the feedback. Anyone else tried to do this kind of thing or
know if it is possible?



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
2
What would be the best way to correct this type of data collection
error?



I have an instance where someone has reported a qty on the final
operation that is more than the operation production qty putting product
into stock that was never made. In the past I have used Labor entry and
just adjusted the labor detail record that is in error to the correct
amount but was wonder if this should really be done through job
adjustment.



Thanks,

Chris



[Non-text portions of this message have been removed]
3
I have tested the job adjustment and when you adjust the labor qty, and
completed check box, it does reflect those transactions in the job
closings. It does not reflect the labor hours in the job closings for
some reason. This is a much more efficient method to adjusting
opperation quanities than labor entry, but I would like to find out how
to add labor hours to the adjusted opperation changes or why those
canges in the job adjustment are not refelcted in the job closings.

Thanks,

Kip
>
4
We have certain items that may be sold under more than one part
number for customer convenience. Our solution to date has been to
maintain the multiple part numbers and choose one as the stocked item
with the others pointint to it via a BOM entry.

VariantA - stocked

VariantB
- made from VariantA
VariantC
- made from VariantA

I would like to eliminate this practice and maintain everything under
one part number. Anyone know of a means to accomplish this? I
thought this feature existed but have been unable to discover
anything other than global linked parts.

Thanks,

John A. Hatcher
Manager of IS
Versa Products Co., Inc.
5
Hello,



I can only speak on Vantage 8.X but what about using the Customer Part
table to map customer part numbers to your numbers?



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jahatcher43
Sent: Wednesday, March 14, 2007 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Equivalant part numbers



We have certain items that may be sold under more than one part
number for customer convenience. Our solution to date has been to
maintain the multiple part numbers and choose one as the stocked item
with the others pointint to it via a BOM entry.

VariantA - stocked

VariantB
- made from VariantA
VariantC
- made from VariantA

I would like to eliminate this practice and maintain everything under
one part number. Anyone know of a means to accomplish this? I
thought this feature existed but have been unable to discover
anything other than global linked parts.

Thanks,

John A. Hatcher
Manager of IS
Versa Products Co., Inc.





[Non-text portions of this message have been removed]
6
Hello,



I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:



CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;



When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)



Does this imply that all users must be out of Vantage before I can
execute this statement?



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



[Non-text portions of this message have been removed]
7
Chris,

I use labor entry to adjust the error. I find that by using job
adjustment, the operation gets too cluttered with negative numbers.
More importantly, if you track efficiencies or other measurables,
these numbers will be skewed because reports usually don't take into
account job adjustments.

Jennifer Mesiano
DuPAGE Machine Products

--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> What would be the best way to correct this type of data collection
> error?
>
>
>
> I have an instance where someone has reported a qty on the final
> operation that is more than the operation production qty putting
product
> into stock that was never made. In the past I have used Labor entry
and
> just adjusted the labor detail record that is in error to the
correct
> amount but was wonder if this should really be done through job
> adjustment.
>
>
>
> Thanks,
>
> Chris
>
>
>
> [Non-text portions of this message have been removed]
>
8
Progress Knowledge Base

http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&docT
ype=1006&contextId=14621%3A129.188&clusterName=CombinedCluster&contentId
=d90b3c6e-23c3-4ef8-a813-63c3fb3ec84d&responseId=a6b23249f80b7ff7%3A1b1f
bf4%3A1114f239f98%3A3ad6&groupId=3&answerGroup=4&score=980&page=http%3A%
2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FES
ERVER_P26368.xhtml&result=3&excerpt=Failure+to+acquire+exclusive+schema+
lock+for+DDL+operation.&resultType=5002#Goto129







Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 10:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OpenEdge 10 - Trying to create a view



Hello,

I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)

Does this imply that all users must be out of Vantage before I can
execute this statement?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
9
Thanks Gerard...I should have started there. :-)



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 10:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view



Progress Knowledge Base

http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&docT
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
T>
ype=1006&contextId=14621%3A129.188&clusterName=CombinedCluster&contentId
=d90b3c6e-23c3-4ef8-a813-63c3fb3ec84d&responseId=a6b23249f80b7ff7%3A1b1f
bf4%3A1114f239f98%3A3ad6&groupId=3&answerGroup=4&score=980&page=http%3A%
2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FES
ERVER_P26368.xhtml&result=3&excerpt=Failure+to+acquire+exclusive+schema+
lock+for+DDL+operation.&resultType=5002#Goto129

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 10:29 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OpenEdge 10 - Trying to create a view

Hello,

I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)

Does this imply that all users must be out of Vantage before I can
execute this statement?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
10
Joe,

I have several views that I have created within a separate
schema that I created.

I create views on the fly within it all the time without any errors or
having to boot anyone. I also like that approach as it segragates my
views from the Vantage tables inside of the PUB schema.



Just a suggestion.

Regards

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 11:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view



Thanks Gerard...I should have started there. :-)

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Progress Knowledge Base

http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&docT
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
T>
ype=1006&contextId=14621%3A129.188&clusterName=CombinedCluster&contentId
=d90b3c6e-23c3-4ef8-a813-63c3fb3ec84d&responseId=a6b23249f80b7ff7%3A1b1f
bf4%3A1114f239f98%3A3ad6&groupId=3&answerGroup=4&score=980&page=http%3A%
2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FES
ERVER_P26368.xhtml&result=3&excerpt=Failure+to+acquire+exclusive+schema+
lock+for+DDL+operation.&resultType=5002#Goto129

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 10:29 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OpenEdge 10 - Trying to create a view

Hello,

I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)

Does this imply that all users must be out of Vantage before I can
execute this statement?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
11
This sounds like a great idea Gerard.

Only problem is that I wouldn't know where to start :-)



Can you offer some guidance?



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 11:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view



Joe,

I have several views that I have created within a separate
schema that I created.

I create views on the fly within it all the time without any errors or
having to boot anyone. I also like that approach as it segragates my
views from the Vantage tables inside of the PUB schema.

Just a suggestion.

Regards

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 11:08 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Thanks Gerard...I should have started there. :-)

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Progress Knowledge Base

http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&docT
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
T>
ype=1006&contextId=14621%3A129.188&clusterName=CombinedCluster&contentId
=d90b3c6e-23c3-4ef8-a813-63c3fb3ec84d&responseId=a6b23249f80b7ff7%3A1b1f
bf4%3A1114f239f98%3A3ad6&groupId=3&answerGroup=4&score=980&page=http%3A%
2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FES
ERVER_P26368.xhtml&result=3&excerpt=Failure+to+acquire+exclusive+schema+
lock+for+DDL+operation.&resultType=5002#Goto129

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > >

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 10:29 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OpenEdge 10 - Trying to create a view

Hello,

I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)

Does this imply that all users must be out of Vantage before I can
execute this statement?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
12
Can you use something like Customer Part Number "VariantB" that
points to your VaraintA part?

Steve

--- In vantage@yahoogroups.com, "jahatcher43" <johnh@...> wrote:
>
> We have certain items that may be sold under more than one part
> number for customer convenience. Our solution to date has been to
> maintain the multiple part numbers and choose one as the stocked
item
> with the others pointint to it via a BOM entry.
>
> VariantA - stocked
>
> VariantB
> - made from VariantA
> VariantC
> - made from VariantA
>
> I would like to eliminate this practice and maintain everything
under
> one part number. Anyone know of a means to accomplish this? I
> thought this feature existed but have been unable to discover
> anything other than global linked parts.
>
> Thanks,
>
> John A. Hatcher
> Manager of IS
> Versa Products Co., Inc.
>
13
To create the new schema, open sql explorer and type the following:

"Create user <username>, <password>;"



"commit";



Ie .... CREATE USER ODBCUSER,VANTAGE;



After that you can create your view:

CREATE VIEW ODBCUSER.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;



Then grant the select privilege on the new view:



GRANT SELECT ON ODBC.JOBHEADVIEW TO ODBCUSER;



COMMIT;



I've received conflicting opinions as to whether the final step is
nescesary since ODBCUSER is actually the schema owner but I do it
anyway.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 12:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view



This sounds like a great idea Gerard.

Only problem is that I wouldn't know where to start :-)

Can you offer some guidance?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 11:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Joe,

I have several views that I have created within a separate
schema that I created.

I create views on the fly within it all the time without any errors or
having to boot anyone. I also like that approach as it segragates my
views from the Vantage tables inside of the PUB schema.

Just a suggestion.

Regards

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 11:08 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Thanks Gerard...I should have started there. :-)

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Progress Knowledge Base

http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&docT
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
>
T>
ype=1006&contextId=14621%3A129.188&clusterName=CombinedCluster&contentId
=d90b3c6e-23c3-4ef8-a813-63c3fb3ec84d&responseId=a6b23249f80b7ff7%3A1b1f
bf4%3A1114f239f98%3A3ad6&groupId=3&answerGroup=4&score=980&page=http%3A%
2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FES
ERVER_P26368.xhtml&result=3&excerpt=Failure+to+acquire+exclusive+schema+
lock+for+DDL+operation.&resultType=5002#Goto129

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > > >

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 10:29 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OpenEdge 10 - Trying to create a view

Hello,

I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)

Does this imply that all users must be out of Vantage before I can
execute this statement?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
14
I have done this as well but it still seems like I had to stop the
appservers. I dialed in over the weekend when no one was using the
system.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 12:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view



To create the new schema, open sql explorer and type the following:

"Create user <username>, <password>;"

"commit";

Ie .... CREATE USER ODBCUSER,VANTAGE;

After that you can create your view:

CREATE VIEW ODBCUSER.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

Then grant the select privilege on the new view:

GRANT SELECT ON ODBC.JOBHEADVIEW TO ODBCUSER;

COMMIT;

I've received conflicting opinions as to whether the final step is
nescesary since ODBCUSER is actually the schema owner but I do it
anyway.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 12:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

This sounds like a great idea Gerard.

Only problem is that I wouldn't know where to start :-)

Can you offer some guidance?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 11:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Joe,

I have several views that I have created within a separate
schema that I created.

I create views on the fly within it all the time without any errors or
having to boot anyone. I also like that approach as it segragates my
views from the Vantage tables inside of the PUB schema.

Just a suggestion.

Regards

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 11:08 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Thanks Gerard...I should have started there. :-)

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, March 14, 2007 10:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] OpenEdge 10 - Trying to create a view

Progress Knowledge Base

http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&docT
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
>
T>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
<http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=129&doc
>
>
>
>
T>
ype=1006&contextId=14621%3A129.188&clusterName=CombinedCluster&contentId
=d90b3c6e-23c3-4ef8-a813-63c3fb3ec84d&responseId=a6b23249f80b7ff7%3A1b1f
bf4%3A1114f239f98%3A3ad6&groupId=3&answerGroup=4&score=980&page=http%3A%
2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FES
ERVER_P26368.xhtml&result=3&excerpt=Failure+to+acquire+exclusive+schema+
lock+for+DDL+operation.&resultType=5002#Goto129

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > > >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >
<http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> > > > >

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Wednesday, March 14, 2007 10:29 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] OpenEdge 10 - Trying to create a view

Hello,

I am trying to create a view against JobHead because there are too many
indexes for Microsoft Access.

I am using the following SQL statements to create this view:

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

COMMIT;

When I execute these statements I get an error message that reads:

=== Statement 1. ===

CREATE VIEW PUB.JobHeadView AS

SELECT * FROM PUB.JobHead

WITH CHECK OPTION;

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC OpenEdge Driver]:Failure to acquire exclusive schema lock for DDL
operation. (7872)

Does this imply that all users must be out of Vantage before I can
execute this statement?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]