Re: [U2] PERL regular expression interpreter in UV Basic?

[George Gallen]

Have you considered just trying to do your regexp through AWK or PHP? 

> On May 13, 2014, at 6:05 PM, "Ken Ford"  wrote:
> 
> Hello U2 Users.
> I have been using a UV Basic function I call REGEXP that takes a text string 
> and a PERL formatted regular expression and executes a PERL script and 
> returns a matched string if found.  The problem is that it can't handle some 
> of the things in strings that are passed to it and PERL bombs.
> Because of this, I am in the midst of writing a UV Basic interpreter of PERL 
> regular expressions, which is an interesting challenge.  I checked via google 
> search for any such UV Basic program already out there, but found none.  So I 
> am curious to know if anyone has done this, and if so, would care to share 
> the code.
> Thanks to anyone who can assist.
> 
> Ken Ford.
> Firstmac Ltd
> Brisbane, Australia.
> 
> ---
> Note: 
> This email (inc all attachments) is for the use of the intended recipient(s) 
> only.
> Privileged or confidential information may be contained in this 
> communication. If you have received this email in error, please notify the 
> sender immediately and then delete all copies of this message from your 
> computer network. If you are not the intended recipient, you must not keep, 
> use, disclose, copy or distribute this email without the author's prior 
> permission. If you are the intended recipient and you do not wish to receive 
> similar electronic messages from us in future, then please respond to the 
> sender to this effect. 
> We have taken precautions to minimise the risk of transmitting software 
> viruses, but advise you to carry out your own virus checks on this email and 
> its attachments. We do not accept liability for any loss or damage caused by 
> software viruses and do not represent that this transmission is free from 
> viruses or other defects. 
> Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) 
> ---
> ___
> 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] Web services at 11.x

[George Gallen]

As far as I know - it's just consumes.

We use a different system for serving - which is XML based and a combination of 
PERL and linux script.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 13, 2014 1:59 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Web services at 11.x


Wget however only works to pull pages in correct?
You can't actually communicate both ways.
 
 
 
-Original Message-----
From: George Gallen 
To: U2 Users List 
Sent: Tue, May 13, 2014 10:56 am
Subject: Re: [U2] Web services at 11.x


We use wget on 10.0.2 / linux  - works but setting up the header lines
Is kludgy.  But since it works we havn't migrated to curl yet.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of Richard Lewis
Sent: Tuesday, May 13, 2014 1:53 PM
To: U2 Users List
Subject: Re: [U2] Web services at 11.x

We have been using a SOAP interface on 10.2 or 10.3 (I forget now which)
and are now on 11.1.  We have also successfully used curl to from within UV
to interact with a web service on 11.1, on linux.

Richard Lewis



On Tue, May 13, 2014 at 11:10 AM, Oaks, Harold wrote:

>
> I have been telling my manager (an Oracle-centric guy) that with Universe
> 11+  (we have 10.2 now) the web services will truly allow us to do input
> and output interfacing with other web services.  I need to make sure this
> is a correct understanding.
>
> It is clear from the Web Services manual that one can create a web service
> (a SOAP service) which will allow outside queries and return data.  I write
> to this list to ask those of you who know that it is possible to do the
> other way, that from Universe you are able to connect to outside web
> services, send queries to them, and get back responses.  Because I don't
> see this in the Web manual.
>
> If the latter is not possible via the Web services capabilities built into
> Universe, how are any of you doing it?  Do you need a 3rd-party product?
>
> Here is the data need:  We are to interface our Jail system to another
> system via an ESB (electronic services bus) via 'web services', passing XML.
>
> Thanks-
> Harold Oaks
> Clark County, WA
>
> --
> This e-mail and related attachments and any response may be subject to
> public disclosure under state law.
> ___
> 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] Web services at 11.x

[George Gallen]

We use wget on 10.0.2 / linux  - works but setting up the header lines
Is kludgy.  But since it works we havn't migrated to curl yet.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis
Sent: Tuesday, May 13, 2014 1:53 PM
To: U2 Users List
Subject: Re: [U2] Web services at 11.x

We have been using a SOAP interface on 10.2 or 10.3 (I forget now which)
and are now on 11.1.  We have also successfully used curl to from within UV
to interact with a web service on 11.1, on linux.

Richard Lewis



On Tue, May 13, 2014 at 11:10 AM, Oaks, Harold wrote:

>
> I have been telling my manager (an Oracle-centric guy) that with Universe
> 11+  (we have 10.2 now) the web services will truly allow us to do input
> and output interfacing with other web services.  I need to make sure this
> is a correct understanding.
>
> It is clear from the Web Services manual that one can create a web service
> (a SOAP service) which will allow outside queries and return data.  I write
> to this list to ask those of you who know that it is possible to do the
> other way, that from Universe you are able to connect to outside web
> services, send queries to them, and get back responses.  Because I don't
> see this in the Web manual.
>
> If the latter is not possible via the Web services capabilities built into
> Universe, how are any of you doing it?  Do you need a 3rd-party product?
>
> Here is the data need:  We are to interface our Jail system to another
> system via an ESB (electronic services bus) via 'web services', passing XML.
>
> Thanks-
> Harold Oaks
> Clark County, WA
>
> --
> This e-mail and related attachments and any response may be subject to
> public disclosure under state law.
> ___
> 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] Read yourself

[George Gallen]

Unless I'm doing it wrongdidn't look it up.

For me - on UV 10.0.2

PRINT SYSTEM(9001)
STOP
END

Outputs

>RUN LIB TEST
0

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 13, 2014 1:55 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Read yourself


I had posted an update, that I had tried it (it returns the program stack)
Its System(9001), and it will return the subroutine names in the stack as well 
as the main program (on Universe 11 anyway)
 
Someone has to try this on Unidata, and on D3 to make sure it also returns the 
subroutine name.
 
What it returns is the absolute path, so you would still need a program to 
translate this into a LOCAL file name and program id, which is, to what, I'm 
trying to get.
 
Like I mentioned, I'm sure there is a way to do it, it's just a question of 
whether someone has a routine which *does* this already, and the answer is 
apparently not, so if I have to roll my own.
 
 
-Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Tue, May 13, 2014 10:40 am
Subject: Re: [U2] Read yourself


Does the 9001 call work for subroutines, or just the main program?

Also, it's platform specific

It all depends on what your trying to do, if the 9001 call works, great, if not 
figure something else out.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of Wjhonson
Sent: Tuesday, May 13, 2014 1:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Read yourself


Well do you see any problem in just using the SYSTEM(9001) and ignoring 
embedding this information ?
 
 
 
 
-Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Tue, May 13, 2014 10:27 am
Subject: Re: [U2] Read yourself


Then you would need to write another program that scans the programs and checks 
if the VERDATA element
For the program name matches the @ID in the program file - if not email someone 
to fix it.

Then have it run nightly - so if it did get cloned without changing, it 
wouldn't 

be that way 
For long.

George


___
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] Read yourself

[George Gallen]

Does the 9001 call work for subroutines, or just the main program?

Also, it's platform specific

It all depends on what your trying to do, if the 9001 call works, great, if not 
figure something else out.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 13, 2014 1:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Read yourself


Well do you see any problem in just using the SYSTEM(9001) and ignoring 
embedding this information ?
 
 
 
 
-Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Tue, May 13, 2014 10:27 am
Subject: Re: [U2] Read yourself


Then you would need to write another program that scans the programs and checks 
if the VERDATA element
For the program name matches the @ID in the program file - if not email someone 
to fix it.

Then have it run nightly - so if it did get cloned without changing, it 
wouldn't 
be that way 
For long.

George


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

Re: [U2] Read yourself

[George Gallen]

Actually, expounding on that. You could have a program insert the program and 
file name into a program

Not recompile - just the source

Then as you get a chance to modify each program to become self aware (the first 
step to 
Activating the MATRIX) then you would compile/catalog.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, May 13, 2014 1:27 PM
To: U2 Users List
Subject: Re: [U2] Read yourself

Then you would need to write another program that scans the programs and checks 
if the VERDATA element
For the program name matches the @ID in the program file - if not email someone 
to fix it.

Then have it run nightly - so if it did get cloned without changing, it 
wouldn't be that way 
For long.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 13, 2014 1:13 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Read yourself


This can be broken simply by copying the program to some other location, 
without changing the variables.
 
 
 
-Original Message-
From: Robert 
To: U2 Users List 
Sent: Tue, May 13, 2014 9:58 am
Subject: Re: [U2] Read yourself


Awesome feature Ross that you have in your Stamina product.

Is there a link to an article, example, or manual describing it in detail?

That way I can forward it to any Universe client inquiring about those 
features.


I have seen Brian Leach's source code and he has the program information 
embedded in a variable like this:

.
.
.
*
* Modification History
* ---
VERDATA=''
VERDATA := 'Version=001009003;'
VERDATA := 'VerModVer=00100;'
VERDATA := 'VerBeta=;'
VERDATA := 'VerDate=15134;'
___
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] Read yourself

[George Gallen]

Then you would need to write another program that scans the programs and checks 
if the VERDATA element
For the program name matches the @ID in the program file - if not email someone 
to fix it.

Then have it run nightly - so if it did get cloned without changing, it 
wouldn't be that way 
For long.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, May 13, 2014 1:13 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Read yourself


This can be broken simply by copying the program to some other location, 
without changing the variables.
 
 
 
-Original Message-
From: Robert 
To: U2 Users List 
Sent: Tue, May 13, 2014 9:58 am
Subject: Re: [U2] Read yourself


Awesome feature Ross that you have in your Stamina product.

Is there a link to an article, example, or manual describing it in detail?

That way I can forward it to any Universe client inquiring about those 
features.


I have seen Brian Leach's source code and he has the program information 
embedded in a variable like this:

.
.
.
*
* Modification History
* ---
VERDATA=''
VERDATA := 'Version=001009003;'
VERDATA := 'VerModVer=00100;'
VERDATA := 'VerBeta=;'
VERDATA := 'VerDate=15134;'
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] stop

[George Gallen]

Silence
The
Outputing
Program


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Friday, May 09, 2014 12:01 PM
To: U2 Users List
Subject: Re: [U2] stop

State
Trooper
Out
P1$$ing


On 05-09-2014 10:56 AM, Allen Egerton wrote:
> Slight
> Tap
> On
> Pedal
> 
>
> Je ne comprends pas.
>
> (Allen - Sent from my paperweight)
>
>> On May 9, 2014, at 11:52 AM, Jerry Neff  wrote:
>>
>> stop
>>
>> Jerry L Neff,
>> Programmer/Analyst - IS
>> State Center Community College District
>> Phone (559) 244-5952
>> Fax (559) 222-9954
>> jerry.n...@scccd.edu
>>
>>
>> ___
>> 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] stop

[George Gallen]

Drop and Roll?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry Neff
Sent: Friday, May 09, 2014 11:52 AM
To: 'U2-Users@listserver.u2ug.org'
Subject: [U2] stop

stop

Jerry L Neff,
Programmer/Analyst - IS
State Center Community College District
Phone (559) 244-5952
Fax (559) 222-9954
jerry.n...@scccd.edu


___
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] [OT] My XML is Chinese!?!

[George Gallen]

It's not as much for editing XML, which I use a different editor for.

But more to verify what is being displayed in IE is what was sent, since IE 
tweeks and consolidates XML
   Before it displays it during it's validation.   (ie.   it will change 
 to 

I use IE for because it's quicker to test xml files that are not local to the 
computer and are online.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus
Sent: Friday, May 09, 2014 10:15 AM
To: U2 Users List
Subject: Re: [U2] [OT] My XML is Chinese!?!

I suspect I know what is happening, though I can't tell you WHY.

The view source function is using an encoding that doesn't match your
actual file. For example the view source may think its using UTF-16 for
some reason, but since its really using UTF-8 the characters are all
mangled.  Its just a guess.  I would recommend saving the file to disk and
the  use another editor like notepad++ which can tell you what the file
encoding is.  This is likely just a bug in IE 11.

There are so many better editors out there for xml data, I would just use
one of those instead.





On Fri, May 9, 2014 at 10:05 AM, George Gallen wrote:

> OKI've got a strange thing happening on my Win 7 IE 11
>
> If I use IE 11 to open an XML file - it renders fine - no problems.
> BUT...if I right click and choose View Source - all I see are Chinese
> characters?
>
> I know the XML is plain text and no extended codes
>
> And it only happens on my machine, if I use another PC same setup (except
> IE 9)
>It shows English when you view Source
>
> HTML renders fine, and View Source for HTML displays English.
>
> My XML declaration line looks like:
>
> 
>
> Firefox view source displays English,  as does Chrome and Safari - It's
> just IE11 doing it.
>
> 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [OT] My XML is Chinese!?!

[George Gallen]

Ok partially solved this.

I changed the program that IE11 uses to edit html from default to notepad
And now it works - displays in English

However, when I went back to change back to default - default wasn't an option

Wonder if this was something from when I last upgraded (if you can call it 
that) from IE10 to EI11

Oh well...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, May 09, 2014 10:05 AM
To: U2 Users List
Subject: [U2] [OT] My XML is Chinese!?!

OKI've got a strange thing happening on my Win 7 IE 11

If I use IE 11 to open an XML file - it renders fine - no problems.
BUT...if I right click and choose View Source - all I see are Chinese 
characters?

I know the XML is plain text and no extended codes

And it only happens on my machine, if I use another PC same setup (except IE 9)
   It shows English when you view Source

HTML renders fine, and View Source for HTML displays English.

My XML declaration line looks like:



Firefox view source displays English,  as does Chrome and Safari - It's just 
IE11 doing it.

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

[U2] [OT] My XML is Chinese!?!

[George Gallen]

OKI've got a strange thing happening on my Win 7 IE 11

If I use IE 11 to open an XML file - it renders fine - no problems.
BUT...if I right click and choose View Source - all I see are Chinese 
characters?

I know the XML is plain text and no extended codes

And it only happens on my machine, if I use another PC same setup (except IE 9)
   It shows English when you view Source

HTML renders fine, and View Source for HTML displays English.

My XML declaration line looks like:



Firefox view source displays English,  as does Chrome and Safari - It's just 
IE11 doing it.

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

Re: [U2] Rgarding ED editor

[George Gallen]

Nobody is arguing that GUI editors are not useful, I'm just saying that ED/AE is
The default editor - just because it's not as robust, doesn't mean it shouldn't
Be learned. I learned the ED on Reality, and had no problem when I used AP / D3
And Prime Information and then Universe - it was almost a standard - that is why
It should be learned. All the reasons you mention really don't matter if all 
Your doing is entering some test data, or doing a quick look at a VOC entry.

Nothing more to read into it

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Thursday, April 17, 2014 10:50 AM
To: U2 Users List
Subject: Re: [U2] Rgarding ED editor

I've been doing Eclipse IDE a lot longer than everybody else.  I'm not
bragging here: U2logic was the first with an editor that ran within Eclipse
IDE for Universe and Unidata in 2004.

I would have to save that I have updated many VOC items from XLr8Editor
Eclipse.  But that is not really point I have made in all of these years
trying to explain this technology.  If the U2 database environment is to
survive and grow, all of us programmers have to look like other programmers
in the world.  Very few of us should be using line by line editors for any
reason.

I firmly believe that the ED/AE should be removed from the database not
because the tools are not useful, but because it detracts from what can be
accomplished within the U2 environment.  When I'm at a client, or doing a
web demo, I have Eclipse running with code showing to showcase that U2 is
not a legacy technology.

When I'm coding and somebody who does not know U2 they can see these to
name few things:

   1. the code compiling on the spot
   2. built-in version control
   3. copy and paste capability
   4. dictionary editing in a grid
   5. an outline with all the variables and their respective line numbers
   6. code completion on my code variables
   7. a local search engine to look for U2 variables or subroutines
   8. a local search for just strings using regular expressions
   9. The ability to have multiple sessions open and manage those sessions
   10. The ability to sync your local storage with the database with a
   single click

Those people have a better feeling about the technology they purchase then
seeing some typing "OOPS" or "C/oldvariable/newvarable/g".

Regards,
Doug
www.u2logic.com/tools.html
"XLr8Editor saves time for U2 programmers"


On Thu, Apr 17, 2014 at 8:16 AM, George Gallen wrote:

> Doug,
>
> I totally disagree!  Yes, once you get used to a GUI editor, ED/AE can be
> tough, but it has it's merits too.
>
> One, it's quick - it's ALWAYS available.
>
> Would you honestly invoke a GUI editor to make a quick change to a VOC
> entry?
>
> It's a tool of the trade - it needs to be a required learn
>
> George
___
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] Rgarding ED editor

[George Gallen]

Doug, 

I totally disagree!  Yes, once you get used to a GUI editor, ED/AE can be 
tough, but it has it's merits too.

One, it's quick - it's ALWAYS available.

Would you honestly invoke a GUI editor to make a quick change to a VOC entry?

It's a tool of the trade - it needs to be a required learn

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Thursday, April 17, 2014 9:18 AM
To: U2 Users List
Subject: Re: [U2] Rgarding ED editor

If you are trying to use ED or AE in Universe or Unidata these are line by
line editors.   If someone is new to U2 then this is a bad move to try and
teach them something so archaic.

Regards,
Doug
www.u2logic.com/tools.html
"The only Eclipse editor with continuous compile technology"


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

Re: [U2] SpreadsheetML and Excel2013

[George Gallen]

I dropped down to the C:\ prompt, then negotiated to the Content.MSO folder 
(since I couldn't find it in
The Temporary Internet Files folder!) - but the error file that it referred to 
existed, but was blank.

Initially it said the file was corrupt - Which apparently if save as from email 
, you can right click
And properties on it, and uncheck unlock property - that will get it past the 
corrupt message.

