[U2] Report Generation

2014-01-16 Thread Charles_Shaffer
I have been asked to look into a report generation tool similar to Crystal 
Reports for multivalued databases. and MS SQL server databases.  I've 
worked with BI Query before are you folks aware of other possible 
solutions. The user has asked for
Ability to schedule queries to run at night
Ability to automatically distribute reports. I think saving them in a 
shared area is good enough.
Ability to generate charts as part of the scheduled run.

Any ideas are appreciated.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [OT] Interview Questions

2013-10-08 Thread Charles_Shaffer
Whenever I interview, it's all about the work.  I tend to give a technical 
interview and avoid the What can you bring to our company types of 
questions. HR wants to hire Game Show hosts. I need people who can 
produce. 

Find out what they know and how they think.  And If you want to know 
somebody's character, give them a problem that you know they can't solve 
in the allotted time. You will see how they handle frustration and 
overwhelming challenges.  If they take the problem as far as they can and 
look you in the eye and say I couldn't finish it then they will probably 
be good to work with. If they get shook up and try and BS you with a wrong 
answer, or if they try to distract you with their dazzling personality 
then I tend to shy away.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] File size (5538816) is not a multiple of block size(16384).

2013-09-06 Thread Charles_Shaffer
We had some file corruption last night and I  am trying to recover a file. 
 The file was so badly corrupted this morning that it wasn't recognized as 
a Unidata file. 

What I have tried is copying the data and dictionary to SAVE files at the 
system level. Then I did a DELETE.FILE of the file and then a CREATE.FILE 
STRUCTURE-HEADER_MA 13,1. Then I copied the data and dictionary files back 
over the originals.  The dictionary portion is OK, but I get the message 
File size (5538816) is not a multiple of block size(16384).

I had hoped that recreating the file with a block size of 1 would have 
made this work since 5538816 is divisible by 1024.  But it did not work. 
It still thinks the block size is 16.

Can anyone tell me how to recover this data?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] File size (5538816) is not a multiple of block size(16384).

2013-09-06 Thread Charles_Shaffer
I am also working with them.  I am just trying to cover all the bases. I 
guess I should let them escalate to Rocket if necessary.  Thanks.




Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Daniel McGrath dmcgr...@rocketsoftware.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   09/06/2013 11:58 AM
Subject:Re: [U2] File size (5538816) is not a multiple of block 
size(16384).
Sent by:u2-users-boun...@listserver.u2ug.org



Hi Charles,

Have you let your support provider know? If they cannot do it they should 
just escalate to Rocket. I know our support engineers here is pretty good 
at salvaging these type of situations.

Regards,

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 
charles_shaf...@ntn-bower.com
Sent: Friday, September 06, 2013 10:40 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] File size (5538816) is not a multiple of block size(16384).

We had some file corruption last night and I  am trying to recover a file. 

 The file was so badly corrupted this morning that it wasn't recognized as 
a Unidata file. 

What I have tried is copying the data and dictionary to SAVE files at the 
system level. Then I did a DELETE.FILE of the file and then a CREATE.FILE 
STRUCTURE-HEADER_MA 13,1. Then I copied the data and dictionary files back 
over the originals.  The dictionary portion is OK, but I get the message 
File size (5538816) is not a multiple of block size(16384).

I had hoped that recreating the file with a block size of 1 would have 
made this work since 5538816 is divisible by 1024.  But it did not work. 
It still thinks the block size is 16.

Can anyone tell me how to recover this data?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


Re: [U2] File size (5538816) is not a multiple of block size(16384).

2013-09-06 Thread Charles_Shaffer
Thanks Susan. i use UltraEdit which would allow that.  You just explained 
something for me.  I kept recreating the file with a block sie that would 
work, but when I copied that data back in, it would revert. That is 
because the block size is contained in the data.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Susan Lynch sly...@fwdco.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   09/06/2013 12:03 PM
Subject:Re: [U2] File size (5538816) is not a multiple of block 
size(16384).
Sent by:u2-users-boun...@listserver.u2ug.org



Charles,

What I have done in similar situations is stop UniData, open the file in a
hex editor (there are free hex editors on the web - Cygnus has always
worked well for me), and trim back the last block (in your case, the last
1024  bytes), since that block has been damaged.   Then change the modulo
in the first block of the file to what your file would then be, which is
337 (which is hex 0151, so the first 2 bytes of the file would become
5101, since UniData stores the modulo in reverse order).   At that point,
you should be able to start UniData, run guide on the file, do a fixfile
for any damage, resize it (so that things will hash properly, which might
not be true with the modulo you replaced), and then compare the file to
your most recent backup and any audit logs that you have for data
added/changed since that backup to help you find any records that might
have been chopped off at the end of the file.

Not fun, but it should work...

Susan Lynch
F. W. Davison  Company, Inc.

-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, September 06, 2013 12:40 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] File size (5538816) is not a multiple of block size(16384).

We had some file corruption last night and I  am trying to recover a file.

 The file was so badly corrupted this morning that it wasn't recognized as
a Unidata file.

What I have tried is copying the data and dictionary to SAVE files at the
system level. Then I did a DELETE.FILE of the file and then a CREATE.FILE
STRUCTURE-HEADER_MA 13,1. Then I copied the data and dictionary files back
over the originals.  The dictionary portion is OK, but I get the message
File size (5538816) is not a multiple of block size(16384).

I had hoped that recreating the file with a block size of 1 would have
made this work since 5538816 is divisible by 1024.  But it did not work.
It still thinks the block size is 16.

Can anyone tell me how to recover this data?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


Re: [U2] File size (5538816) is not a multiple of block size(16384).

2013-09-06 Thread Charles_Shaffer
Here's what I ended up doing.

I couldn't get rid of the GFEs that I was seeing when I ran guide so 
followed these instructions fromour vendor.  It didn't recover the lost 
items, but it got rid of he guide errors..

If you have corruption on only a few files or if the fixfile does not 
clean up all corruption:
FILE.STAT badfile(make a note of the modulo)
CREATE.FILE holderfile modulo
COPY FROM badfile TO holderfile ALL (You should see some number or records 
copied)
COUNT badfile(hopefully, you will see the same number)
CLEAR.FILE DATA badfile
If you need to resize, do that now: RESIZE badfile newmodulo
COPY FROM holderfile TO badfile ALL
When finished DELETE.FILE holderfile


Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] File size (5538816) is not a multiple of block size(16384).

2013-09-06 Thread Charles_Shaffer
I am stuck on fixing the file.  guide produces a GUIDE_FIXUP.DATA file 
that lists the problem groups.  When I run fixfile it is not able to 
correct the GFEs.  I can deal with losing the data, we can re enter it. 
BUt how do I get rid of those GFE errors.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Susan Lynch sly...@fwdco.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   09/06/2013 12:25 PM
Subject:Re: [U2] File size (5538816) is not a multiple of block 
size(16384).
Sent by:u2-users-boun...@listserver.u2ug.org



Charles, yes, first you have to fix the damaged file, then you can use the
UniData utilities to resize it any way that you want.  The modulo and
block are both in the first block of a static file size (in your case, I
believe you would see a 0F in byte 17 of that first block for your
16384-byte block).  Dynamic files are more complicated...

Susan Lynch
F. W. Davison  Company, Inc.

-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, September 06, 2013 1:17 PM
To: U2 Users List
Cc: u2-users-boun...@listserver.u2ug.org
Subject: Re: [U2] File size (5538816) is not a multiple of block
size(16384).

Thanks Susan. i use UltraEdit which would allow that.  You just explained
something for me.  I kept recreating the file with a block sie that would
work, but when I copied that data back in, it would revert. That is
because the block size is contained in the data.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Susan Lynch sly...@fwdco.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date:   09/06/2013 12:03 PM
Subject:Re: [U2] File size (5538816) is not a multiple of block
size(16384).
Sent by:u2-users-boun...@listserver.u2ug.org



Charles,

What I have done in similar situations is stop UniData, open the file in a
hex editor (there are free hex editors on the web - Cygnus has always
worked well for me), and trim back the last block (in your case, the last
1024  bytes), since that block has been damaged.   Then change the modulo
in the first block of the file to what your file would then be, which is
337 (which is hex 0151, so the first 2 bytes of the file would become
5101, since UniData stores the modulo in reverse order).   At that point,
you should be able to start UniData, run guide on the file, do a fixfile
for any damage, resize it (so that things will hash properly, which might
not be true with the modulo you replaced), and then compare the file to
your most recent backup and any audit logs that you have for data
added/changed since that backup to help you find any records that might
have been chopped off at the end of the file.

Not fun, but it should work...

Susan Lynch
F. W. Davison  Company, Inc.

-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, September 06, 2013 12:40 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] File size (5538816) is not a multiple of block size(16384).

We had some file corruption last night and I  am trying to recover a file.

 The file was so badly corrupted this morning that it wasn't recognized as
a Unidata file.

What I have tried is copying the data and dictionary to SAVE files at the
system level. Then I did a DELETE.FILE of the file and then a CREATE.FILE
STRUCTURE-HEADER_MA 13,1. Then I copied the data and dictionary files back
over the originals.  The dictionary portion is OK, but I get the message
File size (5538816) is not a multiple of block size(16384).

I had hoped that recreating the file with a block size of 1 would have
made this work since 5538816 is divisible by 1024.  But it did not work.
It still thinks the block size is 16.

Can anyone tell me how to recover this data?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

--
This email was Virus checked by UTM 9. http://www.astaro.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

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


[U2] @RECORD VARIABLES

2013-08-15 Thread Charles_Shaffer
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


Re: [U2] @RECORD VARIABLES

2013-08-15 Thread Charles_Shaffer
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 checked by UTM 9. http://www.astaro.com

___
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 Charles_Shaffer
I only know Unidata.  Maybe someone else knows.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
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 Charles_Shaffer
In Unidata I believe that it only works for virtual (type = V) attributes. 
 It is nice though. If you have an attribute that reads  from other files 
and performs calculations, formatting, etc. it executes the virtual and 
gives you the output.  Let's you take advantage of the virtual attributes 
already defined in the dictionary.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Phil Walker p...@gnosys.co.nz
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   08/15/2013 04:11 PM
Subject:Re: [U2] @RECORD VARIABLES
Sent by:u2-users-boun...@listserver.u2ug.org



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 checked by UTM 9. http://www.astaro.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

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


[U2] XML or JSON converter for Unibasic

2013-08-02 Thread Charles_Shaffer
I am looking for a way to send the output of a Unidata data query in 
Unibasic back to a web server (PHP) for building web pages.

Up until now I have used a proprietary method (LF, HTAB, etc.), but I 
would like to simplify/standardize the method.  Seems like this could be 
done with XML, or JSON or something I don't know about. Has anyone had 
experience with this and could you offer some advice?

Hoping for a simple subroutine approach as opposed to a comprehensive 
commercial package. Management here is very price sensitive.  When I say 
price sensitive, I mean that if it costs anything, they get their panties 
all in a bunch.  A few hundred dollars might be sellable, a few thousand 
would not be.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] XML or JSON converter for Unibasic

2013-08-02 Thread Charles_Shaffer
We use UNIX on our web and database servers, so the mvScript wouldn't help 
in our case.

I would like to learn more about the built-in restful services you 
mentioned.  That is built-in to Unidata?  We are at 7.2. 


Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org, 
Date:   08/02/2013 11:41 AM
Subject:Re: [U2] XML or JSON converter for Unibasic
Sent by:u2-users-boun...@listserver.u2ug.org



My preferred solution is to use a middle tier web service in C#, that
exposes method calls for either XML or JSON (automatic, just depends on 
the
content-type in the request). Then you can call that from anything that
expects JSON or SOAP.

But that's only because I began doing that long before restful web 
services
got built into the product.

