× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I thought that at Devcon, last November, I heard Mike Smith say, during
his keynote speech, that 10+ character object names were on their list
of things they're looking to do. Maybe I misheard?

Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, February 25, 2008 12:56 PM
To: Midrange Systems Technical Discussion
Subject: Re: 10 Char object names was...

What is really odd is that a stored procedure doesn't even physically
reside in a library. It's not as if you can do a WRKOBJ MYLIB/*ALL
*STRPRC iNav has a way of seeing them via the database option but I am
sure that all it is displaying you is the contents of QSYS2/SYSPROCS
And, when I query that I'll be danged if I can see any space for 10
character object names.

So, in this case, is it not the 10 character limitation, but the fact
that you use spaces, slashes and other special characters? Would using
camel case, or some such thing, be acceptable for your Crystal names?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Steve Richter" <stephenrichter@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/25/2008 12:02 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: 10 Char object names was...






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.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.