Re: multi member file use in Crystal Reports

Thank you !!!!! :)

I just discovered that by changing the option on the data source caused my
alias information to display. The reason that I did not see it before was
because I did not exit the Crystal Reports program and come back in after I
made the change. By exiting CR and returning, everything got refreshed in
the data source area. I now have a tables, views and alias tab to display
and retrieve file information.



On Thu, Mar 19, 2009 at 3:18 PM, Elvis Budimlic <
ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.