RE: JBA Reporting -- SYSTEM21

Dan,

We also suffer from a lack of unique key on all JBA files, INP95 and PMP09
being prime examples as you say.  You can work round this by using the
Relative Record Number (RRN) which gives you a unique key.  It works well,
but watch out after archiving when you reorg your files!!!

Regards,
Bill

-----Original Message-----
From: Dan Thomas [mailto:dthomas@xxxxxxxxxxx]
Sent: 07 July 2003 15:45
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


This message has been successfully virus checked by the Centura Foods Mail
system. 

We have been using Transformation server for about three years now and the
performance increase was 10x to 90x depending upon the application.  Our
queries are web Active Server Pages and MS Access.  We do have a low end
AS/400 (620-2179), but that increase was with a moderately configured SQL
Server box (1 ghz Xeon).  We are ordering a new AS/400 810-2466 and a new
SQL Server.  I'll post performance comparisons when both new boxes are
installed.  I expect the differences to be less pronounced, but still
significant.  The nice thing about this setup is that you can optimize the
SQL Server box for queries.  It also provides a nice standby system (i.e.
stock locations) if your AS/400 ever goes down.  You can set up
Transformation server to send data to multiple SQL Server boxes if your
needs dictate.

One thing to keep in mind is that Transformation server is going to want a
unique key for each file.  This is a real challenge for many of the JBA
files.  Biggest problems we have run into is INP95, PMP09 and CRP09.

Dan Thomas
Director of Information Technology
MDI
4500 Progress Blvd
Louisville, KY  40218
(502) 318-1208

This message is a privileged and confidential communication protected by the
Electronic Communications Act and is intended for the designated recipients
only.  Duplication or distribution of this email beyond the intended
recipients without prior written consent of the sender is strictly
prohibited.


-----Original Message-----
From: Bill Pinnington [mailto:BPinnington@xxxxxxxxxxxxx]
Sent: Monday, July 07, 2003 10:00 AM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


Joe,

You can use a product called Transformation Server from Datamirror to
transfer data from your AS/400 to your reporting database (e.g. SQL Server)
in real time.  That way you get much better reporting performance against
real time data, AND free up your 400's CPU for more important stuff.

Regards,
Bill

-----Original Message-----
From: Joe Roesch [mailto:jroesch@xxxxxxxxxxxxxxx]
Sent: 07 July 2003 14:18
To: 'System 21 Users'
Subject: RE: [SYSTEM21] JBA Reporting


This message has been successfully virus checked by the Centura Foods Mail
system. 


The ODBC link (for Crystal) can become very slow depending upon the table
size accessed from the AS400.  Information warehoused in another database,
such as SQL Server or Oracle for example, has exponentially faster access
the larger the data becomes on the AS400.  However, this is limited to data
that is not constantly updated (i.e. pulled hourly or nightly) where real
time is critical.     


-----Original Message-----
From: Angus Appleby [mailto:aappleby@xxxxxxxxxxxxxxxxxx] 
Sent: Thursday, July 03, 2003 11:29 AM
To: System 21 Users
Subject: RE: [SYSTEM21] JBA Reporting

I found the ODBC driver quite slow when trying to create Crystal Reports - 
how are you connecting to the AS/400?

Angus



"Trask, William" <WTrask@xxxxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
03/07/2003 16:03
Please respond to System 21 Users

 
        To:     "'System 21 Users'" <system21@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: [SYSTEM21]   JBA Reporting


Crystal Reports is a terrific product. We use Version 8.5, but there is a
newer one out now.

We use it for System 21 and other AS/400 programs - even tying System 21
records with our HR program.
Reports can be dynamic or static - we publish static reports to our 
Intranet
site for users.
It also has a built in SQL Wizard which comes in handy sometimes.

----------------------
WW (Bill) Trask
Hensley & Company
Phoenix, AZ
 


-----Original Message-----
From: Todd Grass [mailto:tgrass@xxxxxxxxxx] 
Sent: Thursday, July 03, 2003 5:50 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] JBA Reporting


We are searching for a better report writing method than query. Has anyone
used the Crystal product and how did it work for you?

Todd Grass
American National Rubber
TGRASS@xxxxxxxxxx

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.



_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


=======================================================
This email, its content and any files transmitted with it are confidential
and intended solely for the use of the individual(s) to whom it is 
addressed.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.
This email, its contents and any files transmitted with it have been 
prepared using information believed by the author to be reliable and
accurate, but Centura Foods Ltd. makes no warranty as to accuracy or
completeness. In particular Centura Foods Ltd. does not accept 
responsibility for changes made to this email or related files after it was 
sent. Any opinions expressed in this email and any related documents
are those of the author and do not necessarily reflect the opinions of
Centura Foods Ltd. or its associated companies.

If you have received this email in error please notify the Centura Foods
IT Helpdesk by telephone on +44 (0) 1606 830 533.
=======================================================


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________