Re: [U2] Web services at 11.x

2014-05-13 Thread Bill Haskett

Harold:

Maybe you'd be interested in:

https://u2devzone.rocketsoftware.com/accelerate/resources/videos/rest

HTH,

Bill

Untitled Page

- Original Message -
*From:* harold.o...@clark.wa.gov
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 5/13/2014 11:20 AM
*Subject:* Re: [U2] Web services at 11.x

Right, Enterprise Service Bus.  Thanks.

-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 10:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Web services at 11.x


https://en.wikipedia.org/wiki/Enterprise_service_bus

  
-Original Message-

From: Oaks, Harold harold.o...@clark.wa.gov
To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org
Sent: Tue, May 13, 2014 10:11 am
Subject: [U2] Web services at 11.x

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


Re: [U2] Read yourself

2014-05-13 Thread Bill Haskett

Richard:

This is exactly what appears in UniData's SYSTEM(49) function call, 
although in reverse order.


5 Dev (0)- BPTEST CRT SYSTEM(49) ; END

Compiling Unibasic: SAVEDLISTS\BpTest_332397981 in mode 'p'.
compilation finished

1²E:\AboEnterprise\Abo\BP\BP\_START.STACK²32■2²E:\AboEnterprise\Abo\BP\BP\_TCL.SHELL²1161■3²E:\AboEnterprise\Abo\BP\BP\_BPTEST²104■4²SAVEDLISTS\_BpTest_332397981²1■

Bill
Untitled Page


- Original Message -
*From:* rbl...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/13/2014 1:46 PM
*Subject:* Re: [U2] Read yourself

George,

It's better illustrated by multiple call levels.  A colleague here wrote
these specifically to test this:

  STACK.1
SUBROUTINE STACK.1
CRT ||
CRT CHANGE(SYSTEM(9001), @AM, CHAR(13):CHAR(10))
CRT ||
RETURN

  STACK.2
SUBROUTINE STACK.2
   CALL STACK.1
RETURN

  STACK.WRAP
CRT @(-1)
CALL STACK.2

And here's the results:


||
3ý/(absolute path)/BP.O/STACK.1ý0x6
2ý/(absolute path)/BP.O/STACK.2ý0x0
1ý/(absolute path)/BP.O/STACK.WRAPý0xe

||

Best Regards,
Richard Lewis


On Tue, May 13, 2014 at 11:59 AM, George Gallen ggal...@wyanokegroup.comwrote:


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 ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
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 ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
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

2014-05-12 Thread Bill Haskett
You can also use the program stack (UD - SYSTEM(49), UV - SYSTEM(9001), 
D3 - SYSTEM(33)).  This gives not only the program running but the 
path.  That ought to give needed information to both open the file and 
read the program source code.


HTH,

Bill


- Original Message -
*From:* d...@pickpro.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/12/2014 4:55 PM
*Subject:* Re: [U2] Read yourself

We always have a variable PGID defined at the top of the program.
This at least HELPS identify the source code.

Most of our programs have the ability to edit the code while you are in the program via 
some common hot-keys
built into our core system. (controlled by security)
There is also a hot-key to view source in a custom program, outside the editor.

We use 'PGID' to identify the name of the current program.

In universe, you may also look at the results of SYSTEM(9001) to get the 
current execution stack.
If your object file is type-19, and long-names are ON - it's easy to parse.

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


I understand how one could potentially do it.
I was more interested to see if anyone had already done it.
Cat pointers only work for catalogued entries by the way
  
  
  
-Original Message-

From: Israel, John R. johnisr...@daytonsuperior.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, May 12, 2014 4:41 pm
Subject: Re: [U2] Read yourself


There are @ commands that can get this stuff.  Or read the cat pointer.

John Israel

Sent from my iPhone


On May 12, 2014, at 7:39 PM, Wjhonson wjhon...@aol.com wrote:


The program does not inherently know that it's in a file called BP.
And it does not know it's own (value of) PROG.ID unless it can find it
out

somehow.



-Original Message-
From: Adrian Overs ove...@citysoft.com.au
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, May 12, 2014 4:33 pm
Subject: Re: [U2] Read yourself


What problem are you trying to solve by doing so?
After all it's not rocket science (pardon the pun) to OPEN BP TO
BP.FV THEN READ R.PROG FROM BP.FV, PROG.ID ELSE ... Whatever END

Sent from my iPad

On 13 May 2014, at 6:54 am, Wjhonson wjhon...@aol.com wrote:


Does anyone have a BASIC program, that will open it's own code in a variable ?
So something like this

GOSUB RETURN.A.LOCAL.FILE.AND.KEY.FOR.ME

READ THIS.PROGRAM FROM F.LOCALFILENAME, K.PROGRAMKEY 

the program reads itself.

Does anyone have a program like that?


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://cp.mcafee.com/d/5fHCMUSyOqejhOqemhNEV7e6XCQrEFLThKCqejqdQkTXEFE
CzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSe
847QhPb_nV5BZZAQsZuVtd5ZPATTD67KmKDp55mVEVvVkffGhBrwqrhdICXCXCM0pYGjFY
jfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3P3x
I5-Aq83iS4QPiWq80n-E6y0JlKdfftdFFCW--6tgnb718Y
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://cp.mcafee.com/d/k-Kr6jqb9EVd79EVp76zAsUrKrhKyC_t6WpEVdEThjvKyCy
qejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPoU
wgvh7cLZvAmnTSjhPRXBQQnTejvusouVqWtAklrCzB_BgY-F6lK1FJcSOrKrKr01DOFeDN
c_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIfce6
MnWhEwdbojjdbFEw1vWwq82RmUQYZQSCCrHzJY


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://cp.mcafee.com/d/2DRPoQ93hJ5AQsCzAQsIzzhOesdTdEThjvKztcQsCQrEFLT
hjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzO
VIsg8fEzCn-LObbXX9EVWZOWqbXD9LLecfsJteOaaJPhO_OEuvkzaT0QSOrpdTdTdw0PVk
DjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CS7
C73obZ8Qg6BI9FCBQQg0LZgd41qHsquuWrjjdPC62kJ0KQBUS

___
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] [Universe] [Windows]

2014-05-06 Thread Bill Haskett
Can you open the .csv file (the Windows File item within the Windows 
Directory) with a text editor?  Does it look like text?  Is there a 
sub-directory within this directory? Are the permissions of this .csv 
file the same as the rest of the items within the directory?  You're not 
getting that stupid desktop.ini item within the directory, are you?


Just a few thoughts.

Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 5/6/2014 10:04 AM
*Subject:* [U2] [Universe] [Windows]

Running Universe 11.1.9 Information flavor on top of Windows

A process which has been running for months, has suddenly decided that it has a 
Fatal Error !

When I debug it further, I get this symptom.

In a Universe BASIC program, I can OPEN the file (a type 1 directory)
I can SELECT the elements in the file (perfect)
I can READNEXT each element (perfect so far)

When I try to READ one of these items (windows files) I get in the ON ERROR 
clause the error set to 40070

What has occurred?  Who has messed with what? How do I fix it?

Thanks.

___
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

2014-04-17 Thread Bill Haskett

Shanmukh:

Although the following link is designed for D3...

 http://www.d3ref.com/?category=2

...it's pretty good documentation on the line EDitor.

HTH,

Bill


- Original Message -
*From:* shanmukhnan...@gmail.com
*To:* u2-users@listserver.u2ug.org
*Date:* 4/17/2014 2:47 AM
*Subject:* [U2] Rgarding ED editor

Hello Friends,


Can any one help with ED editor docs in Unibasic Programming language

Thank you,
Shanmukh
___
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] Messing with file triggers and error 30107

2014-04-08 Thread Bill Haskett
This is pretty much why one builds a single update trigger program and a 
single delete trigger program.  Then, from within those subroutines, 
call(s) are made to the actual subroutines that do something.  This way, 
you can actually use local subroutines to do trigger work.


Bill


- Original Message -
*From:* jacque...@yahoo.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/8/2014 8:45 AM
*Subject:* Re: [U2] [UV] Messing with file triggers and error 30107

Hello,

If the program being called by the trigger is catalogued globally and that 
program was changed by an installation, you need to drop the trigger and re-add 
it otherwise it will fail when the trigger is called.





  From: Peter Cheney peter.che...@firstmac.com.au
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, April 8, 2014 2:05 AM
Subject: [U2] [UV] Messing with file triggers and error 30107
  


Hi Everyone,

Just thought I'd post a solution to a recent problem to do with a file trigger 
that was driving me up the wall, across the ceiling and down the other side...

I'd made a mod to a particular file trigger to write to an item to a new file 
and all of a sudden the unirpcd started complaining with this error:

IBMU2.UODOTNET.UniSubroutineException: [IBM U2][UODOTNET - 
UNICLIENT][ErrorCode=30107] The subroutine failed to complete successfully
at IBMU2.UODOTNET.UniSubroutine.Call()
at 
FirstMac.Core.BusinessService.FunderService.Connection.Ultracs.UltracsUniDkConnection.Execute(String
 subroutineName, String[] arguments, Boolean logRequest, Boolean logResponse)


Searching around the usual haunts I found a few similar questions but nothing 
that answered my issue. Am still not entirely sure what other conditions this 
error 30107 covers but if you ever get this error then I recommend you check 
the file permissions of any newly created files that your code/modification is 
trying to write to.

Regards,
Peter


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


---
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] Business ?

2014-03-28 Thread Bill Haskett

If I'm not mistaken, they're a very large DesignBais user.

Bill
Untitled Page



- Original Message -
*From:* jbut...@hampshire.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/28/2014 12:55 PM
*Subject:* [U2] Business ?

Does anyone know much about FW Davidson  http://www.fwdco.com?

They came across my radar and I see references to Unidata along with 
SQL and Oracle.  Just curious if anyone know precisely what 
solution(s) they run on Unidata...





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


Re: [U2] SpreadsheetML and Excel2013

2014-03-24 Thread Bill Haskett
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 u2-users@listserver.u2ug.org
*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.comhttp://www.wyanokegroup.com/

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


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


Re: [U2] Unidata 7.2.6 Secure submitRequest Question

2014-03-24 Thread Bill Haskett

Do sockets update the serverdebug defined file, like UniObjects does?

Bill


- Original Message -
*From:* ke...@precisonline.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/24/2014 2:36 PM
*Subject:* [U2] Unidata 7.2.6 Secure submitRequest Question

Anybody ever seen anything like this before:

1523926:error:0D0890A1:asn1 encoding routines:ASN1_verify:unknown message
digest algorithm:a_verify.c:141:
1523926:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate
verify failed:s3_clnt.c:844:

This is displaying on a routine when it hits a submitRequest after the
following routines have been successfully called:

* createSecurityContext
* setAuthenticationDepth
* addCertificate
* createSecureRequest
* addRequestParameters

Where should I start digging?
___
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] jobnotify: Error 913 occurred

2014-03-21 Thread Bill Haskett
This reminds me...  Does UV have the same kind of logging as UD?  
Whenever UD crashes with things like LCT errors there's a log file 
created in the dbms account directory outlining the kinds of problems 
that occurred.  These were very helpful when I sent them to Wally.  :-)


Bill


- Original Message -
*From:* david.h...@cba.com.au
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/20/2014 11:21 PM
*Subject:* Re: [U2] jobnotify: Error 913 occurred

Sorry, I forgot to reply...

I vaguely recall having a jobnotify errors when we migrated to AIX6.1 and UV11.1.9 
during the testing phases...but do not recall if it was the 913 version you got...I 
cannot find my notes on this and didn't raise it as a problem case with Rocket...

You could be occasionally running out of user processes - but only when the 
system is busy... or perhaps some settings are not optimised for your server / 
license, etc.

A quick check is to verify 'ulimit' sessions for your UV session (do a ulimit 
-a at the shell prompt).

Check the current values of the ULIMIT and SHMMNI kernel parameters. SHMMNI 
should be set to Number of Users + 2. (This is from a Rocket UV11 tech note)

Finally, I think we also ran into issues with running out of LCTs...not necessarily  relayed to the 
jobnotify error... This was another configuration issue not documented in the install guide at the 
time. That required of the  tweaking of the UVCONFIG NUSERS parameters to ensure that everything 
was 'optimised', etc. and documented in the tech guidese UniVerse 11.1 - Before You 
Upgrade.pdf (previously  What You Need To Know for Eleven One.pdf).

Hope this helps...

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon
Sent: Thursday, 20 March 2014 2:40 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: Re: [U2] jobnotify: Error 913 occurred

Nearly one week and no responses...

Do I assume no one encountered the 'jobnotify: Error 913 occurred' message or 
has any knowledge of it.

Regards,
Brendon Leverett

From: Leverett, Brendon
Sent: Friday, 14 March 2014 11:09 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: jobnotify: Error 913 occurred

We have recently upgraded Universe (10.2.4 to 11.1.15) and are now finding some 
unusual activity around phantom jobs and the documented change to NOTIFY ON.

There are a lot of details behind the scenes but in summary:
- started  a job via phantom command (phantom SYNC.COPY.BNET)
- noticed 90 mins later that this job had crashed. This crash happens for 
various reasons but is more frequently crashing since the upgrade
- restarted the same job with the same phantom command At this time the 
following 3 lines of text was returned to the user's session:
jobnotify: Error 913 occurred
[15466830] SYNC.COPY.BNET - terminated
Phantom process started with process ID 33161456

Seems the 1ST 2 lines of text related to the previous phantom and 3rd line 
related to the phantom just started.

My Q is:
Does anyone have any ideas about the specific message
jobnotify: Error 913 occurred


We are running on AIX.

Regards,
Brendon Leverett


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


[U2] MongoDB

2014-03-21 Thread Bill Haskett

This is a very interesting analysis of MongoDB vs Oracle...

http://www.fstsummitus.com/media/whitepapers/2013/a_total_-10gen.pdf

Perhaps U2 ought to seriously review this to expand their market via 
pricing.  Remember, most big companies started out small.  To price 
small companies out of the U2 market is to send big companies elsewhere.


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


Re: [U2] jobnotify: Error 913 occurred

2014-03-20 Thread Bill Haskett
I have no idea what it is either.  When phantoms crash I figure it has 
to do the the credentials running the phantom.  In windows I find all my 
scheduled tasks run under a specific set of credentials.  If something 
runs that I don't have permissions for it just crashes.  So the user has 
to have access to all the files and functions the program accesses.


Since you changed servers, I'm guessing this is a good place to start.

Bill


- Original Message -
*From:* johnisr...@daytonsuperior.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/20/2014 3:58 AM
*Subject:* Re: [U2] jobnotify: Error 913 occurred

No idea what that is.

John Israel

Sent from my iPhone


On Mar 19, 2014, at 11:39 PM, Leverett, Brendon 
brendon.lever...@spotless.com.au wrote:

Nearly one week and no responses...

Do I assume no one encountered the 'jobnotify: Error 913 occurred' message or 
has any knowledge of it.

Regards,
Brendon Leverett

From: Leverett, Brendon
Sent: Friday, 14 March 2014 11:09 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: jobnotify: Error 913 occurred

We have recently upgraded Universe (10.2.4 to 11.1.15) and are now finding some 
unusual activity around phantom jobs and the documented change to NOTIFY ON.

There are a lot of details behind the scenes but in summary:
- started  a job via phantom command (phantom SYNC.COPY.BNET)
- noticed 90 mins later that this job had crashed. This crash happens for 
various reasons but is more frequently crashing since the upgrade
- restarted the same job with the same phantom command
At this time the following 3 lines of text was returned to the user's session:
jobnotify: Error 913 occurred
[15466830] SYNC.COPY.BNET - terminated
Phantom process started with process ID 33161456

Seems the 1ST 2 lines of text related to the previous phantom and 3rd line 
related to the phantom just started.

My Q is:
Does anyone have any ideas about the specific message
jobnotify: Error 913 occurred


We are running on AIX.

Regards,
Brendon Leverett

** This 
email message and any files transmitted with it may be confidential and 
privileged neither of which is intended to be waived. If you have received this 
communication in error, please reply to this e-mail to notify the sender of its 
incorrect delivery and then delete it and your reply. It is your responsibility 
to check this email and any attachments for viruses and defects before opening 
or sending them on. Spotless collects information about you to provide and 
market our services. For information about use, disclosure and access, see our 
privacy policy at 
http://cp.mcafee.com/d/5fHCNASyOqenQTD1NEVvdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVLrIKqCO_R-hsuvjjuWZOW9EV7esC---CU_ORQX8FGTd7b7axVZicHs3jq9JcTsTsS02EJmp_QFO_qSrrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jryr3NI5-Aq83iS4QPiWq816F25pOtb96y0qz6Ijh0qekmjh1mRCUNZ0SOYrTRJo
 Please consider our environment before

   printing this email. 
**

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://cp.mcafee.com/d/avndxMsd38srhpd7bWrPwUQsLCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTJSndjpvW_8KffFFLtuVt4QszDejvvvjsvVqWtAkRrCzBzBgY-F6lK1FJcSCrKrKr01DOFeDNc_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dK9If6MnWhEwdbojjdbFEw4qA8lD9QIAq81GcqNd41EVhpd45rmrz7Q3rbNLzkJuGcbvvfF

___
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] Embedded help as hypertext

2014-03-12 Thread Bill Haskett

Then, someone did the following for D3.

http://www.d3ref.com/

It's really too bad this isn't how U2 provides documentation, as it'd 
get indexed all over the internet, which would be good marketing, 
maybe.  :-)


Bill


- Original Message -
*From:* david.h...@cba.com.au
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/11/2014 10:49 PM
*Subject:* Re: [U2] Embedded help as hypertext

I assume you're talking about UV? Define 'improved'?

It could be improved by actually having all the commands, options and functions 
in it first. Even the PDF versions are missing information  :)

However, if you want another/better built-in HELP facility for your own 
purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, etc.)...

If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine -SHOW) which is a port of 
the Prime INFORMATION help which has 'hypertext' (sub-topics) and paging (back/forwards). In PI, there 
was also a subroutine you could call (rather than EXECUTE PIHELP subject. It has own 
format where you can specify the help file source and sub-topics indexed based on keywords in the 
topic/help message, like this in field/line one:

0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE

An index on the help file would on the above field allow PHELP ABOUT keyword. The 
FROM key word lets you specify you own help file.

It is better than the native UV HELP in some respects and utilises the default SYS.HELP file 
or your own (if required). I did note that there is no indices for the SYS.HELP file, so the PIHELP 
ABOUT topic function doesn't work...the required I-type dictionary item to parse the help 
records appears to be missing from the dictionary of SYS.HELP (Rocket Support should be able to assist 
there).

  The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it has been 
ported over for PI/open users that used this facility for their own 
applications...

The U2 Tools have built online help too - which are handy. If you use them - 
I'd encourage all newcomers to use these tools and similar commercial products 
to supplement the built-in native command-line tools (aka terminal shell 
session)...

Cheers,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, 12 March 2014 3:43 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Embedded help as hypertext


Does anyone have an improved version of the TCL command HELP ?

Are there any wiki's or anything that comprise all of the HELP text and perhaps 
more ?

I sometimes use it, sometimes use the PDFs and sometimes just google.

I think it would be a great resource were there a better solution.


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


Re: [U2] Left Outer Join Question

2014-03-04 Thread Bill Haskett

Randy:

NSELECT is a not select.  It doesn't use, as far as I know, any 
filters with it.  Use the filters with the SELECT then use the NSELECT 
(then use more SELECTs with filters if you want).


Bill


- Original Message -
*From:* randyleesm...@roadrunner.com
*To:* u2-users@listserver.u2ug.org
*Date:* 3/4/2014 10:43 AM
*Subject:* Re: [U2] Left Outer Join Question

Using NSELECT works as long as I don't do a complicated statement with it.


NSELECT OLDMAS WITH CO = SF AND WITH TRWSTATUS AND WITH ACTIONCODE NE

99 ...

Unknown word WITH on command line.


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


Re: [U2] Left Outer Join Question

2014-03-04 Thread Bill Haskett
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


Re: [U2] Left Outer Join Question

2014-03-03 Thread Bill Haskett

Then, there's always:

:SELECT FILE1
xxx items selected.
NSELECT FILE 2
yyy items selected.


You can also do the same as noted below with an EVAL command. e.g.

:select FILE1 WITH EVAL TRANS('FILE2', @ID, 0, 0) = 
xxx items selected.


Bill


- Original Message -
*From:* james.mcgo...@bankofthewest.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/3/2014 9:56 AM
*Subject:* Re: [U2] Left Outer Join Question

The usual pick way to do this is to create an attribute:

AE DICT FILE1 BLACKLIST
001: I
002: TRANS(FILE2, @ID, 0, 0)  ; or really old-school OCONV(@ID,TFILE2;X;0;0)
003:
004:
005: 20L
006: S

:GET.LIST L1
1000 Items Selected
:SELECT FILE1 WITH BLACKLIST = 
600 Items Selected




-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 9:44 AM
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
-
IMPORTANT NOTICE:   This message is intended only for the addressee
and may contain confidential, privileged information.  If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message.  If you have received this
message in error, please notify the sender by reply e-mail and
delete 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] Reporting Tools

2014-03-03 Thread Bill Haskett

Jeff:

I've written a little BASIC utility that takes a file, selects what I 
want, then outputs via the ITYPE function as a CSV file to the spooler.  
I wonder if that gets around the 150 field limit, since it's in BASIC?  
I know UniData is weird regarding this kind of thing.  For instance, 
they also have something like a 256 item limit in a query statement...


:SELECT MYFILE WITH CUST# = 123...256257

...will abort.  This too is hardwired.  However, a neat little utility 
provided by U2 called LSELECT selects items whose field definition 
value is in a list, so if you're on the web you'd first allow the user 
to select stuff, put it into a list, then use LSELECT to select the 
items from the file...kind of like:


:SELECT CUSTOMERS WITH LAST_ACTIVE  01/01/13
500 records selected to list 0.
SAVE.LIST MY.LIST
Overwriting existing saved list.
500 key(s) saved to 1 record(s).
LSELECT SALESORDERS WITH CUSTNO IN MY.LIST VERBOSE
(Parsed Command)
LSELECT SALESORDERS WITH CUSTNO IN MY.LIST TO 0

(Selected List)
List Source MY.LIST found 500 items.

(Create Temp File)
LSELECT0031 file created with MOD = 3

(Loaded List to Temp File) - 500 items.