Or bypass PHP and use mvScript if you can live with IIS.

Brian

-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: 02 August 2013 17:12
To: U2 Users List
Subject: [U2] XML or JSON converter for Unibasic

I am looking for a way to send the output of a Unidata data query in
Unibasic back to a web server (PHP) for building web pages.

Up until now I have used a proprietary method (LF, HTAB, etc.), but I 
would
like to simplify/standardize the method.  Seems like this could be done 
with
XML, or JSON or something I don't know about. Has anyone had experience
with this and could you offer some advice?

Hoping for a simple subroutine approach as opposed to a comprehensive
commercial package. Management here is very price sensitive.  When I say
price sensitive, I mean that if it costs anything, they get their panties
all in a bunch.  A few hundred dollars might be sellable, a few thousand
would not be.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


Re: [U2] XML or JSON converter for Unibasic

2013-08-02 Thread Charles_Shaffer
7.3 has a built-in JSON library.  That's what I was looking for.

Thanks

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Aaron Titus ati...@fwdco.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   08/02/2013 12:14 PM
Subject:Re: [U2] XML or JSON converter for Unibasic
Sent by:u2-users-boun...@listserver.u2ug.org



JSON is far more lightweight vs XML.  Also if you upgrade to 7.3 Unidata,
the built-in JSON library (called UDO) is very easy to use. This would be
my recommendation.


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



On Fri, Aug 2, 2013 at 12:59 PM, charles_shaf...@ntn-bower.com wrote:

 We use UNIX on our web and database servers, so the mvScript wouldn't 
help
 in our case.

 I would like to learn more about the built-in restful services you
 mentioned.  That is built-in to Unidata?  We are at 7.2.


 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation



 From:   Brian Leach br...@brianleach.co.uk
 To: 'U2 Users List' u2-users@listserver.u2ug.org,
 Date:   08/02/2013 11:41 AM
 Subject:Re: [U2] XML or JSON converter for Unibasic
 Sent by:u2-users-boun...@listserver.u2ug.org



 My preferred solution is to use a middle tier web service in C#, that
 exposes method calls for either XML or JSON (automatic, just depends on
 the
 content-type in the request). Then you can call that from anything that
 expects JSON or SOAP.

 But that's only because I began doing that long before restful web
 services
 got built into the product.

 Or bypass PHP and use mvScript if you can live with IIS.

 Brian

 -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: 02 August 2013 17:12
 To: U2 Users List
 Subject: [U2] XML or JSON converter for Unibasic

 I am looking for a way to send the output of a Unidata data query in
 Unibasic back to a web server (PHP) for building web pages.

 Up until now I have used a proprietary method (LF, HTAB, etc.), but I
 would
 like to simplify/standardize the method.  Seems like this could be done
 with
 XML, or JSON or something I don't know about. Has anyone had 
experience
 with this and could you offer some advice?

 Hoping for a simple subroutine approach as opposed to a comprehensive
 commercial package. Management here is very price sensitive.  When I 
say
 price sensitive, I mean that if it costs anything, they get their 
panties
 all in a bunch.  A few hundred dollars might be sellable, a few thousand
 would not be.

 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users


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

 --
 This email was Virus checked by UTM 9. http://www.astaro.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

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


Re: [U2] XML or JSON converter for Unibasic

2013-08-02 Thread Charles_Shaffer
Very good advice.  I did know that XML support was built-in to Unidata, 
and apparently JSON support is included in the newest version of Unidata. 
I guess I am leaning towards JSON because as Aaron Titus pointed out, it 
is more lightweight than XML.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Tony Gravagno 3xk547...@sneakemail.com
To: u2-users@listserver.u2ug.org, 
Date:   08/02/2013 01:05 PM
Subject:Re: [U2] XML or JSON converter for Unibasic
Sent by:u2-users-boun...@listserver.u2ug.org



I do this sort of thing all the time. I'm also curious to know if a
Uni-query can be rendered directly as XML or JSON. I know QM can
render as XML with a simple modifier on the command-line, thought U2
could do this too. JSON is a different animal and I'm not aware of any
decent JSON builders for any MV environment  - they're all proprietary
and unpublished except for the new one in Unidata.

The real problem with all of these XML/JSON solutions is that the
output we get from our reports is 2-dimensional columns and rows - a
curious anomaly after all of these years, considering how much we
pride ourselves on being multi-dimensional. XML and JSON aren't of
much use with flat data. Coding a 2D export to XML or JSON is trivial.
Where this gets complex is in nested relationships, XML and JSON excel
in representation of multi-dimensional data, and again, none of the MV
platforms have rushed to provide decent rendering in this area.
(Except maybe TigerLogic which has built a rich XML server around the
D3 core, like DataStage was built around Universe.)

In plain terms, a U2 report will have something like:
ORD# SHIP.ADDR SHIP.CITY ...
ORD# SHIP.ADDR SHIP.CITY ...
That's 2D. But when you're passing data to another environment, it
expects 3D:
order
  id123/id
  shipto
addr.../addr
   city.../city
  /shipto
/order

JSON is exactly the same as XML in structure, just different in
syntax. Part of the problem is that the output here needs to use names
which are acceptable in XML/JSON tags. That might come from the dict
item, probably not unless you have custom dict items just for this.
The way this is usually done is with metadata stored in the dict item
or somewhere else. So you'll have a dict item named ORD#, the
description might say Order ID but the node name will be id.

Note above that I'm using id123/id. But that could have been done
like this:
  order id=123
The issue here is that there is no schema definition that defines
whether you use elements (unique nodes) or attributes (id=123)
within elements. Hardcoded general-purpose solutions will work for
your internal purposes but they won't work as a general solution for
exchanging data with other entities.

And let's not even get into namespaces.

In summary, the above explains why it's tough to have a
general-purpose solution for rendering query output as XML or JSON. A
lot of other metadata is required in order to describe what the
document will look like. The only recourse we have is to use the XML
hooks provided in the DBMS, to hard-code on a case-by-case basis, or
to export and let some external tool do the formatting ... but in all
cases you still need to provide metadata or none of these tools will
know whether to use id or ordnum, or whether to use elements or
attributes.

All of that said, the nature of my business is to create solutions to
problems like this. I'll be happy to do so for any company that
associates value with such solutions.

HTH
Tony Gravagno 
Nebula Research and Development 
TG@ remove.pleaseNebula-RnD.com 
http://Nebula-RnD.com/blog 
Visit http://PickWiki.com! Contribute! 
http://Twitter.com/TonyGravagno 
http://groups.google.com/group/mvdbms 
https://bitbucket.org/foss4mv/nebulaware 







 From: Charles_Shaffer 
 I am looking for a way to send the output of a Unidata data query in
 Unibasic back to a web server (PHP) for building web pages.
 
 Up until now I have used a proprietary method (LF, HTAB, etc.), but
I
 would like to simplify/standardize the method.  Seems like this
could
 be done with XML, or JSON or something I don't know about. Has
 anyone had experience with this and could you offer some advice?
 
 Hoping for a simple subroutine approach as opposed to a
 comprehensive commercial package. Management here is very price
 sensitive.  When I say price sensitive, I mean that if it costs
anything,
 they get their panties all in a bunch.  A few hundred dollars might
be
 sellable, a few thousand would not be.

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

-- 
This email was Virus checked by UTM 9. http://www.astaro.com

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


Re: [U2] History..

2013-03-20 Thread Charles_Shaffer
Sathya,

There is a book called UNIX  Unidata by M. Taylor and S. Rees that has 
the best information I have been able to find on the basics of Unidata. It 
is for a UNIX environment, but I think it would be useful in a Windows 
environment too. There are probably other good books, but this is the best 
one I have found.

ISBN 1-900176-00-9

I think I bought my copy from Jon Sisk.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] International Date Format

2013-02-05 Thread Charles_Shaffer
Is there a date conversion mask that returns -mm-dd format?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] International Date Format

2013-02-05 Thread Charles_Shaffer
Wyatt,

Worked perfectly. Thank you.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Buffington, Wyatt wgbuffing...@hydro.mb.ca
To: 'U2 Users List' u2-users@listserver.u2ug.org, 
Date:   02/05/2013 08:22 AM
Subject:Re: [U2] International Date Format
Sent by:u2-users-boun...@listserver.u2ug.org



You could try D-YMD[4,2,2]


Wyatt Buffington 
AMPS Support
Manitoba Hydro
204- 360-4473
I wish i would have an out of body experience then i wouldn't be here. 



-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: Tuesday, February 05, 2013 8:20 AM
To: U2 Users List
Subject: [U2] International Date Format

Is there a date conversion mask that returns -mm-dd format?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] {BDT] Commenting A Block Of Code

2013-01-10 Thread Charles_Shaffer
Don't know if someone mentioned $DEFINE and $IFDEF, but you can do this to 
comment out blocks of code.

$DEFINE DEBUG

later enclose the code in a $IFDEF/$ENDIF block.

$IFDEF DEBUG

 Code to be commented out

$ENDIF

Then to bring it back undefine DEBUG or move the $IFDEF statement.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Another job ad written by people who have no clue

2012-11-01 Thread Charles_Shaffer
I did a lot of RPL coding in the 80s. I remember when I left that job 
telling them that I would rather slide down a razor blade into a vat of 
alcohol than write one more line of RPL code. But that's just my opinion.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] uniobjects.dll on Notes 8.3

2012-09-18 Thread Charles_Shaffer
This is running on the client. It is called in a LotusScript agent.  I 
just made sure and it is 32-bit.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   jim.sto...@esc.edu
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   09/18/2012 02:24 PM
Subject:Re: [U2] uniobjects.dll on Notes 8.3
Sent by:u2-users-boun...@listserver.u2ug.org



Hi Charles,

Is the new WIN7 system a 64 bit or 32 bit server, and if it is 64 bit, is 
the Domino installation also 64 bit?  The UniObjects COM library is 32 bit 

only, and I haven't found a way to access it from a 64 bit Domino 
installation.  I can confirm that UniObjects does work with a 32 bit 
Domino 8.5.3 installed on a 32 bit server.  I haven't tried 32 bit Domino 
installed on a 64 bit server, so I'm not sure if that would work or not. 

If you find a way to get it to work with a 64 bit Domino / Windows server, 

I'd love to know how.

Good luck!
Jim Stoner
Empire State College



From:   charles_shaf...@ntn-bower.com
To: U2-Users@listserver.u2ug.org, 
Date:   09/18/2012 03:17 PM
Subject:[U2] uniobjects.dll on Notes 8.3
Sent by:u2-users-boun...@listserver.u2ug.org



Hi. 

I'm hoping someone has had a similar experience and can help me with 
something.  I am trying to port a LotusScript agent that uses 
uniobjects.dll library from Notes 5 to Notes 8.3.  It blows up on the 
statement Set UDSession = CreateObject(Uniobjects.Session.1);

This is directly copied over from the XP/Notes 5 system where it has been 
working fine for years, to a WIN7/Notes 8.3 system.
The uniobjects.dll is in Windows\System32\

Anyone seen anything like this?
Has the uniobjects.dll file been updated in the last few years? 

If I recall correctly, uniobjects.dll is the COM library.  Is this 
supported in newer environments?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] uniobjects.dll on Notes 8.3

2012-09-18 Thread Charles_Shaffer
I may have found it.  I gave the user that will be running it access to 
the dll and it seems to be connecting and running now. Although it hasn't 
completed yet.

I am still a bit concerned about not installing the dll correctly.  I have 
the disk from 2005, but is there a newer version of the Uniobjects.dll?

Thanks.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] uniobjects.dll on Notes 8.3

