|
Without knowing what else you might be getting/needing from the customer/part file, you could create a query intended to be run before the first that summarizes the customer/part file by part and counting some field, producing an outfile that contains only one occurrence for each part. Then change the current query to use this summary file as the join-to. Since there will ONLY be one record per item, you'll eliminate the "duplicate" effect you're seeing. -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Kevin Potter Sent: Thursday, February 10, 2005 3:50 PM To: System 21 Users Subject: RE: [SYSTEM21] RE: Doubling of the inventory We are using the the price file to link the customer to the part. In the past their has typically been a 1 to 1 ratio. One part number per each customer. But recently we have been shipping/selling the item to multiple customers and have more than one customer attached to the item. We did not incorporate the customer number into our items (possibly a bad decision). Are there other ways that you would be able to get customer/part info. We use our group major codes in INP 35 for other groupings and would not be able to use that. What was happening is that we would run a query for "Total On hand" inventory for the plant and the items with more than 1 customer number would be added in a second time or 3rd time if a third customer number was created. Any ideas or work arounds would be appreciated -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Peter Joel Sent: Thursday, February 10, 2005 2:33 PM To: 'System 21 Users' Subject: RE: [SYSTEM21] RE: Doubling of the inventory I guess you're using QUERY to link files and you've got the price file as primary. This will find the same stock record each time it finds a price record for the item code, so inventory will be multiplied. Peter Joel Saltway Ltd +44 7884 306501 -----Original Message----- From: system21-bounces+peterj=saltway.com@xxxxxxxxxxxx [mailto:system21-bounces+peterj=saltway.com@xxxxxxxxxxxx] On Behalf Of Shahid Ali Sent: 09 February 2005 15:07 To: system21@xxxxxxxxxxxx Subject: [SYSTEM21] RE: Doubling of the inventory 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 *************************************** _______________________________________________ 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. ********************************************************************** CONFIDENTIALITY NOTICE: The information transmitted in this message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy all copies of this document. Thank you. The Butler Company **********************************************************************
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
