[U2] Using a ( at the end of a Select statement
Working with Universe Select statements I found one with (RSD at the end of it. I need to do the same select, but I want to confirm if I the (RSD is needed or not. I've been looking for any ref to this with no luck so I thought I ask you folks. Thanks for any help on this. - 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/Using-a-at-the-end-of-a-Select-statement-tp42672.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] Using a ( at the end of a Select statement
Old style Pick used these sort of options, Universe tends to shun them instead using things like DET-SUPP in place of just D Surprising sets of options there. Try to sample the file and execute the select without ANY of these options and see what you get. I suggest these are throwaways from a day when your client was not on Universe at all, but rather on some earlier thing like mvBase -Original Message- From: randyleesmith [via U2 (UniVerse UniData)] ml-node+s1073795n42672...@n5.nabble.com To: Will Johnson wjhon...@aol.com Sent: Thu, Feb 13, 2014 11:17 am Subject: Using a ( at the end of a Select statement Working with Universe Select statements I found one with (RSD at the end of it. I need to do the same select, but I want to confirm if I the (RSD is needed or not. I've been looking for any ref to this with no luck so I thought I ask you folks. Thanks for any help on this. 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/Using-a-at-the-end-of-a-Select-statement-tp42672.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/Using-a-at-the-end-of-a-Select-statement-tp42672p42673.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] Using a ( at the end of a Select statement
It's possible the system I'm on started out in the 70's. I do use (P with select for outputting to a printer. So I thought maybe there were other control items. - 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/Using-a-at-the-end-of-a-Select-statement-tp42672p42674.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] Using a ( at the end of a Select statement
Yes at one time there were perhaps about 12 of them The 'S' probably suppresses something, like the item count. But I suspect that Universe is simply ignoring those options -Original Message- From: randyleesmith [via U2 (UniVerse UniData)] ml-node+s1073795n42674...@n5.nabble.com To: Will Johnson wjhon...@aol.com Sent: Thu, Feb 13, 2014 11:48 am Subject: Re: Using a ( at the end of a Select statement It's possible the system I'm on started out in the 70's. I do use (P with select for outputting to a printer. So I thought maybe there were other control items. 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/Using-a-at-the-end-of-a-Select-statement-tp42672p42674.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/Using-a-at-the-end-of-a-Select-statement-tp42672p42675.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] Using a ( at the end of a Select statement
I did forget one thing. The select in question was in an SB process. EXEC 'S:SELECT ACHPAY.TXT WITH CO = ':@PARMS(3)2:' (RSD' - 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/Using-a-at-the-end-of-a-Select-statement-tp42672p42676.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] Using a ( at the end of a Select statement
Well why didn't you say so? That makes a big difference. If you go into /pd.s to the Options prompt and hit F1 it will tell you what these all mean. S - means return a select list D - means data stack the results R - means return keys in selected format - no window -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Thursday, February 13, 2014 3:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using a ( at the end of a Select statement I did forget one thing. The select in question was in an SB process. EXEC 'S:SELECT ACHPAY.TXT WITH CO = ':@PARMS(3)2:' (RSD' - 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/Using-a-at-the-end-of-a-Select-statement-tp42672p42676.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 Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] ODBC - Not finding the MV fields.
We're running UniVerse 11.x and we've had ODBC setup for a while but recently started to use it more. The single-value fields work just fine, but on some of the Multi-Value fields (only certain tables) we can get the ODCB to work in excel by manually entering the SQL command but they don't show in Microsoft Query. So the issue is that we don't see it in the Microsoft Query window, or even in Access (for certain tables). Is there anyway to debug why the MV on some tables work, but others don't? Is there a way to list the tables that ODBC recognizes? I tried using Dr. DeeBee and it wasn't much help since I didn't get a log after running it. Any help is appreciated, thanks. Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using a ( at the end of a Select statement
Funny I made an PD.S not long ago. Just didn't associate the SB process code with a PD.S. It's been years since I've done a raw select in an SB process. I guess I've been coding to long in Unibasic. Thanks Dave. - 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/Using-a-at-the-end-of-a-Select-statement-tp42672p42679.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] Using a ( at the end of a Select statement
S:SELECT is just the inline form of a /PD.S. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Thursday, February 13, 2014 5:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using a ( at the end of a Select statement Funny I made an PD.S not long ago. Just didn't associate the SB process code with a PD.S. It's been years since I've done a raw select in an SB process. I guess I've been coding to long in Unibasic. Thanks Dave. - 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/Using-a-at-the-end-of-a-Select-statement-tp42672p42679.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 Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Debugging UNIX Segmentation Violations and Core Dumps (UV)
I received a copy of a CD, that has a lot of good information on it. It is labeled U2 Tech Support Survival Kit. It has some good documents and diagnostic utilities on it. Here is an example: IBM-U2 Data Management Solutions,Technical Support White Paper,Subject: Debugging UNIX Segmentation Violations and Core Dumps (UV) Anyone have a link to the latest equivalent of this CD on the Rocket Website? When I searched there was no mention on the Rocket website about SURVIVAL KIT. Thanks, Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (323) 285-7272, (951) 541-1668 http://universe-basic-programming.webstarts.com http://users.keyway.net/~ice/index.html http://www.affordablemultivalueprogramming.i8.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users