Re: [U2] UniVerse over Solaris Logon Question.

[Joshua Gallant]

When you execute the uv session the local directory you are in at the time
is the account directory.  I'd think you are changing to that directory in
your login script or setting the path the same for every Solaris account.

Something like this in your ".profile" file could help:

cd /path/to/account/directoryexec `cat /.uvhome`/bin/uv


Note those are back ticks above.

- Josh





On 1/12/12 9:04 AM, "John Varney"  wrote:

I recently went to work for a company that is running UniVerse over
Solaris.
This seems to be working really well.

We are running ManFact and are setting up multi-plant operations. As part
of
the upgrade we are changing the live account from MANLIVE to something
else.
I'm not doing the upgrade as I kinda walked into the middle of it, and the
person who is doing it seems very well versed in ManFact so no worries
there.

My question is where do we change the default login account? Come next
Monday, people should not be logging into MANLIVE. We looked at the initial
login script on Solaris but that just starts a uv session. Any ideas?




___
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] Extracting XML attributes

[Joshua Gallant]

When working with large XML files in the past I've always run into issues
like this but I use a combination of xmapopen, xmapreadnext, and
xmapclose.  I couldn't ever come up with a great way to use the UV tools
for parsing a large file at once so I open as a sequential file and parse
the file until I have a full record.  I then process that one record with
the xml functions.  There might be 15 other ways but this has always
served its purpose.

- Josh





On 1/12/12 11:10 AM, "Bobby Worley"  wrote:

Does anybody have an experience reading in very large XML files into
Universe on AIX using PrepareXML() function?

We received a 176Mb XML file, and I'm running out of memory.  I've maxed
out ulimit -d and it still blows up with this error:

ERROR MESSAGE A DOM error occured during parsing.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Wednesday, November 16, 2011 7:34 AM
To: U2 Users List
Subject: Re: [U2] Extracting XML attributes

Turns out it is a memory issue. My XML file is 16Mb.   Setting ulimit -d
75 resolved the issue.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Friday, November 11, 2011 10:42 AM
To: U2 Users List
Subject: Re: [U2] Extracting XML attributes

My latest challenge:

>PREPARE.XML FEED.XML MYXML
Prepare the XMLDOM failed.
XMLParser error message: A DOM error occured during parsing.

UNIVERSE RELLEVEL
001 X
002 11.1.0
003 PICK
004 PICK.FORMAT
005 11.1.0

Aix Version 5.3.0.0

FEED.XML is 16mb. 

It prepares just fine on UV 10.1.17.  Unfortunately it wont list on UV
10.1 because UV 10.1 is not aware of namespaces.

This is making my pull my hair out... I don't need this on a Friday.

Bob Worley
Coburn Supply

___
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] Building an Excel File

[Joshua Gallant]

We were running JET until our latest UniVerse upgrade earlier this year.
We used it all over and the users actually resisted when we told them it
had to go.  Go figure.  After a few days testing with our own code they
saw the light.

- Josh





On 2/7/12 12:46 PM, "Wjhonson"  wrote:

Dig it up and market it because Universe is no longer offering JET.



-Original Message-
From: Brian Leach 
To: 'U2 Users List' 
Sent: Tue, Feb 7, 2012 9:43 am
Subject: Re: [U2] Building an Excel File


IIRC didn't VMARK buy CompuSheet, at around the same time they bought JET?
t's probably lying around on and old QIC somewhere..
I'd just written a JET and Ultiword emulator for UniVerse when they popped
p with JET. Grr.. but a long time ago.

nd back to topic I second the "use Tony's tools" motion. Why waste time and
oney reinventing the wheel?
You make think your working time is free, but someone's paying for it!)
If you really need to call out from Excel (as opposed to building
preadsheets from the db) you can use VBA and UniObjects.
Brian
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
ent: 07 February 2012 16:13
o: U2 Users List
ubject: Re: [U2] Building an Excel File
Amen! I don't think I would want to go back to 9600 baud serial
ommunications, though. My first Reality "job" was contract programming
or a local service bureau, using an ADDS Viewpoint terminal and 300
aud acoustical coupler. They handed me the terminal, modem and a set of
anuals and said "Have fun!". Dang, now I'm telling my age!
EasyCalc ran on Reality as well. Of course, it went the way of many of
he other dinosaurs. Now EasyCalc Googles to a scientific calculator on
ourceForge. I acquired the source code and rights to redistribute, but
hat never went anywhere.
If memory serves, Compusheet used a lot of abs frames for speed. EC was
ll Data/Basic. It was a bit slow recalculating a series of 600+
preadsheets from the bottom up. The others in IT (then called Data
rocessing) didn't think I would be able to get it to work at all, but
t did. The sheets drilled all the way down to class enrollment and
aperclip counts, and rolled it all up to a top level , which they used
o feed their GL.
I probably should have taken this [OT], but I didn't know what effect
hanging the subject would have.
Charlie
On 02-07-2012 9:52 AM, Dianne Ackerman wrote:
 Hm, don't remember EasyCalc, but Compusheet was on a Reality system.
 It was so much easier when we only had to know what was native in our
 own systems and not be concerned with a million different things to
 connect to in the outside world!
 -Dianne

 On 2/7/2012 10:45 AM, Charlie Noah wrote:
> Hi Dianne,
>
> You're telling your age here! ;^)
>
> Actually, it was EasyCalc, which was probably very similar to
> Compusheet.
>
> Charlie
>
> On 02-07-2012 9:30 AM, Dianne Ackerman wrote:
>> Compusheet?  I remember working with that!
>> -Dianne
>>
>> On 2/7/2012 6:50 AM, Charlie Noah wrote:
>>> Hi Bob,
>>>
>>> I don't suppose CrowFlite can be obtained these days, can it? It
>>> looks like Phil has retired. If it were available, would it work
>>> with the newer versions of Excel? What about Open Office?
>>>
>>> In the 80s I worked for a university in Florida, where we used a
>>> Pick-based spreadsheet modeled after Lotus 123. I built a series of
>>> spreadsheets which reached down into every aspect of the
>>> university's database, giving upper management an up to the minute
>>> view of the school's financial picture. I think it ended up being
>>> over 600 spreadsheets, but hey, fund accounting is complicated and
>>> we did still have the 32K limit.
>>>
>>> Fond memories. ;^)
>>>
>>> Regards,
>>> Charlie Noah
>>>
>>> Tiny Bear's Wild Bird Store
>>> "Everything For The Backyard Bird Enthusiast, Except For The Birds"
>>> Info, Forum:  http://www.TinyBearMarketing.com
>>> Store:http://Stores.TinyBearMarketing.com
>>> Toll Free:   1-855-TinyBear (855-846-9232)
>>>
>>>
>>> On 02-06-2012 10:57 PM, Bob Rasmussen wrote:
 Makes one long for CrowFlite, doesn't it?

 For those that don't remember, CrowFlite was an add-in to Excel that
 allowed it, at a per-cell level, to "reach back" into a Pick
 database and
 grab individual pieces of data. In other words, it was a "pull"
 solution
 as well as a "push".

 I'm cc'ing its creator, Phil Gerber, so he can reminisce about the
 past
 while reveling in the sights among the mountains of Oregon :-)

 On Mon, 6 Feb 2012, Tony Gravagno wrote:

> Not responding to any particular quote here, just the CSV topic
> in general.
>
> Respected colleagues, CSV is not Excel. If you have an end-user
> that asks for Excel and you give them a CSV you're just
> perpetuating the myth that Pick is a dinosaur. They will gladly
> spend tens of thousands of dollars to replace your application
> with something that 

Re: [U2] Building an Excel File

[Joshua Gallant]

I have never personally used JET-EDIT.  For a replacement, we wrote our
own code.  Since we're an end-user site its not something released
anywhere.

- Josh





On 2/7/12 3:57 PM, "Wjhonson"  wrote:


So what are they using in place of JET?
Did you ever use JET-EDIT to edit your programs?



-Original Message-----
From: Joshua Gallant 
To: U2 Users List 
Sent: Tue, Feb 7, 2012 12:41 pm
Subject: Re: [U2] Building an Excel File


We were running JET until our latest UniVerse upgrade earlier this year.
e used it all over and the users actually resisted when we told them it
ad to go.  Go figure.  After a few days testing with our own code they
aw the light.
- Josh


On 2/7/12 12:46 PM, "Wjhonson"  wrote:
Dig it up and market it because Universe is no longer offering JET.

-Original Message-
rom: Brian Leach 
o: 'U2 Users List' 
ent: Tue, Feb 7, 2012 9:43 am
ubject: Re: [U2] Building an Excel File

IRC didn't VMARK buy CompuSheet, at around the same time they bought JET?
's probably lying around on and old QIC somewhere..
'd just written a JET and Ultiword emulator for UniVerse when they popped
 with JET. Grr.. but a long time ago.
nd back to topic I second the "use Tony's tools" motion. Why waste time and
ney reinventing the wheel?
ou make think your working time is free, but someone's paying for it!)
f you really need to call out from Excel (as opposed to building
readsheets from the db) you can use VBA and UniObjects.
rian
Original Message-
om: u2-users-boun...@listserver.u2ug.org
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
nt: 07 February 2012 16:13
: U2 Users List
bject: Re: [U2] Building an Excel File
men! I don't think I would want to go back to 9600 baud serial
mmunications, though. My first Reality "job" was contract programming
r a local service bureau, using an ADDS Viewpoint terminal and 300
ud acoustical coupler. They handed me the terminal, modem and a set of
nuals and said "Have fun!". Dang, now I'm telling my age!
asyCalc ran on Reality as well. Of course, it went the way of many of
e other dinosaurs. Now EasyCalc Googles to a scientific calculator on
urceForge. I acquired the source code and rights to redistribute, but
at never went anywhere.
f memory serves, Compusheet used a lot of abs frames for speed. EC was
l Data/Basic. It was a bit slow recalculating a series of 600+
readsheets from the bottom up. The others in IT (then called Data
ocessing) didn't think I would be able to get it to work at all, but
 did. The sheets drilled all the way down to class enrollment and
perclip counts, and rolled it all up to a top level , which they used
 feed their GL.
 probably should have taken this [OT], but I didn't know what effect
anging the subject would have.
harlie
n 02-07-2012 9:52 AM, Dianne Ackerman wrote:
Hm, don't remember EasyCalc, but Compusheet was on a Reality system.
It was so much easier when we only had to know what was native in our
own systems and not be concerned with a million different things to
connect to in the outside world!
-Dianne
 On 2/7/2012 10:45 AM, Charlie Noah wrote:
 Hi Dianne,

 You're telling your age here! ;^)

 Actually, it was EasyCalc, which was probably very similar to
 Compusheet.

 Charlie

 On 02-07-2012 9:30 AM, Dianne Ackerman wrote:
> Compusheet?  I remember working with that!
> -Dianne
>
> On 2/7/2012 6:50 AM, Charlie Noah wrote:
>> Hi Bob,
>>
>> I don't suppose CrowFlite can be obtained these days, can it? It
>> looks like Phil has retired. If it were available, would it work
>> with the newer versions of Excel? What about Open Office?
>>
>> In the 80s I worked for a university in Florida, where we used a
>> Pick-based spreadsheet modeled after Lotus 123. I built a series of
>> spreadsheets which reached down into every aspect of the
>> university's database, giving upper management an up to the minute
>> view of the school's financial picture. I think it ended up being
>> over 600 spreadsheets, but hey, fund accounting is complicated and
>> we did still have the 32K limit.
>>
>> Fond memories. ;^)
>>
>> Regards,
>> Charlie Noah
>>
>> Tiny Bear's Wild Bird Store
>> "Everything For The Backyard Bird Enthusiast, Except For The Birds"
>> Info, Forum:  http://www.TinyBearMarketing.com
>> Store:http://Stores.TinyBearMarketing.com
>> Toll Free:   1-855-TinyBear (855-846-9232)
>>
>>
>> On 02-06-2012 10:57 PM, Bob Rasmussen wrote:
>>> Makes one long for CrowFlite, doesn't it?
>>>
>>> For those that don't remember, CrowFlite was an add-in to Excel that
>>> allowed it, at a per-cell level, to "reach back" into a Pick
>>&

Re: [U2] Building an Excel File

[Joshua Gallant]

I was going to ask the same question about embedded line feeds.  I've been
dealing with a lot of outside companies the last few months transferring
data and found a lot have embedded line feeds all over.

- Josh





On 2/9/12 11:11 AM, "George Gallen"  wrote:

Is it possible that the URL has an embedded lf at the end from entry on
the source side?

I've created csv files comma/quoted that contained URLs and were quite
long and didn't have any issues importing
  Them into excel as a .csv , at least not as breaking into two lines.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:06 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File

Thanks George. I changed the tabs to pipes just to display them here.
Normally I save as tab delimited with no surrounding character. Since
the cell contents copies and pastes as 2 lines, I'm not sure whether
these suggestions would solve my problem.

Thanks again,
Charlie

