from:"chris"


What's the diff between

 OCONV(X,'MR20') and DROUND(X,2) ??

where X = N1 * N2



 From: lar...@wcs-corp.com
 To: u2-users@listserver.u2ug.org
 Date: Thu, 14 Oct 2010 09:25:23 -0700
 Subject: Re: [U2] how to round to 2 decimals?
 
 What's so difficult about ANS = DROUND(N1 * N2, 2) ?
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
 Sent: Thursday, October 14, 2010 8:59 AM
 To: U2 Users List
 Subject: Re: [U2] how to round to 2 decimals?
 
 Hi
 
 Never heard of the DROUND() function in Universe.
 
 Anyway, why would I want to use a function syntax when I can do
 
 ANS = N1 * N2 'R2' and it is the answer that gets rounded?
 Easy to write.
 Easy to read...
 
 John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
 Perkins PLC  |  01604 682751
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
 Sent: 14 October 2010 16:49
 To: 'U2 Users List'
 Subject: Re: [U2] how to round to 2 decimals?
 
 Does UniVerse not support the DROUND() function?  
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
 Sent: Thursday, October 14, 2010 1:02 AM
 To: U2 Users List
 Subject: Re: [U2] how to round to 2 decimals?
 
 Hi
 
 I've always used 'R2'
 
 e.g. ANS = N1 * N2 'R2'
 
 No scaling, just rounding
 
 Regards
 
 John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
 Perkins PLC  |  01604 682751
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: 13 October 2010 22:22
 To: u2-users@listserver.u2ug.org
 Subject: [U2] how to round to 2 decimals?
 
 
 I'm trying to figure out how to round to 2 decimal places with a
 floating point in UniVerse
 
 For example 2596 x 8.333 = 21,632.468
 
 How would you round that in UniVerse to 21,632.47?
 
 Thanks!
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 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
 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
 
 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

Re: [U2] how to round to 2 decimals?


Are you sure DROUND() is a UniVerse function?

When I do the following code:

X = 2596 * 8.333
*
PRINT DROUND(X,2)

I get the following error:

Array 'DROUND' never dimensioned.


 From: lar...@wcs-corp.com
 To: u2-users@listserver.u2ug.org
 Date: Thu, 14 Oct 2010 09:25:23 -0700
 Subject: Re: [U2] how to round to 2 decimals?
 
 What's so difficult about ANS = DROUND(N1 * N2, 2) ?
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
 Sent: Thursday, October 14, 2010 8:59 AM
 To: U2 Users List
 Subject: Re: [U2] how to round to 2 decimals?
 
 Hi
 
 Never heard of the DROUND() function in Universe.
 
 Anyway, why would I want to use a function syntax when I can do
 
 ANS = N1 * N2 'R2' and it is the answer that gets rounded?
 Easy to write.
 Easy to read...
 
 John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
 Perkins PLC  |  01604 682751
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
 Sent: 14 October 2010 16:49
 To: 'U2 Users List'
 Subject: Re: [U2] how to round to 2 decimals?
 
 Does UniVerse not support the DROUND() function?  
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
 Sent: Thursday, October 14, 2010 1:02 AM
 To: U2 Users List
 Subject: Re: [U2] how to round to 2 decimals?
 
 Hi
 
 I've always used 'R2'
 
 e.g. ANS = N1 * N2 'R2'
 
 No scaling, just rounding
 
 Regards
 
 John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
 Perkins PLC  |  01604 682751
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: 13 October 2010 22:22
 To: u2-users@listserver.u2ug.org
 Subject: [U2] how to round to 2 decimals?
 
 
 I'm trying to figure out how to round to 2 decimal places with a
 floating point in UniVerse
 
 For example 2596 x 8.333 = 21,632.468
 
 How would you round that in UniVerse to 21,632.47?
 
 Thanks!
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 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
 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
 
 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

Re: [U2] how to round to 2 decimals?


Thanks George,

I know this will be helpful with scaling, I know the need will arise for this 
in the future. 

-Chris



 From: ggal...@wyanokegroup.com
 To: u2-users@listserver.u2ug.org
 Date: Thu, 14 Oct 2010 12:23:50 -0500
 Subject: Re: [U2] how to round to 2 decimals?
 
 I always used   int ( ( x * 10**y) + roundinglevel ) / 10**y
 where x is the original number, and y is the number of decimals
 and where roundinglevel is a cutoff, ie (.5 so less than .5 rounds
 down, and .5 and greater rounds up), if I wanted all number to
 be rounded up, just use .. 
 
 And it works in all flavors
 
 George
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
  Sent: Thursday, October 14, 2010 12:25 PM
  To: 'U2 Users List'
  Subject: Re: [U2] how to round to 2 decimals?
  
  What's so difficult about ANS = DROUND(N1 * N2, 2) ?
  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
  Sent: Thursday, October 14, 2010 8:59 AM
  To: U2 Users List
  Subject: Re: [U2] how to round to 2 decimals?
  
  Hi
  
  Never heard of the DROUND() function in Universe.
  
  Anyway, why would I want to use a function syntax when I can do
  
  ANS = N1 * N2 'R2' and it is the answer that gets rounded?
  Easy to write.
  Easy to read...
  
  John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
  Perkins PLC  |  01604 682751
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry
  Hiscock
  Sent: 14 October 2010 16:49
  To: 'U2 Users List'
  Subject: Re: [U2] how to round to 2 decimals?
  
  Does UniVerse not support the DROUND() function?
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
  Sent: Thursday, October 14, 2010 1:02 AM
  To: U2 Users List
  Subject: Re: [U2] how to round to 2 decimals?
  
  Hi
  
  I've always used 'R2'
  
  e.g. ANS = N1 * N2 'R2'
  
  No scaling, just rounding
  
  Regards
  
  John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
  Perkins PLC  |  01604 682751
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: 13 October 2010 22:22
  To: u2-users@listserver.u2ug.org
  Subject: [U2] how to round to 2 decimals?
  
  
  I'm trying to figure out how to round to 2 decimal places with a
  floating point in UniVerse
  
  For example 2596 x 8.333 = 21,632.468
  
  How would you round that in UniVerse to 21,632.47?
  
  Thanks!
  
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
  
  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
  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
  
  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

Re: [U2] how to round to 2 decimals?


Dan,

That's pretty cool you got those results actually on your benchmark. I can only 
imagine why UniVerse would
be like that? Maybe it has to look up some libraries with OCONV or do some 
stupid cross-checking. Either
way that's actually a considerable difference if you were in a LOOP with 5,000+ 
records lets says.

That would shave off 5 1/2 minutes of processing time!

-Chris


 Date: Thu, 14 Oct 2010 11:00:08 -0700
 From: donr_w...@yahoo.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] how to round to 2 decimals?
 
 How about this?
 
 X = 2596 * 8.333 ;*  [X will contain 21632.468]
 ANS = INT((X * 100) + .5) / 100
 PRINT ANS
 
 
 The (X * 100) changes X to 2163246.8
 The + .5 changes X to 2163247.3
 The INT() changes X to 2163247
 The / 100 changes X to 21632.47
 
 The output will displays 21632.47
 
 Using a FOR NEXT loop, I run INT((21632.468 * 100) + .5) / 100 and 
 the OCONV(21632.468,'MR20') versions one million times and got .84 seconds 
 for 
 the INT version and 4.9 seconds for the OCONV version.
 
 I doubt that 4 seconds would make a difference to most programs but every 
 little 
 helps.
 
 I also run the OCONV(ICONV(21632.468,'MD2'),'MD2') version and it took 5.1 
 seconds.
 
 My point: There is more than one way to skin a cat!
 
 Don Robinson
 
 
  
 
 
 
 
 From: Chris Austin cjausti...@hotmail.com
 To: u2-users@listserver.u2ug.org
 Sent: Thu, October 14, 2010 12:34:36 PM
 Subject: Re: [U2] how to round to 2 decimals?
 
 
 Are you sure DROUND() is a UniVerse function?
 
 When I do the following code:
 
 X = 2596 * 8.333
 *
 PRINT DROUND(X,2)
 
 I get the following error:
 
 Array 'DROUND' never dimensioned.
 
 
  From: lar...@wcs-corp.com
  To: u2-users@listserver.u2ug.org
  Date: Thu, 14 Oct 2010 09:25:23 -0700
  Subject: Re: [U2] how to round to 2 decimals?
  
  What's so difficult about ANS = DROUND(N1 * N2, 2) ?
  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
  Sent: Thursday, October 14, 2010 8:59 AM
  To: U2 Users List
  Subject: Re: [U2] how to round to 2 decimals?
  
  Hi
  
  Never heard of the DROUND() function in Universe.
  
  Anyway, why would I want to use a function syntax when I can do
  
  ANS = N1 * N2 'R2' and it is the answer that gets rounded?
  Easy to write.
  Easy to read...
  
  John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
  Perkins PLC  |  01604 682751
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
  Sent: 14 October 2010 16:49
  To: 'U2 Users List'
  Subject: Re: [U2] how to round to 2 decimals?
  
  Does UniVerse not support the DROUND() function?  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
  Sent: Thursday, October 14, 2010 1:02 AM
  To: U2 Users List
  Subject: Re: [U2] how to round to 2 decimals?
  
  Hi
  
  I've always used 'R2'
  
  e.g. ANS = N1 * N2 'R2'
  
  No scaling, just rounding
  
  Regards
  
  John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
  Perkins PLC  |  01604 682751
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: 13 October 2010 22:22
  To: u2-users@listserver.u2ug.org
  Subject: [U2] how to round to 2 decimals?
  
  
  I'm trying to figure out how to round to 2 decimal places with a
  floating point in UniVerse
  
  For example 2596 x 8.333 = 21,632.468
  
  How would you round that in UniVerse to 21,632.47?
  
  Thanks!
   
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
  
  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

Re: [U2] how to round to 2 decimals?


oops.. I should have read your post closer. 

' one million times' - so yeah that wouldn't make a huge difference but it's 
still good to know!

-Chris


 Date: Thu, 14 Oct 2010 11:00:08 -0700
 From: donr_w...@yahoo.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] how to round to 2 decimals?
 
 How about this?
 
 X = 2596 * 8.333 ;*  [X will contain 21632.468]
 ANS = INT((X * 100) + .5) / 100
 PRINT ANS
 
 
 The (X * 100) changes X to 2163246.8
 The + .5 changes X to 2163247.3
 The INT() changes X to 2163247
 The / 100 changes X to 21632.47
 
 The output will displays 21632.47
 
 Using a FOR NEXT loop, I run INT((21632.468 * 100) + .5) / 100 and 
 the OCONV(21632.468,'MR20') versions one million times and got .84 seconds 
 for 
 the INT version and 4.9 seconds for the OCONV version.
 
 I doubt that 4 seconds would make a difference to most programs but every 
 little 
 helps.
 
 I also run the OCONV(ICONV(21632.468,'MD2'),'MD2') version and it took 5.1 
 seconds.
 
 My point: There is more than one way to skin a cat!
 
 Don Robinson
 
 
  
 
 
 
 
 From: Chris Austin cjausti...@hotmail.com
 To: u2-users@listserver.u2ug.org
 Sent: Thu, October 14, 2010 12:34:36 PM
 Subject: Re: [U2] how to round to 2 decimals?
 
 
 Are you sure DROUND() is a UniVerse function?
 
 When I do the following code:
 
 X = 2596 * 8.333
 *
 PRINT DROUND(X,2)
 
 I get the following error:
 
 Array 'DROUND' never dimensioned.
 
 
  From: lar...@wcs-corp.com
  To: u2-users@listserver.u2ug.org
  Date: Thu, 14 Oct 2010 09:25:23 -0700
  Subject: Re: [U2] how to round to 2 decimals?
  
  What's so difficult about ANS = DROUND(N1 * N2, 2) ?
  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
  Sent: Thursday, October 14, 2010 8:59 AM
  To: U2 Users List
  Subject: Re: [U2] how to round to 2 decimals?
  
  Hi
  
  Never heard of the DROUND() function in Universe.
  
  Anyway, why would I want to use a function syntax when I can do
  
  ANS = N1 * N2 'R2' and it is the answer that gets rounded?
  Easy to write.
  Easy to read...
  
  John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
  Perkins PLC  |  01604 682751
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
  Sent: 14 October 2010 16:49
  To: 'U2 Users List'
  Subject: Re: [U2] how to round to 2 decimals?
  
  Does UniVerse not support the DROUND() function?  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
  Sent: Thursday, October 14, 2010 1:02 AM
  To: U2 Users List
  Subject: Re: [U2] how to round to 2 decimals?
  
  Hi
  
  I've always used 'R2'
  
  e.g. ANS = N1 * N2 'R2'
  
  No scaling, just rounding
  
  Regards
  
  John Woollam  |  Group Function Support 1  (Finance Systems)  |  Travis
  Perkins PLC  |  01604 682751
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: 13 October 2010 22:22
  To: u2-users@listserver.u2ug.org
  Subject: [U2] how to round to 2 decimals?
  
  
  I'm trying to figure out how to round to 2 decimal places with a
  floating point in UniVerse
  
  For example 2596 x 8.333 = 21,632.468
  
  How would you round that in UniVerse to 21,632.47?
  
  Thanks!
   
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
  
  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

[U2] how to round to 2 decimals?

2010-10-13 Thread Chris Austin


I'm trying to figure out how to round to 2 decimal places with a floating point 
in UniVerse

For example 2596 x 8.333 = 21,632.468

How would you round that in UniVerse to 21,632.47?

Thanks!
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] how to round to 2 decimals?

2010-10-13 Thread Chris Austin


Thanks so much!

X = 2597 * 8.333
PRINT OCONV(X,MR2)
PRINT OCONV(X,MD2)
PRINT OCONV(ICONV(X,'MD2'),'MD2')
PRINT OCONV(X,'MR20')

yields the following:

216.41
216.41
21640.80
21640.80

so basically the 2 that worked are:

OCONV(ICONV(X,'MD2'),'MD2')
OCONV(X,'MR20')

you guys rock! :-)

-Chris


 Date: Wed, 13 Oct 2010 15:37:29 -0600
 From: precisonl...@gmail.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] how to round to 2 decimals?
 
 If the value already has the decimal point in it, MR2 or MD2 will scale the
 value as well as round.  If you want to leave the decimal place alone, use:
 
 ROUNDED = OCONV(ORIGINAL.VALUE,'MR20')
 
 Remember that MR2 or MD2 is the same as MR22/MD22, where the first number is
 the number of decimals to show and the second digit is the number of
 decimals to scale.
 
 -K
 ___
 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] UVRESTORE error

2010-10-01 Thread Chris Austin


I looked up the -REV command and found that you can use following commands:
-
–rev93
Produces a backup in a format suitable for restoring to UniVerse Release 9.3.
–rev94
Produces a backup in a format suitable for restoring to UniVerse Release 9.4.
–rev95
Produces a backup in a format suitable for restoring to UniVerse Releases 9.5.1 
through 9.5.1C.
-
I did a VLIST on how we compile programs on the old server (developer server) 
and noticed the following:
-
Compiler Version: 10.1.0.0
Object Level: 5
Machine Type: 11
Local Variables : 145
Subroutine args : 1
Unnamed Common  : 0
Named Common Seg: 1
Object Size : 4140
Source lines: 374
-
We're using UniVerse 10.1.18 (according to UniAdmin) on this older server and 
I'm not sure what -REV to use.

Does anyone know based on the information above which -REV flag would work?

