RE: 10 Char object names was...

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