2012-09-18 Thread Charles_Shaffer
Thanks Jim.  I will do that.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   jim.sto...@esc.edu
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   09/18/2012 02:43 PM
Subject:Re: [U2] uniobjects.dll on Notes 8.3
Sent by:u2-users-boun...@listserver.u2ug.org



Yes, the dll files have to be registered.  The easiest way is to just use 
the UniObjects installer provided from Rocket.  You can download it from 
http://www.rocketsoftware.com/u2/resources/downloads and I believe it is 
in the U2 Clients installer, part of the UniDK installation.

Hope that helps,
Jim Stoner
Empire State College





From:   charles_shaf...@ntn-bower.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Cc: u2-users-boun...@listserver.u2ug.org
Date:   09/18/2012 03:38 PM
Subject:Re: [U2] uniobjects.dll on Notes 8.3
Sent by:u2-users-boun...@listserver.u2ug.org



I just copied it. Did I fail to register it?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   David L. Wasylenko d...@pickpro.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   09/18/2012 02:25 PM
Subject:Re: [U2] uniobjects.dll on Notes 8.3
Sent by:u2-users-boun...@listserver.u2ug.org



Shot in the dark...
Did you install the Uniobjects package or just copy the dll... makes a 
difference.

... david ...

David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com


-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: Tuesday, September 18, 2012 2:24 PM
To: U2 Users List
Subject: Re: [U2] uniobjects.dll on Notes 8.3

The error message is Cannot create automation object.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] AUTO: Charles Shaffer is out of the office (returning 09/04/2012)

2012-08-29 Thread Charles_Shaffer

I am out of the office until 09/04/2012.




Note: This is an automated response to your message  Re: [U2] SPAM-HIGH:
Re:  U2UG sent on 08/29/2012 7:07:53 PM.

This is the only notification you will receive while this person is away.

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


Re: [U2] Variable Interpolation

2012-08-24 Thread Charles_Shaffer
If the goal is to generate several variables by building variable names in 
a loop from text, like you can do in UNIX script, PERL, PHP, etc.  I don't 
think you can do that in UniBasic. There nearest thing I can think of is 
to use a dynamic array.  Maybe I am misunderstanding what you are trying 
to do.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
Is there a way to monitor the number of RPC connections being used at any 
given time on Unidata 7.1/Redhat 3?  We are not using device licensing.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
What about connections coming from client applications?  UniCall, 
UniObjects, etc. Do they use up licenses also?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Symeon Breen syme...@gmail.com
To: 'U2 Users List' u2-users@listserver.u2ug.org, 
Date:   07/06/2012 10:18 AM
Subject:Re: [U2] Monitoring connections on Unidata
Sent by:u2-users-boun...@listserver.u2ug.org



listuser ?


-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: 06 July 2012 14:54
To: U2 Users List
Subject: [U2] Monitoring connections on Unidata

Is there a way to monitor the number of RPC connections being used at any
given time on Unidata 7.1/Redhat 3?  We are not using device licensing.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
When I run  #  ps-A | grep 'udapi_slave' | wc -l

Am I getting a count of client connections?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
 On UV, counting instances of uvapi_slave tells me how many unirpc
 connections are active via UOJ.  It doesn't include JDBC connections,
 though.  JDBC connections spawn a process called uvserver.  If 
capturing
 every type of unirpc connection is important, you could determine the
 PID of unirpcd and count its immediate children.  I think this should
 work:

 PID=`ps -el | grep unirpcd | awk '{print $4}'`
 COUNT=`ps -el | grep $PID | awk '{print $5}' | grep $PID | wc -l`
 echo $COUNT

 -John

Thanks.  That works great.

The problem I am having is that our MRP application does a lot of RPC 
calls to our Unidata server.  We have been having a lot of random problems 
and I suspect that we are running out of connections.  I am looking for a 
way to show that for sure.  I am recommending beefing up our licenses and 
need to show some justification for the financial expense.

Does the sum of the number of users plus the number of RPC connections 
give me the number of licenses in use at the moment?

It seems that way.  Right now there are 56 users listed in listuser. There 
are 31 RPC connections.  This is a total of 87.  We have 96 licenses.  And 
right now everybody seems to be happy.  I expect that when problems start 
occurring, I will check and find that the total of the list user count and 
RPC connections will be greater than 96.

Does that sound right? 


Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
John Hester

That sounds like the correct way to determine total license count.  In
UV at least, there is also a more official way to do it via a built-in
subroutine called !GET.USER.COUNTS.  I don't know if it exists in UD.  I
have a simple program I can run at TCL that calls it and reports the
numbers:

0001: CALL !GET.USER.COUNTS  (uv.users,  max.uv.users,  os.users)

0002: PRINT Max UniVerse users: :max.uv.users

0003: PRINT Current UniVerse users: :uv.users

0004: PRINT OS users  : :os.users

Thanks.  I used the code you shared and some of my own to show the Users, 
RPC connections and the sum.  This will give me a tool to watch the number 
of connections and compare to the occurrences of problems.  Naturally, 
since it is late on Friday afternoon, things are quieting down. 

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
I wrote a pgm that executes !listuser, captures the license counts from 
the output (maybe line 4?), rips that data apart and writes the data to a 
log file (LICENSES).  This job runs every 15 minutes.

I then wrote a program that runs every morning and exports all the data 
to a tab-delimited txt file and E-mails it to the IT management.  Any data 
over 90 days is purged (so my file is fairly static in size).

Management then open it in Excel and make pretty pictures with charts 
and pivot tables.  It allows them to track when we are busy, how many 
licenses we are using, etc.  They have found this to be very helpful.

Maybe this would help.

JRI

You bet.  Management loves numbers.  Is it Unibasic?

Thanks.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Monitoring connections on Unidata

2012-07-06 Thread Charles_Shaffer
Symeon.

Listuser shows rpc connections. The tty shows as udcs,  if it is using a
uniobjects.net pooled connection, the type is pooled, otherwise it is 
udt 

Is total license usage, the listuser plus the udcs connections?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
Having a problem running a Unix script from the crontab.  We use Redhat 
and Unidata 7.1

This script runs fine from command line

UDTHOME=/NTN/CMI
export UDTHOME
UDTBIN=/usr/ud/bin
export UDTBIN
CMIHOME=/NTN/CMI/TRANS4M
export CMIHOME
PATH=$PATH:@UDTBIN
export PATH
cd /NTN/DATA/PRODUCTION
$UDTBIN/udt PHANTOM REQIMPORT_MA

But when it is run by the cron it doesn't seem to run.  We do a lot of 
this sort of thing here, but I have never tried running a script that used 
a PHANTOM command like this.  Does anyone see anything obvious here that 
would not let this run from cron?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
Jeff
Are you running it at the command line as the same user that it runs 
under in cron?

Yes I am.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Jeff Schasny jscha...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   06/28/2012 11:54 AM
Subject:Re: [U2] Problem running script from crontab
Sent by:u2-users-boun...@listserver.u2ug.org




charles_shaf...@ntn-bower.com wrote:
 Having a problem running a Unix script from the crontab.  We use Redhat 
 and Unidata 7.1

 This script runs fine from command line

 UDTHOME=/NTN/CMI
 export UDTHOME
 UDTBIN=/usr/ud/bin
 export UDTBIN
 CMIHOME=/NTN/CMI/TRANS4M
 export CMIHOME
 PATH=$PATH:@UDTBIN
 export PATH
 cd /NTN/DATA/PRODUCTION
 $UDTBIN/udt PHANTOM REQIMPORT_MA

 But when it is run by the cron it doesn't seem to run.  We do a lot of 
 this sort of thing here, but I have never tried running a script that 
used 
 a PHANTOM command like this.  Does anyone see anything obvious here that 

 would not let this run from cron?

 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ___
 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


Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
 lARRY
 Do you have LOGIN paragraph in your VOC file?

Yes and it looks like this.

:AE VOC LOGIN
Top of LOGIN in VOC, 13 lines, 195 characters.
*--: P
001: PA
002: UDT.OPTIONS 82 ON
003: UDT.OPTIONS 43 ON
004: UDT.OPTIONS 43 OFF
005: UDT.OPTIONS 19 ON
006: UDT.OPTIONS 22 ON
007: SP-ASSIGN Q1 HS
008: GN91ACC.X
009: SORT.TYPE 2
010: BASICTYPE 'p'
011: IF @USER.TYPE # 0 THEN GOTO EOJ
012: LOGON.DRIVER
013: EOJ:
Bottom.
*--:
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
 The phantom command will run your login paragraph. Is it setup to 
allow this
 process to go through? There should be something in the _PH_ 
file/folder for
 when the cron fired off.

 hth
 Colin

This is interesting.  There are files being created in the _PH_ directory 
for each run (they are 10 minutes) apart.  But they are empty. This means 
that something failed right off the bat right?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
I rewrote the script to use our in-house methods and now it is working.

#!/bin/ksh
echo `date`  FILES_LOG/ReqImp.LOG 
. /usr/local/set_udt_environ.scr

cd /NTN/DATA/PRODUCTION
$UDTBIN/udtEODFILES_LOG/ReqImp.LOG
PHANTOM REQIMPORT_MA
bye
EOD

Still not sure why it was failing before, but I am moving on.  Thanks for 
your help everyone.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
 If this was UniVerse, I would check the VOC LOGIN paragraph and make 
sure it's not invoking a menu (or something) requiring an Input

 Mark

It is interesting that you said that.  The program that the script is 
calling does exactly that. It is calling menu programs from an ERP package 
and it is feeding the responses to it.  Working now.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Problem running script from crontab

2012-06-28 Thread Charles_Shaffer
George.  RedHat 6.
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Regarding: programming Techinques

2012-06-04 Thread Charles_Shaffer
satya,

You should be able to find documentation on the Rocket site.  If you are 
interested in techniques read the document called Developing Unibasic 
Applications.  There is also a UniBasic Commands Reference for a list 
of commands and how they work.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   satya satya satyapal...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   06/04/2012 11:30 AM
Subject:[U2] Regarding: programming Techinques
Sent by:u2-users-boun...@listserver.u2ug.org



Hi Everyone,

Can any one explain, were we can get the nformation about the
Unidata Programming Logic.

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

-- 
This email was Anti Virus checked by Astaro Security Gateway. 
http://www.astaro.com

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


[U2] AUTO: Charles Shaffer is out of the office (returning 06/04/2012)

2012-05-25 Thread Charles_Shaffer

I am out of the office until 06/04/2012.




Note: This is an automated response to your message  Re: [U2] U2
accounting software question sent on 05/25/2012 12:40:44 AM.

This is the only notification you will receive while this person is away.

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


Re: [U2] Attribute Problem

2012-05-03 Thread Charles_Shaffer
Done.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Martin Braid mbr...@epicor.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   05/02/2012 04:45 PM
Subject:Re: [U2] Attribute Problem
Sent by:u2-users-boun...@listserver.u2ug.org



You've already got the answer. Use F_MATL instead of F-MATL and stop
thinking about it.

-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: 02 May 2012 20:13
To: u2-users@listserver.u2ug.org
Subject: [U2] Attribute Problem

Hi.  I think I have finally gone insane. 

I am having a problem with the attribute MATL.AMT.  It calculates the
extended amount on hand by taking the frozen material cost times the on
hand amount.

The problem is when I use F_MATL for the frozen material cost, MATL.AMT
is good.  When I use F-MATL for the frozen material cost, it returns 0
everytime.

F_MATL and F-MATL are identical and if you list them both work fine.
But when they are used in the calculation F_MATL works, but F-MATL.
doesn't. 
Can anyone see what the problem is?

**
:AE DICT INVENTORY-LOCATION_18 MATL.AMT
Top of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43
characters.
*--: P
001: V
002: ON.HAND * F-MATL
003: MR25,
004: MATERIAL.AMT
005: 13R
006: S
Bottom.

