Re: [U2] [UV] Globally catalogs - source code
Hello LeRoy, Haven't seen you on u2-list for a while. Are you still in South Africa? I'm just up the road a piece (well, 3000 km, not necessarily paved) from you in Dar es Salaam as of last month. Chuck Stevenson On 8/21/2013 5:43 AM, LeRoy Dreyfuss wrote: Many are in APP.PROGS in the UV account. Regards, LeRoy Sent from my iPhone 4 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL Update Multiple rows
Hi Riverman That's obviously TSQL and therefore Microsoft specific. You can get clever in that way by mixing UniVerse SQL and EVAL expressions (which are the same as inline IDescriptors in RetrieVe) This should work the same as the example below: UPDATE Product SET Availability = EVAL IF ProductId = 1 THEN 5 ELSE IF ProductId = 2 THEN 5 ELSE IF ProductId = 6 THEN 5 ELSE Availability ; Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Riverman Sent: 22 August 2013 18:23 To: u2-users@listserver.u2ug.org Subject: [U2] SQL Update Multiple rows Here is the SQL example I am trying to follow UPDATE dbo.Product SET Availability=CASE When ProductId='1' Then '5' When ProductId='2' Then '5' When ProductId='6' Then '10' Else Availability END My attempts UPDATE TESTFILE SET TRAN.NUMBER=CASE WHEN CONTROL.NUMBER.NFMT='9001' THEN '' WHEN CONTROL.NUMBER.NFMT='66551' THEN '' WHEN CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END; UniVerse/SQL: A WHEN clause must have at least one multi-valued column UPDATE TESTFILE SET TRAN.NUMBER=CASE WHERE CONTROL.NUMBER.NFMT='9001' THEN '' WHERE CONTROL.NUMBER.NFMT='66551' THEN '' WHERE CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END; UniVerse/SQL: syntax error. Unexpected symbol. Token was THEN. Scanned command was UPDATE RECEIPT SET TRANSACTION.H = CASE WHERE CONTROL.NUMBER.NFMT = 900166550841 THEN Universe 10.1.1, Windows Server 2003 -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp 41681.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
[U2] [JOB] Las Colinas (Irving), TX
Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] Las Colinas (Irving), TX
You might forward this to texmug.org if you haven't already. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Holt Sent: Friday, August 23, 2013 9:00 AM To: u2-users Subject: [U2] [JOB] Las Colinas (Irving), TX Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ 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] [JOB] Las Colinas (Irving), TX
Already in process On Fri, Aug 23, 2013 at 9:15 AM, Michael Martin michael.mar...@innovationind.com wrote: You might forward this to texmug.org if you haven't already. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Holt Sent: Friday, August 23, 2013 9:00 AM To: u2-users Subject: [U2] [JOB] Las Colinas (Irving), TX Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] Las Colinas (Irving), TX
The company may also wish to post to http://www.pickjobs.net/ which now has 12 other MV jobs listed. Best to ya, bud. T - From: Bruce Holt Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] Las Colinas (Irving), TX
Looking at their internal job postings I dont' any that mention any type of MV platform at all. Have they not yet posted the job internally? -Original Message- From: Bruce Holt mvdb...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Aug 23, 2013 7:22 am Subject: Re: [U2] [JOB] Las Colinas (Irving), TX Already in process On Fri, Aug 23, 2013 at 9:15 AM, Michael Martin michael.mar...@innovationind.com wrote: You might forward this to texmug.org if you haven't already. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Holt Sent: Friday, August 23, 2013 9:00 AM To: u2-users Subject: [U2] [JOB] Las Colinas (Irving), TX Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ 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 ___ 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] [JOB] Las Colinas (Irving), TX
This was not listed internally nor on the web site. The reason being the position was outsourced to Wipro a few years ago. Wipro is looking to fill this position. On Fri, Aug 23, 2013 at 11:45 AM, Wjhonson wjhon...@aol.com wrote: Looking at their internal job postings I dont' any that mention any type of MV platform at all. Have they not yet posted the job internally? -Original Message- From: Bruce Holt mvdb...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Aug 23, 2013 7:22 am Subject: Re: [U2] [JOB] Las Colinas (Irving), TX Already in process On Fri, Aug 23, 2013 at 9:15 AM, Michael Martin michael.mar...@innovationind.com wrote: You might forward this to texmug.org if you haven't already. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Holt Sent: Friday, August 23, 2013 9:00 AM To: u2-users Subject: [U2] [JOB] Las Colinas (Irving), TX Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ 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 ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [JOB] Las Colinas (Irving), TX
I posted the job there but it shows the Location as anywhere, yet I specified the correct location in the location field when I created the posting. Weird. On Fri, Aug 23, 2013 at 10:54 AM, Tony Gravagno 3xk547...@sneakemail.comwrote: The company may also wish to post to http://www.pickjobs.net/ which now has 12 other MV jobs listed. Best to ya, bud. T - From: Bruce Holt Luxury retailer has need of a UniVerse DBA Where: Irving, TX What UniVerse DBA (must be on site, no telecommute) When: Now! Why: I vacated the position and my replacement could not make the move to be on site How: e-mail me your Resume/CV at mvdbman at gmail dot com Best regards, Bruce Certified UniVerse DBA ___ 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