Re: MAPICS-L Digest, Vol 9, Issue 86
"Michael J. Raber" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
You should lock/unlock the DTAARA before/after the three lines, to be sure that the transaction number is unique. Mit freundlichen Grüßen/Best regards Michael Raber ------------------------------------------------------- Dipl.-Ing. Michael J. Raber Consulting - Projectmanagement - Software-Engineering Villar-Perosa-Straße 10 75038 Oberderdingen Tel: +49 7045 2006880 Fax: +49 7045 2006881 Mobil: +49 1520 8523330 eMail: [email protected] Web: www.mjraber.de Skype: mjraber Am 04.07.2011 10:30, schrieb Iain Wilson: > Hi Marc > > > The next transaction number is in data area > > RTVDTAARA DTAARA(*LIBL/ZNXTRN) RTNVAR(&TRNO) > CHGVAR VAR(&TRNO) VALUE(&TRNO + 1) > CHGDTAARA DTAARA(*LIBL/ZNXTRN) VALUE(&TRNO) > > > Can't remember where I found this code for the queue > > C EXSR SNDDQ > > C Return > > C SNDDQ BEGSR > > * > > C CALL 'QSNDDTAQ' PDQJUC > > C MOVE '1' *INLR > > * > > C ENDSR > > C PDQJUC PLIST > > C PARM 'DQJUC' QNAME# 10 > > C PARM '*LIBL' QLIBR# 10 > > C PARM 1 QFLDL# 5 0 > > C PARM '1' QFIEL# 1 > > > Regards > > Iain > > > > > > > > > > > -----Original Message----- > From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] > On Behalf Of mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Sent: 30 June 2011 16:54 > To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: MAPICS-L Digest, Vol 9, Issue 86 > > Send MAPICS-L mailing list submissions to > mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.midrange.com/mailman/listinfo/mapics-l > or, via email, send a message with subject or body 'help' to > mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] > > You can reach the person managing the list at > mapics-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of MAPICS-L digest..." > > > Today's Topics: > > 1. Re: Posting Inventory Transactions via ODBC ([email protected]) > 2. Re: Offline Orders Process (Thompson, Ricky) > 3. Re: Offline Orders Process (Wyatt, Chris (FGWA-IL)) > 4. Re: Offline Orders ProcessABAWXFR (DGowen-KH87JHHfSKradGDVLbOUCQC/[email protected]) > 5. Transaction times periodically increase (Mike Tribbe) > 6. Re: Transaction times periodically increase > (Wyatt, Chris (FGWA-IL)) > 7. Re: Transaction times periodically increase > ([email protected]) > > > ---------------------------------------------------------------------- > > message: 1 > date: Wed, 29 Jun 2011 09:26:00 -0700 > from: [email protected] > subject: Re: [MAPICS-L] Posting Inventory Transactions via ODBC > > TRDATA is the place. The the PM&C UJOB will pick it up automatically, > validate and process (or not). > >> We are planning to perform inventory transactions from an offline process >> and would like to do so near real time with ODBC. If I recall you can do >> this posting to TRDATA but wanted to confirm that this is the proper place >> and if not get some direction regarding were we should post the data to be >> processed. >> >> >> >> Marc Rohde >> >> >> >> _______________________________________________ >> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list >> To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] >> To subscribe, unsubscribe, or change list options, >> visit: http://lists.midrange.com/mailman/listinfo/mapics-l >> or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] >> Before posting, please take a moment to review the archives >> at http://archive.midrange.com/mapics-l. >> >> > > > > ------------------------------ > > message: 2 > date: Wed, 29 Jun 2011 16:15:42 -0400 > from: "Thompson, Ricky"<[email protected]> > subject: Re: [MAPICS-L] Offline Orders Process > > Is there a list of what breaks down the second parameter? Thanks. > > message: 1 > date: Wed, 29 Jun 2011 15:44:28 +0200 > from: "Michael J. Raber"<[email protected]> > subject: Re: [MAPICS-L] Offline Orders Process > > Hi, > > you can use order origin MBC6REP.C6AD0W. Populate this field with a char > (e.g. X) > > and then process with: > > CALL PGM(AMBE8XFR) PARM(' ' '00X000000000000') > > The third char in the second parameter controls which records are > processed. > > We are using this in Release 6 and Release 7 and it works since many years. > > Best regards from Germany > > Michael Raber > > ------------------------------------------------------- > Dipl.-Ing. Michael J. Raber > Consulting - Projectmanagement - Software-Engineering > > Villar-Perosa-Stra?e 10 > 75038 Oberderdingen > > Tel: +49 7045 2006880 > Fax: +49 7045 2006881 > Mobil: +49 1520 8523330 > > eMail: [email protected] > Web: www.mjraber.de > Skype: mjraber > > > This e-mail transmission may contain confidential or legally privileged > information that is intended only for the individual(s) or entity(ies) named > in the e-mail address. If you are not the intended recipient or an agent > responsible for delivering it to the intended recipient, you are hereby > notified that any disclosure, copying, distribution, or reliance upon the > contents of this e-mail is strictly prohibited. If you have received this > e-mail transmission in error, please notify the sender immediately, so that > Endo can arrange for proper delivery, and then please delete the message > from your system. Thank you. > <Virus Scanned by Microsoft ForeFront Online Security> > > > > > ------------------------------ > > message: 3 > date: Wed, 29 Jun 2011 14:14:28 -0700 > from: "Wyatt, Chris (FGWA-IL)"<[email protected]> > subject: Re: [MAPICS-L] Offline Orders Process > > Here's the breakdown of the 2nd parm (Release 6) > > Position 1-1 = Error listing only 1=yes 0=no > Position 2-2 = Purge error records? 1=yes 0=no > Position 3-3 = Order origin > Position 4-14 = Transaction group (the token number) > Positino 15-15 = Print pick list 1=yes 0=no > > Make sure you test this, in case I'm wrong. :) > > -----Original Message----- > From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] > On Behalf Of Thompson, Ricky > Sent: Wednesday, June 29, 2011 3:16 PM > To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: Re: [MAPICS-L] Offline Orders Process > > Is there a list of what breaks down the second parameter? Thanks. > > message: 1 > date: Wed, 29 Jun 2011 15:44:28 +0200 > from: "Michael J. Raber"<[email protected]> > subject: Re: [MAPICS-L] Offline Orders Process > > Hi, > > you can use order origin MBC6REP.C6AD0W. Populate this field with a char > (e.g. X) > > and then process with: > > CALL PGM(AMBE8XFR) PARM(' ' '00X000000000000') > > The third char in the second parameter controls which records are processed. > > We are using this in Release 6 and Release 7 and it works since many years. > > Best regards from Germany > > Michael Raber > > ------------------------------------------------------- > Dipl.-Ing. Michael J. Raber > Consulting - Projectmanagement - Software-Engineering > > Villar-Perosa-Stra?e 10 > 75038 Oberderdingen > > Tel: +49 7045 2006880 > Fax: +49 7045 2006881 > Mobil: +49 1520 8523330 > > eMail: [email protected] > Web: www.mjraber.de > Skype: mjraber > > > This e-mail transmission may contain confidential or legally privileged > information that is intended only for the individual(s) or entity(ies) named > in the e-mail address. If you are not the intended recipient or an agent > responsible for delivering it to the intended recipient, you are hereby > notified that any disclosure, copying, distribution, or reliance upon the > contents of this e-mail is strictly prohibited. If you have received this > e-mail transmission in error, please notify the sender immediately, so that > Endo can arrange for proper delivery, and then please delete the message > from your system. Thank you. > <Virus Scanned by Microsoft ForeFront Online Security> > > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a > message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change > list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives at > http://archive.midrange.com/mapics-l. > > > > ------------------------------ > > message: 4 > date: Wed, 29 Jun 2011 19:30:45 -0500 > from: DGowen-KH87JHHfSKradGDVLbOUCQC/[email protected] > subject: Re: [MAPICS-L] Offline Orders ProcessABAWXFR > > Ricky, > > Below is an example of calling the program with one group# (order#). > Hopefully this will help. > > > fOSAARES0 uf a e k Disk > // off line header file > fOSABCPS0 uf a e k disk > // off line detail file > fOSACCPS0 uf a e k disk > // off line location > > > // ------------------------------------- ship program > D MapShip PR ExtPgm('ABAWXFR') > D Var1 7 > D Var2 1 > D Var3 10 > > > //-------------------------------------------------------- > D GrpNo S 10 > D ShipNo S 7 inz('1') > D ShipSeq S 7 0 inz(0) > d Seven S 7 inz(' ') > > > > We keep track of the group number in a file. > > //-------------- get group# --------------------------- > Chain 'A' groupf; > GrpNo = '0000000000'; > If %found(groupf); > gnumb += 1; > %subst(GrpNo:11- %len(%trim(%char(gnumb)))) = %char(gnumb) > update groupr; > endif; > //-------------- create header ------------------------ > Clear FMXREAT; > > MXNWCD = GrpNo; // Off-Ship Group ID > MXAJSS = '03'; // Off-Ship Type > MXNTCD = c6b9cd; // Off-Ship Number > MXAENB = CDAENB; // Company number > MXA3CD = CDA3CD; // Warehouse > MXDCCD = CDDCCD; // Internal header type > MXCVNB = CDCVNB; // Quote/order number > MXIVNB = %Dec(%Char(%Date(*Date):*CYMD0):7:0); //ship date > etc.................... > fill in all other files per Mapics user guide. Then call....... > > MapShip(Seven:UpdFlg:GrpNo:packit); > > > The group number you pass will be the one that is processed. > > > Regards, > > > > > From: "Thompson, Ricky"<[email protected]> > To: "mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]"<mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> > Date: 06/29/2011 08:18 AM > Subject: [MAPICS-L] Offline Orders Process > Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > > > > We are currently on release 6. But is there a way to only process one > offline order at a time? Can you pass it the token number that you want > to upload and only upload that one token? > > Thanks > > This e-mail transmission may contain confidential or legally privileged > information that is intended only for the individual(s) or entity(ies) > named in the e-mail address. If you are not the intended recipient or an > agent responsible for delivering it to the intended recipient, you are > hereby notified that any disclosure, copying, distribution, or reliance > upon the contents of this e-mail is strictly prohibited. If you have > received this e-mail transmission in error, please notify the sender > immediately, so that Endo can arrange for proper delivery, and then please > delete the message from your system. Thank you. > <Virus Scanned by Microsoft ForeFront Online Security> > > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > > > > > > This message and any files transmitted with it contain privileged and > confidential information. This message is intended only for the use of the > individual or entity to whom it is addressed. If you are not the intended > recipient, or an employee or agent responsible for delivering this message > to the intended recipient, you are hereby notified that any disclosure, > dissemination, distribution, copying, or exploitation of, or taking any > action in reliance on the contents of this message is strictly prohibited. > If you have received this message in error, please notify the sender by > email reply and delete this message from your system. Thank you. > > ------------------------------ > > message: 5 > date: Thu, 30 Jun 2011 10:13:17 -0400 > from: "Mike Tribbe"<[email protected]> > subject: [MAPICS-L] Transaction times periodically increase > > We have users that periodically experience long delays in processing certain > transactions. For example, someone will change a date on a Purchase Order > and the screen will freeze for 3-4 minutes. The problem is intermittent > throughout the day and is not specific to any single transaction (even > though Purchasing complains the most). CPU usage during the delay never > appears high. > > > > How do we troubleshoot to determine the cause (such as other programs that > may be conflicting)? > > > > Mike Tribbe > > Hydrosystems > > > > > > > > ------------------------------ > > message: 6 > date: Thu, 30 Jun 2011 08:25:56 -0700 > from: "Wyatt, Chris (FGWA-IL)"<[email protected]> > subject: Re: [MAPICS-L] Transaction times periodically increase > > I'm not completely sure I'll have an answer, but which interface are you > using? Green screen or Browser/PowerLink? > > And what Release are you on? > > Information on your network infrastructure might be helpful also. > > cw > > -----Original Message----- > From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] > On Behalf Of Mike Tribbe > Sent: Thursday, June 30, 2011 9:13 AM > To: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: [MAPICS-L] Transaction times periodically increase > > We have users that periodically experience long delays in processing certain > transactions. For example, someone will change a date on a Purchase Order > and the screen will freeze for 3-4 minutes. The problem is intermittent > throughout the day and is not specific to any single transaction (even > though Purchasing complains the most). CPU usage during the delay never > appears high. > > > > How do we troubleshoot to determine the cause (such as other programs that > may be conflicting)? > > > > Mike Tribbe > > Hydrosystems > > > > > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a > message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change > list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives at > http://archive.midrange.com/mapics-l. > > > > ------------------------------ > > message: 7 > date: Thu, 30 Jun 2011 10:37:54 -0500 > from: [email protected] > subject: Re: [MAPICS-L] Transaction times periodically increase > > Hi Mike, > > We see this periodically also. I have found that it is usually a lock on > a record from someone else. They get onto a screen and then walk away. > > Check the QSYSOPR messages, there may be a message in there showing the > lock. Otherwise, I look at the Job Log of the job that is slow. > > > > Thanx, > > Nick > > > > Nick Radich > Sr. Programmer/Analyst > EPC Molding, Inc. > Direct (320) 679-6683 > Toll free (800) 388-2155 ext. 6683 > Fax (320) 679-4516 > [email protected] > > > > From: "Mike Tribbe"<[email protected]> > To:<MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]> > Date: 06/30/2011 10:15 AM > Subject: [MAPICS-L] Transaction times periodically increase > Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > > > > We have users that periodically experience long delays in processing > certain > transactions. For example, someone will change a date on a Purchase Order > and the screen will freeze for 3-4 minutes. The problem is intermittent > throughout the day and is not specific to any single transaction (even > though Purchasing complains the most). CPU usage during the delay never > appears high. > > > > How do we troubleshoot to determine the cause (such as other programs that > may be conflicting)? > > > > Mike Tribbe > > Hydrosystems > > > > > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > > > > > ------------------------------ > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) digest list > To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > > > > End of MAPICS-L Digest, Vol 9, Issue 86 > *************************************** > > > This e-mail and any attachments contain material that is confidential for > the sole use of the intended recipient. Any review, reliance or distribution > by others or forwarding without express permission is strictly prohibited. > If you are not the intended recipient, please contact the sender and delete > all copies. > > Tokheim UK LTD. Registered in Scotland No. 58090 > Registered Office: Exchange Tower, 19 Canning Street, Edinburgh EH3 8EH > > > > This e-mail and any attachments contain material that is confidential for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. > > Tokheim UK LTD. Registered in Scotland No. 58090 > Registered Office: Exchange Tower, 19 Canning Street, Edinburgh EH3 8EH > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.