1436 key(s) saved to 1 record(s).
(Selected Result List)
UDT.COMMAND = select SALESORDERS WITH EVAL 
TRANS('LSELECT0031',CUSTNO,'@ID','X') GT  TO 0

UDT.RESPONSE = ■1436 records selected to list 0.■■
Destination 0
Named List 0

(Delete Temp File)
LSELECT0031 file deleted...


Makes one wonder...h.

Bill
Untitled Page



- Original Message -
*From:* rotm...@cedarville.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/3/2014 12:57 PM
*Subject:* Re: [U2] Reporting Tools

As a work around, would this work:
* produce file1 with record key and then 100+ data fields
* produce file2 with remaining data fields
* execute Linux command:
paste file1 file2 myrealdata.csv




David Rotman, Ph.D.
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotm...@cedarville.edu
voice 937-766-7905
fax 937-766-8819



On Mon, Mar 3, 2014 at 3:34 PM, jeffrey Butera jbut...@hampshire.eduwrote:


On 3/3/14, 3:21 PM, Jeff Schasny wrote:


Jeff,

What I think many of us are suggesting is essentially if it hurts when
you do that, don't do that i.e. if the query language won't accomplish
what you want to do, use something else.


Jeff

Believe me - I hear you (and others).  But my administration isn't
listening because they all think this is a reasonable request (excel can
handle 200+ columns).   So if I can't make this work in Unidata I'll have
to move to MSSQL which I really, really, really don't want to do.

At this point I'm just trying to understand the limit on the number of
fields in a LIST statement.  I know in my case that it's not a sentence
length issue as I might've thought earlier so I'd like to know what is
causing this (with the understanding that I very well may not be able to
solve this).

Jeff



jeffrey Butera wrote:


On 3/3/14, 2:58 PM, Brian Leach wrote:


Jeff

Try mvQuery, that should not have any problems with those volumes.


Hi Brian

We've isolated the problem to Unidata itself, not the reporting tool.
  In short, when we do a LIST with about 150 fields, it throws:

too many items in LIST

As soon as we erase a field (any field), the LIST statement runs
properly.  Unfortunately, I cannot locate any parameter that might control
this.  I thought we were hitting U_SENTLEN - but we're nowhere near that
value.


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


Re: [U2] Left Outer Join Question

2014-03-03 Thread Bill Haskett
If you on UniData and you're in PICK mode then you have to lower case 
this kind of thing, since such PRIME style stuff only works in the 
UniData parser mode.  So, try this:


3 Dev (0)- SELECT ADDRBOOK WITH MAILLIST NE  AND WITH MAILLIST_OWNERS 
= [BOD]


309 records selected to list 0.

SAVE-LIST BILL1
Overwriting existing saved list.
309 key(s) saved to 1 record(s).
SELECT ADDRBOOK WITH CUSTOMERS NE 

114 records selected to list 0.

SAVE-LIST BILL2
114 key(s) saved to 1 record(s).
get.list BILL1 TO 1
309 records retrieved to list 1.
get.list BILL2 TO 2
114 records retrieved to list 2.
merge.list 1 UNION 2 TO 0
423 record(s) selected.
3 Dev (0)

...and here we are with 423 items selected as the active select list.

HTH,

Bill


//- Original Message -
*From:* randyleesm...@roadrunner.com
*To:* u2-users@listserver.u2ug.org
*Date:* 3/3/2014 2:36 PM
*Subject:* Re: [U2] Left Outer Join Question

I must be doing something wrong.

When I try this I get;

SELECT FILE1 TO 1
SELECT FILE2 TO 2
MERGE.LIST 1 INTERSECT 2 TO 3

SELECT list 1 is not active.




-
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-tp42740p42762.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] Unidata Index Failure

2014-02-26 Thread Bill Haskett

Doug:

I've had problems in the past when updating indexes while people were 
using the file.  I began using the ONLINE keyword to the CREATE.INDEX 
command and it took several sub-releases before the problems have gone 
away (knock, knock!).


My problem was the indexes I build for everyone's name and address come 
from a central address book file, while this information is used by 
multiple files (e.g. vendors, employees, customers, etc). Even though 
the address book file is indexed, so are all the other files (I don't 
want to look at employees when I'm looking for vendors).  So, the 
solution was to set a flag when a change was made, then delete  rebuild 
the indexes for the file when the next person logged in.  Now, using UO 
and the web, it is checked much more frequently than when on telnet.


Anyway, this process was obviously rebuilding when others were in the 
file.  We occasionally had missing items that required the index be 
rebuilt by hand (at TCL/ECL).  The ONLINE keyword seems to have resolved 
this over the course of several sub-releases.


HTH,

Bill
Untitled Page



- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/26/2014 7:20 AM
*Subject:* [U2] Unidata Index Failure

We have be experiencing a Unidata index failure above 7.3.2 on Windows
2008/2012.  When we go back to 7.3.2 the problem goes away.  The problem is
sometimes the index does not get built for certain items.  If we save the
records or rebuild the index it goes away for a few days to a weeks until
one or two items show up not in the index.  Our customers report a software
failure which takes us hours determine that no application software is the
cause and we rebuild the indexes on the file in question.

We have been working with Rocket Software for about 6 months on this
problem.  Rocket is reporting to me that no one has reported this issue to
them.  We thought we ask anyone on the list if they have seen any problem
that is similar where they have solved the problem by rebuilding the
indexes.

Regards,
Doug
www.u2logic.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] wasted time on rs.com

2014-02-21 Thread Bill Haskett

Baker:

Can't agree more.  You'd think it would be easy to simply index your 
help site, place a search box on each page, then let people search for 
anything...but alas.  [sigh]  This is so difficult that we all ignore it 
and open our sites up to search engines. I did it on Microsoft one time 
and what a nightmare that was.  :-)


Bill
Untitled Page



- Original Message -
*From:* baker_hug...@neimanmarcus.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/21/2014 6:45 AM
*Subject:* Re: [U2] wasted time on rs.com

Charles, your point is well taken.  I am on the site alot, and have the
same struggles finding what I need.
The other day I was searching for a specific Tech bulletin  the exact
number, and it wouldn't find it.

Regards,
R. Baker Hughes
Senior UV DBA, Wipro/NMG


From:   Charles Stevenson stevenson.c...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date:   02/21/2014 08:37 AM
Subject:Re: [U2] wasted time on rs.com
Sent by:u2-users-boun...@listserver.u2ug.org

The question was Why can't it be easy to find?
not Where is it?

Searching Rocket website is difficult.

The other day someone on this list was searching for Tech support
Survivor's guide.
Did he find it?  We were told he needed a 2UBC login to get to it.  Not
for the riffraff.

Try finding Mark Baldridge's Hitchhiker's Guide To UniVerse, which
should be required reading.
Go to www.rocketsoftware.com  homepage  enter some variants of
  Hitchhiker's guide to the universe
at the search prompt of rocket software homepage.
   Your search yielded no results
Keep going.   You can limit the product families to U2. (Although I
don't think that really does anything.)  Nada.
Tell me how long it takes to find it.

Try to find out what particular error codes mean.

Known issues and the release where they are fixed are buried in some
help file you can get to only by looking up particular releases in a
product matrix and downloading the entire help file.
At least, that's the only way I've found.

Do you have to do that for Lnux? MS? HP? any other software product you
use?
I used a new MS backup tool to backup a Win8 server  its virtual
servers.  I got an error code.  I am decidedly not a windows
administrator.  But on 1st attempt I found a useable MS answer.

I rely on this u2-list.  It's quicker to post a question here than wade
through RS looking for anything.
A couple weeks ago I couldn't remember syntax for the old, arcane
Revise.  Posted the q here  got 2 answers.


On 2/20/2014 8:05 PM, baker_hug...@neimanmarcus.com wrote:

It is on the Tech Connect website.  You might need a u2tc login to get to
the product matrix.
https://u2tc.rocketsoftware.com/matrix.asp

Then enter Product desired, and OS:
https://u2tc.rocketsoftware.com/buildmatrix.asp

Regards,
R. Baker Hughes
Senior UV DBA, Wipro/NMG


From:   Marc Harbeson marc.harbe...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date:   02/20/2014 11:00 AM
Subject:[U2] wasted time on rs.com
Sent by:u2-users-boun...@listserver.u2ug.org

why can the download for the U2 clients not be easy to find on the web
site?!?!?


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


Re: [U2] UniVerse Dictionary queston

2014-02-04 Thread Bill Haskett

Martin:

This is the only way to do accomplish the defined task in UniData.  
Maybe @RECORD178,1 is the preferred method in UV.


Bill
Untitled Page



- Original Message -
*From:* msch...@martinscholl.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*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


Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.

2014-01-28 Thread Bill Haskett
You know, I was able to integrate all printers into U2 by writing a few 
simple programs and using Print Wizard to convert our PCL5 output into a 
.pdf file.  This way, I never work with printers at the UD level any 
more.  And PW is an awesome product with awesome support.


Bill
Untitled Page



- Original Message -
*From:* antli...@youngman.org.uk
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/28/2014 12:54 PM
*Subject:* Re: [U2] How do you verify windows printer is good before 
fatal error by PRINTing to a bogus printer.

On 28/01/14 20:31, Jeff Schasny wrote:

I've been using Universe since it was in beta and I had no idea you
could use a URI in SETPTR.

Its a good day, I've learned something new. Thanks!

Just watch out. In today's modern world of GDI printers, sending a raw
text dump from UV is often not a good idea.

In the old days of dot-matrix, or even PCL that just expected a text
stream, it worked fine. It's nowhere near that simple any more :-(

Cheers,
Wol

Wols Lists wrote:

So if I am working on \\ASHDOWN (the name of my computer) I can use
SETPTR to point at \\TIGGER\HP - a printer logically connected to a
different computer that I've never told UV anything about.

Setptr is quite happy to be given a windows remote computer reference
and it works fine. That was how all our printers worked - they usually
had network cards in them, so when a new printer turned up, I would
assign it a name in DNS, and for anybody who was supposed to use it I
would just edit their login script to add eg

SETPTR ...,AT \\ACCOUNTS-HP\RAW

And it just worked. No UV printer setting up whatsoever. Okay, my setup
was a little bit cleverer than that, but everything, and I mean
EVERYTHING, was done in my programs. Nothing at the UV level whatsoever.

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] [UD] Who's locking a record

2014-01-28 Thread Bill Haskett

Oops, I forgot to mention I'm using Windows.

Bill
Untitled Page



- Original Message -
*From:* bl...@shaklee.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/28/2014 1:12 PM
*Subject:* Re: [U2] [UD] Who's locking a record

Here's how we do it:



READU MASTER.REC FROM F.CNTRL, 'COM.MASTER' LOCKED
UID = STATUS()
CMD = '!grep :':UID:': /etc/passwd | cut -d -f5'
EXECUTE CMD CAPTURING USER.NAME
MSG = 'DIST record - ':DIST.NBR:' is locked by: ':USER.NAME1
CALL SB.DISP(9,MSG)
SLEEP 5
CALL SB.DISP(9.'')
RETURN
END ELSE
RELEASE F.CNTRL, 'COM.MASTER'
STOP
END


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, January 28, 2014 12:18 PM
To: U2 Mail List
Subject: [U2] [UD] Who's locking a record

In UniData, if you do a READU you can find out the User ID who has the
record locked by using the STATUS() function; this returns the 'UID'
value.  Here's a list of users:

3 Dev (0)- lu

Licensed(UDT+CP)/Effective  Udt Sql iPhtm Pooled  Total

  (  24 + 1   ) / 25  1   0   0 0   1

UDTNO USRNBR  UID USRNAME   USRTYPE  TTYIP-ADDRESS TIME DATE
1   2488 197612 AsiAdmin  phantom pts/1   Console 10:42:32 Jan 15 2014
2   3920 197610 JohnSmith udt pts/2   192.168.1.52  08:15:33 Jan
28 2014
3180 197608 udcsuser udcspts/3   udcs  09:22:57 Jan
28 2014
4   3840 197608 udcsuser  udcspts/4   udcs 09:23:08 Jan 28 2014

Now, if John Smith goes to read and lock a record that is locked by
port#3, how can I figure out which port# actually has the record locked,
since the UniData GETUSER() function only returns the UID, and that
user, because it is a UniObjects user, is connected on more than one port#?

I have a file managed at login that keeps track of the PORT#s and the
associated users assigned by our application.  I want our logging to
report that a record lock by user so-and-so on port {n} is already in place.

Thanks.

Bill
___
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] [UD] Who's locking a record

2014-01-28 Thread Bill Haskett

Thanks Colin  David.  That's what I did; what a dance though!

I wonder why anyone would want STATUS() to return a value that doesn't 
give us the means to resolve the problem (as in what terminal, or what 
UO program was locking the record)? PORT.STATUS is of no value in a web 
environment because it's too slow and doesn't return a call stack on a 
UO process.


It's be really nice if we could get any information about a port/process 
simply by querying some object, instead of having to remember some 
esoteric function whose data we need to parse through.  Kind of like UD 
not telling us which darned dbms account a user is logged into!


Thanks again.

Bill
Untitled Page



- Original Message -
*From:* alfke...@hotmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 1/28/2014 3:49 PM
*Subject:* Re: [U2] [UD] Who's locking a record

That's what we used to use. It's a little more of a pain as you have to
parse through the output to find the correct record - but it should give you
need. It's simply list.readu output in an array.

Hth
Colin

-Original Message-
From: David A. Green
Sent: Tuesday, January 28, 2014 2:19 PM
To: 'U2 Users List'
Subject: Re: [U2] [UD] Who's locking a record

Can you get what you need using GETREADU?

David A. Green
(480) 201-7953
DAG Consulting

-Original Message-
From: Bill Haskett
Sent: Tuesday, January 28, 2014 1:18 PM
To: U2 Mail List
Subject: [U2] [UD] Who's locking a record

In UniData, if you do a READU you can find out the User ID who has the
record locked by using the STATUS() function; this returns the 'UID'
value.  Here's a list of users:

3 Dev (0)- lu

Licensed(UDT+CP)/Effective  Udt Sql iPhtm Pooled  Total

  (  24 + 1   ) / 25  1   0   0 0   1

UDTNO USRNBR  UID  USRNAME   USRTYPE  TTYIP-ADDRESSTIME DATE
1   2488 197612 AsiAdmin  phantom pts/1   Console   10:42:32 Jan 15 2014
2   3920 197610 JohnSmith udt pts/2   192.168.1.52  08:15:33 Jan 28 2014
3180 197608 udcsuser  udcspts/3   udcs  09:22:57 Jan 28 2014
4   3840 197608 udcsuser  udcspts/4   udcs  09:23:08 Jan 28 2014

Now, if John Smith goes to read and lock a record that is locked by port#3,
how can I figure out which port# actually has the record locked, since the
UniData GETUSER() function only returns the UID, and that user, because it
is a UniObjects user, is connected on more than one port#?

I have a file managed at login that keeps track of the PORT#s and the
associated users assigned by our application.  I want our logging to report
that a record lock by user so-and-so on port {n} is already in place.

Thanks.

Bill


___
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] Accuterm the Web version

2013-12-23 Thread Bill Haskett
Were you talking about the version of AccuTerm that runs through a web 
browser?  If so it's a nice product but the user still has to download 
and install AccuTerm, which works fine over the internet.  I can 
certainly echo the sentiments regarding the quality of AccuTerm products 
and their wonderful support.


If you'd like more information, can you be more specific about what 
you're looking for.  I think your request was a little too general.


Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 12/23/2013 11:07 AM
*Subject:* Re: [U2] Accuterm the Web version

No the original post was to see 1) if anyone is using this web version and 2) 
to get a testimonial FROM them.
Period.  That's all.  Anything else you read into it, was not present.

The purpose of customer testimonials is to get their own personal experience.
That's for what I was looking.  Solely.


-Original Message-
From: Bruce Decker bdec...@bluepinc.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 10:36 am
Subject: Re: [U2] Accuterm the Web version


Okay:
Let me try it this way.  I've known and worked with Pete for over 25
years.  In ALL of that time, I've found that the quality of his products
are first rate, he does not exaggerate claims (which is what I thought
the original post was suggesting) and if there was an issue (rare) he is
very responsive and quick to resolve the issue. I believe if Pete tells
you something, you can take it to the bank. I think this is helpful
information especially for those who may not know Pete and wonder if
they can rely on information he is providing.

I should have spelled it out instead of being snarky.  My apologies.
-BD

On 12/23/2013 11:22 AM, Wjhonson wrote:

Bruce if you don't like this thread, you don't have to respond.
Please let those of us who want to know these answers discuss it.



-Original Message-
From: Bruce Decker bdec...@bluepinc.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 10:19 am
Subject: Re: [U2] Accuterm the Web version


Exactly what he means.
-BD
On 12/23/2013 11:13 AM, Dave Laansma wrote:

Please elaborate. What exactly does Pete say.

Sincerely,
David Laansma
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions

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

On Behalf Of Bruce Decker

Sent: Monday, December 23, 2013 12:58 PM
To: U2 Users List
Subject: Re: [U2] Accuterm the Web version

If Pete says it, I believe it.
-BD

On 12/23/2013 10:52 AM, Wjhonson wrote:

We are using the Accuterm application to telnet into Universe 11

I've toyed with the idea of using the Accuterm browser version, does anyone

here use that ?

I just wonder what are the advantages or disadvantages of that.

I know what Pete says, I want to hear from a customer though.
___
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

  
___

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] Accuterm the Web version

2013-12-23 Thread Bill Haskett
Well, I use it every day.  All of our clients on our old server use it.  
We have a simple connection script set up on our corporate web server 
(an AccuTerm connection script). We also have some code to download and 
install the latest AccuTerm version to the client should they need it.  
Once we got all of this working it has worked flawlessly since.


HTH,

Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 12/23/2013 11:51 AM
*Subject:* Re: [U2] Accuterm the Web version

My specific request is that I wish to hear from a person who is actually using, 
as their main way of connecting to the database, the WEB based version of 
Accuterm.

Not just someone who tried it for a day or something.  But rather a person who 
is using it day to day for their normal work.



-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 11:28 am
Subject: Re: [U2] Accuterm the Web version


Were you talking about the version of AccuTerm that runs through a web
browser?  If so it's a nice product but the user still has to download
and install AccuTerm, which works fine over the internet.  I can
certainly echo the sentiments regarding the quality of AccuTerm products
and their wonderful support.

If you'd like more information, can you be more specific about what
you're looking for.  I think your request was a little too general.

Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 12/23/2013 11:07 AM
*Subject:* Re: [U2] Accuterm the Web version

No the original post was to see 1) if anyone is using this web version and 2)

to get a testimonial FROM them.

Period.  That's all.  Anything else you read into it, was not present.

The purpose of customer testimonials is to get their own personal experience.
That's for what I was looking.  Solely.


-Original Message-
From: Bruce Decker bdec...@bluepinc.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 10:36 am
Subject: Re: [U2] Accuterm the Web version


Okay:
Let me try it this way.  I've known and worked with Pete for over 25
years.  In ALL of that time, I've found that the quality of his products
are first rate, he does not exaggerate claims (which is what I thought
the original post was suggesting) and if there was an issue (rare) he is
very responsive and quick to resolve the issue. I believe if Pete tells
you something, you can take it to the bank. I think this is helpful
information especially for those who may not know Pete and wonder if
they can rely on information he is providing.

I should have spelled it out instead of being snarky.  My apologies.
-BD

On 12/23/2013 11:22 AM, Wjhonson wrote:

Bruce if you don't like this thread, you don't have to respond.
Please let those of us who want to know these answers discuss it.



-Original Message-
From: Bruce Decker bdec...@bluepinc.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 10:19 am
Subject: Re: [U2] Accuterm the Web version


Exactly what he means.
-BD
On 12/23/2013 11:13 AM, Dave Laansma wrote:

Please elaborate. What exactly does Pete say.

Sincerely,
David Laansma
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions

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

On Behalf Of Bruce Decker

Sent: Monday, December 23, 2013 12:58 PM
To: U2 Users List
Subject: Re: [U2] Accuterm the Web version

If Pete says it, I believe it.
-BD

On 12/23/2013 10:52 AM, Wjhonson wrote:

We are using the Accuterm application to telnet into Universe 11

I've toyed with the idea of using the Accuterm browser version, does anyone

here use that ?

I just wonder what are the advantages or disadvantages of that.

I know what Pete says, I want to hear from a customer though.
___
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

Re: [U2] [UV] INPUTTRAP Statement

2013-12-23 Thread Bill Haskett
You can't trap the 'break' key, but you can prevent its usage.  In 
UniData it is:


ON.ABORT

...which is a very finicky task to accomplish in that the command 
doesn't permanently turn on or off anything, it simply executes a 
command on a program abort.  For us, the command executes the ON.ABORT 
command again (for the next abort) the routes the user back to the main 
menu; a very abstract way to get the job done.


HTH,

Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 12/23/2013 11:56 AM
*Subject:* Re: [U2] [UV] INPUTTRAP Statement

I don't think you can use *any* of the chars that are pre-trapped like ctrl-c 
(Break)
That is, chars that actually make the op-sys wake up and act in immediate mode


If you are trying to *trap* the break so you can see when someone is trying to 
use it, there is another way, although the other way of which I'm thinking 
doesn't *prevent* its use, it just *records* its use.

Maybe you could go into more detail about why you're trying to trap ctrl-c



-Original Message-
From: Perry Taylor perry.tay...@zirmed.com
To: U2-Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 11:41 am
Subject: [U2] [UV] INPUTTRAP Statement


Has anyone ever used the INPUTTRAP statement in UniVerse BASIC?  I want to be
able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3),
or any other character for that matter.  The UniVerse BASIC Commands
documentation provides no examples on its use.

Anybody done anything like this?  Any sample code you're willing to share?

Thanks.
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://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] [UV] INPUTTRAP Statement

2013-12-23 Thread Bill Haskett
Yea.  It took me awhile to figure this out. ON.ABORT sets up a (VOC) 
entry to be run on a program abort; but only once!  If you want it to 
happen again, which I wanted in our menu system (i.e. I didn't want 
people to press [Ctrl]+C to get to TCL out of our menu system), then my 
(VOC) item SORRY looks like:


001  PA
002  ON.ABORT SORRY
003  MENU

...where ON.ABORT SORRY is activated to occur upon the next program 
abort (which a break key is an abort) and MENU sends the user back to 
the main menu.  When a user logs on I execute this command (and a 
UTD.OPTION 105 OFF to make sure ON.ABORT can't be executed from within 
BASIC) then route users to the main menu. Now, if anyone tries to break 
out of our menu system the abort management is activated again (awaiting 
an abort) and the user is routed to the main menu.  This is convoluted, 
but it works.  :-)


Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 12/23/2013 1:13 PM
*Subject:* Re: [U2] [UV] INPUTTRAP Statement