On 02-09-2012 8:54 AM, George Gallen wrote:
> Not sure if this helps...
>
> I noticed that you were showing pipe delimited lines...
> If you rename your file from .csv to .txt
>
> Then from excel, you use the "Open" option, and then you can set the
>delimiter to |
> And also change the column types before it imports it, or have it
>skip a column as well.
>
> George
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
>[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> Sent: Thursday, February 09, 2012 9:46 AM
> To: U2 Users List
> Subject: Re: [U2] Building an Excel File
>
> While everyone is thinking about CSV and Excel, maybe I can get a
> solution to a problem that's been plaguing me for a long time.
>
> ___
> 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] Building an Excel File

[Joshua Gallant]

I actually worked through it fine.  If 10 programmers attempted this the
code would be written 10 different ways but below is what I use.  This
works fine if the csv file is a "windows" version where lines end in a
LF:CR.  I need to adapt this to work with files generated on other systems.

In my case I'm working with descriptions that end up as HTML so I convert
the embedded characters to a line break "" sequence.  I use this to
get a full line and them dump that line through a parser that processes
the line.

- Josh

LINE.NUM = 0
LINE = ''
LAST.VAL = ''
IN.QUOTES = @FALSE

LOOP
WHILE READBLK VAL FROM D.PATH,1 DO
   BEGIN CASE
  CASE VAL = CHAR(13) AND NOT(IN.QUOTES)
 GOSUB PROCESS.LINE
 LINE = ''
  CASE VAL = '"' AND IN.QUOTES
 IN.QUOTES = @FALSE
 LINE := VAL
  CASE VAL = '"'
 IN.QUOTES = @TRUE
 LINE := VAL
  CASE VAL = CHAR(13) AND IN.QUOTES
 LINE := ''
  CASE VAL = CHAR(10) AND LAST.VAL = CHAR(13)
  CASE VAL = CHAR(10)
 LINE := ''
  CASE 1
 LINE := VAL
   END CASE
   LAST.VAL = VAL
REPEAT

IF LINE # '' THEN
   GOSUB PROCESS.LINE
   LINE = ''
END





On 2/9/12 11:55 AM, "Charlie Noah"  wrote:

Hi Josh,

I'd be happy to share my routines with you, if they would be of any use.
I have a program I use to load a csv file, and a subroutine which
converts back and forth between csv, dynamic and fixed width, either a
line at a time or an entire flat file.

Charlie

On 02-09-2012 10:44 AM, Joshua Gallant wrote:
> I was going to ask the same question about embedded line feeds.  I've
>been
> dealing with a lot of outside companies the last few months transferring
> data and found a lot have embedded line feeds all over.
>
> - Josh
>
>
>
>
>
> On 2/9/12 11:11 AM, "George Gallen"  wrote:
>
> Is it possible that the URL has an embedded lf at the end from entry on
> the source side?
>
> I've created csv files comma/quoted that contained URLs and were quite
> long and didn't have any issues importing
>Them into excel as a .csv , at least not as breaking into two lines.
>
> George
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> Sent: Thursday, February 09, 2012 11:06 AM
> To: U2 Users List
> Subject: Re: [U2] Building an Excel File
>
> Thanks George. I changed the tabs to pipes just to display them here.
> Normally I save as tab delimited with no surrounding character. Since
> the cell contents copies and pastes as 2 lines, I'm not sure whether
> these suggestions would solve my problem.
>
> Thanks again,
> Charlie
>
> On 02-09-2012 8:54 AM, George Gallen wrote:
>> Not sure if this helps...
>>
>> I noticed that you were showing pipe delimited lines...
>> If you rename your file from .csv to .txt
>>
>> Then from excel, you use the "Open" option, and then you can set the
>> delimiter to |
>>  And also change the column types before it imports it, or have it
>> skip a column as well.
>>
>> George
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
>> Sent: Thursday, February 09, 2012 9:46 AM
>> To: U2 Users List
>> Subject: Re: [U2] Building an Excel File
>>
>> While everyone is thinking about CSV and Excel, maybe I can get a
>> solution to a problem that's been plaguing me for a long time.
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] Linux / file create default permissions

[Joshua Gallant]

You do in fact want to look into the umask setting but 770 doesn't seem
correct since that would grant access to "other" but not the owner or
group.

 

- Josh

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Tuesday, June 16, 2009 12:20 PM
To: sjos...@sjplus.com; U2 Users List
Subject: Re: [U2] Linux / file create default permissions

 

Set the users umask in the .profile of their home directory. If all of
your users are part of a common group (as they should be) umask 770
should work

Susan Joslyn wrote: 

Greetings group.

Anyone know how to set an overall parameter so that files created in
Universe over Linux get r/w/x permissions?  We are having to chmod 777
after we create any file... want that to be the default.

 

Thanks!

 

Susan Joslyn

SJ+ Systems Associates, Inc.

PRC(r) Software life-cycle management and IT Governance for
U2/Multivalue

http://sjplus.com

 

 






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

 

-- 



Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com



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

[U2] XML mapping to multiple files & records

[Joshua Gallant]

Hi Folks,

 

Here's a scenario for you:

 

Let's say there is an XML file containing album & track data that we'd
like to import into 2 different Universe files. A sample layout might be
something like:

 



  











  







  

  







  



  



 

What I'm trying to do is have an ALBUMS file and a TRACKS file.  I want
a single record in the ALBUMS file for each album and a record in the
TRACKS file for each track.  Essentially every "album" record in the XML
will product one ALBUMS record and potentially multiple "TRACKS"
records.

 

The trouble I'm having is getting more than one TRACKS record.  I'm
wondering if anyone has ever tried this before and how their experience
went.  I end up with just one TRACKS record with the first iteration.
Is what I'm trying even possible?  I've opened a case with IBM as well
but figured maybe one of you has been in this situation before.

 

- Josh

 

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

Re: [U2] XML mapping to multiple files & records

[Joshua Gallant]

The scenario and sample I posted is theoretical.  The actual data
structure is much larger and has way too many nested levels.
Unfortunately splitting data is a must.

The two files piece is working fine it's just the multiple records in
the second file that's an issue.

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: Tuesday, June 23, 2009 1:42 PM
To: 'U2 Users List'
Subject: Re: [U2] XML mapping to multiple files & records

Why two files?  That would be the approach with a SQL type database, but
in
Universe, you can make the track data multi-valued related fields in the
albums file.

Larry Hiscock
Western Computer Services


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua
Gallant
Sent: Tuesday, June 23, 2009 10:38 AM
To: U2 Users List
Subject: [U2] XML mapping to multiple files & records