-Chris



 From: jpb-u...@hotmail.com
 To: u2-users@listserver.u2ug.org
 Date: Tue, 28 Sep 2010 17:35:08 -0500
 Subject: Re: [U2] UVRESTORE error
 
 Look up the command in the documentation. You will notice that if you are
 going to restore to a lower revision you will need to back up with one of
 the -rev options.
 
 Jerry Banker
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Tuesday, September 28, 2010 1:22 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UVRESTORE error
 
 
 Hello,
 
 We have a new version of UniVerse on our new server and every night we make
 a backup image
 using UVBACKUP. Today I tried to do a UVRESTORE from last night's backup
 onto the old server
 which is running a slightly older version of UniVerse and received the
 following message:
 
 WARNING: Unable to restore image of revision level 10.  This
 process is only capable of restoring backup images
 created with revisions between 2 and 9, inclusive.
 
 I'm assuming this message is due to the different versions of UniVerse but I
 was curious if there
 was a quick workaround that people have found? 
 
 Thanks,
 
 Chris
 
 ___
 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] where did everyone go ?

I'm still here :) I noticed the same thing though. Wonder if some people 
dropped off the mailing list..

-Chris

 Date: Fri, 1 Oct 2010 06:52:26 +0530
 From: anantkum...@gmail.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] where did everyone go ?

 Same here :-)

 Anant

 On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote:

  I'm lurking as usual, nothing to add, lots to learn. 8-)

  Brian

  From: u2ug simpson-u...@gerzio.ca
  To: u2-users@listserver.u2ug.org
  Date: 27/09/2010 18:07
  Subject: [U2] where did everyone go ?
  Sent by: u2-users-boun...@listserver.u2ug.org

  The number of postings has drastically dropped over the past few weeks
  down to virtually zero
  Has the list been relegated the dust bin and I missed the notice ?

  ___
  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] where did everyone go ?


I just replied to this thread, and noticed something very odd. I got this 
message:
 
mvargh...@silverlinewindow.com - no such user here.
 
There is no user by that name at this server.
: Message contains [1] file attachments
 
---
 
Maybe this has something to do with it??
 
-Chris

 

 
 Date: Fri, 1 Oct 2010 06:52:26 +0530
 From: anantkum...@gmail.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] where did everyone go ?
 
 Same here :-)
 
 Anant
 
 On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote:
 
  I'm lurking as usual, nothing to add, lots to learn. 8-)
 
  Brian
 
 
 
  From: u2ug simpson-u...@gerzio.ca
  To: u2-users@listserver.u2ug.org
  Date: 27/09/2010 18:07
  Subject: [U2] where did everyone go ?
  Sent by: u2-users-boun...@listserver.u2ug.org
 
 
 
  The number of postings has drastically dropped over the past few weeks
  down to virtually zero
  Has the list been relegated the dust bin and I missed the notice ?
 
 
 
  ___
  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] where did everyone go ?


I just replied to this thread, and noticed something very odd. I got this 
message:
 
mvargh...@silverlinewindow.com - no such user here.

There is no user by that name at this server.
: Message contains [1] file attachments
 
---
 
Maybe this has something to do with it??
 
-Chris

 

 
 Date: Fri, 1 Oct 2010 06:52:26 +0530
 From: anantkum...@gmail.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] where did everyone go ?
 
 Same here :-)
 
 Anant
 
 On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote:
 
  I'm lurking as usual, nothing to add, lots to learn. 8-)
 
  Brian
 
 
 
  From: u2ug simpson-u...@gerzio.ca
  To: u2-users@listserver.u2ug.org
  Date: 27/09/2010 18:07
  Subject: [U2] where did everyone go ?
  Sent by: u2-users-boun...@listserver.u2ug.org
 
 
 
  The number of postings has drastically dropped over the past few weeks
  down to virtually zero
  Has the list been relegated the dust bin and I missed the notice ?
 
 
 
  ___
  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] UV index with duplicate nodes


I assume you have tried rebuilding the indices? 
 
That usually fixes almost all of our issues with index problems. Otherwise I 
would delete the index and
build it back again. If you need any code that we use just ask me and I can 
email it to you. 
 
-Chris

 
 From: jpb-u...@hotmail.com
 To: u2-users@listserver.u2ug.org
 Date: Thu, 30 Sep 2010 21:19:22 -0500
 Subject: Re: [U2] UV index with duplicate nodes
 
 Does the correlative have any special coding in it? I would suggest deleting
 the index for this field recreate the field as a D type then add the field
 to the index again. Some correlatives don't give you what you would expect.
 
 Jerry Banker
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis
 Sent: Thursday, September 30, 2010 7:47 PM
 To: U2-Users@listserver.u2ug.org
 Subject: [U2] UV index with duplicate nodes
 
 We've just uncovered a rather unusual and unsettling situation. We have a
 file with a single index that has somehow gotten nodes with duplicate keys.
 A simple example would be having an index on ZIPCODE in a address database,
 and finding that there are _two_ nodes (records) in the index for ZIPCODE
 12345, for example. The source records referred to in the nodes are not
 duplicated, but since most operations find the 'first' node, any source
 records referred to in the duplicate node appear to not exist in the index.
 
 LIST.INDEX fname ALL
 Alternate Key Index Summary for file fname
 File... fname
 Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type)
 Index Updates.. Enabled, No updates pending
 
 Index name Type Build Nulls In DICT S/M Just Unique Field
 num/I-type
 fieldname A Not Reqd Yes Yes M L N 2
 
 
 The file contains 6,539,233 records, with 574,547 unique values in fieldname
 (which is actually a single-valued field, and has been verified that each
 record's fieldname contains one and only one value). We found that 9 source
 records appear to have not been included in the index, but upon further
 research found the nodes with duplicate keys. We created an F-pointer to
 the index file itself (not normally recommended, but useful), then got the
 results like the following:
 
 LIST indexfile WITH @ID = 12345] F1 F2
 
 fname. F1 F2
 12345 987654 876543
 12345-6789 765432 543219
 12345 654321
 
 We are having our UniVerse administrator ask our dealer for assistance, but
 were interested if any other users have had any recent similar experiences,
 or advice.
 
 Sincerely Best Regards,
 
 Richard Lewis
 IBM Certified Solutions Expert
 
 Nu Skin Enterprises
 ___
 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] UVRESTORE error

2010-09-28 Thread Chris Austin


Hello,

We have a new version of UniVerse on our new server and every night we make a 
backup image
using UVBACKUP. Today I tried to do a UVRESTORE from last night's backup onto 
the old server
which is running a slightly older version of UniVerse and received the 
following message:

WARNING: Unable to restore image of revision level 10.  This
process is only capable of restoring backup images
created with revisions between 2 and 9, inclusive.

I'm assuming this message is due to the different versions of UniVerse but I 
was curious if there
was a quick workaround that people have found? 

Thanks,

Chris
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] possible to reverse engineer unibasic object?

2010-08-31 Thread Chris Austin


I was wondering if there was an easy way to reverse engineer unibasic object 
and turn it into
source code? We have some old (but necessary) programs that we can't seem to 
find the 
source anywhere for. However we do have the object code. Any help is 
appreciated.

Chris

  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] possible to reverse engineer unibasic object?

2010-08-31 Thread Chris Austin


Sweet!! Thanks a ton Carl. 

-Chris


 From: c...@pulsarsystems.com
 To: u2-users@listserver.u2ug.org
 Date: Tue, 31 Aug 2010 11:41:56 -0400
 Subject: Re: [U2] possible to reverse engineer unibasic object?
 
 Take a look at:
 
 http://www.srs4uv.com/
 
 --
 Carl Dula   Voice: 973-227-8440 X111
 Pulsar Systems, Inc.Fax: 973-227-8440
 271 Route 46 West, Suite H209   email:c...@pulsarsystems.com
 Fairfield, NJ 07004-2474http://www.pulsarsystems.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] easiest way to COMPILE/CATALOG for a build?


I'm attempting to CATALOG from the CMD line and I get stuck on an error:

C:\CHRISCATALOG LFUTILS TEST_HARNESS5
CATALOG command line parsing error.