Could you explain more why your On.Abort executes another On.Abort ?
I didn't understand that part.



-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 1:06 pm
Subject: Re: [U2] [UV] INPUTTRAP Statement


You can't trap the 'break' key, but you can prevent its usage.  In
UniData it is:

ON.ABORT

...which is a very finicky task to accomplish in that the command
doesn't permanently turn on or off anything, it simply executes a
command on a program abort.  For us, the command executes the ON.ABORT
command again (for the next abort) the routes the user back to the main
menu; a very abstract way to get the job done.

HTH,

Bill


- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 12/23/2013 11:56 AM
*Subject:* Re: [U2] [UV] INPUTTRAP Statement

I don't think you can use *any* of the chars that are pre-trapped like ctrl-c

(Break)

That is, chars that actually make the op-sys wake up and act in immediate mode


If you are trying to *trap* the break so you can see when someone is trying to

use it, there is another way, although the other way of which I'm thinking
doesn't *prevent* its use, it just *records* its use.

Maybe you could go into more detail about why you're trying to trap ctrl-c



-Original Message-
From: Perry Taylor perry.tay...@zirmed.com
To: U2-Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 11:41 am
Subject: [U2] [UV] INPUTTRAP Statement


Has anyone ever used the INPUTTRAP statement in UniVerse BASIC?  I want to be
able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3),
or any other character for that matter.  The UniVerse BASIC Commands
documentation provides no examples on its use.

Anybody done anything like this?  Any sample code you're willing to share?

Thanks.
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://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

  
___

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] BASIC code - upper, lower, CamelCase, what say you?

2013-12-20 Thread Bill Haskett

Charles:

I've always used the following:

 http://www.pickwiki.com/cgi-bin/wiki.pl?BFind

...to search everything on U2, including Windows directories. 
Considering Windows search capabilities really suck, this is very handy 
for our web stuff, programs, accounts, dictionaries, etc.  I did this so 
many years ago the newer version may or may not have some enhancements 
or fixes.  This way I couldn't care less about case.


Now-a-days all of my UniData STATEMENTS are upper case while everything 
else is designed to be readable by anyone who speaks and writes human 
languages (in my case English).


Bill


- Original Message -
*From:* stevenson.c...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 12/20/2013 1:07 PM
*Subject:* Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
If you use mixed case, what search tools  comparitors do you use when 
researching your program libraries?
Particularly if you have programs written in different styles over the 
years.

What formatting tools do you use?




On 12/20/2013 10:01 PM, Bobby Worley wrote:

First off - Merry Christmas and Happy New Year to all.

I'm starting to write a lot of new BASIC (Universe 11.1) subroutines for
our DesignBais application, and since I'll be starting with a blank code
template instead of modifying existing code, and I thought 'hey why not
join the 21st century' and make the code look more mainstream, and
readable.  (falling back on our last TEXMUG presentation by Clif 
Oliver on

refactoring).

And considering Universe 11.2 now supports local subroutines and 
functions,

I should make the code look and behave more object-like.

Does anyone know of a set of rules or guidelines on how to do 
this?Just
experimenting briefly, Universe BASIC compiler will allow any mix of 
cases

for keywords, but variables are case sensitive.  Example:


ED BP TEST

ABC=1
Abc=2
abc=3
PRINT ABC
Print Abc
pRiNt abc
stop
end


RUN TEST

1
2
3

So, how are developers mixed case in their code these day? Do keywords,
local variables, common variable, equates follow a standard method?

thanks in advance,


___
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] Interview Questions

2013-12-16 Thread Bill Haskett
Another option, which I always have done, is to iconv dates in 15 Jan 
2013 format.  This always works regardless of which date method is 
selected.


Don't know why yanks do things that irritate you.  But then, most 
people do things that irritate someone.  As Mark Brown always points 
out; the trouble with standards is everybody has one.  This seems more 
of an issue than what yanks do.  :-)


Bill
Untitled Page



- Original Message -
*From:* antli...@youngman.org.uk
*To:* u2-users@listserver.u2ug.org
*Date:* 12/16/2013 6:00 PM
*Subject:* Re: [U2] [OT] Interview Questions

On 17/12/2013 00:17, Wjhonson wrote:

What is the last Thursday of the current month.

Current Date minus Current Day of Month number plus 1 puts you on the 
first of the current month
Or you could just Oconv d2/ and replace the middle number with 01 
with Iconv that.


Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY, 
D2) gives me 17/12/13. If I replace the middle number (or if Kevin 
replaced the middle number) we'd both end up somewhere in January! Why 
do you Yanks put the least significant number in the middle? That's 
crazy!


If you want the first of the month, the easiest way to do it is

FIRST = 01/:OCONV(@TODAY,D2[M,Y])

(if I've remembered my syntax correctly). Then to get that into 
internal format


I_FIRST = ICONV(FIRST, D2DMY)

You should NEVER assume that dates are in the format you expect, 
unless you are in control (which you aren't, here, seeing as you've 
messed up pretty spectacularly :-)


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] [OT] Interview Questions

2013-12-16 Thread Bill Haskett
Of course, one normally puts dates together like that because left 
justification works, and we all know how we're always limited by someone 
elses standards.  :-)


Bill


- Original Message -
*From:* james.mcgo...@bankofthewest.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 12/16/2013 6:22 PM
*Subject:* Re: [U2] [OT] Interview Questions

There's an xkcd for everthing: http://xkcd.com/1179/

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Monday, December 16, 2013 6:13 PM
To: U2 Users List
Subject: Re: [U2] [OT] Interview Questions

Another option, which I always have done, is to iconv dates in 15 Jan 2013 
format.  This always works regardless of which date method is selected.

Don't know why yanks do things that irritate you.  But then, most people do things that 
irritate someone.  As Mark Brown always points out; the trouble with standards is everybody has 
one.  This seems more of an issue than what yanks do.  :-)

Bill
Untitled Page



- Original Message -
*From:* antli...@youngman.org.uk
*To:* u2-users@listserver.u2ug.org
*Date:* 12/16/2013 6:00 PM
*Subject:* Re: [U2] [OT] Interview Questions

On 17/12/2013 00:17, Wjhonson wrote:

What is the last Thursday of the current month.

Current Date minus Current Day of Month number plus 1 puts you on the
first of the current month Or you could just Oconv d2/ and replace
the middle number with 01 with Iconv that.

Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY,
D2) gives me 17/12/13. If I replace the middle number (or if Kevin
replaced the middle number) we'd both end up somewhere in January! Why
do you Yanks put the least significant number in the middle? That's
crazy!

If you want the first of the month, the easiest way to do it is

FIRST = 01/:OCONV(@TODAY,D2[M,Y])

(if I've remembered my syntax correctly). Then to get that into
internal format

I_FIRST = ICONV(FIRST, D2DMY)

You should NEVER assume that dates are in the format you expect,
unless you are in control (which you aren't, here, seeing as you've
messed up pretty spectacularly :-)

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
-
IMPORTANT NOTICE:   This message is intended only for the addressee
and may contain confidential, privileged information.  If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message.  If you have received this
message in error, please notify the sender by reply e-mail and
delete 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] Unidata error for the ages, so to speak.

2013-12-06 Thread Bill Haskett

Doug:

This is a UniData anomaly.  You can't reference fields like 
@RECORD3, you have to refer to them like EXTRACT(@RECORD,3,0,0).


HTH,

Bill
Untitled Page



- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 12/5/2013 1:44 PM
*Subject:* [U2] Unidata error for the ages, so to speak.

I was playing with EVAL trying to see why it would work in Universe
and not in Unidata.  I typed in this sentence in Unidata 7.3.6:

list CRM.CUSTOMERS WITH EVAL UPCASE(@RECORD15) LIKE BILL...

UPCASE(@RECORD15)
-^
Virtual Attribute Error: qz1zq syntax error

So what is qz1zq syntax error?  Who would of thought this would help a
seasoned professional like myself figure our my syntax error.  I guess
I really don't understand this database after many many years...

The correct syntax was :
list CRM.CUSTOMERS WITH EVAL UPCASE(CONTACT.NAME) LIKE 'BILL...'

Regards,
Doug
www.u2logic.com
Web applications with real error messages
___
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] Running Account wide I-DESC

2013-12-06 Thread Bill Haskett
Doesn't UV have a DICT.DICT ? In UD you can create truly global 
dictionaries by placing them in DICT.DICT.


Bill


- Original Message -
*From:* dia...@aptron.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 12/6/2013 6:13 AM
*Subject:* Re: [U2] Running Account wide I-DESC
Depending on the complexity of the I-type, you can sometimes 
accomplish the same thing with an S-type, which is not compiled.  So 
we use that sometimes for global type dictionary items like that. So 
for example we put an item COUNTER in the VOC which we can use on any 
file:


COUNTER
0001 S
0002 0
0003
0004
0005
0006
0007
0008 A;1
0009 R
0010 5

-Dianne

On 12/5/2013 3:44 PM, George Gallen wrote:

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.comhttp://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] List of display control @ variables for UVBasic

2013-11-20 Thread Bill Haskett
In the UD BASIC manual, this information is under the @ item in the 
table of contents.


Bill


- Original Message -
*From:* jscha...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 11/20/2013 9:20 AM
*Subject:* Re: [U2] List of display control @ variables for UVBasic
Not really. It has the named @ variables like @userno, @ selected, 
@vm, etc but the terminal control codes @(-1), @(-2), @(-3), etc are 
not there. At least not in my (admittedly old, 10.2) version.


HELP BASIC @ worked for me.

Thanks all.

Gregor Scott wrote:
The UniVerse BASIC Commands Reference documents it (look for @ 
function in the TOC)


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

Sent: Wednesday, 20 November 2013 8:54 AM
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
--
Message  protected by DealerGuard: e-mail anti-virus, anti-spam and 
content filtering.

http://www.pentanasolutions.com

Click here to report this message as spam:
https://login.mailguard.com.au/report/1IpKwm7RGU/5YCbcDsMLoLdzSG18nYGvY/0.204 



___
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] UD PE 7.1.0 - Use of EXECUTE with the RTNLIST option

2013-11-20 Thread Bill Haskett

Bruce:

Thanks.  This always gets me so I never use the RTNLIST.  :-)

Bill
Untitled Page



- Original Message -
*From:* bdec...@bluepinc.com
*To:* u2-users@listserver.u2ug.org
*Date:* 11/20/2013 3:56 PM
*Subject:* Re: [U2] UD PE 7.1.0 - Use of EXECUTE with the RTNLIST option

This is a reply to a old post but since this is the top search result for
RTNLIST, I'll post a reply with useful info.  Unidata's BASIC compiler seems
to be quite particular about the ORDER of the clauses on an Execute.  Put
RTNLIST, RETURNING AND CAPTURING in the wrong order and you'll see a error
like this:

Compiling Unibasic: mysource\test4 in mode 'p'.
main program: syntax error at or before
line 7 EXECUTE \SELECT VOC\ RETURNING junk RTNLIST l.voc CAPTURING screen;
  --^
Misuse of reserved word 'RTNLIST'
Expecting: end-of-file,END

compilation failed

Here is the code with examples of proper order of the clauses on an execute
and the final example of EXECUTE producing the failure message above...

done = @FALSE
l.voc = \\
i = 0
*
EXECUTE \SELECT VOC\ RTNLIST l.voc ; *compiles 
ok
EXECUTE \SELECT VOC\ RTNLIST l.voc RETURNING junk  ; *compiles 
ok
EXECUTE \SELECT VOC\ RTNLIST l.voc RETURNING junk CAPTURING screen ; *compiles 
ok
EXECUTE \SELECT VOC\ RETURNING junk RTNLIST l.voc CAPTURING screen ; *fails 
compile
*
LOOP
READNEXT id FROM l.voc ELSE done = @TRUE
UNTIL done DO
i=+ 1
REPEAT
CRT i:\ records counted\
STOP



___
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

2013-11-19 Thread Bill Haskett

Brandon:

Is this UV or UD?  There's a bit of a difference setting up the query 
language to use the WHEN clause within these two different U2 dbms 
products.  The task of setting up the query is to set up fields as 
multi-value first, then associating multi-valued field definitions into 
a group.


Bill
Untitled Page



- Original Message -
*From:* brandon.h...@iqor.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 11/19/2013 10:31 AM
*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 brandon.h...@iqor.com
To: U2 Users List u2-users@listserver.u2ug.org
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

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

2013-11-19 Thread Bill Haskett

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 u2-users@listserver.u2ug.org
*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 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 administratorggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.comhttp://www.wyanokegroup.com/


Re: [U2] UV Basic parsing xml with XDOM commands

2013-11-06 Thread Bill Haskett

Now that is quite a dance!  [whew...]

Bill
Untitled Page



- Original Message -
*From:* peter.che...@firstmac.com.au
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 11/5/2013 6:00 PM
*Subject:* [U2] UV Basic parsing xml with XDOM commands

Hi Everyone,

Thought I'd post a solution to a task I've been working on in the hope it will 
assist someone else with similar requirements. Thanks also to those who've 
previously posted on this as I found the following to be most helpful as well:
http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg18895.html
https://gdoesu2.wordpress.com/tag/xdomlocate/
http://listserver.u2ug.org/pipermail/u2-users/2010-September/004713.html
http://www.mvdeveloper.com/kb/docs/kb10.pdf


I had to parse some xml returned via a soap request to an IIS server:
?xml version=1.0?
s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/;
   s:Body
 SuggestResponse xmlns=http://tempuri.org/;
   SuggestResult 
xmlns:a=http://schemas.datacontract.org/2004/07/FirstMac.Services.Category.Contracts; 
xmlns:i=http://www.w3.org/2001/XMLSchema-instance;
 a:CategoryGroupSome group data/a:CategoryGroup
 a:CategoryNameSome name data/a:CategoryName
   /SuggestResult
 /SuggestResponse
   /s:Body
/s:Envelope
There are only ever 2 value nodes returned if the soap query is successful with the 
SuggestResult node containing 'i:nil=true' if the query is not successful.
e.g. SuggestResult i:nil=true ... /

The xml contains a default namespace and after much searching and trial and 
error I discovered I needed to use the following xpathString and nsMAP 
parameters in the XDOMLocate function:
Notes re the XDOMLocate function.
I found the UV11.1 Basic Commands Reference and Basic Extensions documents for 
XDOMLocate to be scarce on detail for the following:

   *   Each additional namespace in the string must also be space delimited.
   *   The double quotes enclosing the http url must be removed for each namespace defined in 
the nsMAP parameter. The description given has double quotes in the wrong places. e.g. if you 
have s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/; then the 
namespace you need to specify is nsMAP = 'xmlns:s=http://schemas.xmlsoap.org/soap/envelope/'

code
xpathStr  = '/s:Envelope/s:Body'

nsMAP  = 'xmlns:s=http://schemas.xmlsoap.org/soap/envelope/ '
nsMAP := 
'xmlns:a=http://schemas.datacontract.org/2004/07/FirstMac.Services.Category.Contracts
 '
nsMAP := 'xmlns=http://tempuri.org/ '
nsMAP := 'xmlns:i=http://www.w3.org/2001/XMLSchema-instance'

OK = XDOMOpen( RespData, XML.FROM.STRING, hDOM )
if OK = XML.SUCCESS then
crt 'XML document opened'
OK = XDOMLocate( hDOM, xpathStr, nsMAP, hRoot )
if OK = XML.SUCCESS then
   crt 'Found ':xpathStr

   OK = XDOMGetNodeName( hRoot, NodeName )
   crt 'Root node=':NodeName
   OK = XDOMLocateNode( hRoot, XDOM.CHILD, XDOM.FIRST.CHILD, 
XDOM.ELEMENT.NODE, hParent )
   if OK = XML.SUCCESS then
  OK = XDOMGetNodeName( hParent, NodeName )
  crt 'Parent node = ':NodeName ;* 
'SuggestResponse'
  OK = XDOMLocateNode( hParent, XDOM.CHILD, XDOM.FIRST.CHILD, 
XDOM.ELEMENT.NODE, hChild )
  if OK = XML.SUCCESS then
 OK = XDOMGetNodeName( hChild, NodeName )
 crt 'Child node = ':NodeName   ;* 
'SuggestResult'
 OK = XDOMLocateNode( hChild, XDOM.CHILD, XDOM.FIRST.CHILD, 
XDOM.ELEMENT.NODE, hValueNode )
 if OK = XML.SUCCESS then
OK = XDOMGetNodeName( hValueNode, NodeName )
crt 'Value node1 = ':NodeName   ;* 
'a:CategoryGroup'
OK = XDOMLocateNode(hValueNode, XDOM.CHILD, XDOM.FIRST.CHILD, 
XDOM.TEXT.NODE, hTextNode )
if OK = XML.SUCCESS then
   OK = XDOMGetNodeValue(hTextNode, Value )
   crt 'Payload1 = ':Value  ;* 'Some group 
data'
end else
   gosub ShowError
end
 end
 OK = XDOMLocateNode( hChild, XDOM.CHILD, 2, XDOM.ELEMENT.NODE, 
hValueNode )
 if OK = XML.SUCCESS then
OK = XDOMGetNodeName( hValueNode, NodeName )
crt 'Value node2 = ':NodeName   ;* 
'a:CategoryName'
OK = XDOMLocateNode(hValueNode, XDOM.CHILD, XDOM.FIRST.CHILD, 
XDOM.TEXT.NODE, hTextNode )
if OK = XML.SUCCESS then
   OK = XDOMGetNodeValue(hTextNode, Value )
   crt 'Payload2 = ':Value  ;* 'Some name 
data'
end else
   gosub ShowError
end
 end else
gosub ShowError
 end
  end else
 gosub ShowError
  end
   end else
  gosub ShowError
   end
 

Re: [U2] [OT] Support Ticket Software

2013-10-24 Thread Bill Haskett

Charlie:

Welcome to the new world of technology.  sigh...

Bill


- Original Message -
*From:* cwn...@comcast.net
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 10/24/2013 6:49 AM
*Subject:* Re: [U2] [OT] Support Ticket Software
Thanks for the link, Larry. It appears that's the right company. Their 
sales people couldn't answer my question and referred me to tech 
support. After going through their telephone hell I sat on hold about 
45 minutes and gave up. From their forums it appears that the 
originator of a ticket can be given permissions to view or edit 
tickets, but doesn't have to be. I don't know if I can persuade BC to 
do it, though.


Charlie

On 10-23-2013 12:19 PM, Larry Hiscock wrote:

http://www.salesforce.com/remedyforce/features/


Larry Hiscock
Western Computer Services

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Wednesday, October 23, 2013 8:47 AM
To: U2 Users List
Subject: Re: [U2] [OT] Support Ticket Software

Hi Symeon,

I had looked at salesforce and it wasn't really intuitive that they 
had a
support ticket system. I think they are the one, though. The reason I 
was
curious is that BigCommerce said that under the new system they 
sprung on us
unannounced over the weekend, we could enter support tickets, but not 
look
up or view tickets we'd submitted. I thought that was rather strange. 
I've
never used a system before where I couldn't view my tickets. The old 
system

they used allowed viewing of tickets, and responding either via email or
online. It's just one more capability BC has taken away - and to think I
moved away from Intuit for doing that very same thing...

Thanks,
Charlie

On 10-23-2013 2:14 AM, Symeon Breen wrote:
The secure server at force.com , e.g. secure.force.com ?   which 
would be

salesforce - and they do have ticketing software

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie
Noah
Sent: 23 October 2013 03:55
To: U2 Users List
Subject: [U2] [OT] Support Ticket Software

My online store platform has switched to a new support ticket system
called secure.force, but I can't find any info on the company that
markets it, and of course, my provider won't tell me anything about it.
Has anyone seen or know anything about it?

Thanks,
Charlie

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] [OT] Interview Questions

2013-10-11 Thread Bill Haskett

Kevin:

After actually hiring a lot of people, and firing those that needed it, 
I've come to the conclusion that all employers need a person with the 
following three attributes:


1)  An ability, and willingness, to be on-time,
2)  An ability, and willingness, to be presentable in all business 
situations, and
3)  An ability, and willingness, to learn what they don't know (which is 
always a lot!).


The people coming out of college these days are mostly unemployable.  
Today's bachelors degree is like a 1930 8th grade education, or a 1970 
high school education.  So, no matter what any Human Services dweeb 
says, getting someone to show up looking presentable and willing to work 
whatever it takes to learn what they don't know is gold!  These kinds of 
people are quite trainable and, considering all software frameworks have 
a short shelf life anyway, offer a lot of flexibility for your purposes.


Just a thought.  :-)

Bill


- Original Message -
*From:* ke...@precisonline.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 10/11/2013 9:56 AM
*Subject:* Re: [U2] [OT] Interview Questions

Unfortunately, in one case I hired a friend.  Needless to say, it was one
of the worst decisions I've made.  Not only lost a friend, but lost a lot
of customer confidence by her attitude, poor workmanship, and unwillingness
to adapt.


On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.comwrote:


Wow, seen a lot of that and managers trying to get friends hired to create
a perfect office society.


  quit hiring backstabbing chaff

with their own agendas.


Robert
- Original Message - From: Kevin King ke...@precisonline.com
To: Susan Joslyn sjos...@sjplus.com; U2 Users List 
u2-users@listserver.u2ug.org
Sent: Wednesday, October 09, 2013 8:07 PM

Subject: Re: [U2] [OT] Interview Questions


  Susan, yes.  I've been very open in my interviews, and it's netted

significantly regrettable results.  So this time I'm going for people who
can get behind and contribute to the common cause as soon after hire as
possible.  I don't have any aspirations of hiring for life, though I
certainly do endeavor to have that kind of an environment for a person who
wants that sort of thing.  I just need to quit hiring backstabbing chaff
with their own agendas.


On Tue, Oct 8, 2013 at 1:54 PM, Susan Joslyn sjos...@sjplus.com wrote:

  Kevin,

Not that I have any real experience - at least not for what seems like a
lifetime - with hiring.  But my instinct might be to let the applicant
tell
me whatever they want.  You know, just an open ended Tell me what you
would
like me to know about your skills, your ambitions and your work ethic.
Probably that's an approach you've already tried.

Susan



-Original Message-