Then it kept giving me XML errors in the  node - which after looking and 
looking finally jumped
Out at me - it's wasn't a corrupt XML , it was invalid based on the schema - I 
had type that was "numeric"
But the data was alpha numeric.

Funny, once I fixed the XML to be valid, I no longer had to unlock it and could 
open it from the email
Without getting the file corrupt error.

So, I guess it scans the XML, if it's invalid, it throws the corrupt error 
unless the file is set for
Unlock status.

UuughWhy can't it just say data type mismatch found in XML data?

I think when I first created my routine, it was using Excel 2010 - which might 
not have been so
Strict on the XML being invalid for that reason, and it worked. I guess I was 
taking advantage
Of it's good naturedness - and Excel 2013 was just being a hardass..

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, March 24, 2014 3:05 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SpreadsheetML and Excel2013

George, if you're seeing the "Problems During Load dialog", the error might 
refer to the Content.MSO folder:
C:\Users\username\AppData\Local\Microsoft\Windows\Temporary Internet 
Files\Content.MSO

(on older systems that might be c:\WinTemp\Temporary Internet Files\Temporary 
Internet Files\Content.MSO)

From the NebulaXLite Developer Guide page 49: 

"The Content.MSO directory is hidden.To get to the file, use Windows Explorer to
get to the Temporary Internet Files folder, then in the address bar manually
type “Content.MSO”.A list of files
should display.(All files except the most recent can be deleted.)"

XML files from v2003 "should" certainly be compatible with v2013. However, 
there are at least two kinds of XML out there. There is the SpreadsheetML and 
then there is a newer Open format which has been in transition over the years. 
It's possible though unlikely that v2013 has some detail "fixed" that an older 
version of Excel (or related tools) embedded into your documents. Without more 
information I couldn't make any other guesses.

[ad] Relevant to MV/U2, NebulaXLite generates full Excel workbooks with rich 
sheets all from BASIC:

http://Nebula-RnD.com/products/xlite.htm


HTH
Tony Gravagno, Nebula Research and Development   
http://Nebula-RnD.com/blog     
http://Twitter.com/TonyGravagno      
http://www.LinkedIn.com/in/TonyGravagno     
Visit http://PickWiki.com!
Contribute!

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

Re: [U2] [WARNING : MESSAGE ENCRYPTED]RE: SpreadsheetML and Excel2013

[George Gallen]

Another quick way (if your on windows) to explore the XML - is save the file to 
your desktop (or wherever),
Give it an .xml extension.

Then open IE - and (f)ile - Open and then open the file

If it opens it's valid as XML goes - I don't know if you reference a schema 
inside, if IE will then load
   The schema and validate the XML against it - didn't try that.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Van Rooyen, C. 
(Christo)
Sent: Tuesday, March 25, 2014 2:32 AM
To: U2 Users List
Subject: [U2] [WARNING : MESSAGE ENCRYPTED]RE: SpreadsheetML and Excel2013

Hi George,



What I do is to explore the XML file. I added a program that will expand the 
xml code to be one instruction per line. It also indent the code for easy 
reading. It is a windows VB6 program, so good luck to run it on Win8 or Win7. 
Set you User Account Control level to allow you to run it.



Rename the .txt output back to an .xml and then try to open the XML. It sould 
give you a line number of the error. This help me to find the bugs. Mostly it 
is unicode characters in the data.



Sometimes I create a sample spreadsheet and save it as an XML document. Then 
parse it trought the ExpandXML program and the explore the code.



SUBROUTINE UNICODE(MYSTRING)

**

* AUTHOR: Christo Van Rooyen

*   DATE: 06/08/2008

*

**

***   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "&"  , "&"  , MYSTRING)

***   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "<"  , "<"   , MYSTRING)

***   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( ">"  , ">"   , MYSTRING)

