Re: [U2] UniOleDB / UniODBC / HS.ADMIN
On the same topic, we are trying to return 5 million rows, but the select fails at about 2 million rows. Is there a limitation on how many rows can be returned through UniOleDB or through the UniRPC service? Uniiverse 10.2.4 AIX Unix 5.3 We have been using UniODBC to run our DTS jobs (to our DataWarehouse) since before I began working here. I have been told by our VAR that our setup is not typical. We are now attempting to change from UniODBC to UniOleDB using SSIS. The problem that I am encountering is the SQL statement will not recognize the visible files in the same manner. We have a file MO-GL-DET and using ODBC, we have to refer to the file as MO_GL_DET in the SQL statement. But with the OleDB connection the file does not exist. I created a new voc (alias) without the hyphens (MOGLDET) and everything works (even without running HS.UPDATE.FILEINFO). I have been unable locate any documentation regarding UniOleDB and file name constraints. Has anybody else discovered similar discrepancies? Vance CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniOleDB / UniODBC / HS.ADMIN
Uniiverse 10.2.4 AIX Unix 5.3 We have been using UniODBC to run our DTS jobs (to our DataWarehouse) since before I began working here. I have been told by our VAR that our setup is not typical. We are now attempting to change from UniODBC to UniOleDB using SSIS. The problem that I am encountering is the SQL statement will not recognize the visible files in the same manner. We have a file MO-GL-DET and using ODBC, we have to refer to the file as MO_GL_DET in the SQL statement. But with the OleDB connection the file does not exist. I created a new voc (alias) without the hyphens (MOGLDET) and everything works (even without running HS.UPDATE.FILEINFO). I have been unable locate any documentation regarding UniOleDB and file name constraints. Has anybody else discovered similar discrepancies? Vance CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compiling 101
Because of the error message Unable to open BP file.. I believe that it indicates there is currently no pointer to the BP file. From the CODE account ED VOC BP 001 F 002 BP 003 D_BP (or whatever dict you need) From another account after the previous pointer is created in the CODE account ED VOC BP 001 Q 002 CODE 003 BP Vance -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, October 19, 2010 8:29 PM To: U2 Users List Subject: [U2] Compiling 101 I created a new UV account /u2/CODE I put a program in /u2/CODE/BP/FLAVOR.R0. I was not able to compile the program. When I ran the command BASIC BP FLAVOR.R0 I obtained an error message Unable to open BP file. I did a Unix CHMOD command on the parent folders and the file to 777 but still get the same error. I suppose that it is a Q pointer PATH thing. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Cedarville Download (totals using BY.EXP)
Thanks Dave. I think you understood the situation correctly. However, I may have over-simplified the question by omitting that there is also an additional multi-valued field that I am totaling. I have used the NUM.VALUES option for other downloads and forgot about it under this situation. Using NUM.VALUES and TOTAL yields a non-numeric error. The actual TCL statement is more like SORT CASH-REC BY WHSE BY CASH-ACCT# BY BATCH# TOTAL CASH MISC.GL TOTAL DEDUCTIONS BREAK-ON WHSE BREAK-ON CASH-ACCT# BREAK-ON BATCH 08:36:22am 09 Jul 2010 P AGE3 CASH-REC. CASH MISC.GL DEDUCTIONS CO. CASH BATCH... A/C# MISC 19986647.99 6134-33.00 2 1015 6136-14.99 47.99 -47.99 *** In this case, CASH is single valued and Deductions are multi-valued, but the CASH total is not inflated. As always, thank you for your help Vance Alspach John Deere Landscapes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Rotman Sent: Friday, July 09, 2010 8:16 AM To: download-l...@cedarville.edu; u2-users@listserver.u2ug.org Subject: Re: [U2] Cedarville Download (totals using BY.EXP) Vance-- The behavior you are seeing reflects the same behavior you would get with the Unidata LIST statement. I assume Universe would produce similar results. Using BY.EXP causes LIST and DOWNLOAD to produce an output record for each of the multivalues in your field INVOICE. So, running a total on CASH is going to give an inflated value. Here is an approach that may accomplish what you want: SSELECT CASH-REC BY WHSE BY DATE DOWNLOAD CASH-REC _ @ID _ INVOICE _ NUM.VALUES ALL MV.ORIENTATION VERTICAL _ CASH _ FOOTING.ON FINAL LITERAL 'Grand' LITERAL 'Total' TOTAL CASH _ HEADINGLITERAL 'Record' LITERAL 'Invoice' LITERAL 'Cash' This should produce output like this (assuming several invoices per record): Record,Invoice,Cash 308,123456,27.00 ,789012 ,408765 417,22,55.00 ,333444 ,412738 ,510632 ,230288 Grand,Total,82.00 Please let me know if I have misunderstood what you were trying to do. Dave Rotman Associate Vice President for Technology Chief Information Officer Cedarville University 251 N. Main Street Cedarville, OH 45314 rotm...@cedarville.edu voice 937-766-7905 fax 937-766-8819 On 7/8/2010 at 2:40 PM, in message 5350139f0e6341429bc52473d4833700b88ae3e...@mail1.jdl.com, Alspach, Vance valsp...@johndeerelandscapes.com wrote: AIX 5.3 Universe 10.2.4 Pick We have been using Cedarville DOWNLOAD for simple extracts rather developing custom programs for each extract. We are now converting some more complex reports to extracts and having a bit of difficulty. Has anybody ever tried TOTALing a single valued field while using BY.EXP on another field with Cedarville Download? It seems to accumulate the total for each multivalue. This is only an example of what I am experiencing, not the actual DOWNLOAD command. SSELECT CASH-REC BY WHSE BY DATE BY-EXP INVOICE DOWNLOAD CASH-REC BY.EXP INVOICE TOTAL CASH INVOICE CASH INVOICE 27.00 123456 789654 55.00 22 333444 164.00 Acting like, CASH INVOICE 27.00 123456 27.00 789654 55.00 22 55.00 333444 164.00 TIA, Vance Alspach John Deere Landscapes CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe Writeseq Append
Universe 10.0.14 AIX 5.3 I know that in Unidata, you can use a WRITESEQ ... APPEND to append a sequential file. Is there an undocumented way to do this in Universe (other than a READSEQ loop to position the pointer to the EOF)? Thanks in advance. Vance Alspach John Deere Landscapes CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Writeseq Append
Thanks Perry. I'll give it a try. Vance Alspach John Deere Landscapes (248) 588-2100 ext 360 (248) 588-3528 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Friday, November 13, 2009 4:43 PM To: U2 Users List Subject: Re: [U2] Universe Writeseq Append Look at the SEEK statement. CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] COMO OFF / DIVERT.OUT OFF
Our production system is Universe 10.2.4, Pick format on an AIX version 5.3. Execute COMO ON get COMO ON TEST COMO TEST established 13:54:37 22 JUN 2009 Execute COMO OFF get COMO OFF TEST COMO completed. 13:55:05 22 JUN 2009 Invalid keyword OFF on command line. With a little research, I discovered that COMO is a front-end for DIVERT.OUT. However, COMO/DIVERT.OUT both work on our Dev box version 10.0.14 AIX 5.2 and on my personal version. Has anybody else ever experience this? Vance Alspach John Deere Landscapes CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] COMO OFF / DIVERT.OUT OFF
That is amazing. It looks like somebody wrote their own proprietary logoff routine and overwrote the OFF verb. I assumed that DIVERT.OUT OFF was just a parameter and not contigent on the OFF verb. Thanks, Vance Alspach John Deere Landscapes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Monday, June 22, 2009 2:04 PM To: U2 Users List Subject: Re: [U2] COMO OFF / DIVERT.OUT OFF Try comparing the VOC entry for OFF in your systems? Mark CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Triggers
Thank you everybody for your suggestions. My testing has been successful. My stumbling block came with global cataloging. Our ERP is set up in Pick flavor (or flavour depending on where you are from), which doesn't really support global cataloging. What I did was to create a synonym CATALOG command called CATALOG.INFO to be used for cataloging the subroutine using the Information catalog format (suggested by Terry at Strategy 7). Now the problem is adequate tools to test with the ERP database. Our test system is UV 10.0.14 which apparently does not support Triggers (Production is on 10.2.4) With 2000+ users, I am a little apprehensive to implement it cold over night (although my test scenarios on independent files worked fine). What's the worst, I try it, it doesn't work and I look for a new job Also, very nice article Brian. Thanks again. Vance Alspach John Deere Landscapes (248) 588-2100 ext 360 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, August 28, 2008 9:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers Another resource is Brian Leach's article on UniVerse triggers on page 12 of the Nov/Dec 2007 issue of International Spectrum magazine. The issue can be downloaded from: http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx Regards, Clif CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Triggers
What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/