[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

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

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:

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:

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:

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-

[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

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

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

[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