Hi Folks,

 

Here's a scenario for you:

 

Let's say there is an XML file containing album & track data that we'd
like to import into 2 different Universe files. A sample layout might be
something like:

 



  











  







  

  







  



  



 

What I'm trying to do is have an ALBUMS file and a TRACKS file.  I want
a single record in the ALBUMS file for each album and a record in the
TRACKS file for each track.  Essentially every "album" record in the XML
will product one ALBUMS record and potentially multiple "TRACKS"
records.

 

The trouble I'm having is getting more than one TRACKS record.  I'm
wondering if anyone has ever tried this before and how their experience
went.  I end up with just one TRACKS record with the first iteration.
Is what I'm trying even possible?  I've opened a case with IBM as well
but figured maybe one of you has been in this situation before.

 

- Josh

 

___
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] Mixed Case UV Basic Programming Standards.

[Joshua Gallant]

People use something other than ED?  For the most part, all programmers
on our staff do use the ED editor but there are a few of us who like the
functions like syntax highlighting, etc.  We code in all UPPER case
here.  We've had programs around for 30 years so the base programs were
always uppercase and we just stuck with it over the years.

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, June 25, 2009 5:59 AM
To: 'U2 Users List'
Subject: Re: [U2] Mixed Case UV Basic Programming Standards.

An important point there from Brian on editors, yes the editors we use
(no
one writes code in ed do they?) will colour highlight verbs, literals,
comments, variables etc + do case insensitive searches..




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: 25 June 2009 10:14
To: 'U2 Users List'
Subject: Re: [U2] Mixed Case UV Basic Programming Standards.

Hi

I use mixed case using the same capitalization as for Delphi and VB
(rather
than camelCase for C# and Java).

OpenSeq
NumberOfFields = DCount(SomeVariable, @FM)

However I use upper case to distinguish things that are 'special' e.g.
equate literals, file and select variables, common variables and
compiler
directives. That way they stand out. 

I also use upper case for STOP and the main RETURN from an external
subroutine, which helps to distinguish it from the Return from a local
GoSub.

I don't worry about searching since the editors I use are capable of
searching case-independently, and you can always write an IDescriptor to
do
an UPCASE(@RECORD) if you want to search in a source file. In fact,
generally I find doing a SELECT with a LIKE clause on that is faster
than
using the SEARCH command.

There should be no need to do anything special to format your comments
since
any editor worth using will distinguish these (as a bare minimum). I
have a
simple 'autodoc' markup in the comments that makes it easy to generate
technical docs. 

So, putting it all together:

PROGRAM ShowStuff
*-
*  @@Name: ShowStuff
*  @@Project : Demo
*   (other autodoc header info here)
*-
*  @@Info{
*Shows some stuff.
*And some other comments in here with HTML markups
*  }
*-
* (other autodoc comments here: modifications, keywords, todo etc.
*-
* version stamp goes in here - assigned to a variable so it compiles
into
* the object and I can then rip it from the string table.

VERDATA = "Version=001002003;"
VERDATA:= "VerDate=12345;"
VERDATA:= "VerDesc=Short Description here;"
(etc)

*-
$INCLUDE BOOK_TITLES.h

Open "BOOK_TITLES" To TITLES Else
   Crt "Cannot open the TITLES File"
   RETURN
End

Execute "SSELECT BOOK_TITLES", SELECT. > SLIST
Fin = @False
Loop
   ReadNext TitleId From SLIST Else 
 Fin = @True
   End
Until Fin Do
  GoSub ShowISBN
Repeat

RETURN

*--
*  ShowISBN: show the title id, ISBN and price
*--
ShowISBN:
  Read TitleRec From TITLES,TitleId Then 
 Crt TitleId, TitleRec,
OConv(TitleRec,"MD2")
  End
  Return


I find it much more legible, since I spent at least half of my life in
client languages. But I understand the point of view of those raised on
upper case only who don't use modern (grin) languages, and may initially
find it confusing. It's just a question of what you're used to.

Incidentally, this has evolved over the years. I started off upper case
(no
other choice back then), went to lower case in the 'C/UNIX' age, and
then
camelCase before settling on this style. When I go back to older code I
can
see that this one works best.


But the main thing is to be consistent with your style and use a good
editor.


Brian

___
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] XML mapping to multiple files & records

[Joshua Gallant]

Thanks for the responses.  I was trying to use the tools built into
UniVerse rather than parse through everything which I have done on past
projects.  I feel the XML.TODB program or the XMLTODB function should be
able to handle this no problem but seems to have an issue with multiple
records.  I tested this on multiple UniVerse levels including 10.3.0.

I ended up writing a program that uses an XMAP file and with a
combination of XMAPOPEN, XMAPREADNEXT, AND XMAPCLOSE I could get the
data into Universe.  Once in memory I had to do a little parsing and
cleanup but eventually ended up with something acceptable.

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M
Hunter
Sent: Thursday, June 25, 2009 3:57 PM
To: 'U2 Users List'
Subject: Re: [U2] XML mapping to multiple files & records

Call a subroutine that parses the data. I have done  it several times.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua
Gallant
Sent: Tuesday, June 23, 2009 10:49 AM
To: U2 Users List
Subject: Re: [U2] XML mapping to multiple files & records

The scenario and sample I posted is theoretical.  The actual data
structure is much larger and has way too many nested levels.
Unfortunately splitting data is a must.

The two files piece is working fine it's just the multiple records in
the second file that's an issue.

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: Tuesday, June 23, 2009 1:42 PM
To: 'U2 Users List'
Subject: Re: [U2] XML mapping to multiple files & records

Why two files?  That would be the approach with a SQL type database, but
in
Universe, you can make the track data multi-valued related fields in the
albums file.

Larry Hiscock
Western Computer Services


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua
Gallant
Sent: Tuesday, June 23, 2009 10:38 AM
To: U2 Users List
Subject: [U2] XML mapping to multiple files & records

Hi Folks,

 

Here's a scenario for you:

 

Let's say there is an XML file containing album & track data that we'd
like to import into 2 different Universe files. A sample layout might be
something like:

 



  











  







  

  







  



  



 

What I'm trying to do is have an ALBUMS file and a TRACKS file.  I want
a single record in the ALBUMS file for each album and a record in the
TRACKS file for each track.  Essentially every "album" record in the XML
will product one ALBUMS record and potentially multiple "TRACKS"
records.

 

The trouble I'm having is getting more than one TRACKS record.  I'm
wondering if anyone has ever tried this before and how their experience
went.  I end up with just one TRACKS record with the first iteration.
Is what I'm trying even possible?  I've opened a case with IBM as well
but figured maybe one of you has been in this situation before.

 

- Josh

 

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

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

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

Re: [U2] General guidelines on indexing

[Joshua Gallant]

0.1239 seconds running on a Solaris machine with UV 10.2.2 and 250 other
users.

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Thursday, July 09, 2009 1:56 PM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing

UD v7.2 on Dell 1435 server w/2GB RAM and 180 SATA  RAID 1 drive.

  s = ''
  z = STR('*', 1000)
  t1 = SYSTEM(12)
  FOR i = 1 TO 10
 s<-1> = z
  NEXT i
  t2 = SYSTEM(12)
  CRT t2 - t1 : " milliseconds."

-> RUN BP TEST
1625 milliseconds

Bill

Steve Romanow said the following on 7/9/2009 6:04 AM:
> IBM 2x1.8g power5 (i think) 100 users logged in
> 2.5 seconds
>
> Ron Hutchings wrote:
>> IBM BOX (OLDER)
>> PICK.FORMAT
>> 10.0.11
>> 6.9377 seconds
>>
>> Linux box
>> PICK.FORMAT
>> 10.2.0
>> 0.3522 seconds
>>
>>  
>>> Date: Thu, 9 Jul 2009 11:20:25 +0800
>>> From: adrian.wom...@rac.com.au
>>> To: u2-users@listserver.u2ug.org
>>> Subject: Re: [U2] General guidelines on indexing
>>>
>>>
>>> I just tried this example on Universe 10.2.6 - it took 0.0665
seconds -
>>> basically instant, can't complain about that.
>>>  
>>>
>>> -Original Message-
>>> From: u2-users-boun...@listserver.u2ug.org
>>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin
>>> Phillips
>>> Sent: Thursday, 9 July 2009 12:59 AM
>>> To: U2 Users List
>>> Subject: Re: [U2] General guidelines on indexing
>>>
>>>
>>> By way of a simple expample, I just tried the following program...
>>>s = ''
>>>z = str('*', 1000)
>>>t1 = time()
>>>for i = 1 to 10
>>>   s<-1> = z
>>>next i
>>>t2 = time()
>>>crt t2 - t1
>>>
>>> This took six seconds on QM but 32 minutes on UniVerse.
>>>
___
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] General guidelines on indexing

