One World ODA looking for table data in SYS7333

lagerboy1

Active Member
We have a need to use the ODA via excel/MS Query and whilst it lists all the tables and even shows fields when I try and finish the query it fails with SQL0204 and seems to be looking for data in SYS7333 and not DV7333. If I uses a table that exists in SYS7333 eg F00950 it works fine.
We are using AS400 V5R3 with XE and ODA 1.75.00.00
There seems to be no settings on ODA I can change, has anyone else had this issue or do you have any ideas?
 

Similar threads

E9.2 Performing SQL statements on ODBC OneWorld ODA causes Memory Access Violation
Replies
4
Views
1K
michal_kluka
Selva89
E9.2 SQL Table for Document Type and Description
Replies
3
Views
1K
eydeak
A7.3 List of database tables used by the HR and Payroll modules
Replies
0
Views
507
Daniel Ulisses Da Meda
E9.2 Logic Extension - {28=DD validation failed for value null}
Replies
4
Views
624
Kevin Long
Kevin Long
E9.2 Extracting BLOB data from F95631 via a Data Request in Orchestrator - Base64?
Replies
14
Views
1K
Luyendijkleo
Back
Top