From:  
mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org
u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[
mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org
mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org]
On Behalf Of Leverett,
Brendon

Sent: Tuesday, 8 October 2013 1:40 PM

To: U2 Users List

Subject: Re: [U2] [OT] Interview Questions



Interviewer: What is one of your weak points?

Applicant: My honesty.

Interviewer: I would have thought that was a strong point.

Applicant: I don't give a %^* what you think you stupid ^^%$







__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users

  __**_

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


__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] Interview Questions

2013-10-11 Thread Bill Haskett

Kevin:

And that's the crux of the interview process.  If you hire people with 
all the skills you want, and they don't go somewhere else, why would you 
think people you train will go somewhere else?  Or think of this 
conversely.  My thought is people go somewhere else for a reason.  Nip 
that reason in the bud, so to speak, and you won't have that problem, or 
at least you can focus your attention on other problems.  :-)


Bill
Untitled Page



- Original Message -
*From:* ke...@precisonline.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 10/11/2013 1:15 PM
*Subject:* Re: [U2] [OT] Interview Questions

I also agree.  I'm willing to train, but what I've found is that someone
that is willing to learn doesn't necessarily mean they're able to learn
or willing to do what they've learned.  What happened here was that a
group of folks with little experience got a lot of good training and then
took the training elsewhere, so I'd rather not start from scratch if at all
possible.  We need folks to be able to contribute quickly, so I don't have
the time nor desire to give someone their first programming job knowing
that I'm only giving them wings to fly.

And yeah, I'm still a little bitter.  I'll get over it. :-)


On Fri, Oct 11, 2013 at 1:33 PM, Robert Frailey rfrai...@utahmed.comwrote:


I totally agree with Brenda and Bill. Work sent Brooke and I to Epicor's
Unidata and Pick classes in California, I only had Novell and Microsoft
when I was hired.
I picked up Unix, Unidata, redback and DBMS from classes provided by work.
19 years later, Brooke and I are self sufficient. We show up on time and
put in
whatever necessary to complete our tasks. We learn everything in sight. We
would be hard pressed if one or both of us got hit by a bus. I'm expected
to be 24 hours
a day / seven days a week and Brooke fills in when I can't. I run into
very few people with our work ethic anymore.

Robert
- Original Message - From: Brenda Ives 
bren...@marketamerica.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Friday, October 11, 2013 1:18 PM

Subject: Re: [U2] [OT] Interview Questions


  How about the other end here?

By other end, I mean this.  What about someone in college or out of
college with a degree other than an IT subject or if with an IT degree or
working on one, who has been taught by someone with over 20 years of
experience outside of college but the student/graduate has no employment
history of what has been taught them outside of college.  Plus they meet
all 3 of your requirements listed below?