[Joshua Gallant]

It sounds to me like you guys are hitting a limit on the size of the
memory segment.  If that's true its tuned as a kernel parameter.  I'd
check there first and then try other ideas.  

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
Foerthmann
Sent: Friday, July 10, 2009 7:31 AM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing

Well, if it makes you feel better, my test crashed out with a similar 
error message as well.
The size shown was about half of what you had, otherwise the same
message.
UD 5.2 on Solaris 5.2 (I think).
I know it's old, but that's all they give me.

Symeon Breen wrote:
> Ok I am very jealous now of all these quick times, when my one crashed
out 
>
> Can someone remind me (its been years since i did any udt config
stuff) what
> should i be looking at to fix this error 
>
>
> Thanks
>
>
>
> PS - i like this thread i think this can be of benefit to people to
fine
> tune both code and their os and u2 configuration !
>
>
>
> -Original Message-
> From: Symeon Breen [mailto:syme...@gmail.com] 
> Sent: 09 July 2009 14:04
> To: 'U2 Users List'
> Subject: RE: [U2] General guidelines on indexing
>
> Unidata 7.1 (32bit) on redhat EL 3 64bit, on XEON E5335 with 4 gig
ram.
>
>
> Error when creating a shared memory segment (size=35682416), errno=22
>
>
>
> Lol
>
> Hmmm ?
>
>
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron
Hutchings
> Sent: 09 July 2009 13:40
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] General guidelines on indexing
>
>
> IBM BOX (OLDER)
> PICK.FORMAT
> 10.0.11
> 6.9377 seconds
>
> Linux box
> PICK.FORMAT
> 10.2.0
> 0.3522 seconds
>
>   
>> Date: Thu, 9 Jul 2009 11:20:25 +0800
>> From: adrian.wom...@rac.com.au
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] General guidelines on indexing
>>
>>
>> I just tried this example on Universe 10.2.6 - it took 0.0665 seconds
-
>> basically instant, can't complain about that.
>>  
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin
>> Phillips
>> Sent: Thursday, 9 July 2009 12:59 AM
>> To: U2 Users List
>> Subject: Re: [U2] General guidelines on indexing
>>
>>
>> By way of a simple expample, I just tried the following program...
>>s = ''
>>z = str('*', 1000)
>>t1 = time()
>>for i = 1 to 10
>>   s<-1> = z
>>next i
>>t2 = time()
>>crt t2 - t1
>>
>> This took six seconds on QM but 32 minutes on UniVerse. 
>>
>>
>>
>>
>> DISCLAIMER:
>> Disclaimer.  This e-mail is private and confidential. If you are not
the
>> 
> intended recipient, please advise us by return e-mail immediately, and
> delete the e-mail and any attachments without using or disclosing the
> contents in any way. The views expressed in this e-mail are those of
the
> author, and do not represent those of this company unless this is
clearly
> indicated. You should scan this e-mail and any attachments for
viruses. This
> company accepts no liability for any direct or indirect damage or loss
> resulting from the use of any attachments to this e-mail.
>   
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>> 
>
> _
> HotmailR has ever-growing storage! Don't worry about storage limits. 
>
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tut
oria
> l_Storage_062009
> ___
> 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 and triggers

[Joshua Gallant]

It seems okay to me.  What file type is the file you're trying to add
the trigger to?

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, July 10, 2009 3:20 PM
To: U2 Users List
Subject: [U2] UV and triggers

I need to setup a trigger on a Universe file to track changes to one
item.

The book is quite confusing on setting up triggers...
I understand how to compile the program (and read in the appropriate
data).

I just can't figure out how to get the trigger on the file to work

I tried

CREATE TRIGGER EMAILUPDT AFTER INSERT OR UPDATE OR DELETE ON N&ABTP FOR
EACH
ROW CALLING 'BTPEMAILTRIGGER' ;  (also tried unquoted)

which responds with statement triggers are not supported.

I'm on Universe 10.0.2 INFORMATION FLAVOR.
 RELLEVEL
001 X
002 10.0.2
003 INFORMATION
004 INFORMATION.FORMAT
005 10.0.2


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.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] UV global catalog in Pick flavour

[Joshua Gallant]

You just need to create a new voc item and copy of the contents from the
CATALOG voc item.  Change field 6 of the new voc item from PICK.FORMAT
to INFORMATION.FORMAT.  Here's what mine looks like:

0001 V 
0002 CATALOG   
0003 I 
0004 BDGZ  
0005 catalog   
0006 INFORMATION.FORMAT

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Friday, July 10, 2009 4:45 PM
To: U2 Users List
Subject: Re: [U2] UV global catalog in Pick flavour

I wanted to catalog a subroutine globally so that it could be accessed
by IBM .Net data provider for U2.  But the catalog routine does not
allow this in the PICK flavour of UniVerse.  Has anyone found a way
round this.

Regards

David Jordan
___
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] XMAP HTML encoding

[Joshua Gallant]

I'm trying to import an XML document that has some fields with HTML
character encoding using the XMAPOpen & XMAPReadNext commands.  The XML
parser is taking the HTML and trying to parse when we'd like it to be
left alone.  For example, é is being converted to
CHAR(195):CHAR(169) when we'd like to keep the é.  It seems to me
the data should be encapsulated in a CDATA section but the sender
doesn't seem to agree.  Anyone have any guidance for me?

 

- Josh

 

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

Re: [U2] XMAP HTML encoding

[Joshua Gallant]

You're a genius.  If I convert the & to & before parsing the file
the parser pulls it in perfect.

Thanks,

- Josh

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Wednesday, August 19, 2009 10:25 AM
To: 'U2 Users List'
Subject: Re: [U2] XMAP HTML encoding

Actually my mistake - the & is an xml entity and so should infact be
&
so the text should be &#233  this will then render to é




-Original Message-
From: Symeon Breen [mailto:syme...@gmail.com] 
Sent: 19 August 2009 15:21
To: 'U2 Users List'
Subject: RE: [U2] XMAP HTML encoding

é is not an xml entity - infact there are very few xml entities, so
putting this inside an element or an attribute is perfectly valid. No
need
for a CDATA

You may want to check your lang settings and the encoding of the xml to
make
sure they match.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua
Gallant
Sent: 19 August 2009 14:05
To: U2 Users List
Subject: [U2] XMAP HTML encoding

I'm trying to import an XML document that has some fields with HTML
character encoding using the XMAPOpen & XMAPReadNext commands.  The XML
parser is taking the HTML and trying to parse when we'd like it to be
left alone.  For example, é is being converted to
CHAR(195):CHAR(169) when we'd like to keep the é.  It seems to me
the data should be encapsulated in a CDATA section but the sender
doesn't seem to agree.  Anyone have any guidance for me?

 

- Josh

 

___
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] SSH & Viewpoint Emulation

[Joshua Gallant]

We use AnzioWin and it fits our needs very well.

- Josh

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caminiti,
Marc
Sent: Wednesday, September 02, 2009 4:15 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SSH & Viewpoint Emulation

Does anyone have any recommendations on a SSH client that has Viewpoint
Emulation?  We currently use Dynamic Connect, but do not think that it
has SSH.  

 

Thanks in advance

marc

 

Marc Caminiti

IS Manager

Nashbar Direct, Inc

6103 State Route 446

Canfield, OH 44406

330.533.1989, ext 336

330.702.9733, fax

 

Today's subliminal thought is:

 



CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain
confidential information that is legally privileged. The information is
solely for the use of the intended recipient(s). Any disclosure,
copying, distribution, or other use of this information is strictly
prohibited. If you have received this e-mail in error, please notify the
sender by return e-mail and delete this message.

___
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] U2 University 2009, Denver

[Joshua Gallant]

I'll be there as well.

-Josh

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Friday, September 11, 2009 7:15 PM
To: U2 Users List
Subject: Re: [U2] U2 University 2009, Denver

I won't be attending U2U but I will be hanging around the hotel for meetings on 
Thu.  Would love to put faces to the names.

On 9/11/09, Manu Fernandes  wrote:
> Hi,
> I'll be there.
>
> Manu.
>
> -Message d'origine-
> De : u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] De la part de Norman 
> Bauer Envoyé : vendredi 11 septembre 2009 21:40 À : 
> u2-users@listserver.u2ug.org Objet : [U2] U2 University 2009, Denver
>
> I look forward to meeting many of you there. I am really looking 
> forward to "Creating RESTful ADO.NET Data Services and Consuming Them 
> Using Silverlight, AJAX, and .NET Client" presented by Rajan Kumar.
>
> Norm
> ___
> 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
>


--
-Kevin
http://www.PrecisOnline.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] sending text messages to a regular cell phone

[Joshua Gallant]

I know you can send an alpha-numeric page to a pager via SNPP but I'm
not sure if it will work for a cell phone.  We do that in the case that
sendmail is having issues and backing up so an email can't get out.
There is a simple to use perl module.  We wrote a very simple perl
script to call the perl module from the command line.


#!/usr/bin/perl 
#
# This is a script that can be called from a shell script
# to send a message via Net::SNPP using variables passed
# in by the command line.
#
#
use Net::SNPP;
$snpp = Net::SNPP->new($ARGV[0], Debug => 0);
$snpp->send( Pager   => $ARGV[1],
 Message => $ARGV[2],
   ) || die $snpp->message;
$snpp->quit;


You simply pass the server address, pager number, and short message.

- Josh


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne
Ackerman
Sent: Thursday, November 05, 2009 3:09 PM
To: U2 Users List
Subject: Re: [U2] sending text messages to a regular cell phone

Any cell phone has an email associated with it so you can do it - I've 
set the same thing up here with unix sendmail.  For example, I use 
verizon wireless and if you send an email to me at 201xxx...@vtext.com 
it goes as a text message to my cell.
-Dianne

Barber, Bonnie wrote:
> We send ourselves alerts from some of our Universe processes via UNIX
sendmail.  We would like to be able to send some of the critical alerts
as text messages to our personal cell phones when there is no one around
to monitor emails.  Does anyone know if this is possible? The alerts
currently go to our company pager, however the pager is rotated through
our whole department and it is not always carried by someone who is
familiar with our Universe OM system so the alerts are ignored.
>
> Thanks in advance for your responses.
>
> Bonnie Barber
> Perseus Distribution | Senior Programmer, J-Cispub
> 731-988-3135 Direct   800-343-4499 ext. 178
> 731-988-4452 Fax
> "A smile is like a light in the window telling people you are home"
>
> ___
> 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] Paging protocols

[Joshua Gallant]

I've used SNPP before by passing arguments to a simple perl script which
uses the Net::SNPP perl module.  Below is a sample of the code in the
perl script and I call it with something like '/usr/bin/perl
/path/to/script/snpp.pl "$server" "$pager_num" "$message"'

- Josh