***   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( CHAR(34) , """ , MYSTRING)

***   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "'"  , "'" , MYSTRING)

**

   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "&" , "\&" , MYSTRING)

   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "<" , "\<" , MYSTRING)

   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( ">" , "\>" , MYSTRING)

   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( '"' , '\"' , MYSTRING)

   CALL "TCLPLUS,TCLPLUSBP, REPLACE.STRING"( "'" , "\'" , MYSTRING)

   RETURN

**



Groete, Regards,

Christo van Rooyen

GT - Systems Analyst / Designer II

Nedbank Ltd

Mobile: +27 82 925 6301

Office: +2712 436 7264

Location: MenLyn Maine Pretoria - 3'rd Floor - Desk 265



-Original Message-----
From: George Gallen [mailto:ggal...@wyanokegroup.com]
Sent: 24 March 2014 08:00 PM
To: U2 Users
Subject: [U2] SpreadsheetML and Excel2013



Is anyone else having issues with Excel2013 giving errors to previously working 
XML files from Excel2003



It keeps telling me there is an error in the table, and says there is log file, 
which is blank - not helpful.



George



George Gallen

Senior Programmer/Analyst

Accounting/Data Division, EDI Administrator 
ggal...@wyanokegroup.com<mailto:ggal...@wyanokegroup.com>

ph:856.848.9005 Ext 220

The Wyanoke Group

http://www.wyanokegroup.com<http://www.wyanokegroup.com/<http://www.wyanokegroup.com%3chttp:/www.wyanokegroup.com/>>






Nedbank Limited Reg No 1951/09/06. The following link displays
the names of the Nedbank Board of Directors and Company Secretary.
[ http://www.nedbank.co.za/terms/DirectorsNedbank.htm ]
This email is confidential and is intended for the addressee only.
The following link will take you to Nedbank's legal notice.
[ http://www.nedbank.co.za/terms/EmailDisclaimer.htm ]

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

Re: [U2] SpreadsheetML and Excel2013

[George Gallen]

I Think I may have found my issue. I think that Excel 2010 may not have been
As strict, and I have found some problems with my XML coding my program is 
spitting out.
Once I straightened out the coding, it seems to working fine now.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, March 24, 2014 2:31 PM
To: U2 Users List
Subject: Re: [U2] SpreadsheetML and Excel2013

I'm not using 2013.  A friend was showing me that the new word and excel 
files were nothing but XML inside a zip file.  So, open a ".xlsx" or 
".docx" file with a zip client and you can actually see its contents.  
Kind of amazing.

Bill


- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users 
*Date:* 3/24/2014 11:00 AM
*Subject:* [U2] SpreadsheetML and Excel2013
> Is anyone else having issues with Excel2013 giving errors to previously 
> working XML files from Excel2003
>
> It keeps telling me there is an error in the table, and says there is log 
> file, which is blank - not helpful.
>
> George
>
> 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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] SpreadsheetML and Excel2013

[George Gallen]

Is anyone else having issues with Excel2013 giving errors to previously working 
XML files from Excel2003

It keeps telling me there is an error in the table, and says there is log file, 
which is blank - not helpful.

George

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<http://www.wyanokegroup.com/>

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

Re: [U2] Command to show what kind of file in Universe - 32 or 64 bit?

[George Gallen]

What happens if BITS = 32 or 64? Could that happen? In that case, neither of
First two cases would hit, RESULT would still be a 32 or 64.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Hulls
Sent: Wednesday, March 12, 2014 9:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Command to show what kind of file in Universe - 32 or 64 bit?

I generalized this so it can be used in a recall statement. To implement, I
created a I-desc subroutine that is called from a I-desc in a dictionary
that I can deliver (in my case SYS.DICT).
For example:
SORT VOC WITH F1 = "Q]""F]" AND @ID = "[PDA]" 32.64BIT USING DICT SYS.DICT

The interesting line in the I-Desc 32.64BIT is:
SUBR("DICT.VOC.FILE.32.64BIT","","","")

The code 
SUBROUTINE DICT.VOC.FILE.32.64BIT(RESULT,RV3,RV2,RV1)
* Returns 32 or 64 bit size for a file 
**
* MAINLINE
**
RESULT = ""
IF @RECORD<1>[1,1] = "F" OR @RECORD<1>[1,1] = "Q" THEN
OPEN "", @ID TO TEST.FILE THEN 
  STATUS MV.STATUS FROM TEST.FILE THEN 
 BITS = MV.STATUS<32> 
 BEGIN CASE 
 CASE BITS EQ 3 
 RESULT = "32" 
 CASE BITS EQ 5 
 RESULT = "64" 
 CASE 1 
  RESULT = BITS
  END CASE 
END  ;*  STATUS 
END  ;*  OPEN 
END
RETURN



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Command-to-show-what-kind-of-file-in-Universe-32-or-64-bit-tp39581p42841.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Left Outer Join Question

[George Gallen]

I Use MERGE.LIST a lot.

Say for instance you want to know how many emails from an excel file are
  In a customer file.

If you sort the excel file by email, then click on the excel column header, 
right click and copy
Then go to UV,  EDIT-LIST EM1,  I  Then paste the clipboard and File that
SELECT CUSTOMERFILE SAVING UNIQUE EMAIL
SAVE-LIST EM2

GET-LIST EM1 TO 1
GET-LIST EM2 TO 2
MERGE.LIST 1 DIFF 2
SAVE-LIST EMAILS-NOT-IN-CUSTOMER-FILE

GET-LIST EM1 TO 1
GET-LIST EM2 TO 2
MERGE.LIST 2 DIFF 1
SAVE-LIST EMAILS-NOT-IN-EXCEL-FILE

And so on


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Tuesday, March 04, 2014 4:24 PM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

Randy,

It sounds like NSELECT is what you need.
But MERGE.LIST is a handy thing to get working.

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

Re: [U2] Left Outer Join Question

[George Gallen]

Also keep in mind that MERGE.LIST (if you can get it to work) will also
Remove Duplicate Keys

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, March 04, 2014 2:22 PM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

NSELECT gets the items in the list, created by "SELECT X", that do not 
exist in Y.  Consequently, you can do things like:

SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY
xxx records selected to list 0
NSELECT INVOICES

...where INVOICEKEY is the field that produces the record keys into the 
INVOICES file.

Duplicate keys are a different story.  If you want the list to be 
duplicate free then you need to use the "SAVING UNIQUE" (that's UniData 
but I think it's also UniVerse) keyword at the end of the SELECT 
statement.  e.g.

SELECT VENDORS WITH LAST USED > "01/01/13" INVOICEKEY
xxx records selected to list 0
SELECT INVOICES SAVING UNIQUE @ID

HTH,

Bill


- Original Message -
*From:* randyleesm...@roadrunner.com
*To:* u2-users@listserver.u2ug.org
*Date:* 3/4/2014 11:07 AM
*Subject:* Re: [U2] Left Outer Join Question
> If I do;
>
> SELECT X
> NSELECT Y
>
> Won't that take all my duplicate keys out from Y when I only want selected
> ones taken out from Y?
>
___
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] Left Outer Join Question

[George Gallen]

NO

SELECT X
NSELECT Y

Will return all items in X that are NOT in Y

Otherwise it will Exclude Y from X's List

That is what your looking for?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith
Sent: Tuesday, March 04, 2014 2:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Left Outer Join Question

If I do;

SELECT X
NSELECT Y

Won't that take all my duplicate keys out from Y when I only want selected
ones taken out from Y?



-
I used to be an Optimist until I knocked over the glass.
--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42784.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Left Outer Join Question

[George Gallen]

You are definitely typing the lines from TCL level, and NOT from a program 
that's running EXECUTE/PERFORMS?

Because if they are being run from a program, you have to use a multivalued 
command to EXECUTE, with all
The lines in that command

Example
CMD=""
CMD<-1>="GET-LIST LIST1 TO 1"
CMD<-1>="GET-LIST LIST2 TO 2"
CMD<-1>="MERGE.LIST 1 INTERSECT 2 TO 3"
EXECUTE CMD
LOOP
   READNEXT ID FROM 3 ELSE EXIT
REPEAT

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith
Sent: Tuesday, March 04, 2014 1:34 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Left Outer Join Question

It looks like the same thing.

4 lines long.

:
0001: V
:
0002: MERGE.LIST
:
0003: I
:
0004: GKSX
Bottom at line 4.




-
I used to be an Optimist until I knocked over the glass.
--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42776.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Left Outer Join Question

[George Gallen]

Just to be sure, What does your VOC for MERGE.LIST show?

I'm on 10.0.2 of UV - but Information favor.

>ED VOC MERGE.LIST
4 lines long.

: P
0001: V
0002: MERGE.LIST
0003: I
0004: GKSX

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith
Sent: Tuesday, March 04, 2014 7:39 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Left Outer Join Question

I tried the simplest way and still could not get it to work.

SF-MORT>SELECT OLDMAS TO 1

5247 record(s) selected to SELECT list #1.
SF-MORT>SELECT TRWMONTHEND TO 2

5229 record(s) selected to SELECT list #2.
SF-MORT>MERGE.LIST 1 INTERSECT 2 TO 3

SELECT list 1 is not active.
SF-MORT>MERGE.LIST 1 INTERSECT 2

SELECT list 1 is not active.

I even tried the lowercase select and got the same result.

Our version is 10.2.7 and we are running in PICK PICK.FORMAT.
We are running a number of older applications and Proc's.
So it may because of the Version I'm using.

:
0001: X
:
0002: 10.2.7
:
0003: PICK
:
0004: PICK.FORMAT
:
0005: 10.2.7



-
I used to be an Optimist until I knocked over the glass.
--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42772.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Left Outer Join Question

[George Gallen]

In order to simulate select lists in SQL , I create a temporary table, and 
write the keys I'm 
Looking for as col1

INSERT into temporarytable col1 (SELECT key from file1 where .)   ** My 
equvilent to SaveList

Now assuming file2 has similar keys your working with as in file1

Now you SELECT file2 where  and key NOT IN (SELECT col1 FROM 
temporarytable)   ** My equivalent to ReadList and Select (or NSELECT in this 
case)

George



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Monday, March 03, 2014 1:00 PM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

This isn't SQL, but uniquery has "NSELECT" that does this.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith
Sent: Monday, March 03, 2014 12:44 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Left Outer Join Question

I have 2 files.

File 2 is a black list of records (keys) I want to exclude in and active select 
list of File 1.

I've been looking into this for a little while and am not sure what I'm doing 
wrong.

Docs are not very helpful with any examples on the how to do with this.


I know of ways to deal with this in code, but was hoping for an SQL way to deal 
with it.







-
I used to be an Optimist until I knocked over the glass.
--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, Research & Development

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.com

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

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

Re: [U2] SELECTINDEX problem Universe 11.1.11

[George Gallen]

For some reason Games without Frontiers by Peter Gabriel suddenly started 
playing
In my head..

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson
Sent: Friday, February 21, 2014 5:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECTINDEX problem Universe 11.1.11


... so Macke selects Macke and Mackenzie selects Mackenzie


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

Re: [U2] UV 11 vs 10

[George Gallen]

I always setup our printers to be "local" printers to the OS, which handled the 
queueing. As well the OS would then handle the printing.
So to UV it didn't know local from network - I'm not sure if this will be an 
issue, or a benefit.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Card
Sent: Thursday, February 06, 2014 12:46 PM
To: U2 Users List
Subject: Re: [U2] UV 11 vs 10

We had a lot of network printer issues with Universe version 10 running on AIX 
5.3. When we upgraded to Universe version 11.1.4 (and AIX 6.1) most of the 
printer issues went away. I very rarely need to enable a network printer and 
never need to run the usa command to enable printing.


Jon Card
VP Special Projects
Combined Transport, Inc.
541-618-6565
Fax 541-826-9787

www.combinedtransport.com
Division of Combined Transport Logistics Group, Inc


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

Re: [U2] UV 11 vs 10

[George Gallen]

Currently we don't use uv/net - however, the EDA could pose useful, right now I
Have a workaround using tsql on linux and subroutines that return the data.

Is uv/net still an extra charge on the linux platform? I believe it's included
On the windows platform (at least it was back with 10.0.2).

As well, the data replication may prove useful - we have been using rdiff-backup
In the past - combination of replication and partial backups.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
baker_hug...@neimanmarcus.com
Sent: Thursday, February 06, 2014 12:37 PM
To: U2 Users List
Subject: Re: [U2] UV 11 vs 10

George - please download and read UNV-16297.  Discretely put, anyone on UV 
below v11.1.14 needs to upgrade to be PCI or SOX compliant, OR, perform 
the mitigation strategies in that bulletin.
If you don't use uv/net however, then this doesn't apply -- just evaluate 
the decision based on benefits.

The main benefits IMHO are:
a) EDA - external database access
b) Data Replication

The zombie processes that Will mentioned in his post are also an issue for 
us.  That was fixed in 11.1.6

Regards,
R. Baker Hughes




From:   George Gallen 
To: U2 Users , 
Date:   02/06/2014 11:25 AM
Subject:[U2] UV 11 vs 10
Sent by:u2-users-boun...@listserver.u2ug.org



OK. We are kicking around upgrading UV on Linux - from version 10.0.2 to 
the latest version of UV.

The question of what do we get from it (aside from being able to have 
support) to warrant the downtime for migration and
That everything is working fine now attitude.

What have been some features that upgrading has been beneficial for? That 
you couldn't do before?  (universe - not unidata)
I'd prefer to stay with linux, only because we use a lot of linux 
programs for support of our applications, and
   From our experience , has been more stable than a windows platform 
- so a side question would be are there
  Any advantages we might gain by migrating to windows as well?

I'm not just looking for VAR answers, but also end users as well.

Thanks
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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV 11 vs 10

[George Gallen]

We still get those with linux, especially if the network connection gets broken 
in the middle, that is not
By either end. Sometimes the OS cleans them up, or with phantoms that are 
started by phantoms, until the
Parent phantom ends, the child phantoms don't die. 

Not sure if that is something that has been addressed.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, February 06, 2014 12:28 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV 11 vs 10


One thing for us, going from 10 to 11, was what happens to the Zombie Processes
Those processes where the user gets *kicked* out and the process is still there 
running in *windoze* (not necessarily in the LISTU)

We used to accumulate dozens of these over the course of a month
Now zero.




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

[U2] UV 11 vs 10

[George Gallen]

OK. We are kicking around upgrading UV on Linux - from version 10.0.2 to the 
latest version of UV.

The question of what do we get from it (aside from being able to have support) 
to warrant the downtime for migration and
That everything is working fine now attitude.

What have been some features that upgrading has been beneficial for? That you 
couldn't do before?  (universe - not unidata)
I'd prefer to stay with linux, only because we use a lot of linux programs 
for support of our applications, and
   From our experience , has been more stable than a windows platform - so 
a side question would be are there
  Any advantages we might gain by migrating to windows as well?

I'm not just looking for VAR answers, but also end users as well.

Thanks
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<http://www.wyanokegroup.com/>

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

Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question

[George Gallen]

Or are we making a list of things (putting them into a table)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, February 06, 2014 11:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse 
Dictionary question

On 06/02/14 16:33, Doug Averch wrote:
> George:
> 
> All you need to do add is the words "Back in the day" and anyone will know
> why this a discussion that should be tabled.
> 
But are you tabling this in English or American? Is it on the table or
under it?

Cheers,
Wol

___
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] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question

[George Gallen]

I don't remember if that was on the Editor in Reality, or if it came along with 
Prime Information
And eventually into UV

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Thursday, February 06, 2014 11:33 AM
To: 'U2 Users List'
Subject: Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse 
Dictionary question

ABSOLUTELY!!!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, February 06, 2014 11:27 AM
To: U2 Users List
Subject: Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse 
Dictionary question

But you left out THE ABSOLUTE most important feature

"OOPS"

George

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

Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question

[George Gallen]

But you left out THE ABSOLUTE most important feature

"OOPS"

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Thursday, February 06, 2014 4:49 AM
To: U2 Users List
Subject: [U2] "ED: The very finest of 1970s technology!" was: UniVerse 
Dictionary question

& it's been that way for, oh I dunno, going back to PI, 30+ years?
That's in input mode.

Here are some related ED facts about edit-mode that I've found Pickies 
(vs. Primates) don't seem to know:

Rreplaces current line with a blank line.

Ithis is some text
will insert a line "this is some text"but leave yoiu in edit-mode, 
not insert-mode.

IB will put you in input mode BEFORE the line you're on.

IBthis is a some text
will insert a line "this is some text"  BEFORE the current line
but leave yoiu in edit-mode, not insert-mode.

There  is a bit of an inconsistency with IB:
IB
 Inserts a blank line BEFORE current line.  I don't know why 2 
spaces are needed. Oh, well.

R   repeats the previous full-line Replacement
C   repeats the previous Change command.
R this is some text
 replaces thw whole line.
R/ABC/XYZ
   is really  C/ABC/XYZ

So if you pickies are used to saying
 R/ABC/XYZ/
That is really a Change command,   C/ABC/XYZ.
So subsequent C will repeat your R/ABC/XYZ/


Finally, there is the actually helpful HELP command. (Check out 
HELP SEQ.)

AE aficionados may quibble over the ED  motto,  "The very finest of 
1970s technology!"

cds


On 2/6/2014 4:24 AM, Clif Oliver wrote:
> The UniVerse ED verb in input mode accepts a *single* space as a null line 
> indicator.
>
>
> Regards,
>
> Clif
>
>
> On Feb 5, 2014, at 6:15 PM, Daniel McGrath  
> wrote:
>
>> A tip my original mentor taught me on the first day was that in ED/AE, the 
>> back tick (`) gets treated as an empty line so you can keep going in insert 
>> mode and not need to worry about it.
>>
>> Regards,
>> Dan
>>
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org 
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
>> Sent: Wednesday, February 05, 2014 5:07 PM
>> To: 'U2 Users List'
>> Subject: Re: [U2] UniVerse Dictionary question
>>
>> The dots were just there to keep the numbered list going, The same I use 
>> dots in the Editor to enter blank lines. Later I go to the top and do 
>> R/.//50 to remove the dot.
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
>> Sent: Tuesday, February 04, 2014 3:04 PM
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] UniVerse Dictionary question
>>
>>
>> What are the periods in 3 and 4 for?
>> Did you try removing those?
>>
>>
>>
>> -Original Message-
>> From: Woodward, Bob 
>> To: U2 Users List 
>> Sent: Tue, Feb 4, 2014 11:49 am
>> Subject: Re: [U2] UniVerse Dictionary question
>>
>>
>> Just to make sure, you're wanting FIELD 178 and the first value of that 
>> field.  Correct?  Because you have a length of 1, left justified I want to 
>> make sure you're not looking for the first character of the 178th field.
>> Maybe if you showed what you're wanting and what you're getting, instead, 
>> then we'd be sure to give you an answer that makes sense.
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
>> Sent: Tuesday, February 04, 2014 11:45 AM
>> To: U2 Users List
>> Subject: Re: [U2] UniVerse Dictionary queston
>>
>> Martin:
>>
>> This is the only way to do accomplish the defined task in UniData.
>> Maybe "@RECORD<178,1>" is the preferred method in UV.
>>
>> Bill
>> Untitled Page
>>
>>
>> 
>> - Original Message -
>> *From:* msch...@martinscholl.com
>> *To:* U2 Users List 
>> *Date:* 2/4/2014 11:33 AM
>> *Subject:* [U2] UniVerse Dictionary queston
>>> UniVerse.
>>>
>>> I want to create a dictionary item that extract value <178,1>
>>>
>>> I thought
>>>
>>> 1.   I
>>> 2.   EXTRACT(@RECORD,178,1,0)
>>> 3.   .
>>> 4.   .
>>> 5.   1L
>>> 6.   S
>>>
>>>
>>> Would do but it does not give me the desired result. Any suggestions?
>>>

___
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] UniVerse Dictionary queston

[George Gallen]

Another option to this would be to define field 178 in one dictionary

@ID=ITEMWHOLE
D
178
 
DESCRIPTION
1L
S

And then

@ID=ITEMPART
I
ITEMWHOLE ; @1<1,1>
 
PIECEofITEM
1L
S

This way if you ever move where the ITEM is stored, just change the D Item. BUT 
You might still
Have to recompile the I descriptor - I don't think it will automatically sense 
the ITEMWHOLE
Reference changed.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of José Luis Gutiérrez 
de la Peza
Sent: Tuesday, February 04, 2014 2:39 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Dictionary queston

In line 2 put @RECORD<178,1>

Regards

JLGP

-Mensaje original-
De: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] En nombre de Martin Scholl
Enviado el: martes, 4 de febrero de 2014 01:33 p. m.
Para: U2 Users List
Asunto: [U2] UniVerse Dictionary queston

UniVerse. 

I want to create a dictionary item that extract value <178,1>

 

I thought

1.   I

2.   EXTRACT(@RECORD,178,1,0) 

3.   .

4.   .

5.   1L

6.   S

 

Would do but it does not give me the desired result. Any suggestions?

___
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] 11.2

[George Gallen]

It's been awhile since we last bought UV. What does UV run these days per 
license?

Note...we are not looking to upgrade at this point - but might consider it 
sometime later this year.

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<http://www.wyanokegroup.com/>

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

Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine

[George Gallen]

How about if it is contained in the GLOBAL.CATDIR file? 

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Monday, January 27, 2014 12:29 PM
To: U2 Users List
Cc: U2-Users List
Subject: Re: [U2] [UV] Programmatic Verification of Globally Cataloged 
Subroutine

Perhaps VCATALOG

(Allen - Sent from my paperweight)

> On Jan 27, 2014, at 12:06 PM, Perry Taylor  wrote:
> 
> Does anyone know of a good method in UniVerse BASIC to be able to verify if a 
> subroutine is globally cataloged?
> 
> Thanks.
> Perry Taylor
> Senior MV Architect
> Office (877) 494-7633 ext. 4392
> Direct (502) 779-4392
> ZirMed
> 888 West Market Street, Suite 400
> Louisville, KY 40202
> www.zirmed.com
> 
> 
> 
> 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
___
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] Pick 7.3 What is this?

[George Gallen]

Well, that rules out RH7.3! Unless your running as a virtual OS on AIX

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, January 10, 2014 2:02 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [u2] Pick 7.3 What is this?


Whatever this is, they are claiming it runs on AIX.
So Unidata 7.3 probably *does*, does D3 also run on AIX ?

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

Re: [U2] [u2] Pick 7.3 What is this?

[George Gallen]

I thought maybe it was Universe for the RedHat 7.3 platform, from back around 
2002?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, January 10, 2014 12:58 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [u2] Pick 7.3 What is this?


On someone's resume I see "Pick 7.3".  When I try to google for that, I get 
nothing useful.

Is this from Raining Data ?  It's a D3?
Or is this an MvBase or something other thing.

What is it?


___
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 11 and phantoms

[George Gallen]

Ok. That's what I thought. So general phantoms still don't count against the 
user count.

Thanks

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Harbeson
Sent: Thursday, January 09, 2014 1:12 PM
To: U2 Users List
Subject: Re: [U2] uv 11 and phantoms

On UniData, a port call would convert a phantom to an iphantom which would
burn a seat.

but until you "interact with a user" it does not count.  (ports count as
interacting with the user)

its in the manual somewhere


On Thu, Jan 9, 2014 at 12:33 PM, George Gallen wrote:

> Sorry, meant to say socket calls.
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Thursday, January 09, 2014 12:32 PM
> To: U2 Users
> Subject: [U2] uv 11 and phantoms
>
> On UV11, do all phantoms now take a user seat?  Or just those that use the
> port calls?
>
> George
>
> 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<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
>
___
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 11 and phantoms

[George Gallen]

Sorry, meant to say socket calls.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, January 09, 2014 12:32 PM
To: U2 Users
Subject: [U2] uv 11 and phantoms

On UV11, do all phantoms now take a user seat?  Or just those that use the port 
calls?

George

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<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

[U2] uv 11 and phantoms

[George Gallen]

On UV11, do all phantoms now take a user seat?  Or just those that use the port 
calls?

George

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<http://www.wyanokegroup.com/>

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

Re: [U2] USERS command in Universe

[George Gallen]

Wil,

As we all already know, there is no help for users!  They are truly helpless.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, January 08, 2014 2:22 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] USERS command in Universe


The HELP USERS doesn't really say anything useful.

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

Re: [U2] JET Command parameters

[George Gallen]

Hmmm. Since the output is going to the spooler, then being exported and being 
printed
>From another application. Looks like the J and the Q really aren't needed (for 
>this application)

Thanks
George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Decker
Sent: Tuesday, January 07, 2014 2:36 PM
To: U2 Users List
Subject: Re: [U2] JET Command parameters

J= Printer driver.  For printers that use table-drive printer drivers 
such as the HP laserJet to activate letter quality features.
Q=Quality (letter quality)
P=Print to spooler


On 1/7/2014 12:23 PM, George Gallen wrote:
> OK.
>
> I'm looking at Paragraph that runs "JET-OUT" and passes (J,Q,P)
>
> What do the J, Q and P signify?
>
> J=justified?
> Q=quiet?
> P=to the printer?
> 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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] JET Command parameters

[George Gallen]

OK.

I'm looking at Paragraph that runs "JET-OUT" and passes (J,Q,P)

What do the J, Q and P signify?

J=justified?
Q=quiet?
P=to the printer?
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<http://www.wyanokegroup.com/>

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

[U2] JET

[George Gallen]

Where is the licensing information kept for JET on UV.

Someone had their system reloaded - One big difference was their UV account went
>From being c:\IBM\UV to c:\U2\UV and I'm not sure if the JET account was moved 
>to
A different location either.

When they run JET, it says it's not authorized to run.

Who is maintaining JET now? If they need to find out what their license number
Was if it needs to be reinstalled also.

George

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<http://www.wyanokegroup.com/>

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

Re: [U2] EDI Question...

[George Gallen]

We are using custom software that is integrated to our current order 
processing. Luckily we are only doing 850/855 and 810 at the moment.
And I'm sure 856 in the future.

Where it's getting difficult (at the expense of expense) - is doing direct ftp 
with partners to bypass the VANs and
The IMO absolutely outrageous transmissions costs.

So we are doing a combination of XML with our VAN, and edi with our direct 
partners - the XML side doesn't need 997's
Whereas the edi side does.

What our system does is converts the XML -> edi , then converts the edi to an 
internal multivalued format
Our order entry, and billing is based off that internal format. Then when we 
need to send out a document
The internal format is converted back to either edi or xml and then FTP'd to 
each of the appropriate servers.

It's annoying in every time we gain a new partner, the software needs to be 
tweeked to each of their uniqueness
Within their document requirements.

As standards go, EDI is the most non standardized standard I have seen.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey
Sent: Tuesday, December 31, 2013 11:46 AM
To: U2 Users List
Subject: Re: [U2] EDI Question...

EDI brings up a whole can of worms for me in the new year.
We currently use softshare as our van, I would really like to do EDI in 
house or find something more affordable.
Does anyone have any suggestions.

Thank You

 Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Utah Medical Products Ltd.
Femcare-Nikomed Ltd.
Femcare Australia
 rfrai...@utahmed.com
 801-569-4016
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] EDI Question...

[George Gallen]

thanks

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Card
Sent: Tuesday, December 31, 2013 10:54 AM
To: U2 Users List
Subject: Re: [U2] EDI Question...

Yes

Each trading partner should have their own ISA counter. The GS Counter for each 
transaction set and each trading partner should have their own counter. This is 
one way to tell if you are missing a record.


Jon Card
VP Special Projects
Combined Transport, Inc.
541-618-6565
Fax 541-826-9787

www.combinedtransport.com
Division of Combined Transport Logistics Group, Inc


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, December 31, 2013 7:40 AM
To: U2 Users
Subject: [U2] EDI Question...

The control numbers for the ISA/GS/ST segments, do they need to be unique only 
on a trading partner scale, or on a VAN scale?

So if two trading partners are going through the same VAN, can they both have 
say a ISA control # of 1?

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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] EDI Question...

[George Gallen]

Thanks.

I should be good then. Just making sure it didn't need to be on a VAN level.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter S. Goldberger
Sent: Tuesday, December 31, 2013 10:56 AM
To: U2 Users List
Subject: Re: [U2] EDI Question...

ISA (IEA) and GS (GE) control numbers should be consecutive per trading 
partner. The Receiver COMM ID and the control number together are what 
the VAN looks at.


George Gallen wrote:
> The control numbers for the ISA/GS/ST segments, do they need to be unique 
> only on a trading partner scale, or on a VAN scale?
>
> So if two trading partners are going through the same VAN, can they both have 
> say a ISA control # of 1?
>
> 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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] EDI Question...

[George Gallen]

The control numbers for the ISA/GS/ST segments, do they need to be unique only 
on a trading partner scale, or on a VAN scale?

So if two trading partners are going through the same VAN, can they both have 
say a ISA control # of 1?

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<http://www.wyanokegroup.com/>

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

Re: [U2] BASIC code - upper, lower, CamelCase, what say you?

[George Gallen]

Wonder if anyone has ever done a study on whether by using U/l variables, now 
you will be hitting the shift
a whole lot more, does this lead to or worsen carpel tunnel?   Kind of a 
serious concern.
 
I think it also makes debugging more difficult, I'd rather stick to all UPPER 
or all lower Nothing better
Than wasting 2 hours going through a program to find out Oops, mean L instead 
of l

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Friday, December 20, 2013 2:32 PM
To: U2 Users List
Subject: Re: [U2] BASIC code - upper, lower, CamelCase, what say you?

This is really what got my thought-process flowing on this subject.  I saw
this code on github after the Rocket Software "Whats New in 11.2" webinar:

https://github.com/RocketSoftware/u2-servers-lab/blob/master/UniVerse-11.2/Local/BP/LocalMain

PROGRAM LocalMain
** Let's have a quick look at local scoping

CRT "Calling the local SUBROUTINE"
CALL Main(@SENTENCE) ;* This will call Main() below, rather than
an external subroutine
CRT "Back from the local SUBROUTINE"

END

SUBROUTINE Main(Args)
CRT "Running inside the local SUBROUTINE"
CRT "Args:" :Args

FOR Counter = 1 TO 3
CALL InnerLoop(Counter)
NEXT Counter
RETURN

SUBROUTINE InnerLoop(OutsideCounter)
* Notice this won't affect Main()'s 'Counter' variable due to scoping
FOR Counter = 1 TO OutsideCounter
CRT "*":

NEXT Counter
CRT
RETURN
___
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] UniVerse Install on HP-Ux

[George Gallen]

Also, check your uv.load to see if it does an uncompress
Then make sure your OS has that command
If not, I changed mine from uncompress to gunzip in the uv.load
I guess you could also cp gunzip uncompress as well

To make things easier if you have a problem.

Make a copy of the uv.load to something like uv.load.bu

This way if the install fails, you won't have to cpio it back off
The CD (just cp it from uv.load.bu to uv.load)

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Monday, December 16, 2013 12:54 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Install on HP-Ux

Peter:

Thanks... I will try this... 

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Sunday, December 15, 2013 5:35 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Install on HP-Ux

How about making a copy of the cd/dvd to an iso and installing from that?

Somewhere in *nix land where it's easier to mount and use the cd...
# dd if=/dev/cdrom of=/var/tmp/uv.iso bs=8000

transport the resulting ISO to your HPUX machine # mount -F lofs
/some/dir/to/uv.iso /tmp/mount

You should then be able to cd to /tmp/mount and run the cpio command as root
(or uvadm?) and follow the install instructions for hpux.
# cpio -ivcBdum uv.load < ./STARTUP
# ./uv.load -longnames

HTH
Peter



Peter Cheney
Ultracs Developer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au
w firstmac.com.au


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman
Sent: Saturday, 14 December 2013 10:49
To: U2 Users List
Subject: [U2] UniVerse Install on HP-Ux

1. I am having some problems trying to get to first base.
2. There is this cpio command.
3. Is it necessary to install from a CD or DVD?
4. I would rather install from FTP'd files.
5. Mounting the media is a hassle... so is CDFS on a DVD.
6. Suggestions would be appreciated.

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

 

---
Note: 
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this
communication. If you have received this email in error, please notify the
sender immediately and then delete all copies of this message from your
computer network. If you are not the intended recipient, you must not keep,
use, disclose, copy or distribute this email without the author's prior
permission. If you are the intended recipient and you do not wish to receive
similar electronic messages from us in future, then please respond to the
sender to this effect. 
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects. 
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
 

---
___
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] [Very OT] XP File Dialog Box

[George Gallen]

Windows 8 suks

Anyone give any good points that makes Windows 8 worthwhile?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Thursday, December 12, 2013 3:13 PM
To: U2 Users List
Subject: Re: [U2] [Very OT] XP File Dialog Box

If you plan to go to Windows 7, you better move fast.  Microsoft announced that 
the company discontinued the distribution of retail copies of Windows 7 at the 
end of October 2013.  Microsoft had previously listed that date as October 31, 
2014, but changed that information.

http://www.foxnews.com/tech/2013/12/10/microsoft-ends-windows-7-retail-sales-directs-consumers-to-windows-8/

JRI

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

Re: [U2] [Very OT] XP File Dialog Box

[George Gallen]

Are you actually clicking on the scroll bar itself, or in the white area to 
left or right of it?

If you have a lot of files in the directory, and you say click in the white to 
right of the scroll bar,
   It should display the bottom of the directory, and top of the directory for 
the left side.

Maybe this is just the box skipping columns until it can display the last 
column?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, December 12, 2013 3:09 PM
To: U2 Users List
Subject: Re: [U2] [Very OT] XP File Dialog Box

I use Firefox, but it happens in all browsers. It also happens in 
programs like Adobe PDF reader, Foxit PDF reader, Open Office, Notepad, 
Notepad++, etc. None of these have anything to do with a browser, so I'm 
pretty sure it isn't browser related.

I also know that XP is very outdated, but I won't be moving to Win7 
until next year.

Thanks,
Charlie

On 12-12-2013 1:57 PM, George Gallen wrote:
> Does it happen in all browsers? Or just IE and which version of IE are you 
> using?
>
> If your using IE10 or IE11, have you tried to run it in compatibility mode?
>
> George
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> Sent: Thursday, December 12, 2013 2:50 PM
> To: U2 Users List
> Subject: Re: [U2] [Very OT] XP File Dialog Box
>
> Pretty much anything I do in Win XP, in a browser and any other program
> which uses the file dialog box.
>
> On 12-12-2013 1:43 PM, George Gallen wrote:
>> Do you mean when you browse for a file from HTML using Windows XP?
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org 
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
>> Sent: Thursday, December 12, 2013 2:39 PM
>> To: U2 Users List
>> Subject: [U2] [Very OT] XP File Dialog Box
>>
>> I realize this is an unusual place to post this request, but it's
>> driving me crazy and I'm hoping someone here can help. Just about every
>> time I use the XP file dialog box to open or save a file, it scrolls
>> multiple times when I click in the horizontal scroll bar. Has anyone
>> seen this behavior and know what to do about it?
>>
>> Thanks,
>> Charlie Noah
>>
>> Tiny Bear Wild Bird Store
>> Home of "Safety Net Shipping"
>> http://www.TinyBearWildBirdStore.com
>> Toll Free: 1-855-TinyBear (855-846-9232)
>>
>> ___
>> 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] [Very OT] XP File Dialog Box

[George Gallen]

Does it happen in all browsers? Or just IE and which version of IE are you 
using?

If your using IE10 or IE11, have you tried to run it in compatibility mode?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, December 12, 2013 2:50 PM
To: U2 Users List
Subject: Re: [U2] [Very OT] XP File Dialog Box

Pretty much anything I do in Win XP, in a browser and any other program 
which uses the file dialog box.

On 12-12-2013 1:43 PM, George Gallen wrote:
> Do you mean when you browse for a file from HTML using Windows XP?
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> Sent: Thursday, December 12, 2013 2:39 PM
> To: U2 Users List
> Subject: [U2] [Very OT] XP File Dialog Box
>
> I realize this is an unusual place to post this request, but it's
> driving me crazy and I'm hoping someone here can help. Just about every
> time I use the XP file dialog box to open or save a file, it scrolls
> multiple times when I click in the horizontal scroll bar. Has anyone
> seen this behavior and know what to do about it?
>
> Thanks,
> Charlie Noah
>
> Tiny Bear Wild Bird Store
> Home of "Safety Net Shipping"
> http://www.TinyBearWildBirdStore.com
> Toll Free: 1-855-TinyBear (855-846-9232)
>
> ___
> 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] [Very OT] XP File Dialog Box

[George Gallen]

Do you mean when you browse for a file from HTML using Windows XP?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, December 12, 2013 2:39 PM
To: U2 Users List
Subject: [U2] [Very OT] XP File Dialog Box

I realize this is an unusual place to post this request, but it's 
driving me crazy and I'm hoping someone here can help. Just about every 
time I use the XP file dialog box to open or save a file, it scrolls 
multiple times when I click in the horizontal scroll bar. Has anyone 
seen this behavior and know what to do about it?

Thanks,
Charlie Noah

Tiny Bear Wild Bird Store
Home of "Safety Net Shipping"
http://www.TinyBearWildBirdStore.com
Toll Free: 1-855-TinyBear (855-846-9232)

___
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] Exporting to File regularly

[George Gallen]

Depends on the timeframe needed for a response. If this were for some form of 
QA that if it were incorrect
Needed to be addresses quickly, then the every 5 minutes would be needed (or 
maximum time frame).

If it's just for history - then once a day would be fine.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, December 11, 2013 12:09 PM
To: d...@chancofamily.com; u2-users@listserver.u2ug.org
Subject: Re: [U2] Exporting to File regularly


Can I modify this suggestion to say that it *stores* each write, and only 
emails you once a day :)

Put that snake back in the box!!!



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

Re: [U2] Exporting to File regularly

[George Gallen]

Going along this train of thought. What if you setup a new printer and make the
Device's filename to be a script filename. Then when you setup the SP.ASSIGN and
Then do your LIST ... it will send the output directly to your script.

Granted, you will need to setup a new "printer" device on the UV system account
But that shouldn't be too difficult.

But - Personally, I'd opt for Trigger method and have the subroutine also track
Deletes and Changes as well as Adds. However the Trigger method has filename 
naming constraints
As well as permissions issues to allow the setting of the Trigger, however, a 
search
Of this list will yield some trigger setup tips from about 6 months ago I 
believe.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Wednesday, December 11, 2013 6:33 AM
To: 'U2 Users List'
Subject: Re: [U2] Exporting to File regularly

Good morning David.

While the answers you've gotten regarding triggers are valid, they're
perhaps an overly complicated solution to your problem.

Your statement that LIST FILE.NAME LPTR gives you the info you need seems to
imply to me that the record key is numeric and generated sequentially.   If
so, then there's a control record in the existing system that you should be
able to retrieve.   And it may be as simple as finding the &NEXT.AVAILABLE&
record in the dictionary of the file that you're looking at.   If not, it's
going to be stored in a parameter file somewhere.   Unfortunately that
"somewhere" is a nasty word given that you are new to universe...



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell
Sent: Wednesday, December 11, 2013 12:39 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Exporting to File regularly

Hi Everyone,

I'm new to universe (a complete noob) and I couldn't quite find what I was
looking for on google and I've been smashing my face against this for a
while until I stumbled upon this mailing list so I was wondering if anyone
could help me out here.

I'm writing a script that will hopefully alert me via email whenever a new
record is added to a particular universe file, if there is a better way to
do this I would be all ears. I'm working around another proprietary system
which operates on universe and I dont know enough about universe to really
say for sure what is proprietary and what is universe standard code and the
proprietary stuff is covered in NDA's and no touchy hand slappy orders so I
cannot really modify the way it works, I just need to know when a new entry
appears, preferably via an smtp email.

My Current plan works like this

I'm looking to regularly (every 5 minutes) output data into a text or csv
file, doesn't matter really, so long as it is not full of characters that
batch scripts hate and it can happen in an automated fashion.

The closest thing I can get to what I want right now is

SP.ASSIGN HS
LIST FILE.NAME LPTR

this lists all the records and dumps them in a spool file under
/var/spool/uv/ and then a script I have written in the past retrieves that
spool file for me, I have trained that spool file to look for specific
markers in the first line of the file and apply a particular script to it

This spooled print job gives me a list of the records that I can then sort
numerically, pick the highest number, check that number against what the
number was last time and alert me via email if its different.

Ultimately I would love for a regularly running script to just output the
highest record (maybe sort numerically and give me the highest number and
dump just that number into a file on the unix box for me to retrieve and the
work with.

Any help would be greatly appreciated!




--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly
-tp42264.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[U2] Running Account wide I-DESC

[George Gallen]

Not sure if this helps anyone...

There is an I DESC that we usually put in the DICT of most files.
Usually, when you go to use it, it hadn't been entered, while not difficult to 
enter - just a pain.

I tried to put the IDESC in VOC, but I wasn't able to compile it
I was able to put it in the VOC of VOC - which compiled - but wasn't usable 
globally.

SoIn order to get an IDESC to be used globally (at least globally within 
that account).

You must...


1.   Enter the IDESC into the VOC of VOC

2.   Compile the IDESC

3.   COPY from the VOC VOC to VOC

Now it's usable on any file without having to add it

Funny, if you want to add a D type DICT , you only need to put it in VOC,
But , with I DESC, the problem is compiling it - you can only compile in the 
VOC of VOC
   Then you have to copy it into VOC for it to be usable.

Like I said...If it helps...great,   If not - move on.

George

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<http://www.wyanokegroup.com/>

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

Re: [U2] Working with accented characters

[George Gallen]

Any consideration of converting the accented character to an unaccented 
character first? 

Not perfect but it works 99% of the timeand then when you export the name 
to another company
All they get are unaccented letters.

George


SUBROUTINE REMOVE.ACCENT(INDATA,OUTDATA)
 *
UAE=CHAR(140):CHAR(198)
LAE=CHAR(156):CHAR(230)
DEGREE=CHAR(176)
 *

NULL1=CHAR(128):CHAR(129):CHAR(130):CHAR(131):CHAR(132):CHAR(133):CHAR(134):CHAR(135):CHAR(136):CHAR(137)

NULL2=CHAR(139):CHAR(141):CHAR(143):CHAR(144):CHAR(145):CHAR(146):CHAR(147):CHAR(148):CHAR(149):CHAR(150)

NULL3=CHAR(151):CHAR(152):CHAR(153):CHAR(155):CHAR(157):CHAR(160):CHAR(161):CHAR(162):CHAR(163):CHAR(164)

NULL4=CHAR(165):CHAR(166):CHAR(167):CHAR(168):CHAR(169):CHAR(171):CHAR(172):CHAR(173):CHAR(174):CHAR(175)

NULL5=CHAR(177):CHAR(178):CHAR(179):CHAR(180):CHAR(181):CHAR(182):CHAR(183):CHAR(184):CHAR(185):CHAR(187)
NULL6=CHAR(188):CHAR(189):CHAR(190):CHAR(191)
NULLX=CHAR(186):CHAR(216):CHAR(222):CHAR(240):CHAR(247):CHAR(248)
 *
UPA=CHAR(192):CHAR(193):CHAR(194):CHAR(195):CHAR(196):CHAR(197)
LWA=CHAR(224):CHAR(225):CHAR(226):CHAR(227):CHAR(228):CHAR(229)
RUA=STR('A',LEN(UPA))
RLA=STR('a',LEN(LWA))
UPE=CHAR(200):CHAR(201):CHAR(202):CHAR(203)
LWE=CHAR(232):CHAR(233):CHAR(234):CHAR(235)
RUE=STR('E',LEN(UPE))
RLE=STR('e',LEN(LWE))
UPI=CHAR(204):CHAR(205):CHAR(206):CHAR(207)
LWI=CHAR(236):CHAR(237):CHAR(238):CHAR(239)
RUI=STR('I',LEN(UPI))
RLI=STR('i',LEN(LWI))
UPO=CHAR(210):CHAR(211):CHAR(212):CHAR(213):CHAR(214)
LWO=CHAR(242):CHAR(243):CHAR(244):CHAR(245):CHAR(246)
RUO=STR('O',LEN(UPO))
RLO=STR('o',LEN(LWO))
UPU=CHAR(217):CHAR(218):CHAR(219):CHAR(220)
LWU=CHAR(249):CHAR(250):CHAR(251):CHAR(252)
RUU=STR('U',LEN(UPU))
RLU=STR('u',LEN(LWU))

SS1=CHAR(138):CHAR(142):CHAR(154):CHAR(158):CHAR(159):CHAR(199):CHAR(208):CHAR(209):CHAR(221):CHAR(223):CHAR(231)
SR1="SZszYCDNYBc"
SS2=CHAR(241):CHAR(253):CHAR(170):CHAR(215)
SR2="nyax"
*
EXPR1=UPA:LWA:UPE:LWE:UPI:LWI:UPO:LWO:UPU:LWU:SS1:SS2
EXPR2=RUA:RLA:RUE:RLE:RUI:RLI:RUO:RLO:RUU:RLU:SR1:SR2
NULCHARS=NULL1:NULL2:NULL3:NULL4:NULL5:NULL6:NULLX:DEGREE
*
LIN=INDATA
*
LIN=CHANGE(LIN,CHAR(223),"SS")
CONVERT EXPR1 TO EXPR2 IN LIN
CONVERT NULCHARS TO "" IN LIN
LIN=CHANGE(LIN,CHAR(230),"AE")
LIN=CHANGE(LIN,UAE,"AE")
LIN=CHANGE(LIN,LAE,"ae")
*
OUTDATA=LIN
RETURN
STOP
END

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little
Sent: Monday, November 25, 2013 3:10 PM
To: U2 Users List ‎[u2-users@listserver.u2ug.org]‎
Subject: [U2] Working with accented characters

To convert the first character of a regular ASCII string to uppercase, I'd use 
OCONV("STRING",'MCT') so that "STRING" is output as "String".  However, this 
doesn't seem to work for Spanish accented characters.  The machine is UV 
11.1.11 with NLS enabled.

What is the most elegant way to convert a name, such as JOSÉ to José ?  I'm not 
a sys admin, so if it requires setting up an NLS map or something along those 
lines, I'm probably out of luck.


bob little
applications architect
independent contractor
market america, inc.
1302 pleasant ridge rd.
greensboro, nc  27409
Phone: 336-698-4367
Cell: 248-675-5515
Skype: boblittle904

___
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] Mysterious Error Message

[George Gallen]

Given that Corrupt is missing a T (itself being corrupt?) I would think it's 
not an OS related message.

Since your HPUX, can you do a file content find in unix for "RECORD CORRUP!" to 
find out where it's coming from?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Monday, November 25, 2013 11:46 AM
To: U2 Users List
Subject: [U2] Mysterious Error Message

We use UniData/HPUX w/ SB and Redback.  We are running Epicor's Avanté which 
uses iConnect.
For arguments sake, I have 3 UniData accounts: TEST, PILOT & LIVE.
I have 3 web sites (TEST, PILOT & LIVE) that connect as you would expect.
3-4 weeks ago, a change was made in Sales Order Entry in SB.  I had to make a 
minor tweak for this to work via the web sites.  All was good with all three 
web sites.
Due to unrelated issues, our TEST account has a temporary stand-alone copy of 
DMSECURITY.

Other people on my team have made a few changes in SB Sales Order Entry and 
asked that I verify that the web site still worked.  One change was in TEST and 
another (untested) one was in PILOT.  Order Entry was now failing on both web 
sites, but LIVE was still working.  The change in PILOT was unrolled, but we 
still had the problem.

The actual error we are getting in the Redback log is "II RECORD CORRUP! - 
CONTACT SYSTEM ADMINISTRATOR"

If the problem were only in TEST, I would blame my local copy of DMSECURITY.  
Since the problem is also in PILOT but NOT in LIVE (which share the standard 
DMSECURITY file), this tells me it is not the DMSECURITY file, but rather 
something that is local to each account.

Has anyone seen this before?  Any thoughts or suggestions?

JRI
___
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] Johnson's Lemma

[George Gallen]

That you will no  doubtedly insert a bug into as you try to improve it!

> On Nov 21, 2013, at 7:16 PM, Wjhonson  wrote:
> 
> 
> Johnson's Lemma:
> On any sufficiently complex application, you will have running and useful 
> routines, that predate your career.
> 
> 
> ___
> 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] List of display control @ variables for UVBasic

[George Gallen]

I seem to recall it was in the system manual, in one of the appendixs,
check the master index for @

George

-Original Message- 
From: Jeff Schasny 
Sent: Tuesday, November 19, 2013 4:54 PM 
To: U2-Users@listserver.u2ug.org 
Subject: [U2] List of display control @ variables for UVBasic 

Anyone know where the list of @ variables for display control ( @(-1) = 
clear screen) is in the Universe documentation? I can't seem to find it.


Thanks

--

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-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] moving UV from one server to another (windows)

[George Gallen]

About the only major advantage I can see using windows over linux (from my 
tainted view)
would be that Windows version of UV comes with .NET connectivity. aside from 
that I
find linux to far more easier and more secure as a platform level than 
windows, however,

as for UV I find no difference which platform you use - matter of comfort.

George

-Original Message- 
From: Bill Haskett

Sent: Tuesday, November 19, 2013 2:30 PM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

George:

David is correct that you should use Windows server to run U2 products
for a business environment.  However, there is a role for running
everything on a single Windows 7 machine for demos, proof-of-concepts,
development, etc.

There is no need to worry about Windows reboots for a non-24/7
environment, and what you've discussed so far would not lead anyone to
think you need 24/7 uptime.  So, Windows is perfectly acceptable and,
IMHO of course, even more acceptable than a 'nix' environment for this
kind of low-use configuration.

Just a thought...

Bill
Untitled Page




- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List 
*Date:* 11/19/2013 6:22 AM
*Subject:* Re: [U2] moving UV from one server to another (windows)
Yes, but they will be running windows - which NEVER needs to be reboot 
unless it's

Something really serious!

George

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

Sent: Monday, November 18, 2013 7:19 PM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

Hi Bob,
Post migration, one thing for consideration might be user education
regarding the new use of their workstation/PC?
No more will the user just be able to re-boot it when it freezes etc or
shut it down each night at home-o'clock.
Cheers
Peter

On 19/11/13 05:55, Woodward, Bob wrote:

Oh, I'd always say go for more memory.  Especially if there are other
Windows apps that are going to be used on that computer.  As to the
locking, the normal record locks inside of UV once it's moved.  Just do
a simple edit of a record on the workstation, then from another
workstation, edit the same record.  If there is a problem, the
workstation hosting UV is probably not locking the records.  When I saw
the problem, it was because the workstation was accessing UV through the
C: drive, which was local, of course.  To fix it, you have to map a
network drive and ONLY use the network drive on that workstation.  The
idea was that local drives didn't NEED to be locked since it's a single
user OS.  At least that's the way it was explained to me.  Come to think
of it, Win7 may not even maintain a network locking table.  Remember, I
said I did this on a PE version where I was pretty much the only user.

BobW

-Original Message-
From:u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, November 18, 2013 11:38 AM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

Locking issues once UV is running on the Windows 7 machine, or locking
issues caused by Copying over the data and overwriting the fresh
install?

This won't be a heavily used system (3 or 4 users maximum and even then
should be too taxing).

Should they max out the memory on the PC it's going to be installed on?
Or is 4gb fine?

George

-Original Message-
From:u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob
Sent: Monday, November 18, 2013 2:28 PM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

One of the things you may need to watch real careful would be locking.
Especially on the workstation that is hosting UV.   Then, as long as all
the drive letters are the same as on the server, everything should be
okay.  Of course, YMMV but I've done this type of swapping on my home
network with the personal edition a number of years ago.


-Original Message-
From:u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, November 18, 2013 11:04 AM
To: U2 Users
Subject: [U2] moving UV from one server to another (windows)

Had someone ask me this question.  They are downsizing their PC's

They have UV currently installed on a Windows Server PC - and each of
the PC's using wintergate to access it.
This server is having some issues, so they want to move UV off of it,
and have it run on one of their "client" PC Running windows 7.

My thought was that you would install UV on that PC, Then (with the
services off), copy the file structure from The Server to the PC.
Assuming the all the folders are named the s

Re: [U2] Simple question - selecting and listing records

[George Gallen]

If someone who has rights to be able to change them needs to add
"link1"  (example-but it can be used) into field 7 of the following DICT 
ITEMS

PACKET STATUS TRACKING.ID and PMT.DATE

That will link these fields together so next time you can do:

SELECT CREDITCARD.FILE WITH PMT.DATE = "11/19/2013"
LIST CREDITCARD.FILE WHEN PMT.DATE = "11/19/2013" PACKET STATUS TRACKING.ID 
PMT.DATE


George

-Original Message- 
From: Hilk, Brandon

Sent: Tuesday, November 19, 2013 1:31 PM
To: U2 Users List
Subject: Re: [U2] Simple question - selecting and listing records

You may be right :)
I do no programming with this system, I'm just an end user that's trying
to understand better.

Field. Type & Field Conversion.. Column. Output
Depth &
Name.. Field. Definition... Code Heading Format
Assoc..
  Number

@IDD0CREDITCARD.FILE 10L
S
PACKET D2PACKET  8R
M
STATUS D   10STATUS  15L
M
TRACKING.IDD9TRACKING ID 20L
M
PMT.DATE   D7   D4/  PMT DATE10R
M


As far as WHEN clause, I tried:

list creditcard.file packet status tracking.id pmt.date when pmt.date eq
"11/19/2013"

and it sorts those dates to be the first results, but it still lists all
the other card entries on that packet before moving to the next record.
Is this just a consequence of how the creditcard.file is set up?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, November 19, 2013 12:06 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Simple question - selecting and listing records

Could you post the exact statement you're using with the WHEN clause, a
and also the contents of the DICT items?

I suspect one or more of them is not actually setup as a multivalued
field







-Original Message-
From: Hilk, Brandon 
To: U2 Users List 
Sent: Tue, Nov 19, 2013 8:29 am
Subject: [U2] Simple question - selecting and listing records


Hello, I have a quick question regarding listing multivalued fields. I
hope the formatting is retained on this email so my example doesn't get
confusing.



This file is structured for multiple credit card entries under one @id.
How can I alter my LIST command to only show the entries for the date
specified? I tried using "when" in both the LIST and SELECT statements
but didn't get the results I was looking for. I feel like I'm missing
something really basic. Thanks in advance.





}SELECT CREDITCARD.FILE WITH PMT.DATE EQ "11/19/2013"

303 record(s) selected to SELECT list #0.



}}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE



CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE..



5215216252152162 APPROVED25D6TGCD 11/19/2013

   52152162  12/31/2013

   52152162  01/31/2014

   52152162  02/28/2014

   52152162  03/31/2014

   52152162  04/30/2014

   52152162  05/30/2014

   52152162  06/30/2014

   52152162  07/31/2014

   52152162  08/29/2014

   52152162  09/30/2014

   52152162  10/31/2014

5643649556436495 APPROVED259l17j2 02/18/2013

   56436495 APPROVED25a0hfg7 03/18/2013

   56436495 APPROVED25adf4bt 04/18/2013

   56436495 APPROVED25ar1ofv 05/20/2013

   56436495 APPROVED25b7a92o 06/18/2013

   56436495 APPROVED25bk0tpv 07/18/2013

   56436495 APPROVED25c11rl1 08/19/2013



___
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] Simple question - selecting and listing records

[George Gallen]

OOPS, meant field 7, not field 6.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, November 19, 2013 11:35 AM
To: U2 Users List
Subject: Re: [U2] Simple question - selecting and listing records

I'm assuming you have multiple fields which are tied together that are all 
multivalued?
If so, make sure you field 6 in the dict all have the same linkcode otherwise 
WHEN
Will not be to pull the associated fields.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Tuesday, November 19, 2013 11:29 AM
To: U2 Users List
Subject: [U2] Simple question - selecting and listing records

Hello, I have a quick question regarding listing multivalued fields. I
hope the formatting is retained on this email so my example doesn't get
confusing. 

 

This file is structured for multiple credit card entries under one @id.
How can I alter my LIST command to only show the entries for the date
specified? I tried using "when" in both the LIST and SELECT statements
but didn't get the results I was looking for. I feel like I'm missing
something really basic. Thanks in advance.

 

 

}SELECT CREDITCARD.FILE WITH PMT.DATE EQ "11/19/2013"

303 record(s) selected to SELECT list #0.

 

}}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE

 

CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE..



5215216252152162 APPROVED25D6TGCD 11/19/2013

52152162  12/31/2013

52152162  01/31/2014

52152162  02/28/2014

52152162  03/31/2014

52152162  04/30/2014

52152162  05/30/2014

52152162  06/30/2014

52152162  07/31/2014

52152162  08/29/2014

52152162  09/30/2014

52152162  10/31/2014

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 08/19/2013

 

___
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] Simple question - selecting and listing records

[George Gallen]

I'm assuming you have multiple fields which are tied together that are all 
multivalued?
If so, make sure you field 6 in the dict all have the same linkcode otherwise 
WHEN
Will not be to pull the associated fields.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Tuesday, November 19, 2013 11:29 AM
To: U2 Users List
Subject: [U2] Simple question - selecting and listing records

Hello, I have a quick question regarding listing multivalued fields. I
hope the formatting is retained on this email so my example doesn't get
confusing. 

 

This file is structured for multiple credit card entries under one @id.
How can I alter my LIST command to only show the entries for the date
specified? I tried using "when" in both the LIST and SELECT statements
but didn't get the results I was looking for. I feel like I'm missing
something really basic. Thanks in advance.

 

 

}SELECT CREDITCARD.FILE WITH PMT.DATE EQ "11/19/2013"

303 record(s) selected to SELECT list #0.

 

}}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE

 

CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE..



5215216252152162 APPROVED25D6TGCD 11/19/2013

52152162  12/31/2013

52152162  01/31/2014

52152162  02/28/2014

52152162  03/31/2014

52152162  04/30/2014

52152162  05/30/2014

52152162  06/30/2014

52152162  07/31/2014

52152162  08/29/2014

52152162  09/30/2014

52152162  10/31/2014

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 08/19/2013

 

___
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] moving UV from one server to another (windows)

[George Gallen]

Although, I'm not sure if it's a supported platform given their version 
level.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Tuesday, November 19, 2013 11:18 AM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

 From the PAM on Rocket's website, Windows 7 is a supported version.
-Dianne

On 11/18/2013 10:13 PM, David Scoggins wrote:
> No one has pointed out the elephant in the room yet, so I will.  Windows 7
> is not intended for this use; while this configuration may "work" for some
> values of "work", stability issues can and should be expected.  In
> particular, I would expect the network stack to be, unh, "flaky" might be
> the best word.
>
> More importantly, Windows 7 is not LICENSED for this use.  I am not
> affiliated with Rocket, nor can I speak for them, but I would be very
> surprised if Rocket supports this configuration.
>
> This is NOT a good idea; it has "false economy" written all over it.   I
> would discourage your client, friend or whatever from going down this path.
>
>
> David Scoggins
>
>
>
>
> On Mon, Nov 18, 2013 at 2:03 PM, George Gallen 
> wrote:
>
>> Had someone ask me this question.  They are downsizing their PC's
>>
>> They have UV currently installed on a Windows Server PC - and each of the
>> PC's using wintergate to access it.
>> This server is having some issues, so they want to move UV off of it, and
>> have it run on one of their "client" PC
>> Running windows 7.
>>
>> My thought was that you would install UV on that PC, Then (with the
>> services off), copy the file structure from
>> The Server to the PC. Assuming the all the folders are named the same on
>> both systems for the install. And of
>> Course remove UV from the Server once all it good.
>>
>> Should this be all that would be needed?
>>
>> Will UV function on a Windows 7 PC?
>> Can it be used as working PC - as well as be a UV server?
>>
>> Everything I've heard says it should run by itself - but - can it run on a
>> PC as background service?
>>
>> 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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] moving UV from one server to another (windows)

[George Gallen]

While I agree what your saying, it may not be certified to work with W7
I'm sure support will still be offered, however, if a unique problem comes
Up, then the excuse (not meant in a mean tone) that your not working with
A supported combination would be the answer, but if it's just something
That everyday support can still handle, I would imagine they would still
Take the $$ to renew a contract (just a guess).

My original response was to keep it isolated on a new W Server machine,
Or at the least isolated on it's own W7 machine. Although personnaly my
True preference would be to go with a linux server vs windows. But it's
Not my say.

But your point is well taken

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Scoggins
Sent: Monday, November 18, 2013 10:13 PM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

No one has pointed out the elephant in the room yet, so I will.  Windows 7
is not intended for this use; while this configuration may "work" for some
values of "work", stability issues can and should be expected.  In
particular, I would expect the network stack to be, unh, "flaky" might be
the best word.

More importantly, Windows 7 is not LICENSED for this use.  I am not
affiliated with Rocket, nor can I speak for them, but I would be very
surprised if Rocket supports this configuration.

This is NOT a good idea; it has "false economy" written all over it.   I
would discourage your client, friend or whatever from going down this path.


David Scoggins




On Mon, Nov 18, 2013 at 2:03 PM, George Gallen wrote:

> Had someone ask me this question.  They are downsizing their PC's
>
> They have UV currently installed on a Windows Server PC - and each of the
> PC's using wintergate to access it.
> This server is having some issues, so they want to move UV off of it, and
> have it run on one of their "client" PC
> Running windows 7.
>
> My thought was that you would install UV on that PC, Then (with the
> services off), copy the file structure from
> The Server to the PC. Assuming the all the folders are named the same on
> both systems for the install. And of
> Course remove UV from the Server once all it good.
>
> Should this be all that would be needed?
>
> Will UV function on a Windows 7 PC?
> Can it be used as working PC - as well as be a UV server?
>
> Everything I've heard says it should run by itself - but - can it run on a
> PC as background service?
>
> 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<http://www.wyanokegroup.com/>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 
David Scoggins
dscogg...@gmail.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] moving UV from one server to another (windows)

[George Gallen]

Yes, but they will be running windows - which NEVER needs to be reboot unless 
it's
Something really serious!

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Monday, November 18, 2013 7:19 PM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

Hi Bob,
Post migration, one thing for consideration might be user education
regarding the new use of their workstation/PC?
No more will the user just be able to re-boot it when it freezes etc or
shut it down each night at home-o'clock.
Cheers
Peter

On 19/11/13 05:55, Woodward, Bob wrote:
> Oh, I'd always say go for more memory.  Especially if there are other
> Windows apps that are going to be used on that computer.  As to the
> locking, the normal record locks inside of UV once it's moved.  Just do
> a simple edit of a record on the workstation, then from another
> workstation, edit the same record.  If there is a problem, the
> workstation hosting UV is probably not locking the records.  When I saw
> the problem, it was because the workstation was accessing UV through the
> C: drive, which was local, of course.  To fix it, you have to map a
> network drive and ONLY use the network drive on that workstation.  The
> idea was that local drives didn't NEED to be locked since it's a single
> user OS.  At least that's the way it was explained to me.  Come to think
> of it, Win7 may not even maintain a network locking table.  Remember, I
> said I did this on a PE version where I was pretty much the only user.
>
> BobW
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Monday, November 18, 2013 11:38 AM
> To: U2 Users List
> Subject: Re: [U2] moving UV from one server to another (windows)
>
> Locking issues once UV is running on the Windows 7 machine, or locking
> issues caused by Copying over the data and overwriting the fresh
> install?
>
> This won't be a heavily used system (3 or 4 users maximum and even then
> should be too taxing).
>
> Should they max out the memory on the PC it's going to be installed on?
> Or is 4gb fine?
>
> George
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob
> Sent: Monday, November 18, 2013 2:28 PM
> To: U2 Users List
> Subject: Re: [U2] moving UV from one server to another (windows)
>
> One of the things you may need to watch real careful would be locking.
> Especially on the workstation that is hosting UV.   Then, as long as all
> the drive letters are the same as on the server, everything should be
> okay.  Of course, YMMV but I've done this type of swapping on my home
> network with the personal edition a number of years ago.
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Monday, November 18, 2013 11:04 AM
> To: U2 Users
> Subject: [U2] moving UV from one server to another (windows)
>
> Had someone ask me this question.  They are downsizing their PC's
>
> They have UV currently installed on a Windows Server PC - and each of
> the PC's using wintergate to access it.
> This server is having some issues, so they want to move UV off of it,
> and have it run on one of their "client" PC Running windows 7.
>
> My thought was that you would install UV on that PC, Then (with the
> services off), copy the file structure from The Server to the PC.
> Assuming the all the folders are named the same on both systems for the
> install. And of Course remove UV from the Server once all it good.
>
> Should this be all that would be needed?
>
> Will UV function on a Windows 7 PC?
> Can it be used as working PC - as well as be a UV server?
>
> Everything I've heard says it should run by itself - but - can it run on
> a PC as background service?
>
> 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<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
> ___
> U2-Users mailin

Re: [U2] moving UV from one server to another (windows)

[George Gallen]

Locking issues once UV is running on the Windows 7 machine, or locking issues 
caused by
Copying over the data and overwriting the fresh install?

This won't be a heavily used system (3 or 4 users maximum and even then should 
be too taxing).

Should they max out the memory on the PC it's going to be installed on? Or is 
4gb fine?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob
Sent: Monday, November 18, 2013 2:28 PM
To: U2 Users List
Subject: Re: [U2] moving UV from one server to another (windows)

One of the things you may need to watch real careful would be locking.
Especially on the workstation that is hosting UV.   Then, as long as all
the drive letters are the same as on the server, everything should be
okay.  Of course, YMMV but I've done this type of swapping on my home
network with the personal edition a number of years ago.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, November 18, 2013 11:04 AM
To: U2 Users
Subject: [U2] moving UV from one server to another (windows)

Had someone ask me this question.  They are downsizing their PC's

They have UV currently installed on a Windows Server PC - and each of
the PC's using wintergate to access it.
This server is having some issues, so they want to move UV off of it,
and have it run on one of their "client" PC Running windows 7.

My thought was that you would install UV on that PC, Then (with the
services off), copy the file structure from The Server to the PC.
Assuming the all the folders are named the same on both systems for the
install. And of Course remove UV from the Server once all it good.

Should this be all that would be needed?

Will UV function on a Windows 7 PC?
Can it be used as working PC - as well as be a UV server?

Everything I've heard says it should run by itself - but - can it run on
a PC as background service?

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<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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] moving UV from one server to another (windows)

[George Gallen]

Had someone ask me this question.  They are downsizing their PC's

They have UV currently installed on a Windows Server PC - and each of the PC's 
using wintergate to access it.
This server is having some issues, so they want to move UV off of it, and have 
it run on one of their "client" PC
Running windows 7.

My thought was that you would install UV on that PC, Then (with the services 
off), copy the file structure from
The Server to the PC. Assuming the all the folders are named the same on both 
systems for the install. And of
Course remove UV from the Server once all it good.

Should this be all that would be needed?

Will UV function on a Windows 7 PC?
Can it be used as working PC - as well as be a UV server?

Everything I've heard says it should run by itself - but - can it run on a PC 
as background service?

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<http://www.wyanokegroup.com/>

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

[U2] Non-SQL re-entrant query calls are not allowed??? (UV 10.0.2 )

[George Gallen]

OK.

I Setup a Subroutine that if I call from an IDESC Gives me the following error:
Non-SQL re-entrant query calls are not allowed'

Am I to take this as, you can't do a SELECT on a file, from an IDESC Subroutine?

However, If I call it from another basic program, it works just fine.

The program runs the following code:
   CMD="SELECT FRED-XREF-FILE WITH FILENAME = '":FILENAME:"' TO 5"
   PRINT CMD
   EXECUTE CMD RTNLIST CAPTURING JUNK
   PRINT JUNK
   PRINT @SELECTED:" SELECTED"
   SIDNO=""
   LOOP
  READNEXT ID FROM 5 ELSE EXIT
  PRINT ID
  SIDNO=FIELD(ID,"_",2)
   REPEAT
*

And the IDESC:
0001: I
0002: SUBR('*CRM.RETURN.PROFESSION','MASTER.HEMONC',@ID)
0003:
0004: PROFESSION
0005: 30L
0006: S

It's the SELECT that fails - but only when run from the IDESC

Example:

0001: FILE="MASTER.HEMONC"
0002: ID="123456"
0003: CALL *CRM.RETURN.PROFESSION(PROFESSION,FILE,ID)
0004: PRINT PROFESSION



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<http://www.wyanokegroup.com/>

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

Re: [U2] Export to Excel using XML

[George Gallen]

With which product?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti
Sent: Friday, October 25, 2013 6:54 AM
To: U2 Users List
Subject: Re: [U2] Export to Excel using XML

Funny how you have had success with this product when 
I have tried for what seems a year now with no success!
 


 From: George Gallen 
To: U2 Users List  
Sent: Thursday, October 17, 2013 9:28 AM
Subject: Re: [U2] Export to Excel using XML
  

Tony,

Great link - thanks.

"Thanks for expressing the pain that my clients do not. You are my new, best 
marketing resource."

No problemwhen I first read that, I thought it was going to say "I wrote a 
new blog entry over this.."

It's not so much the cost of implementing a product, but the time involved to 
integrate it.

I was just looking for a quick conversion type utility (which I will post in a 
followup)

Thanks
George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Wednesday, October 16, 2013 6:53 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Export to Excel using XML

Correct. It makes more sense if you know that the ss:Format attribute is really 
a complex field that describes what to do with positive numbers, negative 
numbers, zero, and then finally with text. Using "@" you're saying you don't 
want any formatting for numbers, only for text, and further, that you don't 
want to change the text that's there. If you wanted to include specific text 
for every cell, you would put it before the @. For examples of these formatting 
codes, right click a cell, go to Format Cells, Number, Custom, then scroll down 
through the list to the bottom.

For details on that topic:
http://office.microsoft.com/en-us/excel-help/create-or-delete-a-custom-number-format-HP001216503.aspx

To keep this in context with MV, NebulaXLite includes named formats so that you 
don't need to know this stuff, but it also allows you to enter custom codes 
when you want to take it to the next level. The product documentation helps 
with this.

Thanks for expressing the pain that my clients do not. You are my new, best 
marketing resource.

BTW, (duh) I forgot to mention that NebulaXLite is free for developers. All you 
need to do is to download the account for your platform, 
generate an activation request from TCL, and we'll return a key for a 
couple months. That gets renewed for as long as you want. No charge and no 
grief. The cost of only $200 (with free support) is only for end-users, and 
only after you have completed your development and they're running production. 
How tough is that?  ;)

Regards,
T



On Wednesday, October 16, 2013 1:52 PM, George Gallen wrote:

After saving the XML2003 from Excel, looks like NumberFormat ss:Format="@" is 
for Text???
___
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 Mount -t CIFS

[George Gallen]

Yes, when I setup the server, I added each user and manually assigned them the 
uid/gid from the other server,

This way when I overlay the data from the other system, everything works as 
planned (at least I keep telling
Myself that).

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Wednesday, October 09, 2013 2:07 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV and Mount -t CIFS

On 09/10/13 16:59, George Gallen wrote:
> No, it's not - it's a 0.
> 
> But...I didn't have it set to 1 on the old server either, and it worked.
> 
> If I change it.I assume I would need to bring UV down and restart?
> 
> What I essentially do is I backup the /uv directory on the old system,
> Did a fresh install of UV on the new server, then overwrite the /uv directory
>>From the old system 

Are your user numbers the same on the new system as the old - check who
owns the files by listing them on the machine the disk is physically in.

Cheers,
Wol
___
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 Mount -t CIFS

[George Gallen]

No that was the first thing I disabled!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little
Sent: Wednesday, October 09, 2013 2:05 PM
To: U2 Users List
Subject: Re: [U2] UV and Mount -t CIFS

Is SELINUX enabled?  That's caused me headaches in the past.

bob little
applications architect
independent contractor
market america, inc.
1302 pleasant ridge rd.
greensboro, nc  27409
Phone: 336-698-4367
Cell: 248-675-5515
Skype: boblittle904



From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] on behalf of George Gallen 
[ggal...@wyanokegroup.com]
Sent: Wednesday, October 09, 2013 1:34 PM
To: U2 Users List
Subject: Re: [U2] UV and Mount -t CIFS

Thanks...

I tried all the variations of sec - most mounted - some failed - but none 
allowed UV to LIST the directory
I also added ver=1.0

I may need to setup a ftp server on the printwizard machine, and work around 
that way until I figure it out.

We will be upgrading the RHEL5 to RHEL6 once our server issues are fixed - so 
maybe RHEL6 will be ok (or not)
Found a bunch of things different from RHEL5 to Fedora19  (switches in ftp, 
mailx and attachments and
Few others I forget at the moment).

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little
Sent: Wednesday, October 09, 2013 10:31 AM
To: U2 Users List
Subject: Re: [U2] UV and Mount -t CIFS

I had to add the sec=ntlm to the line in my /etc/fstab since about FC18 or so:

//shareName   mountPointcifs
rw,credentials=.myCredentials,_netdev,sec=ntlm,users,nounix,nosetuids,file_mode=0644,dir_mode=0775
   0 0

bob little
applications architect
independent contractor
market america, inc.
1302 pleasant ridge rd.
greensboro, nc  27409
Phone: 336-698-4367
Cell: 248-675-5515
Skype: boblittle904



From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] on behalf of George Gallen 
[ggal...@wyanokegroup.com]
Sent: Wednesday, October 09, 2013 10:16 AM
To: U2 Users
Subject: [U2] UV and Mount -t CIFS

Ok...

When I had RHEL5 and UV 10.0.2 running, If I did a mount using type cifs
   All I needed to do in UV was <1>F , <2>/mnt/mountname, <3>D_SOURCE

And I could list the directory, no problem.


Due to a server issue, we had to put an emergency server in place that is
Running Fedora19 (64 bit) and installed the UV 10.0.2 - which appears to
Run fine.

EXCEPT - when I mount the share

Now when I attempt to LIST the File (or OPENPATH /mnt/sharename) it bombs out
Gives me "Unable to open -filename-"

I can as non-root, go into this share, create files, delete files and modify 
files so it
Also works as root.

So, I'm not sure if this is a UV related issue or a Fedora19/Windows machine 
share problem.

Any ideas?

I'm currently doing:
mount -t cifs -o rw,username=windowsloginname 
"//Sharename",file_mode=0777,dir_mode=0777,cifsacl /mnt/printwizard

What we do is use lpd to print our PCL to printwizard (which works)
Printwizard then produces a PDF (which works)
Then we read the PDF from the share on the printwizard machine (which is what 
is not working).
___
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] UV and Mount -t CIFS

[George Gallen]

Thanks...

I tried all the variations of sec - most mounted - some failed - but none 
allowed UV to LIST the directory
I also added ver=1.0

I may need to setup a ftp server on the printwizard machine, and work around 
that way until I figure it out.

We will be upgrading the RHEL5 to RHEL6 once our server issues are fixed - so 
maybe RHEL6 will be ok (or not)
Found a bunch of things different from RHEL5 to Fedora19  (switches in ftp, 
mailx and attachments and
Few others I forget at the moment).

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little
Sent: Wednesday, October 09, 2013 10:31 AM
To: U2 Users List
Subject: Re: [U2] UV and Mount -t CIFS

I had to add the sec=ntlm to the line in my /etc/fstab since about FC18 or so:

//shareName   mountPointcifs
rw,credentials=.myCredentials,_netdev,sec=ntlm,users,nounix,nosetuids,file_mode=0644,dir_mode=0775
   0 0

bob little
applications architect
independent contractor
market america, inc.
1302 pleasant ridge rd.
greensboro, nc  27409
Phone: 336-698-4367
Cell: 248-675-5515
Skype: boblittle904



From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] on behalf of George Gallen 
[ggal...@wyanokegroup.com]
Sent: Wednesday, October 09, 2013 10:16 AM
To: U2 Users
Subject: [U2] UV and Mount -t CIFS

Ok...

When I had RHEL5 and UV 10.0.2 running, If I did a mount using type cifs
   All I needed to do in UV was <1>F , <2>/mnt/mountname, <3>D_SOURCE

And I could list the directory, no problem.


Due to a server issue, we had to put an emergency server in place that is
Running Fedora19 (64 bit) and installed the UV 10.0.2 - which appears to
Run fine.

EXCEPT - when I mount the share

Now when I attempt to LIST the File (or OPENPATH /mnt/sharename) it bombs out
Gives me "Unable to open -filename-"

I can as non-root, go into this share, create files, delete files and modify 
files so it
Also works as root.

So, I'm not sure if this is a UV related issue or a Fedora19/Windows machine 
share problem.

Any ideas?

I'm currently doing:
mount -t cifs -o rw,username=windowsloginname 
"//Sharename",file_mode=0777,dir_mode=0777,cifsacl /mnt/printwizard

What we do is use lpd to print our PCL to printwizard (which works)
Printwizard then produces a PDF (which works)
Then we read the PDF from the share on the printwizard machine (which is what 
is not working).
___
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 Mount -t CIFS

[George Gallen]

No, it's not - it's a 0.

But...I didn't have it set to 1 on the old server either, and it worked.

If I change it.I assume I would need to bring UV down and restart?

What I essentially do is I backup the /uv directory on the old system,
Did a fresh install of UV on the new server, then overwrite the /uv directory
>From the old system 

It's worked fine in the past - and UV seems to be running healthy on F19

For now, I'm going to use an ftp workaround - I can't bring down UV at the 
moment.

George


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, October 09, 2013 11:46 AM
To: 'U2 Users List'
Subject: Re: [U2] UV and Mount -t CIFS

Have you got the ALLOWNFS setting in your uvconfig set to 1 ?

Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 09 October 2013 15:16
To: U2 Users
Subject: [U2] UV and Mount -t CIFS

Ok...

When I had RHEL5 and UV 10.0.2 running, If I did a mount using type cifs
   All I needed to do in UV was <1>F , <2>/mnt/mountname, <3>D_SOURCE

And I could list the directory, no problem.


Due to a server issue, we had to put an emergency server in place that is
Running Fedora19 (64 bit) and installed the UV 10.0.2 - which appears to Run
fine.

EXCEPT - when I mount the share

Now when I attempt to LIST the File (or OPENPATH /mnt/sharename) it bombs
out Gives me "Unable to open -filename-"

I can as non-root, go into this share, create files, delete files and modify
files so it Also works as root.

So, I'm not sure if this is a UV related issue or a Fedora19/Windows machine
share problem.

Any ideas?

I'm currently doing:
mount -t cifs -o rw,username=windowsloginname
"//Sharename",file_mode=0777,dir_mode=0777,cifsacl /mnt/printwizard

What we do is use lpd to print our PCL to printwizard (which works)
Printwizard then produces a PDF (which works) Then we read the PDF from the
share on the printwizard machine (which is what is not working).
___
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 and Mount -t CIFS

[George Gallen]

Ok...

When I had RHEL5 and UV 10.0.2 running, If I did a mount using type cifs
   All I needed to do in UV was <1>F , <2>/mnt/mountname, <3>D_SOURCE

And I could list the directory, no problem.


Due to a server issue, we had to put an emergency server in place that is
Running Fedora19 (64 bit) and installed the UV 10.0.2 - which appears to
Run fine.

EXCEPT - when I mount the share

Now when I attempt to LIST the File (or OPENPATH /mnt/sharename) it bombs out
Gives me "Unable to open -filename-"

I can as non-root, go into this share, create files, delete files and modify 
files so it
Also works as root.

So, I'm not sure if this is a UV related issue or a Fedora19/Windows machine 
share problem.

Any ideas?

I'm currently doing:
mount -t cifs -o rw,username=windowsloginname 
"//Sharename",file_mode=0777,dir_mode=0777,cifsacl /mnt/printwizard

What we do is use lpd to print our PCL to printwizard (which works)
Printwizard then produces a PDF (which works)
Then we read the PDF from the share on the printwizard machine (which is what 
is not working).
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Interesting....

[George Gallen]

Well that one is an obvious no - since the debugger works at the input 
statement in that program,
  But wasn't working when it was stuck in the loop.

That is what I meant by "by not actually trying" - if it's a method that is 
intentional to turn
  Off the debugger, then that is not the cause - this program essentially has 
been running for
  About 20 years, and the only change to that area was converting a GOTO to 
jump over statements
  To a LOOP - which I accidentally put in continue instead of exit.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 1:55 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

The command that makes the BASIC program *run* supports an option to turn it 
off.
That's one way out of dozens

I'm not going to go through them all here :)

 

 

 

-----Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Thu, Oct 3, 2013 10:44 am
Subject: Re: [U2] Interesting


I can't really provide any more details.

What would be the most common ways to turn off the debugger? By not actually 
trying...

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 1:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

It's impossible to debug your situation, without more details.
The code you posted is NOT the problem.
It's elsewhere.  To determine where we need to know more details.
Sorry, there's just too many ways to turn off the debugger.

 

 
___
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] Interesting....

[George Gallen]

I can't really provide any more details.

What would be the most common ways to turn off the debugger? By not actually 
trying...

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 1:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

It's impossible to debug your situation, without more details.
The code you posted is NOT the problem.
It's elsewhere.  To determine where we need to know more details.
Sorry, there's just too many ways to turn off the debugger.

 

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

Re: [U2] Interesting....

[George Gallen]

Good question...

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 1:29 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

If it worked fine for you, then what's the problem?
 

 

 

-Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Thu, Oct 3, 2013 10:27 am
Subject: Re: [U2] Interesting


Yes, it worked fine for me as well - which is what confused me. 

The only other time I've seen the D option not available, is when it's
Executing a TCL command, which was not the case in this program.

Knowing the variety of ways it can be turned off was what my question was,
>From there I'd have to look into whether any fit the mold.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 1:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

The portion you posted works perfectly fine on my system.
It's quite likely that another portion you didn't post is the problem.
The 'D' option can be turned off in a variety of ways.
Without having more details its not very easy to find the cause.

 

 

 
___
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] Interesting....

[George Gallen]

Yes, it worked fine for me as well - which is what confused me. 

The only other time I've seen the D option not available, is when it's
Executing a TCL command, which was not the case in this program.

Knowing the variety of ways it can be turned off was what my question was,
>From there I'd have to look into whether any fit the mold.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 1:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

The portion you posted works perfectly fine on my system.
It's quite likely that another portion you didn't post is the problem.
The 'D' option can be turned off in a variety of ways.
Without having more details its not very easy to find the cause.

 

 

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

Re: [U2] Interesting....

[George Gallen]

I'm fairly confident that the Break= is not applicable to my connection
Since it's not a serial connection where a break signal could be sent.
The portion that would be applicable is INTR= ^C  - which did work,
When I hit control C, it interrupted the program. So the interrupt portion
Isn't the issue (or shouldn't be).

Posting the full code is not possible - over 1500 lines and well boss wouldn't 
like it either.
The code sample posted was the code in question with the names changed to 
protect the innocent.

George


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, October 03, 2013 12:24 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

I don't think this is it.
Perhaps George you could post the full code that is the actual issue, not just 
an example.
We could then test it, to see if your symptom can be replicated.
However I still don't like Break=Null, that seems wrong to me.
It should say Break=Intr


 

 

 

-Original Message-
From: Ed Clark 
To: U2 Users List 
Sent: Thu, Oct 3, 2013 5:32 am
Subject: Re: [U2] Interesting


My guess would be that it's because the loop was very tight. I've seen lots of 
instances where tight loops couldn't be interrupted at all. Maybe in this case 
it wasn't in basic code when it interrupted, and couldn't find any basic code 
within a few steps, so didn't offer D.

On Oct 2, 2013, at 11:30 PM, George Gallen  wrote:

> Nothing special in the compile. Why would it give the D in one part of the 
program ,
> but not in another? Just very strange.
> 
> Oh wellguess I'll have to chalk it up the computer having indigestion or 
something;
> Hopefully it didn't pick up a virus or bug! (I think I found them all now - 
but you never
> know)
> 
> -Original Message- From: Kevin King
> Sent: Wednesday, October 02, 2013 11:13 PM
> To: U2 Users List
> Subject: Re: [U2] Interesting
> 
> Isn't there something that strips the symbol table during compile? If the
> symbol table were suppressed the D might not appear because it couldn't do
> much anyway, right?
> On Oct 2, 2013 11:53 AM, "George Gallen"  wrote:
> 
>> I Don't know? I never really looked into the PTERM signals.
>> 
>> I would think that is referring to a Break signal vs Control C  (but I
>> don't know)
>> 
>> It's not that the Break is disabled - just the DEBUG option was missing.
>> 
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org [mailto:
>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson
>> Sent: Wednesday, October 02, 2013 1:51 PM
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] Interesting
>> 
>> Is BREAK=NULL what you expected to see ?
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> -Original Message-
>> From: George Gallen-2 [via U2 (UniVerse & UniData)] <
>> ml-node+s1073795n41901...@n5.nabble.com>
>> To: Will Johnson 
>> Sent: Wed, Oct 2, 2013 10:46 am
>> Subject: Re: Interesting
>> 
>> 
>>>PTERM DISPLAY  (RUNNING UV 10.0.2)
>> 
>> MODEEMULATE
>> CC  INTR= ^C  QUIT= ^\  SUSP= OFF DSUSP   = OFF
>>SWITCH  = OFF ERASE   = ^H  WERASE  = OFF KILL= ^U
>>LNEXT   = OFF REPRINT = OFF EOF = ^D  EOL = ^@
>>EOL2= ^@  FLUSH   = OFF START   = ^Q  STOP= ^S
>>LCONT   = ^_  FMC = ^^  VMC = ^]  SMC = ^\
>>TMC = ^T  SQLNULL = ^N
>> INPUTCTLOFF
>> CARRIER RECEIVE -HANGUP -LOCAL
>> CASE-UCIN -UCOUT -XCASE -INVERT
>> CRMODE  -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY
>> DELAY   BS0 CR0 FF0 LF0 VT0 TAB0 -FILL
>> ECHOECHO ERASE=BSB KILL=LF CTRL -LF
>> HANDSHAKE   XON -ANY -TANDEM -DTR
>> OUTPUT  POST -TILDE -BG CS -EXPAND
>> PROTOCOLLINE=0 BAUD=9600 DATA=8 STOP=1 NONE DISABLE -STRIP
>> SIGNALS ENABLE FLUSH BREAK=NULL
>> 
>> 
>> 
>> -Original Message-
>> From: [hidden email] [mailto:[hidden email]] On Behalf Of Wjhonson
>> Sent: Wednesday, October 02, 2013 1:23 PM
>> To: [hidden email]
>> Subject: Re: [U2] Interesting
>> 
>> The INTR.KEY in the VOC is not the only thing controlling breaking
>> behaviour.
>> It specifies the maximum level of ability, not the minimum, it can be
>> overridden.
>> 
>> However,

Re: [U2] Interesting....

[George Gallen]

Sounds reasonable. 

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark
Sent: Thursday, October 03, 2013 8:32 AM
To: U2 Users List
Subject: Re: [U2] Interesting

My guess would be that it's because the loop was very tight. I've seen lots of 
instances where tight loops couldn't be interrupted at all. Maybe in this case 
it wasn't in basic code when it interrupted, and couldn't find any basic code 
within a few steps, so didn't offer D.

On Oct 2, 2013, at 11:30 PM, George Gallen  wrote:

> Nothing special in the compile. Why would it give the D in one part of the 
> program ,
> but not in another? Just very strange.
> 
> Oh wellguess I'll have to chalk it up the computer having indigestion or 
> something;
> Hopefully it didn't pick up a virus or bug! (I think I found them all now - 
> but you never
> know)
> 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Interesting....

[George Gallen]

Nothing special in the compile. Why would it give the D in one part of the 
program ,

but not in another? Just very strange.

Oh wellguess I'll have to chalk it up the computer having indigestion or 
something;
Hopefully it didn't pick up a virus or bug! (I think I found them all now - 
but you never

know)

-Original Message- 
From: Kevin King

Sent: Wednesday, October 02, 2013 11:13 PM
To: U2 Users List
Subject: Re: [U2] Interesting

Isn't there something that strips the symbol table during compile? If the
symbol table were suppressed the D might not appear because it couldn't do
much anyway, right?
On Oct 2, 2013 11:53 AM, "George Gallen"  wrote:


I Don't know? I never really looked into the PTERM signals.

I would think that is referring to a Break signal vs Control C  (but I
don't know)

It's not that the Break is disabled - just the DEBUG option was missing.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson
Sent: Wednesday, October 02, 2013 1:51 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

Is BREAK=NULL what you expected to see ?








-Original Message-
From: George Gallen-2 [via U2 (UniVerse & UniData)] <
ml-node+s1073795n41901...@n5.nabble.com>
To: Will Johnson 
Sent: Wed, Oct 2, 2013 10:46 am
Subject: Re: Interesting


>PTERM DISPLAY  (RUNNING UV 10.0.2)

MODEEMULATE
CC  INTR= ^C  QUIT= ^\  SUSP= OFF DSUSP   = OFF
SWITCH  = OFF ERASE   = ^H  WERASE  = OFF KILL= ^U
LNEXT   = OFF REPRINT = OFF EOF = ^D  EOL = ^@
EOL2= ^@  FLUSH   = OFF START   = ^Q  STOP= ^S
LCONT   = ^_  FMC = ^^  VMC = ^]  SMC = ^\
TMC = ^T  SQLNULL = ^N
INPUTCTLOFF
CARRIER RECEIVE -HANGUP -LOCAL
CASE-UCIN -UCOUT -XCASE -INVERT
CRMODE  -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY
DELAY   BS0 CR0 FF0 LF0 VT0 TAB0 -FILL
ECHOECHO ERASE=BSB KILL=LF CTRL -LF
HANDSHAKE   XON -ANY -TANDEM -DTR
OUTPUT  POST -TILDE -BG CS -EXPAND
PROTOCOLLINE=0 BAUD=9600 DATA=8 STOP=1 NONE DISABLE -STRIP
SIGNALS ENABLE FLUSH BREAK=NULL



-Original Message-
From: [hidden email] [mailto:[hidden email]] On Behalf Of Wjhonson
Sent: Wednesday, October 02, 2013 1:23 PM
To: [hidden email]
Subject: Re: [U2] Interesting

The INTR.KEY in the VOC is not the only thing controlling breaking
behaviour.
It specifies the maximum level of ability, not the minimum, it can be
overridden.

However, please type PTERM DISPLAY at TCL and post the results for us to
review.
That is your first step, before we get more technical.








-Original Message-
From: George Gallen <[hidden email]>
To: U2 Users List <[hidden email]>
Sent: Wed, Oct 2, 2013 10:20 am
Subject: Re: [U2] Interesting


Yes...

The only time I've not had the "D" option, is when I break from a VOC
Which is expected, since you can't debug a VOC.

So, why would the D option not appear when you break from a basic program?
Whenit does when you break from an input
it does when another program is in a loop
just this program in this loop it did not appear

And it wasn't executing a SELECT that was taking a long time or something,
then
  That would be like breaking out of a VOC

George
___
U2-Users mailing list
[hidden email]
http://listserver.u2ug.org/mailman/listinfo/u2-users





If you reply to this email, your message will be added to the discussion
below:

http://u2-universe-unidata.1073795.n5.nabble.com/Interesting-tp41892p41901.html

To start a new topic under U2 - Users, email
ml-node+s1073795n3...@n5.nabble.com
To unsubscribe from U2 (UniVerse & UniData), click here.
NAML





--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/Interesting-tp41892p41905.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-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] Interesting....

[George Gallen]

I Don't know? I never really looked into the PTERM signals.

I would think that is referring to a Break signal vs Control C  (but I don't 
know)

It's not that the Break is disabled - just the DEBUG option was missing.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson
Sent: Wednesday, October 02, 2013 1:51 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

Is BREAK=NULL what you expected to see ?


 

 

 

-Original Message-----
From: George Gallen-2 [via U2 (UniVerse & UniData)] 

To: Will Johnson 
Sent: Wed, Oct 2, 2013 10:46 am
Subject: Re: Interesting


>PTERM DISPLAY  (RUNNING UV 10.0.2)

MODEEMULATE
CC  INTR= ^C  QUIT= ^\  SUSP= OFF DSUSP   = OFF
SWITCH  = OFF ERASE   = ^H  WERASE  = OFF KILL= ^U
LNEXT   = OFF REPRINT = OFF EOF = ^D  EOL = ^@
EOL2= ^@  FLUSH   = OFF START   = ^Q  STOP= ^S
LCONT   = ^_  FMC = ^^  VMC = ^]  SMC = ^\
TMC = ^T  SQLNULL = ^N
INPUTCTLOFF
CARRIER RECEIVE -HANGUP -LOCAL
CASE-UCIN -UCOUT -XCASE -INVERT
CRMODE  -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY
DELAY   BS0 CR0 FF0 LF0 VT0 TAB0 -FILL
ECHOECHO ERASE=BSB KILL=LF CTRL -LF
HANDSHAKE   XON -ANY -TANDEM -DTR
OUTPUT  POST -TILDE -BG CS -EXPAND
PROTOCOLLINE=0 BAUD=9600 DATA=8 STOP=1 NONE DISABLE -STRIP
SIGNALS ENABLE FLUSH BREAK=NULL



-Original Message-
From: [hidden email] [mailto:[hidden email]] On Behalf Of Wjhonson
Sent: Wednesday, October 02, 2013 1:23 PM
To: [hidden email]
Subject: Re: [U2] Interesting

The INTR.KEY in the VOC is not the only thing controlling breaking behaviour.
It specifies the maximum level of ability, not the minimum, it can be 
overridden.

However, please type PTERM DISPLAY at TCL and post the results for us to review.
That is your first step, before we get more technical.


 

 

 

-Original Message-----
From: George Gallen <[hidden email]>
To: U2 Users List <[hidden email]>
Sent: Wed, Oct 2, 2013 10:20 am
Subject: Re: [U2] Interesting


Yes...

The only time I've not had the "D" option, is when I break from a VOC 
Which is expected, since you can't debug a VOC.

So, why would the D option not appear when you break from a basic program?
Whenit does when you break from an input
it does when another program is in a loop
just this program in this loop it did not appear

And it wasn't executing a SELECT that was taking a long time or something, then
  That would be like breaking out of a VOC

George
___
U2-Users mailing list
[hidden email]
http://listserver.u2ug.org/mailman/listinfo/u2-users





If you reply to this email, your message will be added to the discussion below:

http://u2-universe-unidata.1073795.n5.nabble.com/Interesting-tp41892p41901.html 

To start a new topic under U2 - Users, email 
ml-node+s1073795n3...@n5.nabble.com 
To unsubscribe from U2 (UniVerse & UniData), click here.
NAML





--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/Interesting-tp41892p41905.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Interesting....

[George Gallen]

>PTERM DISPLAY  (RUNNING UV 10.0.2)

MODEEMULATE
CC  INTR= ^C  QUIT= ^\  SUSP= OFF DSUSP   = OFF
SWITCH  = OFF ERASE   = ^H  WERASE  = OFF KILL= ^U
LNEXT   = OFF REPRINT = OFF EOF = ^D  EOL = ^@
EOL2= ^@  FLUSH   = OFF START   = ^Q  STOP= ^S
LCONT   = ^_  FMC = ^^  VMC = ^]  SMC = ^\
TMC = ^T  SQLNULL = ^N
INPUTCTLOFF
CARRIER RECEIVE -HANGUP -LOCAL
CASE-UCIN -UCOUT -XCASE -INVERT
CRMODE  -INLCR -IGNCR ICRNL ONLCR -OCRNL -ONOCR -ONLRET -CRONLY
DELAY   BS0 CR0 FF0 LF0 VT0 TAB0 -FILL
ECHOECHO ERASE=BSB KILL=LF CTRL -LF
HANDSHAKE   XON -ANY -TANDEM -DTR
OUTPUT  POST -TILDE -BG CS -EXPAND
PROTOCOLLINE=0 BAUD=9600 DATA=8 STOP=1 NONE DISABLE -STRIP
SIGNALS ENABLE FLUSH BREAK=NULL



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, October 02, 2013 1:23 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

The INTR.KEY in the VOC is not the only thing controlling breaking behaviour.
It specifies the maximum level of ability, not the minimum, it can be 
overridden.

However, please type PTERM DISPLAY at TCL and post the results for us to review.
That is your first step, before we get more technical.


 

 

 

-Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Wed, Oct 2, 2013 10:20 am
Subject: Re: [U2] Interesting


Yes...

The only time I've not had the "D" option, is when I break from a VOC 
Which is expected, since you can't debug a VOC.

So, why would the D option not appear when you break from a basic program?
Whenit does when you break from an input
it does when another program is in a loop
just this program in this loop it did not appear

And it wasn't executing a SELECT that was taking a long time or something, then
  That would be like breaking out of a VOC

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

Re: [U2] Interesting....

[George Gallen]

Yes...

The only time I've not had the "D" option, is when I break from a VOC 
Which is expected, since you can't debug a VOC.

So, why would the D option not appear when you break from a basic program?
Whenit does when you break from an input
it does when another program is in a loop
just this program in this loop it did not appear

And it wasn't executing a SELECT that was taking a long time or something, then
  That would be like breaking out of a VOC

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, October 02, 2013 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Interesting

You mean if you break out at a BASIC input ?
If you break from a VOC you don't get the debug option, because you cannot 
debug VOC entries

 

 

 

-----Original Message-
From: George Gallen 
To: U2 Users List 
Sent: Wed, Oct 2, 2013 10:08 am
Subject: Re: [U2] Interesting


Both accounts (my login and the active one) have the D in INTR.KEY

I now if I break out of a VOC, then the D is not an option
And if I break out of that same program at an input, or when it's not stuck in 
a 
loop - the D was an option
And when I wrote the test program below - and broke out of that loop - the D 
was 
an option.

So my question still is, why would one program's loop not give the D option, 
whereas others do?

Putting in the debug statements were probably faster than running port.status 
50 
or 100 times :)
I just used a binary sort method to hone in on where in the program it was near 
- then looking
   At the source code - I was able to spot the problem. Fairly quick.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of Ladd, Ryan
Sent: Wednesday, October 02, 2013 12:13 PM
To: U2 Users List
Subject: Re: [U2] Interesting

The "INTR.KEY" entry in the VOC determines what options are given when a user 
"breaks" out of a program.  The "D" is for the debug option.
 INTR.KEY
001 X-type - Define options available when INTR key is hit
002 ACLQD
>
One thing to note...  The options defined in INTR.KEY are read in when you 
first 
enter Universe and are NOT re-read when you log between accounts.  Whatever 
options are defined in the first account you log into will be the available 
options for your entire session.


As a side note, you mention that you were trying to figure out where you were 
"getting stuck".

  The use of PORT.STATUS using the "PID" option and "LAYER.STACK" (>PORT.STATUS 
PID 123456 LAYER.STACK) over and over again can show you what hex address in 
the 
program your process is at.  I suggest calling this 50 or 100 times in a row 
and 
inspecting the output.  Once you have the hex addresses, use "VLIST" to figure 
out what line in the program each address represents.

Ryan



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
On Behalf Of George Gallen
Sent: Wednesday, October 02, 2013 9:07 AM
To: U2 Users
Subject: [U2] Interesting

LOOP
   IF (1=1) THEN CONTINUE
REPEAT
END

Run this program (yes, I know - it's an endless loop).
Then Control C to break out

D is one of the debug options (and lets you know what line your on).

However, when I had something like this in my program, when it got stuck
D wasn't one of the options - I had to start putting debug lines throughout the 
program
   To isolate what area I was getting stuck at.

What would cause that to be missing?   (I wasn't calling or executing anything 
at the time)


As a side note: the above had me thinking
First we execute a program, then if it's doesn't die, we kill it!

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

Note: The information contained in this message may be privileged and 
confidential and protected from disclosure. If the reader of this message is 
not 
the intended recipient, or an employee or agent responsible for delivering this 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify us 
immediately by replying to the message and deleting it from your computer.
___
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] Interesting....

[George Gallen]

Both accounts (my login and the active one) have the D in INTR.KEY

I now if I break out of a VOC, then the D is not an option
And if I break out of that same program at an input, or when it's not stuck in 
a loop - the D was an option
And when I wrote the test program below - and broke out of that loop - the D 
was an option.

So my question still is, why would one program's loop not give the D option, 
whereas others do?

Putting in the debug statements were probably faster than running port.status 
50 or 100 times :)
I just used a binary sort method to hone in on where in the program it was near 
- then looking
   At the source code - I was able to spot the problem. Fairly quick.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ladd, Ryan
Sent: Wednesday, October 02, 2013 12:13 PM
To: U2 Users List
Subject: Re: [U2] Interesting

The "INTR.KEY" entry in the VOC determines what options are given when a user 
"breaks" out of a program.  The "D" is for the debug option.
 INTR.KEY
001 X-type - Define options available when INTR key is hit
002 ACLQD
>
One thing to note...  The options defined in INTR.KEY are read in when you 
first enter Universe and are NOT re-read when you log between accounts.  
Whatever options are defined in the first account you log into will be the 
available options for your entire session.


As a side note, you mention that you were trying to figure out where you were 
"getting stuck".

  The use of PORT.STATUS using the "PID" option and "LAYER.STACK" (>PORT.STATUS 
PID 123456 LAYER.STACK) over and over again can show you what hex address in 
the program your process is at.  I suggest calling this 50 or 100 times in a 
row and inspecting the output.  Once you have the hex addresses, use "VLIST" to 
figure out what line in the program each address represents.

Ryan



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, October 02, 2013 9:07 AM
To: U2 Users
Subject: [U2] Interesting

LOOP
   IF (1=1) THEN CONTINUE
REPEAT
END

Run this program (yes, I know - it's an endless loop).
Then Control C to break out

D is one of the debug options (and lets you know what line your on).

However, when I had something like this in my program, when it got stuck
D wasn't one of the options - I had to start putting debug lines throughout the 
program
   To isolate what area I was getting stuck at.

What would cause that to be missing?   (I wasn't calling or executing anything 
at the time)


As a side note: the above had me thinking
First we execute a program, then if it's doesn't die, we kill it!

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

Note: The information contained in this message may be privileged and 
confidential and protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify us 
immediately by replying to the message and deleting it from your computer.
___
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] Interesting....

[George Gallen]

LOOP
   IF (1=1) THEN CONTINUE
REPEAT
END

Run this program (yes, I know - it's an endless loop).
Then Control C to break out

D is one of the debug options (and lets you know what line your on).

However, when I had something like this in my program, when it got stuck
D wasn't one of the options - I had to start putting debug lines throughout the 
program
   To isolate what area I was getting stuck at.

What would cause that to be missing?   (I wasn't calling or executing anything 
at the time)


As a side note: the above had me thinking
First we execute a program, then if it's doesn't die, we kill it!

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

[U2] sorting and special characters.

[George Gallen]

Just found something odd that occurs when sorting (at least with Microsoft).

We were comparing a sorted list of emails on UV against a sorted list of emails 
in excel (manually comparing)

It appears U2 and Microsoft differ on how they treat "-" (dash)

U2 sorts it where it belongs either ASCII wise or as a special character 
(before letters), whereas Microsoft just
   Ignores the dash.

Example:

Hello-there
Hellobear
Hellozare

Would be the order on U2

Hellobear
Hello-there
Hellozare

Would be the order in Microsoft land - (like Excel)

Things that make you go huh? Why'd they do that? To make things stranger, both 
U2 and Microsoft treat
"." And "_" the same, as special characters - before letters.

But...I guess from a human perspective, ignoring the "-" would make more sense, 
but then why wouldn't
You ignore "." And "_" also?

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

[U2] Old MacDonald had U2 [EI] [EIO].....

[George Gallen]

Read operation failure.  [EIO] I/O error

First thing that popped into my mind when this little gem occurred!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Old MacDonald had U2 [EI] [EIO].....

[George Gallen]

Actually, it said a little more

That the file was corrupt and needed to be fixed.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, September 11, 2013 2:59 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Old MacDonald had U2 [EI] [EIO].

And I have to say that's a beautiful error message.
Giving you no useful content to tell what it means :)

"An alligator bit through the cable connecting your computer room to the 
ventilation system"


 

 

 

-Original Message-----
From: George Gallen 
To: U2 Users 
Sent: Wed, Sep 11, 2013 11:45 am
Subject: [U2] Old MacDonald had U2 [EI] [EIO].


Read operation failure.  [EIO] I/O error

First thing that popped into my mind when this little gem occurred!
___
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] Old MacDonald had U2 [EI] [EIO].....

[George Gallen]

I wasn't too worried. The file itself is in a temporary filespace (memory), and 
gets rebuild each night.

I'll worry about tomorrow if it happens again.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Wednesday, September 11, 2013 2:53 PM
To: U2 Users List
Subject: Re: [U2] Old MacDonald had U2 [EI] [EIO].

I have no idea what to do with this one, George. But thanks for 
brightening my afternoon.
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
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] SQL Update Multiple rows

[George Gallen]

CoolBorg SQL.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Friday, August 23, 2013 4:29 AM
To: 'U2 Users List'
Subject: Re: [U2] SQL Update Multiple rows

Hi Riverman

That's obviously TSQL and therefore Microsoft specific. You can get clever
in that way by mixing UniVerse SQL and EVAL expressions (which are the same
as inline IDescriptors in RetrieVe)

This should work the same as the example below:

UPDATE Product  SET Availability = EVAL "IF ProductId = 1 THEN 5 ELSE IF
ProductId = 2 THEN 5 ELSE IF ProductId = 6 THEN 5 ELSE Availability" ;


Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Riverman
Sent: 22 August 2013 18:23
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL Update Multiple rows


Here is the SQL example I am trying to follow

UPDATE dbo.Product
   SET Availability=CASE When ProductId='1' Then '5'
 When ProductId='2' Then '5'
 When ProductId='6' Then '10'
 Else Availability
 END

My attempts

>UPDATE TESTFILE SET TRAN.NUMBER=CASE WHEN CONTROL.NUMBER.NFMT='9001' 
>THEN
'' WHEN CONTROL.NUMBER.NFMT='66551' THEN '' WHEN CONTROL.NUMBER.NFMT='1205'
THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: A WHEN clause must have at least one multi-valued column

>UPDATE TESTFILE SET TRAN.NUMBER=CASE WHERE CONTROL.NUMBER.NFMT='9001' 
>THEN
'' WHERE CONTROL.NUMBER.NFMT='66551' THEN '' WHERE
CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "THEN".
Scanned command was UPDATE RECEIPT SET TRANSACTION.H = CASE WHERE
CONTROL.NUMBER.NFMT = "900166550841" THEN 

Universe 10.1.1, Windows Server 2003



--
View this message in context:
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp
41681.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] SQL Update Multiple rows

[George Gallen]

UPDATE TESTFILE SET TRAN.NUMBER="" WHERE CONTROL.NUMBER.NFMT='9001' OR 
CONTROL.NUMBER.NFMT='66551' OR CONTROL.NUMBER.NFMT='1205'

Should do what you want

George

Basically, only clear out TRAN.NUMBER if CONTROL.NUMBER.NFMT is one of three 
values.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Riverman
Sent: Thursday, August 22, 2013 1:23 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SQL Update Multiple rows


Here is the SQL example I am trying to follow

UPDATE dbo.Product
   SET Availability=CASE When ProductId='1' Then '5'
 When ProductId='2' Then '5'
 When ProductId='6' Then '10'
 Else Availability
 END

My attempts

>UPDATE TESTFILE SET TRAN.NUMBER=CASE WHEN CONTROL.NUMBER.NFMT='9001' THEN
'' WHEN CONTROL.NUMBER.NFMT='66551' THEN '' WHEN CONTROL.NUMBER.NFMT='1205'
THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: A WHEN clause must have at least one multi-valued column

>UPDATE TESTFILE SET TRAN.NUMBER=CASE WHERE CONTROL.NUMBER.NFMT='9001' THEN
'' WHERE CONTROL.NUMBER.NFMT='66551' THEN '' WHERE
CONTROL.NUMBER.NFMT='1205' THEN '' ELSE TRAN.NUMBER END;
UniVerse/SQL: syntax error.  Unexpected symbol.  Token was "THEN".
Scanned command was UPDATE RECEIPT SET TRANSACTION.H = CASE WHERE
CONTROL.NUMBER.NFMT = "900166550841" THEN 

Universe 10.1.1, Windows Server 2003



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/SQL-Update-Multiple-rows-tp41681.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] TU.SQL.CONNECT

[George Gallen]

Leftout FIRSTFIELD as an IN: variable  - setup as below:

1200:
   CRMFIELDS="field1, field2, field3"
   CRMFILE="table1name inner join table2name on (field1 = field2)"
   CRMWHERE="where field1 = 'value' ORDER BY field2"
   SQLCMD="select ":CRMFIELDS:" from ":CRMFILE:" ":CRMWHERE
   FIRSTFIELD="field1"
   GOSUB 2000

Or you could just assign SQLCMD="select field1,field2,field3 from table1name 
inner join table2name on (field1 = field2) where field1 = 'value' ORDER BY 
field2"

I just found it easier to break it up when debugging.

The FIRSTFIELD is used to detect when to start pulling actual data - otherwise 
it will keep skipping
Lines until it sees FIRSTFIELD as the first FIELD(line,char(9),1)

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, August 22, 2013 9:28 AM
To: U2 Users List
Subject: Re: [U2] TU.SQL.CONNECT

Not exactly what you are asking for...but we use tsql (freetds - open source 
odbc for linux)

Setup: we have a "/tmp" opened to F.TMP  

*
***
* Subroutine Execute Query, Put results into YDATA Dynamic Array (ROW,COLUMN) *
***
*
* IN: SQLCMD contains the SQL command to execute on the MSSQL Server
* OUT: YDATA contains a dynamic Array of the results  (Headers are on YDATA<1>)
*   X=Row , Y=Columns
*
2000:
   USERNAME="..."
   PASSWORD="..."
   USRNO=@USERNO
   BLANKLINE=CHAR(9):CHAR(9)
   SQLLINE="tsql -S CRM -U ":USERNAME:" -P ":PASSWORD:" 2>&1 > 
/tmp/output":USRNO:" <="use schema_name;"  
   SQLLINE<-1>=SQLCMD
   SQLLINE<-1>="go"
   SQLLINE<-1>="bye"
   SQLLINE<-1>="EOF"
*
* The following was added to remove ^M's (from websites that allow the ENTER key
*in Web Fields - it gets converted to a space
*
   SQLLINE<-1>="cp /tmp/output":USRNO:" /tmp/holding":USRNO
   SQLLINE<-1>="perl -pe 's/\r\n/ /g'  
/tmp/output":USRNO
   SQLLINE<-1>="/bin/rm /tmp/holding":USRNO
*
   WRITE SQLLINE ON F.TMP,"TSQLCMD":USRNO
   CMD1="/tmp/TSQLCMD":USRNO
   EXECUTE \SH -c "\:CMD1:\"\ CAPTURING ERRORS
   IF ERRORS#"" THEN CALL 
*EMAILFILE(SQLLINE:CHAR(254):CHAR(254):ERRORS,"programmer1@localhost","[MSSQL] 
(Program-Name) Errors Executing","*") 
   DELETE F.TMP,"TSQLCMD":USRNO
*
   OPENSEQ "/tmp/output":USRNO TO F.MSSQLIN ELSE STOP "Can't Open MSSQL file"
   STARTCHECK=0; NUMB=0
*
   YDATA=""
   LOOP
  READSEQ PLINE FROM F.MSSQLIN ELSE EXIT
  IF PLINE=BLANKLINE THEN CONTINUE
  IF STARTCHECK=0 THEN
 IF PLINE[1,LEN(FIRSTFIELD)]=FIRSTFIELD THEN 
STARTCHECK=1
   YDATA=CHANGE(PLINE,CHAR(9),CHAR(253))
END
CONTINUE
  END
  IF PLINE[1,2]="1>" THEN CONTINUE
  PTEMP=CHANGE(PLINE,CHAR(9),CHAR(253))
  FOR T=1 TO DCOUNT(PTEMP,CHAR(253))
 IF PTEMP<1,T>="NULL" THEN PTEMP<1,T>=""
  NEXT T
  YDATA<-1>=PTEMP
   REPEAT
*
   CLOSESEQ F.MSSQLIN
   DELETE F.TMP,"output":USRNO
   RETURN

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Thursday, August 22, 2013 8:14 AM
To: U2 Users List
Subject: [U2] TU.SQL.CONNECT

Does anyone have any experience using the TU.SQL.CONNECT command to connect to 
a Microsoft Sequel database?

I am not finding any on-line docs and the OLD book I am using is not very 
helpful.


JRI
___
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] TU.SQL.CONNECT

[George Gallen]

Not exactly what you are asking for...but we use tsql (freetds - open source 
odbc for linux)

Setup: we have a "/tmp" opened to F.TMP  

*
***
* Subroutine Execute Query, Put results into YDATA Dynamic Array (ROW,COLUMN) *
***
*
* IN: SQLCMD contains the SQL command to execute on the MSSQL Server
* OUT: YDATA contains a dynamic Array of the results  (Headers are on YDATA<1>)
*   X=Row , Y=Columns
*
2000:
   USERNAME="..."
   PASSWORD="..."
   USRNO=@USERNO
   BLANKLINE=CHAR(9):CHAR(9)
   SQLLINE="tsql -S CRM -U ":USERNAME:" -P ":PASSWORD:" 2>&1 > 
/tmp/output":USRNO:" <="use schema_name;"  
   SQLLINE<-1>=SQLCMD
   SQLLINE<-1>="go"
   SQLLINE<-1>="bye"
   SQLLINE<-1>="EOF"
*
* The following was added to remove ^M's (from websites that allow the ENTER key
*in Web Fields - it gets converted to a space
*
   SQLLINE<-1>="cp /tmp/output":USRNO:" /tmp/holding":USRNO
   SQLLINE<-1>="perl -pe 's/\r\n/ /g'  
/tmp/output":USRNO
   SQLLINE<-1>="/bin/rm /tmp/holding":USRNO
*
   WRITE SQLLINE ON F.TMP,"TSQLCMD":USRNO
   CMD1="/tmp/TSQLCMD":USRNO
   EXECUTE \SH -c "\:CMD1:\"\ CAPTURING ERRORS
   IF ERRORS#"" THEN CALL 
*EMAILFILE(SQLLINE:CHAR(254):CHAR(254):ERRORS,"programmer1@localhost","[MSSQL] 
(Program-Name) Errors Executing","*") 
   DELETE F.TMP,"TSQLCMD":USRNO
*
   OPENSEQ "/tmp/output":USRNO TO F.MSSQLIN ELSE STOP "Can't Open MSSQL file"
   STARTCHECK=0; NUMB=0
*
   YDATA=""
   LOOP
  READSEQ PLINE FROM F.MSSQLIN ELSE EXIT
  IF PLINE=BLANKLINE THEN CONTINUE
  IF STARTCHECK=0 THEN
 IF PLINE[1,LEN(FIRSTFIELD)]=FIRSTFIELD THEN 
STARTCHECK=1
YDATA=CHANGE(PLINE,CHAR(9),CHAR(253))
 END
 CONTINUE
  END
  IF PLINE[1,2]="1>" THEN CONTINUE
  PTEMP=CHANGE(PLINE,CHAR(9),CHAR(253))
  FOR T=1 TO DCOUNT(PTEMP,CHAR(253))
 IF PTEMP<1,T>="NULL" THEN PTEMP<1,T>=""
  NEXT T
  YDATA<-1>=PTEMP
   REPEAT
*
   CLOSESEQ F.MSSQLIN
   DELETE F.TMP,"output":USRNO
   RETURN

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Thursday, August 22, 2013 8:14 AM
To: U2 Users List
Subject: [U2] TU.SQL.CONNECT

Does anyone have any experience using the TU.SQL.CONNECT command to connect to 
a Microsoft Sequel database?

I am not finding any on-line docs and the OLD book I am using is not very 
helpful.


JRI
___
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] ED PERMISSIONS subroutine

[George Gallen]

When we had delays with telnet logins, we traced it back to the reverse DNS
That telnetd was doing.

If you put the IP addresses of the telnet clients into the hosts file on the UV 
server 
Does the delay go away? I believe on windows servers the hosts file is at c:\ 
but I'm not sure.

Format is: 

IPaddressmachinename

Ex. 

192.168.0.15computer1

It does not have to be a fully qualified domain name, as if it's in the hosts 
file, that
Usually prevents a reverse DNS lookup.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Thursday, August 15, 2013 10:59 AM
To: U2 Users List
Subject: Re: [U2] [UV] ED PERMISSIONS subroutine

Yes!  Actually, the login does also have the same delay.  Sad to hear 
you didn't find a solution...

On 8/15/2013 10:35 AM, mhilb...@ppcsoftware.com wrote:
> Dianne,
> Does your login to telnet sessions also have this same delay? We 
> experienced this problem (with ED and with Login); never fixed it. The 
> company was a multinational that managed user priveleges at an 
> international corporate level, so even though we are in Argentina, 
> supoosedly there was some validation going on at a server in the US or 
> elsewhere. The multinational sold local operations to a local company 
> and the problem went away when we left the corportate network.
>
>
> On Thu, 15 Aug 2013 09:25:35 -0500, George Gallen wrote:
>> To me, if it is causing a delay that was not there before - raises
>> red flags and back hairs of read disk errors (or gonna be errors
>> soon).
>>
>> Can you do a disk scan?
>>
>> George
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne
>> Ackerman
>> Sent: Thursday, August 15, 2013 9:51 AM
>> To: U2-Users@listserver.u2ug.org
>> Subject: [U2] [UV] ED PERMISSIONS subroutine
>>
>> Does anyone know anything about the -PERMISSIONS subroutine used by the
>> ED verb in Universe?  Running 11.1.12 on Windows, the ED verb has a huge
>> delay and we've tracked it down to that subroutine call in the basic ED
>> program.  If I could look at that subroutine to see what it's doing,
>> maybe I can figure out what's causing that delay. Thanks!
>> -Dianne
>>
>>> >ED BP ED.B The file "BP" is read-only and cannot be updated. 3988
>>> lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS'
>>> : L 0308: CALL
>>> @PERMISSIONS(EDIT.FILE,EDIT.PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT)
>>> : EX
>>
>> ___
>> 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] [UV] ED PERMISSIONS subroutine

[George Gallen]

To me, if it is causing a delay that was not there before - raises red flags 
and back hairs of read disk errors (or gonna be errors soon).

Can you do a disk scan?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Thursday, August 15, 2013 9:51 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] [UV] ED PERMISSIONS subroutine

Does anyone know anything about the -PERMISSIONS subroutine used by the 
ED verb in Universe?  Running 11.1.12 on Windows, the ED verb has a huge 
delay and we've tracked it down to that subroutine call in the basic ED 
program.  If I could look at that subroutine to see what it's doing, 
maybe I can figure out what's causing that delay. Thanks!
-Dianne

> >ED BP ED.B The file "BP" is read-only and cannot be updated. 3988 
> lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' 
> : L 0308: CALL 
> @PERMISSIONS(EDIT.FILE,EDIT.PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) 
> : EX

___
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