UniVerse/UniData/D3/JBASE/**CACHE is not taught in colleges and if we
don't teach them what happens when all of us oldies are gone?

Brenda

-Original Message-
From: 
u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[mailto:
u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org]
On Behalf Of Bill Haskett
Sent: Friday, October 11, 2013 2:41 PM
To: U2 Users List
Subject: Re: [U2] [OT] Interview Questions

Kevin:

After actually hiring a lot of people, and firing those that needed it,
I've come to the conclusion that all employers need a person with the
following three attributes:

1)  An ability, and willingness, to be on-time,
2)  An ability, and willingness, to be presentable in all business
situations, and
3)  An ability, and willingness, to learn what they don't know (which is
always a lot!).

The people coming out of college these days are mostly unemployable.
Today's bachelors degree is like a 1930 8th grade education, or a 1970
high school education.  So, no matter what any Human Services dweeb says,
getting someone to show up looking presentable and willing to work whatever
it takes to learn what they don't know is gold!  These kinds of people are
quite trainable and, considering all software frameworks have a short shelf
life anyway, offer a lot of flexibility for your purposes.

Just a thought.  :-)

Bill

--**--**

- Original Message -
*From:* ke...@precisonline.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 10/11/2013 9:56 AM
*Subject:* Re: [U2] [OT] Interview Questions


[...snipped...]


On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.com
[...snipped...]

  Robert

- Original Message - From: Kevin King
ke...@precisonline.com
To: Susan Joslyn sjos...@sjplus.com; U2 Users List 
u2-users@listserver.u2ug.org
Sent: Wednesday, October 09, 2013 8:07 PM

Subject: Re: [U2] [OT] Interview Questions


Susan, yes.  I've been very open in my interviews, and it's netted
significantly regrettable results.  So this time I'm going for
people who can get behind and contribute to the common cause as soon
after hire as possible.  I don't have any aspirations of hiring for
life, though I certainly do endeavor to have that kind of an
environment

[U2] Fwd: Re: Select from one file with save-list from another file

2013-08-28 Thread Bill Haskett

Tony:

I use a simple program, inspired by a U2 tech note at 
https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select, 
that does the following:


LSELECT ARTVIOLATION WITH UNITID IN DEFAULT.LIST.NAME

The list is simply generated then used in the statement.  So, I can 
create a select list of unit#s from anywhere and name it 
DEFAULT.LIST.NAME.  Then can search the ARTVIOLATION file items whose 
unit ID is anywhere in the select list.


[...added comments...]
This becomes required when one does something like:

SELECT SOMEFILE 'a''b''c'...'{n}'

...and the number of items to select exceed 256 (UD barfs on this).  
Now, I just change the code to do a select first, like:


SELECT SOMEFILE 'a''b''c'...'{n}'
SAVE.LIST MY.LIST
LSELECT ANOTHERFILE WITH KEY IN MY.LIST

This turned out to be a simple solution when web'izing our application, 
knowing users will be selecting keys (not values) to submit to a select 
statement that does something (lots of things, actually).  :-)


Bill
Untitled Page



- Original Message -
*From:* 3xk547...@sneakemail.com
*To:* u2-users@listserver.u2ug.org
*Date:* 8/28/2013 5:18 AM
*Subject:* Re: [U2] Select from one file with save-list from another file

Not sure where to toss this into this thread so I'll start at the
beginning. I wanted to see the solutions that would be offered. I
blogged on exactly this topic back in 2008. The solution I published
for D3 uses @environment variables to allow us to do inner queries
with a tiny bit of simple and reusable code, no dict items, no work
files, and no save-lists. Perhaps someone can describe the
UD/UV-specific equivalents so that we can accomplish this here using
similar methods? I'll be happy to add the U2 solution to the blog for
future reference.
http://Nebula-RnD.com/blog/tech/mv/2008/03/d3shell1.html



Tony Gravagno   
Nebula Research and Development 
TG@ remove.pleaseNebula-RnD.com 
http://Nebula-RnD.com/blog  
http://LinkedIn.com/in/TonyGravagno 
http://Twitter.com/TonyGravagno 
http://PickWiki.com 
http://groups.google.com/group/MVDBMS   
http://www.LinkedIn.com/groups/Pick-Users-Group-64935   
http://BitBucket.org/FOSS4MV/



From: Hilk, Brandon
UniVerse 10.1, HP/UX, Pick.
Is there a way I can build a save-list from a selection from onefile
X.INFO (where the record ID is an 8 digit number) and use that listto
select from file Y.INFO (where that 8 digit number is not the recordID
but does exist as a foreign key elsewhere in the file). In SQLthis
would be considered a join and would look something like this:

select *
from X.INFO, Y.INFO
where X.INFO.packet.id=Y.INFO.packet.id
and X.INFO.status='ccc';

I can run this in TCL and have it return the results I want butcan't build
a save-list from it because I don't know the UniVerse/SQL syntax todoso.
So to summarize, is there a way to use a save-list built from X.INFOto
make another save-list comprised of the record ID's from Y.INFO?



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


Re: [U2] [UV] ED PERMISSIONS subroutine

2013-08-20 Thread Bill Haskett

Diane:

I use UniData and always put my accounts underneath a level separate 
from @UDTHOME (in E:\UDAccounts).  I've never had this kind of 
problem, but have had DNS issues.  I wouldn't even contemplate putting 
anything under C: so have no idea what can happen there.  :-(


Bill


- Original Message -
*From:* dia...@aptron.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/20/2013 1:29 PM
*Subject:* Re: [U2] [UV] ED PERMISSIONS subroutine
c:\level contains about 10 universe accounts.  All are local 
directories, none are remote.

-Dianne

On 8/20/2013 4:24 PM, Aaron Titus wrote:

Hi Diane, a couple of questions.

How many other directories exist within c:\level ?
Is C:\ACCOUNT a local directory and c:\level remote?


*Aaron Titus*
Senior Software Engineer
F.W. Davison  Company, Inc.
508-747-7261 x245
ati...@fwdco.com



On Tue, Aug 20, 2013 at 2:00 PM, Dianne Ackerman dia...@aptron.com 
wrote:



OK, I've found the PERMISSIONS subroutine (APP.PROGS PERMS.B) and have
narrowed this issue down more.  It's actually a slowness in the basic
command STATUS.  It's instantaneous in an upper level account (eg
C:\ACCOUNT) but takes 4-5 seconds in a lower level account (eg
C:\level\ACCOUNT).  Any thoughts?
Thanks
-Dianne


On 8/15/2013 9:50 AM, Dianne Ackerman wrote:

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-usershttp://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] @RECORD VARIABLES

2013-08-15 Thread Bill Haskett
Isn't this pretty much the same thing as ITYPE(), except the conversions 
are processed?


In the CALCULATE() form, the dictionary.item can be a quoted string
or a UniBasic variable. The expression uses the data from the current
@RECORD during the evaluation process.

In the {} form, the dictionary.item must be the literal dictionary
name with no quotation marks.

You must open a dictionary to @DICT and read the data record into
@RECORD for the function to work properly.

If these functions are successful, they update the values in @CONV,
@FORMAT, and @HEADER. You can then use these @ variables in other
UniBasic functions, such as ICONV, OCONV, and FMT. For more information
about @ variables, see Appendix B, UniBasic@variables.

-

The UniBasic ITYPE function enables a UniBasic program to execute
a UniData virtual attribute from the dictionary of a UniData file.
The value of the function is the same as if it were run using UniQuery
or UniData SQL.

Note:  ITYPE generally requires you to open both the dictionary and
data portions of the file. Before you use this function, you must
compile the dictionary of the file by using the ECL COMPILE.DICT
or CD command.

In most cases, you also must assign the @ID and @RECORD variables.
These variables resolve the value of the ITYPE function. However,
if neither the ID of the file nor the data from the record is used
in the ITYPE, you do not need to assign these variables.

Note: Conversion or formatting codes in the dictionary record of
the virtual attribute does not affect the value ITYPE returns.

Bill
Untitled Page



- Original Message -
*From:* p...@gnosys.co.nz
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/15/2013 2:10 PM
*Subject:* Re: [U2] @RECORD VARIABLES

Is that only a Unidata thing? Sounds like a nice feature to have in 
Universe.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
charles_shaf...@ntn-bower.com
Sent: Friday, 16 August 2013 9:06 a.m.
To: U2 Users List
Cc: u2-users-boun...@listserver.u2ug.org
Subject: Re: [U2] @RECORD VARIABLES

Of course. Worked like a charm.

Thank you Dave.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Dave Davis dda...@harriscomputer.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date:   08/15/2013 03:41 PM
Subject:Re: [U2] @RECORD VARIABLES
Sent by:u2-users-boun...@listserver.u2ug.org



HELP CALCULATE

You have to have your dictionary open to @DICT as well.

I think you want to say

RESULT = CALCULATE(ATTRIBUTE)

Since {} is for a literal attribute name only.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [ 
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
charles_shaf...@ntn-bower.com
Sent: Thursday, August 15, 2013 4:35 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] @RECORD VARIABLES

I am attempting to pass a variable into a SUBROUTINE and use it to access the 
data through the dictionary name.

SUBROUTINE fieldLookup(., ATTRIBUTE, ) .
.
.
READ @RECORD FROM F.FILE, @ID THEN
 RESULT = {ATTRIBUTE}
END ELSE
 RESULT = 
END

The part that isn't working is the RESULT = {ATTRIBUTE}

As written here it is looking for a dictionary attribute named ATTRIBUTE.
I tried forcing it to evaluate the variable ATTRIBUTE to the value in ATTRIBUTE 
by putting it in parenthesis, but it complained that it was expecting a 
variable when it was compiling.
Is there a way to use a variable in the curly braces so that I can make this a 
generic subroutine?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
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]
http://www.harriscomputer.com/
 6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://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

--
This email was Virus 

Re: [U2] OPENSEQ

2013-08-05 Thread Bill Haskett

Al:

UniData help shows...

Help Information For: UNIBASIC OPENSEQ  
Page: 1/5


OPENSEQ

Syntax

OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}

OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}

Description

The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.

It would seem your path uses the seq.filename, record.id format 
instead of the absolute path format.  e.g.


065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO 
OUT.FILE ELSE

HTH (and fixes it).

Bill
Untitled Page



- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ

I'm a Domain Admin so permissions is not an issue.  I'm going back to the 
beginning and start over.  Maybe I have an issue I'm not seeing.

Thanks for all your help.

Albert DeWitt, CPIM
Sr. Programmer Analyst

Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com

Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Monday, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ

Does the code still fail with the dummy file out there? If not, I'd guess 
permissions.



From:   Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date:   08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org

Thanks for your reply Kevin.

I can list LRGLBRVARS at TCL.  I put a dummy file inside to prove it.

FNAME does not exist.  In the code I stole this from the name is created
anew each time.  It always open the file empty, allows me to populate
and close it.  However, in this code it's not working.

Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.

Albert DeWitt, CPIM
Sr. Programmer Analyst

Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com

Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook


-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ

I've never used OPENSEQ on a remote drive like that.  I presume you can
LIST LRGLBRVARS @ TCL without difficulty right?  If so, I would think the
OPENSEQ should work with that just fine.  May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?



On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:

Please educate me on OPENSEQ.  I have some code that is giving me an
error.  The funny thing is that I stole the code from a working program:
  The code:

064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO 
OUT.FILE ELSE
066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE
067:   ERRCD = STATUS()
068:   GOSUB 900
069:   CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.')
070:   GO 
071: END
If I run it as is ERRCD = 2.  If I comment out 65 and uncomment 66
ERRCD = 0.  According to manual 2 means: The file does not exist.  A 0
means The record does not exist.

In my voc file I have an entry for LRGLBRVARS.  It looks like this:
Top of LRGLBRVARS in VOC, 3 lines, 48 characters.
001: DIR
002: \\led\fs-styl\Public\LrgLbrVariances
003: D_HOLD_
Bottom.
  What is OPENSEQ looking for and where does it expect it to find it?

Thanks.

Albert DeWitt, CPIM

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


Re: [U2] OPENSEQ

2013-08-05 Thread Bill Haskett
Remember, if you're using Windows 2008 (Vista Server) or later (I use 
2008 R2 - Windows 7 Server) then you have to be careful about how you 
share the network directory you want to share.


For testing purposes, if you're using Windows, it may be a good idea to 
share the directory to everyone, with full permissions.


Bill
Untitled Page



- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 8/5/2013 10:16 AM
*Subject:* Re: [U2] OPENSEQ

*Falls out of my chair*

What ? What ?
I never knew you could DO this!

After some fiddling about I finally was able to make OPENSEQ open an UNC path.
Of course the one I tried, actually points to the exact same server and account 
the code is already running in, but I didn't even know you could OPEN an UNC 
path at all before!  I've been translating the UNC paths into DOS paths.

Now to try to open remote UNC path


-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Aug 5, 2013 10:05 am
Subject: Re: [U2] OPENSEQ


Al:

UniData help shows...

  Help Information For: UNIBASIC OPENSEQ
Page: 1/5

OPENSEQ

Syntax

OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}

OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}

Description

The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.

It would seem your path uses the seq.filename, record.id format
instead of the absolute path format.  e.g.

065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO
OUT.FILE ELSE

HTH (and fixes it).

Bill
Untitled Page



- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ

I'm a Domain Admin so permissions is not an issue.  I'm going back to the
beginning and start over.  Maybe I have an issue I'm not seeing.

Thanks for all your help.

Albert DeWitt, CPIM
Sr. Programmer Analyst

Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com

Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of bradley.sch...@usbank.com
Sent: Monday, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ

Does the code still fail with the dummy file out there? If not, I'd guess
permissions.


From:   Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date:   08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org

Thanks for your reply Kevin.

I can list LRGLBRVARS at TCL.  I put a dummy file inside to prove it.

FNAME does not exist.  In the code I stole this from the name is created
anew each time.  It always open the file empty, allows me to populate
and close it.  However, in this code it's not working.

Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.

Albert DeWitt, CPIM
Sr. Programmer Analyst

Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com

Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook


-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ

I've never used OPENSEQ on a remote drive like that.  I presume you can
LIST LRGLBRVARS @ TCL without difficulty right?  If so, I would think the
OPENSEQ should work with that just fine.  May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?



On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:

Please educate me on OPENSEQ.  I have some code that is giving me an
error.  The funny thing is that I stole the code from a working program:
   The code:

064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME

Re: [U2] Pick flavor in U2 personal edition

2013-08-05 Thread Bill Haskett

Eric:

Yes.

Bill


- Original Message -
*From:* earmstr...@lobelfinancial.com
*To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
*Date:* 8/5/2013 1:24 PM
*Subject:* Re: [U2] Pick flavor in U2 personal edition

Dan, Thanks.

I downloaded and installed the Extensible Administration Tool it. Do I have to 
create a new U2 Server in order to use it?

Eric Armstrong
IT Dept

--

Message: 6
Date: Fri, 2 Aug 2013 21:31:58 +
From: Daniel McGrath dmcgr...@rocketsoftware.com
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] Pick flavor in U2 personal edition
Message-ID:
8e17b0ffe20e47db8ffcae5d1b91e...@wal-vm-mbx1.rocketsoftware.com
Content-Type: text/plain; charset=us-ascii

XAdmin, part of our U2 DBTools package: 
http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/try-now

Regards,

Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software



LOBEL FINANCIAL PRIVACY NOTICE:
This communication may contain confidential company information that is 
protected by federal law. Federal regulations prohibit the disclosure (or 
re-disclosure) of confidential information without the written consent of the 
person(s) to whom it pertains. Additionally, the views or opinions presented in 
this email are solely those of the author and do not necessarily represent 
those of the company.


___
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] XAdmin wiki?

2013-08-05 Thread Bill Haskett
You know, I'd have no problem updating documentation to a wiki site, 
where I know all documentation would go and I could continue to 
reference the documentation in the future.  The Pickwiki is a little 
disorganized, but since I do most of my database work with U2 I'd be 
happy to update anything to a wiki they provide.


The biggest problem I see is the changing technology.  Everything 
changes, including wikis!  Simple is always better, and since we're all 
developers to one degree or another, we don't need a completely 
idiot-proof environment; just someone at U2's end who can keep us idiots 
in line and keep the site organized.


Just my $.02.  :-)

Bill

- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 4:57 PM
*Subject:* Re: [U2] XAdmin wiki?

Hi:

The problem is not whether you need a wiki or not.  The problem is the
documentation is terrible and in most cases non-existent. A year ago at U2
University a majority of us discussed this with the board of Rocket U2.
  The agreed with us they would fix this and show some examples as well.

Well, here we are a year and many months later with the same problem.  New
users and non-eclipse users cannot figure out how this tool works.

Since U2logic is a U2 VAR, U2logic does get paid to tell our clients how to
use this tool and the others.  However, since the tools are given away by
Rocket there is little money in the pot for any meaningful help.

Regards,
Doug
www.u2logic.com
Better documentation for our XLr8 Tools
___
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] [UD] BASIC Code Failing

2013-07-30 Thread Bill Haskett

John:

That's an interesting thought.  We do backups of the application account 
every night, so I do have the last 10 days object code in a backup (plus 
the last four months weekly backups).  I'll look at this the next time 
it happens.  Thanks,


Bill
Untitled Page



- Original Message -
*From:* jhes...@momtex.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/30/2013 11:01 AM
*Subject:* Re: [U2] [UD] BASIC Code Failing

I would also consider the possibility of data corruption at the hardware
level.  Granted, I would expect that you'd also occasionally find
anomalies within your source code and data files if this were the case,
but I don't know how your filesystems are set up.  If the object code
has become corrupt, that would explain why recompiling fixes the
problem.  The newly created object code will be stored on a new location
in the filesystem.  Fortunately this possibility is very easy to test
for.  Just make a copy of your application account on alternate storage
and wait for the problem to recur.  When it does, open the live object
file and your backup copy in an editor with diff capability (Notepad++
is a good one) and see if they still match.

-John

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Thursday, July 25, 2013 12:25 PM
To: U2 Mail List
Subject: [U2] [UD] BASIC Code Failing

We've been having an anomaly that has occurred over the past 7 years
we've been using UniData on Windows.

Yesterday one of the accounts on our ASP server, that contains about 30
accounts, had a billing issue.  This issue was created because a single
BASIC program didn't run a couple of lines of code, thus a particular
type of charge wasn't created for anyone on this account.  The BASIC
code is compiled in an application account then cataloged locally in
each account (a pointer to the program file exists on every account).

When I make a copy of this particular account, then run the offending
program in it, I see the same problem.  When I put a DEBUG statement (in
the offending program) just above where I suspect the problem occurs,
recompile then rerun it, there is no problem.  After futzing around with
placing the DEBUG statement in several different locations, with no
further issue, I remove the DEBUG statement and finally re-compile the
offending program.  I've changed nothing in the program, but it now
works.  This particular program runs maybe 250,000 billings every month
with nothing wrong happening.  In fact, I haven't seen this problem in
this billing program for the past seven years, which means that maybe
over 20 million transactions have been created with no issues.

This happens about once every six months or so on one BASIC program or
another, where I look at an offending program, see something like five
lines of code writing to five different files, and the issue is the last
two lines didn't execute.  When I put a DEBUG into the program
everything works fine.  When I remove the DEBUG statement and recompile
everything works fine from then on.

Has anyone else seen this?  Maybe there's something I should do to
prevent this.

Bill
___
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] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Bill Haskett
I must say, I use triggers in UD with no problems.  When converting from 
D3 to UD I had a hard time getting them to work.  However, with useful 
suggestions from several on this list I was able to get them working 
properly.  They turned out to be a bit more robust than the D3 
triggers.  I've been able to debug the trigger several times when 
problems appeared, but haven't for a number of years as they work as 
expected now.


The structure took a while to get my head around, but I simply have two 
trigger programs (globally cataloged):


U2.MASTER.TRIGGER.D
U2.MASTER.TRIGGER.U

...which handle all delete and update triggers.  Inside each program a 
file is read that actually provides the trigger subroutines to CALL (via 
a CALL @...).  So, I can insert any subroutine as a trigger in any 
account.  These programs are cataloged locally.  I don't remember any 
problems debugging these subroutines.


Just a thought.

Bill


- Original Message -
*From:* perry.tay...@zirmed.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/29/2013 6:24 AM
*Subject:* Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty 
using DEBUG or RAID with them? Was: Universe Triggers

That and the expense of their usage.

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Friday, July 26, 2013 1:32 PM
To: U2 Users List
Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG 
or RAID with them? Was: Universe Triggers

How many people avoid using triggers BECAUSE of the virtual
impossibility of using RAID with Triggers?

On 7/26/2013 12:33 PM, Phil Walker wrote:

I won't be holding my breath Charles ;-)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Friday, 26 July 2013 9:22 p.m.
To: U2 Users List
Subject: Re: [U2] Universe Triggers

re. triggers  Raid,  I could not agree with Phil more.  Well said.
Come on, Rocket!

On 7/19/2013 1:32 AM, Phil Walker wrote:

Ken,

I am glad you raised the issue about debugging a program with a file which has 
a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages 
about fixing this pushing for the ability to be able to step into the trigger 
code, but at a VERY MINIMUM being able to debug the program and perform the 
write on the file, and in effect step over the trigger subroutine and carry on 
debugging. The issue is the trigger subroutine cannot support input, so what UV 
have done is basically say you are using the debugger so you are inputting 
debug commands so you will abort. They need to turn this restriction off for 
debugging so that either of the above two scenarios is supported.

In a Microsoft world I can debug anything through the connected world of 
web/databases etc..

Have had no feedback from UV

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
Sent: Friday, 19 July 2013 9:48 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe Triggers

Dan,
In addition to the other responses you have received, I suggest the following:
1. Have one master file trigger subroutine (globally catalogued) that calls 
subroutines (locally catalogued) tailored to individual files.  This means you 
don't have to stop and restart Universe when a new trigger is required or a 
change to an existing one.  If the master subroutine changes, you do have to 
restart Universe.
2. Use a control record that records the subroutine name and state of the 
trigger for each file having a trigger.
3. Use a program to change the state of a trigger, using the control records in 
2 above.
4. Make sure all background processes that have a file with a trigger open are 
logged out when recompiling the subroutine for that file trigger.
5. Remember that you can't do anything to a file with an active trigger whilst 
in the RAID debugger (it will crash).  Rather, if you are testing a file 
trigger subroutine, drop the trigger and use a trigger testing program that 
calls the subroutine after taking a copy of the record being changed, pausing 
whilst you change it in another session, and then resuming, calling the 
subroutine.

If you would like samples of any of the software mentioned above, let me know, 
and I can send them to you.

Regards,
Ken Ford
Universe Software Developer
t 07 3013 8605 | f 07 3002 8400
e ken.f...@firstmac.com.au | w firstmac.com.au

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

CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s)
and may contain confidential and 

[U2] [UD] BASIC Code Failing

2013-07-25 Thread Bill Haskett
We've been having an anomaly that has occurred over the past 7 years 
we've been using UniData on Windows.


Yesterday one of the accounts on our ASP server, that contains about 30 
accounts, had a billing issue.  This issue was created because a single 
BASIC program didn't run a couple of lines of code, thus a particular 
type of charge wasn't created for anyone on this account.  The BASIC 
code is compiled in an application account then cataloged locally in 
each account (a pointer to the program file exists on every account).


When I make a copy of this particular account, then run the offending 
program in it, I see the same problem.  When I put a DEBUG statement (in 
the offending program) just above where I suspect the problem occurs, 
recompile then rerun it, there is no problem.  After futzing around with 
placing the DEBUG statement in several different locations, with no 
further issue, I remove the DEBUG statement and finally re-compile the 
offending program.  I've changed nothing in the program, but it now 
works.  This particular program runs maybe 250,000 billings every month 
with nothing wrong happening.  In fact, I haven't seen this problem in 
this billing program for the past seven years, which means that maybe 
over 20 million transactions have been created with no issues.


This happens about once every six months or so on one BASIC program or 
another, where I look at an offending program, see something like five 
lines of code writing to five different files, and the issue is the last 
two lines didn't execute.  When I put a DEBUG into the program 
everything works fine.  When I remove the DEBUG statement and recompile 
everything works fine from then on.


Has anyone else seen this?  Maybe there's something I should do to 
prevent this.


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


Re: [U2] [UD] BASIC Code Failing

2013-07-25 Thread Bill Haskett

Robert:

...the object code became corrupt due to a system crash.  That sounds 
plausible.  Our systems rarely go down, but they do get rebooted with 
Windows Updates.  UO connections often fail, then get picked up.  Telnet 
often freezes or aborts (mostly client issues) then they log in again.  
Then there's ...


It's always something...and these moron kids think everything works just 
fine (because they haven't lived long enough to see it not work).  :-)


Bill
Untitled Page



- Original Message -
*From:* i...@keyway.net
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/25/2013 1:57 PM
*Subject:* Re: [U2] [UD] BASIC Code Failing
I just remembered another situation I saw once where a program behaved 
strangely. When we used the command to verify the object code 
(BVERIFY?) it didn't verify. A recompile fixed it because the object 
code became corrupt due to a system crash.


Sometimes you can have the same thing happen, but in the catalog space.

Robert Norman
ROBERT NORMAN AND ASSOCIATES
23441 Golden Springs Dr., #289, Diamond Bar, CA 91765
(951) 541-1668
i...@keyway.net mailto:i...@keyway.net
http://users.keyway.net/~ice/ http://users.keyway.net/%7Eice/
Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, 
UniVerse

Basic, UniBasic, R/BASIC, jBC.

On 7/25/2013 1:36 PM, Woodward, Bob wrote:

I agree with Tony.  I once had a program that my fix was just adding a
JUNK = 0 line near the top of the program.  With that do-nothing line
the program worked.  Comment the line out or remove it completely and
the program seemed to skip lines of code.

This was a LONG time ago, though.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Thursday, July 25, 2013 1:05 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UD] BASIC Code Failing

Bill, at Pick Systems we occasionally saw issues like this, where the
object code would behave differently if specific statements (their
opcodes/tokens) were broken across frame boundaries. Until DBMS patches
become available, the problem could be avoided with some
carefully-placed NULL statements. I've seen this with RPL too, for
exactly the same reasons. I know nothing of U2 internals but the
internals are of course similar. Unfortunately without a confirmed
cause/effect scenario defined by engineers, it's a crap shoot as to
whether inserting NULLs will help, or where they can be inserted to
ensure they work.

I suggest you contact Rocket and ask them to pursue this as a byte-level
issue in your object code. Sending them the code might not help if they
test in an environment that's different from your own.
They need to see it on your system. I'm just trying to save you some
wasted diagnostic time...

Best,
T


From: Bill Haskett
... a single BASIC program didn't run a couple of lines of code...

___
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] [UD] BASIC Code Failing

2013-07-25 Thread Bill Haskett

As always, thanks G-Man!

I can't replicate it.  It just comes up every six months (or so) with 
something totally different happening within our application, not to 
everybody, but to someone.  The testing is always the same; test to 
confirm, put in the DEBUG, recompile, test, confirm fix, take out DEBUG, 
recompile, test to confirm fix, then move on.  In the meantime, hundreds 
of thousands of transactions have taken place with no problems.


All I can say is; it could be worse!  :-)

Bill


- Original Message -
*From:* 3xk547...@sneakemail.com
*To:* u2-users@listserver.u2ug.org
*Date:* 7/25/2013 1:04 PM
*Subject:* Re: [U2] [UD] BASIC Code Failing

Bill, at Pick Systems we occasionally saw issues like this, where the
object code would behave differently if specific statements (their
opcodes/tokens) were broken across frame boundaries. Until DBMS
patches become available, the problem could be avoided with some
carefully-placed NULL statements. I've seen this with RPL too, for
exactly the same reasons. I know nothing of U2 internals but the
internals are of course similar. Unfortunately without a confirmed
cause/effect scenario defined by engineers, it's a crap shoot as to
whether inserting NULLs will help, or where they can be inserted to
ensure they work.

I suggest you contact Rocket and ask them to pursue this as a
byte-level issue in your object code. Sending them the code might not
help if they test in an environment that's different from your own.
They need to see it on your system. I'm just trying to save you some
wasted diagnostic time...

Best,
T


From: Bill Haskett
... a single BASIC program didn't run a couple of lines of code...

___
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] CentOS with Universe?

2013-07-17 Thread Bill Haskett
Are you saying your client wouldn't pay $750 for Windows Server 2008 
R2?  ...and you actually get paid?  :-)


Bill


- Original Message -
*From:* dw...@tincat-group.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/17/2013 6:41 AM
*Subject:* [U2] CentOS with Universe?

We have a VAR who would prefer to load Universe and their application on a
supported platform, but we would prefer not to pay for RHEL 6. I searched
the list and found a few tidbits, but does anyone have a good list of what
changes might be required to successfully run Universe 11.1 on CentOS? How
much pain would we be introducing for ourselves and our VAR, if they were
willing to play along?

Thanks.  --dawn


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


Re: [U2] CentOS with Universe?

2013-07-17 Thread Bill Haskett

Dawn:

I kind of figured.  :-)  Whatever you decide, I'm sure would be fine.  I 
would just not look for anything free, because nothing is free.


I run everything on Windows because everything in the O/S is updated and 
I know every machine I run is running the same version of Windows.  It 
seems when Windows updates I have very few problems with the software 
I'm running on the machine. Surprisingly, this makes my life a lot 
easier.  IIS is easy to install, and 3rd party SFTP is too, with virtual 
accounts as act like real Windows accounts.


Although I run UniData, I think UniVerse is just as stable on Windows as 
it is on ..nix.  Although you may have specific reasons to run on ..nix 
I would think free shouldn't be one of them.


Just a thought.

Bill


- Original Message -
*From:* dw...@tincat-group.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/17/2013 10:48 AM
*Subject:* Re: [U2] CentOS with Universe?

Hi Bill -- Ah, this time I'm in the client seat, desiring a hosted solution
for Universe. We will choose the same box for starters for the web server
as well. The VAR runs IIS on Windows, but Apache on linux. Given that info,
which OS would you select for Universe 11.1?   --dawn


On Wed, Jul 17, 2013 at 12:28 PM, Bill Haskett wphask...@advantos.netwrote:


Are you saying your client wouldn't pay $750 for Windows Server 2008 R2?
  ...and you actually get paid?  :-)

Bill

--**--**

- Original Message -
*From:* dw...@tincat-group.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/17/2013 6:41 AM
*Subject:* [U2] CentOS with Universe?

  We have a VAR who would prefer to load Universe and their application on a

supported platform, but we would prefer not to pay for RHEL 6. I searched
the list and found a few tidbits, but does anyone have a good list of what
changes might be required to successfully run Universe 11.1 on CentOS? How
much pain would we be introducing for ourselves and our VAR, if they were
willing to play along?

Thanks.  --dawn


__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] CentOS with Universe?

2013-07-17 Thread Bill Haskett
I'm not sure why you'd say that.  I wouldn't create a caveat that my 
time is worth nothing; thus, as Tony says, Linux ain't free.


I have very little trouble with Windows, so, again, I'm not sure what 
you refer to about not putting IIS and the dbms server on the same box 
and face it towards the internet...Windows is much better than it used 
to be. The minimal amount of configuration, along with a firewall device 
and/or router seems to work just fine, especially in our development 
environment.  Now, if you want to work with the Active Directory on 
Windows Server 2012, or configure a VPN on your firewall/VPN device, 
then you might as well just shoot yourself instead!  :-)


I use Windows because, in the aggregate, using it has saved me a lot of 
time with our customers.  YMMV...


Bill


- Original Message -
*From:* antli...@youngman.org.uk
*To:* u2-users@listserver.u2ug.org
*Date:* 7/17/2013 12:25 PM
*Subject:* Re: [U2] CentOS with Universe?

On 17/07/2013 19:09, Bill Haskett wrote:

Dawn:

I kind of figured.  :-)  Whatever you decide, I'm sure would be 
fine.  I would just not look for anything free, because nothing is 
free.


It's only free if your time is worth nothing - I think that's one of 
Tony's quotes. Just don't forget, linux is Free, which is completely 
different.


I run everything on Windows because everything in the O/S is updated 
and I know every machine I run is running the same version of 
Windows.  It seems when Windows updates I have very few problems with 
the software I'm running on the machine. Surprisingly, this makes my 
life a lot easier.  IIS is easy to install, and 3rd party SFTP is 
too, with virtual accounts as act like real Windows accounts.


And yet we hear loads of stories about how updates regularly break 
Windows ... although they tend to be client stuff that suffers most of 
that. The counter-advantage of linux is it's easy to run a 
stripped-down box with only the services you want. Especially with a 
net-facing system, how easy is it to run Windows with everything 
except IIS locked-down/disabled/deleted?


And on linux you have total control over updates too. I don't think 
you want to run gentoo like me, but if you've got someone who can 
administer the system you could run Apache on one system facing the 
net, on a totally locked-down system (maybe even with a DVD as your 
system drive) with a firewall between that and your UV system.


I'd be a little bit worried about having just one Windows system, 
net-facing, running both the web server and the database.


Although I run UniData, I think UniVerse is just as stable on Windows 
as it is on ..nix.  Although you may have specific reasons to run on 
..nix I would think free shouldn't be one of them.


Just a thought.


A sensible thought :-) but you can see which way I'd go :-)

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] Fwd: UML mapping tool for MV (UniVerse)

2013-07-16 Thread Bill Haskett
You can place all of your dictionaries into a separate account, in a 
separate directory.  Create valid update permissions for an 
administrator to this database directory and read permissions for users, 
and anyone else


Bill

Untitled Page
- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 7/16/2013 9:44 AM
*Subject:* [U2] Fwd: UML mapping tool for MV (UniVerse)

-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, Jul 16, 2013 9:42 am
Subject: Re: [U2] UML mapping tool for MV (UniVerse)


But with programmers able to create new DICT entries as they will, how do you 
*keep* it spotless?
  



-Original Message-
From: Hona, David david.h...@cba.com.au
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Jul 15, 2013 5:40 pm
Subject: Re: [U2] UML mapping tool for MV (UniVerse)


Regardless of the toolset, the first hurdle would be to normalise your database
to look like a relational one. Which is likely to be the greatest hurdle. Data
dictionaries in U2/PICK are optional are a purely for reporting purposes - they
can have duplicates and these can be conflicting. Even worse (as if you thought
it could be) - data dictionaries can be incomplete or wrong. This added to the
lack of enforcement of data integrity and constraints usually causes these
toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck!

Rocket released U2 Metadata Manager to assist in this respect and is designed to
allow forward and backwards capability. Although, support for this in UV is
limited to the latest official release... so your alternative is UV/ODBC...

For UV/ODBC users - I have always recommended a separate UV account and data
dictionary that is spotless. For some this is the best option - why go against
the flow - when you create your own stream...


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


Re: [U2] Fwd: UML mapping tool for MV (UniVerse)

2013-07-16 Thread Bill Haskett

George:

You could create another dictionary account, next to the first one, 
and reference it for those accounts that utilize the same file names 
with different data structures.  Would that work?


Bill
Untitled Page



- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/16/2013 11:16 AM
*Subject:* Re: [U2] Fwd: UML mapping tool for MV (UniVerse)

The only downside to that would be that you can't have filenames of the same 
name in different accounts, unless you factor the accountname into the dict 
name.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, July 16, 2013 2:11 PM
To: U2 Users List
Subject: Re: [U2] Fwd: UML mapping tool for MV (UniVerse)

You can place all of your dictionaries into a separate account, in a
separate directory.  Create valid update permissions for an
administrator to this database directory and read permissions for users,
and anyone else

Bill


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


Re: [U2] Fwd: UML mapping tool for MV (UniVerse)

2013-07-16 Thread Bill Haskett

Yea, but who's going to read, and understand, the XML?  :-)

Bill
Untitled Page



- Original Message -
*From:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/16/2013 2:05 PM
*Subject:* Re: [U2] Fwd: UML mapping tool for MV (UniVerse)

You silly boys and girls, you don't need dictionaries to do a UML class
diagram.  You just need UniBasic code, Eclipse to index your code, and XLr8
to create the XML.

Regards,
Doug
www.u2logic.com
Spelling is optional for U2 programmers

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


Re: [U2] Mobile phones

2013-07-15 Thread Bill Haskett

Did it help, and what did you decide to do? :-)

Bill


- Original Message -
*From:* syme...@gmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 7/15/2013 5:20 AM
*Subject:* Re: [U2] Mobile phones

Thanks everyone for your information.



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


Re: [U2] SORT reports line length, change right margin?

2013-07-15 Thread Bill Haskett
The simplest solution is to change the print width in UV then alter the 
CPI in PCL.  You may not have to alter the print width in UV if the 
original developer was prescient enough to plan for expansion.


e.g. ^027E^027l1e64F^027a0l85M^027(s0p16.67h0s3b##DEFFONTNO##T

...where ##DEFFONTNO### is just a tag that is substituted by the actual 
font ID# at runtime.


HTH,

Bill


- Original Message -
*From:* randyleesm...@roadrunner.com
*To:* u2-users@listserver.u2ug.org
*Date:* 7/15/2013 7:32 AM
*Subject:* [U2] SORT reports line length, change right margin?

It's been a while, nice to be back and working again. :)


I'm on a Universe Database;
  
I have a proc full of SORT reports.


I needed to add new fields, but the size of the line is too small. I'm
already using landscape mode and don't have enough space.

I have been testing with PCL, but I was wondering if I could just make the
line longer. Seems to be enough room if I could adjust the right margin.

MARGIN /n/ only changes the left margin.

I never had to deal much with SORT reports in the past, so I though you
Guru's could help.



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-change-right-margin-tp41205.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] [UV] Record Sampling for File Sizing Diagnostics

2013-06-12 Thread Bill Haskett

Harold:

UniData does have the SAMPLED verb.  It works the same way as described.

Bill


- Original Message -
*From:* harold.o...@clark.wa.gov
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 6/12/2013 2:17 PM
*Subject:* Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

Perry:
In Universe the modifier SAMPLED nn selects every nn'th record.  For
example, SELECT MYFILE SAMPLED 50 selects every 50th record.  That way
you plow thru the entire file but come back with only  1/50 of the
records.   I don't know if this keyword exists in Unidata
Harold Oaks
Clark County, WA

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Tuesday, June 11, 2013 9:01 AM
To: U2-Users List
Subject: [U2] [UV] Record Sampling for File Sizing Diagnostics

I have several *very* large files on which I need to perform some file
sizing diagnostics.  Rather than repeatedly running HASH.AID against
these files is there a good way to sample say 2-3 million records to
copy into a test file?  SAMPLE will only grab the first n records in
hash order and I'm thinking that would not necessarily be a good
representative sample of the file's contents.  Am I up in the night
thinking this is the case?  Is there a better way to get a good sample
of records for this purpose?

Thanks.
Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://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

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

2013-06-11 Thread Bill Haskett

Does anyone have documentation on msglevelconfig?  I've set it as:

unidata = 16/PID/DT

...and get all kinds of junk like:

Sat May 25 20:27:45 pid=3808 No active select list, creating empty saved 
list.
Sat May 25 21:17:59 pid=172 No active select list, creating empty saved 
list.

Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10166_SEL failed.
Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10179_SEL failed.

...which just floods the udt.errlog.  Also, is there a way to log the 
account path?  I use multiple accounts with shared code so which account 
is having problems with a program would be quite helpful?


Thanks,

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


Re: [U2] MsgLvlConfig

2013-06-11 Thread Bill Haskett

Robert:

Thanks!  The links were very informative.  :-)

Bill
Untitled Page



- Original Message -
*From:* rfrai...@utahmed.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 6/11/2013 12:10 PM
*Subject:* Re: [U2] MsgLvlConfig

http://u2-universe-unidata.1073795.n5.nabble.com/Re-Logging-td28343.html

http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg32670.html

http://comments.gmane.org/gmane.comp.db.u2.general/57763

Robert
- Original Message - From: Bill Haskett 
wphask...@advantos.net

To: U2 Mail List U2-users@listserver.u2ug.org
Sent: Tuesday, June 11, 2013 1:06 PM
Subject: [U2] MsgLvlConfig



Does anyone have documentation on msglevelconfig?  I've set it as:

unidata = 16/PID/DT

...and get all kinds of junk like:

Sat May 25 20:27:45 pid=3808 No active select list, creating empty 
saved list.
Sat May 25 21:17:59 pid=172 No active select list, creating empty 
saved list.

Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10166_SEL failed.
Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10179_SEL failed.

...which just floods the udt.errlog.  Also, is there a way to log 
the account path?  I use multiple accounts with shared code so which 
account is having problems with a program would be quite helpful?


Thanks,

Bill Haskett
___
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] UniData PreStore to change the KEY of a record?

2013-05-29 Thread Bill Haskett

Or, you could download the BPTEST or TRY program from:

 http://www.pickwiki.com/cgi-bin/wiki.pl?BasicSource

...then write the simple code from the command line.  Not only are these 
programs good to test syntax, but they're great for performing simple 
tasks that don't work from the command line.


Bill


- Original Message -
*From:* mec...@gmx.net
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/29/2013 12:25 AM
*Subject:* Re: [U2] UniData PreStore to change the KEY of a record?
To stay with the picture of not using a hammer to drive in a screw, I 
would just write a Basic program to do this.

Use the right tool for the job!
Open the file
Execute GET-LIST
Then a loop that generates the new Ids including checking that it 
doesn't already exist, READU record from old Id, WRITE record to new 
ID, DELETE old record.

A few lines of code written in less than a minute.
Compile, generate list, run program, job done!


On 28/05/2013 21:59, Charlie Noah wrote:
Dang, David, you beat me to it. ;^) I was just going to suggest the 
same thing. Just because the OP wanted to use ED (a hammer) to drive 
in a screw doesn't mean that it is the best tool ( a screwdriver). 
Good answer.


Charlie Noah

On 05-28-2013 3:42 PM, David A. Green wrote:

I would take my saved list and copy it to a text editor then using copy
commands and a quick macro convert the list into a bunch of COPY 
FROM FILE.A

BAD.KEY, GOOD.KEY commands.  Then save it as a PA and then execute it.

David A. Green
(480) 813-1725
DAG Consulting

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

Sent: Tuesday, May 28, 2013 10:48 AM
To: 'U2 Users List'
Subject: [U2] UniData PreStore to change the KEY of a record?

I am always using what I call 'PreStore' command...

In the AE editor, I need to change  Attb 2  from A]thisbad]C]D   to be
A]thisgood]C]D  on a list of items...

So I get the list, AE FILENAME and then...

=FIX 2`R/thisbad/thisgood/`FI`=FIX

Viola!  The data is updated.

I have a need to 'fix' a KEY to a record...

Is there a way to use a PreStore command that could do that? It's 95
records.  Too many to hand edit.  Too few to write a program. A 
PreStore

would be JUST RIGHT... if there was a way to do it!

DW

___
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] select query..

2013-05-15 Thread Bill Haskett

George:

In UniData, all SAVEDLISTS items have 000 (or 001, etc) appended to 
the end of it.  Although one can normally do a SAVE.LIST MY.LIST and 
expect that the actual item ID in the SAVEDLISTS file to be MY.LIST000 
this isn't always the case if the list is large.  This makes managing a 
list directly in UD problematic.  :-(


HTH,

Bill


- Original Message -
*From:* ggal...@wyanokegroup.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/15/2013 6:43 AM
*Subject:* Re: [U2] select query..

I'm confused..

If your doing a select with @ID =  you will only get 1 response each time,
@ID is a primary key field. So as suggested just open the file, then do a read 
from
That file with the given @ID.

An alternative to a SAVE.LIST and GET.LIST could be to open SAVEDLISTS as 
file
Then READ and WRITE your dynamic list to that file, and just use a FOR/NEXT 
loop to
Traverse it.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya
Sent: Wednesday, May 15, 2013 5:45 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] select query..

Hi Experts..

I have one issue here with fetching data from the file.

EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\
DISPLAY EXECLINE
EXECUTE EXECLINE RTNLIST LIST1
EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1

LIST.NAME = GET-LIST SOME.LIST
sellist = ''
EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk

Here Im running a loop for a set of KEYVALUEs and for each run the
SSELECT statement is taking around 30 seconds. When I want to run 1000
loops, ideally the run time will be much.

Is there any easier way to do this with less time consumption.

Thanks  Regards,
Sathya V.


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


[U2] Manage $ values

2013-05-07 Thread Bill Haskett

Dale:

Be careful with this if running UniData.  Here are some UDT.OPTIONS 
documentation:


UDT.OPTIONS 56 - U_CONV_BADRETURN
Normally, if an OCONV or ICONV conversion fails due to invalid data or 
an invalid conversion code, UniData returns the input string. In 
BASICTYPE P, if you turn on UDT.OPTIONS 56, UniData returns an empty string.

ON
If this option is on, UniData returns an empty string when an OCONV or 
ICONV conversion fails. Note: For compatibility with most Pick® systems, 
turn this option on.

OFF
If this option is off, UniData returns the original string when an OCONV 
or ICONV conversion fails.


I've been bitten by this in the past.  :-(

Bill


- Original Message -
*From:* dalekel...@dalewkelleyinc.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/7/2013 3:06 PM
*Subject:* Re: [U2] Illegal use of the file, select, cursor, BCI, 
Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.

if var is XXX.XX
ICONV(var,MD2) then OCONV(var,MD0)

Dale


On 05/07/2013 12:04 PM, Sathya wrote:

Hi,.

Thanks everyone for the suggestions and I have sorted out the issue. 
Now I
want to write some dollar values to a file. But the format in which 
it is

in the file is XXX.XX, but I need to write it as X. Without the
decimals the simple numbers.

Can some help me in doing so.

Thanks  Regards,
Sathya V.

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


Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

2013-05-01 Thread Bill Haskett
It has always been my opinion that any TCL verb, function, or whatever 
should be able to process a select list if one is present.  All of the 
utilities I write have this capability, along with help.  :-)


Bill


- Original Message -
*From:* gregor.sc...@pentanasolutions.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 5/1/2013 5:34 PM
*Subject:* Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

That has not been our experience.

The actual workings of the program are not well explained in the UV doco. I did 
find in the UV11 UniOLEDB PDF an explanation of sorts:

* Scans the dictionaries of all nonsystem files named in the VOC, finding all 
associations and unassociated multivalued columns.
* Rewrites the file information cache (.hs_fileinfo) under the account's 
directory, based on the above dictionary information and on the contents of the 
HS_FILE_ACCESS file.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Thursday, 2 May 2013 1:57 AM
To: U2 Users List
Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO?

That would be a nice feature. I do believe that it only processes files with a 
* or *SELECT dictionary item however.


This email and any attachments to it are confidential.
You must not use, disclose or act on the email if you are not the intended
recipient.  Liability limited by a scheme approved under Professional
Standards Legislation.
___
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] UD - Display Current Terminal Type

2013-04-24 Thread Bill Haskett

Thanks, Martin.

This does the same thing !echo %TERM% does, where I noted that my 
SYSTEM(7) variable was Actwy60 while the results of this Windows 
environment variable was wyse60.  When I noticed this my thoughts went 
to why?  :-)


Thanks again,

Bill
Untitled Page



- Original Message -
*From:* mbr...@epicor.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/24/2013 5:57 AM
*Subject:* Re: [U2] UD - Display Current Terminal Type

Not ECL, but UniBasic and should work in UD on either Unix or NT

X=GETENV(TERM)
PRINT X

vt220




-
Epicor Software (UK) is a limited company registered in England  Wales.
Registration Number: 2338274.   Registered Office:  6th Floor, One London Wall, 
London EC2Y 5EB
This e-mail and any attachments to it are confidential and is for the use of 
the intended recipient(s) only. If you have received this e-mail in error, 
please notify the sender immediately and then delete it. If you are not the 
intended recipient, you must not use, disclose or distribute this e-mail 
without the author's prior permission. We have taken precautions to minimize 
the risk of transmitting software viruses, but we advise you to carry out your 
own virus checks on any attachment to this message. We cannot accept liability 
for any loss or damage caused by software viruses. Any views and/or opinions 
expressed in this e-mail are of the author only and do not represent the views 
of Epicor Software (UK) Limited or any other company within its group.
-

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: 24 April 2013 13:23
To: U2 Users List
Subject: Re: [U2] UD - Display Current Terminal Type

Sorry, I thought it was available on both UV and UD.  It is a valid verb on UV:


GET.TERM.TYPE

Wyse Technology 50/60 (W)
Width : 127
Depth : 40

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, April 23, 2013 9:09 PM
To: U2 Users List
Subject: Re: [U2] UD - Display Current Terminal Type

:GET.TERM.TYPE
Not a verb
   GET.TERM.TYPE
:version

  Module Name Version   Licensed

UniData RDBMS 7.3 Yes
Connection Pooling... 7.3 Yes
Device License... 7.3 Yes
NFA.. 7.3 No
RFS.. 7.3 No
EDA.. 7.3 No
733

Bill
Untitled Page



- Original Message -
*From:* tewhitm...@ratex.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/23/2013 5:11 PM
*Subject:* Re: [U2] UD - Display Current Terminal Type

GET.TERM.TYPE will display the terminal type, width and depth.

Tom Whitmore
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, April 23, 2013 5:12 PM
To: U2 Mail List
Subject: [U2] UD - Display Current Terminal Type

I've had a brain-freeze and can't remember how to display the current terminal 
type at ECL.  I know it's SYSTEM(7) but what ECL command do I need to display 
it?

TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).

Any help would be appreciated.

Bill

___
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


Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ==  to report this 
email as spam.


This message has been scanned for malware by Websense. www.websense.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] UD - Display Current Terminal Type

2013-04-23 Thread Bill Haskett
I've had a brain-freeze and can't remember how to display the current 
terminal type at ECL.  I know it's SYSTEM(7) but what ECL command do I 
need to display it?


TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).

Any help would be appreciated.

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


Re: [U2] UD - Display Current Terminal Type

2013-04-23 Thread Bill Haskett

Ahh!

4 Dev (0)- !echo %TERM%
wyse60

4 Dev (0)- BPTEST CRT SYSTEM(7) ; END

Compiling Unibasic: SAVEDLISTS\BpTest_516680981 in mode 'p'.
compilation finished
ACTWY60

I ran the command TERM  ACTWY60 when I logged in.  I wonder why the 
difference?


Thanks,

Bill


- Original Message -
*From:* dda...@harriscomputer.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/23/2013 2:19 PM
*Subject:* Re: [U2] UD - Display Current Terminal Type

!echo $TERM

perhaps.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, April 23, 2013 5:12 PM
To: U2 Mail List
Subject: [U2] UD - Display Current Terminal Type

I've had a brain-freeze and can't remember how to display the current terminal 
type at ECL.  I know it's SYSTEM(7) but what ECL command do I need to display 
it?

TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).

Any help would be appreciated.

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



Dave Davis
Team Lead, RD

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]http://www.harriscomputer.com/
 6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://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


Re: [U2] UD - Display Current Terminal Type

2013-04-23 Thread Bill Haskett
Well, that doesn't work, which I tried originally as this is what other 
mvDbms products use (at least what I'm used to).  UniData doesn't 
respond with the terminal type.


4 Dev (0)- TERM
TERM parameters are all numeric:
TERM A,B,C,D
For the terminal
A=number of characters in a line(132).
B=number of lines per page(42).
For the line printer
C=number of characters in a line(146).
D=number of lines per page(61).
4 Dev (0)-

Bill
Untitled Page



- Original Message -
*From:* bob_woodw...@k2sports.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/23/2013 2:48 PM
*Subject:* Re: [U2] UD - Display Current Terminal Type

In Unidata 6.1, TERM with no arguments gives me a brief syntax help
message.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, April 23, 2013 2:42 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UD - Display Current Terminal Type

TERM with no arguments will *display* your current settings, at the
bottom of the display it will say 'wyse50'



  

  

  


-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Mail List U2-users@listserver.u2ug.org
Sent: Tue, Apr 23, 2013 2:11 pm
Subject: [U2] UD - Display Current Terminal Type


I've had a brain-freeze and can't remember how to display the current
terminal type at ECL.  I know it's SYSTEM(7) but what ECL command do I
need to display it?

TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).

Any help would be appreciated.

Bill
___
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] Unidata RESIZE CONCURRENT

2013-04-23 Thread Bill Haskett

Jeff:

Since the documentation says: RESTORE - If the system crashes or RESIZE 
CONCURRENT encounters an error, delete the temporary copy of the resized 
file and restore the original file before any resize operation took 
place. I'd guess the RESTORE keyword is putting something somewhere 
where you don't have permissions.


Further documentation says:
- - - - - - - - - -
Recovering from a Concurrent Resize Error
If the concurrent resizing process encounters an error, or the system 
crashes during the resize operation, complete the following steps to 
restore the file:-

Resizes the file according to its actual size, thus correcting overflows.

1.  Check and repair the physical integrity of the file, if necessary. 
For nonrecoverable files, use the guide utility to check if the file 
needs to be repaired. If so, use the fixfile command to repair the file.
If the file is a recoverable file, restarting UniData after the system 
crash should automatically fix both the original file and the temporary 
copy of the file as it was being resized.
2.  Execute the RESIZE CONCURRENT CONTINUE command against the file if 
you want the resize operation to continue to completion. Execute the 
RESIZE CONCURRENT RESTORE command against the file if you want to delete 
the temporary copy of the file and restore the original file before any 
resize operation took place. If you do not execute either of these 
options, the RESIZE CONCURRENT operation will fail and display an error 
message describing the reason for the failure.


At this release, the guide utility has been enhanced to display a 
message indicating that the file is currently being resized. The message 
includes the number of groups that have been resized:

- - - - - - - - - -

I wonder what, and where, that is?

Bill
Untitled Page



- Original Message -
*From:* jbut...@hampshire.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/23/2013 3:35 PM
*Subject:* Re: [U2] Unidata RESIZE CONCURRENT

On 04/22/2013 09:49 PM, Jeffrey Butera wrote:
I'm attempting some experiments with RESIZE CONCURRENT on Unidata 
7.3.3 (RedHat) but failing miserably.
I didn't think there was any configuration I needed to enable before 
using CONCURRENT, perhaps I'm misunderstanding the error message:


:RESIZE  H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE
H08.FACULTY.WL.SNAP is a synonym, real name is 
H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.
Resize Concurrent Continue/Restore failed because the 
RESIZE_CONCURRENT bit was not set on the file.


I determined that the problem is RESTORE.  If we eliminate that 
keyword, RESIZE CONCURRENT works.


:RESIZE  H08.FACULTY.WL.SNAP 3593,8 CONCURRENT
H08.FACULTY.WL.SNAP is a synonym, real name is 
H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.
The temporary file for RESIZE is 
H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.resize.

H08.FACULTY.WL.SNAP RESIZED from 3359 to 3593

I'm not yet sure of implications of not using RESTORE or CONTINUE, but 
I'm ok for now.




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


Re: [U2] UD - Display Current Terminal Type

2013-04-23 Thread Bill Haskett

Thanks, but that's not it for UniData.

Bill
Untitled Page



- Original Message -
*From:* antli...@youngman.org.uk
*To:* u2-users@listserver.u2ug.org
*Date:* 4/23/2013 3:48 PM
*Subject:* Re: [U2] UD - Display Current Terminal Type

On 23/04/13 22:12, Bill Haskett wrote:

I've had a brain-freeze and can't remember how to display the current
terminal type at ECL.  I know it's SYSTEM(7) but what ECL command do I
need to display it?

TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).


Dunno whether it works for UD, but the UV command is GET.TERM.TYPE.

Cheers,
Wol


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


Re: [U2] UD - Display Current Terminal Type

2013-04-23 Thread Bill Haskett

:GET.TERM.TYPE
Not a verb
 GET.TERM.TYPE
:version

Module Name Version   Licensed

UniData RDBMS 7.3 Yes
Connection Pooling... 7.3 Yes
Device License... 7.3 Yes
NFA.. 7.3 No
RFS.. 7.3 No
EDA.. 7.3 No
733

Bill
Untitled Page



- Original Message -
*From:* tewhitm...@ratex.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 4/23/2013 5:11 PM
*Subject:* Re: [U2] UD - Display Current Terminal Type

GET.TERM.TYPE will display the terminal type, width and depth.

Tom Whitmore
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Tuesday, April 23, 2013 5:12 PM
To: U2 Mail List
Subject: [U2] UD - Display Current Terminal Type

I've had a brain-freeze and can't remember how to display the current terminal 
type at ECL.  I know it's SYSTEM(7) but what ECL command do I need to display 
it?

TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).

Any help would be appreciated.

Bill


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


Re: [U2] Refactoring Tools

2013-04-22 Thread Bill Haskett

Brian:

Prayer may come in handy.  :-)

Bill
Untitled Page



- Original Message -
*From:* br...@brianleach.co.uk
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 4/22/2013 12:12 PM
*Subject:* Re: [U2] Refactoring Tools

Jeff -

Exactly :)

I mean refactoring as in restructuring old code to make it more testable and
consistent. You find these tools for .NET, java and other languages though
there the model is different because of the OO nature. Universe code doesn't
decompose down the same way but I was just wondering whether anyone had
built some assisting tools before I have to start designing and building
some.

Example, an slice through a program that mixes UI and business logic to rip
out the useful guts into external subroutines for unit testing whilst
preserving the overall logic safely. Which means the tool needs at least a
rudimentary understanding of code syntax and scope rather than just
stripping lines out. (e.g. this block sets a local variable as a by-product,
that also just happens to be used 5,000 lines later on in a GoSub so it
needs to be surfaced if the block is externalized - that kind of stuff that
could easily get lost).

I've written plenty of code analysis software but not specifically for this.

Regards

Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: 22 April 2013 19:49
To: U2 Users List
Subject: Re: [U2] Refactoring Tools

*https://en.wikipedia.org/wiki/Code_refactoring

Code refactoring is a disciplined technique for restructuring an existing
body of code, altering its internal structure without changing its external
behavior,[1] undertaken in order to improve some of the nonfunctional
attributes of the software. Advantages include improved code readability and
reduced complexity to improve the maintainability of the source code, as
well as a more expressive internal architecture or object model to improve
extensibility.

My translation:
Remove the spaghetti without changing functionality.


*Wjhonson wrote:

Perhaps by refactoring you mean just to make the code more consistent.

Yes and no.  Decompiling the object code, will enforce consistency,

however at the expense of readability.
  

  

  


-Original Message-
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Sun, Apr 21, 2013 5:26 am
Subject: [U2] Refactoring Tools


Hi All

  


I'm doing some intensive work with a large UniVerse site to assist
them in migrating their 20 year old code base and working practices to
full Agile, XP and TDD. They are really enthusiastic in embracing the
modern world and making good progress, but there is a huge amount of
legacy code to be cleaned up and test harnessed.

  


So before I spend time possibly reinventing the wheel, does anyone
know of any good refactoring tools for UniVerse Basic?

  


Brian

  


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

  
___

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

   

--

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


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


Re: [U2] WRITESEQ Error

2013-04-12 Thread Bill Haskett
Beware of Windows Updates!  They've cause me all kinds of trouble.  So 
much so that I now have to review the updates by hand to see what 
they're trying to slip in!  :-o


Bill


- Original Message -
*From:* adew...@stylmark.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 4/12/2013 7:59 AM
*Subject:* Re: [U2] WRITESEQ Error

We found the cause to this problem and I thought I'd share it with you.

The file we append sits on a virtual PC.  The VOC pointer is 
\\file-server\share-name\folder-name

This PC is configured for automatic windows updates and automatically restarts. 
 We had Patch Tuesday.  The PC restarted fine and automatically started the 
application, however, the share-name stopped working.

When the IT person tried to restart it he didn't do it correctly.  Now that we 
have correctly recreated share-name all is well.

Thanks for all your help.

Al DeWitt



-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob
Sent: Thursday, April 11, 2013 6:34 PM
To: U2 Users List
Subject: Re: [U2] WRITESEQ Error

I quite often found that the file had either not been sequentially opened, or 
it had
been closed before the writeseq command.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt
Sent: Thursday, April 11, 2013 3:56 PM
To: 'U2 Users List'
Subject: Re: [U2] WRITESEQ Error

I initially thought it was a permissions issue as well, however, I am a domain
admin and I get the same error.  If it is a permissions error than something has
changed that I am not aware of.

Al DeWitt


-Original Message-
From: Wjhonson [mailto:wjhon...@aol.com]
Sent: Thursday, April 11, 2013 5:53 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] WRITESEQ Error

Here 9 points to a permissions issue

http://u2-universe-unidata.1073795.n5.nabble.com/Unidata-6-1-AIX-quot-
write- error-errno-9-quot-on-WRITESEQ-td6781.html









-Original Message-
From: Kevin King ke...@precisonline.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, Apr 11, 2013 3:44 pm
Subject: Re: [U2] WRITESEQ Error


Al brings up a good point though... Where would one find what error 9
means exactly?  I scanned the documentation and didn't see any mention
of an error 9 for WRITESEQ or even described in STATUS() which is
where a lot of the IO errors show up.


On Thu, Apr 11, 2013 at 3:45 PM, Wjhonson wjhon...@aol.com wrote:


You're first test is always permissions.
Permissions, permissions, I hate them.








-Original Message-
From: Al DeWitt adew...@stylmark.com
To: (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org
Sent: Thu, Apr 11, 2013 2:10 pm
Subject: [U2] WRITESEQ Error


I have a program that has been working fine until today.  The users
are now experiencing an error at the following statement #:

508: WRITESEQ RECRD APPEND ON FILEIN ELSE
... at line 508 write error, errno = 9

Can someone tell me what errno 9 is and what my cause it?The

file

resides on
a virtual XP machine that runs a third-party app that reads this

file.

Thanks.

Albert DeWitt, CPIM
___
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

___
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] Social Networks for MV

2013-04-02 Thread Bill Haskett

Symeon:

That isn't mostly true if you're a small business.  Many times a small 
business's marketing focus has been on stationary, business cards, 
membership with the local chamber of commerce or rotary club, church 
membership, and sometimes a targeted trade show or advertisement in a 
particular trade publication.  This is far different than what you 
observe for much larger businesses looking at much broader-based markets.


I can't tell you how many of my small business friends have overpaid and 
been unhappy with SEO firms, marketing lists, marketing firms, and the 
plethora of business pustules who promise much and produce little.  I'm 
sure we've all been there, and done that!  In a small business, there 
isn't such a redundancy of resources that these decisions don't matter.


Just a thought, or two.  :-)

Bill
Untitled Page


- - -
*/Fav Icon Advantos Systems, Inc./*
☎ Tel: 760-944-5570 x7002  | ☏ Fax: 760-655-1583
The Property Management Advantage.

- Original Message -
*From:* syme...@gmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 4/2/2013 1:30 AM
*Subject:* Re: [U2] Social Networks for MV

Marketing has always been about multiple ways to do predominantly the same
thing  you have a newspaper campaign, poster campaign, radio, tv, cpc ads,
web banners, cold calling etc,  these are just some more.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: 28 March 2013 21:55
To: U2 Users List
Subject: Re: [U2] Social Networks for MV

The biggest issue I have this all of this social media craze (emperor's new
clothes) is the time it takes to manage multiple ways to do predominately
the same thing. Although with enough resources, these marketing avenues are
manageable, for small businesses, there aren't enough resources in house.
In addition, to outsource requires tremendous luck in the selection process.

Secondly, the level of self-absorption in these social media outlets is
so monumental, what can I say?   It's like talking with someone who
spends the entire time preening themselves in from me.

Just a thought, or two... :-)

Bill
Untitled Page



- Original Message -
*From:* robert.hou...@fwic.net
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/28/2013 2:14 PM
*Subject:* Re: [U2] Social Networks for MV

Here's another article about social media.  While it addresses more

consumer facing data, you can easily see how some B2B companies can take
advantage of the same concepts:

http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-har
d-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egd
e_43707_member_222896835


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony
Gravagno
Sent: March-19-13 2:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Social Networks for MV


From: Robert Houben
And just to mess with your heads a bit more...
http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html

Oh dear, you seem to have provoked yet another blog. :)
http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html

Summary: It's not just the individual services. Each of us has different

roles in life. Pinterest might not appeal to us as MV people but it might
appeal to the companies we support who wish to use it for marketing. And
while you might not want to tweet about your MV epiphanies, in the broad
landscape of social media there are many APIs (web services) for extracting
data into your MV system, and publishing data from your MV system. As
professionals and business people, ignoring this can be a strategic mistake.

Thanks for the ongoing inspiration.
T


___
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] Compressing PDFs

2013-03-28 Thread Bill Haskett
The main reason I like WinRAR is because is offers compression in 
command-line mode.  This is very handy for me in the U2 environment, 
along with for Windows backups, etc.  In addition, I can use its UI to 
create .zip files that are useful on Windows client machines.


Bill
Untitled Page



- Original Message -
*From:* 3xk547...@sneakemail.com
*To:* u2-users@listserver.u2ug.org
*Date:* 3/28/2013 8:58 AM
*Subject:* Re: [U2] Compressing PDFs

In addition to 7-Zip (the software, not just the compression
algorithm), consider WinRAR. They're both based on the same UnRAR
decompression. They both support multiple platforms, multiple
compression methods, multiple volumes, security, etc.  I hope I don't
start a war by suggesting that anyone spend money for software or
anything, but WinRAR is shareware for $30 and has Windows extensions
for a UI that make it worth it to some people. You don't need to pay
for it, and I'd guess most people do not, but it's a good thing to do,
especially for a company. There is a tiny nag on file opens which is
easy to dismiss. I've been using WinRAR for almost a decade and swear
by it for all compression needs. For some people the choice is just a
matter of personal preference where most other comparisons are
similar. You'll see arguments out there about 128bit AES vs 256, or
how many CPU cores are utilized, or whether you get 80% compression vs
85%. At some point it just comes down to feel.

I'd recommend that you do not provide your trading partners with
software, but tell them the compression mechanism you use and why, and
then point them to a couple websites from which they can make their
own choices. Otherwise you could get stuck providing support because
YOU told them to use brandX.

As to your local storage, consider delivering files to your trading
partners in a format that's easy for Them to manipulate, but
re-compress/store files in a way that's easy for You to manipulate.
The content is ultimately the same and file transport/unpacking issues
are rare and easy to remedy.

HTH
T



From: Israel, John R.
There are several issues here that I am dealing with for this

project.

#1 The company that we are sending the PDFs to is Windows based, so
I am limited as to the formats they can accept (zip and 7z being two

of

them).

#2 In my testing, I have found that 7z gives significantly more
compression.  In my test, I took a single PDF that was 17k in size.

I

made 3 copies of it for a total of 17 x 4 = 68k.  Using a

traditional zip, I

was able to compact these 4 PDFs down into a 33k file (about half).
HOWEVER, after compressing it down with 7z, those same 4 PDFs went
down to only 8K!  That is a SIGNIFICANT difference.

#3 I wrote a program we all use that archives the intended file,

then

transmits the archive to the 2nd party.  That way, if they did not

get it, I

can re-send it from the archive w/o having to try to re-create the

data

(which may have changed).  Also, if there are any issues, I can look

at

the archive file and determine exactly what they got and then
determine if the problem was mine or theirs.
From: Israel, John R.

HPUX, UniData  SB:

After a bunch of work, I have a UNIX directory that has a bunch of
PDFs.

I wish to bundle these PDFs up into a 7zip formatted compressed

file.  I

see that there is a ported version of the Windows version of 7zip

for

UNIX called p7zip.

Has anyone installed p7zip and if so, what else needed to be

installed

with it?  Is it stand-alone or is it dependent on other software

packages

being loaded first?

OR

Does anyone have a simple way for UNIX to run the Windows
command line version of 7zip against my UNIX PDF directory?

___
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] Social Networks for MV

2013-03-28 Thread Bill Haskett
The biggest issue I have this all of this social media craze (emperor's 
new clothes) is the time it takes to manage multiple ways to do 
predominately the same thing. Although with enough resources, these 
marketing avenues are manageable, for small businesses, there aren't 
enough resources in house.  In addition, to outsource requires 
tremendous luck in the selection process.


Secondly, the level of self-absorption in these social media outlets is 
so monumental, what can I say?   It's like talking with someone who 
spends the entire time preening themselves in from me.


Just a thought, or two... :-)

Bill
Untitled Page



- Original Message -
*From:* robert.hou...@fwic.net
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/28/2013 2:14 PM
*Subject:* Re: [U2] Social Networks for MV

Here's another article about social media.  While it addresses more consumer 
facing data, you can easily see how some B2B companies can take advantage of 
the same concepts:
http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-hard-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egde_43707_member_222896835


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: March-19-13 2:40 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Social Networks for MV


From: Robert Houben
And just to mess with your heads a bit more...
http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html

Oh dear, you seem to have provoked yet another blog. :) 
http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html

Summary: It's not just the individual services. Each of us has different roles 
in life. Pinterest might not appeal to us as MV people but it might appeal to 
the companies we support who wish to use it for marketing. And while you might 
not want to tweet about your MV epiphanies, in the broad landscape of social 
media there are many APIs (web services) for extracting data into your MV 
system, and publishing data from your MV system. As professionals and business 
people, ignoring this can be a strategic mistake.

Thanks for the ongoing inspiration.
T


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


Re: [U2] REDBACK Fatal UniBasic errors

2013-03-25 Thread Bill Haskett

David:

Sorry I can't help you on the Redback issue, but you'd be surprised what 
shows up in the UO logs.  Also, do you have a UOLOGIN subroutine?  In 
UD this subroutine always runs when a connection is made through UO.  
I've been known to cause myself trouble there.


Bill
Untitled Page



- Original Message -
*From:* dgr...@dagconsulting.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 3/25/2013 10:11 AM
*Subject:* Re: [U2] REDBACK Fatal UniBasic errors

Bill, thanks for the post, I will check this location for debugging purposes.  
But it doesn't help my issue of having Redback send back an error message that 
makes more sense when the UniBasic program aborts.

David A. Green
(480) 813-1725
DAG Consulting

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Friday, March 22, 2013 3:56 PM
To: U2 Users List
Subject: Re: [U2] REDBACK Fatal UniBasic errors

David:

Have you turned on UniObjects error logging?  If not, create the following item 
in the UDTHOME directory:

serverdebug
001 udcs 10 E:\U2\ud\log\udcs\udcs.log

My UDTHOME is located at E:\U2\ud so your path should replace mine from above.  Also, I've 
created a udcs subdirectory under the UDTHOME log subdirectory.  You can actually 
just name (and place) this log file whatever and wherever you like.  After each UO connection there's a bunch 
of stuff in it that most often helps me.

HTH,

Bill

Untitled Page


- - -
*/Fav Icon Advantos Systems, Inc./*
☎ Tel: 760-944-5570 x7002  | ☏ Fax: 760-655-1583 The Property Management 
Advantage.

- Original Message -
*From:* dgr...@dagconsulting.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 3/22/2013 1:43 PM
*Subject:* [U2] REDBACK Fatal UniBasic errors

I'm accessing UniData via .NET and Redback.  But if there is a fatal
UniBasic error, like trying to access an unopened file, I get the following:

dagLink.DOAdoExecute - ADO Record Set Execute - Connection to
Application Server lost Responder Error: (errno=32 The process cannot
access the file because it is being used by another process.)
Responder Error: (errno=32 The process cannot access the file because
it is being used by another process.) Responder Error:
 Server Err: 
SpGetLen error, rc=-109

 Output Log: 
none.

 Error Log: 
none.
*

It then goes on to tell me that we have a Responder Error.

The rgw.log has this:
102340,RESP,spdr.c,1219,SpGetLen error, rc=-109  (ErrorCode=109 The
pipe has been ended.)
102340,RESP,ntbackend.c,720,Resp1 killing pid=122680
102340,RESP,ntbackend.c,701,WriteFile  (ErrorCode=232 The pipe is
being
closed.)
102340,RESP,ntbackend.c,769,Sent 0 stop failed.  (ErrorCode=232 The
pipe is being closed.) 102340,RESP,ntbackend.c,626,try
SafeTerminateProcess  (ErrorCode=232 The pipe is being closed.)
102340,RESP,ntbackend.c,630,Did not respond to SafeTerminateProcess:
try TerminateProcess (gag)  (ErrorCode=232 The pipe is being closed.)
102340,RESP,ntbackend.c,633,TerminateProcess  (ErrorCode=5 Access is
denied.)
102340,RESP,ntbackend.c,790,Resp1 kill of pid=0 complete, rc=1.
102340,SCHD,ntresp.c,368,2.child slot=6 thandle=-1
102340,SCHD,ntresp.c,370,child died aidx=3
102340,RESP,respcmn.c,428,Responder terminating now.

Is there a way to capture a better error message?

David A. Green
(480) 813-1725
DAG Consulting

___
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] Cataloged programs // finding

2013-03-25 Thread Bill Haskett
In UniData, there's a CTLGTB file (not directory) with dictionary items 
and a catalog item with a format like:


4 Dev (0)- AE CTLGTB *

606 record(s) selected.

 1  Top of MVNET.DICTWRITE in CTLGTB, 4 lines, 47 characters.
*--: p
001: S
002: 3
003: E:\MVNET\MVNET.BP MVNET.DICTWRITE
004: admin
Bottom.

...and the dictionaries look like:

Dictionary of File: CTLGTB 14:01:27 Mar 25 2013
Dict Name.. Typ # Col-Heading Field-Definition 
Conversion.. Formt Assoc...


@ID D 0   CATALOG 
NAME  28L   S

TYPED 1 1LS
ARG D 2 #ofArguments 3RS
ORIGD 3 ORIGINATOR 22L   S
WHO D 4 7LS
5 records listed

...and output looks like:

2 Dev (0)- SSCROLL CTLGTB BY ORIG ID-SUPP @ID FMT 35L TYPE ARG ORIG 
FMT 72L WHO FMT 12L
Command = SORT CTLGTB  
14:03:31 Mar 25 2013
CATALOG NAME. T ARG 
ORIGINATOR.. WHO.
US_EXECUTOR   S   5 @UDTHOME/SYS_BP 
US_EXECUTOR  root
help  M   0 @UDTHOME/SYS_BP 
help root
U2.MASTER.TRIGGER.D   S   4 E:\AboE\Abo\BP\BP U2.MASTER.TRIGGER.D  
  admin
U2.MASTER.TRIGGER.U   S   5 E:\AboE\Abo\BP\BP 
U2.MASTER.TRIGGER.Uadmin
UOLOGIN   S   2 E:\AboE\Abo\BP\BP 
UOLOGINadmin
BAWEBEXEC S   2 E:\DESIGNBAIS\BA\DBI\DBI 
BAWEBEXEC   admin
DB.G.EOP.DATA S   0 E:\DESIGNBAIS\BA\DBI\DBI 
DB.G.EOP.DATA   admin


HTH,

Bill
Untitled Page



- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org, sjos...@sjplus.com
*Date:* 3/25/2013 1:28 PM
*Subject:* Re: [U2] Cataloged programs // finding

To be more clear.  The path of the source code, is embedded at the tail of the 
opcode in the GLOBAL.CATDIR item for that catalogued routine name.  If you can 
retrieve that path you can then parse it and compare it to what you know or 
think you know about where your code is stored from the *PICK* point-of-view 
(since the path will be fully specified, not Pick type).

However

If you simply try to READ the opcode that is the GLOBAL.CATDIR item, you have to be aware, that it 
CAN include  CHAR(255) in that opcode.  CHAR(255) to a STRING type variable means End Of 
String so seeing that in your STRING, will pre-maturely *truncate* the string on that 
character, making you think you've end the END of that variable.

So you will never get the *full* opcode and thus probably never see the path 
you want, if you just happen to have a byte which is the CHAR(255) otherwise 
known as HEX FF.

Hope that's more clear.  In order to *around* this problem you can use the 
READBLK command instead of the READ command, and READBLK *one* *byte* *at* *a* 
*time*.

Using the READBLK it will *not* attempt to interpret the FF as an end-of-string 
condition, so you can test for it, and skip over it and know as well that you 
still have *more* to read.  That's not all there is.



  

  

  


-Original Message-
From: Wjhonson wjhon...@aol.com
To: SJoslyn sjos...@sjplus.com; u2-users u2-users@listserver.u2ug.org
Sent: Mon, Mar 25, 2013 11:41 am
Subject: Re: [U2] Cataloged programs // finding


I have this built into my VIEW routine which allows inter-call jumping
but I don't have it as a sep program
Just be aware that you *have* to read the opcode in BLOCK form (READBLK) because
it *can* have embedded char 255's which will truncate any string read.  Nice
huh?

So you have to step the code, byte by frickin byte :)


  

  

  


-Original Message-
From: Susan Joslyn sjos...@sjplus.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Mar 25, 2013 11:10 am
Subject: [U2] Cataloged programs // finding


Hi Geniuses.
At a few of my customer sites I've seen people have these little hand-built
utilities that help them identify the file/location of the source of a
globally cataloged item.
I could really use a handy little device like that - on both platforms,
Universe and Unidata.  Does anyone - ideally - have one of those they'd like
to share for either platform?  Or, at least know how to quickly put that
together.  I confess, I don't want to go do the research into this if I can
just smile pretty and borrow it?  But I'll go read up if that's what I need
to do.

TIA,
Susan

___
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

Re: [U2] REDBACK Fatal UniBasic errors

2013-03-22 Thread Bill Haskett

David:

Have you turned on UniObjects error logging?  If not, create the 
following item in the UDTHOME directory:


serverdebug
001 udcs 10 E:\U2\ud\log\udcs\udcs.log

My UDTHOME is located at E:\U2\ud so your path should replace mine 
from above.  Also, I've created a udcs subdirectory under the UDTHOME 
log subdirectory.  You can actually just name (and place) this log 
file whatever and wherever you like.  After each UO connection there's a 
bunch of stuff in it that most often helps me.


HTH,

Bill

Untitled Page


- - -
*/Fav Icon Advantos Systems, Inc./*
☎ Tel: 760-944-5570 x7002  | ☏ Fax: 760-655-1583
The Property Management Advantage.

- Original Message -
*From:* dgr...@dagconsulting.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 3/22/2013 1:43 PM
*Subject:* [U2] REDBACK Fatal UniBasic errors

I'm accessing UniData via .NET and Redback.  But if there is a fatal
UniBasic error, like trying to access an unopened file, I get the following:

dagLink.DOAdoExecute - ADO Record Set Execute - Connection to Application
Server lost
Responder Error: (errno=32 The process cannot access the file because it is
being used by another process.)
Responder Error: (errno=32 The process cannot access the file because it is
being used by another process.)
Responder Error:
 Server Err: 
SpGetLen error, rc=-109

 Output Log: 
none.

 Error Log: 
none.
*

It then goes on to tell me that we have a Responder Error.

The rgw.log has this:
102340,RESP,spdr.c,1219,SpGetLen error, rc=-109  (ErrorCode=109 The pipe has
been ended.)
102340,RESP,ntbackend.c,720,Resp1 killing pid=122680
102340,RESP,ntbackend.c,701,WriteFile  (ErrorCode=232 The pipe is being
closed.)
102340,RESP,ntbackend.c,769,Sent 0 stop failed.  (ErrorCode=232 The pipe is
being closed.)
102340,RESP,ntbackend.c,626,try SafeTerminateProcess  (ErrorCode=232 The
pipe is being closed.)
102340,RESP,ntbackend.c,630,Did not respond to SafeTerminateProcess: try
TerminateProcess (gag)  (ErrorCode=232 The pipe is being closed.)
102340,RESP,ntbackend.c,633,TerminateProcess  (ErrorCode=5 Access is
denied.)
102340,RESP,ntbackend.c,790,Resp1 kill of pid=0 complete, rc=1.
102340,SCHD,ntresp.c,368,2.child slot=6 thandle=-1
102340,SCHD,ntresp.c,370,child died aidx=3
102340,RESP,respcmn.c,428,Responder terminating now.

Is there a way to capture a better error message?

David A. Green
(480) 813-1725
DAG Consulting

___
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] unidata env var

2013-03-21 Thread Bill Haskett

Jeffrey:

I had to set it to 2500 in Windows, otherwise I had problems.

HTH,

Bill


- Original Message -
*From:* jbut...@hampshire.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/21/2013 3:51 AM
*Subject:* [U2] unidata env var
We've had some issues with i-desc failing over years and the solution 
was to set the evironment variable VFIELDSIZE to some amount (6000 or 
more).


My real question is does unidata care about case for this variable (on 
*nix, not windoze)?  I've seen it documented both as VFIELDSIZE and 
vfieldsize and not sure unidata sees one or both of these.




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


Re: [U2] *** GMX Spamverdacht *** Re: I Descriptor no longer working in UniSQL after UD upgrade

2013-03-05 Thread Bill Haskett

Mecki:

You need to when using the other stuff with UniData (non-telnet 
connectivity).  ECL doesn't always represent what happens through a UO 
connection.


:COMPILE.DICT  MYFILE

...should do the trick.

HTH,

Bill
Untitled Page



- Original Message -
*From:* mec...@gmx.net
*To:* u2-users@listserver.u2ug.org
*Date:* 3/5/2013 9:10 AM
*Subject:* Re: [U2] *** GMX Spamverdacht *** Re: I Descriptor no longer 
working in UniSQL after UD upgrade

I don't know about compiling I-descriptors in UD.
Never done it and never needed to.
The dict is marked as MV and has an association as well.
It works just fine from ECL so when I type LIST PODET WITH PO_NBR = 
98587  SCHED_DEL_DATE U_RPT_DATE I get 2 dates in both columns as 
expected.
But when I go to sql and try SELECT SCHED_DEL_DATE,U_RPT_DATE from 
PODET_SCHED_DETAIL1 where PO_NBR = '98587' I get 2 scheduled dates but 
only one report date (current date) in the first row while in the 
second row it is null.
I found a work-around by using an Active-X control in my DTS package, 
but I shouldn't have to do that.
I also noticed that I-descriptors calling a Basic subroutine don't 
work any more through ODBC or OLE-DB even though they work in UniSQL.

Maybe in 7.2 I have to convert them into V-types?
I prefer I-types since I just don't seem to be able to get to grips 
with the V-type syntax.




On 05/03/2013 13:52, David A. Green wrote:

Have your compiled your i-descriptor?  Is it marked as MV?

David A. Green
(480) 813-1725
DAG Consulting

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

Sent: Tuesday, March 05, 2013 5:42 AM
To: U2 Users List
Subject: [U2] I Descriptor no longer working in UniSQL after UD upgrade

Hi

we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it
looked fine so far.
Now I had a call that there are purchase orders missing on a Cognos 
report.
When I investigated I noticed that from the day of the upgrade I have 
rows

in the table used for that report with missing dates.

The report is based on a SQL Server 2000 table that gets updated 
every night

with Purchasing information from UD using DTS.
We want to track supplier performance so I take a snapshot of the
outstanding Purchase order deliveries every night and add them to this
table.
Each row also contains the date the snapshot was done.
Some order line have multiple deliveries so I created a I-type 
dictionary

item using REUSE(@DATE).
This is mapped in the schema and was working just fine under 5.2 but now
there is only a date for the first multivalue.

I created a new subtable using the 7.2 VSG and the result is the same.
The dictionary works just fine from ECL but in SQL only the first row 
has a

date and all others are null.

Any idea why this doesn't work anymore under UD 7.2?

___
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] New Rocket Toolkit for .NET

2013-02-28 Thread Bill Haskett

Dan:

I have to say...  I have a pretty good idea of how mv.NET works, how it 
connects, what tools are included, and what kind of costs I can expect.  
I have no idea what the U2 toolkit includes, or its costs, and could 
never get past the marketing, which knows nothing about implementation 
and costs.  :-)


Bill
Untitled Page



- Original Message -
*From:* dmcgr...@rocketsoftware.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/28/2013 7:15 AM
*Subject:* Re: [U2] New Rocket Toolkit for .NET

It is not based on MV.NET at all.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker
Sent: Wednesday, February 27, 2013 2:17 PM
To: U2 Users List
Subject: Re: [U2] New Rocket Toolkit for .NET

Is this toolkit based on the MV.NET code that was licensed/purchased quite some 
time ago or is it something different?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, 28 February 2013 10:05 a.m.
To: U2 Users List
Subject: Re: [U2] New Rocket Toolkit for .NET

Hey Will,

The U2 Toolkit for .NET (U2NETDK) can be thought of as 2 pieces:

U2NETDK Provider - this is the API that provides access to U2 from .NET, 
superceding both ADO.NET and UO.NET. It is complete free and can be downloaded 
from our website: http://u2.rocketsoftware.com/resources/downloads

U2NETDK Developer - this gives you Visual Studio Add-ins for U2 which makes 
development a lot easier. This is chargable on a per machine basis.

Both are provided in the same package, the Developer portion will require an 
authorization key to use, other Provider will work exactly the same as you are 
used to with the older UO.NET.

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, February 27, 2013 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] New Rocket Toolkit for .NET

Does this new toolkit cost something?
We already use .NET with Universe, but we'd be interested in getting this if 
it's an upgrade or something to what we have.

Or is it something that *comes with* a Universe install so we should just ask 
for our free disk?

Will Johnson

___
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 full screen editor

2013-02-26 Thread Bill Haskett

Symeon:

Well, there you go!  Over here, we often figure if it's cheaper we'll 
make it work.  :-)

Untitled Page



- Original Message -
*From:* syme...@gmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 2/26/2013 12:38 AM
*Subject:* Re: [U2] UV full screen editor

I seem to remember when we used such things that the costs in the uk where
pretty similar. Wintegrate also did some emulations that accuterm did not
and we needed those, but the other problem I have with Accuterm is that it
is very American (not being rude here)  so it has some funny (to us
Europeans) way of doing things, and always looks very old fashioned.   Each
to their own I guess






-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: 25 February 2013 20:14
To: U2 Users List
Subject: Re: [U2] UV full screen editor

Symeon:

That may be true these days, but wIntegrate has always been significantly
more expensive than AccuTerm, and AccuTerm always worked better with Linux
and SSH (rather than using SSL like wIntegrate does/did).  Also, AccuTerm's
licensing was significantly easier to manage (we still have clients
struggling with the old site-licensing of wIntegrate).

Nowadays, however, we use UniObjects to connect to our servers and run our
application.  Even now, I still use AccuTerm mostly, and VS2010 (which I
mostly dislike - but that's just the environment).  I've tried xLr8, BST,
Brian's but there's always something that just trips me up each and every
day with these packages.  Every time I get one of these set up and running,
something changes or something I do on a common basis is just very difficult
to accomplish.  :-(

Bill
Untitled Page



- Original Message -
*From:* syme...@gmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 2/25/2013 10:56 AM
*Subject:* Re: [U2] UV full screen editor

Also If you want an editor integrated into your terminal emulator I
have always found wintegrate to be the best solution out there.

___
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 full screen editor

2013-02-25 Thread Bill Haskett
Probably the simplest, and easiest to use, would be AccuTerm 
http://www.asent.com.  It is a terminal emulator, probably the best in 
the MV market, that includes an editor.  You can call the editor while 
within the UV environment (that is, logged into an account) straight 
from the command line. So, instead of...


:ED SOMEFILE ItemId

...you would change the ED verb with WED, like...

:WED SOMEFILE ItemId

This solution is probably best if you spend most of your time inside the 
UV environment and aren't interested in installing software other than a 
telnet client.  In addition, it is probably the cheapest of all telnet 
clients you can use, assuming you place any value on your time.  :-)


HTH,

Bill


- Original Message -
*From:* nirvanwijesek...@hotmail.com
*To:* u2-users@listserver.u2ug.org
*Date:* 2/25/2013 6:04 AM
*Subject:* [U2] UV full screen editor

Hello all,
  
I'm new to this forum, so apologies if this topic has been brought up before. Can anyone recommend a decent full-screen editor for Universe? I require it for editing source code as well as modifying data files. Seems like most of them can do one or the other, but not both. We do not run System Builder, so is there anything else available? We are trying to move away from the native UV line editor.
  
Many thanks. 		 	   		

___
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 full screen editor

2013-02-25 Thread Bill Haskett

Symeon:

That may be true these days, but wIntegrate has always been 
significantly more expensive than AccuTerm, and AccuTerm always worked 
better with Linux and SSH (rather than using SSL like wIntegrate 
does/did).  Also, AccuTerm's licensing was significantly easier to 
manage (we still have clients struggling with the old site-licensing of 
wIntegrate).


Nowadays, however, we use UniObjects to connect to our servers and run 
our application.  Even now, I still use AccuTerm mostly, and VS2010 
(which I mostly dislike - but that's just the environment).  I've tried 
xLr8, BST, Brian's but there's always something that just trips me up 
each and every day with these packages.  Every time I get one of these 
set up and running, something changes or something I do on a common 
basis is just very difficult to accomplish.  :-(


Bill
Untitled Page



- Original Message -
*From:* syme...@gmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 2/25/2013 10:56 AM
*Subject:* Re: [U2] UV full screen editor

Also If you want an editor integrated into your terminal emulator I have
always found wintegrate to be the best solution out there.

___
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] Quick Question on u2 toolkit for .net

2013-02-14 Thread Bill Haskett

Really?  I've never heard that, or seen that either.

Bill


- Original Message -
*From:* david.pet...@bluefinity.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/14/2013 7:33 AM
*Subject:* Re: [U2] Quick Question on u2 toolkit for .net

Just to confirm Symeon that mv.NET has that functionality.

Regards

David Peters
Bluefinity

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 14 February 2013 15:27
To: U2 Users List
Subject: Re: [U2] Quick Question on u2 toolkit for .net

No, it doesn't.

Regards,
Dan


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, February 14, 2013 3:20 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Quick Question on u2 toolkit for .net

I am currently not really interested in most of this - we just simply connect 
to u2 using uo.net to do subroutine calls and produce webservices from this.

  However my question is, does this toolkit allow you to edit and compile U2
basic programs within visual studio ?   Now that would be handy.

Rgds

Symeon.
___
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] [UD] SETPTR

2013-02-02 Thread Bill Haskett

Doug:

Great eye!  I ran into this after moving to Windows 2008 R2 (which is 64 
bit) back in the summer of 2010.  Fortunately, Wally worked to get this 
fixed in UD v7.2.7.  I've implemented UDT.OPTIONS 116 ON ever since, but 
it wasn't set in our demo account on this particular server.  I must 
have moved the demo account from somewhere else.  I knew this was 
familiar but couldn't remember what.


Anyway, thanks very much!  :-)

Bill


- Original Message -
*From:* dave...@u2logic.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/2/2013 7:02 AM
*Subject:* Re: [U2] [UD] SETPTR

Hi Bill:

We had this problem a while ago.  You might try setting this UDT option.

UDT.OPTIONS 116 OFF/ON

Regards
Doug
www.u2logic.com
Applications and tools for U2 shops

On Fri, Feb 1, 2013 at 7:12 PM, Bill Haskett wphask...@advantos.net wrote:


David:

The ping doesn't respond on either machine.  The printer is local on
both dbms servers, not a network printer; although it is shared.

Bill

--**--**

- Original Message -
*From:* dgr...@dagconsulting.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 2/1/2013 5:54 PM
*Subject:* Re: [U2] [UD] SETPTR

  Bill, sounds like a domain name network issue.  How does a ping to

UDGENERIC
respond?  Maybe you can add the IP address to your host file?

David A. Green
(480) 813-1725
DAG Consulting

-Original Message-
From: 
u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org
[mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org]
On Behalf Of Bill Haskett
Sent: Friday, February 01, 2013 6:14 PM
To: U2 Mail List
Subject: [U2] [UD] SETPTR

Does anyone know why UniData (v7.2.12) responds differently to the SETPTR
command between two different machines? I created a local printer, which I
share as UDGENERIC, that is a generic/text printer to a file.  I did
this
on both machines.

Machine 1 - Windows 2008 R2 fully updated - UniData 77 user Standard
Edition.
:version

   Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 No
Device License... 7.2 No
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
7212

:SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,**NOHEAD,DEST UDGENERIC

This command takes exactly 60 seconds to return to ECL.

Machine 2 - Windows 2008 R2 fully updated - UniData 24 user Workgroup
Edition.
:version

   Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 Yes
Device License... 7.2 Yes
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
7212

:SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,**NOHEAD,DEST UDGENERIC

This command returns to ECL immediately.

Both machines are Dell R210 rack-mount servers.  I'm having the
udt.errlog
fill up with messages:

Fri Feb 01 18:19:34 pid=2828 In E:\DataTrust\DTA\BP\BP\_RESET.**STANDARDS
at line 33 Fri Feb 01 18:19:34 pid=2828 errno=1801: The printer name is
invalid.
Fri Feb 01 18:19:56 pid=3696 pid=3696,uid=197875,udtno=2:

...which is caused by one of our subroutines, used everywhere in our
application.  This error occurs nowhere else where our application is
installed, because I execute the above SETPTR command within the LOGIN
process at login.  I can't execute it on our 77 user machine because
logging
on will take over a minute!

Any ideas?  Thanks,

Bill Haskett
__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users

__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users


__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] [UD] SETPTR

2013-02-01 Thread Bill Haskett
Does anyone know why UniData (v7.2.12) responds differently to the 
SETPTR command between two different machines? I created a local 
printer, which I share as UDGENERIC, that is a generic/text printer to 
a file.  I did this on both machines.


Machine 1 - Windows 2008 R2 fully updated - UniData 77 user Standard 
Edition.

:version

Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 No
Device License... 7.2 No
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
7212

:SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,NOHEAD,DEST UDGENERIC

This command takes exactly 60 seconds to return to ECL.

Machine 2 - Windows 2008 R2 fully updated - UniData 24 user Workgroup 
Edition.

:version

Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 Yes
Device License... 7.2 Yes
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
7212

:SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,NOHEAD,DEST UDGENERIC

This command returns to ECL immediately.

Both machines are Dell R210 rack-mount servers.  I'm having the 
udt.errlog fill up with messages:


Fri Feb 01 18:19:34 pid=2828 In E:\DataTrust\DTA\BP\BP\_RESET.STANDARDS 
at line 33 Fri Feb 01 18:19:34 pid=2828 errno=1801: The printer name is 
invalid.

Fri Feb 01 18:19:56 pid=3696 pid=3696,uid=197875,udtno=2:

...which is caused by one of our subroutines, used everywhere in our 
application.  This error occurs nowhere else where our application is 
installed, because I execute the above SETPTR command within the LOGIN 
process at login.  I can't execute it on our 77 user machine because 
logging on will take over a minute!


Any ideas?  Thanks,

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


Re: [U2] [UD] SETPTR

2013-02-01 Thread Bill Haskett

David:

The ping doesn't respond on either machine.  The printer is local on 
both dbms servers, not a network printer; although it is shared.


Bill


- Original Message -
*From:* dgr...@dagconsulting.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 2/1/2013 5:54 PM
*Subject:* Re: [U2] [UD] SETPTR

Bill, sounds like a domain name network issue.  How does a ping to UDGENERIC
respond?  Maybe you can add the IP address to your host file?

David A. Green
(480) 813-1725
DAG Consulting

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Friday, February 01, 2013 6:14 PM
To: U2 Mail List
Subject: [U2] [UD] SETPTR

Does anyone know why UniData (v7.2.12) responds differently to the SETPTR
command between two different machines? I created a local printer, which I
share as UDGENERIC, that is a generic/text printer to a file.  I did this
on both machines.

Machine 1 - Windows 2008 R2 fully updated - UniData 77 user Standard
Edition.
:version

  Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 No
Device License... 7.2 No
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
7212

:SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,NOHEAD,DEST UDGENERIC

This command takes exactly 60 seconds to return to ECL.

Machine 2 - Windows 2008 R2 fully updated - UniData 24 user Workgroup
Edition.
:version

  Module Name Version   Licensed

UniData RDBMS 7.2 Yes
Connection Pooling... 7.2 Yes
Device License... 7.2 Yes
NFA.. 7.2 No
RFS.. 7.2 No
EDA.. 7.2 No
7212

:SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,NOHEAD,DEST UDGENERIC

This command returns to ECL immediately.

Both machines are Dell R210 rack-mount servers.  I'm having the udt.errlog
fill up with messages:

Fri Feb 01 18:19:34 pid=2828 In E:\DataTrust\DTA\BP\BP\_RESET.STANDARDS
at line 33 Fri Feb 01 18:19:34 pid=2828 errno=1801: The printer name is
invalid.
Fri Feb 01 18:19:56 pid=3696 pid=3696,uid=197875,udtno=2:

...which is caused by one of our subroutines, used everywhere in our
application.  This error occurs nowhere else where our application is
installed, because I execute the above SETPTR command within the LOGIN
process at login.  I can't execute it on our 77 user machine because logging
on will take over a minute!

Any ideas?  Thanks,

Bill Haskett
___
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] Triggers in Universe

2013-01-29 Thread Bill Haskett
/...but I've created systems with master triggers that read a list of 
subordinate triggers from a control file and call them in order./


This appears to be the best practices of managing triggers in UD.  
Once explained, it seems the most logical method of managing triggers 
and allowing individual dbms accounts to use local versions of trigger 
subroutines.


Bill

- Original Message -
*From:* br...@brianleach.co.uk
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 1/29/2013 1:08 AM
*Subject:* Re: [U2] Triggers in Universe

Peter

Yes, they are still cached but you can derive the name - it's an overhead but 
I've created systems with master triggers that read a list of subordinate 
triggers from a control file and call them in order. Then these can have a 
version stamp appended when catalogued.

IN practice I found the overhead of reading the list was minimal compared with 
the overheads on calling the trigger in the first place, and because it's 
happening all the time on a busy system that control file is constantly cached 
in memory anyway.

Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: 28 January 2013 23:26
To: U2 Users List
Subject: Re: [U2] Triggers in Universe

Could use the trigger program to call one or more external subroutines based on 
the trigger action required?  I understand that the external subroutines are 
not cached and can be updated without needing to stop/start the master trigger.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Saturday, 26 January 2013 20:19
To: U2 Users List
Subject: Re: [U2] Triggers in Universe

Remember also that triggers, as subroutines, are cached in memory so if you 
recompile a trigger  the changes won't be picked up by any processes that have 
not logged off or returned to TCL.

Brian


Sent from my iPad

On 25 Jan 2013, at 22:18, Bobby Worley bwor...@coburns.com wrote:


[snipped]


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


Re: [U2] Searching for 'Bad' Dates

2013-01-29 Thread Bill Haskett

Greg:

Can you do something like:

   :select {FileName} WITH EVAL OCONV(MPAR.STATUS.DATE, 'D') = 

This works fine on UniData in PICK mode, where an invalid conversion 
returns a null (an empty string).


HTH,

Bill



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates

All,

Can anyone help me with a query to find instances where an external date has been 
written to a date field?  I would like to use ...WITH MPAR.STATUS.DATE LIKE ..
./... (the dates would be in the fomat: '12/16/12', but this field is set with 
external formatting so I end up bringing back everything.  Is there a way I can 
'turn off' formatting for this field within the query?

Thanks,

Greg

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


Re: [U2] Searching for 'Bad' Dates

2013-01-29 Thread Bill Haskett

Greg:

That was the point.  What happens is an externally formatted date isn't 
OCONV'd, if the dbms is configured to return an empty string for a bad 
conversion.  I've got this set up on our systems like this. So, when I 
run the following code:


2 Dev (0)- BPTEST CRT 'OConverted Date--: ' : OCONV('01/29/13', 'D') ; END

Compiling Unibasic: SAVEDLISTS\BpTest_547690521 in mode 'p'.
compilation finished
OConverted Date--:

...I get what you're looking for, an empty string for dates filed in 
external format.  In UniData I need UDT.OPTIONS 56 ON.


Bill


- Original Message -
*From:* coe...@american.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/29/2013 3:09 PM
*Subject:* Re: [U2] Searching for 'Bad' Dates

Bill,

This is only returning those records that do not have a value in
MPAR.STATUS.DATE.  Unfortunately I looking for records where an external
date has been written instead of the internal date.

Greg



From:   Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Date:   01/29/2013 06:01 PM
Subject:Re: [U2] Searching for 'Bad' Dates
Sent by:u2-users-boun...@listserver.u2ug.org



Greg:

Can you do something like:

 :select {FileName} WITH EVAL OCONV(MPAR.STATUS.DATE, 'D') = 

This works fine on UniData in PICK mode, where an invalid conversion
returns a null (an empty string).

HTH,

Bill



-Original Message-
From: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates

All,

Can anyone help me with a query to find instances where an external date
has been written to a date field?  I would like to use ...WITH
MPAR.STATUS.DATE LIKE ..
./... (the dates would be in the fomat: '12/16/12', but this field is set
with external formatting so I end up bringing back everything.  Is there a
way I can 'turn off' formatting for this field within the query?

Thanks,

Greg

___
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] [UD] Disabling/blocking ODBC

2013-01-25 Thread Bill Haskett
Just as an aside, there's also a UOLOGIN global cataloged routine that 
is always called before a UO login (I created it with that name).  It's 
a very handy routine to use to manage connections.


Bill


- Original Message -
*From:* aeger...@pobox.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/25/2013 11:23 AM
*Subject:* Re: [U2] [UD] Disabling/blocking ODBC

Dan,

Is this also available in Universe? (Release 10.3.7 for windows)

(Allen - Sent from my paperweight)

On Jan 25, 2013, at 1:49 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote:


There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called 
for every ODBC call. You can use this to either blank prevent ODBC, or setting up 
restricted login access  login.

If you are under a support contract, contact your support provider and they 
should be able to help you get ODBCLOGIN up and running.

Cheers,

Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software
4600 South Ulster Street  ·  Suite 1100  ·   Denver, CO 80237 ·  USA
T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Friday, January 25, 2013 11:23 AM
To: 'U2 Users List'
Subject: [U2] [UD] Disabling/blocking ODBC

We may need to figure out a way to disable ODBC access to UniData due to data 
access concerns. I've set up connections before, but have never approached ODBC 
from this perspective. I'm hoping there's a service we can turn off or a port 
we can block. One possible constraint is that we still need to be able to 
connect to UniData via DataStage. We use the native unidata connector, so I'm 
hoping that won't get in the way. Thoughts?

UniData 7.1
AIX 5.3


TIA,
Brad.
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


Re: [U2] Universal COMO

2013-01-23 Thread Bill Haskett
In UniData (on Windows) this is pretty simple.  First you create an 
environment variable for the como file (e.g. MY_COMO) that points to the 
directory under which you've created a _PH_ directory and a D__PH_ 
dictionary file.  Then you create a VOC item as follows:


_PH_
001 DIR
002 @MY_COMO\_PH_
003 @MY_COMP\D__PH_

...to include in every account's VOC file.  This will now act as a 
centralized como repository.  I do this with the _HOLD_ directory, as 
everyone on our machines share the same spooler file, and each spooler 
file name is a unique .txt file.  I'm sure it would be even easier on 
a nix machine.  :-)


Bill


- Original Message -
*From:* peter.che...@firstmac.com.au
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/23/2013 6:31 PM
*Subject:* Re: [U2] Universal COMO

Hi Will,

I think the biggest *con* you might come up against will be concurrency issues 
with multiple processes writing to the one central location.
If you had a solution where each session log is unique amongst all processes 
then that would work very well.

You will still need to clean it out though whether it be one big centralised dir or one 
for each account. As others have indicated, and if you run a unix box, then an 
overnight cron job to find and clean out any COMO dirs older than a set 
number of days would an option for you. I would suggest that you identify any logs that 
were important historically to you and roll them first. Probably zipping them up and 
moving them to an archive area would be viable. Google may even cough up a log rotate 
script that you could adapt.

Regards,
Peter

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, 24 January 2013 4:28
To: u2-users@listserver.u2ug.org
Subject: [U2] Universal COMO

By default, Universe will create several files in each account you create.  Like SAVEDLISTS, 
and ED... one of these default files is COMO which is where you can stick session 
logs.

We use this constantly to monitor the output of phantoms, for review and 
debugging the next day.  The logs are emailed to myself and some other 
programmers here.

By altering the VOC entries in the accounts, we could have a central, universal 
COMO for all accounts, instead of one for each account.

I see a *pro* in this, for the ease of cleaning up old logs from years ago, 
obviously no longer needed, which can be done from the O/S level.  What might 
be a *con* ?

Will Johnson
___
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


Re: [U2] How to check which sproc is called by user

2013-01-08 Thread Bill Haskett

Andy:

The first place I'd look for any UO errors is the UO error log. In UD, 
you need to create a serverdebug item in the @UDTHOME directory (in my 
case this is in E:\U2\ud).  The contents of this item is:


udcs 10 E:\U2\ud\log\udcs\udcs.log

...which indicates maximum logging and the log should go to the location 
indicated.  From there I've always been able to track down UO problems.  
They've mostly been with my UOLOGIN globally cataloged routine, but 
sometimes I see other problems.


I'm not sure how to do this in UV, but it should be fairly easy to track 
down once you activate UO logging.


HTH,

Bill

P.S.  I set all of my UO connections to timeout in 5 minutes (in my 
E:\U2\unishared\unirpc\unirpcservices file).  This causes the Basic  
Developer's Toolkit to not work properly, but you can use any other 
development client  you want, as long as it sends a keepalive.



- Original Message -
*From:* akra...@rammutual.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/8/2013 6:43 AM
*Subject:* Re: [U2] How to check which sproc is called by user

I will chime in since I work with Ravi and I am dealing with this issue
along with him.

Thanks for the response Brian, PORT.STATUS should be useful for our
situation.

I'll try and be a little more specific and hopefully I know what I'm
talking about:  We have a web application which is using UniObjects and
we are randomly getting multiple (we've seen as many as 9) user sessions
in the LISTU which appear to be hung and it's causing us to reach our
user limit.  We have debugged the web application and verified that all
sessions are being closed properly so we do not believe that it's on the
web side of things.  Although, we cannot duplicate this problem in the
live application either, so we cannot say for sure it's not on the web
side.  My first thought was that the application is calling a PICK
subroutine that is stalling (possibly waiting for input or stuck in an
infinite loop or something).

So, at this point all we know is we are getting these stalled sessions
but we don't know how.  Hopefully with PORT.STATUS we can see whether is
a PICK subroutine that is stalling?

Now, to limit the severity of this problem we discovered there is a
Timeout property of the UniSession object.  However, it seems in the
past we were advised against setting this parameter by Rocket support
and that this timeout should be handled in the unirpcservices file in
the unishared directory?  Does that sound right?  UniAdmin uses the
timeout in the unirpcservices file so I don't think we would want to
shorten the timeout and be booted from UniAdmin sooner.

Thanks in advance for any responses.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Tuesday, January 08, 2013 3:35 AM
To: 'U2 Users List'
Subject: Re: [U2] How to check which sproc is called by user

If it is a session hang you're possibly looking at locking issues so
check the lock table to see what is waiting and also check for any group
locks that persist.

If it is UniVerse, It's also a good idea to check the errlog file in the
uv
account: if that does not exist, create it as a zero length file (you
can go into the UV account and ED UFD errlog and just file it) and it
will log the last 100 errors.

If you can catch the session that has hung you can use the PORT.STATUS
command to see where they were and their calling stack.

Phil's idea of using the remote item security subroutine to audit calls
is good once you've managed to identify the routine concerned, but it
doesn't help you get to that point.

How is your application constructed? Is it terminal based, UniObjects,
Web?
If it is terminal based, create a COMO on the LOGIN for that user
session and see if that helps find it.

If it is UniObjects based and you can clearly identify the user (and you
have the time and space) and nothing else has worked, you can actually
watch their session using a network tracer.

I think we need to know a little more about the context of the problem.

Brian


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ravindranath
Wickramanayake
Sent: 07 January 2013 21:55
To: u2-users@listserver.u2ug.org
Subject: [U2] How to check which sproc is called by user

Hi U2 Guru's

  


Can I tell when a sproc was last executed or who executed it.  If so
how.
Some way to get statistics and access logs. Reason we are asking this is
we are having a session hang issue we have tracked it down to a session
user but have no clue which sproc did the call to trouble shoot.

  


Thanks in advance

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



Re: [U2] UV win 2008 Workgroup - ED / COPY very slow

2012-12-11 Thread Bill Haskett

Manu:

Have you checked with U2 support?  What have they said?

Bill Haskett


- Original Message -
*From:* e...@infodata.lu
*To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
*Date:* 12/11/2012 8:20 AM
*Subject:* [U2] UV win 2008 Workgroup - ED / COPY very slow

Hi group,

Using Universe 11.1.9 on win2008/workgroup logged as Administrator, I get a 
perf trouble when using ED, COPY, BUILD.INDEX, the process use 10 seconds to 
start.

After look inside, I detect each one use uv's subroutine -PERMISSIONS which 
seems check the user's write right on the file to update.

The execution of these subr (non documented) use 10 seconds.

I suspect a security/rights problem but where ?

Any suggestions ?

Thanks
Manu Fernandes



___
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


  1   2   3   4   5   6   7   8   9   10   >