Re: 10 Char object names was... -- MIDRANGE-L

Subject: Re: 10 Char object names was...
From: "Steve Richter" <stephenrichter@xxxxxxxxx>
Date: Mon, 25 Feb 2008 12:01:20 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On Mon, Feb 25, 2008 at 11:44 AM, <rob@xxxxxxxxx> wrote:

Whose ODBC client is that? And what happened when you asked them why they
didn't show the long name?

crystal reports is an odbc client to the as400 server. The method I
use when writing CR reports against the data from the 400 ( V5R4 ) is
to write a stored procedure that returns a result set. This way all
the application specific logic of joining tables, selecting and
grouping is encapsulated in a program running on the server. Works
very well. Only problem is I cant assign an sql procedure name that
matches the long descriptive crystal reports report name (
"forecast/GP unit detail", "forecast/GP dollary summary", "rankings
category unit", "rankings category dollar", ... ) This limitation was
confirmed by IBM support.

-Steve

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: 10 Char object names was... , rob

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.