#!/usr/bin/perl 
#
use Net::SNPP;
$snpp = Net::SNPP->new($ARGV[0], Debug => 0);
$snpp->send( Pager   => $ARGV[1],
 Message => $ARGV[2],
   ) || die $snpp->message;
$snpp->quit;



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nick Gettino
Sent: Monday, December 07, 2009 3:34 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Paging protocols

Has anyone interfaced to  SS7 or SMPP (these are 2 paging protocols) to
send pages?  Using Unibasic on either Windows Server or IBM AIX on
UniData?
Thanks
Nick Gettino

Nicholas M Gettino - Director of Support & Professional Services |
EnRoute Emergency Systems an Infor Company, 401 E Jackson Street, Suite
1500, Tampa Florida 33602 | Office 813-207-6998 |Fax 678-393-5389
|nick.gett...@enroute911.com / www.enroute911.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] Soap error question

[Joshua Gallant]

I haven't worked a ton with SOAP requests but figured I'd throw this out
there any how...

Do you have a permissions error preventing a write?  It seems most of
what you've mentioned that's working are just reads but the one that
write is failing. 

 - Josh

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce
Sent: Friday, April 30, 2010 6:13 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Soap error question

Hi All,

 

We have a strange result happening with a simple soap service call and I
was
hoping someone has seen this problem or something like it before.

 

We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP & SSN.SUBMIT.
Each
program has 2 inputs: CUST.NO & SSN and 1 output: VERIFY.

 

The first one: SSN.VERF is a program on UniData that accepts Cust.No &
last-4 of SSN. The program then reads the customer record and validates
that
the last 4 of that customer's SSN match the 4 digits sent in the
transmission. If they match then it returns a 1 in the variable called
VERIFY. Otherwise, it returns a 0 (zero) in VERFIY.

 

SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and have
it
verified as well with the same VERIFY variable being passed back.

 

SSN.SUBMIT: Is for adding the SSN to the customer's record if it does
not
already exist. It checks for the existence in the record and in the
cross-reference file and returns 1 if the update was successful and zero
otherwise.

 

Now for the problem: SSN.VERF & SSN.VERF.SUP both work as expected.
SSN.SUBMIT appears to work when it is for an invalid entry (the SSN is
already on file) but whenever a valid SSN is entered for a customer with
a
blank SSN field it fails with a strange error message, like this:

 

http://schemas.xmlsoap.org/soap/envelope/";
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>

 

 

  Exception: Internal Web Service Server
Error 

 

 

  Exception: Internal Web Service Server Error 

 

 

 

 



 

Can anyone suggest how we could debug this problem? Is there a way to
capture whatever it is that is freaking out the soap process?

 

TIA,

Bruce Lunt

___
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] CDATA in XML

[Joshua Gallant]

Hi folks,

I tried posting this on the u2ug forum but it seems more folks use email than 
check the forum so figured I'd try here.

I'm looking for a way to use the XMAP functions within UniVerse to 
import/export documents using a CDATA field instead of the default encoding 
UniVerse does.  Does anyone know of a way to use a XMAP and get this output:





instead of this output:


content goes here & < > " 


I can write some type of wrapper program if needed but I'm wondering if someone 
has found something built in.

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

RE: [U2] Speeding up processing through large dynamic table

[Joshua Gallant]

When running through an array with a for next loop the last item
processed isn't remembered so the program needs to traverse the entire
array for each record and will slow down as you get to records later in
the process.

Instead of this:

A11 = DCOUNT(IN.TAB,@AM)

FOR A1 = 1 TO A11
  IN.LINE = IN.TAB
  SWAP @VM WITH @AM IN IN.LINE
  CUST.NUM  = IN.LINE<1>
  CUST.DESC = IN.LINE<2>
NEXT A1

Try something like this instead:

LOOP
REMOVE IN.LINE FROM IN.TAB SETTING MARK
  SWAP @VM WITH @AM IN IN.LINE
  CUST.NUM  = IN.LINE<1>
  CUST.DESC = IN.LINE<2>
WHILE MARK DO
REPEAT

That will keep track of where you were in the array and pick up where
you left off.

Let me know how that works out for you.

Thanks,
Josh


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Laansma
Sent: Monday, November 17, 2008 1:10 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Speeding up processing through large dynamic table

Is there a way to speed up spinning through a very large dynamic table?
Here is
a sample of my program:

A11 = DCOUNT(IN.TAB,@AM)

FOR A1 = 1 TO A11
  IN.LINE = IN.TAB
  SWAP @VM WITH @AM IN IN.LINE
  CUST.NUM  = IN.LINE<1>
  CUST.DESC = IN.LINE<2>
NEXT A1

A11 is 85,000+ and as this loop goes on, this thing get really slow.
Any tips
on speeding this up?
---
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] U2 University 2009 Schedule

[Joshua Gallant]

I have no link with dates but this was in the recent U2 news flash
email:

" U2 University Planning Status 

As reported earlier in this News Flash, the U2 Team is hard at work on
U2 University 
2009. Current status is as follows:

Denver, USA, September 16-18, 2009 -- Confirmed!
Liverpool, UK, October 13-15 -- Confirmed!
Sydney, Australia, November 17-19 -- In Process

Please note that we've moved the Denver event back one day. We hope to
confirm Sydney 
shortly, at which time we'll let you know how to register. We'll also
publicize the agenda 
once it's been finalized."

- Josh


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Wednesday, April 15, 2009 11:54 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] U2 University 2009 Schedule

I've been searching the IBM U2 site for the 2009 U2 University sites and

schedule with no success. Can anyone provide a link? 

Thanks
-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

---
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] 81003 uvrpc error

[Joshua Gallant]

I'd start with the basics.  First check for the process to be running
(ps -ef | grep unirpc) and then for it to be listening on the port
(netstat -an | grep 31438).  I deal mainly with Solaris so the commands
may be slightly different for linux but should be close.

- Josh


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: Monday, April 20, 2009 11:31 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] 81003 uvrpc error

I am getting the below error message and I'm wondering if it has to do 
with the personal edition of universe?

81002 UVRPC_NO_CONNECTION Connection is down.

I think I have everything setup (this is running on a linux system) so I

have

/etc/services with

uvrpc   31438/tcp   # uvNet rpc port

I have an entry in xinetd.d called uvrpc

service uvrpc
{
instances   = 10
socket_type = stream
wait= no
user= root
server  = /usr/ibm/unishared/unirpc
nice= 10
disable = no
}

yet when I try to connect I get the above error.  Rex (the developer of 
u2pipe) has been super helpful but I don't want to take advantage of his

