[U2] U2 SOAP Server for Linux
Can anyone tell me where we can find the software for the Linux version of the U2 SOAP Server. We have looked on the IBM web site but cannot find this software to download. We have the Windows version but want to run this on Linux. Any assistance will be very much appreciated. Sara Burns IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 SOAP Server for Linux
Sara IBM does not supply a U2 specific SOAP server for deployment in any environment. You need to deploy it yourself... Unfortunately, they make the assumption that you know how to do this yourself. It's been covered in a previous topic (which you started :)), I posted some clues on how to invoke the SOAP server supplied with IBM's U2WSD should you wish to try that. The topic can be viewed via Nabble here: http://www.nabble.com/U2-SOAP-Server-tt14039276.html#a14124580 Given that the Jetty SOAP server (it's open source) is merely a Java application, you should be able to deploy upon any OS which has the required Java Runtime Environment version and the applicable JAR files (for the Jetty HTTP/SOAP server and UniObjects for Java, etc). Of course, along with your SOAP web services you've developed. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Tuesday, 5 February 2008 8:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 SOAP Server for Linux Can anyone tell me where we can find the software for the Linux version of the U2 SOAP Server. We have looked on the IBM web site but cannot find this software to download. We have the Windows version but want to run this on Linux. Any assistance will be very much appreciated. Sara Burns --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 SOAP Server for Linux
Sara, As the soap server is part of the U2 client package, I thought that it is not available for Linux yet. There were murmurs at the U2 University that it was under consideration. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Tuesday, February 05, 2008 4:38 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 SOAP Server for Linux Can anyone tell me where we can find the software for the Linux version of the U2 SOAP Server. We have looked on the IBM web site but cannot find this software to download. We have the Windows version but want to run this on Linux. Any assistance will be very much appreciated. Sara Burns IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] VMWare Server (free) Product - UV virtualization?
Gabriel, Doing that successfully with Unidata so imagine Universe would be fine, too, but can't promise that's an accurate guess. I find vmware to be slow and clunky until you get it set up just right with it's allocation of time share and memory. But it is immensely convenient - I keep those USB hard drives around with different worlds on them and can be up and running on any at any time. It's worth the setup hassle. HTH Susan Date: Fri, 1 Feb 2008 18:52:12 -0800 From: Tony G [EMAIL PROTECTED] Subject: RE: [U2] VMWare Server (free) Product - UV virtualization? Full response here: remove.anti.spam.munge.pleaseNebula-rnd.com/blog/ No experience but lots of interest in Xen. HTH T From: Gabriel Green Was wondering if anyone has had any luck running VMWare Server (their free Virtualization product which runs on top of Windows or Linux) to run multiple instances of UV on one piece of hardware. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.20/1260 - Release Date: 2/5/2008 9:44 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects error 30105 Unable to load subroutine on server
Wol From memory (sorry using webmail here) you're calling the subroutine with a record read throug a file object. Make sure you extract the stringvalue for the call or you may get reference errors - remember record is a dynamic array object not a string. This may be why it doesn't fail if the record is changed: it's creating a new reference. Regards Brian In message [EMAIL PROTECTED], David Jordan [EMAIL PROTECTED] writes Hi Wol UniObjects does not like returning unassigned variables, it causes a fatal. In the unibasic subroutine, you could check if the parameter is unassigned and set it to before returning. Thanks - that's a good thing to know. But it's not the case here. The error is that the subroutine never gets called, if I've got it right. Certainly, none of the DataBasic code seems to run (almost the first thing it does is write diagnostic tracking stuff to a file, and that never happens). And all the arguments are assigned in my VB app before I call it, so they should still be assigned when it returns :-) Thanks, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV phantoms
What about a phantom that run for more than three days -Original Message- From: Louie Bergsagel [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 1:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV phantoms I've got a paragraph (UniVerse, Pick flavor) I run every night that copies all phantoms 3 days or older to a PH.BAK file, in case I want them later, a painless way to keep the PH file cleaned out. SELECT PH WITH DATE LT THREE.DAYS.AGO OR WITH (DATE = THREE.DAYS.AGO AND TIME LT 08:00:00pm) SAVE.LIST PH.CLEANUP GET.LIST PH.CLEANUP IF @SYSTEM.RETURN.CODE LT 1 THEN GO NO.RECORDS COPY PH DATA (PH.BAK DATA GET.LIST PH.CLEANUP IF @SYSTEM.RETURN.CODE LT 1 THEN GO NO.RECORDS [I know, overkill, but I like to be sure...] DELETE PH ... LIST DICT PH DATETIMETHREE.DAYS.AGO DICT PH01:24:23pm 04 Feb 2008 Page1 Field. Type Field Conversion.. Column. Output Depth Name.. Field. Definition... Code Heading Format Assoc.. Number DATE I FIELD(@ID,_ D2/ 10RS ,3) THREE.DAYS.AGO I @DATE - 3 D11RS TIME I FIELD(@ID,_ MTHS 10RS ,2) 3 records listed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Switching from D3 to U2
Actually, what was the VAR's reason for switching. One of my client's VAR's forced a switch from UV to UD around 9 years ago when they went from a green-screen app to having rewritten their package with SB. Not SB GUI but regular SB. SB GUI came later for those newer clients. Thanks Mark Johnson - Original Message - From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 10:13 AM Subject: RE: [U2] RE: Switching from D3 to U2 -Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: PCL: command
Mark, Could you post your version of PCL.INCLUDE on PickWiki.com or the U2UG wiki? rex MAJ Programming wrote: I'm surprised someone in any MV hasn't submitted a comprehensive PCL.INCLUDE that would help many of these requests. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Switching from D3 to U2
I can't speak authoritatively for Prelude (Activant), but I suspect they more or less followed where SB+ went. They made a tremendous effort to convert their whole application from all legacy code to SB+ about 13 years ago. Perhaps it was general fear for the future of D3, perhaps it was fear that SB+ would cease to be supported on D3, or perhaps since IBM owned the whole mess and they were IBM business partners, they thought it was the prudent thing to do. From our standpoint, we were happy with D3. It did everything we needed and I really liked FlashConnect for web connectivity. But we were about 3 major versions behind on the Prelude application code and wanted some of the newer features. When Prelude said they would not support the newer versions on D3, we were forced to switch. Conversion by coercion. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Orville Wright didn't have a pilot's license. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Tuesday, February 05, 2008 8:14 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Switching from D3 to U2 Actually, what was the VAR's reason for switching. One of my client's VAR's forced a switch from UV to UD around 9 years ago when they went from a green-screen app to having rewritten their package with SB. Not SB GUI but regular SB. SB GUI came later for those newer clients. Thanks Mark Johnson - Original Message - From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 04, 2008 10:13 AM Subject: RE: [U2] RE: Switching from D3 to U2 -Original Message- From: MAJ So what's the number one reason for switching from D3 to U2? Not to create an onslaught of replies, but I've worked on many MV platforms and have my opinions on each. Because our VAR told use they wouldn't support their product on D3 any longer. grin === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Real programmers don't document. Documentation is for simps who can't read the listings or the object deck. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV phantoms
You'd want to create a ...DAYS.AGO I-type to the length of your longest-running phantom. I just set it to 3 so that on Monday we could see the weekend's work. -- Louie On Feb 5, 2008 6:03 AM, Kathleeni M Hunter [EMAIL PROTECTED] wrote: What about a phantom that run for more than three days --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects error 30105 Unable to load subroutine on server
Okay, but do you reset the routine name before each call? This should not be necessary, but I think that that is what the error message is implying is wrong. -Rick Nuckolls On Feb 2, 2008, at 2:44 PM, Anthony W. Youngman wrote: And all the arguments are assigned in my VB app before I call it --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] copying files in Unix from one IBM AIX computer to another IBM AIX computer
Thanks all for everyone's input! We added a trio of sync commands after every uv -admin -L, and that seemed to do the trick. We had no copy errors. We'll look into the other solutions (rcp -p, and jfs2) and let you know of any improvements. -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Totaling an Oconv'd DICT column
Hey, UV 10.2 / PIOPEN Flavor I'm trying to resolve an erratic issue with totaling on some reports, where it runs the column out to 9 decimals. It only happens when we apply the 'MD2' conversion with an OCONV, rather than using the Conv field in the DICT item. And, it does not happen consistently. Why, then, do it this way? Because we must decide whether to present a foreign currency amount, or a USD amount. We store the foreign currency amount in its output format, but USD in its internal format. Our accountants want the AR Amount to appear in the same column, regardless of currency code. Consider the DICTs: This is what formerly appeared on reports, before handling other currencies: Top of D10 in DICT CRJ, 6 lines, 51 characters. 001: D ACCOUNTS RECEIVABLE AMOUNT 002: 10 003: MD2 004: A/R-TOTAL 005: 10R 006: S Bottom. For diagnostic purposes only, to demonstrate there is no embedded decimal in the data: Top of D10.RAW in DICT CRJ, 6 lines, 52 characters. 001: D AR AMT WITH NO (02/04/08,RBH) 002: 10 003: 004: AR-TOT RAW 005: 10R 006: S Bottom. A simple form of the actual OCONV, without the conditional IF: Top of D10.OCONV in DICT CRJ, 20 lines, 542 characters. 001: I AR AMT - Oconv'd (2/5/8, rbh) 002: OCONV(D10,MD2) 003: 004: AR-TOT OCONV 005: 16R 006: S What is used now in the report; We present field 10 if USD, or field 26 (already converted) otherwise: Top of AR.TOT.USD.FRGN in DICT CRJ, 20 lines, 1,407 characters. 001: I ACCOUNTS RECEIVABLE AMOUNT USD / FGRN (JMK, 15 MAR 2007) 002: IF D22 = USD OR D22 = THEN OCONV(D10,MD2) ELSE D26 003: 004: A/R-TOTAL 005: 10R 006: S Top of D26 in DICT CRJ, 6 lines, 57 characters. 001: D FOREIGN ACCOUNTS RECEIVABLE AMOUNT 002: 26 003: 004: A/R-TOTAL 005: 10R 006: S Bottom. The output: LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL. A/R-TOTAL ====== == nn86.5nn8655nn86.5499989nn49.835.64 5 399989 Beaucoup records listed. [actual figures masked] Thanks for any insights offered, or diagnostic steps. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects error 30105 Unable to load subroutine on server
Wol: If you're using UD there's a tricky way to log UO... activity. If on UV I don't know the technique to do this. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Saturday, February 02, 2008 2:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniObjects error 30105 Unable to load subroutine on server In message [EMAIL PROTECTED], David Jordan [EMAIL PROTECTED] writes Hi Wol UniObjects does not like returning unassigned variables, it causes a fatal. In the unibasic subroutine, you could check if the parameter is unassigned and set it to before returning. Thanks - that's a good thing to know. But it's not the case here. The error is that the subroutine never gets called, if I've got it right. Certainly, none of the DataBasic code seems to run (almost the first thing it does is write diagnostic tracking stuff to a file, and that never happens). And all the arguments are assigned in my VB app before I call it, so they should still be assigned when it returns :-) Thanks, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] i think i got it..
I didn't use -noindexfix -noindex and it retained my indices. -- View this message in context: http://www.nabble.com/-uvrestoreif-I-don%27t-want-to-rebuild-the-index-after-a-restore..-tp15216381p15297376.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV Linux under FreeBSD?
Let me know if you succeed. Thanks, Gabe Louis Guillaume wrote: Gabriel Green wrote: Has anyone successfully installed UV Linux under FreeBSD using FreeBSD's Linux ABI emulation layer? --GG I've been trying w/ NetBSD, but currently have problems with Shared Memory allocation. Louis --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Totaling an Oconv'd DICT column
Both D10.OCONV and AR.TOT.USD.FRGN are using D10 which is already converted. Jerry Banker -Original Message- From: Baker Hughes [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 1:07 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Totaling an Oconv'd DICT column Hey, UV 10.2 / PIOPEN Flavor I'm trying to resolve an erratic issue with totaling on some reports, where it runs the column out to 9 decimals. It only happens when we apply the 'MD2' conversion with an OCONV, rather than using the Conv field in the DICT item. And, it does not happen consistently. Why, then, do it this way? Because we must decide whether to present a foreign currency amount, or a USD amount. We store the foreign currency amount in its output format, but USD in its internal format. Our accountants want the AR Amount to appear in the same column, regardless of currency code. Consider the DICTs: This is what formerly appeared on reports, before handling other currencies: Top of D10 in DICT CRJ, 6 lines, 51 characters. 001: D ACCOUNTS RECEIVABLE AMOUNT 002: 10 003: MD2 004: A/R-TOTAL 005: 10R 006: S Bottom. For diagnostic purposes only, to demonstrate there is no embedded decimal in the data: Top of D10.RAW in DICT CRJ, 6 lines, 52 characters. 001: D AR AMT WITH NO (02/04/08,RBH) 002: 10 003: 004: AR-TOT RAW 005: 10R 006: S Bottom. A simple form of the actual OCONV, without the conditional IF: Top of D10.OCONV in DICT CRJ, 20 lines, 542 characters. 001: I AR AMT - Oconv'd (2/5/8, rbh) 002: OCONV(D10,MD2) 003: 004: AR-TOT OCONV 005: 16R 006: S What is used now in the report; We present field 10 if USD, or field 26 (already converted) otherwise: Top of AR.TOT.USD.FRGN in DICT CRJ, 20 lines, 1,407 characters. 001: I ACCOUNTS RECEIVABLE AMOUNT USD / FGRN (JMK, 15 MAR 2007) 002: IF D22 = USD OR D22 = THEN OCONV(D10,MD2) ELSE D26 003: 004: A/R-TOTAL 005: 10R 006: S Top of D26 in DICT CRJ, 6 lines, 57 characters. 001: D FOREIGN ACCOUNTS RECEIVABLE AMOUNT 002: 26 003: 004: A/R-TOTAL 005: 10R 006: S Bottom. The output: LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL. A/R-TOTAL ====== == nn86.5nn8655nn86.5499989nn49.8 35.64 5 399989 Beaucoup records listed. [actual figures masked] Thanks for any insights offered, or diagnostic steps. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Switching from D3 to U2
From: MAJ Actually, what was the VAR's reason for switching. Mark, SB+ used to be supported for D3 so many developers created apps in D3 that integrated with SB+. When IBM withdrew support for SB+ over D3, people needed to make the decision to trash their SB+ app or to migrate it to U2 in order to continue to receive support. The VAR's reason for switching was simply that if they ever needed help, new features, or fixes, they would need to be running on an IBM database rather than one from a competitor. While this is all perfectly legal business practice, it's blatently predatory. Similarly they could have compelled U2 users to make a decision between U2 and DB2, but thankfully they didn't. There are (at least) two products in our industry (unnamed to avoid persecution) that allow SB+ users to continue using their apps on their platform of choice (including U2) after a relatively painless migration process. HTH T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 SOAP Server for Linux [ad]
As mentioned here before, I have a video on our web site that shows how to create a SOAP server for any MV environment in just a few minutes using mv.NET. remove.pleaseNebula-RnD.com/products/gallery.htm Tony Gravagno Nebula Research and Development Worldwide sales and development services for mv.NET and other developer tools TG@ remove.this.pleaseNebula-RnD.com From: David IBM does not supply a U2 specific SOAP server for deployment in any environment. You need to deploy it yourself... Unfortunately, they make the assumption that you know how to do this yourself. From: Sara Burns Can anyone tell me where we can find the software for the Linux version of the U2 SOAP Server. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV phantoms
If you're on an unix system, the individual records in PH are unix files. There's a unix command (fuser, I think) that will tell you if a process still has the file open or not. If the Phantom is still running, it'll still own the file and fuser will list the PID number of that process. If the Phantom is finished, it won't return a PID and you know the PH record can be deleted whenever you no longer need it. I don't know if there's an equivalent way of doing this on a Windows-based system. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleeni M Hunter Sent: Tuesday, February 05, 2008 8:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV phantoms What about a phantom that run for more than three days -Original Message- From: Louie Bergsagel [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 1:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV phantoms I've got a paragraph (UniVerse, Pick flavor) I run every night that copies all phantoms 3 days or older to a PH.BAK file, in case I want them later, a painless way to keep the PH file cleaned out. SELECT PH WITH DATE LT THREE.DAYS.AGO OR WITH (DATE = THREE.DAYS.AGO AND TIME LT 08:00:00pm) SAVE.LIST PH.CLEANUP GET.LIST PH.CLEANUP IF @SYSTEM.RETURN.CODE LT 1 THEN GO NO.RECORDS COPY PH DATA (PH.BAK DATA GET.LIST PH.CLEANUP IF @SYSTEM.RETURN.CODE LT 1 THEN GO NO.RECORDS [I know, overkill, but I like to be sure...] DELETE PH ... LIST DICT PH DATETIMETHREE.DAYS.AGO DICT PH01:24:23pm 04 Feb 2008 Page1 Field. Type Field Conversion.. Column. Output Depth Name.. Field. Definition... Code Heading Format Assoc.. Number DATE I FIELD(@ID,_ D2/ 10RS ,3) THREE.DAYS.AGO I @DATE - 3 D11RS TIME I FIELD(@ID,_ MTHS 10RS ,2) 3 records listed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Totaling an Oconv'd DICT column
Jerry, Thanks for that thought, but I've already tried it without the CONV in D10. I've removed it temporarily to demonstrate how it all looks, working on that hunch [ but, alas...]. LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP 15:26:35 02-05-08 PAGE 1 A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL.A/R-TOTAL. ======== nnn655nnn655nnn6.5499989nnn9.8 35.64 399989 bunchof records listed. D10 currently: D10 0001 D ACCOUNTS RECEIVABLE AMOUNT 0002 10 0003 0004 A/R-TOTAL 0005 10R 0006 S What's mysterious - is that many days it looks right: LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP 15:30:15 02-05-08 PAGE 1 A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL.A/R-TOTAL. ======== nnn480.83 nnn48083 nnn480.83 nnn480.83 0 1516 records listed. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, February 05, 2008 1:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling an Oconv'd DICT column Both D10.OCONV and AR.TOT.USD.FRGN are using D10 which is already converted. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/