| View previous topic :: View next topic |
| Author |
Message |
Freddy
Guest
|
 Posted: Tue Aug 05, 2003 11:40 am Post subject: Selecting from AS400 |
 |
|
Hi there everyone.
I am working a project, needing to access a file on an AS400 Server.
The problem is I have never worked on a AS400 before.
How would I write a query to retrieve a file called "x" from a Library
called "y"
Thanks
|
|
| Back to top |
|
 |
K. Hoffrath
Guest
|
| Posted: Wed Aug 06, 2003 6:42 am Post subject: Re: Selecting from AS400 |
|
|
Freddy wrote:
| Quote: | The problem is I have never worked on a AS400 before.
How would I write a query to retrieve a file called "x" from a Library
called "y"
|
We use Delphi/400 as middleware but it should work with other
libraries too.
Steps to take:
1) Define a database connection in your programm.
2) Add a query and set the database property to your database.
3) Write your sql into Query.SQL, e.g. "select * from y/x" where y is the
library and x is the file. If you have logical files you can use them also.
HTH
--
Karsten Hoffrath
|
|
| Back to top |
|
|
DJ van Wyk
Guest
|
| Posted: Wed Aug 06, 2003 10:02 am Post subject: Re: Selecting from AS400 |
|
|
I'm using Delphi 5 Professional in conjunction with IBM Client Access.
With this you can go the ODBC route or the dbExpress route, each with
it's own pros and cons.
Set your ODBC just like any other ODBC driver. Remember to set the
correct library with the correct profile (username/password)
1) Define a database connection in your programm.
2) Add a query and set the database property to your database.
3) Write your sql into Query.SQL, e.g. "SELECT * FROM x" where x is the
file.
Hope this will help.
DJ van Wyk
Freddy wrote:
| Quote: | Hi there everyone.
I am working a project, needing to access a file on an AS400 Server.
The problem is I have never worked on a AS400 before.
How would I write a query to retrieve a file called "x" from a Library
called "y"
Thanks
|
|
|
| Back to top |
|
|
Betsy
Guest
|
| Posted: Fri Nov 14, 2003 10:42 pm Post subject: Re: Selecting from AS400 |
|
|
DJ van Wyk,
d5 pro with IBM Client Access... come back!
I am currently upgrading from d5 to d7 and transitioning from ODBC to ADO...
I am encountering some little problems using the ADO connection/objects via
the IBMDA400 provider and am scanning sources to find out if I am going
about this all wrong.
We do use Client Access here... so am wondering if I would be better off
using DBExpress and dbexpca400 driver/provider (did I say all of that
right?)
Can you offer your experience to me to assist in answering this question for
me? Why would I pick one over the other?
thank you
b
"DJ van Wyk" <DJvanWyk (AT) ProMed (DOT) co.za> wrote
| Quote: | I'm using Delphi 5 Professional in conjunction with IBM Client Access.
With this you can go the ODBC route or the dbExpress route, each with
it's own pros and cons.
Set your ODBC just like any other ODBC driver. Remember to set the
correct library with the correct profile (username/password)
1) Define a database connection in your programm.
2) Add a query and set the database property to your database.
3) Write your sql into Query.SQL, e.g. "SELECT * FROM x" where x is the
file.
Hope this will help.
DJ van Wyk
Freddy wrote:
Hi there everyone.
I am working a project, needing to access a file on an AS400 Server.
The problem is I have never worked on a AS400 before.
How would I write a query to retrieve a file called "x" from a Library
called "y"
Thanks
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