**
:AE DICT INVENTORY-LOCATION_18 F_MATL
Top of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.

***
:AE DICT INVENTORY-LOCATION_18 F-MATL
Top of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.




Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Click
https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg==  to report this email as
spam.


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


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


Re: [U2] Attribute Problem

2012-05-03 Thread Charles_Shaffer
I don't think so.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Boydell, Stuart stuart.boyd...@spotless.com.au
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   05/02/2012 04:32 PM
Subject:Re: [U2] Attribute Problem
Sent by:u2-users-boun...@listserver.u2ug.org



can you DLIST a V type in UD to see how it's compiled?

From: charles_shaf...@ntn-bower.com
Sent: 03-May-12 5:13
To: u2-users@listserver.u2ug.org
Subject: [U2] Attribute Problem

Hi.  I think I have finally gone insane.

I am having a problem with the attribute MATL.AMT.  It calculates the
extended amount on hand by taking the frozen material cost times the on
hand amount.

The problem is when I use F_MATL for the frozen material cost, MATL.AMT is
good.  When I use F-MATL for the frozen material cost, it returns 0
everytime.

F_MATL and F-MATL are identical and if you list them both work fine.  But
when they are used in the calculation F_MATL works, but F-MATL. doesn't.
Can anyone see what the problem is?

**
:AE DICT INVENTORY-LOCATION_18 MATL.AMT
Top of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43 characters.
*--: P
001: V
002: ON.HAND * F-MATL
003: MR25,
004: MATERIAL.AMT
005: 13R
006: S
Bottom.

**
:AE DICT INVENTORY-LOCATION_18 F_MATL
Top of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.

***
:AE DICT INVENTORY-LOCATION_18 F-MATL
Top of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.




Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



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

-- 
This email was Anti Virus checked by Astaro Security Gateway. 
http://www.astaro.com

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


Re: [U2] Attribute Problem

2012-05-03 Thread Charles_Shaffer
I think so.  I went with the underscore.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   George R Smith geo...@grsmith.arcoxmail.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Cc: u2-users-boun...@listserver.u2ug.org
Date:   05/03/2012 07:31 AM
Subject:Re: [U2] Attribute Problem
Sent by:u2-users-boun...@listserver.u2ug.org



Could it be that MATL is being subtracted from F ?
Which of course would not work unless MATL and F
had numeric values

george

-Original Message- 
From: charles_shaf...@ntn-bower.com 
Sent: Thursday, May 03, 2012 7:25 AM 
To: U2 Users List 
Cc: u2-users-boun...@listserver.u2ug.org 
Subject: Re: [U2] Attribute Problem 

Done.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Martin Braid mbr...@epicor.com
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   05/02/2012 04:45 PM
Subject:Re: [U2] Attribute Problem
Sent by:u2-users-boun...@listserver.u2ug.org



You've already got the answer. Use F_MATL instead of F-MATL and stop
thinking about it.

-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: 02 May 2012 20:13
To: u2-users@listserver.u2ug.org
Subject: [U2] Attribute Problem

Hi.  I think I have finally gone insane. 

I am having a problem with the attribute MATL.AMT.  It calculates the
extended amount on hand by taking the frozen material cost times the on
hand amount.

The problem is when I use F_MATL for the frozen material cost, MATL.AMT
is good.  When I use F-MATL for the frozen material cost, it returns 0
everytime.

F_MATL and F-MATL are identical and if you list them both work fine.
But when they are used in the calculation F_MATL works, but F-MATL.
doesn't. 
Can anyone see what the problem is?

**
:AE DICT INVENTORY-LOCATION_18 MATL.AMT
Top of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43
characters.
*--: P
001: V
002: ON.HAND * F-MATL
003: MR25,
004: MATERIAL.AMT
005: 13R
006: S
Bottom.

**
:AE DICT INVENTORY-LOCATION_18 F_MATL
Top of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.

***
:AE DICT INVENTORY-LOCATION_18 F-MATL
Top of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.




Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Click
https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
cXO5UZqptIGHDy7!uJKtCfM2WwvnrwGEQlca1YcpG8Zdg==  to report this email as
spam.


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


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-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Attribute Problem

2012-05-02 Thread Charles_Shaffer
Hi.  I think I have finally gone insane. 

I am having a problem with the attribute MATL.AMT.  It calculates the 
extended amount on hand by taking the frozen material cost times the on 
hand amount.

The problem is when I use F_MATL for the frozen material cost, MATL.AMT is 
good.  When I use F-MATL for the frozen material cost, it returns 0 
everytime.

F_MATL and F-MATL are identical and if you list them both work fine.  But 
when they are used in the calculation F_MATL works, but F-MATL. doesn't. 
Can anyone see what the problem is?

**
:AE DICT INVENTORY-LOCATION_18 MATL.AMT
Top of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43 characters.
*--: P
001: V
002: ON.HAND * F-MATL
003: MR25,
004: MATERIAL.AMT
005: 13R
006: S
Bottom.

**
:AE DICT INVENTORY-LOCATION_18 F_MATL
Top of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.

***
:AE DICT INVENTORY-LOCATION_18 F-MATL
Top of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
*--: P
001: V
002: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
003: MD5,
004: MATERIAL/UNIT
005: 13R
006: S
Bottom.




Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Attribute Problem

2012-05-02 Thread Charles_Shaffer
Not at this point.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org, 
Date:   05/02/2012 02:24 PM
Subject:Re: [U2] Attribute Problem
Sent by:u2-users-boun...@listserver.u2ug.org




F minus Mail

Are you confident the V processer is that brilliant that it can 
distinguish between a name and an operator ?




-Original Message-
From: Charles_Shaffer charles_shaf...@ntn-bower.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Wed, May 2, 2012 12:15 pm
Subject: [U2] Attribute Problem


Hi.  I think I have finally gone insane. 
I am having a problem with the attribute MATL.AMT.  It calculates the 
xtended amount on hand by taking the frozen material cost times the on 
and amount.
The problem is when I use F_MATL for the frozen material cost, MATL.AMT is 

ood.  When I use F-MATL for the frozen material cost, it returns 0 
verytime.
F_MATL and F-MATL are identical and if you list them both work fine.  But 
hen they are used in the calculation F_MATL works, but F-MATL. doesn't. 
an anyone see what the problem is?
**
AE DICT INVENTORY-LOCATION_18 MATL.AMT
op of MATL.AMT in DICT INVENTORY-LOCATION_18, 6 lines, 43 characters.
--: P
01: V
02: ON.HAND * F-MATL
03: MR25,
04: MATERIAL.AMT
05: 13R
06: S
ottom.
**
AE DICT INVENTORY-LOCATION_18 F_MATL
op of F_MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
--: P
01: V
02: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
03: MD5,
04: MATERIAL/UNIT
05: 13R
06: S
ottom.
***
AE DICT INVENTORY-LOCATION_18 F-MATL
op of F-MATL in DICT INVENTORY-LOCATION_18, 6 lines, 93 characters.
--: P
01: V
02: @ID; OCONV(@ID, G0*1); OCONV(@2, TINVENTORY-MASTER*18;X;66;66)
03: MD5,
04: MATERIAL/UNIT
05: 13R
06: S
ottom.


harles Shaffer
enior Analyst
TN-Bower Corporation
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://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] AUTO: Charles Shaffer/NTNBOWER is out of the office (returning 04/09/2012)

2012-04-03 Thread Charles_Shaffer

I am out of the office until 04/09/2012.

I will be out of the office until April 9.  I will respond to your message
when I return.


Note: This is an automated response to your message  Re: [U2] u2ug.net
Website sent on 04/03/2012 4:55:16 PM.

This is the only notification you will receive while this person is away.

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


[U2] AUTO: Charles Shaffer/NTNBOWER is out of the office (returning 03/05/2012)

2012-02-29 Thread Charles_Shaffer

I am out of the office until 03/05/2012.

I will be out of the office until March 5.  I will respond to your message
when I return.


Note: This is an automated response to your message  [U2] XLr8Editor does
code assist sent on 02/29/2012 1:04:26 PM.

This is the only notification you will receive while this person is away.

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


Re: [U2] Brilliant? or not?

2012-01-16 Thread Charles_Shaffer
 I used to have a C programmer working for me that reveled in
 condensing multiple lines of C code to a single statement, much more
 obtuse than that.

 He is no longer employed here.

 Nuff said

 Doug
*
Aside from it not being readable, compacting C code like that can reduce 
portability.  Different compilers may evaluate complex, compacted code 
differently.  Don't ask me how I know that.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Brilliant? or not?

2012-01-16 Thread Charles_Shaffer
It's not about whether somebody can or can't read the code, it is about 
productivity and avoiding errors.  Why should it take 4 seconds to figure 
out a line of code?  4 seconds times a thousand lines of code is over an 
hour of wasted time.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Presentation on Python to UniVerse

2011-12-15 Thread Charles_Shaffer
I would be interested also.

Are you considering posting a white paper on the presentation? And/or 
with slides?
I'd be interested in seeing it, but it's a little far for a roadtrip and 
still be in the next day.

In case anyone is interested, I am doing a presentation to the local 
Python
Users Group - Northern VA, USA - on using ctypes in Python to access
UniVerse.

It's tonight.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Just sharing some info - RHEL 6 and Universe/maybe Unidata as well

2011-12-14 Thread Charles_Shaffer
We use Redhat on some of our systems and do exactly what Symeon says.  We 
get support for the first year and then drop it once the system is stable. 
 In the case of Domino, the IBM support people answer Redhat questions as 
well.  On less critical systems Ubuntu works well.  You can buy Ubuntu 
support just like Redhat.
 
 From: John Thompson
 I'm not going to revert to RHEL 5.7 because I'm afraid, and then in 
 two years have to convert to RHEL 6.x because Red Hat stopped 
 supporting it, and have to go through all of this nonsense again.

Tony
Few people will admit that a decade ago they dumped a commercial OS like
Sun, SCO, AIX, or Windows precisely because Linux was Free, and 
separately
Open Source.  Somehow because of those factors, the idea was that we 
would
never again have to suffer the whims of the cathedral, as the bazaar 
would
provide in bounty all the code changes required for the common good and 
of
all.

Symeon
Yes but there is linux and there is linux - redhat is a commercial 
operating
system with a full support model - you can always go the fedora route 
if you
want to browse the bazaar. Actually many people only take the first 
year
support from redhat - after that there is plenty of bazaar activity for
redhat so you can go ahead and update many parts. The difficulty then 
would
be updating the kernel, you may as well then go the fedora route at 
that
point - or subscribe to the latest redhat, or take your pick of linux 
distro

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects for Java and Domino 8

2011-12-14 Thread Charles_Shaffer
I've used both.  There are syntax differences, especially with the UO,NET 
since it adheres to the CLR.  Both libraries did what I needed.  I don't 
know if UO,NET is a better solution, but it looks to me like it has been 
kept up-to-date better.  I am interested in UOJ because of new 
capabilities in Domino.  The 64-bit issue is going to become important.  I 
guess my real question isn't just whether UOJ will continue to be 
supported, but will it be kept up with new technologies.
 
Hi,

If Rocket is not going to be updating / supporting the original 
UniObjects, we're looking at either creating a wrapper for UO.net, or 
using UOJ.  UOJ is the obvious choice for us, since we're currently 
Domino-based, and Domino supports Java agents.  However, I have the 
impression UO.net may be the better product. 

Are there any users on the list who have experience with both UOJ and 
UO.net?   If so, would you be willing to share a quick assessment of 
their 
comparative value / quality?  From looking through the manuals, it seems 
to me like UO.net has slightly more functionality out of the box, such as 

