RE: 10 Char object names was...

[Al Barsa <barsa@xxxxxxxxxxxxxxxxxxx>]

This is the first inclination that I've heard of this.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.systemiconnection.com/



                                                                       
             "Kurt Anderson"                                           
             <kjanderson@highs                                         
             mith.com>                                                  To
             Sent by:                  "Midrange Systems Technical     
             midrange-l-bounce         Discussion"                     
             s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>   
                                                                        cc
                                                                       
             02/25/2008 03:34                                      Subject
             PM                        RE: 10 Char object names was...
                                                                       
                                                                       
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.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
--
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.


--
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.

--
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.