RE: multi member file use in Crystal Reports

Is CUSTUDENT in the library list of your ODBC data source?
You can invoke the ODBC Administrator utility by clicking on
Start->Run->odbcad32->OK and check the 'Library list' settings, and perhaps
set 'Naming convention' to *SYS if looking at multiple libraries.

Another option is to write a two line stored procedure (SQL or external)
that runs the OVRDBF command followed by a SELECT. You can make it generic
by having it accept parameters specifying which lib/file/mbr is to be
overridden. Then have Crystal report prompt for the parameters or hardcode
them in a stored procedure call.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: multi member file use in Crystal Reports

Elvis, The iSeries SQL statement that I used to create the alias is as
follows:

CREATE ALIAS CUSTUDENT/PSTU2409 FOR SMSFILES/PSTU240(WCBOE09)

I changed the Synonyms option for the Datasource and that did not seem to
help with the current setup.
Nathan, Interesting idea. Crystal has a command line, I will look into this.
You don't happen to know if this can be done that way?

Charles