the native implementation of a data set class.  Is that a valid 
assessment?  And how do they compare in terms of quality?  For example, 
the recent thread was going through issues with UOJ's character encoding. 

Are there similar (or worse) gotchas in UO.net? 

Thanks for any insights you care to share!
Jim Stoner


Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects for Java and Domino 8

2011-12-08 Thread Charles_Shaffer
Tony
It was confirmed that UOJ isn't going away, which is good for
legacy development.
But my whole point was that for new development we don't need it,
never did.

Maybe I am asking the wrong question.  Is there a better way to interface 
Domino 8.5 to Unidata than UOJ?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Tony Gravagno 3xk547...@sneakemail.com
To: u2-users@listserver.u2ug.org, 
Date:   12/08/2011 03:32 PM
Subject:Re: [U2] Uniobjects for Java and Domino 8
Sent by:u2-users-boun...@listserver.u2ug.org



It was confirmed that UOJ isn't going away, which is good for
legacy development.
But my whole point was that for new development we don't need it,
never did.

 From: Charles_Shaffer
 Tony, What you say is true, and those tools would be 
 great in the right situation.  But I am concerned 
 about the future of UOJ.  My understanding is that the 
 new Domino will allow jars to be directly accessed 
 from the Domino Designer.  Just want to make sure that 
 UOJ is not going to be deprecated.
 
 
 Tony said:
 There's no good reason for that condition to exist. 
 Rocket doesn't necessarily need to be the sole 
 provider of language bindings into the platform.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Uniobjects for Java and Domino 8

2011-12-07 Thread Charles_Shaffer
Great information John and Robert.   Looks like UOJ is getting mature. 
In my situation, it is attractive since we use Domino and Unidata 
extensively.  But, I do not want to invest my time in something that won't 
be supported in the future.

My question for Rocket is Will UOJ be further developed and supported by 
Rocket in the future? 

Thanks.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation

Robert said:
Hi John,

On Fri, Dec 2, 2011 at 10:01 AM, John Hester jhes...@momtex.com wrote:
 We've been using UOJ with WebSphere App Server since around 2003.  Not
 quite the same as Domino, I realize, but at least under the same IBM
 Java middleware umbrella.  I can't offer a lot the way of best
 practices, but I can say that the combination is robust and
 trouble-free.  This is more OS related, but if you're connecting to or
 from a linux box you need to make sure the LANG environment variable is
 set correctly.  The RedHat default is incorrect for UOJ (at least up to
 EL 5) and will result in MV delimiters being incorrectly translated into
 other ascii characters.  RedHat EL 5 stores the LANG value in
 /etc/sysconfig/i18n and the official setting I was given by IBM is
 en_US.iso885915.

The above has caused me many problems in both web applications and
running UOJ on mobile devices.

I got a debugger out and went through what is happening, it appears
UOJ is using deprecated routines within java and writing invalid data
to the udcs server. The deprecated routines are using the systems
character encoding to convert 16bit java characters to 8bit bytes.  As
the host systems character encoding is variable thus different data
will be sent to the server depending on what location and operating
system is used.

Roughly the uniobjects conversion routines grab the java system
property file.encoding which is meant for reading and writing files
and use it directly and indirectly to write data to the socket.

Quick fix is on the java command line -Dfile.encoding=iso8859_1
Warning: once java program is running ie
System.setProperty(file.encoding,iso8859_1) does not work as a
bunch of system level stuff is cached on startup.

The above quick fix has many bad side effects as the java process
now has the wrong character encoding to read and write files on the
local system and has caused me issues in third party libraries which
expect to be able to read and write files correctly.  ie my web server
should be emitting utf8 for maximum compatibility but is putting out
iso8859_1 for most files thanks to this quick fix

It would be better for the rocket engineers to decide on a character
encoding to talk to the server with and set it as a separate define(or
hard code it maybe), according to oracle the basic encodings below
should be available on most jvms :
http://docs.oracle.com/javase/1.3/docs/guide/intl/encoding.doc.html
 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects for Java and Domino 8

2011-12-07 Thread Charles_Shaffer
Tony,

What you say is true, and those tools would be great in the right 
situation.  But I am concerned about the future of UOJ.  My understanding 
is that the new Domino will allow jars to be directly accessed from the 
Domino Designer.  Just want to make sure that UOJ is not going to be 
deprecated.


Tony said:
There's no good reason for that condition to exist.  Rocket
doesn't necessarily need to be the sole provider of language
bindings into the platform.  A new API can be wrapped around a
lower-level interface, and any language binding can then
implement that API.  So in a short period of time we could have a
new Java SDK for U2, PHP for U2, Ruby for U2...

A number of people in this community could initiate this over a
weekend.  But there's little motivation for any of us to do so.
Few companies would buy it.  If it's FOSS, as it usually happens,
few would contribute, but a lot of people would report issues,
request new functionality, criticize the documentation, and
eventually burn out anyone volunteering effort.  The net result,
as with many things that are possible with the platform, is that
if it doesn't come from the DBMS provider then this commmunity
simply does without.  Of course we have UOJ and UO.NET, but as
discussed here, when these interfaces have issues, there's only
one place to go for solutions, and sometimes that's just not good
enough or fast enough.

Just sayin...
T

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] End of Month date routine

2011-12-05 Thread Charles_Shaffer
Here's one I use.

TODAY = OCONV(DATE(), D4/)
MO = FIELD(TODAY, /, 1)
YR = FIELD(TODAY, /, 3)
MO += 1
IF MO  12 THEN
   MO = 1
   YR += 1
END
EOM = OCONV((ICONV(MO:/:1:YR) - 1), D4/)

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org, 
Date:   12/05/2011 01:03 PM
Subject:[U2]  End of Month date routine
Sent by:u2-users-boun...@listserver.u2ug.org




Does someone have a routine that, no matter what day you run it, returns 
the End of Month Date ?
(Assume the end of month date, is the calendar end of month date not some 
screwy business date)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

-- 
This email was Anti Virus checked by Astaro Security Gateway. 
http://www.astaro.com

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


Re: [U2] Uniobjects for Java and Domino 8

2011-12-02 Thread Charles_Shaffer
 The RedHat default is incorrect for UOJ (at least up to
 EL 5) and will result in MV delimiters being incorrectly translated 
into
 other ascii characters.

Thanks for the tip.  Looks like we do have a problem with the LANG 
setting. 

LANG=en_US.UTF-8

I'll check with IBM and see if changing it en_US.iso885915 will be OK with 
Domino. 

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects for Java and Domino 8

2011-12-02 Thread Charles_Shaffer
Thanks.  This is very helpful.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Tony Gravagno 3xk547...@sneakemail.com
To: u2-users@listserver.u2ug.org, 
Date:   12/01/2011 10:18 PM
Subject:Re: [U2] Uniobjects for Java and Domino 8
Sent by:u2-users-boun...@listserver.u2ug.org



I follow John's policy in all web integration.  All external
access comes through a single entry point which identifies the
purpose of the connection and transfers to an appropriate
subroutine.  I also include logging abilities in most code, just
in case.  Code below is made up for this example and not
stylistically elegant nor complete. :

SUBROUTINE ENTRY.POINT(QUERY,RESPONSE)
  INCLUDE WEB.COMMON
  * that routine does initialization, logging, breaks up query,
etc
  BEGIN CASE
CASE OPERATION=CUSTINQ
  CALL WEB.CUSTINQ(QUERY,RESPONSE)
CASE 1 ; * bad request
  END CASE
  INCLUDE WEB.EXIT
RETURN

SUBROUTINE WEB.COMMON
  COMMON VARS(100)
  INCLUDE WEB.EQUATES ; * assign name to all VARS
  IF NOT(INITIALIZED) THEN GOSUB INIT
  IF LOGGING THEN GOSUB LOG

RETURN

SUBROUTINE WEB.EXIT
  IF LOGGING THEN GOSUB LOG
  ...
RETURN 

Since all code includes WEB.COMMON, note from above that when
LOGGING is active all routines will log on entry, and all
programs have access to the common LOG function.

HTH
T



 From: John Hester
 Another gotcha I've run into in the past (also not app 
 platform specific) is difficutly isolating bugs in UV 
 subroutines that cause an abort.  The result is a hung 
 unirpc connection and a corresponding consumed 
 license.  If this problem happens in a frequently 
 called subroutine, you can quickly find yourself with 
 no UV licenses left.  To isolate offending 
 subroutines, I created a tracking subroutine that gets 
 called at the beginning of each subroutine...

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Uniobjects for Java and Domino 8

2011-12-01 Thread Charles_Shaffer
Has anyone used Uniobjects for Java with Domino 8?  If so, have you had 
luck with it.  Any best practice suggestions?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects for Java and Domino 8

2011-12-01 Thread Charles_Shaffer
Jim Stoner Said

It would certainly be nice to find a small user group to ask 
questions and bounce around best practices.
I would definitely be interested in that.

I haven't tried using UniObjects for Java with Domino yet, but I have 
used 
the original OLE/COM version of UniObjects in LotusScript agents on 
Domino 
8.5.
The COM library with LotusScript is what I've done in the past as well. 
The direct integration with Java archives is very interesting to me, but I 
haven't gotten into it much yet.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   jim.sto...@esc.edu
To: U2 Users List u2-users@listserver.u2ug.org, 
Date:   12/01/2011 02:53 PM
Subject:Re: [U2] Uniobjects for Java and Domino 8
Sent by:u2-users-boun...@listserver.u2ug.org



Hi,

I'm also interested in any advice / best practices for UO for Java on 
Domino.  It would certainly be nice to find a small user group to ask 
questions and bounce around best practices.

I haven't tried using UniObjects for Java with Domino yet, but I have used 

the original OLE/COM version of UniObjects in LotusScript agents on Domino 

8.5.  We have been using that for some small-scale production jobs for the 

past year, and it has worked really well.  The main problem I have is that 

the OLE/COM version of UniObjects hasn't been updated in years, and it 
doesn't seem to have a 64-bit version.  I have looked for alternatives, 
like trying to register the UO for .Net client as an OLE/COM object, but 
for some reason that only exposes a handful of classes and methods; the 
vast majority of the functionality doesn't seem to be configured to work 
when accessed as an OLE/COM object. 

So unless Rocket releases a 64-bit version of the original UniObjects, my 
fallback plan is to move to UniObjects for Java, but I've been putting it 
off until I have some more time or find other people doing something 
similar to help motivate me.  :-)

Cheers,
Jim Stoner
Lead Programmer/Analyst
SUNY Empire State College
 



From:   charles_shaf...@ntn-bower.com
To: u2-users@listserver.u2ug.org, 
Date:   12/01/2011 03:38 PM
Subject:[U2] Uniobjects for Java and Domino 8
Sent by:u2-users-boun...@listserver.u2ug.org



Has anyone used Uniobjects for Java with Domino 8?  If so, have you had 
luck with it.  Any best practice suggestions?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] guide problem

2011-11-18 Thread Charles_Shaffer
Does anybody know what would cause a segmentation fault while running 
guide?
Red hat   2.6.9-5.ELsmp
Unidata 7.1

Haven't changed the OS or Unidata version for a long time.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] guide problem

2011-11-18 Thread Charles_Shaffer
Well.  It happened while doing all the files and I don't know which file 
it occurred on.  The GUIDE files just stopped outputting.  No GUIDE_BRIEF 
was created.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation



From:   Jeffrey Butera jbut...@hampshire.edu
To: u2-users@listserver.u2ug.org, 
Date:   11/18/2011 01:07 PM
Subject:Re: [U2] guide problem
Sent by:u2-users-boun...@listserver.u2ug.org



  On 11/18/11 14:02, charles_shaf...@ntn-bower.com wrote:
 Does anybody know what would cause a segmentation fault while running
 guide?
 Red hat   2.6.9-5.ELsmp
 Unidata 7.1

 Haven't changed the OS or Unidata version for a long time.

