All you need to do to query the AS400 (I have been doing it with CF since version 5).
All you need is the JTOpen JDBC driver, get it here: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=expastb jm3 Copy the extracted files to: <cfusion root>\wwwroot\WEB-INF\lib - restart coldfusion Setup a datasource from the web CF admin as a type of 'other', and fill in: Name: (I usually use the library name I am accessing) JDBC URL: jdbc:as400://<system IP>/<Library>;prompt=false; Driver Class: com.ibm.as400.access.AS400JDBCDriver Driver Name: JT400 Username: <your AS400 user name> Password: <your AS400 password> At this point you should be able to query without a problem. If you need to reference something outside of your library defined in the JDBC URL, use dot notation: SELECT * FROM <LIBRARY>.<FILE> Also, if you need to query from a member, you will need to create an alias for the file, like this: CREATE ALIAS <LIBRARY>.<NEWFILENAME> FOR <CURRENT LIBRARY>.<FILE WITH A MEMBER>(<MEMBER NAME>) Then query off your newfilename! Its nice when a question comes up that I know the answers too!! =) Chris Peterson Gainey Corporation -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 1:14 PM To: CF-Talk Subject: Re: DB2 mainframe queries still not working properly! =( For what it's worth, I've just verified that this problem does *NOT* exist when using the HiT JDBC/DB2 driver. Which only costs $8000 for a 2 CPU machine =) Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