is this telling me that I physically cannot CATALOG a universe program from CMD 
line in windows?



 From: robert.hou...@fwic.net
 To: u2-users@listserver.u2ug.org
 Date: Wed, 18 Aug 2010 14:29:48 -0700
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 You could probably just do the compile from the folder where your VOC is. I 
 believe the basic.exe command opens the VOC and uses it to resolve the 
 reference to the file, so the fact that it is elsewhere should work. Flying 
 half from memory, so it might not work...
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Wednesday, August 18, 2010 2:21 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
 Thanks Robert,
 
 That actually worked. There is one issue however. I had to copy my VOC into 
 my programing folder for it to work. Our setup is as follows:
 
 c:\CHRIS this is where we keep our DATA tables. (VOC is also kept 
 here)
 c:\CHRISSYS   this is where we keep our SOURCE code.
 
 It would be nice if we could compile without moving the VOC everytime. I'll 
 be working some more on this.
 
 Chris
 
 
  From: robert.hou...@fwic.net
  To: u2-users@listserver.u2ug.org
  Date: Wed, 18 Aug 2010 14:01:31 -0700
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
  Try running it from the directory where the VOC resides with the 
  C:\IBM\UV\bin directory added to your path.
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org 
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Wednesday, August 18, 2010 2:00 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
  So it seems like it wants to compile it but can't open the VOC. I'm not 
  sure which VOC it's trying to use (the one c:\Chris
  or the one in c:\IBM\uv\bin). This is what I get from the command line
 
  C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5
  Unable to open 'VOC' file
 
  I have made sure that in the folder security settings that I have full 
  rights to the IBM/*.* and CHRIS/*.* folders.
 
  Any ideas why it would be unable to open the VOC?
 
 
  * on a side note to Doug, we want to keep the compiling very simple without 
  many java scripts. Currently we're using a java
  script but we want to do it on a command line level IF possible.
 
 
 
   From: d.hender...@moreheadstate.edu
   To: u2-users@listserver.u2ug.org
   Date: Wed, 18 Aug 2010 16:45:32 -0400
   Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
   ...should have clarified that the below command is executed at the OS 
   command prompt.
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org 
   [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Drew William 
   Henderson
   Sent: Wednesday, August 18, 2010 4:43 PM
   To: U2 Users List
   Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
   Chris,
  
   Are you on Windows or Unix/Linux?
  
   On the ?nix version, you can execute uv/bin program basic to compile 
   your programs (and assume you can catalog, as well, but never tried it.)  
   Assuming uv/bin is in your PATH, if the folder/directory is SOURCE, and 
   you want to compile the file PROG1, you can use the following command:
  
   basic SOURCE PROG1
  
   Wildcarding may be a problem, but can put multiple files on the command 
   line.  Of course, you could write a quick script to do all this for you, 
   as well.
  
   (DISCLAIMER: We're running 10.2 on Linux, and the above worked your 
   mileage may vary! :-)  )
  
   If you're running Universe on Windows, I can't speak to that!
  
   HTH
   Drew
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org 
   [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
   Sent: Wednesday, August 18, 2010 4:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] easiest way to COMPILE/CATALOG for a build?
  
  
   Hello,
  
   We just recently changed our entire repository from Source Safe to SVN 
   and we're now using
   hudson to automate our builds. This works great for Java since we can 
   simply compile ALL
   the programs using the JAVA compiler in a batch file.
  
   Universe however seems to require us sign into a Universe account and 
   then compile/catalog
   all our programs. Is there a way you can compile all programs in a folder 
   from a batch file?
   We need to do the same to CATALOG all our programs.
  
   Here's why:
  
   We submit all of our changes to 1 central SVN repository, when we want to 
   'release' the object code
   to the production server it runs on a different UniVerse region

Re: [U2] easiest way to COMPILE/CATALOG for a build?


Ed, 

I tried both with no luck. Here was my output:

C:\CHRISUDT CATALOG LFUTILS TEST_HARNESS5
'UDT' is not recognized as an internal or external command,
operable program or batch file.

C:\CHRISPHANTOM CATALOG LFUTILS TEST_HARNESS5
'PHANTOM' is not recognized as an internal or external command,
operable program or batch file.

I didn't see the program UDT.exe or PHANTOM.exe in the IBM/UV/bin dir



 Date: Thu, 19 Aug 2010 14:42:00 +0100
 From: ebr...@civica.co.uk
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 Can't you just do
 
 C:\CHRISudt CATALOG LFUTILS TEST_HARNESS5
 
 Or use phantom instead of udt...
 
 Ed
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: 19 August 2010 14:37
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
 I'm attempting to CATALOG from the CMD line and I get stuck on an error:
 
 C:\CHRISCATALOG LFUTILS TEST_HARNESS5
 CATALOG command line parsing error.
 
 is this telling me that I physically cannot CATALOG a universe program
 from CMD line in windows?
 
 
 
  From: robert.hou...@fwic.net
  To: u2-users@listserver.u2ug.org
  Date: Wed, 18 Aug 2010 14:29:48 -0700
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
  You could probably just do the compile from the folder where your VOC
 is. I believe the basic.exe command opens the VOC and uses it to resolve
 the reference to the file, so the fact that it is elsewhere should work.
 Flying half from memory, so it might not work...
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Wednesday, August 18, 2010 2:21 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
  
  Thanks Robert,
  
  That actually worked. There is one issue however. I had to copy my VOC
 into my programing folder for it to work. Our setup is as follows:
  
  c:\CHRIS this is where we keep our DATA tables. (VOC is also
 kept here)
  c:\CHRISSYS   this is where we keep our SOURCE code.
  
  It would be nice if we could compile without moving the VOC everytime.
 I'll be working some more on this.
  
  Chris
  
  
   From: robert.hou...@fwic.net
   To: u2-users@listserver.u2ug.org
   Date: Wed, 18 Aug 2010 14:01:31 -0700
   Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
   Try running it from the directory where the VOC resides with the
 C:\IBM\UV\bin directory added to your path.
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
   Sent: Wednesday, August 18, 2010 2:00 PM
   To: u2-users@listserver.u2ug.org
   Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
  
   So it seems like it wants to compile it but can't open the VOC. I'm
 not sure which VOC it's trying to use (the one c:\Chris
   or the one in c:\IBM\uv\bin). This is what I get from the command
 line
  
   C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5
   Unable to open 'VOC' file
  
   I have made sure that in the folder security settings that I have
 full rights to the IBM/*.* and CHRIS/*.* folders.
  
   Any ideas why it would be unable to open the VOC?
  
  
   * on a side note to Doug, we want to keep the compiling very simple
 without many java scripts. Currently we're using a java
   script but we want to do it on a command line level IF possible.
  
  
  
From: d.hender...@moreheadstate.edu
To: u2-users@listserver.u2ug.org
Date: Wed, 18 Aug 2010 16:45:32 -0400
Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
   
...should have clarified that the below command is executed at the
 OS command prompt.
   
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Drew William
 Henderson
Sent: Wednesday, August 18, 2010 4:43 PM
To: U2 Users List
Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
   
Chris,
   
Are you on Windows or Unix/Linux?
   
On the ?nix version, you can execute uv/bin program basic to
 compile your programs (and assume you can catalog, as well, but never
 tried it.)  Assuming uv/bin is in your PATH, if the folder/directory is
 SOURCE, and you want to compile the file PROG1, you can use the
 following command:
   
basic SOURCE PROG1
   
Wildcarding may be a problem, but can put multiple files on the
 command line.  Of course, you could write a quick script to do all this
 for you, as well.
   
(DISCLAIMER: We're running 10.2 on Linux, and the above worked
 your mileage may vary! :-)  )
   
If you're running Universe on Windows, I can't speak to that!
   
HTH
Drew

Re: [U2] easiest way to COMPILE/CATALOG for a build?


If someone knows of a way I would be interested in hearing it. It appears that 
it's trying to 
CATALOG the file but the 'COMMAND LINE PARSING ERROR' usually indicates the 
syntax is incorrect
I though. 



 Date: Thu, 19 Aug 2010 14:57:44 +0100
 From: ebr...@civica.co.uk
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 Oh, sorry. Those are unidata commands. But I believe universe has
 phantoms that are launched in much the same way...
 
 Ed
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: 19 August 2010 14:56
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
 Ed, 
 
 I tried both with no luck. Here was my output:
 
 C:\CHRISUDT CATALOG LFUTILS TEST_HARNESS5
 'UDT' is not recognized as an internal or external command,
 operable program or batch file.
 
 C:\CHRISPHANTOM CATALOG LFUTILS TEST_HARNESS5
 'PHANTOM' is not recognized as an internal or external command,
 operable program or batch file.
 
 I didn't see the program UDT.exe or PHANTOM.exe in the IBM/UV/bin dir
 
 
 
  Date: Thu, 19 Aug 2010 14:42:00 +0100
  From: ebr...@civica.co.uk
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
  Can't you just do
  
  C:\CHRISudt CATALOG LFUTILS TEST_HARNESS5
  
  Or use phantom instead of udt...
  
  Ed
  
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
 Austin
  Sent: 19 August 2010 14:37
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
  
  
  I'm attempting to CATALOG from the CMD line and I get stuck on an
 error:
  
  C:\CHRISCATALOG LFUTILS TEST_HARNESS5
  CATALOG command line parsing error.
  
  is this telling me that I physically cannot CATALOG a universe program
  from CMD line in windows?
  
  
  
   From: robert.hou...@fwic.net
   To: u2-users@listserver.u2ug.org
   Date: Wed, 18 Aug 2010 14:29:48 -0700
   Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
   
   You could probably just do the compile from the folder where your
 VOC
  is. I believe the basic.exe command opens the VOC and uses it to
 resolve
  the reference to the file, so the fact that it is elsewhere should
 work.
  Flying half from memory, so it might not work...
   
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
 Austin
   Sent: Wednesday, August 18, 2010 2:21 PM
   To: u2-users@listserver.u2ug.org
   Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
   
   
   Thanks Robert,
   
   That actually worked. There is one issue however. I had to copy my
 VOC
  into my programing folder for it to work. Our setup is as follows:
   
   c:\CHRIS this is where we keep our DATA tables. (VOC is
 also
  kept here)
   c:\CHRISSYS   this is where we keep our SOURCE code.
   
   It would be nice if we could compile without moving the VOC
 everytime.
  I'll be working some more on this.
   
   Chris
   
   
From: robert.hou...@fwic.net
To: u2-users@listserver.u2ug.org
Date: Wed, 18 Aug 2010 14:01:31 -0700
Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
   
Try running it from the directory where the VOC resides with the
  C:\IBM\UV\bin directory added to your path.
   
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
 Austin
Sent: Wednesday, August 18, 2010 2:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
   
   
So it seems like it wants to compile it but can't open the VOC.
 I'm
  not sure which VOC it's trying to use (the one c:\Chris
or the one in c:\IBM\uv\bin). This is what I get from the command
  line
   
C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5
Unable to open 'VOC' file
   
I have made sure that in the folder security settings that I have
  full rights to the IBM/*.* and CHRIS/*.* folders.
   
Any ideas why it would be unable to open the VOC?
   
   
* on a side note to Doug, we want to keep the compiling very
 simple
  without many java scripts. Currently we're using a java
script but we want to do it on a command line level IF possible.
   
   
   
 From: d.hender...@moreheadstate.edu
 To: u2-users@listserver.u2ug.org
 Date: Wed, 18 Aug 2010 16:45:32 -0400
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

 ...should have clarified that the below command is executed at
 the
  OS command prompt.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] easiest way to COMPILE/CATALOG for a build?

Sweet, that worked! Thanks for all the help. 

 Date: Thu, 19 Aug 2010 08:24:11 -0600
 From: jscha...@gmail.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

 Use uv instead of udt if it's not in your PATH then it would be 
 c:\IBM\UV\BIN\uv.exe

 Chris Austin wrote:
  If someone knows of a way I would be interested in hearing it. It appears 
  that it's trying to 
  CATALOG the file but the 'COMMAND LINE PARSING ERROR' usually indicates the 
  syntax is incorrect
  I though. 

  Date: Thu, 19 Aug 2010 14:57:44 +0100
  From: ebr...@civica.co.uk
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  Oh, sorry. Those are unidata commands. But I believe universe has
  phantoms that are launched in much the same way...

  Ed

  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: 19 August 2010 14:56
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  Ed, 

  I tried both with no luck. Here was my output:

  C:\CHRISUDT CATALOG LFUTILS TEST_HARNESS5
  'UDT' is not recognized as an internal or external command,
  operable program or batch file.

  C:\CHRISPHANTOM CATALOG LFUTILS TEST_HARNESS5
  'PHANTOM' is not recognized as an internal or external command,
  operable program or batch file.

  I didn't see the program UDT.exe or PHANTOM.exe in the IBM/UV/bin dir

  Date: Thu, 19 Aug 2010 14:42:00 +0100
  From: ebr...@civica.co.uk
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  Can't you just do

  C:\CHRISudt CATALOG LFUTILS TEST_HARNESS5

  Or use phantom instead of udt...

  Ed

  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris

  Austin

  Sent: 19 August 2010 14:37
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  I'm attempting to CATALOG from the CMD line and I get stuck on an

  error:

  C:\CHRISCATALOG LFUTILS TEST_HARNESS5
  CATALOG command line parsing error.

  is this telling me that I physically cannot CATALOG a universe program
  from CMD line in windows?

  From: robert.hou...@fwic.net
  To: u2-users@listserver.u2ug.org
  Date: Wed, 18 Aug 2010 14:29:48 -0700
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  You could probably just do the compile from the folder where your

  VOC

  is. I believe the basic.exe command opens the VOC and uses it to

  resolve

  the reference to the file, so the fact that it is elsewhere should

  work.

  Flying half from memory, so it might not work...

  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org

  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris

  Austin

  Sent: Wednesday, August 18, 2010 2:21 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  Thanks Robert,

  That actually worked. There is one issue however. I had to copy my

  VOC

  into my programing folder for it to work. Our setup is as follows:

  c:\CHRIS this is where we keep our DATA tables. (VOC is

  also

  kept here)

  c:\CHRISSYS   this is where we keep our SOURCE code.

  It would be nice if we could compile without moving the VOC

  everytime.

  I'll be working some more on this.

  Chris

  From: robert.hou...@fwic.net
  To: u2-users@listserver.u2ug.org
  Date: Wed, 18 Aug 2010 14:01:31 -0700
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  Try running it from the directory where the VOC resides with the

  C:\IBM\UV\bin directory added to your path.

  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org

  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris

  Austin

  Sent: Wednesday, August 18, 2010 2:00 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

  So it seems like it wants to compile it but can't open the VOC.

  I'm

  not sure which VOC it's trying to use (the one c:\Chris

  or the one in c:\IBM\uv\bin). This is what I get from the command

  line

  C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5
  Unable to open 'VOC' file

  I have made sure that in the folder security settings that I have

  full rights to the IBM/*.* and CHRIS/*.* folders.

  Any ideas why it would be unable to open the VOC?

  * on a side note to Doug, we want

[U2] easiest way to COMPILE/CATALOG for a build?


Hello,

We just recently changed our entire repository from Source Safe to SVN and 
we're now using 
hudson to automate our builds. This works great for Java since we can simply 
compile ALL 
the programs using the JAVA compiler in a batch file.

Universe however seems to require us sign into a Universe account and then 
compile/catalog
all our programs. Is there a way you can compile all programs in a folder from 
a batch file?
We need to do the same to CATALOG all our programs. 

Here's why: 

We submit all of our changes to 1 central SVN repository, when we want to 
'release' the object code
to the production server it runs on a different UniVerse region and totally 
different server, so we 
have the need to compile all the programs at once in the build, then CATALOG 
all of the programs
to the production universe region. 

Is there an easy way to do this?

Right now we have a batch file that logins into our Java webapp, then it logs 
into universe from 
the webapp so that it can compile/catalog but there has to be an easier way. 


  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] easiest way to COMPILE/CATALOG for a build?

Unfortunately we are on a Windows 2008 server platform. 

I will try putting the uv/bin in my PATH as well and giving it a go.

 From: d.hender...@moreheadstate.edu
 To: u2-users@listserver.u2ug.org
 Date: Wed, 18 Aug 2010 16:43:05 -0400
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?

 Chris,

 Are you on Windows or Unix/Linux?

 On the ?nix version, you can execute uv/bin program basic to compile your 
 programs (and assume you can catalog, as well, but never tried it.)  Assuming 
 uv/bin is in your PATH, if the folder/directory is SOURCE, and you want to 
 compile the file PROG1, you can use the following command:

 basic SOURCE PROG1

 Wildcarding may be a problem, but can put multiple files on the command line. 
  Of course, you could write a quick script to do all this for you, as well.

 (DISCLAIMER: We're running 10.2 on Linux, and the above worked your 
 mileage may vary! :-)  )

 If you're running Universe on Windows, I can't speak to that!

 HTH
 Drew

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Wednesday, August 18, 2010 4:19 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] easiest way to COMPILE/CATALOG for a build?

 Hello,

 We just recently changed our entire repository from Source Safe to SVN and 
 we're now using 
 hudson to automate our builds. This works great for Java since we can simply 
 compile ALL 
 the programs using the JAVA compiler in a batch file.

 Universe however seems to require us sign into a Universe account and then 
 compile/catalog
 all our programs. Is there a way you can compile all programs in a folder 
 from a batch file?
 We need to do the same to CATALOG all our programs. 

 Here's why: 

 We submit all of our changes to 1 central SVN repository, when we want to 
 'release' the object code
 to the production server it runs on a different UniVerse region and totally 
 different server, so we 
 have the need to compile all the programs at once in the build, then CATALOG 
 all of the programs
 to the production universe region. 

 Is there an easy way to do this?

 Right now we have a batch file that logins into our Java webapp, then it logs 
 into universe from 
 the webapp so that it can compile/catalog but there has to be an easier way. 

 ___
 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] easiest way to COMPILE/CATALOG for a build?


So it seems like it wants to compile it but can't open the VOC. I'm not sure 
which VOC it's trying to use (the one c:\Chris 
or the one in c:\IBM\uv\bin). This is what I get from the command line

C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5
Unable to open 'VOC' file

I have made sure that in the folder security settings that I have full rights 
to the IBM/*.* and CHRIS/*.* folders. 

Any ideas why it would be unable to open the VOC?


* on a side note to Doug, we want to keep the compiling very simple without 
many java scripts. Currently we're using a java
script but we want to do it on a command line level IF possible. 



 From: d.hender...@moreheadstate.edu
 To: u2-users@listserver.u2ug.org
 Date: Wed, 18 Aug 2010 16:45:32 -0400
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 ...should have clarified that the below command is executed at the OS command 
 prompt.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Drew William 
 Henderson
 Sent: Wednesday, August 18, 2010 4:43 PM
 To: U2 Users List
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 Chris,
 
 Are you on Windows or Unix/Linux?
 
 On the ?nix version, you can execute uv/bin program basic to compile your 
 programs (and assume you can catalog, as well, but never tried it.)  Assuming 
 uv/bin is in your PATH, if the folder/directory is SOURCE, and you want to 
 compile the file PROG1, you can use the following command:
 
 basic SOURCE PROG1
 
 Wildcarding may be a problem, but can put multiple files on the command line. 
  Of course, you could write a quick script to do all this for you, as well.
 
 (DISCLAIMER: We're running 10.2 on Linux, and the above worked your 
 mileage may vary! :-)  )
 
 If you're running Universe on Windows, I can't speak to that!
 
 HTH
 Drew
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Wednesday, August 18, 2010 4:19 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
 Hello,
 
 We just recently changed our entire repository from Source Safe to SVN and 
 we're now using 
 hudson to automate our builds. This works great for Java since we can simply 
 compile ALL 
 the programs using the JAVA compiler in a batch file.
 
 Universe however seems to require us sign into a Universe account and then 
 compile/catalog
 all our programs. Is there a way you can compile all programs in a folder 
 from a batch file?
 We need to do the same to CATALOG all our programs. 
 
 Here's why: 
 
 We submit all of our changes to 1 central SVN repository, when we want to 
 'release' the object code
 to the production server it runs on a different UniVerse region and totally 
 different server, so we 
 have the need to compile all the programs at once in the build, then CATALOG 
 all of the programs
 to the production universe region. 
 
 Is there an easy way to do this?
 
 Right now we have a batch file that logins into our Java webapp, then it logs 
 into universe from 
 the webapp so that it can compile/catalog but there has to be an easier way. 
 
 
 
 ___
 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] easiest way to COMPILE/CATALOG for a build?


Thanks Robert,

That actually worked. There is one issue however. I had to copy my VOC into my 
programing folder for it to work. Our setup is as follows:

c:\CHRIS this is where we keep our DATA tables. (VOC is also kept here)
c:\CHRISSYS   this is where we keep our SOURCE code. 

It would be nice if we could compile without moving the VOC everytime. I'll be 
working some more on this. 

Chris


 From: robert.hou...@fwic.net
 To: u2-users@listserver.u2ug.org
 Date: Wed, 18 Aug 2010 14:01:31 -0700
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 Try running it from the directory where the VOC resides with the 
 C:\IBM\UV\bin directory added to your path.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Wednesday, August 18, 2010 2:00 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
 So it seems like it wants to compile it but can't open the VOC. I'm not sure 
 which VOC it's trying to use (the one c:\Chris
 or the one in c:\IBM\uv\bin). This is what I get from the command line
 
 C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5
 Unable to open 'VOC' file
 
 I have made sure that in the folder security settings that I have full rights 
 to the IBM/*.* and CHRIS/*.* folders.
 
 Any ideas why it would be unable to open the VOC?
 
 
 * on a side note to Doug, we want to keep the compiling very simple without 
 many java scripts. Currently we're using a java
 script but we want to do it on a command line level IF possible.
 
 
 
  From: d.hender...@moreheadstate.edu
  To: u2-users@listserver.u2ug.org
  Date: Wed, 18 Aug 2010 16:45:32 -0400
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
  ...should have clarified that the below command is executed at the OS 
  command prompt.
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org 
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Drew William 
  Henderson
  Sent: Wednesday, August 18, 2010 4:43 PM
  To: U2 Users List
  Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build?
 
  Chris,
 
  Are you on Windows or Unix/Linux?
 
  On the ?nix version, you can execute uv/bin program basic to compile your 
  programs (and assume you can catalog, as well, but never tried it.)  
  Assuming uv/bin is in your PATH, if the folder/directory is SOURCE, and you 
  want to compile the file PROG1, you can use the following command:
 
  basic SOURCE PROG1
 
  Wildcarding may be a problem, but can put multiple files on the command 
  line.  Of course, you could write a quick script to do all this for you, as 
  well.
 
  (DISCLAIMER: We're running 10.2 on Linux, and the above worked your 
  mileage may vary! :-)  )
 
  If you're running Universe on Windows, I can't speak to that!
 
  HTH
  Drew
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org 
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Wednesday, August 18, 2010 4:19 PM
  To: u2-users@listserver.u2ug.org
  Subject: [U2] easiest way to COMPILE/CATALOG for a build?
 
 
  Hello,
 
  We just recently changed our entire repository from Source Safe to SVN and 
  we're now using
  hudson to automate our builds. This works great for Java since we can 
  simply compile ALL
  the programs using the JAVA compiler in a batch file.
 
  Universe however seems to require us sign into a Universe account and then 
  compile/catalog
  all our programs. Is there a way you can compile all programs in a folder 
  from a batch file?
  We need to do the same to CATALOG all our programs.
 
  Here's why:
 
  We submit all of our changes to 1 central SVN repository, when we want to 
  'release' the object code
  to the production server it runs on a different UniVerse region and totally 
  different server, so we
  have the need to compile all the programs at once in the build, then 
  CATALOG all of the programs
  to the production universe region.
 
  Is there an easy way to do this?
 
  Right now we have a batch file that logins into our Java webapp, then it 
  logs into universe from
  the webapp so that it can compile/catalog but there has to be an easier way.
 
 
 
  ___
  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] XLr8 + Subversion

2010-08-04 Thread Chris Austin


I just downloaded the Eclipse XLr8 plug-in and we want to setup Eclipse with 
Subversion. I wasn't sure how to do this, I tried a couple things 
and it didn't seem to work. If someone could steer me down the right direction 
I would really appreciate it. We're using the latest version
of UniVerse as well as a current version of eclipse.
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] problem - Attempted WRITE with record ID larger than file/table maximum

2010-06-09 Thread Chris Austin


We encountered a problem during our nightly batch processing last night and it 
pertains to a specific
record/key. The error that we received in our log is as follows:

--
Program LFBDOPOS: Line 337, Attempted WRITE with record ID larger than 
file/table maximum
record ID size of 255 characters.
Program LFBDOPOS: Line 337, FATAL: Unable to do commit of record 
15500*60431*EJK in file GENACCTRN_POSTED/DATA.30.
Program LFBDOPOS: Line 337, Rolling back uncommitted transactions begun 
within this execution environment.
Attempted WRITE with record ID larger than file/table maximum
record ID size of 255 characters.
--

I checked our MAXKEYSIZE in UniAdmin and it's set to 255. 

I guess my question is why is it saying the ID/primary key is too large if it 
should be - 15500*60431*EJK ?

Also, what do we do to fix this? Any help is appreciated, thanks!


Chris

  
_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum

2010-06-09 Thread Chris Austin

I believe that is the problem, the key for record '15500*60431*EJK' must have
more than 255 characters. Is there
a way to check the # of characters on a key from a telnet prompt? I'm confused
why the key would
be so big? There must be 'historical encoding of record locks' or something
behind the scenes being stored.

Basically it's a record we have in table #1 that we are writing to table #2.
Would there be anything to check
on the record? Thanks.

Date: Wed, 9 Jun 2010 10:34:07 -0400
From: perry.tay...@zirmed.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] problem - Attempted WRITE with record ID larger than
file/table maximum

Make sure there is not an index on that file being updated with a key
255 characters.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, June 09, 2010 8:19 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] problem - Attempted WRITE with record ID larger than
file/table maximum

We encountered a problem during our nightly batch processing last night
and it pertains to a specific
record/key. The error that we received in our log is as follows:

--
Program LFBDOPOS: Line 337, Attempted WRITE with record ID larger than
file/table maximum
record ID size of 255 characters.
Program LFBDOPOS: Line 337, FATAL: Unable to do commit of record
15500*60431*EJK in file GENACCTRN_POSTED/DATA.30.
Program LFBDOPOS: Line 337, Rolling back uncommitted transactions
begun within this execution environment.
Attempted WRITE with record ID larger than file/table maximum
record ID size of 255 characters.
--

I checked our MAXKEYSIZE in UniAdmin and it's set to 255.

I guess my question is why is it saying the ID/primary key is too large
if it should be - 15500*60431*EJK ?

Also, what do we do to fix this? Any help is appreciated, thanks!

Chris

_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars
with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=P
ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is
prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health
Information, any communications containing such material will
be returned to the originating party with such advisement
noted. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccountocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum

2010-06-09 Thread Chris Austin

Yeah that could be it but I just did a restore of last nights pre-cycle data.
An interesting thing I noticed in
regards to the table GENACCTRN (the one we're having issues with) and noticed
the following errors with the index:

Restoring c:\LIVE/I_GENACCTRN/INDEX.005 (19:34:23)
Restoring c:\LIVE/I_GENACCTRN/INDEX.006 (19:34:23)
Unable to write item 9ý3136FJMA6ý912828DC1ý3136FJQU8.
Unable to write item
361448AG8ý362311AH5ý36966RV60ý4165X0MJ6ý4165X0NK3ý44181EW79ý620076AH2ý620076AP4ý925524AQ3ý92923WAA8ý025816BA6ý3136FHSC0ý3136F3R32ý3128X9YC8.
Unable to write item
220905202ý94979B204ý38144X500ý17306N203ý369622519ý46623D200ý95709T704ý59021V839.
Unable to write item
165069AS4ý25271CAK8ý260543BJ1ý50075NAC8ý650094CA1ý3135A1GD3ý3136FHR23ý3136FJME8ý3128X9XG0ý00206RAB8ý035229CT8ý053332AF9ý06550XDM2ý06406JCU7ý219350AS4.
Restoring c:\LIVE/I_GENACCTRN/INDEX.MAP (19:34:23)

'unable to write' to the index. I guess this index will need to be rebuilt?

Date: Wed, 9 Jun 2010 11:24:18 -0400
From: slestak...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] problem - Attempted WRITE with record ID larger than
file/table maximum

On 6/9/2010 10:46 AM, Chris Austin wrote:
I believe that is the problem, the key for record '15500*60431*EJK' must
have more than 255 characters. Is there
a way to check the # of characters on a key from a telnet prompt? I'm
confused why the key would
be so big? There must be 'historical encoding of record locks' or something
behind the scenes being stored.

Basically it's a record we have in table #1 that we are writing to table
#2. Would there be anything to check
on the record? Thanks.

ttp://listserver.u2ug.org/mailman/listinfo/u2-users

I have done this by accident before. If you are getting your key from a
multivalue list and have the wrong delimiter chosen, you will send the
dynamic array as the key and that can be too long.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with
Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] import data to excel sheet...

2010-04-14 Thread Chris Austin

Brian,

I really appreciate the reply. I'm going to spend some time over the weekend on
this.
I'll probably give Tony's product a try first and then go from there.

Thanks!

-Chris

From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Wed, 14 Apr 2010 09:48:48 +0100
Subject: Re: [U2] import data to excel sheet...

Hi Chris

I would investigate Tony's product first - that may well save you a bunch of
work. I'm generating OpenXML from a number of different places - so if your
requirement is for UniVerse only I'd look to Nebula and see if it covers
your needs.

If you do find afterwards that you still want to look at OpenXML, it's
reasonably simple to update and manage but you need to invest some time
understanding the structure. Essentially, it's based on something called
Open Packaging Convention which is a zipped archive under the hood - though
not compatible will all ZIP programs :(. Within that archive, the content is
divided into a number of separate 'parts' all of which link together to
create a document - so a Word document will have separate parts for the main
body, section headers and footers, media elements, embedded pictures etc.

Once you have walked through that maze, the spreadsheet markup is simple as
far as the data content is concerned: there are some gotchas when reading
data (shared strings, for example) but you can generally avoid them all if
you are the one generating it. All the content is separated from the
styling, and held in a simple sheetData element for the chosen worksheet.
Each worksheet is a separate XML doc within the archive.

The difficulty is in adding new styles for formatting, simply because the
format there is very verbose. Your best bet is to create a template, apply
various styles within that template to dummy cells and save it. Then you
have all the styling information ready to use and you can simply apply them
to your cells by adding a style number attribute.

It's worth noting that OpenXML was introduced as the standard format for
Office 2007, but there is a free download from Microsoft called the Office
Compatibility Pack that lets earlier versions of Office read and write in
that format.

I'd recommend the free eBook 'OpenXML Explained' by Wouter van Vugt. IIRC
it's downloadable via www.openxmldeveloper.org.

Brian

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_
Hotmail is redefining busy with tools for the New Busy. Get more from your
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Basic Developers Toolkit - how to create a program?

2010-04-14 Thread Chris Austin


I installed the new UniVerse (10.3.3) and have installed the Basic Developers 
Toolkit from the UniVerse CD and
I'm able to compile and run programs that have already been cataloged. For the 
life of me I cannot figure out how 
to simply create a new UniVerse BASIC program and catalog it from within the 
toolkit. Does anyone know how to do this?

Chris
  
_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] import data to excel sheet...


I was curious if there is an easy way to add font formatting to the .CSV files 
I have been creating from UniVerse.
Right now we just write to a sequential file and call it name.csv and just 
use comma's to separate
the data. We then use a carriage return CHAR(13) to return to the next line in 
the spreadsheet. 

If I wanted to make a word appear as blue or in bold, how are you guys doing 
this?

Thanks.

-Chris


 Date: Mon, 12 Apr 2010 11:47:20 -0700
 From: jacque...@yahoo.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] import data to excel sheet...
 
 Hi Jaweed,
 
 If you already produced a number of files with the CHAR(13) as the end of 
 line separator, you probably still handle them with excel, if you change the 
 file extension from .csv to .txt and when you are in Excel import wizard, 
 specify that the origin of the file is Macintosh.Since the Mac uses 
 CHAR(13) as an EOL separator, the import should work.
 
 
 
 
 
 - Original Message 
 From: Robert Houben robert.hou...@fwic.net
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Mon, April 12, 2010 12:01:03 PM
 Subject: Re: [U2] import data to excel sheet...
 
 Hi Jaweed,
 
 I haven't looked too closely at your code, but I did notice on thing that I 
 would consider the most likely candidate:
 
 CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10) instead 
 for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I 
 think CHAR(10) should do it.
 
 Good luck!
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
 Sent: Monday, April 12, 2010 7:53 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] import data to excel sheet...
 
 Can anyone tell me what is wrong with the following code for importing data
 from txt file to an excel sheet, when its launch
 
 Excel it giving some error message, but when I open the downloaded file from
 my disc, all the data is in one line with some especial
 
 Chars. Any help will be appreciated.
 
 
 
 034: **
 
 035: * OPEN FILES *
 
 036: **
 
 037:   ERRMSG = ''
 
 038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE
 
 039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'
 
 040:   END
 
 041:   IF ERRMSG THEN
 
 042: GOSUB 91000
 
 043: RETURN
 
 044:   END
 
 *--: P
 
 045: **
 
 046: * INITIALIZE *
 
 047: **
 
 048:   PAGE.FEED = CHAR(12)
 
 049:   LINE.FEED = CHAR(13)
 
 050:   ;*
 
 051:   ;* Read the text file to convert
 
 052:   ;*
 
 053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE
 
 054: ERRMSG = ITEM  : TEXT.REC.NAME :  DOES NOT EXIST IN  :
 TEXT.FILE.NA
 
 ME
 
 055: GOSUB 91000
 
 056: RETURN
 
 057:   END
 
 058:   ;*
 
 059:   ;* Set default values (none are used now)
 
 060:   ;*
 
 061:   VALUE = DEFAULT
 
 062:   LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN
 
 063: VALUE = FORMATSTR2,PTR
 
 064:   END
 
 065:   ;*
 
 066:   ;* Remove the first line if it contains a PAGE.FEED
 
 *--: P
 
 067:   ;*
 
 068:   LOOP WHILE TEXT.REC1 = PAGE.FEED DO
 
 069:  TEXT.REC = DELETE(TEXT.REC,1)
 
 070:   REPEAT
 
 071:   IF TEXT.REC1[1,1] = PAGE.FEED THEN
 
 072:  TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)]
 
 073:   END
 
 074:   ;*
 
 075:   ;* Find the header for each page
 
 076:   ;*
 
 077:   SLK.REC = ''
 
 078:   SLK.ROWS = 0
 
 079:   SLK.HEADER.LINES = 0
 
 080:   IF TEXT.REC1[1,10] = RUN D - T: THEN
 
 081: SLK.REC-1 = F;SD;R3
 
 082: SLK.REC-1 = F;SD;R4
 
 083: SLK.REC-1 = C;Y1;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';;
 
 ')))
 
 084: SLK.REC-1 = C;Y2;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC2[1,30],';',';;
 
 ')))
 
 085: SLK.REC-1 = C;Y3;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC1[31,90],';',';
 
 ;')))
 
 086: SLK.REC-1 = C;Y4;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC2[31,90],';',';
 
 ;')))
 
 087: SLK.ROWS = 4
 
 088: SLK.HEADER.LINES = 2
 
 *--: P
 
 089:   END
 
 090:   ;*
 
 091:   ;* Find the number of lines in the header
 
 092:   ;*
 
 093:   LINES = DCOUNT(TEXT.REC,@AM)
 
 094:   SLK.HEADER.CNT = 0
 
 095:   FOR IDX = SLK.HEADER.LINES+1 TO LINES
 
 096: IF INDEX(TEXT.RECIDX,---,1) THEN
 
 097:   SLK.HEADER.CNT = IDX
 
 098:   EXIT
 
 099: END
 
 100:   NEXT IDX
 
 101:   ;*
 
 102:   ;* Find the column locations
 
 103:   ;*
 
 104:   COL.LIST  = ''
 
 105:   IF SLK.HEADER.CNT THEN
 
 106: DASHES.LINE =   : TEXT.RECSLK.HEADER.CNT :  
 
 107: DASHES.LINE = TRIM(DASHES.LINE,'-')
 
 108: DASHES.CNT  = COUNT(DASHES.LINE,'-')
 
 109: DASHES.LINE = TEXT.RECSLK.HEADER.CNT
 
 110: FOR DASHES.IDX = 1 TO DASHES.CNT
 
 *--: P
 
 111:   COL.START = INDEX(DASHES.LINE,'-',1)
 
 112:   DASHES.REMAIN = LEN(DASHES.LINE) - COL.START + 1
 
 113:   COL.LEN   = INDEX(DASHES.LINE[DASHES.REMAIN],' ',1)-1
 
 114:   IF COL.LEN  1 THEN COL.LEN = LEN(DASHES.LINE)
 
 115:   COL.LISTDASHES.IDX,1 = COL.START

Re: [U2] import data to excel sheet...


Brian,

I was curious if you had an example of how you can setup your spreadsheet 
directly from UniVerse by treating the content as XML? 

Are you physically writing to a .XLS type file from universe but in an XML 
format?

Also, I wouldn't mind looking into OpenXML, that sounds like it may be very 
useful for our needs here. I appreciate the response. 

-Chris




 From: br...@brianleach.co.uk
 To: u2-users@listserver.u2ug.org
 Date: Tue, 13 Apr 2010 16:44:31 +0100
 Subject: Re: [U2] import data to excel sheet...
 
 Chris
 
 I'm using OpenXML to create spreadsheets in Excel 2007 format: and writing a
 series in Spectrum about it. You can create the spreadsheets directly from
 UniVerse by treating the content as XML (with a number of caveats) or you
 can call out to something external that will build it using the OpenXML SDK
 2.0 or an equivalent toolkit.
 
 Brian
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: 13 April 2010 3:48 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] import data to excel sheet...
 
 
 I was curious if there is an easy way to add font formatting to the .CSV
 files I have been creating from UniVerse.
 Right now we just write to a sequential file and call it name.csv and just
 use comma's to separate
 the data. We then use a carriage return CHAR(13) to return to the next line
 in the spreadsheet. 
 
 If I wanted to make a word appear as blue or in bold, how are you guys doing
 this?
 
 Thanks.
 
 -Chris
 
 
  Date: Mon, 12 Apr 2010 11:47:20 -0700
  From: jacque...@yahoo.com
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] import data to excel sheet...
  
  Hi Jaweed,
  
  If you already produced a number of files with the CHAR(13) as the end of
 line separator, you probably still handle them with excel, if you change the
 file extension from .csv to .txt and when you are in Excel import wizard,
 specify that the origin of the file is Macintosh.Since the Mac uses
 CHAR(13) as an EOL separator, the import should work.
  
  
  
  
  
  - Original Message 
  From: Robert Houben robert.hou...@fwic.net
  To: U2 Users List u2-users@listserver.u2ug.org
  Sent: Mon, April 12, 2010 12:01:03 PM
  Subject: Re: [U2] import data to excel sheet...
  
  Hi Jaweed,
  
  I haven't looked too closely at your code, but I did notice on thing that
 I would consider the most likely candidate:
  
  CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10)
 instead for your LINE.FEED variable. You might have to use
 CHAR(13):CHAR(10), but I think CHAR(10) should do it.
  
  Good luck!
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
  Sent: Monday, April 12, 2010 7:53 AM
  To: u2-users@listserver.u2ug.org
  Subject: [U2] import data to excel sheet...
  
  Can anyone tell me what is wrong with the following code for importing
 data
  from txt file to an excel sheet, when its launch
  
  Excel it giving some error message, but when I open the downloaded file
 from
  my disc, all the data is in one line with some especial
  
  Chars. Any help will be appreciated.
  
  
  
  034: **
  
  035: * OPEN FILES *
  
  036: **
  
  037:   ERRMSG = ''
  
  038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE
  
  039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'
  
  040:   END
  
  041:   IF ERRMSG THEN
  
  042: GOSUB 91000
  
  043: RETURN
  
  044:   END
  
  *--: P
  
  045: **
  
  046: * INITIALIZE *
  
  047: **
  
  048:   PAGE.FEED = CHAR(12)
  
  049:   LINE.FEED = CHAR(13)
  
  050:   ;*
  
  051:   ;* Read the text file to convert
  
  052:   ;*
  
  053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE
  
  054: ERRMSG = ITEM  : TEXT.REC.NAME :  DOES NOT EXIST IN  :
  TEXT.FILE.NA
  
  ME
  
  055: GOSUB 91000
  
  056: RETURN
  
  057:   END
  
  058:   ;*
  
  059:   ;* Set default values (none are used now)
  
  060:   ;*
  
  061:   VALUE = DEFAULT
  
  062:   LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN
  
  063: VALUE = FORMATSTR2,PTR
  
  064:   END
  
  065:   ;*
  
  066:   ;* Remove the first line if it contains a PAGE.FEED
  
  *--: P
  
  067:   ;*
  
  068:   LOOP WHILE TEXT.REC1 = PAGE.FEED DO
  
  069:  TEXT.REC = DELETE(TEXT.REC,1)
  
  070:   REPEAT
  
  071:   IF TEXT.REC1[1,1] = PAGE.FEED THEN
  
  072:  TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)]
  
  073:   END
  
  074:   ;*
  
  075:   ;* Find the header for each page
  
  076:   ;*
  
  077:   SLK.REC = ''
  
  078:   SLK.ROWS = 0
  
  079:   SLK.HEADER.LINES = 0
  
  080:   IF TEXT.REC1[1,10] = RUN D - T: THEN
  
  081: SLK.REC-1 = F;SD;R3
  
  082: SLK.REC-1 = F;SD;R4
  
  083: SLK.REC-1 = C;Y1;X1;K :
  QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';;
  
  ')))
  
  084: SLK.REC-1 = C;Y2;X1;K

Re: [U2] import data to excel sheet...


Gerorge, 

Thanks a ton! I think I will try to get OpenXML working now that I see how the 
XML documents
are built up and make up the spreadsheet. It just seems very tedious to 
manually create the XML
files. Now as far as getting OpenXML to work with universe, is there any 
documentation out there
for that? 

I know Brian mentioned he was writing an article, I would be very inclined to 
read it. 

-Chris


 From: ggal...@wyanokegroup.com
 To: u2-users@listserver.u2ug.org
 Date: Tue, 13 Apr 2010 10:47:58 -0500
 Subject: Re: [U2] import data to excel sheet...
 
 also see:
 
 http://blogs.msdn.com/brian_jones/archive/2005/06/27/433152.aspx
 
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Brian Leach
  Sent: Tuesday, April 13, 2010 11:45 AM
  To: 'U2 Users List'
  Subject: Re: [U2] import data to excel sheet...
  
  Chris
  
  I'm using OpenXML to create spreadsheets in Excel 2007 format: and
  writing a
  series in Spectrum about it. You can create the spreadsheets directly
  from
  UniVerse by treating the content as XML (with a number of caveats) or
  you
  can call out to something external that will build it using the OpenXML
  SDK
  2.0 or an equivalent toolkit.
  
  Brian
  
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: 13 April 2010 3:48 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] import data to excel sheet...
  
  
  I was curious if there is an easy way to add font formatting to the
  .CSV
  files I have been creating from UniVerse.
  Right now we just write to a sequential file and call it name.csv and
  just
  use comma's to separate
  the data. We then use a carriage return CHAR(13) to return to the next
  line
  in the spreadsheet.
  
  If I wanted to make a word appear as blue or in bold, how are you guys
  doing
  this?
  
  Thanks.
  
  -Chris
  
  
   Date: Mon, 12 Apr 2010 11:47:20 -0700
   From: jacque...@yahoo.com
   To: u2-users@listserver.u2ug.org
   Subject: Re: [U2] import data to excel sheet...
  
   Hi Jaweed,
  
   If you already produced a number of files with the CHAR(13) as the
  end of
  line separator, you probably still handle them with excel, if you
  change the
  file extension from .csv to .txt and when you are in Excel import
  wizard,
  specify that the origin of the file is Macintosh.Since the Mac
  uses
  CHAR(13) as an EOL separator, the import should work.
  
  
  
  
  
   - Original Message 
   From: Robert Houben robert.hou...@fwic.net
   To: U2 Users List u2-users@listserver.u2ug.org
   Sent: Mon, April 12, 2010 12:01:03 PM
   Subject: Re: [U2] import data to excel sheet...
  
   Hi Jaweed,
  
   I haven't looked too closely at your code, but I did notice on thing
  that
  I would consider the most likely candidate:
  
   CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10)
  instead for your LINE.FEED variable. You might have to use
  CHAR(13):CHAR(10), but I think CHAR(10) should do it.
  
   Good luck!
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
   Sent: Monday, April 12, 2010 7:53 AM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] import data to excel sheet...
  
   Can anyone tell me what is wrong with the following code for
  importing
  data
   from txt file to an excel sheet, when its launch
  
   Excel it giving some error message, but when I open the downloaded
  file
  from
   my disc, all the data is in one line with some especial
  
   Chars. Any help will be appreciated.
  
  
  
   034: **
  
   035: * OPEN FILES *
  
   036: **
  
   037:   ERRMSG = ''
  
   038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE
  
   039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'
  
   040:   END
  
   041:   IF ERRMSG THEN
  
   042: GOSUB 91000
  
   043: RETURN
  
   044:   END
  
   *--: P
  
   045: **
  
   046: * INITIALIZE *
  
   047: **
  
   048:   PAGE.FEED = CHAR(12)
  
   049:   LINE.FEED = CHAR(13)
  
   050:   ;*
  
   051:   ;* Read the text file to convert
  
   052:   ;*
  
   053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE
  
   054: ERRMSG = ITEM  : TEXT.REC.NAME :  DOES NOT EXIST IN  :
   TEXT.FILE.NA
  
   ME
  
   055: GOSUB 91000
  
   056: RETURN
  
   057:   END
  
   058:   ;*
  
   059:   ;* Set default values (none are used now)
  
   060:   ;*
  
   061:   VALUE = DEFAULT
  
   062:   LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN
  
   063: VALUE = FORMATSTR2,PTR
  
   064:   END
  
   065:   ;*
  
   066:   ;* Remove the first line if it contains a PAGE.FEED
  
   *--: P
  
   067:   ;*
  
   068:   LOOP WHILE TEXT.REC1 = PAGE.FEED DO
  
   069:  TEXT.REC = DELETE(TEXT.REC,1)
  
   070:   REPEAT

Re: [U2] import data to excel sheet...

That program actually seems perfect for what I'm looking to do Bill. Do you guys
use this at your work? Is it a decent product?

-Chris

 Date: Tue, 13 Apr 2010 09:11:25 -0700
 From: wphask...@advantos.net
 To: U2-users@listserver.u2ug.org
 Subject: Re: [U2] import data to excel sheet...

 Chris:

 You may want to simplify your life and pick up NebulaXLite.

 http://nebula-rnd.com/products/xlite.htm

 HTH,

 Bill

  Chris Austin said the following on 4/13/2010 7:48 AM:
  I was curious if there is an easy way to add font formatting to the .CSV 
  files I have been creating from UniVerse.
  Right now we just write to a sequential file and call it name.csv and 
  just use comma's to separate
  the data. We then use a carriage return CHAR(13) to return to the next 
  line in the spreadsheet. 

  If I wanted to make a word appear as blue or in bold, how are you guys 
  doing this?

  Thanks.

  -Chris

  Date: Mon, 12 Apr 2010 11:47:20 -0700
  From: jacque...@yahoo.com
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] import data to excel sheet...

  Hi Jaweed,

  If you already produced a number of files with the CHAR(13) as the end of 
  line separator, you probably still handle them with excel, if you change 
  the file extension from .csv to .txt and when you are in Excel import 
  wizard, specify that the origin of the file is Macintosh.Since the 
  Mac uses CHAR(13) as an EOL separator, the import should work.

  - Original Message 
  From: Robert Houben robert.hou...@fwic.net
  To: U2 Users List u2-users@listserver.u2ug.org
  Sent: Mon, April 12, 2010 12:01:03 PM
  Subject: Re: [U2] import data to excel sheet...

  Hi Jaweed,

  I haven't looked too closely at your code, but I did notice on thing that 
  I would consider the most likely candidate:

  CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10) 
  instead for your LINE.FEED variable. You might have to use 
  CHAR(13):CHAR(10), but I think CHAR(10) should do it.

  Good luck!

  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org 
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
  Sent: Monday, April 12, 2010 7:53 AM
  To: u2-users@listserver.u2ug.org
  Subject: [U2] import data to excel sheet...

  Can anyone tell me what is wrong with the following code for importing 
  data
  from txt file to an excel sheet, when its launch

  Excel it giving some error message, but when I open the downloaded file 
  from
  my disc, all the data is in one line with some especial

  Chars. Any help will be appreciated.

  034: **

  035: * OPEN FILES *

  036: **

  037:   ERRMSG = ''

  038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE

  039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'

  040:   END

  041:   IF ERRMSG THEN

  042: GOSUB 91000

  043: RETURN

  044:   END

  *--: P

  045: **

  046: * INITIALIZE *

  047: **

  048:   PAGE.FEED = CHAR(12)

  049:   LINE.FEED = CHAR(13)

  050:   ;*

  051:   ;* Read the text file to convert

  052:   ;*

  053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE

  054: ERRMSG = ITEM  : TEXT.REC.NAME :  DOES NOT EXIST IN  :
  TEXT.FILE.NA

  ME

  055: GOSUB 91000

  056: RETURN

  057:   END

  058:   ;*

  059:   ;* Set default values (none are used now)

  060:   ;*

  061:   VALUE = DEFAULT

  062:   LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN

  063: VALUE = FORMATSTR2,PTR

  064:   END

  065:   ;*

  066:   ;* Remove the first line if it contains a PAGE.FEED

  *--: P

  067:   ;*

  068:   LOOP WHILE TEXT.REC1 = PAGE.FEED DO

  069:  TEXT.REC = DELETE(TEXT.REC,1)

  070:   REPEAT

  071:   IF TEXT.REC1[1,1] = PAGE.FEED THEN

  072:  TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)]

  073:   END

  074:   ;*

  075:   ;* Find the header for each page

  076:   ;*

  077:   SLK.REC = ''

  078:   SLK.ROWS = 0

  079:   SLK.HEADER.LINES = 0

  080:   IF TEXT.REC1[1,10] = RUN D - T: THEN

  081: SLK.REC-1 = F;SD;R3

  082: SLK.REC-1 = F;SD;R4

  083: SLK.REC-1 = C;Y1;X1;K :
  QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';;

  ')))

  084: SLK.REC-1 = C;Y2;X1;K :
  QUOTE(TRIM(CHANGE(TEXT.REC2[1,30],';',';;

  ')))

  085: SLK.REC-1 = C;Y3;X1;K :
  QUOTE(TRIM(CHANGE(TEXT.REC1[31,90],';',';

  ;')))

  086: SLK.REC-1 = C;Y4;X1;K :
  QUOTE(TRIM(CHANGE(TEXT.REC2[31,90],';',';

  ;')))

  087: SLK.ROWS = 4

  088: SLK.HEADER.LINES = 2

  *--: P

  089:   END

  090:   ;*

  091:   ;* Find the number of lines in the header

  092:   ;*

  093:   LINES = DCOUNT(TEXT.REC,@AM)

  094:   SLK.HEADER.CNT = 0

  095:   FOR IDX = SLK.HEADER.LINES+1 TO LINES

  096: IF INDEX(TEXT.RECIDX,---,1) THEN

  097:   SLK.HEADER.CNT = IDX

  098:   EXIT

Re: [U2] import data to excel sheet...

2010-04-12 Thread Chris Austin


CSV.FILE.NAME = 'c:\path\testCSV.csv'
OPENSEQ CSV.FILE.NAME TO CSV.FILE THEN WEOFSEQ CSV.FILE
CSV.REC := 'data1, data2, data3':CHAR(13)
WRITESEQ CSV.REC TO CSV.FILE THEN NULL

The above is a really easy way to write to a CSV file. Maybe you want to get a 
simple read from the txt and
write to the CSV going and add in the other layers as you go.




 From: robert.hou...@fwic.net
 To: u2-users@listserver.u2ug.org
 Date: Mon, 12 Apr 2010 09:01:03 -0700
 Subject: Re: [U2] import data to excel sheet...
 
 Hi Jaweed,
 
 I haven't looked too closely at your code, but I did notice on thing that I 
 would consider the most likely candidate:
 
 CHAR(13) is a carriage return, not a line feed.  Try using CHAR(10) instead 
 for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I 
 think CHAR(10) should do it.
 
 Good luck!
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
 Sent: Monday, April 12, 2010 7:53 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] import data to excel sheet...
 
 Can anyone tell me what is wrong with the following code for importing data
 from txt file to an excel sheet, when its launch
 
 Excel it giving some error message, but when I open the downloaded file from
 my disc, all the data is in one line with some especial
 
 Chars. Any help will be appreciated.
 
 
 
 034: **
 
 035: * OPEN FILES *
 
 036: **
 
 037:   ERRMSG = ''
 
 038:   OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE
 
 039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!'
 
 040:   END
 
 041:   IF ERRMSG THEN
 
 042: GOSUB 91000
 
 043: RETURN
 
 044:   END
 
 *--: P
 
 045: **
 
 046: * INITIALIZE *
 
 047: **
 
 048:   PAGE.FEED = CHAR(12)
 
 049:   LINE.FEED = CHAR(13)
 
 050:   ;*
 
 051:   ;* Read the text file to convert
 
 052:   ;*
 
 053:   READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE
 
 054: ERRMSG = ITEM  : TEXT.REC.NAME :  DOES NOT EXIST IN  :
 TEXT.FILE.NA
 
 ME
 
 055: GOSUB 91000
 
 056: RETURN
 
 057:   END
 
 058:   ;*
 
 059:   ;* Set default values (none are used now)
 
 060:   ;*
 
 061:   VALUE = DEFAULT
 
 062:   LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN
 
 063: VALUE = FORMATSTR2,PTR
 
 064:   END
 
 065:   ;*
 
 066:   ;* Remove the first line if it contains a PAGE.FEED
 
 *--: P
 
 067:   ;*
 
 068:   LOOP WHILE TEXT.REC1 = PAGE.FEED DO
 
 069:  TEXT.REC = DELETE(TEXT.REC,1)
 
 070:   REPEAT
 
 071:   IF TEXT.REC1[1,1] = PAGE.FEED THEN
 
 072:  TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)]
 
 073:   END
 
 074:   ;*
 
 075:   ;* Find the header for each page
 
 076:   ;*
 
 077:   SLK.REC = ''
 
 078:   SLK.ROWS = 0
 
 079:   SLK.HEADER.LINES = 0
 
 080:   IF TEXT.REC1[1,10] = RUN D - T: THEN
 
 081: SLK.REC-1 = F;SD;R3
 
 082: SLK.REC-1 = F;SD;R4
 
 083: SLK.REC-1 = C;Y1;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';;
 
 ')))
 
 084: SLK.REC-1 = C;Y2;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC2[1,30],';',';;
 
 ')))
 
 085: SLK.REC-1 = C;Y3;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC1[31,90],';',';
 
 ;')))
 
 086: SLK.REC-1 = C;Y4;X1;K :
 QUOTE(TRIM(CHANGE(TEXT.REC2[31,90],';',';
 
 ;')))
 
 087: SLK.ROWS = 4
 
 088: SLK.HEADER.LINES = 2
 
 *--: P
 
 089:   END
 
 090:   ;*
 
 091:   ;* Find the number of lines in the header
 
 092:   ;*
 
 093:   LINES = DCOUNT(TEXT.REC,@AM)
 
 094:   SLK.HEADER.CNT = 0
 
 095:   FOR IDX = SLK.HEADER.LINES+1 TO LINES
 
 096: IF INDEX(TEXT.RECIDX,---,1) THEN
 
 097:   SLK.HEADER.CNT = IDX
 
 098:   EXIT
 
 099: END
 
 100:   NEXT IDX
 
 101:   ;*
 
 102:   ;* Find the column locations
 
 103:   ;*
 
 104:   COL.LIST  = ''
 
 105:   IF SLK.HEADER.CNT THEN
 
 106: DASHES.LINE =   : TEXT.RECSLK.HEADER.CNT :  
 
 107: DASHES.LINE = TRIM(DASHES.LINE,'-')
 
 108: DASHES.CNT  = COUNT(DASHES.LINE,'-')
 
 109: DASHES.LINE = TEXT.RECSLK.HEADER.CNT
 
 110: FOR DASHES.IDX = 1 TO DASHES.CNT
 
 *--: P
 
 111:   COL.START = INDEX(DASHES.LINE,'-',1)
 
 112:   DASHES.REMAIN = LEN(DASHES.LINE) - COL.START + 1
 
 113:   COL.LEN   = INDEX(DASHES.LINE[DASHES.REMAIN],' ',1)-1
 
 114:   IF COL.LEN  1 THEN COL.LEN = LEN(DASHES.LINE)
 
 115:   COL.LISTDASHES.IDX,1 = COL.START
 
 116:   COL.LISTDASHES.IDX,2 = COL.LEN
 
 117:   DASHES.LINE[COL.START,COL.LEN] = SPACE(COL.LEN)
 
 118: NEXT DASHES.IDX
 
 119:   END
 
 120:   ;*
 
 121:   ;* Extract the column titles
 
 122:   ;*
 
 123:   COL.CNT = DCOUNT(COL.LIST,@AM)
 
 124:   FOR HDR.IDX = SLK.HEADER.LINES+1 TO SLK.HEADER.CNT-1
 
 125: SLK.ROWS = SLK.ROWS + 1
 
 126: SLK.Y = Y : SLK.ROWS : ;
 
 127: ;*
 
 128: ;* Make sure the header properly fits into the column
 
 129: ;* If it does not, then add it to the spreadsheet's first column
 
 130: ;*
 
 131: CHECK.LINE = TEXT.RECHDR.IDX
 
 132: GOSUB CHECK.COLUMNS
 
 *--: P
 
 133:

Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture

2010-04-08 Thread Chris Austin


We're also using Apache Tomcat 6 w/ a Java Servlet. 

The front end has Java 1.6, hibernate (writing to PICK), ajax, and html.

The back end is done in UniVerse BASIC which we use for our reports and 
database. 

It's basically one medium size web application. 


-Chris



 Date: Thu, 8 Apr 2010 17:47:20 -0500
 From: j...@powellclan.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture
 
 Hi Baker,
 
 We're doing a lot of java through web services and servlets. Mostly with 
 Tomcat and Glassfish.
 
 Several servlets for reports and inquiries.
 Several java user interfaces that utilize web services that connect to 
 UD for wireless picking, tag and label printing.
 
 HTH
 
 Jeff
 
 On 04/08/2010 12:16 PM, Baker Hughes wrote:
  Would those of you mind responding that use 3-Tier or N-Tier architecture - 
  I'm trying to gather some quick numbers for some decision makers (somewhat 
  urgent).
 
  Please respond if your site, or sites who you service have UniData, 
  UniVerse, or any other MV db on the backend, and any fully graphical user 
  interface:
 
  a.  How many have a middle-tier application server?
  b.  How many use IBM Websphere?
  c.  How many use some other? Please give product name if you can.
  d.  How many have a Java front end User Interface?
  e.  How many have a C# front end User Interface?
  f.  How many have other UI? Please give name.
 
  For anyone - what Multi-Value aware / friendly middleware products are 
  there?  (That don't require data normalization before sending to the 
  middleware.)
 
  Thank you so much,
  -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
  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
  
_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with 
Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] 2 servers - how do I point to a VOC on another server?


Our configuration is like this:


Server A (Windows Server 2003, 32-bit) - the host server with programs.
Server B (Windows Server 2008, 64-bit) - the production server, need to point 
to Server A only for a cpl programs. 

I've never setup an NFS but what we're doing is really basic, we have 3 
accounts with corresponding folders
on Server A and 1 account with 1 folder on Server B. 

Does anyone know how to setup a NFS in Windows? Or do we just need the ALLOWNFS 
setting + UVnet?




 From: ggal...@wyanokegroup.com
 To: u2-users@listserver.u2ug.org
 Date: Wed, 31 Mar 2010 08:56:19 -0500
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?
 
 you didn't say what the O/S of the systems are.
 
 If you are running unix on both machines, you need to setup
 one machine as an NFS server, and the other as an NFS Client.
 
 Both are fairly simple.
 
 basically, you are updating /etc/fstab for the Client side
 and /etc/exports , /etc/hosts.allow (nfs/nfsd and portmap)
 and run the command exportfs
 
 do a google on NFS setup, and it should explain how to configure
 and use the above files/commands
 
 If your on a Windows platform.I don't have a clue how to 
 setup NFS on them.
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Tuesday, March 30, 2010 5:56 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
  
  Thanks for the reply John. Is there anything we need to setup to
  achieve an
  NFS mount? The only configuration change we made thus far was setting
  ALLOWNFS to 1.
  
  An example of a VOC entry on the OLD SERVER is as follows:
  
  LIVECT VOC TEST_HARNESS2
  
   TEST_HARNESS2
  0001 V *PJC* ELEVATED FROM CHRIS PROJECT 2487 ON 11:25:11 01 SEP 2009
  0002 ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2
  0003 B
  0004 BNP
  0005
  0006 PICK.FORMAT
  0007 S²N²P²I²A²E²H
  0008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP
  0009 ..\CHRISSYS\LFUTILS.O
  
  I'm confused what 'mnt' would be in your notes? If you could clarify
  what our VOC should
  be I can then test this out. I really appreciate the help! Thanks.
  
  -Chris
  
  
   Date: Tue, 30 Mar 2010 14:44:02 -0700
   From: jhes...@momtex.com
   To: u2-users@listserver.u2ug.org
   Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
   If I'm understanding correctly, you want to run a program that
   physically resides on the old server against data on the new server.
  I
   haven't done this myself, but I don't see any reason why you couldn't
   run or catalog a program that sits on an NFS mount from another
  server.
   The VOC for the remote file might look something like this:
  
   BP.OLD
  
   001: F
   002: /mnt/nfs/old_server/BP
   003: /mnt/nfs/old_server/D_BP
  
   and you'll also need the corresponding object file:
  
   BP.OLD.O
  
   001: F
   002: /mnt/nfs/old_server/BP.O
   003: /mnt/nfs/old_server/D_BP.O
  
   Then you should be able to RUN BP.OLD PROGRAMNAME or CATALOG BP.OLD
   PROGRAMNAME to have its VOC entry replace one that points to the
  local
   copy of the program.
  
   -John
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org
   [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
  Austin
   Sent: Tuesday, March 30, 2010 2:31 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] 2 servers - how do I point to a VOC on another server?
  
  
   Hello,
  
   We're running UniVerse 10.1.8 on our main server and we just bought
   another
   server with UniVerse 10.3.3. I would like to setup the old server as
  the
   development
   server and keep the new server as the production server. The problem
  is
   we want to elevate some programs to the new server. Ideally we
  would
   just
   point the VOC to the old server until we fully test the programs. We
   have set
   ALLOWNFS to 1 as well. What is involved for us to run a file and
  setup a
   voc to
   point to a completely different server?
  
   Example) program A is on server 1, but we want the changes to reflect
  on
   server 2.
  
   What we have been doing in the past is editing the VOC from one
  account
   to the other, but
   I'm not sure how to do this on another server.
  
   Thanks.
   ___
   U2-Users mailing list
   U2-Users@listserver.u2ug.org
   http://listserver.u2ug.org/mailman/listinfo/u2-users
  
  _
  Hotmail has tools for the New Busy. Search, chat and e-mail from your
  inbox.
  http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL
  :ON:WL:en-US:WM_HMP:032010_1
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2

Re: [U2] 2 servers - how do I point to a VOC on another server?


We can map the drives from one server to the other. Let's call the drive on 
Server A drive (Z:\). 
I assume we would still need UVnet to do this solution. If we did map a drive 
what would the VOC
pointer look like?

This is an example what one of my VOC pointers looks like now:

..\CHRISSYS\LFUTILS.O/TEST_HARNESS2

If we wanted to map this to serverA, using drive Z how would the pointer look?



 From: ggal...@wyanokegroup.com
 To: u2-users@listserver.u2ug.org
 Date: Wed, 31 Mar 2010 09:53:57 -0500
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?
 
 Since your running windows, Can you map a drive to the other servers Folder 
 containing the programs.
 
 Then just setup a VOC entry pointing to the mapped drive.
 
 Don't use NFS, just use windows SMB protocols. As long as
 they are both setup with workgroup names the same you should
 be ok.
 
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Wednesday, March 31, 2010 10:51 AM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
  
  Our configuration is like this:
  
  
  Server A (Windows Server 2003, 32-bit) - the host server with
  programs.
  Server B (Windows Server 2008, 64-bit) - the production server, need to
  point to Server A only for a cpl programs.
  
  I've never setup an NFS but what we're doing is really basic, we have 3
  accounts with corresponding folders
  on Server A and 1 account with 1 folder on Server B.
  
  Does anyone know how to setup a NFS in Windows? Or do we just need the
  ALLOWNFS setting + UVnet?
  
  
  
  
   From: ggal...@wyanokegroup.com
   To: u2-users@listserver.u2ug.org
   Date: Wed, 31 Mar 2010 08:56:19 -0500
   Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
   you didn't say what the O/S of the systems are.
  
   If you are running unix on both machines, you need to setup
   one machine as an NFS server, and the other as an NFS Client.
  
   Both are fairly simple.
  
   basically, you are updating /etc/fstab for the Client side
   and /etc/exports , /etc/hosts.allow (nfs/nfsd and portmap)
   and run the command exportfs
  
   do a google on NFS setup, and it should explain how to configure
   and use the above files/commands
  
   If your on a Windows platform.I don't have a clue how to
   setup NFS on them.
  
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, March 30, 2010 5:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 2 servers - how do I point to a VOC on another
server?
   
   
Thanks for the reply John. Is there anything we need to setup to
achieve an
NFS mount? The only configuration change we made thus far was
  setting
ALLOWNFS to 1.
   
An example of a VOC entry on the OLD SERVER is as follows:
   
LIVECT VOC TEST_HARNESS2
   
 TEST_HARNESS2
0001 V *PJC* ELEVATED FROM CHRIS PROJECT 2487 ON 11:25:11 01 SEP
  2009
0002 ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2
0003 B
0004 BNP
0005
0006 PICK.FORMAT
0007 S²N²P²I²A²E²H
0008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP
0009 ..\CHRISSYS\LFUTILS.O
   
I'm confused what 'mnt' would be in your notes? If you could
  clarify
what our VOC should
be I can then test this out. I really appreciate the help! Thanks.
   
-Chris
   
   
 Date: Tue, 30 Mar 2010 14:44:02 -0700
 From: jhes...@momtex.com
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another
server?

 If I'm understanding correctly, you want to run a program that
 physically resides on the old server against data on the new
  server.
I
 haven't done this myself, but I don't see any reason why you
  couldn't
 run or catalog a program that sits on an NFS mount from another
server.
 The VOC for the remote file might look something like this:

 BP.OLD

 001: F
 002: /mnt/nfs/old_server/BP
 003: /mnt/nfs/old_server/D_BP

 and you'll also need the corresponding object file:

 BP.OLD.O

 001: F
 002: /mnt/nfs/old_server/BP.O
 003: /mnt/nfs/old_server/D_BP.O

 Then you should be able to RUN BP.OLD PROGRAMNAME or CATALOG
  BP.OLD
 PROGRAMNAME to have its VOC entry replace one that points to the
local
 copy of the program.

 -John

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris
Austin
 Sent: Tuesday, March 30, 2010 2:31 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] 2 servers - how do I point to a VOC on another
  server?


 Hello,

 We're

Re: [U2] 2 servers - how do I point to a VOC on another server?


One more thing I wanted to add. We're trying to access the object code from one 
server
on another. I assume this can be done but I wanted to clarify what our goals 
were.

Server A (has object code) - Server B (wants to run Server A object code)

I also found the UV/NET II guide and it says this:

I-Descriptors and UniVerse BASIC Object Code
UV/Net II gives users read and write access to files on remote systems. 
However, you
cannot execute I-descriptors and UniVerse BASIC object code located on remote
systems.

Does that mean you can't access object code at all from one server to the 
other??

Or are they saying if you're using an I-Descriptor? Thanks.



 From: cjausti...@hotmail.com
 To: u2-users@listserver.u2ug.org
 Date: Wed, 31 Mar 2010 10:07:03 -0500
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?
 
 
 We can map the drives from one server to the other. Let's call the drive on 
 Server A drive (Z:\). 
 I assume we would still need UVnet to do this solution. If we did map a drive 
 what would the VOC
 pointer look like?
 
 This is an example what one of my VOC pointers looks like now:
 
 ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2
 
 If we wanted to map this to serverA, using drive Z how would the pointer look?
 
 
 
  From: ggal...@wyanokegroup.com
  To: u2-users@listserver.u2ug.org
  Date: Wed, 31 Mar 2010 09:53:57 -0500
  Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?
  
  Since your running windows, Can you map a drive to the other servers Folder 
  containing the programs.
  
  Then just setup a VOC entry pointing to the mapped drive.
  
  Don't use NFS, just use windows SMB protocols. As long as
  they are both setup with workgroup names the same you should
  be ok.
  
  
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
   boun...@listserver.u2ug.org] On Behalf Of Chris Austin
   Sent: Wednesday, March 31, 2010 10:51 AM
   To: u2-users@listserver.u2ug.org
   Subject: Re: [U2] 2 servers - how do I point to a VOC on another
   server?
   
   
   Our configuration is like this:
   
   
   Server A (Windows Server 2003, 32-bit) - the host server with
   programs.
   Server B (Windows Server 2008, 64-bit) - the production server, need to
   point to Server A only for a cpl programs.
   
   I've never setup an NFS but what we're doing is really basic, we have 3
   accounts with corresponding folders
   on Server A and 1 account with 1 folder on Server B.
   
   Does anyone know how to setup a NFS in Windows? Or do we just need the
   ALLOWNFS setting + UVnet?
   
   
   
   
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 31 Mar 2010 08:56:19 -0500
Subject: Re: [U2] 2 servers - how do I point to a VOC on another
   server?
   
you didn't say what the O/S of the systems are.
   
If you are running unix on both machines, you need to setup
one machine as an NFS server, and the other as an NFS Client.
   
Both are fairly simple.
   
basically, you are updating /etc/fstab for the Client side
and /etc/exports , /etc/hosts.allow (nfs/nfsd and portmap)
and run the command exportfs
   
do a google on NFS setup, and it should explain how to configure
and use the above files/commands
   
If your on a Windows platform.I don't have a clue how to
setup NFS on them.
   
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Tuesday, March 30, 2010 5:56 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another
 server?


 Thanks for the reply John. Is there anything we need to setup to
 achieve an
 NFS mount? The only configuration change we made thus far was
   setting
 ALLOWNFS to 1.

 An example of a VOC entry on the OLD SERVER is as follows:

 LIVECT VOC TEST_HARNESS2

  TEST_HARNESS2
 0001 V *PJC* ELEVATED FROM CHRIS PROJECT 2487 ON 11:25:11 01 SEP
   2009
 0002 ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2
 0003 B
 0004 BNP
 0005
 0006 PICK.FORMAT
 0007 S²N²P²I²A²E²H
 0008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP
 0009 ..\CHRISSYS\LFUTILS.O

 I'm confused what 'mnt' would be in your notes? If you could
   clarify
 what our VOC should
 be I can then test this out. I really appreciate the help! Thanks.

 -Chris


  Date: Tue, 30 Mar 2010 14:44:02 -0700
  From: jhes...@momtex.com
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] 2 servers - how do I point to a VOC on another
 server?
 
  If I'm understanding correctly, you want to run a program that
  physically resides on the old server against data on the new
   server.
 I
  haven't done this myself, but I don't see any reason why you
   couldn't
  run

Re: [U2] 2 servers - how do I point to a VOC on another server?


I setup a mapped drive drive on ServerA and i called it S:\ which maps to my 
CHRISSYS (programming directory)

and I then changed the VOC from:

..\CHRISSYS\LFUTILS.O/TEST_HARNESS3

to

S:LFUTILS.O/TEST_HARNESS2 

and

S:\LFUTILS.O/TEST_HARNESS2

with no luck. I get this back from telnet:

LIVETEST_HARNESS2
Unable to open the operating system file S:\LFUTILS.O/TEST_HARNESS2.
[ENOENT] No such file or directory

Do I have my path name setup correctly? The drive is mapped and I have tried a 
couple diff pointers. 



 From: ggal...@wyanokegroup.com
 To: u2-users@listserver.u2ug.org
 Date: Wed, 31 Mar 2010 10:57:10 -0500
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?
 
 You would need to create a new VOC entry that referenced the other drive.
 
 ie x:pathname\LFUTILS.O/TEST_HARNESS2
 
 You could copy the VOC entry, and and prefix the drive,
 but your example used a relative path (..) which I have
 not used on our system, I've always used full pathnames
 unless the file was in the current account directory.
 
 As said by someone else, record locking will not exist with this method, if 
 you want record locking, you will need to use uvnet.
 
 that said, I don't think if your only running programs this method,
 locking would be a major concern, as long as your not trying to
 update the source file from the other server, just accessing it.
 
 What I'm not sure about is whether the object code is the same
 between a 32bit and 64bit O/S implementation...that's easy to test
 once you get the link setup. Just try it.
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Wednesday, March 31, 2010 11:38 AM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
  
  One more thing I wanted to add. We're trying to access the object code
  from one server
  on another. I assume this can be done but I wanted to clarify what our
  goals were.
  
  Server A (has object code) - Server B (wants to run Server A object
  code)
  
  I also found the UV/NET II guide and it says this:
  
  I-Descriptors and UniVerse BASIC Object Code
  UV/Net II gives users read and write access to files on remote systems.
  However, you
  cannot execute I-descriptors and UniVerse BASIC object code located on
  remote
  systems.
  
  Does that mean you can't access object code at all from one server to
  the other??
  
  Or are they saying if you're using an I-Descriptor? Thanks.
  
  
  
   From: cjausti...@hotmail.com
   To: u2-users@listserver.u2ug.org
   Date: Wed, 31 Mar 2010 10:07:03 -0500
   Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
  
   We can map the drives from one server to the other. Let's call the
  drive on Server A drive (Z:\).
   I assume we would still need UVnet to do this solution. If we did map
  a drive what would the VOC
   pointer look like?
  
   This is an example what one of my VOC pointers looks like now:
  
   ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2
  
   If we wanted to map this to serverA, using drive Z how would the
  pointer look?
  
  
  
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 31 Mar 2010 09:53:57 -0500
Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
   
Since your running windows, Can you map a drive to the other
  servers Folder containing the programs.
   
Then just setup a VOC entry pointing to the mapped drive.
   
Don't use NFS, just use windows SMB protocols. As long as
they are both setup with workgroup names the same you should
be ok.
   
   
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Chris Austin
 Sent: Wednesday, March 31, 2010 10:51 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another
 server?


 Our configuration is like this:


 Server A (Windows Server 2003, 32-bit) - the host server with
 programs.
 Server B (Windows Server 2008, 64-bit) - the production server,
  need to
 point to Server A only for a cpl programs.

 I've never setup an NFS but what we're doing is really basic, we
  have 3
 accounts with corresponding folders
 on Server A and 1 account with 1 folder on Server B.

 Does anyone know how to setup a NFS in Windows? Or do we just
  need the
 ALLOWNFS setting + UVnet?




  From: ggal...@wyanokegroup.com
  To: u2-users@listserver.u2ug.org
  Date: Wed, 31 Mar 2010 08:56:19 -0500
  Subject: Re: [U2] 2 servers - how do I point to a VOC on
  another
 server?
 
  you didn't say what the O/S of the systems are.
 
  If you are running unix on both machines, you need to setup
  one machine

Re: [U2] 2 servers - how do I point to a VOC on another server?


I was able to run object code on Server A from Server B by using universal path 
name in the VOC as follows:

\\server name\CHRISSYS\LFUTILS.O/TEST_HARNESS2   

.\CHRISSYS\LFUTILS.O/TEST_HARNESS2   **old VOC**

So that takes care of running the source code from 1 server to the other. Now 
the next and final step would
be to install UVnet so we can edit the VOC on server B and then those programs 
will be able to run. 

Again, we only point the VOC to the development server for a day or 2 to test 
new changes before the code
is copied over.



 From: ggal...@wyanokegroup.com
 To: u2-users@listserver.u2ug.org
 Date: Wed, 31 Mar 2010 11:26:31 -0500
 Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?
 
 I Don't work with UV on Windows, so I'm not sure.
 
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Chris Austin
  Sent: Wednesday, March 31, 2010 12:23 PM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] 2 servers - how do I point to a VOC on another
  server?
  
  
  I setup a mapped drive drive on ServerA and i called it S:\ which maps
  to my CHRISSYS (programming directory)
  
  and I then changed the VOC from:
  
  ..\CHRISSYS\LFUTILS.O/TEST_HARNESS3
  
  to
  
  S:LFUTILS.O/TEST_HARNESS2
  
  and
  
  S:\LFUTILS.O/TEST_HARNESS2
  
  with no luck. I get this back from telnet:
  
  LIVETEST_HARNESS2
  Unable to open the operating system file S:\LFUTILS.O/TEST_HARNESS2.
  [ENOENT] No such file or directory
  
  Do I have my path name setup correctly? The drive is mapped and I have
  tried a couple diff pointers.
  
  
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
  
_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_1
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Subject: 2 servers - how do I point to a VOC on another server?

Susan,

Thanks for the reply! Right now we're using M$ Source Safe for our repository
needs but I
am curious what your product has to offer. Does this product work on multi
servers?

I have thought about doing a release with source safe every so often that would
essentially
copy the object code into the production server region.

And on a side note to Bill, we do have a 'sandbox' region setup. I guess we
were hoping to
elevate a program for a day or 2 (like we do now) on 1 server.. but cross
servers until
we decided to commit the changes but it appears that this may not be the best
solution.

-Chris

From: sjos...@sjplus.com
To: u2-users@listserver.u2ug.org
Date: Wed, 31 Mar 2010 15:28:48 -0400
Subject: [U2] Subject: 2 servers - how do I point to a VOC on another server?

Hi Chris,
I can't help myself - everyone knows it. Just like most know that I have a
version control / deployment product for U2 that I could be trying to plug.
And if you are interested I'd be happy to talk to you about it. (There ya go
- plugged!) But whatever you will do to manage your promotions to live I
really very strongly recommend that you not run some programs off of the dev
server!

Why not copy the program to the live server and compile and catalog it
there? Keep a very strong border between dev and live! Papers required to
cross! The idea of having some programs running out of DEV and some not...
well, it strikes me as a situation waiting for its moment!

Let me know if I can help...

Susan Joslyn
sjos...@sjplus.com
SJ+ Systems Associates, In.c
PRC(r) Real software development life-cycle management for U2

Message: 1
Date: Tue, 30 Mar 2010 16:31:08 -0500
From: Chris Austin cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Subject: [U2] 2 servers - how do I point to a VOC on another server?
Message-ID: snt104-w56921228bd3de6dcf6781edb...@phx.gbl
Content-Type: text/plain; charset=iso-8859-1

Hello,

We're running UniVerse 10.1.8 on our main server and we just bought another
server with UniVerse 10.3.3. I would like to setup the old server as the
development
server and keep the new server as the production server. The problem is
we want to elevate some programs to the new server. Ideally we would just
point the VOC to the old server until we fully test the programs. We have
set
ALLOWNFS to 1 as well. What is involved for us to run a file and setup a voc
to
point to a completely different server?

Example) program A is on server 1, but we want the changes to reflect on
server 2.

What we have been doing in the past is editing the VOC from one account to
the other, but
I'm not sure how to do this on another server.

Thanks.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_3
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] 2 servers - how do I point to a VOC on another server?

2010-03-30 Thread Chris Austin


Hello,

We're running UniVerse 10.1.8 on our main server and we just bought another
server with UniVerse 10.3.3. I would like to setup the old server as the 
development
server and keep the new server as the production server. The problem is
we want to elevate some programs to the new server. Ideally we would just 
point the VOC to the old server until we fully test the programs. We have set 
ALLOWNFS to 1 as well. What is involved for us to run a file and setup a voc to 
point to a completely different server?

Example) program A is on server 1, but we want the changes to reflect on server 
2.

What we have been doing in the past is editing the VOC from one account to the 
other, but
I'm not sure how to do this on another server.

Thanks.

  
_
Hotmail is redefining busy with tools for the New Busy. Get more from your 
inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_2
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] 2 servers - how do I point to a VOC on another server?

2010-03-30 Thread Chris Austin

Thanks for the reply John. Is there anything we need to setup to achieve an
NFS mount? The only configuration change we made thus far was setting ALLOWNFS
to 1.

An example of a VOC entry on the OLD SERVER is as follows:

LIVECT VOC TEST_HARNESS2

TEST_HARNESS2
0001 V *PJC* ELEVATED FROM CHRIS PROJECT 2487 ON 11:25:11 01 SEP 2009
0002 ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2
0003 B
0004 BNP
0005
0006 PICK.FORMAT
0007 S²N²P²I²A²E²H
0008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP
0009 ..\CHRISSYS\LFUTILS.O

I'm confused what 'mnt' would be in your notes? If you could clarify what our
VOC should
be I can then test this out. I really appreciate the help! Thanks.

-Chris

Date: Tue, 30 Mar 2010 14:44:02 -0700
From: jhes...@momtex.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 2 servers - how do I point to a VOC on another server?

If I'm understanding correctly, you want to run a program that
physically resides on the old server against data on the new server. I
haven't done this myself, but I don't see any reason why you couldn't
run or catalog a program that sits on an NFS mount from another server.
The VOC for the remote file might look something like this:

BP.OLD

001: F
002: /mnt/nfs/old_server/BP
003: /mnt/nfs/old_server/D_BP

and you'll also need the corresponding object file:

BP.OLD.O

001: F
002: /mnt/nfs/old_server/BP.O
003: /mnt/nfs/old_server/D_BP.O

Then you should be able to RUN BP.OLD PROGRAMNAME or CATALOG BP.OLD
PROGRAMNAME to have its VOC entry replace one that points to the local
copy of the program.

-John

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Tuesday, March 30, 2010 2:31 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] 2 servers - how do I point to a VOC on another server?

Hello,

We're running UniVerse 10.1.8 on our main server and we just bought
another
server with UniVerse 10.3.3. I would like to setup the old server as the
development
server and keep the new server as the production server. The problem is
we want to elevate some programs to the new server. Ideally we would
just
point the VOC to the old server until we fully test the programs. We
have set
ALLOWNFS to 1 as well. What is involved for us to run a file and setup a
voc to
point to a completely different server?

Example) program A is on server 1, but we want the changes to reflect on
server 2.

What we have been doing in the past is editing the VOC from one account
to the other, but
I'm not sure how to do this on another server.

Thanks.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL:ON:WL:en-US:WM_HMP:032010_1
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV ODBC Driver

2009-08-13 Thread Chris Lee

Thanks, I had already used UCI Editor and defined the exact same parameters
as on our existing server.
I just tried removing the additional line that our server has (MAXFETCHBUFF
= 16384) and the test connection now passes on my PC, so there must be an
issue with that parameter in the newer driver version.

Cheers,
Chris

On Tue, Aug 11, 2009 at 9:21 AM, Brutzman, Bill bi...@hkmetalcraft.comwrote:


 The UCI Editor on the PC is a necessary first step.

 In Windows it can be found in the \ IBM U2 \ UniVerse ODBC Driver \

 --Bill

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Lee
 Sent: Monday, August 10, 2009 6:22 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UV ODBC Driver

 We have a UniVerse database running UV Version 10.1.17 on AIX.
 I have the IBM UniVerse ODBC Driver version 4.00.03.7251 installed on my
 PC, but can't seem to get it to successfully connect to the UniVerse
 database...
 we already have another server with a UniVerse ODBC driver installed and
 connecting successfully, but it's a somewhat older ODBC driver version
 (4.00.00.7045).

 Do you have to use a particular ODBC driver with UV 10.1.17 or is there
 something else that needs to be configured ?

 When I put in the server details and click Test Connection on my PC I
 get the following error message from the ODBC client:-

 [IBM][UVODBC][0301931]Error ID:46 Severity: ERROR Facility: DBCAPERR -
 UCI Error. Func: SQLConnect(); State: IM997; uniVerse code: 0; Msg:
 [IBM][SQL Client] An illegal configuration option was found.

 Thanks,
 Chris
 ___
 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] UV ODBC Driver

2009-08-10 Thread Chris Lee

We have a UniVerse database running UV Version 10.1.17 on AIX.
I have the IBM UniVerse ODBC Driver version 4.00.03.7251 installed on my PC,
but can't seem to get it to successfully connect to the UniVerse database...
we already have another server with a UniVerse ODBC driver installed and
connecting successfully, but it's a somewhat older ODBC driver version
(4.00.00.7045).

Do you have to use a particular ODBC driver with UV 10.1.17 or is there
something else that needs to be configured ?

When I put in the server details and click Test Connection on my PC I get
the following error message from the ODBC client:-

[IBM][UVODBC][0301931]Error ID:46 Severity: ERROR Facility: DBCAPERR - UCI
Error. Func: SQLConnect(); State: IM997; uniVerse code: 0; Msg: [IBM][SQL
Client] An illegal configuration option was found.

Thanks,
Chris
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

RE: [U2] [UD] Unexpected telnet/SSH error

2009-03-06 Thread Chris Thornton1

Hi Tony,

Would this be a UniData PE problem, or would it be a problem with some 
other (unrelated) software listening on port 22 ?

Regards

- Chris Thornton





Tony G 1tlx6h...@sneakemail.com 
Sent by: owner-u2-us...@listserver.u2ug.org
06/03/2009 06:43
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] [UD] Unexpected telnet/SSH error






Bill - the problem isn't that I want to run SSH or that I can't
find telnet.  Although I do have 7 MV DBMS platforms running on
my system and none of them run on default ports.  :)  I did
accidentally telnet to the wrong port, but then found the right
port, oops, mea culpa.

The issue is that it looks like anyone can generate a mysterious
server desktop dialog simply by telnetting to the SSH port.  That
would have to annoy someone if it happens at the wrong time and
you're not sure what caused it.

Try it.  If your default for Telnet is 23 and SSH is 22, just
Telnet to port 22 and see what happens.

T


 From: Bill Haskett
 
G-Man:
Is something listening on port 22?
Bill


From: Tony G
 
 This started out to be a bug report, but now I'm not sure if
it's
 just a don't do that issue.
 
 Whenever I connect to my Unidata PE 7.2 over Windows via
telnet,
 an unknown software exception error dialog would display on the
 _server_ desktop.  I realized this was because I was telnetting
 onto the SSH port.  OK, oops, don't do that.  But I'd consider
 this a bug.  Can someone else verify this behaviour and then
 report it to IBM through proper channels?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/







Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] port.status

2008-09-04 Thread Chris Louis

Unsubscribe * [EMAIL PROTECTED]

Thank you,

Chris Louis

Asset Management Outsourcing, Inc.
5655 Peachtree Parkway, Suite 213
Norcross, GA 30092
800-893-3501 x 1106


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 12:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] port.status

To all.

thanks for your suggestions.   there was something hincky with aix and
universe.   server had been setup in July.   Universe added at the same
time.Then in August, we imported our files.And started getting
'universe will expire in x days'.   Which we hadn't been getting before.

Sticky bits had been turned on.  

invalid expiration date could not be resolved by reconfiging universe.

both invalid expiration date and port.status were both resolved by a
shutdown and restart of aix.

About the only thing that was done to the system between initial setup
and the conversion, HP Jetdirect drivers were installed into/onto AIX by
our aix/os guru.

Sorry, don't know exactly what the guru did.  but universe seems okay
now.  We'll just remember to kick the server more often.

Again, thanks all.
Roger


- Original Message -
From: Lloyd Cottrell 
Date: Thursday, September 4, 2008 11:42 am
Subject: Re: [U2] port.status
To: u2-users@listserver.u2ug.org

 that was my point, easier to remember that +s is that sticky is 
 easier to
 remember or associate with +s. Also, unless i don't understand 
 what an OS
 is, this program (port.status) is not part of the OS but part of 
 the DB. I
 too would not be doing this to an OS program.
 
 On Thu, Sep 4, 2008 at 6:58 AM, jpb-u2ug wrote:
 
  My mistake, thanks Ken. It's just that when you don't do it 
 too often the
  names get jumbled together. Beside the fact that '+s' sounds 
 like it should
  be sticky.
 
  Jerry Banker
 
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis
  Sent: Wednesday, September 03, 2008 10:04 PM
  To: u2-users@listserver.u2ug.org
  Subject: RE: [U2] port.status
 
  OK, I ignored it the first time, but if this is going to keep 
 rolling then
  I
  need to jump in with a correction before people assume it must 
 be correct.
 
  This is not the 'sticky' bit. The purpose of the sticky bit 
 on some
  (older)
  unix implementations is to keep the text segment of an 
 executable loaded in
  memory once it has been executed rather than unloading it at 
 completion. This was designed to make commonly used programs 
 load faster, but is now
  pretty much irrelevant in that context and is ignored by some unix
  implementations such as Linux. The sticky bit is most often 
 used now on
  directories such as /tmp where it requires the actual owner of 
 a file to
  delete or modify that file, even though other users might have write
  permission on the directory. The sticky bit gets set with 
 chmod +t.
 
  If you want a program to run with the credentials of another 
 user (such as
  root) when it is executed, then you set the 'setuid' bit with 
 chmod +s and
  make sure the file is owned by the appropriate user and 
 executable by
  relevant people.
 
  I won't get into arguments about how good an idea it is to set 
 the setuid
  bit on random bits of the operating system.
 
  Cheers,
 
  Ken
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG
  Sent: Thursday, 4 September 2008 11:24 AM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] port.status
 
  Yes, but it should have already been set. If you want it to 
 work with
  everyone then set the sticky bit in the /usr/bin/ipcs.
 
  --
  From: Lloyd Cottrell 
  Sent: Wednesday, September 03, 2008 12:19 PM
  To: 
  Subject: Re: [U2] port.status
 
   i've found that you need to flip on the sticky bit on the 
 list_readu  program
   to fix this problem, which makes it run as root
  
   On Tue, Sep 2, 2008 at 2:49 PM, wrote:
  
   New install of Universe 10.2.4
   PORT.STATUS
   There are no uniVerse sessions that match the specified 
 conditions. 
   But one user is logged on as root and then starting 
 /usr/ibm/uv/bin/uv.  And is running a multple program 
 jobstream, so something Universe
  should
   have been detected.
  
   And we get the same results if a user logins with a unique 
 login, is
  then
   pointed to the /bin/ksh and starting uv.
  
   Thanks.
   Roger
   ---
   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

Re: [U2] Determining double-byte status of a character

2007-12-21 Thread Chris Thornton1

Hi Craig,

Assuming UniVerse NLS on, and that you mean double-byte in the external 
characterset, I would use BYTELEN( OCONV( mychar, NLS:mapname) ) 

Regards

- Chris Thornton

_
Chris Thornton DataStage development engineer





Craig Bennett [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
20/12/2007 23:26
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
Re: [U2] Determining double-byte status of a character






Bob,

can you use the UNISEQ function? or failing that BYTEVAL (testing for 
the multibyte character start byte)?


Craig
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/







Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] secure ftp

2007-08-02 Thread Chris Thornton1

Hi Theo,

On-line information on AIX ssh / sftp bundling is here:

http://www-128.ibm.com/developerworks/eserver/articles/openssh_aix.html

Regards

- Chris 
_
Chris Thornton DataStage development engineer





aivazian [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
01/08/2007 21:00
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] secure ftp






It wasn't in the manual, but I found it with the usage desc when I typed 
it
in, I am not 100% sue if how the options work yet


theo








Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] JMS and Unidata

2007-07-10 Thread Chris Neal

Has anyone had any experience integrating from Unibasic to JMS?

We were thinking of using the XML tools to map the database then use a
Database Trigger to send a XML message to a JMS server...


-- 
View this message in context: 
http://www.nabble.com/JMS-and-Unidata-tf4059332.html#a11532415
Sent from the U2 - Users mailing list archive at Nabble.com.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [AD] Entrinsik is hiring [/AD]

2007-03-30 Thread Chris Reeves

Entrinsik, Inc., a privately held company with a solid foundation of
more than 18 years in the multi-value industry, is seeking qualified
applicants for a Customer Product Support Professional position in
Raleigh, NC.

Responsibilities include: Provide customer support via phone and web
meetings; conduct on-site and web training; assist product development
team with testing and programming; assist VAR customers in embedding our
Informer Web Reporting software within their vertical offerings.
Desired Skills: Candidate should possess: A college degree; Effective
communication skills; Java programming experience a plus; Working
knowledge of Multi-value database concepts; applicable work experience. 

Interested individuals should send resume and cover letter to
[EMAIL PROTECTED]

Chris Reeves
Entrinsik, Inc.
919-848-4828 x114
[EMAIL PROTECTED]
http://www.entrinsik.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] spam using u2

2007-02-28 Thread Chris Thornton1

I just won $100, apparently. 

Regards

- Chris Thornton

_
Chris Thornton DataStage development engineer

[EMAIL PROTECTED] 

IBM United Kingdom Limited
Power House
Harrison Close
Knowlhill
Milton Keynes
Buckinghamshire
MK5 8RR  U.K.





Perry Taylor [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
28/02/2007 15:46
Please respond to
u2-users@listserver.u2ug.org


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] spam using u2






Yes.

From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry
Sent: Wednesday, February 28, 2007 8:47 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] spam using u2

Have other people been getting spam with the [U2] subject line (see below) 
lately?
 
- Original Message - 
From: PayPal 
Sent: Tuesday, February 27, 2007 11:58 PM
Subject: [U2] Verify your identity

Dear PayPal,

We recently noticed one or more attempts to log in to your PayPal account
from a foreign IP address.

If you recently accessed your account while traveling, the unusual log in
attempts may have been initiated by you. However, if you did not initiate
the log ins, please visit PayPal as soon as possible to verify your
identity:

https://www.paypal.com/us/cgi-bin/webscr? cmd=_login-run

Verify your identity is a security measure that will ensure that you are
the only person with access to the account.

Thanks for your patience as we work together to protect your account.

Sincerely,
PayPal
  
PROTECT YOUR PASSWORD

   NEVER give your password to anyone and ONLY log in at
https://www.paypal.com/. Protect yourself against fraudulent websites by
opening a new web browser (e.g. Internet Explorer or Netscape) and typing
in the PayPal URL every time you log in to your account.
 

Please do not reply to this e-mail. Mail sent to this address cannot be
answered. For assistance, log in to your PayPal account and choose the
Help link in the header of any page.

PayPal Email ID PP321 
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is 
for the sole use of the intended recipient(s) and may contain confidential 
and privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will be returned 
to the originating party with such advisement noted. If you are not the 
intended recipient, please contact the sender by reply e-mail and destroy 
all copies of the original message.






Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU

Re: [U2] UniData telnet

2006-12-21 Thread Chris Thornton1

Hi Bill,

I've seen similar problems with DataStage, caused by firewalls  timing out
sessions for you.

If you can't change the firewall, not sure what the solution would be.

Regards

  - Chris Thornton

_
Chris Thornton DataStage development engineer

[EMAIL PROTECTED]  Chris Thornton1/UK/IBM

IBM United Kingdom Limited
Power House
Harrison Close
Knowlhill
Milton Keynes
Buckinghamshire
MK5 8RR  U.K.




   
 Bill Haskett
 [EMAIL PROTECTED] 
 os.netTo 
 Sent by:  u2-users@listserver.u2ug.org  
 [EMAIL PROTECTED]  cc 
 stserver.u2ug.org 
   Subject 
   [U2] UniData telnet 
 21/12/2006 10:34  
   
   
 Please respond to 
 [EMAIL PROTECTED] 
er.u2ug.org
   
   




I have UniData 7.1 running on a local server in our network.  I'm testing
UniData 7.1 on an off-site server.  When I telnet in to the off-site server
I notice telnet is disconnecting if idle for 30 minutes.  This never
happens
on our internal server.  We use AccuTerm.  The telnet port is different
than
port 23.

I have the keepalive unchecked in AccuTerm because is sends a funny
character to UniData (a greater-than character with a line underneath it).
I used UniAdmin and configured UniData telnet to send the keepalive with
the parameters being 1000 / 720 / 5.  It still disconnects.

Does anyone know how this is supposed to work in UniAdmin and UniData?

Thanks,

Bill Haskett
---
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 ODBC driver performance issues {Unclassified}

Mike,
The NIC is reporting 1-2% busy.  Can you explain I-Type Dictionary
items?  Is an I-Type Dictionary Item equivalent to a I-descriptor?  
Sorry I am new to UniVerse, Thanks for your patience!!! 
Chris 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, August 10, 2006 6:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}

John,

Chris is transferring on average about 360 (2.6M / 2 / 3600) records per
second.  If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the throughput you might
hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.

I can see how increasing the block size would make the network traffic
less inefficient, it would be interesting to see what percent busy the
network card reports.

One of the other issues can be that the data contains, on the UV side,
complicated I-Type Dictionary items that mean that the exported data
isn't nearly as simple as it looks.  This can cause an unexpectedly
large amount of I/O on the UV side.

Mike

-Original Message-
From: [EMAIL PROTECTED] On Behalf Of John Hester
Sent: Friday, 11 August 2006 08:39
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues 

 -Original Message-
 From: [EMAIL PROTECTED] Behalf Of Chris Brooks
 Sent: Thursday, August 10, 2006 8:21 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Universe ODBC driver performance issues
 
 I am new to the group and to UniVerse.  We are experiencing issues in 
 UniVerse 10.1.3 downloading data via the ODBC connection to SQL 
 Server.
 2.6 mil records can take 2 hours to complete.  We are currently using 
 the default settings for the ODBC driver.  I will soon make changes to

 increase the prefetch and threshold values.  Any experience with the 
 ideal settings?  From my testing the best performance seems to be at 
 prefetch = 16383 and threshold = 4096 on the ODBC driver.  At this 
 settings seem to get a 30% performance increase.  I would like to see 
 it improve even more.
 

 During the download the CPU is utilized less than 10%.

Sounds like you're I/O bound, although 2.6 million records in 2 hours
isn't all that bad in my experience.  Is it possible you're hitting the
threshold of your NICs, or competing with a lot of other network
traffic?  If both machines have multiple NICs, you could reserve one on
each machine for only talking to the other.  You could add an entry to
the hosts file on each so it would only know the other machine by the
reserved NIC's IP, then just make sure the reserved IP addresses don't
exist in DNS so no other machines will use them.  If the machines are
physically close, a crossover cable from NIC to NIC would eliminate any
switch performance issues.  At that point a rough calculation of your
throughput based on the average size of each record would tell you if
you're utilizing the available bandwidth, or if there's some other
bottleneck.

-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/ The information
contained in this Internet Email message is intended for the addressee
only and may contain privileged information, but not necessarily the
official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy
or distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
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 ODBC driver performance issues {Unclassified}

John, 
It is abysmal because the NIC and the Ethernet are both gigabit. 
Thanks,
Chris  

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Hester
Sent: Thursday, August 10, 2006 7:19 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON 
 MIKE, MR
 Sent: Thursday, August 10, 2006 4:22 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] Universe ODBC driver performance issues 
 {Unclassified}

 John,

 Chris is transferring on average about 360 (2.6M / 2 / 3600) records 
 per second.  If the records are ~200 chars, then he's getting about 
 700kb/sec (that's kb, not kB), or about 1.5% of the throughput you 
 might hope for on a 100Mbps Ethernet pipe!
 So I'd say Chris does have an issue here.

ODBC is known to be very chatty and inefficient, so you have to add
quite a bit of overhead for the protocol itself (though I don't know how
much).  Even so, you're right, that's pretty poor performance over 100MB
ethernet and it would be abysmal for a gigabit link.

-John
---
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 ODBC driver performance issues {Unclassified}

David 
We are pulling data into SQL Server from UniVerse through an ODBC
connection.
Thanks
Chris  

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: Friday, August 11, 2006 4:44 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues {Unclassified}

Chris are you pulling data into SQL Server from UniVerse through an ODBC
connection or are you pushing the data to the SQL Server through BCI.

Regards

David Jordan
Managing Consultant
 
[EMAIL PROTECTED]
 Chris is transferring on average about 360 (2.6M / 2 / 3600) records 
 per second.  If the records are ~200 chars, then he's getting about 
 700kb/sec (that's kb, not kB), or about 1.5% of the throughput you 
 might hope for on a 100Mbps Ethernet pipe!
 So I'd say Chris does have an issue here.
---
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 ODBC driver performance issues {Unclassified}