• 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!

ODA in external program

masanchez

Active Member
Hello everyone,

somebody has been worked the ODA in external program? somebody has documentation of like using it?

Regards
 

Larry_Jones

Legendary Poster
Sanchez,

In My Humble Opinion (don't laugh people), ODA is a poor choice for database access by a program (VB?). ODA has several problems that I won't re-iterate here (if you want my opinions on ODA problems search the archives).

I suggest that you create views in your DBMS that contain the data you need and have your program go directly against those views - bypassing ODA/OneWorld.

FWIW,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 

JOHNG

Member
Masanchez, are you talking about bringing in ready only data from JDE into
say..Excel via an ODBC connection??
 
There's quite some documentations in your deployment server that may help
you. You can find it in your InteropManual.pdf which you can find under
/Com/Doc directory in your jde installation directory.

Bell
OneWorld Developer
One World B7332,SP 9, AS/400 V4R4M0
Windows NT; Win2000+Citrix Metaframe 1.8a

----- Original Message -----
From: "masanchez" <marco_cnc@yahoo.com.mx>
To: <jdeowdevml@jdelist.com>
Sent: Tuesday, May 08, 2001 11:50 PM
Subject: ODA in external program


documentation of like using it?
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=10377
 

gabrielsv

Member
Problems with row security using ODA

Hi there..
I got a problem when working with ODA. Let me explain it to you:

I have an enterprise server that uses Oracle as database and I want to get information from it using ODA. I saw documentation about how having ODA enabled when using Oracle. Actually I have gotten information from many different files. However, when I set up row security for some files (F41001, F006), it seems like ODA does not take row security into account. The only condition for row security to work properly is:

Having global tables deleted before running a query AND simultaneously using the restricted columns as filters for such query.

Otherwise, I am able to see all the information from the files, even if I have row security. For example: I can see Cost Center Column (MCU) in Inventory Constants File (F41001), even if I restricted not to view Cost Centers in range from " 10" through
" 30".

Does anybody have any comments about it?
I hope you can help me...
Thanks a bunch
 
Top