Re: [U2] Multi-threaded phantom processing
Thanks David. As they say "Bigger than Ben-Hur"! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, 5 March 2014 13:01 To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent <-> child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
Thanks Gregor I will look into the SQL interface and see what I can glean. I did look at the submit request stuff and had a working proof of concept between my workstation and our dev AIX host but the destination UV system is an earlier release and didn't support a lot of that stuff. So we had to find a middle of the road solution and sockets was it. For the moment at least until they upgrade. :) Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Wednesday, 5 March 2014 11:29 To: U2 Users List Subject: Re: [U2] Multi-threaded phantom processing There are options you can explore using the BASIC SQL Client Interface. These will allow basic programs running as phantoms to establish their own connection to the remote site and run subroutines supplied with data as parameters. This would bypass the need for multiple server phantoms listening and reacting to socket connections. You could also look at hosting web services on the AIX server and use the submitrequest() functions. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent <-> child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
There are options you can explore using the BASIC SQL Client Interface. These will allow basic programs running as phantoms to establish their own connection to the remote site and run subroutines supplied with data as parameters. This would bypass the need for multiple server phantoms listening and reacting to socket connections. You could also look at hosting web services on the AIX server and use the submitrequest() functions. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Multi-threaded phantom processing
Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent <-> child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
I Use MERGE.LIST a lot. Say for instance you want to know how many emails from an excel file are In a customer file. If you sort the excel file by email, then click on the excel column header, right click and copy Then go to UV, EDIT-LIST EM1, I Then paste the clipboard and File that SELECT CUSTOMERFILE SAVING UNIQUE EMAIL SAVE-LIST EM2 GET-LIST EM1 TO 1 GET-LIST EM2 TO 2 MERGE.LIST 1 DIFF 2 SAVE-LIST EMAILS-NOT-IN-CUSTOMER-FILE GET-LIST EM1 TO 1 GET-LIST EM2 TO 2 MERGE.LIST 2 DIFF 1 SAVE-LIST EMAILS-NOT-IN-EXCEL-FILE And so on -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, March 04, 2014 4:24 PM To: U2 Users List Subject: Re: [U2] Left Outer Join Question Randy, It sounds like NSELECT is what you need. But MERGE.LIST is a handy thing to get working. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Randy, It sounds like NSELECT is what you need. But MERGE.LIST is a handy thing to get working. I use it all the time, especially when researching bugs or bad data. What happens if you do other commands manipulating active select list 1? SELECT OLDMAS TO 1 SAVE.LIST X FROM 1 ? or LIST OLDMAS FROM 1 ? You say you're in Pick-flavor. Look for "1", "2", "3" in the VOC. There may be A-items defined there. They may conflict with parsing the command. "0" thru "11" actually. If there are, they should be moved to DICT.DICT which, unlike true Pick, is UV's "master" dictionary of dictionaries. While you're at it, for any and all of the words used in the command line compare your VOC to what is in NEWACC (the file they build VOCs for new accounts). Particularly "TO" & "FROM". I have seen some commands fail, but others work fine when those are not exactly as NEWACC says they should be. Chuck On 3/4/2014 3:39 PM, randyleesmith wrote: I tried the simplest way and still could not get it to work. SF-MORT>SELECT OLDMAS TO 1 5247 record(s) selected to SELECT list #1. SF-MORT>SELECT TRWMONTHEND TO 2 5229 record(s) selected to SELECT list #2. SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. SF-MORT>MERGE.LIST 1 INTERSECT 2 SELECT list 1 is not active. I even tried the lowercase select and got the same result. Our version is 10.2.7 and we are running in PICK PICK.FORMAT. We are running a number of older applications and Proc's. So it may because of the Version I'm using. : 0001: X : 0002: 10.2.7 : 0003: PICK : 0004: PICK.FORMAT : 0005: 10.2.7 - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Yes, that's what I meant. I was hoping to take out selected items in Y from X. I was trying to use it in another way to control it more. I realize now I can do that with the active select list using multiple selects as long as I use the right logic to filter out what I want vs. what I don't want. As it turns out I can use the SELECT X and NSELECT Y to get what I need by using the right combo of files. Thanks for all the help. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42792.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Which was what I was looking for. Thanks. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42791.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Ok, I see. If I just keep doing a Select I can keep trimming down the active select list as long as the keys are the same. (And I use the right logic. What I want to keep vs what I don't want.) Sorry, I got caught up in lists and the like. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42790.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Also keep in mind that MERGE.LIST (if you can get it to work) will also Remove Duplicate Keys George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, March 04, 2014 2:22 PM To: U2 Users List Subject: Re: [U2] Left Outer Join Question NSELECT gets the items in the list, created by "SELECT X", that do not exist in Y. Consequently, you can do things like: SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY xxx records selected to list 0 NSELECT INVOICES ...where INVOICEKEY is the field that produces the record keys into the INVOICES file. Duplicate keys are a different story. If you want the list to be duplicate free then you need to use the "SAVING UNIQUE" (that's UniData but I think it's also UniVerse) keyword at the end of the SELECT statement. e.g. SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY xxx records selected to list 0 SELECT INVOICES SAVING UNIQUE @ID HTH, Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 3/4/2014 11:07 AM *Subject:* Re: [U2] Left Outer Join Question > If I do; > > SELECT X > NSELECT Y > > Won't that take all my duplicate keys out from Y when I only want selected > ones taken out from Y? > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
NSELECT gets the items in the list, created by "SELECT X", that do not exist in Y. Consequently, you can do things like: SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY xxx records selected to list 0 NSELECT INVOICES ...where INVOICEKEY is the field that produces the record keys into the INVOICES file. Duplicate keys are a different story. If you want the list to be duplicate free then you need to use the "SAVING UNIQUE" (that's UniData but I think it's also UniVerse) keyword at the end of the SELECT statement. e.g. SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY xxx records selected to list 0 SELECT INVOICES SAVING UNIQUE @ID HTH, Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 3/4/2014 11:07 AM *Subject:* Re: [U2] Left Outer Join Question If I do; SELECT X NSELECT Y Won't that take all my duplicate keys out from Y when I only want selected ones taken out from Y? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
NO SELECT X NSELECT Y Will return all items in X that are NOT in Y Otherwise it will Exclude Y from X's List That is what your looking for? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, March 04, 2014 2:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Left Outer Join Question If I do; SELECT X NSELECT Y Won't that take all my duplicate keys out from Y when I only want selected ones taken out from Y? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42784.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Explain this concern better, I don't understand it. -Original Message- From: randyleesmith [via U2 (UniVerse & UniData)] To: Will Johnson Sent: Tue, Mar 4, 2014 11:07 am Subject: Re: Left Outer Join Question If I do; SELECT X NSELECT Y Won't that take all my duplicate keys out from Y when I only want selected ones taken out from Y? I used to be an Optimist until I knocked over the glass. If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42784.html To start a new topic under U2 - Users, email ml-node+s1073795n3...@n5.nabble.com To unsubscribe from U2 (UniVerse & UniData), click here. NAML -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42786.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Randy: NSELECT is a "not" select. It doesn't use, as far as I know, any filters with it. Use the filters with the SELECT then use the NSELECT (then use more SELECTs with filters if you want). Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 3/4/2014 10:43 AM *Subject:* Re: [U2] Left Outer Join Question Using NSELECT works as long as I don't do a complicated statement with it. NSELECT OLDMAS WITH CO = "SF" AND WITH TRWSTATUS AND WITH ACTIONCODE NE "99" ... Unknown word "WITH" on command line. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
If I do; SELECT X NSELECT Y Won't that take all my duplicate keys out from Y when I only want selected ones taken out from Y? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42784.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
The program does use the heading from DICT as a default column heading. I included 65 lines of explanations and examples in the program but left out some of the information for this post in the interest of brevity. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Reporting-Tools-tp42725p42783.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
How option an (Option to include or not include column headings ? -Original Message- From: Riverman [via U2 (UniVerse & UniData)] To: Will Johnson Sent: Tue, Mar 4, 2014 10:53 am Subject: Re: Reporting Tools I created a program (LIST.EXPORT) that works similar to the LIST command. The report has tab delimited columns and is output to the &HOLD& file. The command line command LIST.EXPORT allows conv and col.hdg column modifiers. The command requires a saved list name to know which records to select. I suspect the only limitation is the number of characters that can be entered on a command line. LIST.EXPORT reads the dictionary record for each column to determine if it is a "D" or "I" type. Value marks and sub value marks are converted to spaces. I have not yet added normalisation to the routine. If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/Reporting-Tools-tp42725p42781.html To start a new topic under U2 - Users, email ml-node+s1073795n3...@n5.nabble.com To unsubscribe from U2 (UniVerse & UniData), click here. NAML -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Reporting-Tools-tp42725p42782.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
I created a program (LIST.EXPORT) that works similar to the LIST command. The report has tab delimited columns and is output to the &HOLD& file. The command line command LIST.EXPORT allows conv and col.hdg column modifiers. The command requires a saved list name to know which records to select. I suspect the only limitation is the number of characters that can be entered on a command line. LIST.EXPORT reads the dictionary record for each column to determine if it is a "D" or "I" type. Value marks and sub value marks are converted to spaces. I have not yet added normalisation to the routine. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Reporting-Tools-tp42725p42781.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
No you can't do that. You do select this, select that, select this, nselect that. When you are all DONE, you can then do another SELECT on the result. Nselect cannot take options like that But you can do a Select AFTER you've done the Nselect -Original Message- From: randyleesmith [via U2 (UniVerse & UniData)] To: Will Johnson Sent: Tue, Mar 4, 2014 10:43 am Subject: Re: Left Outer Join Question Using NSELECT works as long as I don't do a complicated statement with it. >NSELECT OLDMAS WITH CO = "SF" AND WITH TRWSTATUS AND WITH ACTIONCODE NE "99" >... Unknown word "WITH" on command line. I used to be an Optimist until I knocked over the glass. If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42778.html To start a new topic under U2 - Users, email ml-node+s1073795n3...@n5.nabble.com To unsubscribe from U2 (UniVerse & UniData), click here. NAML -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42780.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
For all my testing I've been doing from TCL. Looks like I may need to do this in a PROC and not execute them in Unibasic code. Still this information maybe useful for the next time when I need to do it this way. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42779.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Using NSELECT works as long as I don't do a complicated statement with it. >NSELECT OLDMAS WITH CO = "SF" AND WITH TRWSTATUS AND WITH ACTIONCODE NE "99" ... Unknown word "WITH" on command line. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42778.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
You are definitely typing the lines from TCL level, and NOT from a program that's running EXECUTE/PERFORMS? Because if they are being run from a program, you have to use a multivalued command to EXECUTE, with all The lines in that command Example CMD="" CMD<-1>="GET-LIST LIST1 TO 1" CMD<-1>="GET-LIST LIST2 TO 2" CMD<-1>="MERGE.LIST 1 INTERSECT 2 TO 3" EXECUTE CMD LOOP READNEXT ID FROM 3 ELSE EXIT REPEAT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, March 04, 2014 1:34 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Left Outer Join Question It looks like the same thing. 4 lines long. : 0001: V : 0002: MERGE.LIST : 0003: I : 0004: GKSX Bottom at line 4. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42776.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
It looks like the same thing. 4 lines long. : 0001: V : 0002: MERGE.LIST : 0003: I : 0004: GKSX Bottom at line 4. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42776.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
SELECT OLDMAS 5247 records selected NSELECT TRWMONTHEND -Original Message- From: randyleesmith [via U2 (UniVerse & UniData)] To: Will Johnson Sent: Tue, Mar 4, 2014 4:39 am Subject: Re: Left Outer Join Question I tried the simplest way and still could not get it to work. SF-MORT>SELECT OLDMAS TO 1 5247 record(s) selected to SELECT list #1. SF-MORT>SELECT TRWMONTHEND TO 2 5229 record(s) selected to SELECT list #2. SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. SF-MORT>MERGE.LIST 1 INTERSECT 2 SELECT list 1 is not active. I even tried the lowercase select and got the same result. Our version is 10.2.7 and we are running in PICK PICK.FORMAT. We are running a number of older applications and Proc's. So it may because of the Version I'm using. : 0001: X : 0002: 10.2.7 : 0003: PICK : 0004: PICK.FORMAT : 0005: 10.2.7 I used to be an Optimist until I knocked over the glass. If you reply to this email, your message will be added to the discussion below: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html To start a new topic under U2 - Users, email ml-node+s1073795n3...@n5.nabble.com To unsubscribe from U2 (UniVerse & UniData), click here. NAML -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42775.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2-Users Digest, Vol 59, Issue 1
Just a quiet "second" to Jeff's comment about using ODBC and pulling the data into Excel and then using Powerpivot. PivotTables are a good way to quickly obtain meaning from large data sets. ... other than that, I know nothing. -- Message: 2 Date: Fri, 28 Feb 2014 20:31:20 + From: Jeff Lettau To: U2 Users List Subject: Re: [U2] Reporting Tools Message-ID: <7935b2cd14a94badb63ba6e7e52cb...@blupr05mb198.namprd05.prod.outlook.com> Content-Type: text/plain; charset="iso-8859-1" Without knowing exactly what you are doing, why not take a look at ODBC and linking an excel sheet to your database and use the powerpivot to create your report? If you are really doing a ETL you need a tool or a programmer. I've pulled over 300k worth of records without an issue. Although the record set was not 200 columns, but I'd bet you could get down to under 50 then do calculations in excel, then pivot the data to the report. Please note that my email address has changed. Beginning immediately my new address is jeff.let...@soundunited.com . Use this new address for all communications. Jeffrey Lettau | ERP Systems Manager | O 410.358.3600 | D 410.764.5242 | 5601 Metro Drive | Baltimore MD 21215 | www.soundunited.com Polk Audio - WWW.POLKAUDIO.COM Definitive Technologies - WWW.DEFINITIVETECH.COM BOOM Movement - WWW.BOOMMOVEMENT.COM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Just to be sure, What does your VOC for MERGE.LIST show? I'm on 10.0.2 of UV - but Information favor. >ED VOC MERGE.LIST 4 lines long. : P 0001: V 0002: MERGE.LIST 0003: I 0004: GKSX George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, March 04, 2014 7:39 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Left Outer Join Question I tried the simplest way and still could not get it to work. SF-MORT>SELECT OLDMAS TO 1 5247 record(s) selected to SELECT list #1. SF-MORT>SELECT TRWMONTHEND TO 2 5229 record(s) selected to SELECT list #2. SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. SF-MORT>MERGE.LIST 1 INTERSECT 2 SELECT list 1 is not active. I even tried the lowercase select and got the same result. Our version is 10.2.7 and we are running in PICK PICK.FORMAT. We are running a number of older applications and Proc's. So it may because of the Version I'm using. : 0001: X : 0002: 10.2.7 : 0003: PICK : 0004: PICK.FORMAT : 0005: 10.2.7 - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
I tried the simplest way and still could not get it to work. SF-MORT>SELECT OLDMAS TO 1 5247 record(s) selected to SELECT list #1. SF-MORT>SELECT TRWMONTHEND TO 2 5229 record(s) selected to SELECT list #2. SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. SF-MORT>MERGE.LIST 1 INTERSECT 2 SELECT list 1 is not active. I even tried the lowercase select and got the same result. Our version is 10.2.7 and we are running in PICK PICK.FORMAT. We are running a number of older applications and Proc's. So it may because of the Version I'm using. : 0001: X : 0002: 10.2.7 : 0003: PICK : 0004: PICK.FORMAT : 0005: 10.2.7 - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