kindness so I am sending this out to the list instead.

dougc
---
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] Question on UniVerse VOC record for CREATE.FILE

[Joshua Gallant]

The LONGNAMES command will update certain VOC records (CREATE.FILE,
DELETE.FILE, CNAME, & CREATE.BFILE) so they will work with long file
names properly.  Certain fields are updated with the necessary data when
that command is used that can be missed if modified manually.  For the
CREATE.FILE command it will add "LONGNAMES" to field 5 and change field
4 to either "V" or "FV" if the field previously had an "F" somewhere in
it.

It appears to me that someone manually modified the record in the
NEWACC,PICK file on your system instead of using the LONGNAMES command.
The proper command to update the records in the NEWACC file would be
"LONGNAMES ON NEWACC"

- Josh

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Doug Farmer
Sent: Thursday, April 23, 2009 5:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Question on UniVerse VOC record for CREATE.FILE

I am mainly a UniData person, so UniVerse is a bit foreign to me.

I am running UniVerse on a Windows Platform.

Using the CREATE.FILE command, I created a file with a long name (15
characters) with my standard VOC pointer, and the VOC pointer in the
UV\NEWAC,PICK file.

Using the CREATE.FILE verb in my VOC, I am able to create the file
correctly.  Using the verb as it is on the NEWAC,PICK file, it truncates
the file name.  This, even though the LONGNAMES is on.  See the examples
at the end of the E mail.

My VOC entry looks like

>AE VOC CREATE.FILE
Top of "CREATE.FILE" in "VOC", 6 lines, 40 characters.
*--: L22
001: V
002: create.file
003: E
004: VF
005: LONGNAMES
006: PICK.FORMAT
Bottom.
*--:

The NEWACC\PICK file verb looks like this (After I copy it to my VOC and
set LONGNAMES)
>AE VOC PICK-CREATE-FILE
Top of "CREATE.FILE" in "VOC", 6 lines, 40 characters.
*--: L22
001: V
002: create.file
003: E
004: FG
005: LONGNAMES
006: PICK.FORMAT
Bottom.
*--:

The only difference is attribute 4 which has an FG instead of VF in it.
I have no idea what FG vs VF is.

You may wonder why I am asking?  I have an old application that creates
files specifically using the PICK version, no matter what the VOC
version is.

I don't know why, is there a difference?

The only difference I know of is that LONGNAMES do not seem to work
under the PICK version.

Any ideas?

Thanks in Advance

Doug


Using PICK-CREATE-FILE

>PICK-CREATE-FILE DAF1234567890123456 1,1,18 1,1,19
WARNING: An operating system file will be created with a truncated name.
Creating file "DAF123456000" as Type 19.
Creating file "D_DAF123456000" as Type 18, Modulo 1, Separation 1.

Using CREATE-FILE
>CREATE.FILE DAF123456789012345 1,1,18 1,1,19
Creating file "DAF123456789012345" as Type 19.
Creating file "D_DAF123456789012345" as Type 18, Modulo 1, Separation 1.
Added "@ID", the default record for RetrieVe, to "D_DAF123456789012345".


This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses. Any views
and/or opinions expressed in this e-mail are of the author only and do
not represent the views of Epicor Software Corporation or any other
company within its group.
---
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] How do you do a NOPAGE on a SELECT?

[Joshua Gallant]

Couldn't you just use HUSH before doing the select to suppress the
output?

- Josh


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, April 24, 2009 2:22 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] How do you do a NOPAGE on a SELECT?

ok...(UV 10 )

I'm doing the following:

SELECT FILE1 SAVING VARB1  (PICK format SELECT - to allow multivalued
SAVING)
SELECT FILE2
SAVE-LIST XX

Problem is when there are VARB1 items in FILE1 that are not valid ID's
in
FILE2
   the SELECT FILE2 displays all the ID's that are not valid ID's.

If I'm typing the commands, no problem...just hit 'n', however, if I put
them
in a VOC, and execute the VOC from a program, the operator has to hit
'n'.

What would be nice would be if there was a NOPAGE, or a HUSH option to
SELECT.

My workaround is:

SELECT FILE1 SAVING VARIB1 TO 1
SELECT FILE2 TO 2
MERGE.LIST 1 INTERSECT 2
SAVE-LIST XX

George
---
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] Help with sockets

[Joshua Gallant]

Hi Folks,



Maybe one of you can help...



Let's assume I'm writing a piece of client software to connect to a
server using the basic socket calls & simply dump data through a port
and receive a response back.  Let's also assume the server shuts down
mid process and sends a FINACK packet to the client.  From what I've
seen it would appear the proper response is for the client to respond
with an ACK and then a FINACK to close the connection down.



First off, is this the correct communication for shutdown in the event
the server dies.



Secondly, does anyone know how the client software (written in BASIC)
can be aware of the FINACK from the server?  I tried the
getsocketinformation() function run against the peer side but it just
tells me the socket is open.  It seems I need the software to know the
server wants to shut down so that I can issue the closesocket() call.
I'm assuming the closesocket() call is sending a FINACK packet.  Is this
true?



Anyone have any insight for me?



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

RE: [U2] Help with encryption

[Joshua Gallant]

I know someone already mentioned it but since there are so many
responses trying to do something more difficult I figured I'd throw it
out there again.

Won't the DIGEST() function do what you're looking for?

- Josh

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen
Sent: Tuesday, May 12, 2009 5:17 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Help with encryption

Thanks. These seem to only handle symmetrical encryption, not one-way
hashing
(like MD5), but maybe I am missing something. Still reading...!

Laure Hansen,
City of Redwood City - Information Technology
1017 Middlefield Road - Redwood City, CA 94063
Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204
lhan...@redwoodcity.org

o
 Please think green before printing this e-mail

Subscribe to receive Redwood City E-News, news releases,
or other documents via email: Click here to register/subscribe


-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Greer
Sent: Tuesday, May 12, 2009 12:43 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Help with encryption

I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref.

-Original Message-
From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org]
Sent: Tuesday, May 12, 2009 2:48 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Help with encryption


Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on
Win2003
server. I am hoping for a Basic command that I can run on a desired
piece of
data. Reading documentation so far hasn't helped, am I wanting to do
something
that is not available to me?

Thanks in advance!

Laure Hansen,
City of Redwood City - Information Technology
1017 Middlefield Road - Redwood City, CA 94063
Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204
lhan...@redwoodcity.org

P Please think green before printing this e-mail

Subscribe to receive Redwood City E-News, news releases,
or other documents via email: Click here to
register/subscribe
---
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://listserver.u2ug.org/