Creating SQL table views 8.3 403D

OpenEdge 10.1B doesn't have SQL Explorer anymore so you will have to create
a *.bat file on your server desktop and include these contents.





set dlc=d:\epicor\oe101b

call d:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user
administrator -password yourpassword



REM -infile C:\epicor\odbctableList400.txt -outfile
C:\epicor\odbcresults.txt -sqlverbose





You can take the REM off the last line if you want to use input and output
files.



You also have to modify the username and password elements in the string to
meet your environment. Port too, if you are using a different account than
the live account.and drive letter, path.



When the batch file opens up a command prompt window you need to type in the
following:





CREATE VIEW obbcuser.customer_view AS SELECT * from pub.customer;

COMMIT;





The next time you view your fields through Access you should see the
Customer_View at the top of the list.



Hope this helps,

Ross



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joanne Yargeau
Sent: Friday, June 27, 2008 10:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Creating SQL table views 8.3 403D



We are testing 8.3 403D. Can anyone please provide the detail steps
needed to create the SQL table views of the customer table using MS
Access? TIA.





[Non-text portions of this message have been removed]
We are testing 8.3 403D. Can anyone please provide the detail steps
needed to create the SQL table views of the customer table using MS
Access? TIA.