Re: multi member file use in Crystal Reports

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

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.