View Full Version : Accessing AS/400 PF members in Crystal Reports
01-01-1995, 02:00 AM
I am using Crystal Reports 8.5 with the Client Access ODBC to access data on the AS/400. How can I access specific members of a PF? I always get the first member. In addition, if the first member is not named the same as the PF, then I get an error. I have just started using Crystal Reports and am very pleased...so far. Thanks in advance for a quick response.
03-14-2001, 02:37 AM
CR does not give you a member option even when using the OLE/ADO connection. I would suggest copying the member to another (new) file. Dave
03-14-2001, 05:12 AM
Depending on file/member sizes, you could try Logical views of the mbr. bobh
03-16-2001, 02:27 PM
Scott, The multiple members problem is a common problem when we start dealing with them via ODBC. You can use the SQL Alias command to create aliases for each member that can then be referenced by the ODBC driver. Bill
03-24-2001, 12:18 PM
//Quick-n-Dirty ODBC/SQL access //If ODBC gives you the annoying "*N" not valid error, //type at As/400 cmd line (ignore //Comments): ADDRDBDIRE RDB(<your as400 Local-control-point name from DSPNETA>) + RMTLOCNAME(*local) //Type the following at As/400 cmd line: STRSQL NAMING(*SQL) //You will now be in interactive SQL (My option 13 on menu CMDSQL) //Type: CREATE LIBRARY.ALIASNAME FOR LIBRARY.FILE(MEMBER) //Example: For ODBC to retrieve my modified IPL startup file //in QGPL/QCLSRC(QSTRUP) I type: //CREATE ALIAS qgpl.myqstrup FOR qgpl.qclsrc(qstrup) //Press F3 and taker option 1 to save session. You normally won't //execute this more than once for each alias you need. //Now browse QGPL with Crystal Reports (or whatever). CA400 ODBC will now //return a file named "myqstrup" which represents file member //QGPL/QCLSRC(QSTRUP). Bob Mills DP Solutions Lufkin TX
05-03-2001, 06:02 PM
How can I access As/400 PF records using Crystal report ? Do I need to have VB installed in my Pc to do this ? Thank You, Deepu
05-04-2001, 02:16 AM
All you need is the ODBC driver that comes free with CA/400. Even if you don't have a CA/400 license, you may still use the ODBC driver free of charge. CR also supports OLE/ADO. Dave
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.