RE: [U2] [UV] Selection help
Hi, We are using Universe 10.2.4 and PIOPEN flavor and this does not work, only the first item in the list is returned. Any further ideas, Regards, Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 23 January 2008 08:16 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Try SELECT LOOKUP.TABLE XYZ SAVING UNIQUE EVAL RAISE(CODE) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Wednesday, January 23, 2008 5:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Selection help I have a table which contains an MV list of codes. What I want to do is get a unique list of codes in the table for a lookup list... Table XYZ @ID = XYZ LINE = 1]2]3]4]5]6]7... CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB... The list I'd like returned is: AAA]BBB]CCC... The semantic I think I'd like is: SELECT LOOKUP.TABLE XYZ SAVING UNIQUE CODE However, this doesn't work. Is there a simple select statement to do this I'm overlooking? Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- 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/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Epson DLQ3500 dot-matrix printer
Hi, Have you considered purchasing a HP printer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: 28 November 2007 12:06 To: u2-users@listserver.u2ug.org Subject: [U2] Epson DLQ3500 dot-matrix printer Hi, Does anyone have any experience of printing barcodes on Epson printers? We have an Epson DLQ3500 dot-matrix printer (in fact we have bought loads of them for Poland). They use a command language called Esc/p. We just cant figure out the syntax to use from the manuals. We have googled everything, tried Easylabel etc, and still can get it to work. What we really need is a sample of someone's code who did it before, in any language... Thanks Andy Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2:UV: Dynamo
Hi Manu, I believe there are a number of 'Dynamo' products out there can you give me details of that your Dynamo product does, I have a lot if experience in one which is a 4GL, if we are talking the same product let me know and I can be of help. Regards, Tim Franklin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: 05 October 2007 15:47 To: u2-users@listserver.u2ug.org Subject: [U2] U2:UV: Dynamo Hi all, Is there someone who have experience with Dynamo product under Universe 9 Unix ? I've a resurrected customer site (UV/AIX)) where I want to go on Linux, but Dynamo is not moveable. Thanks for any help, contact, advice. Manu --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time conversion code
When Brian responded to my original posting he mentioned flavour but did not indicate his, but is ours as requested by a brilliant idea. VOC.@RECORD...9. RELLEVELX 01:00:00 10.1.7 PIOPEN PIOPEN.FOR MAT 10.1.7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 06 June 2007 12:32 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time conversion code Tim Sorry - 'tis flavor dependent :( Not sure how to get round that except by some scraggy coding: Crt Int(YourTime/3600):::Mod(YourTime,3600) Regards Brian Thanks Brian, I have tried that: PRINT OCONV(9,'MT') and get 01:00 The flavor we use is PIOPEN.FORMAT should we use any options? Regards, Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 06 June 2007 10:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time conversion code Tim A regular MT conversion should do that: OCONV(9,MT) - 25:00 Just don't use the H option (MTH or MTHS). Regards Brian I have an internal time of greater than 24hrs (86400) is there a conversion code I can use to display the actual time in hours:minutes e.g. 120:45. We are running Universe 10.1.17 Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- 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/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- 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/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Time conversion code
I have an internal time of greater than 24hrs (86400) is there a conversion code I can use to display the actual time in hours:minutes e.g. 120:45. We are running Universe 10.1.17 Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time conversion code
Thanks Brian, I have tried that: PRINT OCONV(9,'MT') and get 01:00 The flavor we use is PIOPEN.FORMAT should we use any options? Regards, Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 06 June 2007 10:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time conversion code Tim A regular MT conversion should do that: OCONV(9,MT) - 25:00 Just don't use the H option (MTH or MTHS). Regards Brian I have an internal time of greater than 24hrs (86400) is there a conversion code I can use to display the actual time in hours:minutes e.g. 120:45. We are running Universe 10.1.17 Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- 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/ Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Index files
Charles, Thanks for your input, let me answer your questions. What is strange about this corruption is that we use AK extensively and this is the only index we have had problems with. Regards, Tim, Six a half thoughts: 1. You say 1:1 correspondence for ID:PHYS.PALLET.ID, meaning no multivalues, right? YES I ask about multivalues because if there are repeated identical mv entries in a record, SELECTINDEX performs differently in PI vs PICK flavours. See $OPTIONS PIOPEN.SELIDX. We are using PIOPEN flavour 2. And no null PHYS.PALLET.IDs, right? CORRECT 3. It is possible to corrupt an index if the primary data file were copied using an OS-level utility so that the header in the copy still contains pointers to the index. for example you CTRL+[mouse right click] and drag a copy to your sandbox to test with. To search for all indexes, in each VOC do: SELECTF SETINDEX INFORM Records only written using Basic. 4. Corruption can occur if there is a VOC pointer to the path of the type-25 index file itself. (i.e.,, VOC 2 will look something like ...\I_[datafilename]\INDEX.004). That allows you to edit or otherwise manipulate the index valued directly. For that matter basic's OPENPATH could do the same w/o a VOC reference. We use Q pointers to the account were the file actually resides. 4a. You might want to ~temporarily~ create such a VOC item so you can examine the contents of the index just for troubleshooting. Will try this after the next corruption. Thanks for the idea. 5. If you rebuild the index does it work right at first, then somehow get corrupted? Or is it always wrong? It works fine after a rebuild then we get corruptions hours, days, weeks later it is totally random. 6. TCL SELECT works correctly? only Basic's SELECTINDEX fails? How about BSCAN? After a corruption SELECT and SEELCTINDEX fails. Using NO.INDEX will find the records. Beyond that, maybe you could post an example of where it fails? (w/o =0D=OA's?) Not sure what example I can provide. cds Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Index files
We are running UniVerse 10.1.7 and use indexing on a number of files.=0D=0A Randomly on one of the files we keep loosing the index on the same=0D=0A field, PHYS.PALLET.ID.=0D=0A =0D=0A =0D=0A =0D=0A Index name Type BuildNulls In DICT S/M Just Unique Field=0D=0A num/I-type=0D=0A =0D=0A =0D=0A =0D=0A PHYS.PALLET.ID DNot Reqd No Yes SL N6=0D=0A =0D=0A TRUCK.ID DNot Reqd No Yes SL N8=0D=0A =0D=0A ORDER.NO DNot Reqd No Yes MR N1=0D=0A =0D=0A WAYBILL.UMC DNot Reqd No Yes SR N9=0D=0A =0D=0A WAYBILL DNot Reqd No Yes SL N14=0D=0A =0D=0A =0D=0A =0D=0A So SELECTINDEX fails, has anyone experienced similar problems. The data=0D= =0A in the fields is always of the form 4A4N and there is a one to one=0D=0A relationship between the field and the primary key.=0D=0A =0D=0A =0D=0A =0D=0A Regards,=0D=0A =0D=0A Tim=0D=0A =0D=0A =0D=0A Legal Disclaimer:=0A The information contained in this message may be privileged and confident= ial. It is intended to be read only by the individual or entity to whom i= t is addressed or by their designee. If the reader of this message is not= the intended recipient, you are on notice that any distribution of this = message, in any form, is strictly prohibited. If you have received this m= essage in error, please immediately notify the sender and delete or destr= oy any copy of this message=0D=0A --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] reference a variable indirectly?
Try this for size 0001: EQUATE PART.NO LIT 'REC1' 0002: REC1 = 'IT WORKS' 0003: PRINT PART.NO 0004:END Regards, Tim Franklin -Original Message- From: Mats Carlid [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 09:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] reference a variable indirectly? Barry Brevik wrote: UV 9.6.1.3 on Windows. For the longest time this has been bugging me, but right now I could really use this capability. Does anyone know if it is possible to reference a variable indirectly? IOW, I want to be able to store variable names in a file (for example), and then assign values to those variables as the program encounters them. For example, something like this: PARTNO = ''; LOTNO = ''; PARTNAME = '' VAR.NAMES = 'PARTNO':@FM:'LOTNO':@FM:'PARTNAME' * * Next, a magic command that makes the variable * refered to by VAR.NAMES2 equal to 'it works'. (VAR.NAMES2) = 'it works'; * I know this does not work, just example. PRINT LOTNO * * Variable LOTNO is now eq 'it works'. Possible?? Barry No there is no way to do that. You'd need an 'eval' function/statement. But You can do something similar with a subroutine and a function. Subroutine SET( variable name, value ) Function VAL( variable name ) They need to share a common ( or a file ) where variable-value pairs are stored. A straight forward implementation would be to search for the variable name in an mv-string and use the index to look up the value from another mv string. If you know the number of entries you can use arrays. Even if you don't you can still use arrays by running imformation style allowing them to be redimensioned. Then Your program would look like: DEFFUN VAL( var ) CALLING VAL CALL SET( 'LOTNO', 'it works' ) PRINT VAL( 'LOTNO' ) Naive untested implementation. If heavily used you'd need to hash e.g. as MOD( SEQ(VAR[1,1])*LEN(VAR), N )+1 where N is the number of hash points and the dimension of VARS and VALS. SUBROUTINE SET( VAR, VAL) COMMON /..SET/ VARS, VALS LOCATE VAR IN VARS1 SETTING II THEN VALSII = VAL END ELSE VARS-1 = VAR VALS-1 = VAL END RETURN END FUNCTION VAL( VAR ) !! Hashed version COMMON /..SET/ VARS(N), VALS(N) HASH = MOD( SEQ(VAR[1,1])*LEN(VAR), N )+1 RES = LOCATE VAR IN VARS(HASH)1 SETTING II THEN RES = VALS(HASH)II END RETURN (RES) END -- mats --- 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] Upgrading Universe to 10.1.4
We are running aix. -Original Message- From: Raymond DeGennaro II [mailto:[EMAIL PROTECTED] Sent: 09 March 2005 12:11 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upgrading Universe to 10.1.4 At 06:10 + 2005/03/09, Tim Franklin wrote: We are in the process of upgrading a 800+ Universe system from 10.0.7 to 10.1.4, is anyone aware of any functionality that works at the previous release but no longer at the upgrade release. You didn't mention if this was uvNT or a *nix flavor, so here's the one item we found that affects uvNT: The case of the user NT AUTHORITY/system becomes NT AUTHORITY/SYSTEM, so if you have anything that branches based on the userID (e.g. LOGIN PA's), they may break. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- 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] Upgrading Universe to 10.1.4
We are in the process of upgrading a 800+ Universe system from 10.0.7 to 10.1.4, is anyone aware of any functionality that works at the previous release but no longer at the upgrade release. Many thanks, Tim Franklin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] PHANTOM command
I believe in a previous email I have read that it is possible to specify a user name that you can supply on the command line to the PHANTOM command and this user will be used to log on to run the command. Does anyone have the details? Tim Franklin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV-piopen TRANS function
Do you have sub values in your data? if not it maybe useful to write a program to select each file and execute all I-Descriptors that use the TRANS function on each record looking for @SVM in the result. This may take some time to run but will ensure all TRANS have been converted. -Original Message- From: Andrea Charles [mailto:[EMAIL PROTECTED] Sent: 21 January 2005 14:32 To: 'u2-users@listserver.u2ug.org' Subject: [U2] UV-piopen TRANS function Thanks for all the suggestions. I think I am going to bite the bullet and add the RAISE to all i-descriptors. Think I can come up with a BASIC program to accomplish this. And learned about K=K in the process. IBM's response is that this is a documented difference between UniVerse and PIopen and there are no workarounds other than using the RAISE function to raise the results from the TRANS. Andrea --- 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/