Not offhand -- we're RHEL 5.5 2.6.18-274.el5 with Unidata 7.2.9

I'm sure you've checked, but does it seg fault on the same single file 
or any file you attempt?


-- 
Jeff Butera, Ph.D.
Manager of ERP Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556

...we must choose between what is right and what is easy...
   Dumbledore

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] guide problem

2011-11-18 Thread Charles_Shaffer
 Steve
 You can strace it and maybe the problem will show itself.

strace did show me which file was corrupted.  It was a swp file of a 
SAVEDLIST.  Deleted it and reran guide.  Ran fine.

Thanks everyone.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniBasic Question

2011-10-25 Thread Charles_Shaffer
 Dave
 The next-to-last one may depend on Unidata vs. Universe.  I understand
 that Unidata only 'fetches' the key in the READNEXT while I believe
 Universe grabs both the key and record, due to the construct of the
 database.

I believe that is the case in Unidata.  A SELECT returns a list of IDs. 
That's why your recommendation was confusing me.  In the Unidata 
environment, I would have to read every record in order to apply the 
filter in the loop.  In a case where only a few records are selected from 
a large file, this would create a lot of unnecessary disk activity.  Also, 
you would not be able to SORT the order of the IDs.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniBasic Question

2011-10-25 Thread Charles_Shaffer
 Unless you know the keys to the records you're selecting, even the
 EXECUTE SELECT ... is going to have to read each record, how else
 would it know which records to throw out?

SELECT is definitely faster than EXECUTE SELECT... and I try and use it 
first.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniBasic Question

2011-10-25 Thread Charles_Shaffer
 I don't know if I agree that SELECT is faster.  If you are using
 indexed fields, SELECT is definitely not the good choice.

Are you saying that when there is an index, the system does not need to 
read the record at all?  It just gets the SELECT list from the index?  Is 
this only true in Unidata?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Ardent programmers

2011-09-09 Thread Charles_Shaffer
George
 Doesn't PROC mean Painfull Reading Of Code?

I thought it was short for Proctology.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Ardent programmers

2011-09-09 Thread Charles_Shaffer
 I really don't know what you guys are complaining about.
 My first career position was maintaining and enhancing a system 
written entirely in  RPL (the one from SMI, not that other one)

 Proc is like eating cake compared to RPL.

My first PICK environment used RPL on a Vax with the add-in board.  Ahh, 
just thinking about it makes me break out in a cold sweat.  Padding the 
code with no ops to avoid crossing a page boundary. The equates didn't 
work quite right, so you were stuck with the %1, 1 variables.  Assembly 
language looked real good after that.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




Wjhonson wjhon...@aol.com
Sent by: u2-users-boun...@listserver.u2ug.org
09/09/2011 03:29 PM
Please respond to U2 Users List
 
To: u2-users@listserver.u2ug.org
cc: 
Subject:Re: [U2] Ardent programmers



I really don't know what you guys are complaining about.
My first career position was maintaining and enhancing a system written 
entirely in  RPL (the one from SMI, not that other one)

Proc is like eating cake compared to RPL.


http://knol.google.com/k/will-johnson/rpl-computer-language-by-smi/4hmquk6fx4gu/715#



No it's not the third buffer position of stack 6 it's the sixth buffer 
position of stack 3 !!
Push push push pop add one switch push pop take three chars copy copy push 
pop 

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

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


Re: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?

2011-08-10 Thread Charles_Shaffer
I would say this was an os (Linux ?)  issue and not UV - taking 10-145
seconds to come up with a login prompt is not a uv issue - the network 
or
the os is compromised in some way .

For what it's worth, I experienced the same slowness on logins after 
moving a Linux server to a VM.  Turned out that the RAM needed to be 
bumped up.  Greatly improved, but still not as quick as our Linux on 
non-VM servers.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer?

2011-08-10 Thread Charles_Shaffer
 The strange thing is that it happens enough that we have noticed it but 
not enough the be regular.

That might be an effect of what is going on at the moment.  We are using 
VMWare vSphere.  It has good performance monitoring tools on the 
performance tab.  Try running something known to cause the lag and 
watching CPU, RAM, etc.  Even though the host machine has lots of 
resources, you may have to tweak the resources allocated to your guest.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniSubroutineException

2011-08-09 Thread Charles_Shaffer
That's a decent size.  We're doing some work which can return upwards of 
200k and haven't had any issues.

Any time out settings?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Job won't run

2011-08-08 Thread Charles_Shaffer
 George
 what if you throw a whoami, groups and env into the script and check 
your logfile
 against those values when your on the CL, to see if anything jumps out.

The environment for the remote job did not contain a path to udt.  Not 
exactly sure why this doesn't  affect our other jobs, but I know how to 
fix it now.

Thanks everyone.


Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Job won't run

2011-08-05 Thread Charles_Shaffer
I have run into something I have never seen before.   We exchange a lot of 
data with an AS400 in Chicago.  For many years we have taken the approach 
that the AS400 would submit a job to our UNIX box that would run a script. 
 Many of the scripts run a Unibasic program and send the resulting file 
back to the AS400.  This happens several times a day and we have been 
doing this for many years. 

One job has started doing something odd.  It runs the script and transfers 
the file, but never runs the Unibasic program, so it has been resending an 
old version of the file.  This seems to have started happening 3 days ago. 
 I can log in manually using the same credentials as the remote job, and 
run the script by typing it in at the command line.  It runs perfectly. 
Unibasic program runs, new file is sent to the AS400.  There is joy.

I have checked permissions.  Nothing has changed at the AS400 end. Nothing 
has changed here.  (That we know of).  I have rechecked the code of he 
script and the Unibasic program.  Looks good.  I am stumped.  Here is the 
script code.

#!/usr/bin/ksh
#Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO

LOG=/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG
rm $LOG
touch $LOG
cd /NTN/DATA/CORPORATE

echo `date` Extracting Firm Planned Orders to BOWER_FPO $LOG
$UDTBIN/udtEOD$LOG
RUN GD-BPGM EXTRACT_FPO -N
bye
EOD

echo Sending Firm Planned Orders to AS400 730  $LOG
/usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO
echo `date` Finished sending Firm Planned Orders $LOG

This runs perfectly when run from CL, but not when submitted from the 
AS400.  And ideas?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Job won't run

2011-08-05 Thread Charles_Shaffer
 Did anything change in your VOC LOGIN program/proc/paragraph that might 
be 
 preventing the program from running?

 Susan Lynch
 F. W. Davison  Company, Inc.

I don't think so.  Wouldn't that affect the command line run also?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Job won't run

2011-08-05 Thread Charles_Shaffer
 George
 Since you say it's sending the same file each day, then it's not
 just the Unibasic that is not running, the rm isn't working either,
 otherwise, you would be sending a blank file over and over.

The remove and touch affect the log file.  The data file is cleared in the 
program.  Since the program doesn't execute, the file doesn't change.

* Clear the output file
OUTPUT = /NTN/DATA/CORPORATE/FILES_AS400/BOWER_FPO
PCPERFORM rm :OUTPUT
PCPERFORM touch :OUTPUT

 How are you running this script from the AS400? rsh? If so, has 

The actual command on the AS400 is:
RUNRMTCMD  CMD('/NTN/DATA/CORPORATE/PROCESSES/fpo_as400') 
RMTLOCNAME('xx.xxx.xxx.xx' *IP)   RMTUSER() RMTPWD() 
I looked into this one time and the AS400 is running an rsh underneath.

 has the user that running it on the AS400 changed? 
They say no and I believe them because it would have affecteed many jobs.
This is Redhat and the default shell is bsh.  We run lots of ksh scripts 
on it.  They were ported over from Tru64 many years ago.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




George Gallen ggal...@wyanokegroup.com
Sent by: u2-users-boun...@listserver.u2ug.org
08/05/2011 10:34 AM
Please respond to U2 Users List
 
To: U2 Users List u2-users@listserver.u2ug.org
cc: 
Subject:Re: [U2] Job won't run


Since you say it's sending the same file each day, then it's not
just the Unibasic that is not running, the rm isn't working either,
otherwise, you would be sending a blank file over and over.

How are you running this script from the AS400? rsh? If so, has 
the user that running it on the AS400 changed? Could they be logging
  in under the C Shell? I don't know if Korn scripts will run under csh,
  never really tried it.

George

 -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, August 05, 2011 11:27 AM
 To: U2 Users List
 Subject: [U2] Job won't run
 
 I have run into something I have never seen before.   We exchange a lot
 of
 data with an AS400 in Chicago.  For many years we have taken the
 approach
 that the AS400 would submit a job to our UNIX box that would run a
 script.
  Many of the scripts run a Unibasic program and send the resulting file
 back to the AS400.  This happens several times a day and we have been
 doing this for many years.
 
 One job has started doing something odd.  It runs the script and
 transfers
 the file, but never runs the Unibasic program, so it has been resending
 an
 old version of the file.  This seems to have started happening 3 days
 ago.
  I can log in manually using the same credentials as the remote job,
 and
 run the script by typing it in at the command line.  It runs perfectly.
 Unibasic program runs, new file is sent to the AS400.  There is joy.
 
 I have checked permissions.  Nothing has changed at the AS400 end.
 Nothing
 has changed here.  (That we know of).  I have rechecked the code of he
 script and the Unibasic program.  Looks good.  I am stumped.  Here is
 the
 script code.
 
 #!/usr/bin/ksh
 #Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO
 
 LOG=/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG
 rm $LOG
 touch $LOG
 cd /NTN/DATA/CORPORATE
 
 echo `date` Extracting Firm Planned Orders to BOWER_FPO $LOG
 $UDTBIN/udtEOD$LOG
 RUN GD-BPGM EXTRACT_FPO -N
 bye
 EOD
 
 echo Sending Firm Planned Orders to AS400 730  $LOG
 /usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO
 echo `date` Finished sending Firm Planned Orders $LOG
 
 This runs perfectly when run from CL, but not when submitted from the
 AS400.  And ideas?
 
 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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


Re: [U2] Job won't run

2011-08-05 Thread Charles_Shaffer
 Susan
 Not necessarily - if, for example, you have a branch in your VOC LOGIN 
that 
 varies on usertype or on the login user (eg SYSTEM to avoid having 
Redback 
 processes run some parts of the LOGIN routine, which is one thing that 
we 
 do), you might have inadvertantly caused the user id for this process 
to 
 fail when run by the automated script, but not when run as your user 
id.

My first response was going to be wouldn't it affect our other remotely 
run scripts too?  Then I thought of something.  This is the first time we 
have had a situation where the AS400 initiates a job and then receives a 
file back.  Normally files sent to the AS400 are initiated from here 
either in a program, or from kron.  Jobs from the AS400 are normally 
sending us files.

Not sure why this would be different, but it gives me something to look 
into. 

Thanks for the ideas everybody.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Job won't run

2011-08-05 Thread Charles_Shaffer
I will try the 21.  That might be informative.

I can log in locally as the same user that remotely logs in and run the 
script no problem, including the unidata session. 

Thanks.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




Larry Hiscock lar...@wcs-corp.com
Sent by: u2-users-boun...@listserver.u2ug.org
08/05/2011 11:42 AM
Please respond to U2 Users List
 
To: 'U2 Users List' u2-users@listserver.u2ug.org
cc: 
Subject:Re: [U2] Job won't run


One thing I would do is to add 21 to the end of every line that contains 
a
$LOG or $LOG.  This will redirect any error messages from stderr to the
log file as well.  Then you can check the log file to see if any type of
error is occurring.  It may be that your script isn't even starting udt.

Also curious why you're using the EOD syntax instead of simply doing:

