× 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 opened the following case with Answerlink:
"We sometimes assign distinct customer numbers to different divisions of the 
same customer. There exists only a single Linked Item Maintenance (10 / INM) 
for each part number. But in the Pricing Type (3 /OEA) the same part number is 
attached to 2 different customer numbers (although the same customer). When 
System 21 driven queries are run, the inventory for 1 part number is shown as 
double the actual amount. Is there a way to get around this situation?" Well 
rather than explaining a work around the problem, GEAC tried to work around the 
answer. So, has anybody on the list come across the same issue? What have you 
done? Please advice.

Thanks

-------------------------------------------------- 
Shahid Ali
SAli@xxxxxxxxxxxxxxx
System 21 Team Member 

The Crown Group
Corporate Offices
2111 Walter Reuther Drive
Warren, MI 48091-6199 
Phone:  (586) 575-9800
Direct:  (586) 558-5309
Fax:      (586) 575-9856 

No institution can possibly survive if it needs geniuses or supermen to manage 
it. It must be organized in such a way as to be able to get along under a 
leadership composed of average human 
beings.                                        Peter Drucker


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On 
Behalf Of system21-request@xxxxxxxxxxxx
Sent: Wednesday, February 09, 2005 9:32 AM
To: system21@xxxxxxxxxxxx
Subject: SYSTEM21 Digest, Vol 3, Issue 13

Send SYSTEM21 mailing list submissions to
        system21@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
        system21-request@xxxxxxxxxxxx

You can reach the person managing the list at
        system21-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of SYSTEM21 digest..."


