Can we manipulate data in PY from DV

Hi List,

I would like to know if there is any possibility to Add/Delete/Update data into a table in PY environment through an Application / UBE logging into DV environment.

If yes can you please let me know how to go about it.

Thanks in advance.

Regards,
Sunny

Hi,
Change your OCM to point to PY data
Thanks

----- Original Message -----
From: "sunnyind" <[email protected]>
To: <[email protected]>
Sent: Tuesday, December 02, 2003 8:59 AM
Subject: Can we manipulate data in PY from DV


Add/Delete/Update data into a table in PY environment through an Application
/ UBE logging into DV environment.If yes can you please let me know how to
go about it.Thanks in advance.Regards,Sunny
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=64820
messages, login to http://www.jdelist.com/forums, click Control Panel, then
click Edit by "Subscribe / Unsubscribe from receiving board posts by email,
change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®

Just some thoughts but I have never tried it. You might be able to do it by changing the OCM mappings for certain tables and the ODBC datasources on the PC (for a Fat Client) to point to PY instead of DV.

For an AS400 Fat Client, OBDC sources are stored on the PC. In theory, I can just change the library to PYDATA for the Business Data TEST ODBC source and it should update PY.

For UBEs you may just be able to override the environment it's updating.

Grant

OCM, Object Configuration Manager, allows you to point diff objects to diff environments.

Gene

Hi Sunny,

For a temp solution you can use the OCM mapping and point your DV table
specs to your PY datasources. This can be done for the entire environment
or as specifically as for just one user.

Or if this is something that you want to do on an ongoing basis you can
create a new environment using the DV Pathcode and the PY Datasources much
the same way that the TEST env uses the TEST (Dev) Data and the PY
pathcode.

Good luck and be careful.

Gerald




sunnyind
<sunny_ind0@lycos To: [email protected]
.com> cc:
Sent by: Subject: Can we manipulate data in PY from DV
jdelist-bounces@j
delist.com


12/02/2003 10:57
AM
Please respond to
JDELIST One World
/ XE Discussions





Hi List,I would like to know if there is any possibility to
Add/Delete/Update data into a table in PY environment through an
Application / UBE logging into DV environment.If yes can you please let me
know how to go about it.Thanks in advance.Regards,Sunny
Sunny
OW733.3 Xe SP 20 ES - Intel NT + Oracle 8.1.6
ERP 8 SP21- D1 ES - Sun Solaris 8 + Oracle 8.1.7
ERP 8 SP21 ES - Windows NT + Oracle 8.1.7
--------------------------
To view this thread, go to: http://www.jdelist.com/ubb/showthreaded.php?Cat
=&Board=OW&Number=64820

This is the JDELIST One World / XE Mailing List. To stop receiving these
messages, login to http://www.jdelist.com/forums, click Control Panel,
then click Edit by "Subscribe / Unsubscribe from receiving board posts by
email, change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®

Create an OCM mapping for a particular user/group/*public, though this affect
all applications etc for the selected users..
Regards,
Kieran Fitzgerald

If you track the Applications that work with the printqueue - you'll notice
that there is an override database taking place within one of the processes.
You can mimic the process to your hearts content.

Daniel



Looking for work out west
Daniel Bohner | JDE P/A III | Freelance-JDE/Web/Photo
www.ExistingLight.Net | www.ExtremeSights.com | [email protected]
JDE XE | SP20 | AS/400 | V5R1

Thanks for your responces.. Do we have to logout and log back to get the changes come in effect made to the OCM mappings.

Thanks

You can set an UBE to run in one environment against data in a different
environment. There is a white paper that specifically addresses how you do this.
This doesn't require changing any OCM mappings.

Patrick Conlon
Allegheny County
XE Update 4 SP 20, AS/400, Citrix, Terminal Server, Java Serve

Yes I believe that OCM mappings are cached so you would have to log off/on.

Patty

I will suggest you to delete Global tables from the fat clients.. It will
make the cahce to be refreshed

Saludos/Best Regards




sunnyind
<sunny_ind0@lycos To: [email protected]
.com> cc:
Sent by: Subject: Re: Can we manipulate data in PY from DV
jdelist-bounces@j
delist.com


03/12/2003 14:50
Please respond to
"JDELIST One
World / XE
Discussions"






Thanks for your responces.. Do we have to logout and log back to get the
changes come in effect made to the OCM mappings.

Thanks
Sunny
OW733.3 Xe SP 20 ES - Intel NT + Oracle 8.1.6
ERP 8 SP21- D1 ES - Sun Solaris 8 + Oracle 8.1.7
ERP 8 SP21 ES - Windows NT + Oracle 8.1.7
--------------------------
To view this thread, go to: http://www.jdelist.com/ubb/showthreaded.php?Cat
=&Board=OW&Number=64871

This is the JDELIST One World / XE Mailing List. To stop receiving these
messages, login to http://www.jdelist.com/forums, click Control Panel,
then click Edit by "Subscribe / Unsubscribe from receiving board posts by
email, change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®






------------------------------------------------------------------------------
The information transmitted is intended only for the person(s)or entity to which it is addressed and may contain confidential and/or legally privileged material. Delivery of this message to any person other than the intended recipient(s) is not intended in any way to waive privilege or confidentiality. Any review, retransmission, dissemination or other use of , or taking of any action in reliance upon, this information by entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer.

For Translation:

http://www.baxter.com/email_disclaimer
==============================================================================

Hi Patrick,

Thanks, but can you send me the link or the document itself. My email id is [email protected]

Thanks

Sunny,

I want to add to all other answer that you can do this WITHOUT OCM change if you only want to use table I/O (NER) on this table. Table I/O using "Handle" can access data in another environment without change to OCM.

Christian Audet

The document ID is OFN-02-0023. The link is=20
https://kgapps2.jdedwards.com/jdecontent/CustomerKnowledge/Knowledge/ofn-02-=
0023.htm

The text from the document is=20
How to use The Override Environments feature in Advanced Properties of=20
OneWorld=AE Report Design
Advanced Report Properties are accessed by selecting Report Properties from=20
the Report pull-down menu within Report Design. Select the Advanced tab.=20
The Override Environments section can be used during the development and=20
testing of a new report; for example if the report needed to be tested by ru=
nning=20
over the Production environment data.=20
The following parameters need to be filled in.
Target - This is used to enter the path for the target environment. The=20
browse button can also be used to specify a location. =20
Source - This specifies the name of the data source the report will use to=20
access all tables. Source will override the default data source for any tab=
le=20
in the report. For example, the report being developed could be selected to=20=
run=20
over production data. =20
Prompt for overrides at runtime - Prompts the user at time of execution to=20
specify the name of a datasource or an environment. This is optional.=20



Have a good day,

Patrick Conlon
Allegheny County
OneWorld XE U4 SP20, Java, Citrix, and Terminal serve