$UDTBIN/udt PHANTOM RUN GD-BPGM EXTRACT_FPO -N

Which would create a como file in _PH_, in which you could also look for
errors.

What happens if you run the script from a Linux command prompt?

BTW, there's nothing in your script that requires ksh.  You could replace
the #!/usr/bin/ksh with either : or #!/usr/bin/bash, and it should run 
fine.

Larry Hiscock
Western Computer Services


-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, August 05, 2011 8:27 AM
To: U2 Users List
Subject: [U2] Job won't run

I have run into something I have never seen before.   We exchange a lot of 

data with an AS400 in Chicago.  For many years we have taken the approach 
that the AS400 would submit a job to our UNIX box that would run a script. 

 Many of the scripts run a Unibasic program and send the resulting file 
back to the AS400.  This happens several times a day and we have been 
doing this for many years. 

One job has started doing something odd.  It runs the script and transfers 

the file, but never runs the Unibasic program, so it has been resending an 

old version of the file.  This seems to have started happening 3 days ago. 

 I can log in manually using the same credentials as the remote job, and 
run the script by typing it in at the command line.  It runs perfectly. 
Unibasic program runs, new file is sent to the AS400.  There is joy.

I have checked permissions.  Nothing has changed at the AS400 end. Nothing 

has changed here.  (That we know of).  I have rechecked the code of he 
script and the Unibasic program.  Looks good.  I am stumped.  Here is the 
script code.

#!/usr/bin/ksh
#Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO

LOG=/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG
rm $LOG
touch $LOG
cd /NTN/DATA/CORPORATE

echo `date` Extracting Firm Planned Orders to BOWER_FPO $LOG
$UDTBIN/udtEOD$LOG
RUN GD-BPGM EXTRACT_FPO -N
bye
EOD

echo Sending Firm Planned Orders to AS400 730  $LOG
/usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO
echo `date` Finished sending Firm Planned Orders $LOG

This runs perfectly when run from CL, but not when submitted from the 
AS400.  And ideas?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

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


Re: [U2] Job won't run

2011-08-05 Thread Charles_Shaffer
 George
 Are you sure it's running ok? Did you remove the output file before you 
ran as that user?

When we first noticed the problem, I logged in as the remote user and ran 
it from CL, and the folks in Chicago saw right away that the records were 
updated.  Orders they were missing were now there.  It definitely seems to 
be related to the difference between logging in locally or remotely.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




George Gallen ggal...@wyanokegroup.com
Sent by: u2-users-boun...@listserver.u2ug.org
08/05/2011 12:52 PM
Please respond to U2 Users List
 
To: U2 Users List u2-users@listserver.u2ug.org
cc: 
Subject:Re: [U2] Job won't run


Are you sure it's running ok? Did you remove the output file before you 
ran as that user?
I say that, because if you ran it ok from the CL as you, then tried as the 
user and it
   didn't update the file, you wouldn't know, would it have been the same 
since you ran
   it from the CL?
Maybe a better test would be to copy a couple random lines of text into 
that file
Then test it.
This way you will know if the file contents are changing?

 -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, August 05, 2011 1:57 PM
 To: U2 Users List
 Subject: Re: [U2] Job won't run
 
 I will try the 21.  That might be informative.
 
 I can log in locally as the same user that remotely logs in and run the
 script no problem, including the unidata session.
 
 Thanks.
 
 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 
 
 
 
 Larry Hiscock lar...@wcs-corp.com
 Sent by: u2-users-boun...@listserver.u2ug.org
 08/05/2011 11:42 AM
 Please respond to U2 Users List
 
 To: 'U2 Users List' u2-users@listserver.u2ug.org
 cc:
 Subject:Re: [U2] Job won't run
 
 
 One thing I would do is to add 21 to the end of every line that
 contains
 a
 $LOG or $LOG.  This will redirect any error messages from stderr to
 the
 log file as well.  Then you can check the log file to see if any type
 of
 error is occurring.  It may be that your script isn't even starting
 udt.
 
 Also curious why you're using the EOD syntax instead of simply doing:
 
 $UDTBIN/udt PHANTOM RUN GD-BPGM EXTRACT_FPO -N
 
 Which would create a como file in _PH_, in which you could also look
 for
 errors.
 
 What happens if you run the script from a Linux command prompt?
 
 BTW, there's nothing in your script that requires ksh.  You could
 replace
 the #!/usr/bin/ksh with either : or #!/usr/bin/bash, and it should run
 fine.
 
 Larry Hiscock
 Western Computer Services
 
 
 -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, August 05, 2011 8:27 AM
 To: U2 Users List
 Subject: [U2] Job won't run
 
 I have run into something I have never seen before.   We exchange a lot
 of
 
 data with an AS400 in Chicago.  For many years we have taken the
 approach
 that the AS400 would submit a job to our UNIX box that would run a
 script.
 
  Many of the scripts run a Unibasic program and send the resulting file
 back to the AS400.  This happens several times a day and we have been
 doing this for many years.
 
 One job has started doing something odd.  It runs the script and
 transfers
 
 the file, but never runs the Unibasic program, so it has been resending
 an
 
 old version of the file.  This seems to have started happening 3 days
 ago.
 
  I can log in manually using the same credentials as the remote job,
 and
 run the script by typing it in at the command line.  It runs perfectly.
 Unibasic program runs, new file is sent to the AS400.  There is joy.
 
 I have checked permissions.  Nothing has changed at the AS400 end.
 Nothing
 
 has changed here.  (That we know of).  I have rechecked the code of he
 script and the Unibasic program.  Looks good.  I am stumped.  Here is
 the
 script code.
 
 #!/usr/bin/ksh
 #Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO
 
 LOG=/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG
 rm $LOG
 touch $LOG
 cd /NTN/DATA/CORPORATE
 
 echo `date` Extracting Firm Planned Orders to BOWER_FPO $LOG
 $UDTBIN/udtEOD$LOG
 RUN GD-BPGM EXTRACT_FPO -N
 bye
 EOD
 
 echo Sending Firm Planned Orders to AS400 730  $LOG
 /usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO
 echo `date` Finished sending Firm Planned Orders $LOG
 
 This runs perfectly when run from CL, but not when submitted from the
 AS400.  And ideas?
 
 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ___
 U2-Users 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] Job won't run

2011-08-05 Thread Charles_Shaffer
 George
 what if you throw a whoami, groups and env into the script and check 
your logfile
 against those values when your on the CL, to see if anything jumps out.

Good idea.  I just ran it from CL with the additional information.  It ran 
fine, and everything looks as I would expect.

Monday morning, I will get a log of the remote job submission and compare.

Thanks.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Charles_Shaffer
John Said
 and sometimes I wish they just stored the lists in a BASIC program as
 dynamic arrays...

There is the READLIST verb.  That takes a list and makes a dynamic array 
with it.  P type uses READSELECT.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Charles_Shaffer
Bill
 But, obviously, not technology to a technologist!  :-)

It was a hard lesson to learn.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Charles_Shaffer
Symeon says

 Javascript inherently works with JSON regardless of any library used.

 It is a fantastic serialisation of data that should be embraced in the 
MV
 world. It fits very well in fact, it handles any level of array nesting 
so
 can manage the 3 (or 4 inc @tm) levels of MV data, it is schemaless and
 weakly typed and fairly compact, so a perfect fit for MV programmers 
and
 data.

Ijust wanted to voice my agreement with Symeon on this.  For me at least, 
a TO_JSON verb in UniBasic would be great.  Most of the programming I've 
done in the last few years has been web applications that use Javascript 
heavily.  I find XML cumbersome so I just rolled my own for data transfer 
from U2 to the browser.  JSON would be better.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Charles Shaffer/NTNBOWER is out of the office

2011-07-07 Thread Charles_Shaffer
I will be out of the office starting  07/07/2011 and will not return until
07/11/2011.

I will be out of the office until June 6.  I will respond to your message
when I return.


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


[U2] Charles Shaffer/NTNBOWER is out of the office

2011-05-29 Thread Charles_Shaffer
I will be out of the office starting  05/25/2011 and will not return until
06/06/2011.

I will be out of the office until June 6.  I will respond to your message
when I return.


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


[U2] Charles Shaffer/NTNBOWER is out of the office

2011-05-25 Thread Charles_Shaffer
I will be out of the office starting  05/25/2011 and will not return until
06/06/2011.

I will be out of the office until June 6.  I will respond to your message
when I return.


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


Re: [U2] Uniobjects - What Is It?

2011-05-23 Thread Charles_Shaffer
Kevin,

when it takes about a couple
of seconds just to spool up the connector and make that first 
connection
I haven't noticed that with the Undiata as much as I have with remote 
mySql connections.  I typically load the HTML and then make many, short 
connections.  The initial connection might be appear to be part of the 
page loading.

The performance is good on the web applications that use UOJ.  The UOJ 
libraries are on the same server as the PHP code.  I prefer using the 
JavaBridge in Zend Server because of the management interface and PHP 
optimization.  The SourceForge project works well also.

Now that's been my experience.  Keep in mind that I am working in an 
intranet.  Our servers don't have to handle more than 100 people.  I don't 
know how it would perform under heavier loads.

As to the PDO connector,
I looked into the PDO, but it was a while back.  It didn't seem to be 
ready.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




Kevin King precisonl...@gmail.com
Sent by: u2-users-boun...@listserver.u2ug.org
05/21/2011 05:50 PM
Please respond to U2 Users List
 
To: U2 Users List u2-users@listserver.u2ug.org
cc: 
Subject:Re: [U2] Uniobjects - What Is It?


Charles, how is the performance using the Java bridge?  That's my #1 
concern
about UO right now (and UOJ by association) - when it takes about a couple
of seconds just to spool up the connector and make that first connection,
it's something to be questioned.  After the connection is established it's
remarkably fast, but the speed of making that connection is not as fast as 
I
personally would prefer.

As to the PDO connector, I did actually look into it. Even with source 
code
I couldn't find the magic combination of things to make it work across
platforms.  That was a few years ago, and my available time these days is
significantly less, as I'm just too busy dreaming up hodge podge 
schemes!
:-)

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

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


Re: [U2] Uniobjects - What Is It?

2011-05-20 Thread Charles_Shaffer
Kevin,

At the time I set this up here, there was no PDO for U2 in PHP, so I 
looked into the UOJ libraries.  Using them requires a bridge.  There is a 
SourceForge project that works well.  I am currently using Zend Server CE. 
 No cost and it does the job, in fact it optimizes the PHP code.

I build a Java class for each project and include it in a java archive 
that I put in the same directory as the UOJ includes.  The java object 
uses Uniobjects for Java to access Unidata.  Although, Uniobjects has a 
rich command set, I have come to the conclusion that the Java layer should 
be minimized as much as possible.  I just use the java to run UniBasic 
subroutines.  It passes in the parameters and returns the result.  This is 
partly to reduce traffic, but mostly because I want to push the database 
logic to the database.

It would be better if there was a PDO for U2, but this approach works.

Here is a example.


In the javascript function make a request object call to PHP on the 
webserver
 
   var XHR = GetXHR();
   var urlstr = getNextId.php;
   urlstr += ?sid= + Math.random();
   XHR.onreadystatechange = function() {
  if(XHR.readyState === 4) {
   // Process the results in XHR.responseText
  } 
   };
   XHR.open(GET,urlstr,true);
   XHR.send(null);
   return; 

*
In PHP create an object from the java archive for the project and call the 
java function.  Must be cataloged.

$cnU2 = new Java('com.ntnbower.webutil.u2ProjectName');
$cnU2-setAccount(PRODUCTION);
echo $cnU2-getNextId();  // This is returned to javascript as reponseText
return;

*
In java