Today's Topics:

   1. An old chestnut... (Jeff Klipa)
   2. Re: An old chestnut... (Rick Allen)
   3. Connectivity question (Neil Thursby)
   4. RE: Connectivity question (Darrell Watercott)
   5. RE: Connectivity question (Ram Hari)
   6. RE: Connectivity question (jroesch@xxxxxxxxxxxxxxx)
   7. RE: Connectivity question (Rob Rogerson)
   8. RE: Connectivity question (forums@xxxxxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Tue, 08 Feb 2005 22:17:40 +0000
from: "Jeff Klipa" <jklipa@xxxxxxxxxxx>
subject: [SYSTEM21]   An old chestnut...

I see an Answerlink Solution (dated 1/31/05) to this and is says buy a copy 
of Aurora...
We're still at 3.5.2-SP4...

I know we've covered this one before but I'm having trouble...

I am trying to run Verify Allocations in Machine Manager...
Basically this means a call to XA705...

Has anyone ever found a way around this limitation...?

Thanks.

When I run it I get a program dump for pgm ICF702 and XA999...

Program Name . . . . . . . . . . . . . :   IPGCFP4/ICF702
Program Status . . . . . . . . . . . . :   00000
Previous Status  . . . . . . . . . . . :   00907
                decimal-data error in field (C G S D F).
Statement in Error . . . . . . . . . . :   99999999

Program Name . . . . . . . . . . . . . :   IPGCFP4/XA999
Program Status . . . . . . . . . . . . :   00907
                decimal-data error in field (C G S D F).
Previous Status  . . . . . . . . . . . :   00000
Statement in Error . . . . . . . . . . :   99999999




------------------------------

message: 2
date: Wed, 9 Feb 2005 08:30:09 +1000
from: Rick Allen <rick.allen@xxxxxxxxxxx>
subject: Re: [SYSTEM21]   An old chestnut...





Hi Jeff,

I have also seen this issue in the past but not since we moved to SP4.

I happily run verify applications via MM 3 times each 24hr period. However,
I have created a bespoke task to call XA705 in batch and MM uses the task.
Just maybe that is the answer?

Previously when I queried JBA/GEAC re these dumps the response was to "not
worry about them as the program still does what it is intended to do". That
indicates to me that it is intended to dump????

BR



Rick Allen
Voest Alpine Mining & Tunnelling Pty Limited, IT
Office Phone: +61 (0)2 4985 2622


This e-mail is confidential and it is intended only for the addressees. Any
review, dissemination, distribution, or copying of this message by persons
or entities other than the intended recipient is prohibited. If you have
received this e-mail in error, kindly notify us immediately by telephone or
e-mail and delete the message from your system. The sender does not accept
liability for any errors or omissions in the contents of this message which
may arise as a result of the e-mail transmission.



                                                                                
                                                      
                                                                                
                                                      
                                                                                
                                                      
                                                  To:                           
                                                      
                                                         system21@xxxxxxxxxxxx  
                                                      
           "Jeff Klipa" <jklipa@xxxxxxxxxxx>                                    
                                                      
                                                                                
                                                      
                                                  cc:                           
                                                      
                                                                                
                                                      
           Sent by:                                                             
                                                      
           system21-bounces@xxxxxxxxxxxx                                        
                                                      
                                                                                
                                                      
                                                                                
                                                      
           09/02/2005 09:20 AM                    Subject:                      
                                                      
           Please respond to System 21 Users             [SYSTEM21]   An old 
chestnut...                                              
                                                                                
                                                      
                                                                                
                                                      




I see an Answerlink Solution (dated 1/31/05) to this and is says buy a copy

of Aurora...
We're still at 3.5.2-SP4...

I know we've covered this one before but I'm having trouble...

I am trying to run Verify Allocations in Machine Manager...
Basically this means a call to XA705...

Has anyone ever found a way around this limitation...?

Thanks.

When I run it I get a program dump for pgm ICF702 and XA999...

Program Name . . . . . . . . . . . . . :   IPGCFP4/ICF702
Program Status . . . . . . . . . . . . :   00000
Previous Status  . . . . . . . . . . . :   00907
                decimal-data error in field (C G S D F).
Statement in Error . . . . . . . . . . :   99999999

Program Name . . . . . . . . . . . . . :   IPGCFP4/XA999
Program Status . . . . . . . . . . . . :   00907
                decimal-data error in field (C G S D F).
Previous Status  . . . . . . . . . . . :   00000
Statement in Error . . . . . . . . . . :   99999999


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







------------------------------

message: 3
date: Wed, 9 Feb 2005 11:41:35 -0000
from: "Neil Thursby" <neil.thursby@xxxxxxxxxxxxxxxxxxxx>
subject: [SYSTEM21]   Connectivity question

A little off the System 21 subject I'm afraid, but wonder if anyone can help;

I need to write some records from an RPG program to a SQL Server table.  There 
are a few products out there that claim to enable this.  Has anyone got any 
experience of these products?  Another approach might be a dataq with a vb.net 
program at the Pc end - again has anyone used a dataq in a vb.net program to 
receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended solely 
for the named addressee (s). If you are not the addressee, please do not read, 
copy, use or disclose this transmission and please notify us immediately by 
telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from 
your system.

Although we have taken steps to ensure that this email and attachments are free 
from viruses, we advise that in keeping with good computing practice the 
recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of email 
communications.



------------------------------

message: 4
date: Wed, 9 Feb 2005 06:51:29 -0600 
from: Darrell Watercott <DWATERCOTT@xxxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   Connectivity question

We use a product from RJS called RPG2SQL.  It's easy to learn and use and
works great.  Can go to/from Excel and Access tables as well as SQL Server.

Darrell

-----Original Message-----
From: Neil Thursby [mailto:neil.thursby@xxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, February 09, 2005 5:42 AM
To: System 21 Users
Subject: [SYSTEM21] Connectivity question


A little off the System 21 subject I'm afraid, but wonder if anyone can
help;

I need to write some records from an RPG program to a SQL Server table.
There are a few products out there that claim to enable this.  Has anyone
got any experience of these products?  Another approach might be a dataq
with a vb.net program at the Pc end - again has anyone used a dataq in a
vb.net program to receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from
your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

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


------------------------------

message: 5
date: Wed, 9 Feb 2005 08:22:19 -0500 
from: Ram Hari <RamHari@xxxxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   Connectivity question

Try ASNA VRPG. You can access AS/400 and SQL Server data using one program.
Our website was developed using ASNA
www.asna.com


Ram S. Hari
Information Services
Wasserstrom  
ramhari@xxxxxxxxxxxxxxx
Voice 614.737.8542
Fax    614.737.3275

 -----Original Message-----
From:   Neil Thursby [mailto:neil.thursby@xxxxxxxxxxxxxxxxxxxx] 
Sent:   Wednesday, February 09, 2005 6:42 AM
To:     System 21 Users
Subject:        [SYSTEM21]   Connectivity question

A little off the System 21 subject I'm afraid, but wonder if anyone can
help;

I need to write some records from an RPG program to a SQL Server table.
There are a few products out there that claim to enable this.  Has anyone
got any experience of these products?  Another approach might be a dataq
with a vb.net program at the Pc end - again has anyone used a dataq in a
vb.net program to receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from
your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

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




__________________________________________________________
Message transport security by GatewayDefender.com
6:42:23 AM ET - 2/9/2005



------------------------------

message: 6
date: Wed, 9 Feb 2005 09:08:50 -0500 
from: jroesch@xxxxxxxxxxxxxxx
subject: RE: [SYSTEM21]   Connectivity question

One method is to write your output to an AS400 file.  SQL can be setup to
pull data on a timely, nightly for example, but this is not real time basis.


Another more real time method is to simply FTP the data to SQL Server from
your RPG program.       


-----Original Message-----
From: Neil Thursby [mailto:neil.thursby@xxxxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, February 09, 2005 6:42 AM
To: System 21 Users
Subject: [SYSTEM21] Connectivity question

A little off the System 21 subject I'm afraid, but wonder if anyone can
help;

I need to write some records from an RPG program to a SQL Server table.
There are a few products out there that claim to enable this.  Has anyone
got any experience of these products?  Another approach might be a dataq
with a vb.net program at the Pc end - again has anyone used a dataq in a
vb.net program to receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from
your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

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


------------------------------

message: 7
date: Wed, 9 Feb 2005 09:16:30 -0500
from: "Rob Rogerson" <rrogerson@xxxxxxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   Connectivity question

Yet another solution I have used in the past with Oracle and DB2/400 is
to use Java and JDBC.

You mentioned an RPG solution so this may not be the solution you are
looking for.

Rob

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
jroesch@xxxxxxxxxxxxxxx
Sent: Wednesday, February 09, 2005 9:09 AM
To: system21@xxxxxxxxxxxx
Subject: RE: [SYSTEM21] Connectivity question

One method is to write your output to an AS400 file.  SQL can be setup
to
pull data on a timely, nightly for example, but this is not real time
basis.


Another more real time method is to simply FTP the data to SQL Server
from
your RPG program.       


-----Original Message-----
From: Neil Thursby [mailto:neil.thursby@xxxxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, February 09, 2005 6:42 AM
To: System 21 Users
Subject: [SYSTEM21] Connectivity question

A little off the System 21 subject I'm afraid, but wonder if anyone can
help;

I need to write some records from an RPG program to a SQL Server table.
There are a few products out there that claim to enable this.  Has
anyone
got any experience of these products?  Another approach might be a dataq
with a vb.net program at the Pc end - again has anyone used a dataq in a
vb.net program to receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please
do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission
from
your system.

Although we have taken steps to ensure that this email and attachments
are
free from viruses, we advise that in keeping with good computing
practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means
of
email communications.

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



------------------------------

message: 8
date: Wed, 9 Feb 2005 09:31:10 -0500
from: <forums@xxxxxxxxxxxxxx>
subject: RE: [SYSTEM21]   Connectivity question

I once dabbled with relational database entries (modern day DDM) to another
iSeries' database by ip address. Then in interactive SQL I connected to that
database using CONNECT and happily worked on that remote systems data.

I see no reason why this wouldn't work in embedded sql as well and to a
SQLServer database. 

It's worth investing a few hours to see if you can get it to work. 


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Neil Thursby
Sent: Wednesday, February 09, 2005 6:42 AM
To: System 21 Users
Subject: [SYSTEM21] Connectivity question

A little off the System 21 subject I'm afraid, but wonder if anyone can
help;

I need to write some records from an RPG program to a SQL Server table.
There are a few products out there that claim to enable this.  Has anyone
got any experience of these products?  Another approach might be a dataq
with a vb.net program at the Pc end - again has anyone used a dataq in a
vb.net program to receive As400 data.

Thanks in advance,

Neil.  

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from
your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

_______________________________________________
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) digest 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.



End of SYSTEM21 Digest, Vol 3, Issue 13
***************************************


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.