RE: [U2] Employment disaster
RubbishI have worked for the same couple for more then 10 years. In that time I have gone from only knowing Universe to developing systems in VB6, JAVA, dot.net. It's not the developers that become dinosaurs it's the PHB's that think anything new is better then anything that's gone before, and only some one young can understand this new world. Have you spotted that most new ideas are old ideas with lots of big words wrapped round them?? End of rant...boy am I glad it's Friday Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 23 April 2009 17:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Employment disaster That may be right, but smart companies don't hire someone, who got stuck somewhere and only knows that little niche, even if he knows it inside out. Smart employers hire people who bring new ideas, new skills and show the ability to adapt to a new environment quickly. Smart companies train their employees and let them constantly learn new skills (and pay them decent salaries as well). Dinosaurs became extinct, because they couldn't adapt to a rapidly changing world. That's why you call some people 'dinosaurs', not because they are over 55 like myself. If you work for an end user company for more than 5 years, you most likely already lost touch with what is going on in rest of the world. After 20 years with the same outfit (probably also still running the same software as 20 years ago) you become unemployable. And in today's climate, no job is save. jpb-u2ug wrote: I wouldn't say that too loudly there's a lot of potential employers on this list. Most smart companies like to have someone that is willing to stick around long enough to learn their business logic. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, April 22, 2009 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster jpb-u2ug wrote: snip Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker Not me Jerry, I usually don't stay long enough for that to happen. If there's nothing new to learn I move on. --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Question on UniVerse VOC record for CREATE.FILE
It is probably the options in attribute 4 that drive this. Anyway, to set long name support on an account type, try this from the UV account: LONGNAMES ON NEWACC,PICK You can then see what the verb should look like. You may want to take a backup copy of your original first though. HTH Brett Doug Farmer dfar...@epicor.com wrote in message news:dbd320e216b98b4d842bb357e46c0788cd7...@basalt.americas.epicor.net... I am mainly a UniData person, so UniVerse is a bit foreign to me. I am running UniVerse on a Windows Platform. Using the CREATE.FILE command, I created a file with a long name (15 characters) with my standard VOC pointer, and the VOC pointer in the UV\NEWAC,PICK file. Using the CREATE.FILE verb in my VOC, I am able to create the file correctly. Using the verb as it is on the NEWAC,PICK file, it truncates the file name. This, even though the LONGNAMES is on. See the examples at the end of the E mail. My VOC entry looks like AE VOC CREATE.FILE Top of CREATE.FILE in VOC, 6 lines, 40 characters. *--: L22 001: V 002: create.file 003: E 004: VF 005: LONGNAMES 006: PICK.FORMAT Bottom. *--: The NEWACC\PICK file verb looks like this (After I copy it to my VOC and set LONGNAMES) AE VOC PICK-CREATE-FILE Top of CREATE.FILE in VOC, 6 lines, 40 characters. *--: L22 001: V 002: create.file 003: E 004: FG 005: LONGNAMES 006: PICK.FORMAT Bottom. *--: The only difference is attribute 4 which has an FG instead of VF in it. I have no idea what FG vs VF is. You may wonder why I am asking? I have an old application that creates files specifically using the PICK version, no matter what the VOC version is. I don't know why, is there a difference? The only difference I know of is that LONGNAMES do not seem to work under the PICK version. Any ideas? Thanks in Advance Doug Using PICK-CREATE-FILE PICK-CREATE-FILE DAF1234567890123456 1,1,18 1,1,19 WARNING: An operating system file will be created with a truncated name. Creating file DAF123456000 as Type 19. Creating file D_DAF123456000 as Type 18, Modulo 1, Separation 1. Using CREATE-FILE CREATE.FILE DAF123456789012345 1,1,18 1,1,19 Creating file DAF123456789012345 as Type 19. Creating file D_DAF123456789012345 as Type 18, Modulo 1, Separation 1. Added @ID, the default record for RetrieVe, to D_DAF123456789012345. This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- 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] I-descriptor subroutine / SELECT question
Hi all, I was asked to create an I-descriptor friendly wrapper subroutine for a subroutine that has one input argument and 10 outputs. Turns out this subroutine calls another subroutine that executes a select (against a different file). Active select - LIST FILE-1 I-DESC - I-DESC calls wrapper - wrapper calls subroutine - called subroutine tries to execute select against FILE-2. Is there any way to get around the active select so the query against FILE-2 works correctly? BTW - We're running Unidata 7.1 Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (fax) *---* --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I-descriptor subroutine / SELECT question
By default, selecting uses the default of select list 0. In the 2nd/internal subroutine, have the SELECT use a different select # and then read from that select #. For example: STMT = SELECT WIGETS TO 4 EXECUTE STMT LOOP WHILE READNEXT KEY FROM 4 (your code) REPEAT John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Friday, April 24, 2009 9:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] I-descriptor subroutine / SELECT question Hi all, I was asked to create an I-descriptor friendly wrapper subroutine for a subroutine that has one input argument and 10 outputs. Turns out this subroutine calls another subroutine that executes a select (against a different file). Active select - LIST FILE-1 I-DESC - I-DESC calls wrapper - wrapper calls subroutine - called subroutine tries to execute select against FILE-2. Is there any way to get around the active select so the query against FILE-2 works correctly? BTW - We're running Unidata 7.1 Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (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/
RE: [U2] I-descriptor subroutine / SELECT question
I would add to the wrapper to SAVE all the UniData Internal Variables then call your subroutine, and then RESTORE all the Variables. Example: U.ID = @ID U.DICT = @DICT U.RECORD = @RECORD READLIST U.SEL THEN SEL.FLAG = @TRUE (Any other COMMON variables that might be modified) ... DO YOUR CALL ... IF SEL.FLAG THEN FORMLIST U.SEL @RECORD = U.RECORD @DICT = U.DICT @ID = U.ID Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Friday, April 24, 2009 6:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] I-descriptor subroutine / SELECT question Hi all, I was asked to create an I-descriptor friendly wrapper subroutine for a subroutine that has one input argument and 10 outputs. Turns out this subroutine calls another subroutine that executes a select (against a different file). Active select - LIST FILE-1 I-DESC - I-DESC calls wrapper - wrapper calls subroutine - called subroutine tries to execute select against FILE-2. Is there any way to get around the active select so the query against FILE-2 works correctly? BTW - We're running Unidata 7.1 Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (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/
Re: RE: [U2] Employment disaster
Les, I didn't say ALL developers become dinosaurs (even if Jerry seems to think so) and PHBs are ALWAYS smart. The fact that you are in this group probably makes you an exception already. There are many reasons to stick with the same outfit for a long time; Family, friends, habit to name just a few. There might even be companies which really appreciate what you are doing and are great to work for. I don't know, I haven't found one yet. Being a dinosaur has nothing to do with age, it has to do with adaptability. Crocodiles are even older than dinosaurs, and they are still around and still a very successful species. And of course a subroutine is still a subroutine even if you call it a method! That is not the point. The point is, that it is not ALWAYS the obsession of PHBs with new technology and youth that leads to MV-systems being replaced with the likes of Microsoft, SAP or Oracle. In many cases it is the dinosaurs under the IT-people who are the reason for the wish or even need to change. And believe me or not, I had to work with quite a lot of them over the years - old ones and young ones alike. But you are right in a way, in every case it has been ignorant management who let them get away with that attitude in the first place; so it is always the fault of the PHBs after all. ;-) Aren't Fridays great? Mecki Original-Nachricht Datum: Fri, 24 Apr 2009 08:44:43 +0100 Von: Les Hewkin les.hew...@travisperkins.co.uk An: u2-users@listserver.u2ug.org Betreff: RE: [U2] Employment disaster RubbishI have worked for the same couple for more then 10 years. In that time I have gone from only knowing Universe to developing systems in VB6, JAVA, dot.net. It's not the developers that become dinosaurs it's the PHB's that think anything new is better then anything that's gone before, and only some one young can understand this new world. Have you spotted that most new ideas are old ideas with lots of big words wrapped round them?? End of rant...boy am I glad it's Friday Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 23 April 2009 17:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Employment disaster That may be right, but smart companies don't hire someone, who got stuck somewhere and only knows that little niche, even if he knows it inside out. Smart employers hire people who bring new ideas, new skills and show the ability to adapt to a new environment quickly. Smart companies train their employees and let them constantly learn new skills (and pay them decent salaries as well). Dinosaurs became extinct, because they couldn't adapt to a rapidly changing world. That's why you call some people 'dinosaurs', not because they are over 55 like myself. If you work for an end user company for more than 5 years, you most likely already lost touch with what is going on in rest of the world. After 20 years with the same outfit (probably also still running the same software as 20 years ago) you become unemployable. And in today's climate, no job is save. jpb-u2ug wrote: I wouldn't say that too loudly there's a lot of potential employers on this list. Most smart companies like to have someone that is willing to stick around long enough to learn their business logic. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, April 22, 2009 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster jpb-u2ug wrote: snip Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker Not me Jerry, I usually don't stay long enough for that to happen. If there's nothing new to learn I move on. --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS
RE: [U2] I-descriptor subroutine / SELECT question
Hi John, I tried that approach. The select attempts to use the active list for the query. *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (fax) *---* -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, April 24, 2009 8:22 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] I-descriptor subroutine / SELECT question By default, selecting uses the default of select list 0. In the 2nd/internal subroutine, have the SELECT use a different select # and then read from that select #. For example: STMT = SELECT WIGETS TO 4 EXECUTE STMT LOOP WHILE READNEXT KEY FROM 4 (your code) REPEAT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Question on UniVerse VOC record for CREATE.FILE
The LONGNAMES command will update certain VOC records (CREATE.FILE, DELETE.FILE, CNAME, CREATE.BFILE) so they will work with long file names properly. Certain fields are updated with the necessary data when that command is used that can be missed if modified manually. For the CREATE.FILE command it will add LONGNAMES to field 5 and change field 4 to either V or FV if the field previously had an F somewhere in it. It appears to me that someone manually modified the record in the NEWACC,PICK file on your system instead of using the LONGNAMES command. The proper command to update the records in the NEWACC file would be LONGNAMES ON NEWACC - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Thursday, April 23, 2009 5:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] Question on UniVerse VOC record for CREATE.FILE I am mainly a UniData person, so UniVerse is a bit foreign to me. I am running UniVerse on a Windows Platform. Using the CREATE.FILE command, I created a file with a long name (15 characters) with my standard VOC pointer, and the VOC pointer in the UV\NEWAC,PICK file. Using the CREATE.FILE verb in my VOC, I am able to create the file correctly. Using the verb as it is on the NEWAC,PICK file, it truncates the file name. This, even though the LONGNAMES is on. See the examples at the end of the E mail. My VOC entry looks like AE VOC CREATE.FILE Top of CREATE.FILE in VOC, 6 lines, 40 characters. *--: L22 001: V 002: create.file 003: E 004: VF 005: LONGNAMES 006: PICK.FORMAT Bottom. *--: The NEWACC\PICK file verb looks like this (After I copy it to my VOC and set LONGNAMES) AE VOC PICK-CREATE-FILE Top of CREATE.FILE in VOC, 6 lines, 40 characters. *--: L22 001: V 002: create.file 003: E 004: FG 005: LONGNAMES 006: PICK.FORMAT Bottom. *--: The only difference is attribute 4 which has an FG instead of VF in it. I have no idea what FG vs VF is. You may wonder why I am asking? I have an old application that creates files specifically using the PICK version, no matter what the VOC version is. I don't know why, is there a difference? The only difference I know of is that LONGNAMES do not seem to work under the PICK version. Any ideas? Thanks in Advance Doug Using PICK-CREATE-FILE PICK-CREATE-FILE DAF1234567890123456 1,1,18 1,1,19 WARNING: An operating system file will be created with a truncated name. Creating file DAF123456000 as Type 19. Creating file D_DAF123456000 as Type 18, Modulo 1, Separation 1. Using CREATE-FILE CREATE.FILE DAF123456789012345 1,1,18 1,1,19 Creating file DAF123456789012345 as Type 19. Creating file D_DAF123456789012345 as Type 18, Modulo 1, Separation 1. Added @ID, the default record for RetrieVe, to D_DAF123456789012345. This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- 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] I-descriptor subroutine / SELECT question
John wrote: Hi all, I was asked to create an I-descriptor friendly wrapper subroutine for a subroutine that has one input argument and 10 outputs. Turns out this subroutine calls another subroutine that executes a select (against a different file). Active select - LIST FILE-1 I-DESC - I-DESC calls wrapper - wrapper calls subroutine - called subroutine tries to execute select against FILE-2. Is there any way to get around the active select so the query against FILE-2 works correctly? John - the solution provided by David will work. However, I've got to say that I cringe whenver someone proposes using an I-decriptor that, in turn, is performing it's own SELECT under the hood. This is really poor from both a design and performance point of view - there's got to be a more methodical means to get the data you need. For example, if your I-desc XYZ.MONEY is in the PERSON file and in turn performs a SELECT against the MONEY file and each has 1000 records, this: SELECT PERSON WITH XYZ.MONEY 1000.00 is going to execute 1,000,000 SELECTs to obtain it's results. I do a lot with stored computed columns (ahem: I-desc), many of which are calculated in realtime using triggers. Combined with indexing these stored values, queries take less than a second. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, you're talking in grown-up and need to stop. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe Fonts
Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I-descriptor subroutine / SELECT question
Hi David, That did the trick. MANY THANKS. *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (fax) *---* -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Friday, April 24, 2009 8:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I-descriptor subroutine / SELECT question I would add to the wrapper to SAVE all the UniData Internal Variables then call your subroutine, and then RESTORE all the Variables. Example: U.ID = @ID U.DICT = @DICT U.RECORD = @RECORD READLIST U.SEL THEN SEL.FLAG = @TRUE (Any other COMMON variables that might be modified) ... DO YOUR CALL ... IF SEL.FLAG THEN FORMLIST U.SEL @RECORD = U.RECORD @DICT = U.DICT @ID = U.ID Thanks, David A. Green www.dagconsulting.com (480) 813-1725 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I-descriptor subroutine / SELECT question
After all my advice, I do agree with Jeff that doing selects within I-desc creates a LOT of overhead and in general, is not a good idea. If you can get around this and put it all in one piece of code, you will get better results. I was assuming you had a reason for doing it the way you described. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, April 24, 2009 10:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I-descriptor subroutine / SELECT question John wrote: Hi all, I was asked to create an I-descriptor friendly wrapper subroutine for a subroutine that has one input argument and 10 outputs. Turns out this subroutine calls another subroutine that executes a select (against a different file). Active select - LIST FILE-1 I-DESC - I-DESC calls wrapper - wrapper calls subroutine - called subroutine tries to execute select against FILE-2. Is there any way to get around the active select so the query against FILE-2 works correctly? John - the solution provided by David will work. However, I've got to say that I cringe whenver someone proposes using an I-decriptor that, in turn, is performing it's own SELECT under the hood. This is really poor from both a design and performance point of view - there's got to be a more methodical means to get the data you need. For example, if your I-desc XYZ.MONEY is in the PERSON file and in turn performs a SELECT against the MONEY file and each has 1000 records, this: SELECT PERSON WITH XYZ.MONEY 1000.00 is going to execute 1,000,000 SELECTs to obtain it's results. I do a lot with stored computed columns (ahem: I-desc), many of which are calculated in realtime using triggers. Combined with indexing these stored values, queries take less than a second. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, you're talking in grown-up and need to stop. Catherine Butera --- 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] I-descriptor subroutine / SELECT question
Jon, Are you running in the native UniData/UniVerse flavor or the PICK flavor? I don't think the PICK flavor supports multiple active selects. A possible way to get this to work in PICK mode is to use a lower case select to force the syntax to the native UniData/UniVerse flavor. However, after executing the internal select and returning control to the 2nd program, it might not understand the concept of multiple active selects. I have never actually tried this in PICK flavor. Just to be sure I understand, you have an active select from one program, and one way or another, a 2nd subroutine is being called for each key and this 2nd subroutine is doing a 2nd select. Is this correct? Alternatively, if all else fails, you could simply build an array of the keys in the first program, then loop/remove the keys (instead of using an active select). This is not the preferred way, esp. if the 1st select returns a huge number of keys, but sometimes you have to do what you have to do. If this still does not work, give me a call and I will see if I can talk you through a solution. Good luck. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Friday, April 24, 2009 9:58 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I-descriptor subroutine / SELECT question Hi John, I tried that approach. The select attempts to use the active list for the query. *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (fax) *---* -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, April 24, 2009 8:22 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] I-descriptor subroutine / SELECT question By default, selecting uses the default of select list 0. In the 2nd/internal subroutine, have the SELECT use a different select # and then read from that select #. For example: STMT = SELECT WIGETS TO 4 EXECUTE STMT LOOP WHILE READNEXT KEY FROM 4 (your code) REPEAT --- 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] Universe Fonts
we use ,FONTNAME Monotype.com for the Monotype.com font. On Fri, Apr 24, 2009 at 10:08 AM, Baruch Salamander bar...@ats.org wrote: Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Geeky sorcery at My website http://normanbauer.info Facebook http://www.facebook.com/profile.php?id=561250983 Twitter http://twitter.com/simulacra10 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I-descriptor subroutine / SELECT question
Hi Jeff, This is one of those the trustee's are coming, the trustee's are coming situations. In other words they needed this before yesterday. We went through the Benefactor to Colleague Advancement conversion in early February. This is the sort of request I was not looking forward to. Fortunately, at least for the moment, this will only be used in a LIST statement. Hopefully this will handle the immediate problem. Do you have an example or two of using triggers? This sounds very useful. Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (fax) *---* -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, April 24, 2009 9:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I-descriptor subroutine / SELECT question John wrote: Hi all, I was asked to create an I-descriptor friendly wrapper subroutine for a subroutine that has one input argument and 10 outputs. Turns out this subroutine calls another subroutine that executes a select (against a different file). Active select - LIST FILE-1 I-DESC - I-DESC calls wrapper - wrapper calls subroutine - called subroutine tries to execute select against FILE-2. Is there any way to get around the active select so the query against FILE-2 works correctly? John - the solution provided by David will work. However, I've got to say that I cringe whenver someone proposes using an I-decriptor that, in turn, is performing it's own SELECT under the hood. This is really poor from both a design and performance point of view - there's got to be a more methodical means to get the data you need. For example, if your I-desc XYZ.MONEY is in the PERSON file and in turn performs a SELECT against the MONEY file and each has 1000 records, this: SELECT PERSON WITH XYZ.MONEY 1000.00 is going to execute 1,000,000 SELECTs to obtain it's results. I do a lot with stored computed columns (ahem: I-desc), many of which are calculated in realtime using triggers. Combined with indexing these stored values, queries take less than a second. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, you're talking in grown-up and need to stop. Catherine Butera --- 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] Universe Fonts
Where are we? Are we talking about a terminal emulator? --B -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baruch Salamander Sent: Friday, April 24, 2009 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Fonts Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- 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] Universe Fonts
thanks...please specify how the entire command looks like Baruch u2-users@listserver.u2ug.org on Friday, April 24, 2009 at 10:29 AM -0500 wrote: we use ,FONTNAME Monotype.com for the Monotype.com font. On Fri, Apr 24, 2009 at 10:08 AM, Baruch Salamander bar...@ats.org wrote: Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Geeky sorcery at My website http://normanbauer.info Facebook http://www.facebook.com/profile.php?id=561250983 Twitter http://twitter.com/simulacra10 --- 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] Universe Fonts
Universe 10.1 printing on HP laser. I'm not concerned about how it looks on the screen, rather how it shows on a report. Baruch u2-users@listserver.u2ug.org on Friday, April 24, 2009 at 10:33 AM -0500 wrote: Where are we? Are we talking about a terminal emulator? --B -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baruch Salamander Sent: Friday, April 24, 2009 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Fonts Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- 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] Universe Fonts
I don't think UV has a default font. The font is from the application you use to access the UV server (ie. TELNET). I use the telnet .exe that came with windows, and it has the ability to use a few different fonts. The only thing (although not required) would be that the font not be proportional, that is each letter uses the same width of space, otherwise you will have a difficult time having columns line up properly. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Baruch Salamander Sent: Friday, April 24, 2009 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Fonts Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- 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] Universe Fonts
The entire command which is specified in PRITNERS: CSLASER 002 175 003 60 004 2 005 2 006 1 007 NFMT,BRIEF,NHEAD,AT CSLASER,GDI,FONTNAME Monotype.com,FONTSIZE 8 On Fri, Apr 24, 2009 at 10:49 AM, Baruch Salamander bar...@ats.org wrote: Universe 10.1 printing on HP laser. I'm not concerned about how it looks on the screen, rather how it shows on a report. Baruch u2-users@listserver.u2ug.org on Friday, April 24, 2009 at 10:33 AM -0500 wrote: Where are we? Are we talking about a terminal emulator? --B -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baruch Salamander Sent: Friday, April 24, 2009 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Fonts Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- 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/ -- Geeky sorcery at My website http://normanbauer.info Facebook http://www.facebook.com/profile.php?id=561250983 Twitter http://twitter.com/simulacra10 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Fonts
Thanks u2-users@listserver.u2ug.org on Friday, April 24, 2009 at 11:12 AM -0500 wrote: The entire command which is specified in PRITNERS: CSLASER 002 175 003 60 004 2 005 2 006 1 007 NFMT,BRIEF,NHEAD,AT CSLASER,GDI,FONTNAME Monotype.com,FONTSIZE 8 On Fri, Apr 24, 2009 at 10:49 AM, Baruch Salamander bar...@ats.org wrote: Universe 10.1 printing on HP laser. I'm not concerned about how it looks on the screen, rather how it shows on a report. Baruch u2-users@listserver.u2ug.org on Friday, April 24, 2009 at 10:33 AM -0500 wrote: Where are we? Are we talking about a terminal emulator? --B -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baruch Salamander Sent: Friday, April 24, 2009 10:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Fonts Greetings, Is the generic font in Universe a Courier? If not, what's the command for a Courier font? If someone can provide the commands for other types of fonts, it would be a plus. Baruch --- 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/ -- Geeky sorcery at My website http://normanbauer.info Facebook http://www.facebook.com/profile.php?id=561250983 Twitter http://twitter.com/simulacra10 --- 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] I-descriptor subroutine / SELECT question
Jeff Butera wrote: However, I've got to say that I cringe whenver someone proposes using an I-decriptor that, in turn, is performing it's own SELECT under the hood. This is really poor from both a design and performance point of view - there's got to be a more methodical means to get the data you need. Yes, it looks like a likely reason to create an index and use selectindex inside that nested subroutine. That said, there is a place for QuickDirty when the trustees are coming, the trustees are coming. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.22; Dynamic File question
2. Use resize if you can get exclusive use of the file. (I don't think CONCURRENT works with dynamic files. but I'm wary with static too.) RESIZE will allow you to set the minimum modulus, but maybe not using the syntax as documented. And syntax differs according to acct flavour and OS (and UV rel?) If RESIZE does nOt recognize MINIMUM.MODULUS on the command line, then specify the mod explicitly, like you would a static hashed file. That will become the minimum.modulus and the file will be sized accordingly. RESIZE YOURFILE 30 1 4 [SEQ.NUM] (syntax different in Pick flavour) will resize the file, type 30, setting MINIMUM.MODULUS TO 1 and reserve the disk space in DATA.30, setting the current modulus to 1 too. (Of course, if the file is already larger than that, the current modulus will be larger than 1.) Hi Chuck, In case you hadn't noticed, the manual is explicit about it - RESIZE does not recognise MIMIMUM.MODULUS if the file is already dynamic. Of course, that doesn't mean the manual is correct :-) Cheers, Wol I do pretty much ignore the manual on the subject. I'm not a postmodern, but in this case I think truth is relative, varying from flavour to flavour , OS to OS, release to release, manual to manual. The absolute truth is that you can use RESIZE to set the minimum modulus parameter itself, no matter what it says about the syntax or the corresponding parameter. Wol, I think it would be reading too much into one of your posts to infer that you use (trust) CONCURRENT, but hope springs eternal. Do you trust CONCURRENT INPLACE? I *think* the manual also says you can't do CONCURRENT when resizing a file that starts out dynamic. IBM has been promising a trustworthy CONCURRENT to move toward competitive uptime capability. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need assistance replicating UniObjects.NET issue
Whenever we have run into this kind of error (RPC error 81009) using UniObjects.NET we have pretty much always been able to trace it back to a single UDT/UV process that is taking excessively long, or requiring excessive disk/memory IO in order to complete.. The common one we initially ran into was a particular select on a file was not returning in a timely fashion, and only once a proper index was put in place this problem was then mitigated, until later an additional method that tried to read batches of records (which can be quite large individually) from the same file started to timeout and generate excessive amounts of this error. Through trial and error we found that our particular process needed parameters to allow each client installation to fine tune the size of batches and frequency with which the offending file was scanned and processed... It's probably not going to give you much, but I would recommend running Filemon (from sysinternals) to watch the file/disk IO on the UDT server while your .NET code executes to try and identify any IO bottlenecks... It may just give you a direction with which to dig into... Ray -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Batson Sent: 22 April 2009 02:17 To: u2-users@listserver.u2ug.org Subject: [U2] Need assistance replicating UniObjects.NET issue Does anyone have any insight into how to create the following error. Error Message: IBMU2.UODOTNET.UniXMLException: Unable to read data from th transport connection: An existing connection was forcibly closed by the re host.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. UNIDATA 7.1.0 Windows 2003 I've tried killing the udapislave.exe process associated with the connection and then accessing the connection. I get a similar error but not this one. I've tried to sleep to long but noticed I we don't set the timeout property on the UniObject and the default is no timeout. So it just sits there waiting. I haven't tried unplugging the network cable yet or mimicking some network interruption. Any ideas would be greatly appreciated. Thanks, Glenn --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.22; Dynamic File question
... and at this point I'd be thinking static file. Distributed, if necessary. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, April 24, 2009 12:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV 10.1.22; Dynamic File question Allen Egerton wrote: The situation is that I'm potentially adding a million records to a dynamic file. That's not hypothetical, it's a real life scenario. And I don't want to wait while the file splits multiple times over the course of the add. I don't have that large a window. I want to force the file to expand the weekend before so that when I add the records the file isn't rebuilding. The file's already dynamic, so setting Minimum.Modulus doesn't seem to do me much good unless I can figure out how to force it to split to that minium.modulos. And there's the crux of my question. How can I force it to split? Allen, Only doing CONFIGURE.FILE . . . MINIMUM.MODULUS does not make the file grow. It just tells UV that if when the file ever grows that big, don't let it shrink smaller. You need to be sneakier. Here are 2 ways reserving space on DATA.30, one for OVER.30. 1. Do it this way if you can't have any downtime, but can sneak writing one bogus little record. Tinker with MERGE.LOAD SPLIT.LOAD then repeatedly write a fake record, so that each write triggers a split until you get to the size you want. Let's say you want min mod of 10,000 and your current mod is 1,000 CONFIGURE.FILE YOURFILE MINIMUM.MODULUS 1 MERGE.LOAD 1 SPLIT.LOAD 2 run this: open YOURFILE to F else stop for i = 1000 to 1 ;* you need 9000 =10,000-1,000 splits write '' F, 'dummy' delete F, 'dummy' next i Now set MERGE.LOAD SPLIT.LOAD TO where you want them (usually 50 80). Until you load your real data you may be well below MERGE percentage, but merges will not happen because of minimum.modulus parameter.. 2. Use resize if you can get exclusive use of the file. (I don't think CONCURRENT works with dynamic files. but I'm wary with static too.) RESIZE will allow you to set the minimum modulus, but maybe not using the syntax as documented. And syntax differs according to acct flavour and OS (and UV rel?) If RESIZE does nOt recognize MINIMUM.MODULUS on the command line, then specify the mod explicitly, like you would a static hashed file. That will become the minimum.modulus and the file will be sized accordingly. RESIZE YOURFILE 30 1 4 [SEQ.NUM] (syntax different in Pick flavour) will resize the file, type 30, setting MINIMUM.MODULUS TO 1 and reserve the disk space in DATA.30, setting the current modulus to 1 too. (Of course, if the file is already larger than that, the current modulus will be larger than 1.) 3. Neither of the above will reserve room in OVER.30. If you know what your data will be like, then you know how much overload you'll need. If you have the luxury of being able to create bogus data, you could write many large records so that OVER.30 grows. Then delete all the bogus large records. Other han that, I don't know a way to make OVER.30 grow. --- 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] How do you do a NOPAGE on a SELECT?
ok...(UV 10 ) I'm doing the following: SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued SAVING) SELECT FILE2 SAVE-LIST XX Problem is when there are VARB1 items in FILE1 that are not valid ID's in FILE2 the SELECT FILE2 displays all the ID's that are not valid ID's. If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. What would be nice would be if there was a NOPAGE, or a HUSH option to SELECT. My workaround is: SELECT FILE1 SAVING VARIB1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 SAVE-LIST XX George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: RE: [U2] Employment disaster
The PHB's base their decisions upon the information given them - if there dinosaur MV programmers (whatever age) go xml tut tut not easy or web interface are you insane - then they look elsewhere ! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: 24 April 2009 14:35 To: u2-users@listserver.u2ug.org Subject: Re: RE: [U2] Employment disaster Les, I didn't say ALL developers become dinosaurs (even if Jerry seems to think so) and PHBs are ALWAYS smart. The fact that you are in this group probably makes you an exception already. There are many reasons to stick with the same outfit for a long time; Family, friends, habit to name just a few. There might even be companies which really appreciate what you are doing and are great to work for. I don't know, I haven't found one yet. Being a dinosaur has nothing to do with age, it has to do with adaptability. Crocodiles are even older than dinosaurs, and they are still around and still a very successful species. And of course a subroutine is still a subroutine even if you call it a method! That is not the point. The point is, that it is not ALWAYS the obsession of PHBs with new technology and youth that leads to MV-systems being replaced with the likes of Microsoft, SAP or Oracle. In many cases it is the dinosaurs under the IT-people who are the reason for the wish or even need to change. And believe me or not, I had to work with quite a lot of them over the years - old ones and young ones alike. But you are right in a way, in every case it has been ignorant management who let them get away with that attitude in the first place; so it is always the fault of the PHBs after all. ;-) Aren't Fridays great? Mecki Original-Nachricht Datum: Fri, 24 Apr 2009 08:44:43 +0100 Von: Les Hewkin les.hew...@travisperkins.co.uk An: u2-users@listserver.u2ug.org Betreff: RE: [U2] Employment disaster RubbishI have worked for the same couple for more then 10 years. In that time I have gone from only knowing Universe to developing systems in VB6, JAVA, dot.net. It's not the developers that become dinosaurs it's the PHB's that think anything new is better then anything that's gone before, and only some one young can understand this new world. Have you spotted that most new ideas are old ideas with lots of big words wrapped round them?? End of rant...boy am I glad it's Friday Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 23 April 2009 17:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Employment disaster That may be right, but smart companies don't hire someone, who got stuck somewhere and only knows that little niche, even if he knows it inside out. Smart employers hire people who bring new ideas, new skills and show the ability to adapt to a new environment quickly. Smart companies train their employees and let them constantly learn new skills (and pay them decent salaries as well). Dinosaurs became extinct, because they couldn't adapt to a rapidly changing world. That's why you call some people 'dinosaurs', not because they are over 55 like myself. If you work for an end user company for more than 5 years, you most likely already lost touch with what is going on in rest of the world. After 20 years with the same outfit (probably also still running the same software as 20 years ago) you become unemployable. And in today's climate, no job is save. jpb-u2ug wrote: I wouldn't say that too loudly there's a lot of potential employers on this list. Most smart companies like to have someone that is willing to stick around long enough to learn their business logic. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, April 22, 2009 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster jpb-u2ug wrote: snip Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker Not me Jerry, I usually don't stay long enough for that to happen. If there's nothing new to learn I move on. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
RE: [U2] How do you do a NOPAGE on a SELECT?
George, If I understand correctly you are trying to end up with a list of the VARB1's from FILE1 that are valid record keys in FILE2, correct? If I'm right so far, what I'd do is create an I-descriptor in FILE1 that does a TRANS to FILE2, like this: CHECK.FILE2 0001: I 0002: TRANS(FILE2, VARB1, 0, X) ... TRANS works for multivalued fields, by the way. So then your SELECT could be: SELECT FILE1 WITH CHECK.FILE2 # SAVING VARB1 SAVE-LIST XX HTH, Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 12:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] How do you do a NOPAGE on a SELECT? ok...(UV 10 ) I'm doing the following: SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued SAVING) SELECT FILE2 SAVE-LIST XX Problem is when there are VARB1 items in FILE1 that are not valid ID's in FILE2 the SELECT FILE2 displays all the ID's that are not valid ID's. If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. What would be nice would be if there was a NOPAGE, or a HUSH option to SELECT. My workaround is: SELECT FILE1 SAVING VARIB1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 SAVE-LIST XX George --- 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 10.1.22; Dynamic File question
Dan Fitzgerald wrote: ... and at this point I'd be thinking static file. Distributed, if necessary. snip Ayup. But I'll quote myself from an earlier post: I've got some slightly unusual circumstances and client induced constraints that I'm working under. -- Allen Egerton aegerton at pobox dot com PGP Key ID 0x8EA57261 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do you do a NOPAGE on a SELECT?
I know in UD that I can use: UDT.OPTIONS 55 ON Not sure about UV. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] How do you do a NOPAGE on a SELECT? ok...(UV 10 ) I'm doing the following: SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued SAVING) SELECT FILE2 SAVE-LIST XX Problem is when there are VARB1 items in FILE1 that are not valid ID's in FILE2 the SELECT FILE2 displays all the ID's that are not valid ID's. If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. What would be nice would be if there was a NOPAGE, or a HUSH option to SELECT. My workaround is: SELECT FILE1 SAVING VARIB1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 SAVE-LIST XX George --- 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] How do you do a NOPAGE on a SELECT?
hmmm. that would work. I was hoping to not use a dict item, as it could be 1 of many source files. Thanks George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald Sent: Friday, April 24, 2009 2:58 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you do a NOPAGE on a SELECT? George, If I understand correctly you are trying to end up with a list of the VARB1's from FILE1 that are valid record keys in FILE2, correct? If I'm right so far, what I'd do is create an I-descriptor in FILE1 that does a TRANS to FILE2, like this: CHECK.FILE2 0001: I 0002: TRANS(FILE2, VARB1, 0, X) ... TRANS works for multivalued fields, by the way. So then your SELECT could be: SELECT FILE1 WITH CHECK.FILE2 # SAVING VARB1 SAVE-LIST XX HTH, Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 12:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] How do you do a NOPAGE on a SELECT? ok...(UV 10 ) I'm doing the following: SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued SAVING) SELECT FILE2 SAVE-LIST XX Problem is when there are VARB1 items in FILE1 that are not valid ID's in FILE2 the SELECT FILE2 displays all the ID's that are not valid ID's. If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. What would be nice would be if there was a NOPAGE, or a HUSH option to SELECT. My workaround is: SELECT FILE1 SAVING VARIB1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 SAVE-LIST XX George --- 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] How do you do a NOPAGE on a SELECT?
yes, HUSH works. I was hoping that SELECT had it built in. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Friday, April 24, 2009 3:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you do a NOPAGE on a SELECT? Couldn't you just use HUSH before doing the select to suppress the output? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] How do you do a NOPAGE on a SELECT? ok...(UV 10 ) I'm doing the following: SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued SAVING) SELECT FILE2 SAVE-LIST XX Problem is when there are VARB1 items in FILE1 that are not valid ID's in FILE2 the SELECT FILE2 displays all the ID's that are not valid ID's. If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. What would be nice would be if there was a NOPAGE, or a HUSH option to SELECT. My workaround is: SELECT FILE1 SAVING VARIB1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 SAVE-LIST XX George --- 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] How do you do a NOPAGE on a SELECT?
If no other suggestions work, how about putting a DATA N in there somewhere? I've used that to great effect in the past. Brad owner-u2-us...@listserver.u2ug.org wrote on 04/24/2009 01:21:55 PM: If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do you do a NOPAGE on a SELECT?
Or ...CAPTURING MESS... Danny Ruckel, Senior Programmer Southwest Traders 27711 Diaz Road Temecula, CA 92590 Ph: 951.676.8377 Fax: 615.676.8370 dan...@southwesttraders.com http://www.southwesttraders.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Friday, April 24, 2009 12:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you do a NOPAGE on a SELECT? Couldn't you just use HUSH before doing the select to suppress the output? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] How do you do a NOPAGE on a SELECT? ok...(UV 10 ) I'm doing the following: SELECT FILE1 SAVING VARB1 (PICK format SELECT - to allow multivalued SAVING) SELECT FILE2 SAVE-LIST XX Problem is when there are VARB1 items in FILE1 that are not valid ID's in FILE2 the SELECT FILE2 displays all the ID's that are not valid ID's. If I'm typing the commands, no problem...just hit 'n', however, if I put them in a VOC, and execute the VOC from a program, the operator has to hit 'n'. What would be nice would be if there was a NOPAGE, or a HUSH option to SELECT. My workaround is: SELECT FILE1 SAVING VARIB1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 SAVE-LIST XX George --- 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/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of Daniel Ruckel (dani...@southwesttraders.com).vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Question on UniVerse VOC record for CREATE.FILE
Thanks, it was the V option Doug -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Friday, April 24, 2009 9:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Question on UniVerse VOC record for CREATE.FILE The LONGNAMES command will update certain VOC records (CREATE.FILE, DELETE.FILE, CNAME, CREATE.BFILE) so they will work with long file names properly. Certain fields are updated with the necessary data when that command is used that can be missed if modified manually. For the CREATE.FILE command it will add LONGNAMES to field 5 and change field 4 to either V or FV if the field previously had an F somewhere in it. It appears to me that someone manually modified the record in the NEWACC,PICK file on your system instead of using the LONGNAMES command. The proper command to update the records in the NEWACC file would be LONGNAMES ON NEWACC - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Thursday, April 23, 2009 5:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] Question on UniVerse VOC record for CREATE.FILE I am mainly a UniData person, so UniVerse is a bit foreign to me. I am running UniVerse on a Windows Platform. Using the CREATE.FILE command, I created a file with a long name (15 characters) with my standard VOC pointer, and the VOC pointer in the UV\NEWAC,PICK file. Using the CREATE.FILE verb in my VOC, I am able to create the file correctly. Using the verb as it is on the NEWAC,PICK file, it truncates the file name. This, even though the LONGNAMES is on. See the examples at the end of the E mail. My VOC entry looks like AE VOC CREATE.FILE Top of CREATE.FILE in VOC, 6 lines, 40 characters. *--: L22 001: V 002: create.file 003: E 004: VF 005: LONGNAMES 006: PICK.FORMAT Bottom. *--: The NEWACC\PICK file verb looks like this (After I copy it to my VOC and set LONGNAMES) AE VOC PICK-CREATE-FILE Top of CREATE.FILE in VOC, 6 lines, 40 characters. *--: L22 001: V 002: create.file 003: E 004: FG 005: LONGNAMES 006: PICK.FORMAT Bottom. *--: The only difference is attribute 4 which has an FG instead of VF in it. I have no idea what FG vs VF is. You may wonder why I am asking? I have an old application that creates files specifically using the PICK version, no matter what the VOC version is. I don't know why, is there a difference? The only difference I know of is that LONGNAMES do not seem to work under the PICK version. Any ideas? Thanks in Advance Doug Using PICK-CREATE-FILE PICK-CREATE-FILE DAF1234567890123456 1,1,18 1,1,19 WARNING: An operating system file will be created with a truncated name. Creating file DAF123456000 as Type 19. Creating file D_DAF123456000 as Type 18, Modulo 1, Separation 1. Using CREATE-FILE CREATE.FILE DAF123456789012345 1,1,18 1,1,19 Creating file DAF123456789012345 as Type 19. Creating file D_DAF123456789012345 as Type 18, Modulo 1, Separation 1. Added @ID, the default record for RetrieVe, to D_DAF123456789012345. This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- 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/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please
[U2] MV based Financials ready for Intl business
Hey, I'm looking for names of some multi-value based Financials. They must be ready for International business. Hopefully something that would interface nicely to a highly customized order fulfillment system. What should it contain? GL, AP, AR, be able to do it all in multiple currencies and use bank accounts in various countries, based in other currencies. We are in the distribution business and most facets of our custom package are up to the task of international business. Our financial package is lagging and is difficult to maintain so we're maybe reaching the tipping point where's its better for business to convert to something more up to date. You can respond off list if you like. baker.hug...@mouser.com Thanks in advance, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do you do a NOPAGE on a SELECT?
Instead of creating new dict items, you could use EVAL and do it on-the-fly: SELECT FILE1 WITH EVAL \TRANS(FILE2,@ID,0,X)\ # -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 1:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you do a NOPAGE on a SELECT? hmmm. that would work. I was hoping to not use a dict item, as it could be 1 of many source files. Thanks George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