public String getNextId() {
   OpenU2Session();
   UniSubroutine uSub = uSession.subroutine(getNextId, 1);
   uSub.call();
   return uSub.getArg(0);
}

**
In UniBasic.  Get the requested data and return it in RESULT

SUBROUTINE getNextId(RESULT) 
   OPEN 'FILENAME' TO F.NSH THEN
  READU R.NSH FROM F.NSH, 'NEXT_ID' THEN
 RESULT = R.NSH1
 R.NSH1 += 1
 WRITE R.NSH TO F.NSH, 'NEXT_ID'
  END
 CLOSE F.NSH
  END ELSE
 RESULT = -1
  END
   END
RETURN

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




Kevin King precisonl...@gmail.com
Sent by: u2-users-boun...@listserver.u2ug.org
05/19/2011 11:26 PM
Please respond to U2 Users List
 
To: U2 Users List u2-users@listserver.u2ug.org
cc: 
Subject:Re: [U2] Uniobjects - What Is It?


I'm interested to know more about how folks are using UOJ with PHP.  I've
tried making that connection numerous times but .. just haven't been
successful yet.  Big fan of PHP but using the UO connection on Windows is
... less than optimal for my needs.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Uniobjects - What Is It?

2011-05-19 Thread Charles_Shaffer
 What are UniObjects?

Uniobjects are libraries.  Theses can be included in a variety of 
applications and provide access to U2 databases.  On Linux there is 
Uniobjects for Java.  There is a version for .NET.  And there is an older 
COM version that can be used for applications that don't support .NET.

I mainly use the Uniobjects for Java to access data from our Unidata 
system from PHP.  I use some .NET in VB applications.  The COM version is 
used in some Domino agents..

HTH

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects - What Is It?

2011-05-19 Thread Charles_Shaffer
I don't know much about RedBack.  It may provide more developed tools than 
Uniobjects does.  UO gives you libraries that you can use in your 
applicaitons.

 can you briefly describe some real world examples of what kind of 
applications were written with UniObjects?

I use UniObjects to access data from Unidata where our main systems are. 
Examples;

A Visual Basic application for scanning in Invoices and Checks for image 
archiving.  I use the UO libraries in the VB application to retrieve as 
much informatino as possible about the document from Unidata where our 
financials are.  The image and the information  are stored in a Domino 
database and later, after the invoices are paid, the rest of the 
information is gathered using the COM version of the Uniobjects libraries 
in a LotusScript script.

Mostly though.  I use Uniobjects for Java on Linux web servers to provide 
PHP access to data on our Unidata system.  We use web interfaces for 
spending analysis, work orders, crib inventory, production order analysis, 
and shipping,  When I first started working with PICK in the 80s, we had 
to use a pair of programs to manually move data between the PICK 
ennvironment and the native file system.  Now I can validate a field in a 
web browser against our Unidata database, in real time.  This integrates 
the Unidata based information with information from other database 
systems.  Very useful.

Uniobjects comes on the client disk so there is nothing to buy.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Saying Goodbye...

2011-04-26 Thread Charles_Shaffer
 it is all about web integration, smartphones, tablets,
good looking and easily usable UIs. We have a platform on which we can 
do
that easier than most other technologies, but it's about new skills 
blended
with U2, pure U2 doesn't cut it any more.

Well said. 

Rocket needs to create a development kit for mobil devices and then give 
it away to everybody who will take it.  That sounds counter intuitive, but 
look at Microsoft.  I was a charter member of the MSDN.  It was free at 
first.  Gates understood that it is all about the applications.  His goal 
at that point was to get people developing with his tools.  And it worked.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Saying Goodbye...

2011-04-26 Thread Charles_Shaffer
 And as to dot-net... why complicate the hell out of a good thing like 
the
 web? :)

Amen, Brother.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Extreme slow down on Universe periodically

2011-04-08 Thread Charles_Shaffer
 My client is reporting the periodic slow down of their system.  It 
slows
 down to almost the point of a hang.  This affects both existing 
processes
 (menu selections, data entry, reports) and logins.  Their system admins
 (IBM) reports that it is a Universe or application problem.

Curt,

We have been experiencing slowdowns on some servers residing on virtual 
machines.  So far, we are not certain, but we are beginning to suspect 
that we are overloading the network card on our virtual machine.  We often 
see slowness on a web server for example and when we check resources it 
looks OK, but pings are slow and sometimes time out the request. 
Frequently, when we see the slowness on the guests it is followed by our 
Domino server (also on the VM) becoming unresponsive.  This made us think 
network since the Domino server is very network intensive.

This may turn out to not be the case, but it is something to consider.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Does anyone have an MV BASIC cheatsheet?

2011-03-24 Thread Charles_Shaffer
Here's a cheat sheet for the UniBasic debugger:

Thanks Rob.  I can use this.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE

2011-03-16 Thread Charles_Shaffer
I am trying to detect the success of failure of a BASIC program when 
running from UNIX. I was going to use @SYSTEM.RETURN.CODE setting to do 
this, hoping that the exit status of uvsh would reflect the value set 
for @SYSTEM.RETURN.CODE but it appears this is not the case. Does anyone 
know if this works and I am just missing something silly?

Well I use another approach.  It's not pretty, but it works.  This runs 
from a UNIX shell script.

$UDTBIN/udtEODFILES_LOG/CONV_NBCAFG.LOG
RUN IH-BPGM CONV_NBCAFG -N
bye
EOD

In this case the output of the program is redirected to a log file, but if 
there was a way to redirect to a shell variable you could test the 
variable for success or failure.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Uniobjects and java

2011-03-11 Thread Charles_Shaffer
Hey all,
 I am beginning to use uniobjects and java anyone know/have any good 
examples of both accessing the data directly and calling subroutines that 
return data

I have the uniobjects for java manual and I will begin looking at that 
this week-end but any additional code samples would be greatly appreciated 


Thanks

Dougc

I have some examples of using Uniobjects for Java as a connector between 
PHP and Unidata.  If that sounds useful for you, contact me offline and 
I'll send you some examples.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation




Doug Chanco d...@chancofamily.com
Sent by: u2-users-boun...@listserver.u2ug.org
03/11/2011 02:04 PM
Please respond to U2 Users List
 
To: U2 Users List u2-users@listserver.u2ug.org
cc: 
Subject:[U2] Uniobjects and java



email signature

There are 10 kinds of people in the world, those that know binary and 
those that do not

On Mar 10, 2011, at 19:54, Hona, David david.h...@cba.com.au wrote:

 It is my view that you should never manipulate any UniVerse file (even 
directories) from outside UniVerse (especially when it is up)...without 
due care or being aware of the negative impact, etc.
 
 If you must clear SAVEDLISTS, use the vendor supplied CLEAR.FILE 
command. 
 
 If you execute say CREATE.FILE MYUNIXDIR 19, it will create .Type19 
within the UNIX directory created - common sense says you should do so 
too. :-)
 
 UniVerse will always use the correct UMASK you define (which should be 
set in your LOGIN or UV.LOGIN so it is consistently applied for every UV 
process) when you use CREATE.FILE.
 
 Good practise dictates you should use the tools and processes provided 
by the vendor unless there is a very good reason(s) why you should not. Of 
course, experienced and brave souls...can do as they deem fit.
 
 I guess as with all advice on here - use it at your own risk - caveat 
emptor applies :-)
 
 Regards
 David
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
 Sent: Thursday, 10 March 2011 1:17 AM
 To: U2 Users List
 Subject: Re: [U2] User LogOut Cabbage
 
 HI,
 You don't need the .Type19 file.  You can do
  rm -R \SAVEDLISTS\
  mkdir \SAVEDLISTS\
 You do need to make sure the permissions are correct on the directory, 
we have found people not having the correct UMASK so people have trouble 
writing to the directory.
 Tom
 RATEX Business Solutions
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
 Sent: Tuesday, March 08, 2011 8:22 PM
 To: 'U2 Users List'
 Subject: Re: [U2] User LogOut Cabbage
 
 Are you clearing your SAVEDLISTS directory from UNIX (scheduled or 
manually) and then this error appears?
 
 If so, it is probably deleting the required .Type19 entry (within the 
SAVEDLISTS directory.
 
 Possible solution: purge away, but re-create the .Type19 file using 
'touch .Type19' or the like in your UNIX script. )...refrain from doing 
when you have users logged in too. Perhaps use CLEAR.FILE instead from 
within UV instead?
 
 Regards,
 David
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
 Sent: Wednesday, 9 March 2011 9:35 AM
 To: U2 Users List
 Subject: [U2] User LogOut Cabbage
 
 When a user here logs out of UniVerse on HP-Ux, it comes back with 
repeating...
 
Mkpath: @SAVEDLISTS/S.maryann.14 is not a directory
 
 Suggestions would be appreciated.
 
 --Bill
 
 ** IMPORTANT MESSAGE * 
 This e-mail message is intended only for the addressee(s) and contains 
information which may be
 confidential. 
 If you are not the intended recipient please advise the sender by return 
email, do not use or
 disclose the contents, and delete the message and any attachments from 
your system. Unless
 specifically indicated, this email does not constitute formal advice or 
commitment by the sender
 or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its 
subsidiaries. 
 We can be contacted through our web site: commbank.com.au. 
 If you no longer wish to receive commercial electronic messages from us, 
please reply to this
 e-mail by typing Unsubscribe in the subject line. 
 **
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://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] Is this worth rewriting?

2011-03-04 Thread Charles_Shaffer
Rex Gozar Said
 We all want fast and accurate programming.  To improve comprehension,
 you have to write code to (a) reveal its logical structure, and (b)
 reveal the business rules implemented in the code.

I agree.  My first language was C and I went through a phase of cramming 
as much code as I could into one line because the language would let me. I 
came to realize that this a) did not create more efficient code.  The 
compiler has still had to turn it into machine code.  b) Most important. 
It made it very difficult for the programmers that followed.  A great deal 
of the value of code is how quickly and easily it can be debugged and 
modified after it is initially written.  This is a huge factor in terms of 
cost and efficiency.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Is this worth rewriting?

2011-03-04 Thread Charles_Shaffer
Symeon wrote:
 I still think all of these constructs as just sooo basic that if you 
can't
 just read them either which way,  then you had better think about 
another
 career.

Yes, for an experienced UniBasic programmer.  What if there is a new 
programmer, or a programmer that normally works in another language?  The 
simpler and clearer the source code is, the easier, and less costly, it is 
to support.  The source code is the human-machine interface for the 
programmer.  Using clear structures and meaningful variable names is 
always a good idea.

We in the U2 community want the U2 technology to become more widely used. 
When someone looks at UniBasic code and finds it difficult to read, they 
might not find another career, they might just find another environment 
to do the project in.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Unidata programming books?

2011-03-01 Thread Charles_Shaffer
 Can anyone recommend me some good books on this? We're using
 Unidata 7.1. 

Hi.  We also use Unidata 7.1.  A good place to start would be

Developing UniBasic Applications
UniBasic Commands Reference

I downloaded the from IBM a while back.  Should be available from Rocket.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] RPL was Pick History et al

2011-02-08 Thread Charles_Shaffer
I'm thinking it might be good to write up an article about RPL.
If any of you has knowledge of the history of the language, the company, 
etc. you can email me, and we can collaborate on getting it all laid 
out... straight.

Will

In the late 80s I worked with Ultimate Pick on a VAX, running software 
from SMI.  That system used RPL as its native programming language.  This 
was the Ultimate PICK that ran on an add-in board.

RPL was an interesting language.  I remember having to add NOP 
instructions into programs so that a subroutine wouldn't span groups or 
something.  % variables were regular variables, and  variables were file 
buffers.  There was an equate that sort of worked, but I remember it being 
problematic.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


  1   2   3   >