Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux

[Phil Walker]

No David is correct, you are thinking of DATE.FORMAT

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthonys Lists
Sent: Thursday, 9 January 2014 11:11 a.m.
To: U2 Users List
Subject: Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux

On 08/01/2014 06:34, Hona, David wrote:
> Did you use "format.conv" (UNIX / DOS/Windows command) or FORMAT.CONV (TCL 
> command) on the HPUX sourced files that restored - post-restore? This will 
> convert them into the format required for the target system...

I hate to say it, but I think you've missed something crucial ...

iirc FORMAT.CONV doesn't affect file format, rather it changes the date format 
from American to European, so that's the wrong command.

HOWEVER the OP used UVBACKUP / UVRESTORE, the whold point of which is to
*avoid* all these endian problems! UVBACKUP dumps the database as *text*, and 
then UVRESTORE puts it back. So the file should be created on the new system in 
the new endian format without any problems.
>
> There are many options to choose from...see Admin.pdf (In the UV11.1 
> edition, see section 15-21 - PDF page 362 or do a TCL HELP 
> FORMAT.CONV)
>
> A quick google would've revealed to you the following thread... which could 
> be useful as well...
> http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td
> 7144.html
>
>
Bearing in mind I've never done this, what I would try is ...

Do a UVBACKUP at the account level to save the account on the old system.

Delete the contents of the account directory on the new system, then run UV to 
create a new empty account.

UVRESTORE your backup into the directory.

A lot more hassle than a global UVBACKUP / UVRESTORE if you have multiple 
accounts, but it might work.

The other thing is to put a fault call into Rocket, because this ought to work!

I wonder ... could it be because the new system has a newer version of UV, and 
somehow the "account upgrade" mechanism is cutting in and messing up?

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

Re: [U2] Logging program execution in Unidata?

[Phil Walker]

Maybe convert the VOC entries for the programs to R pointers. The r pointer 
would point to a file with the original VOC entry for the program. Then in 
attribute 4 of the R pointer put a security subroutine which logs the calling 
details for each call etc. That way you can gain a picture of when a program is 
called and how often and by who and from where.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian
Sent: Tuesday, 7 January 2014 1:08 p.m.
To: U2-Users@listserver.u2ug.org
Subject: [U2] Logging program execution in Unidata?

We're looking into a major conversion late this year, which will involve 
checking out several thousand programs (mostly opens, reads or writes).  Some 
programs are run many times a day, whereas some were throwaway and haven't been 
touched in years.  It would be great to get some sense of which ones are active.

We unfortunately don't have a wrapper program, wondering if anyone has run into 
this before - is it possible to somehow log when a program is executed in 
Unidata?  Any magic triggers, directory flags or other audit flags that can get 
turned on?

Any ideas gratefully received,
Ian


-
IMPORTANT NOTICE:   This message is intended only for the addressee
and may contain confidential, privileged information.  If you are not the 
intended recipient, you may not use, copy or disclose any information contained 
in the message.  If you have received this message in error, please notify the 
sender by reply e-mail and delete the message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] REPLICATING DATA [OT]

[Phil Walker]

I did not think Windows Server 2003 was still supported by Microsoft

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ard956
Sent: Thursday, 5 September 2013 7:27 a.m.
To: U2 Users List
Cc: u2-users@listserver.u2ug.org
Subject: Re: [U2] REPLICATING DATA

We are on Windows Server 2003.


Sent from my iPad

On Sep 3, 2013, at 1:45 PM, Wols Lists  wrote:

> On 03/09/13 18:33, Ard956 wrote:
>> and we would keep replication in place as a DR solution.
> What OS are you on?
> 
> Given that, I'd be inclined to use rsync - DBPAUSE the database to 
> make sure it's quiescent, run an rsync, and then bring the database back.
> 
> Dunno what the Windows equivalent of rsync is, but if you're backing 
> up across machines, rsync tries to not copy stuff that hasn't changed.
> 
> Cheers,
> Wol
>> 
>> 
>> Sent from my iPad
>> 
>> On Sep 3, 2013, at 1:30 PM, Ard956  wrote:
>> 
>>> We are moving our servers to a new colo and wanted to replicate from the 
>>> server in the old colo to the one in the new colo and then flip over to the 
>>> new server one weekend.  Looking to have minimal down time.  
>>> 
>>> 
>>> Sent from my iPad
>>> 
>>> On Sep 3, 2013, at 12:26 PM, Baker Hughes  wrote:
>>> 
 Andrea - are you wanting to replicate for the purposes of having a warm 
 backup as DR solution, or for reporting from, or some (what) other purpose?
 
 This question will dictate the strategy and what tools to employ.  We 
 copied the entire db every night to a hot system for Business Analysis.  
 That was put in place before EDA was available.
 
 You could spend a lot of resources and time cobbling a 'replication 
 solution' into place, while trying to dodge an upgrade... and perhaps 
 spend more and have less satisfactory results than proceeding with 
 standard methodology (upgrade to get the new toolset).
 
 HTH.
 -Baker
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ard956
 Sent: Tuesday, September 03, 2013 11:19 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] REPLICATING DATA
 
 Does anyone do replication with a tool outside of the U2 toolbox?  We are 
 on UV 10.2.10 which does not support UV replication.  We have no plans to 
 upgrade at this time but need a backup for our Universe server.  Our 
 database is about 180GB.
 
 Thank you,
 
 Andrea Dente
 Taylored Services
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

[Phil Walker]

Should line 73 of your program be < rather than > for the time as when the date 
has changed, the time will be less than the time of the date - 1 which you have 
just set.


0068   DATE.NOW = DATE()
0069   TIME.NOW = TIME()

0073   IF DATE.NOW # DATE() AND TIME() > TIME.NOW THEN DATE.NOW = DATE()

Example:

DATE.NOW = 16789
TIME.NOW = 83999

DATE() = 16790
TIME() = 1

Might be wrong



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Wednesday, 28 August 2013 4:26 a.m.
To: U2 Users List
Subject: Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

That is awesome information Troy!  Thanks for that!

(Now if I could just get my production environment upgrade to 11.1x :D )

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy 
(Contractor, Logitek Systems)
Sent: Tuesday, August 27, 2013 10:03 AM
To: U2 Users List
Subject: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

Regarding the recent discussion of using indexes as triggers, I use the 
following to update timestamps of record changes to a master item stats file 
that we use for controlling updates to a business warehouse (BW).   Without 
modifying hundreds of legacy programs to support proper timestamps in the 
primary records, I added the following indexed Idescriptors to files I need to 
track.   We are on universe 11.1.1 and this has been working well for over a 
year.

DICT AR-INVOICE INDEX..MODIFIEDZ
0001 I
0002 SUBR("ZIDESC.ITEMSTATS.UPDATE", "AR-INVOICE!":F0,"")
0004 \
0005 1L
0006 S
0049 used to create item created, modified, delete in zitemstats file - create 
index with this and no.nulls keyword EOI 216 bytes

In this example, we have a AR-INVOICE header record and a related ARLI line 
item file.   For our purposes to keep in sync with the BW, we want to timestamp 
the corresponding header record whenever a line item is updated so the ARLI 
dict item also updates AR-INVOICE header ZITEMSTATS with an "I" indirect update 
flag.

DICT ARLI INDEX..MODIFIEDZ
0001 I
0002 SUBR("ZIDESC.ITEMSTATS.UPDATE", 
"ARLI!":F0,""):SUBR("ZIDESC.ITEMSTATS.UPDATE", "AR-INVOICE!":F1,"I")
0004 \
0005 1L
0006 S
0049 used to create item created, modified, delete in zitemstats file - create 
index with this and no.nulls keyword EOI 264 bytes

Alternate Key Index Summary for file ARLI File... ARLI Indices 
3 (0 A-type, 0 C-type, 0 D-type, 3 I-type, 0 SQL, 0 S-type) Index Updates.. 
Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field num/I-type
INDEX..MODIFIEDZ INot Reqd  No Yes  SL NSUBR("ZIDESC.ITE
MSTATS.UPDATE",
"ARLI!":F0,""):S
UBR("ZIDESC.ITEM
STATS.UPDATE", "
AR-INVOICE!":F1,
"I")


Subroutine ZIDESC.ITEMSTATS.UPDATE:

0001 SUB (RETURN.VALUE, ZITEMSTATS.ID, OPTIONS)
0002 * updates zitemstats with timestamps; create, modified, deleted
0003 *
0004 * Revision history:
0005 *
0006 * tdb.1190 2012-04-22_1602 new
0007 *
0008 *
0009 * input:  ZITEMSTATS.ID item id to use for ZITEMSTATS file
0010 * OPTIONS
0011 *I  update attb 5 with "I" for indirect 
reference
0012 *
0013 * output: RETURN.VALUE  NULL
0014 *
0015 * common vars: /ZITEMSTATS/
0016 *
0017 * called by:  INDEX..MODIFIEDZ dictionary items
0018 * calls:
0019 *
0020 * notes:
0021 *
0022 *
0023 $OPTIONS TIME.MILLISECOND
0024 *
0025 * @idx.iotype = 0 - Not being used from an index;
0026 * 1 - INSERT (new) record;
0027 * 2 - DELETE record;
0028 * 3 - Derive old index value;
0029 * 4 - Derive new index value;
0030 *
0031 COMMON /ZITEMSTATS/ F.ZITEMSTATS, ZITEMSTATS.FLAG.OPEN, ZITEMSTATS.WHO
0032 *
0033 EQU NUL TO ""
0034 *
0035 RETURN.VALUE = NUL
0036 *
0037 * the following handles initial call and logto commands
0038 *
0039 IF NOT(ZITEMSTATS.FLAG.OPEN) OR (@WHO # ZITEMSTATS.WHO) THEN
0040   OPEN "ZITEMSTATS" TO F.ZITEMSTATS ELSE
0041 RETURN ;*  to caller.
0042   END
0043 *
0044   ZITEMSTATS.FLAG.OPEN = 1
0045   ZITEMSTATS.WHO   = @WHO
0046 END
0047 *
0048 LOG.TYPE = NUL
0049 *
0050 BEGIN CASE
0051   CASE @IDX.IOTYPE = 0
0052 *
0053   CASE @IDX.IOTYPE = 1
0054 LOG.TYPE = "C" ;* new - created - easier to see than 'N' new
0055 *
0056   CASE @IDX.IOTYPE = 2
0057 LOG.TYPE = "D" ;* delete
0058 *
0059   CASE @IDX.IOTYPE = 3
0060 *
0061   CASE @IDX.IOTYPE = 4
0062 LOG.TYPE = "M" ;* modified
0063 *
0064 END CASE
0065 *
0066 IF LOG.TYPE # NUL THEN
0067 *
0068   DATE.NOW

Re: [U2] @RECORD VARIABLES

[Phil Walker]

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 
To: U2 Users List , 
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.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

Re: [U2] Universe Configuration --

[Phil Walker]

The RLOWNER parameter relates to record shared locks and were introduced to 
Universe when the SQL syntax was. The value determines the number of slots 
available to hold the user information of the processes holding the shared 
locks. If any shared locks are held against a record an exclusive lock, READU 
or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use 
SQL or specifically request a READL lock in basic then you can basically ignore 
it I believe from memory.

Regards

Phil

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, 15 August 2013 6:06 a.m.
To: 'U2 Users List'
Subject: [U2] Universe Configuration --

Can anyone provide a cogent explanation of the RLOWNER configuration parameter 
in UV?  How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ?
What are the contents & duration of an associated entry?  Is there any way to 
determine the number in use (as opposed to the configured number)?

The manual's explanation is a bit short.  Thanks,

Rick Nuckolls

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

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

[Phil Walker]

That is not the point. Why should I have to do a workaround to get around 
something which should just work.

I cannot see what would be so hard about allowing the debugging of programs 
which access a file with a trigger associated with it without aborting which UV 
currently does. That as  a minimum. Hey it might even be good to be able to 
debug he trigger itself. Yes I could build a framework to call the trigger 
subroutine with the appropriate arguments, but why should I have to.

Why is it so hard to do things? Mostly, I don't get that feeling with SQL, 
although to be fair MV has lot better string handling via build in functions, 
but then again SQL has the CLR capability in which I can build most of the MV 
string handling functions. Has anyone done this BTW?

Sorry for the rant guys, but just pent up years of frustration.

Cheers

Phil

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Thursday, 1 August 2013 9:33 p.m.
To: U2 Users List
Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using 
DEBUG or RAID with them? Was: Universe Triggers

Now that (from UV10.1) Index-based triggers are officially supported, can these 
replace your SQL-based triggers? These have less functionality and less 
overhead, but that's the price you have to pay

Can't say I had a chance to try it for myself...yet...!



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

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

On 7/26/2013 12:33 PM, Phil Walker wrote:
> I won't be holding my breath Charles ;-)
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles 
> Stevenson
> Sent: Friday, 26 July 2013 9:22 p.m.
> To: U2 Users List
> Subject: Re: [U2] Universe Triggers
>
> re. triggers & Raid,  I could not agree with Phil more.  Well said.
> Come on, Rocket!
>
> On 7/19/2013 1:32 AM, Phil Walker wrote:
>> Ken,
>>
>> I am glad you raised the issue about debugging a program with a file which 
>> has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
>> ages about fixing this pushing for the ability to be able to step into the 
>> trigger code, but at a VERY MINIMUM being able to debug the program and 
>> perform the write on the file, and in effect step over the trigger 
>> subroutine and carry on debugging. The issue is the trigger subroutine 
>> cannot support input, so what UV have done is basically say you are using 
>> the debugger so you are inputting debug commands so you will abort. They 
>> need to turn this restriction off for debugging so that either of the above 
>> two scenarios is supported.
>>
>> In a Microsoft world I can debug anything through the connected world of 
>> web/databases etc..
>>
>> Have had no feedback from UV
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
>> Sent: Friday, 19 July 2013 9:48 a.m.
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] Universe Triggers
>>
>> Dan,
>> In addition to the other responses you have received, I suggest the 
>> following:
>> 1. Have one master file trigger subroutine (globally catalogued) that calls 
>> subroutines (locally catalogued) tailored to individual files.  This means 
>> you don't have to stop and restart Universe when a new trigger is required 
>> or a change to an existing one.  If the master subroutine changes, you do 
>> have to restart Universe.
>> 2. Use a control record that records the subroutine name and state of the 
>> trigger for each file having a trigger.
>> 3. Use a program to change the state of a trigger, using the control records 
>> in 2 above.
>> 4. Make sure all background processes that have a file with a trigger open 
>> are logged out when recompiling the subroutine for that file trigger.
>> 5. Remember that you can't do anything to a file with an active trigger 
>> whilst in the RAID debugger (it will crash).  Rather, if you are testing a 
>> file trigger subroutine, drop the trigger and use a trigger testing program 
>> that calls the subroutine after taking a copy of the record being changed, 
>> pausing whilst 

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

[Phil Walker]

I know we use them, but whenever one of the programmers wants to debug a 
program they take them off, which causes us other problems as we have processes 
which rely on the trigger output.

This would be my biggest beef with UV at the moment.

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

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

On 7/26/2013 12:33 PM, Phil Walker wrote:
> I won't be holding my breath Charles ;-)
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles 
> Stevenson
> Sent: Friday, 26 July 2013 9:22 p.m.
> To: U2 Users List
> Subject: Re: [U2] Universe Triggers
>
> re. triggers & Raid,  I could not agree with Phil more.  Well said.
> Come on, Rocket!
>
> On 7/19/2013 1:32 AM, Phil Walker wrote:
>> Ken,
>>
>> I am glad you raised the issue about debugging a program with a file which 
>> has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
>> ages about fixing this pushing for the ability to be able to step into the 
>> trigger code, but at a VERY MINIMUM being able to debug the program and 
>> perform the write on the file, and in effect step over the trigger 
>> subroutine and carry on debugging. The issue is the trigger subroutine 
>> cannot support input, so what UV have done is basically say you are using 
>> the debugger so you are inputting debug commands so you will abort. They 
>> need to turn this restriction off for debugging so that either of the above 
>> two scenarios is supported.
>>
>> In a Microsoft world I can debug anything through the connected world of 
>> web/databases etc..
>>
>> Have had no feedback from UV
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org 
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
>> Sent: Friday, 19 July 2013 9:48 a.m.
>> To: u2-users@listserver.u2ug.org
>> Subject: Re: [U2] Universe Triggers
>>
>> Dan,
>> In addition to the other responses you have received, I suggest the 
>> following:
>> 1. Have one master file trigger subroutine (globally catalogued) that calls 
>> subroutines (locally catalogued) tailored to individual files.  This means 
>> you don't have to stop and restart Universe when a new trigger is required 
>> or a change to an existing one.  If the master subroutine changes, you do 
>> have to restart Universe.
>> 2. Use a control record that records the subroutine name and state of the 
>> trigger for each file having a trigger.
>> 3. Use a program to change the state of a trigger, using the control records 
>> in 2 above.
>> 4. Make sure all background processes that have a file with a trigger open 
>> are logged out when recompiling the subroutine for that file trigger.
>> 5. Remember that you can't do anything to a file with an active trigger 
>> whilst in the RAID debugger (it will crash).  Rather, if you are testing a 
>> file trigger subroutine, drop the trigger and use a trigger testing program 
>> that calls the subroutine after taking a copy of the record being changed, 
>> pausing whilst you change it in another session, and then resuming, calling 
>> the subroutine.
>>
>> If you would like samples of any of the software mentioned above, let me 
>> know, and I can send them to you.
>>
>> Regards,
>> Ken Ford
>> Universe Software Developer
>> t 07 3013 8605 | f 07 3002 8400
>> e ken.f...@firstmac.com.au | w firstmac.com.au
>

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

Re: [U2] Universe Triggers

[Phil Walker]

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

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

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

On 7/19/2013 1:32 AM, Phil Walker wrote:
> Ken,
>
> I am glad you raised the issue about debugging a program with a file which 
> has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
> ages about fixing this pushing for the ability to be able to step into the 
> trigger code, but at a VERY MINIMUM being able to debug the program and 
> perform the write on the file, and in effect step over the trigger subroutine 
> and carry on debugging. The issue is the trigger subroutine cannot support 
> input, so what UV have done is basically say you are using the debugger so 
> you are inputting debug commands so you will abort. They need to turn this 
> restriction off for debugging so that either of the above two scenarios is 
> supported.
>
> In a Microsoft world I can debug anything through the connected world of 
> web/databases etc..
>
> Have had no feedback from UV
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
> Sent: Friday, 19 July 2013 9:48 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Universe Triggers
>
> Dan,
> In addition to the other responses you have received, I suggest the following:
> 1. Have one master file trigger subroutine (globally catalogued) that calls 
> subroutines (locally catalogued) tailored to individual files.  This means 
> you don't have to stop and restart Universe when a new trigger is required or 
> a change to an existing one.  If the master subroutine changes, you do have 
> to restart Universe.
> 2. Use a control record that records the subroutine name and state of the 
> trigger for each file having a trigger.
> 3. Use a program to change the state of a trigger, using the control records 
> in 2 above.
> 4. Make sure all background processes that have a file with a trigger open 
> are logged out when recompiling the subroutine for that file trigger.
> 5. Remember that you can't do anything to a file with an active trigger 
> whilst in the RAID debugger (it will crash).  Rather, if you are testing a 
> file trigger subroutine, drop the trigger and use a trigger testing program 
> that calls the subroutine after taking a copy of the record being changed, 
> pausing whilst you change it in another session, and then resuming, calling 
> the subroutine.
>
> If you would like samples of any of the software mentioned above, let me 
> know, and I can send them to you.
>
> Regards,
> Ken Ford
> Universe Software Developer
> t 07 3013 8605 | f 07 3002 8400
> e ken.f...@firstmac.com.au | w firstmac.com.au

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

Re: [U2] Autologout

[Phil Walker]

Sort of, you would have to conditionally use the command in a Paragraph or like 
to do this I believe.

LOGIN
PA
IF [skipautologout = true] GO SKIPAUTOLOGOUT
AUTOLOGOUT
SKIPAUTOLOGOUT:
NEXTCOMMAND

Would be nice if UV could interrogate the ENV in one line e.g.

IF ENV.AUTOLOGOUT = 1 THEN GO SKIPAUTOLOGOUT
AUTOLOGOUT

Alas but it can't at least in the manner like above.

Cheers

Phil

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Thursday, 25 July 2013 7:56 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Autologout

This is probably a simple question but I can't seem to figure it out, is there 
a way to exempt users from autologout?

 

Jake Holt l samsill l Information Technology Director

(817) 759-8038 l jh...@samsill.com  

www.samsill.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] Universe Triggers

[Phil Walker]

Ken,

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

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

Have had no feedback from UV

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

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

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

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


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

Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7

[Phil Walker]

Yes,  that is it. I always though it strange that the 64 bit ones are under 
system 32, and 32 under 64sort of reverse psychology.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Thursday, 18 July 2013 11:11 a.m.
To: U2 Users List
Subject: Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7

\windows\syswow64

With Microsoft typical logic this is where 32 bit versions of commands reside 
on x64. 64 bit ones are in system32.

Sent from my cell phone.

On 2013-07-17, at 3:50 PM, "Phil Walker"  wrote:

> You need to use the 32bit ODBC Driver Manager which is under the a WOW64??? 
> directory or something similar. I don't have access to a system at the 
> moment.
> 
> And then use the 32bit ODBC Driver.
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman
> Sent: Thursday, 18 July 2013 10:35 a.m.
> To: U2 Users List
> Subject: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7
> 
> The shipping clerk's XP PC died.
> 
> I bought him a new Win7 PC.  I guess I made the mistake of installing the 
> 64-Bit Rocket ODBC.
> 
> When I tried to do an ODBC mapping, the United Parcel Service WorldShip 
> desktop software indicated something like an architecture incompatibility 
> when trying to connect to UniVerse 10,3.6 running on HP-Ux Itanium.
> 
> Even though I uninstalled the 64-bit ODBC from Win7... the 64 bit ODBC still 
> appears in the Win7 Control Panel, Administrative Tools, ODBC Data Sources.
> 
> Help sorting all this out would be appreciated.
> 
> --Bill
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7

[Phil Walker]

You need to use the 32bit ODBC Driver Manager which is under the a WOW64??? 
directory or something similar. I don't have access to a system at the 
moment.

And then use the 32bit ODBC Driver.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman
Sent: Thursday, 18 July 2013 10:35 a.m.
To: U2 Users List
Subject: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7

The shipping clerk's XP PC died.

I bought him a new Win7 PC.  I guess I made the mistake of installing the 
64-Bit Rocket ODBC.

When I tried to do an ODBC mapping, the United Parcel Service WorldShip desktop 
software indicated something like an architecture incompatibility when trying 
to connect to UniVerse 10,3.6 running on HP-Ux Itanium.

Even though I uninstalled the 64-bit ODBC from Win7... the 64 bit ODBC still 
appears in the Win7 Control Panel, Administrative Tools, ODBC Data Sources.

Help sorting all this out would be appreciated.

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

Re: [U2] CentOS with Universe?

[Phil Walker]

Hi Dan,

When will Universe be 64-bit? This year, next year, never. I am not after 
specific dates, but is it on the project lifeline?

Cheers

Phil

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, 18 July 2013 2:57 a.m.
To: U2 Users List
Cc: U2 Users List
Subject: Re: [U2] CentOS with Universe?

While CentOS is effectively RHEL, and generally speaking, runs fine, there is 
always the chance that a difference is introduced (say an environment 
difference on the machine that compiled the source) that could adversely 
support UniVerse. CentOS 32-bit will be easier for you as our RHEL port is 
currently 32-bit. 

CentOS is not a Rocket supported OS. Rocket may require you to reproduce a 
reported issue on a supported platform. 

As a word of caution, we commonly work with OS providers (and sometimes 
hardware providers) to determine the root cause of an issue. With RHEL support, 
we have someone to work with, with CentOS we do not. 

Regards,
Dan

On Jul 17, 2013, at 7:42 AM, "Dawn Wolthuis"  wrote:

> We have a VAR who would prefer to load Universe and their application 
> on a supported platform, but we would prefer not to pay for RHEL 6. I 
> searched the list and found a few tidbits, but does anyone have a good 
> list of what changes might be required to successfully run Universe 
> 11.1 on CentOS? How much pain would we be introducing for ourselves 
> and our VAR, if they were willing to play along?
> 
> Thanks.  --dawn
> --
> Dawn M. Wolthuis
> 
> Take and give some delight today
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Any advantages to UV on 64-bit OS?

[Phil Walker]

Hi John,

We are building on that platform but have not deployed to production yet.

64-Bit RHEL 6
VMWare
140+ users

The issue I had was that I was wanting to deploy the Microsoft ODBC Driver 
Manager and driver for Linux which is only 64-bit, and so while I got it 
working in isolation on the Linux box well, I could not link it to Universe as 
like you say it is only 32-bit. You could use another 32 bit Manager and driver.

Cheers

Phil

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
Sent: Friday, 12 July 2013 9:36 a.m.
To: U2 User Group List
Subject: [U2] Any advantages to UV on 64-bit OS?

Hi all,

 

I'm planning to upgrade our UV installation later this year primarily
due to the age of the hardware (it's just over 5 years old).   We aren't
having any serious performance problems.  We're currently running UV
10.2.7 on RedHat EL 5.1 32-bit and typically max out around 100 concurrent 
users.  Since I probably won't upgrade again for another 5 years, I'd like to 
make the upgrade as future-proof as possible.
Because UV is still a 32-bit app, though, I'm wondering if there is any 
real-world benefit to switching to 64-bit RedHat when I upgrade.  I know the 
64-bit kernel will remove the 4GB memory ceiling, but AFAIK, there is also a 
special 32-bit kernel for that.  We also link UV to MS SQL via a 3rd party ODBC 
driver and accept JDBC and UOJ connections.  I have to make sure that 
functionality isn't broken, and I recall someone recently posting that a 64-bit 
OS broke ODBC for them.  Is anyone else successfully using ODBC, JDBC, and UOJ 
with 64-bit linux?  Can anyone point out any advantages to running UV on a 
64-bit OS?

 

Thanks,

John

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

[Phil Walker]

You should use uvsh rather than uv and you also need to consider multiple cron 
jobs running as the same user at the same time as Universe does not like this 
or never used to at least.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Thursday, 11 July 2013 10:51 a.m.
To: U2 Users List
Subject: Re: [U2] [UV] Auto Starting Applications

You can certainly launch a UV process from a unix script.
e.g.

#!/usr/bin/bash
cd /$path_to_uv_account/$ACCOUNTNAME
$UVHOME/bin/uv "phantom PROGRAMNAME" >> /somedir/log1.txt $UVHOME/bin/uv "LIST 
SOMEFILE DICTITEM1 DICTITEM2" >> /somedir/log2.txt

You can call this from cron too if required.

Cheers
Peter


Peter Cheney

Universe Engineer

t 07 3017 8837 | f 07 3002 8400

e peter.che...@firstmac.com.au | w www.firstmac.com.au




From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King 
[ke...@precisonline.com]
Sent: Thursday, 11 July 2013 8:34 AM
To: U2 Users List
Subject: Re: [U2] [UV] Auto Starting Applications

Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d 
(depending on Linux)?


On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor wrote:

> What techniques are you folks using to start up apps when UniVerse on 
> Linux is started?  Obviously hooking into uv.rc is an option.  Are 
> there others?
>
> Thanks.
> Perry
>
> Perry Taylor
> Senior MV Architect
> Office (877) 494-7633 ext. 4392
> Direct (502) 779-4392
> ZirMed
> 888 West Market Street, Suite 400
> Louisville, KY 40202
> www.zirmed.com
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail message, including any 
> attachments, is for the sole use of the intended recipient(s) and may 
> contain confidential and privileged information.  Any unauthorized 
> review, use, disclosure or distribution is prohibited. ZirMed, Inc. 
> has strict policies regarding the content of e-mail communications, 
> specifically Protected Health Information, any communications 
> containing such material will be returned to the originating party 
> with such advisement noted. If you are not the intended recipient, 
> please contact the sender by reply e-mail and destroy all copies of 
> the original message.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] File type 30 (dynamic)

[Phil Walker]

The other option is to use something like syslog (you did not say your OS I 
believe) and then use something like splunk to query the logs, a great tool 
that you can customise for dashboarding, searching etc. That way Linux will 
administer the maintenance of them.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, 10 July 2013 7:54 a.m.
To: 'U2 Users List'
Subject: Re: [U2] File type 30 (dynamic)

Scott

The idea behind a dynamic file is to spread the pain of administration over the 
lifetime of an application. So yes, there are overheads and whilst a well-sized 
static file will outperform it, a dynamic file in turn will normally outperform 
a badly sized static file.

There are some caveats, mostly relating to accessing the file outside of the 
database. If you use an OS level backup or snapshot, or anything that looks at 
these from the OS level, you need to make sure your dynamic files are closed OR 
you have paused your database - Universe holds runtime dynamic file parameters 
in shared memory and without those getting written back to the file header 
(which happens in the pause) the files will break if you restore them.

Most of the prejudice against them goes back to the old PICKies who migrated to 
Universe at a time when they weren't particularly stable and had performance 
issues around concurrency with the way they effectively single threaded their 
sizing operations. They were also doubly expensive on UNIXes that had tight 
limitations on the number of open (OS level) files. But that was a long time 
ago.


Brian


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Scott Zachary
Sent: 09 July 2013 17:15
To: u2-users@listserver.u2ug.org
Subject: [U2] File type 30 (dynamic)

I have very little experience with using dynamic (type 30) files and I'm 
looking for some pointers in that regard. I have a file that I am considering 
creating as a dynamic file. The file will be a log file with sequential numeric 
keys. The record size will normally range from about 200 to 700 bytes, with a 
probable maximum size of less than 1,000 bytes. We expect the file to 
continually grow without deletions and we will likely purge it annually. What 
are the pro's and con's of creating this file as type 30 verses other file 
types?

Thanks, 

Scott Zachary
UniVerse Developer
Gardens Alive! Inc



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


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

Re: [U2] File type 30 (dynamic)

[Phil Walker]

I would probably use a distributed file, with a key based on some date elemen, 
e.g. month. That way you can add partfiles as a month happens and each file 
would be a static file of a standard size optimized for the number and size of 
records expected for that month. You can then have a rolling 12-month window 
without the disruption of having to add/delete records during the same 
timeframe as you would for purging a dynamic file.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
Sent: Wednesday, 10 July 2013 6:01 a.m.
To: U2 Users List
Subject: Re: [U2] File type 30 (dynamic)

Once you start splitting groups, there's overhead on every write where that 
occurs, possibly creating a bottleneck. Dynamic files are good for files with 
non-consistent item sizes, and also for files with oversized items, but that's 
not the case here. I'd go with a "wide & shallow" static file for this purpose, 
even if you  had to make it distributed to account for size. Since most of what 
you'll do with this file is write to it, I wouldn't worry too much about empty 
groups.
 
> Date: Tue, 9 Jul 2013 09:15:20 -0700
> From: szach...@gardensalive.com
> To: u2-users@listserver.u2ug.org
> Subject: [U2] File type 30 (dynamic)
> 
> I have very little experience with using dynamic (type 30) files and 
> I'm looking for some pointers in that regard. I have a file that I am 
> considering creating as a dynamic file. The file will be a log file 
> with sequential numeric keys. The record size will normally range from 
> about 200 to 700 bytes, with a probable maximum size of less than 
> 1,000 bytes. We expect the file to continually grow without deletions 
> and we will likely purge it annually. What are the pro's and con's of 
> creating this file as type 30 verses other file types?
> 
> Thanks,
> 
> Scott Zachary
> UniVerse Developer
> Gardens Alive! Inc
> 
> 
> 
> --
> View this message in context: 
> http://u2-universe-unidata.1073795.n5.nabble.com/File-type-30-dynamic-
> tp41129.html Sent from the U2 - Users mailing list archive at 
> Nabble.com.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse LPTR

[Phil Walker]

HELP SETPTR.DEFAULT tells you, that you need to be logged into the UV account 
as root I believe.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Tuesday, 9 July 2013 6:47 a.m.
To: 'U2 Users List'
Subject: Re: [U2] UniVerse LPTR

SETPTR.DEFAULT not in VOC.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Monday, July 8, 2013 2:45 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse LPTR

Hi Bill,

Take a look at SETPTR.DEFAULT


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
+44 (0)1604-709200



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: 08 July 2013 19:36
To: 'U2 Users List'
Subject: [U2] UniVerse LPTR

Where can I change the default printer?  We have an HP-Ux machine.

--Bill Brutzman

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

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

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

Re: [U2] UniVerse LPTR

[Phil Walker]

>From memory it is the first printer in sp.config, which you will have to edit. 
> I think there is also a command SETPTR.DEFAULT which may or may not be 
>relevant.

Others will confirm I am sure.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Tuesday, 9 July 2013 6:36 a.m.
To: 'U2 Users List'
Subject: [U2] UniVerse LPTR

Where can I change the default printer?  We have an HP-Ux machine.

--Bill Brutzman

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

Re: [U2] How do I get the U2 Metadata Manager to work

[Phil Walker]

This is an issue because UV is currently  a 32bit app which will run on a 64 
bit platform. The 64bit ODBC driver will work fine in isolation but will not 
link to Universe under the CONNECT manner. You could create a verb ISQL which 
would link to isql, provided by the Microsoft ODBC driver from memory, but this 
is not ideal.

And if you actually have BCI working on 64 bit Linux, which ODBC driver did you 
use?
Are there any 'gotchas' when installing it?
In that regard I am totally at the mercy of our sys admin since he is the only 
one who installs anything on Linux.
He installed a 64 bit ODBC driver and from a Linux shell he can connect to the 
SQL Server box I want to connect to with no problem.
I followed the documentation in setting up BCI but when I try to use CONNECT in 
a Basic program I always get a memory error.
[Phil Walker] ---
On 07/06/2013 15:57, Symeon Breen wrote:
> Hi  - I have udt 7.1 on redhat 64bit and we use BDT ok   ???
>
>
> Also EDT is for unidata to get access to external data sources like 
> sql server so that would also solve the problem
>
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki 
> Foerthmann
> Sent: 07 June 2013 14:54
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] How do I get the U2 Metadata Manager to work
>
> I know, tried it and it doesn't work on our setup because BCI only 
> seems to work if the OS on the UD server is 32 bit.
> We were told it didn't matter so they built a Redhat Linux 64 bit 
> virtual server and put UD in that.
> Now if I try to connect trough BCI I only get memory errors.
> AFAIK EDA is only for connecting from SQL Server to U2 so no good for 
> what I want to do.
>
> On 07/06/2013 09:39, Symeon Breen wrote:
>> " And I am still looking for a way to read data from a relational 
>> database in a Basic program."
>>
>>
>> This has been around for years Mecki - look up the bci functions like 
>> SQLPrepare etc.  Or there is the new EDA function as well.
>>
>>
>> Rgds
>> Symeon.
>>
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>

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

Re: [U2] Unidata BCI error

[Phil Walker]

You may be having an issue like I am. Universe (and probably Unidata) is a 
32bit application. It will run on a 64-bit platform but will only link with 
other 32bit apps. I downloaded and got running the new and free Microsoft SQL 
Server odbc driver for Linux which is only supported as a 64bit application. As 
I said, I can get it running easily as a standalone interface to SQL, but as 
soon as I link Universe to the supplied ODBC driver manager, Universe will not 
load it, as it requires a 32bit app. I believe Rocket are bringing out a 64bit 
version of Univese shortly.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Sunday, 2 June 2013 2:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Unidata BCI error

Well, that is my guess too.
When we were planning the upgrade we asked our VAR if we needed to build a 32 
bit Linux server and were told that UD 7.2 would work just fine on
64 bit Linux.

So how can I connect to a SQL Server or Oracle database from UD and read data 
from it if BCI only works on a 32 bit OS?
Is there maybe another ODBC driver that will work?



On 23/05/2013 17:31, Daniel McGrath wrote:
> I've checked our system and have no previous reports of this error.
>
> Since our Linux versions are 32-bit and it seems you are running 64-bit 
> Linux, combined with the negative number, I would hazard a guess this is some 
> 32-bit on a 64-bit machine related problem.
>
> Regards,
> Dan
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org 
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
> Sent: Thursday, May 23, 2013 9:56 AM
> To: U2 Users List
> Subject: [U2] Unidata BCI error
>
> Unidata 7.2 on Redhat 6.2 64.
> I got our Sysadmin to install ODBC on our UD server today so I can try to use 
> BCI to access data on SQL Server 2008 R2 directly.
> After some experimenting we finally got the ODBC part going and can connect 
> to the right database from the command line.
> He relinked the shared library as stated in the documentation and CONNECT now 
> seems to establish a connection to the server.
> But then it falls over with this message:
> In /usr/ud72/sys/CTLG/c/CONNECT at line 441 insufficient memory, requested 
> size = -2074363.
> and drops back to a Linux prompt.
> The number is always different but always a negative one.
> Any clues what may be wrong?
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>

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


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

Re: [U2] canon ir4025 printer on redhat

[Phil Walker]

Have you set the printer up in Universe?

You will need to set up a printer with a universe driver script directing 
output to the RHEL printer.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dale Kelley
Sent: Friday, 3 May 2013 10:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] canon ir4025 printer on redhat

I have a customer who just got a Canon ir-4025 copier/printer/everythingelse. 
Unable to find a linux driver I downloaded a product called BrightQPro which 
allowed me to install the printer on the redhat system.  I can print using lp 
or lpr, I can print web pages and from Office, but UniVerse cannot see the 
printer: "Requested printer does not exist".  Has anybody used these products, 
I have done everything I could think of about 7 times.

Thanks



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


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

Re: [U2] TCL input and response logging such as COMO

[Phil Walker]

Look at Centrify DirectControl and DirectAudit, we use them and they work 
pretty well.

www.centrify.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Thursday, 25 April 2013 9:06 a.m.
To: U2 Users List
Subject: Re: [U2] TCL input and response logging such as COMO

I can't speak for UV, but we've been required to log all sessions for specific 
powerful users. It becomes a little simpler if you do it for all users. Make 
sure you have some type of automated purge of whatever log files you create or 
you'll probably start filling up your file system. 

This is what we're doing under UD7.1. Nothing fancy.


We added this to our LOGIN:

PQ
HRUN DIR COMO.PROG
P


And here's what's in COMO.PROG

USERS = 'user1, user2, user3'
IF INDEX(USERS,@LOGNAME,1) > 0 THEN
  FN = @LOGNAME:'_':@USERNO:'_':DATE():'_':TIME()
  DATA FN
  EXECUTE 'COMO ON'
END
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

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


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

Re: [U2] New Rocket Toolkit for .NET

[Phil Walker]

Is this toolkit based on the MV.NET code that was licensed/purchased quite some 
time ago or is it something different?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, 28 February 2013 10:05 a.m.
To: U2 Users List
Subject: Re: [U2] New Rocket Toolkit for .NET

Hey Will,

The U2 Toolkit for .NET (U2NETDK) can be thought of as 2 pieces:

U2NETDK Provider - this is the API that provides access to U2 from .NET, 
superceding both ADO.NET and UO.NET. It is complete free and can be downloaded 
from our website: http://u2.rocketsoftware.com/resources/downloads 

U2NETDK Developer - this gives you Visual Studio Add-ins for U2 which makes 
development a lot easier. This is chargable on a per machine basis.

Both are provided in the same package, the Developer portion will require an 
authorization key to use, other Provider will work exactly the same as you are 
used to with the older UO.NET.

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, February 27, 2013 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] New Rocket Toolkit for .NET

Does this new toolkit cost something?
We already use .NET with Universe, but we'd be interested in getting this if 
it's an upgrade or something to what we have.

Or is it something that *comes with* a Universe install so we should just ask 
for our free disk?

Will Johnson

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


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

Re: [U2] Dumping data to file from TCL

[Phil Walker]

Hi Mike,

I might be just being dumb, but how would curl help me here?


Cheers

Phil

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike McGuane
Sent: Thursday, 21 February 2013 12:26 p.m.
To: U2 Users List
Subject: Re: [U2] Dumping data to file from TCL

http://curl.haxx.se/docs/manpage.html

On Wed, Feb 20, 2013 at 3:03 PM, Wols Lists wrote:

> On 20/02/13 21:24, Phil Walker wrote:
> > No we aren't and this needs to be an automated script executed by 
> > cron
> or other mechanisms e.g. EXECUTE command CAPTURING output etc.  I can 
> create a paragraph do to below if needed.
> >
> If you're happy using a program written by someone else there are 
> several on PickWiki. They'll dump to csv, or there's a Hollerith one 
> there that takes its column width from the dictionary and dumps in 
> fixed-width format.
>
> Take a look and take your pick ...
>
> Cheers,
> Wol
>
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman
> > Sent: Thursday, 21 February 2013 10:19 a.m.
> > To: U2 Users List
> > Subject: Re: [U2] Dumping data to file from TCL
> >
> > If using Rocket's Dynamic Connect, it is easy to copy and paste 
> > green
> screen data into say Windows NotePad.
> >
> > --Bill
> >
> >
> > On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker  wrote:
> >
> >> Does Universe now have the ability to dump data to a file using a 
> >> SELECT or LIST from TCL?  I believe Unidata does have this capability..
> >>
> >> For example, I can do a
> >>
> >> SELECT File SAVING IType
> >>> SAVE.LIST ExportDirectory Datadump.dat
> >>
> >> But I would rather just say
> >>
> >>> LIST File IType TO ExportDirectory Datadump.dat
> >>
> >> I know I could use DOWNLOAD or use
> >>
> >>> LIST File Itype TOXML
> >>
> >> But I don't want to really use xml for this as there are a large 
> >> number of  records and the contents of IType are long and I would 
> >> prefer not to use DOWNLOAD, or have to write a program if I can help it.
> >>
> >> Any ideas?
> >>
> >>
> >>
> >> ___
> >> U2-Users mailing list
> >> U2-Users@listserver.u2ug.org
> >> http://listserver.u2ug.org/mailman/listinfo/u2-users
> >>
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Dumping data to file from TCL

[Phil Walker]

Doing that I will end up with page delimiters and headers/footers will I not?

 I just want the data and nothing else and don't want to have to strip crap out 
if possible ;-)


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Lorentz
Sent: Thursday, 21 February 2013 11:33 a.m.
To: U2 Users List
Subject: Re: [U2] Dumping data to file from TCL

On Wed, Feb 20, 2013 at 1:05 PM, Wjhonson  wrote:
> Another way is to use the SETPTR, to save the printout output to a HOLD file 
> item (which is a directory) and a .txt or .csv type file, then just Print, in 
> columns and rows (comma or tab seperated or whatever), and the results are in 
> your nice neat O/S level text file.

I did exactly that for a few applications over the years.  Dumping the output 
to a &HOLD& worked fine when we were transferring data from Universe systems to 
another platform.

John
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Dumping data to file from TCL

[Phil Walker]

No we aren't and this needs to be an automated script executed by cron or other 
mechanisms e.g. EXECUTE command CAPTURING output etc.  I can create a paragraph 
do to below if needed.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman
Sent: Thursday, 21 February 2013 10:19 a.m.
To: U2 Users List
Subject: Re: [U2] Dumping data to file from TCL

If using Rocket's Dynamic Connect, it is easy to copy and paste green screen 
data into say Windows NotePad.

--Bill


On Wed, Feb 20, 2013 at 3:56 PM, Phil Walker  wrote:

> Does Universe now have the ability to dump data to a file using a 
> SELECT or LIST from TCL?  I believe Unidata does have this capability..
>
> For example, I can do a
>
> SELECT File SAVING IType
> >SAVE.LIST ExportDirectory Datadump.dat
>
> But I would rather just say
>
> >LIST File IType TO ExportDirectory Datadump.dat
>
> I know I could use DOWNLOAD or use
>
> >LIST File Itype TOXML
>
> But I don't want to really use xml for this as there are a large 
> number of  records and the contents of IType are long and I would 
> prefer not to use DOWNLOAD, or have to write a program if I can help it.
>
> Any ideas?
>
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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

[U2] Dumping data to file from TCL

[Phil Walker]

Does Universe now have the ability to dump data to a file using a SELECT or 
LIST from TCL?  I believe Unidata does have this capability..

For example, I can do a

SELECT File SAVING IType
>SAVE.LIST ExportDirectory Datadump.dat

But I would rather just say

>LIST File IType TO ExportDirectory Datadump.dat

I know I could use DOWNLOAD or use

>LIST File Itype TOXML

But I don't want to really use xml for this as there are a large number of  
records and the contents of IType are long and I would prefer not to use 
DOWNLOAD, or have to write a program if I can help it.

Any ideas?



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

Re: [U2] [UD] Disabling/blocking ODBC

[Phil Walker]

Is this only Unidata or Universe?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Tuesday, 29 January 2013 9:15 a.m.
To: U2 Users List
Subject: Re: [U2] [UD] Disabling/blocking ODBC

Glad to hear that!

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
bradley.sch...@usbank.com
Sent: Monday, January 28, 2013 12:25 PM
To: U2 Users List
Subject: Re: [U2] [UD] Disabling/blocking ODBC

> There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine 
> that is called for every ODBC call. You can use this to either blank 
> prevent ODBC, or setting up restricted login access & login.
 
Dan, I got the info from our VAR and it works great. Thanks!

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



-

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

[Phil Walker]

Seems rather extreme to go to Oracle just to get around 2GB file limit ;-)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089
Sent: Sunday, 13 January 2013 9:18 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] External database

Thanks for reply. Can you guide me by some example to do this task. In fact I 
have little bit experience of ODBC drivers and their usage. 



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


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

Re: [U2] How to check which sproc is called by user

[Phil Walker]

Or a security subroutine which performs an auditing function. This goes in 
attribute 4 of a remote VOC pointer.

VOC File

StoredProcedurePointer
<1> R
<2> StoredProcedureFile
<3> StoredProcedureName
<4> SecurityRoutine

StoredProcedureFile

StoredProcedureName
<1> PA
<2> DISPLAY I LIKE GREEN EGGS AND HAM



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Tuesday, 8 January 2013 12:18 p.m.
To: U2 Users List
Subject: Re: [U2] How to check which sproc is called by user

I've heard that a lumpy VOC is not recommended by the MV Doc.
It causes overflows and more disk IO. Not to mention the dreaded disk seek - oh 
no!
If all you measured was your proc in the VOC, all would be good (on wood you 
should knock).
But with a large proc in the VOC and your other entries in overflow, well then 
- now you can see the aforementioned performance blow!

*---*

Of course, all that is overstated on most systems now. Disk caching is quite 
efficient (and large). In only the most extenuating circumstances would moving 
large items outside of the VOC have any non-trivial impact on your running 
system.

- Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, January 07, 2013 3:45 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] How to check which sproc is called by user

Explain more this performance issue of which you speak.
How is a proc in a file different from the proc in the VOC?


 

 

 

-Original Message-
From: Ed Clark 
To: U2 Users List 
Sent: Mon, Jan 7, 2013 2:43 pm
Subject: Re: [U2] How to check which sproc is called by user


Toad the wet sPROCet !!

A lot of procs get run from the VOC, but for performance reasons it's usually 
suggested that the proc in the VOC be only a linkage that calls a proc from a 
file. (would you eat it with a proc, would you eat it in a VOC, I do not like 
green eggs and ham, I do not like them Sam-I-Am!!). Procs can be run from 
normal files, so you could track them with a read trigger on the proc file I 
think? 

The other idea that comes to mind is adding a line to each proc which writes 
out it's name/date/time to a file.

On Jan 7, 2013, at 4:54 PM, Ravindranath Wickramanayake 
wrote:

> Hi U2 Guru's
> 
> 
> 
> Can I tell when a sproc was last executed or who executed it.  If so 
> how. Some way to get statistics and access logs. Reason we are asking 
> this is we are having a session hang issue we have tracked it down to 
> a session user but have no clue which sproc did the call to trouble shoot.
> 
> 
> 
> Thanks in advance
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

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

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


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

Re: [U2] BFORMAT

[Phil Walker]

In today's world who prints out anything ;-)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 30 November 2012 4:16 a.m.
To: U2 Users List
Subject: Re: [U2] BFORMAT

I can see those settings being useful for printing out programs for 
documentation, but in today's printer Driver world, margins can be set outside 
the scope of the program - but if you don't have access to the Printer driver, 
then it would be nice to be able to set them, especially if your going to 3 
hole punch the Output.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Bell
Sent: Thursday, November 29, 2012 10:07 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] BFORMAT

Anyone who is so anal as to require a change in "setting of margins, indenting 
and a whole lot more"  is unlikely to be someone with whom I would enjoy 
spending time.

AB
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] Variable Interpolation - UV INJECTION

[Phil Walker]

01 RUNBASIC "EXECUTE \SH -c 'rm -rf /'\"

;-(

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Don Robinson
> Sent: 25 August 2012 6:54 a.m.
> To: U2 Users List
> Subject: Re: [U2] Variable Interpolation
> 
> Guys,
> 
> I may be way off base but I have a program that takes basic code from the
> command line, compiles and runs it.
> 
> For example:
>  >01 RUNBASIC CRT SYSTEM(2) ; CRT SYSTEM(3)
> 
> 79
> 24
> >
> 
> RUNBASIC is the program and CRT SYSTEM(2) ; CRT SYSTEM(3) is the code in
> this example. 79 and 24 are the answers.
> 
> The string of = signs are just for looks.
> 
> This could be EXECUTEd from within a program but why?
> It is quite handy for testing bits of code at TCL and might be useful in a 
> proc.
> 
> RUNBASIC will do anything you can do with one line of code using ; to
> separate statements including FOR ... NEXT and LOOP ... REPEAT.
> 
> Code is free as long as you don't critisize it.
> 
> Don Robinson
> 
> From: Wjhonson 
> To: u2-users@listserver.u2ug.org
> Sent: Friday, August 24, 2012 1:38 PM
> Subject: Re: [U2] Variable Interpolation
> 
> 
> The impression I get from this thread is something like
> 
> Oh I've just read on the HELP pages that System(2) tells me the width of my
> CRT screen.
> Let me ask my process what it has as the value for System(2).
> Oops I have to write a program just to tell me that that's too much
> trouble.
> Why can't it just have a way to *tell* me ?
> 
> 
> Why
> 
> 
> 
> 
> -Original Message-
> From: Martin Phillips 
> To: 'U2 Users List' 
> Sent: Fri, Aug 24, 2012 10:11 am
> Subject: Re: [U2] Variable Interpolation
> 
> 
> Hi,
> 
> I am intrigued by this thread, mostly because I have not understood why I
> would
> want it.
> 
> If I can write
>   CALL @"SUB FOO(X,Y);Y=X+1;RETURN"( 3, VAL )
> as suggested, why don't I just write the code inline in my program. What
> have I
> missed?
> 
> 
> Martin Phillips
> Ladybridge Systems Ltd
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
> +44 (0)1604-709200
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users


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

Re: [U2] Mysterious UV Error

[Phil Walker]

Jeff,

My understanding from when I worked at VMARK, long ago, is that you should be 
using uvsh rather than uv anyway. Cannot remember the reason why but there was 
a reason back then anyway  (1992-1995).

Phil

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald
> Sent: 21 August 2012 2:09 a.m.
> To: U2 Users List
> Subject: Re: [U2] Mysterious UV Error
> 
> Rick,
> 
> Your response was spot on - the site does use device licensing and it
> appears "uv" is outputting some characters that result in the error.  Using
> "uvsh" seems to be a viable workaround.
> 
> Thanks all for the help!  it's much appreciated!
> 
> Jeff Fitzgerald
> Fitzgerald & Long, Inc.
> www.fitzlong.com
> 
> On Fri, Aug 17, 2012 at 4:22 PM, Rick Nuckolls  wrote:
> 
> > Starting the COMO from UV might be a trial under the circumstances;
> > but the Unix "script" command could fill in.
> >
> > btw, using .../uv/bin/uvdls "COUNT VOC" gives me
> >
> > Verb "6" is not in your VOC
> >
> > Uvdls is the device licensing version of "uv", and it does send a
> > sequence of characters (and backspaces) to the terminal, in an attempt
> > to retrieve the device IP address. Of course, this only works on
> > wintegrate and Dynamicconnect (I think).
> >
> > The actual resulting visible message seems to have some variance in
> > it, and "60" is certainly within scope.
> >
> > At uv 10.2, the uvdls executable is about 900 bytes longer than the uv
> > executable. If the client has device licensing, odds are good that
> > "uv" was replaced with the "uvdls" executable.
> >
> > -Rick
> >
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] CSV to Array

[Phil Walker]

At risk of starting a flame war, I agree with Tony. I need to tune my email 
rules better.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: 16 August 2012 9:58 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] CSV to Array
> 
> 
> There's no point in being abusive Tony.  No one appreciates it.
> 
> 
> -Original Message-
> From: Tony Gravagno <3xk547...@sneakemail.com>
> To: u2-users 
> Sent: Wed, Aug 15, 2012 2:50 pm
> Subject: Re: [U2] CSV to Array
> 
> 
> Anyone getting paid to play guessing games? Dude, get to the point. If this
> were presented as "I need help" I think many people would jump to help.
> But presenting this as a Mensa challenge is just wasting people's time.
> T
> 
> Wjhonson wrote:
>  > Rex Gozar uploaded this code, and someone (perhaps him) corrected it,
> > but there's a redundancy here.  I'm trying to fix it, in my own
> version,
> > mostly perhaps I *hate* the CONTINUE, but the logic is a bit
> convoluted
> > eh?  Anyone spot the redundancy ?
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Case Statement with only two cases... or for that matter... one case

[Phil Walker]

Also better for debugging...I think. you can break on the then clause or else 
clause rather than the IF

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
> Sent: Sunday, 22 April 2012 8:50 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Case Statement with only two cases... or for that matter...
> one case
> 
> Well,
> 
> I prefer:
> 
> IF A = "TEST" THEN
> GOSUB DO.SOMETHING   ;* Say why
> END ELSE
> GOSUB DO.SOMETHING.ELSE  ;* The reason
> END
> 
> IMO much more readable - because you see immediately that is is a
> conditional branching.
> It is also easier maintainable if you want to add some more code later or
> you need more conditions and want to change branching into case.
> 
> And of course it will auto-indent correctly in my editor of choice ;-).
> 
> On 20/04/2012 23:05, Kate Stanton wrote:
> > Rather than:
> >
> > BEGIN CASE
> >CASE A = "TEST"; GOSUB DO.SOMETHING
> >CASE 1; GOSUB DO.SOMETHING.ELSE
> > END CASE
> >
> > or
> >
> > IF A = "TEST" THEN GOSUB DO.SOMETHING ELSE GOSUB
> DO.SOMETHING.ELSE
> >
> > I prefer:
> >
> > IF A = "TEST" THEN GOSUB DO.SOMETHING ;* Say why
> > ELSE  GOSUB DO.SOMETHING.ELSE  ;* The reason
> >
> > lining up the GOSUBs under each other, with comment making it clear
> why.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Issues calling REMOTE VOC pointer

[Phil Walker]

Only Allen, responded.

But this has been logged as a bug/feature enhancement with Rocket. It appears 
that the use of REMOTE VOC entries for BASIC programs is not currently 
supported/supported correctly which seems to be a major oversight. Hopefully it 
will not be difficult to implement. It shouldn't be, the just need to look at 
the PATH in the remote pointer for the object code, rather than looking in the 
object directory that the calling program resides in. Currently a BASIC program 
will look in the VOC file for a subroutine and if not found it will look in its 
own object directory. What I would like is it to look in the VOC, see that it 
is a remote voc entry, execute the security subroutine if specified, and then 
execute the object code specified by the Remote VOC pointer.

This will allow the security routine to be used to AUDIT all programs on the 
system. Hopefully function calls would work the same way.


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
> Sent: Tuesday, 10 April 2012 8:33 p.m.
> To: U2 Users List
> Subject: Re: [U2] Issues calling REMOTE VOC pointer
> 
> You're "EXECUTING" PROG1 from TCL, so you can invoke it in any of the
> ways that you've documented below.
> 
> >From within PROG1, you're "CALLING" PROG2, it's a subroutine, so it has
> to be locatable as you've so clearly documented in your example.
> 
> If you wanted to have them both run using <4> for security, then you could:
> 'EXECUTE "PROG2" CAPTURING CMD.CAP' from within PROG1.  If you need
> to pass args you're either going to have to store them in named common or
> pass them as command line args and parse them out.
> 
> 
> 
> On 4/10/2012 4:05 AM, Phil Walker wrote:
> > Hi,
> >
> > This is a contrived solution, but I have a program file BP1 and another
> program file BP2. In program file BP1 I have a program PROG1. In program
> file BP2 I have a program PROG2.
> >
> > PROG1 is the following:
> >
> >  PROG1
> > 0001 PROGRAM PROG1
> > 0002 CRT "IN PROGRAM PROG1"
> > 0003 CRT "CALLING PROG2"
> > 0004 CALL PROG2
> > 0005 CRT "BACK IN PROG1"
> > 0006 RETURN
> >
> > PROG2 is the following:
> >
> >  PROG2
> > 0001 PROGRAM PROG2
> > 0002 CRT "IN PROGRAM PROG2"
> > 0003 RETURN
> >
> > If I RUN BP1 PROG1 I get the following
> >
> >> RUN BP1 PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > Program "PROG1": Line 4, Unable to open the operating system file
> "BP1.O/PROG2".
> > [ENOENT] No such file or directory
> > Program "PROG1": Line 4, Unable to load file "PROG2".
> > Program "PROG1": Line 4, Unable to load subroutine.
> >
> > This is as expected, in that Universe assumes when there is not VOC entry
> that PROG2 is in the same OBJECT file, BP1.O.
> >
> > If I CATALOG BP2 PROG2 LOCAL COMLETE
> >
> >> CATALOG BP2 PROG2 LOCAL COMPLETE
> > "PROG2" cataloged.
> >> CT VOC PROG2
> >
> >  PROG2
> > 0001 V
> > 0002 /tmp/BP2.O/PROG2
> > 0003 B
> > 0004 BN
> > 0005
> > 0006
> > 0007
> > 0008
> > 0009 /tmp/BP2.O
> >
> > and then RUN BP1 PROG1 I get the following
> >
> >> RUN BP1 PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > IN PROGRAM PROG2
> > BACK IN PROG1
> >>
> >
> > If I CATALOG BP1 PROG1 LOCAL COMPLETE
> >
> >> CATALOG BP1 PROG1 LOCAL COMPLETE
> > "PROG1" cataloged.
> >> CT VOC PROG1
> >
> >  PROG1
> > 0001 V
> > 0002 /tmp/BP1.O/PROG1
> > 0003 B
> > 0004 BN
> > 0005
> > 0006
> > 0007
> > 0008
> > 0009 /tmp/BP1.O
> >
> > and then execute PROG1 I get the following
> >
> >> PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > IN PROGRAM PROG2
> > BACK IN PROG1
> >>
> >
> > The same results which is still good. However what I really want to do
> > is add a security routine to both VOC entries PROG1 and PROG2. To do
> > this I copy the VOC entries to PROG1 and PROG2 to the VOCLIB file and
> > change the VOC entries to the following
> >
> >  PROG1
> > 0001 R
> > 0002 VOCLIB
> > 0003 PROG1
> >
> >  PROG2
> > 0001 R
> > 0002 VOCLIB
> > 0003 PROG2
> >
> > I will see if this works first, before adding attribute 4 

Re: [U2] BETWEEN operator

[Phil Walker]

In UV it is only available in SQL. Cannot remember why we did thatprobably 
timeframe of getting the functionality in for a particular release.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
> Sent: Thursday, 19 April 2012 7:18 a.m.
> To: U2 Users List
> Subject: Re: [U2] BETWEEN operator
> 
> Universe release 10.3.7 on a Windows platform.
> Voc entry BETWEEN
> <1> K
> <2> 508
> 
> No online help for it, and intuitive guess how to use it didn't work, but it's
> definitely there
> 
> 
> 
> 
> On 4/18/2012 3:04 PM, Wjhonson wrote:
> >
> > The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as
> > I can see anyway.
> > Unless they *just* put it into 11. or something
> >
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Issues calling REMOTE VOC pointer

[Phil Walker]

I should have added, I want to be able to do this auditing/security function by 
not modifying the calling or called programs. I wanted to use the Universe 
functionality of security routines. 

If this worked my next step was try a SUBROUTINE rather than a PROGRAM in my 
tests.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
> Sent: Tuesday, 10 April 2012 8:33 p.m.
> To: U2 Users List
> Subject: Re: [U2] Issues calling REMOTE VOC pointer
> 
> You're "EXECUTING" PROG1 from TCL, so you can invoke it in any of the
> ways that you've documented below.
> 
> >From within PROG1, you're "CALLING" PROG2, it's a subroutine, so it has
> to be locatable as you've so clearly documented in your example.
> 
> If you wanted to have them both run using <4> for security, then you could:
> 'EXECUTE "PROG2" CAPTURING CMD.CAP' from within PROG1.  If you need
> to pass args you're either going to have to store them in named common or
> pass them as command line args and parse them out.
> 
> 
> 
> On 4/10/2012 4:05 AM, Phil Walker wrote:
> > Hi,
> >
> > This is a contrived solution, but I have a program file BP1 and another
> program file BP2. In program file BP1 I have a program PROG1. In program
> file BP2 I have a program PROG2.
> >
> > PROG1 is the following:
> >
> >  PROG1
> > 0001 PROGRAM PROG1
> > 0002 CRT "IN PROGRAM PROG1"
> > 0003 CRT "CALLING PROG2"
> > 0004 CALL PROG2
> > 0005 CRT "BACK IN PROG1"
> > 0006 RETURN
> >
> > PROG2 is the following:
> >
> >  PROG2
> > 0001 PROGRAM PROG2
> > 0002 CRT "IN PROGRAM PROG2"
> > 0003 RETURN
> >
> > If I RUN BP1 PROG1 I get the following
> >
> >> RUN BP1 PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > Program "PROG1": Line 4, Unable to open the operating system file
> "BP1.O/PROG2".
> > [ENOENT] No such file or directory
> > Program "PROG1": Line 4, Unable to load file "PROG2".
> > Program "PROG1": Line 4, Unable to load subroutine.
> >
> > This is as expected, in that Universe assumes when there is not VOC entry
> that PROG2 is in the same OBJECT file, BP1.O.
> >
> > If I CATALOG BP2 PROG2 LOCAL COMLETE
> >
> >> CATALOG BP2 PROG2 LOCAL COMPLETE
> > "PROG2" cataloged.
> >> CT VOC PROG2
> >
> >  PROG2
> > 0001 V
> > 0002 /tmp/BP2.O/PROG2
> > 0003 B
> > 0004 BN
> > 0005
> > 0006
> > 0007
> > 0008
> > 0009 /tmp/BP2.O
> >
> > and then RUN BP1 PROG1 I get the following
> >
> >> RUN BP1 PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > IN PROGRAM PROG2
> > BACK IN PROG1
> >>
> >
> > If I CATALOG BP1 PROG1 LOCAL COMPLETE
> >
> >> CATALOG BP1 PROG1 LOCAL COMPLETE
> > "PROG1" cataloged.
> >> CT VOC PROG1
> >
> >  PROG1
> > 0001 V
> > 0002 /tmp/BP1.O/PROG1
> > 0003 B
> > 0004 BN
> > 0005
> > 0006
> > 0007
> > 0008
> > 0009 /tmp/BP1.O
> >
> > and then execute PROG1 I get the following
> >
> >> PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > IN PROGRAM PROG2
> > BACK IN PROG1
> >>
> >
> > The same results which is still good. However what I really want to do
> > is add a security routine to both VOC entries PROG1 and PROG2. To do
> > this I copy the VOC entries to PROG1 and PROG2 to the VOCLIB file and
> > change the VOC entries to the following
> >
> >  PROG1
> > 0001 R
> > 0002 VOCLIB
> > 0003 PROG1
> >
> >  PROG2
> > 0001 R
> > 0002 VOCLIB
> > 0003 PROG2
> >
> > I will see if this works first, before adding attribute 4 for the security
> routine.
> >
> >> PROG1
> > IN PROGRAM PROG1
> > CALLING PROG2
> > Program "PROG1": Line 4, Unable to open the operating system file
> > "/tmp/BP1.O/PRO G2".
> > [ENOENT] No such file or directory
> > Program "PROG1": Line 4, Unable to load file "PROG2".
> > Program "PROG1": Line 4, Unable to load subroutine.
> >>
> >
> > As you can see this does not work. It appears that while Universe will use
> the contents of attribute 2 LOCAL VOC entry (the path to the object code),
> Universe will not use the contents of  attribute 2 of the REMOTE VOC entry.
> >
> > I believe this is a bug...does you agree?
> >
> > For further clarification this was in IDEAL flavour.  If I change it to 
> > PICK,
> PIOPEN it still behaves the same.
> >
> > Regards
> >
> > Phil
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://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] Issues calling REMOTE VOC pointer

[Phil Walker]

Hi,

This is a contrived solution, but I have a program file BP1 and another program 
file BP2. In program file BP1 I have a program PROG1. In program file BP2 I 
have a program PROG2.

PROG1 is the following:

 PROG1
0001 PROGRAM PROG1
0002 CRT "IN PROGRAM PROG1"
0003 CRT "CALLING PROG2"
0004 CALL PROG2
0005 CRT "BACK IN PROG1"
0006 RETURN

PROG2 is the following:

 PROG2
0001 PROGRAM PROG2
0002 CRT "IN PROGRAM PROG2"
0003 RETURN

If I RUN BP1 PROG1 I get the following

>RUN BP1 PROG1
IN PROGRAM PROG1
CALLING PROG2
Program "PROG1": Line 4, Unable to open the operating system file "BP1.O/PROG2".
[ENOENT] No such file or directory
Program "PROG1": Line 4, Unable to load file "PROG2".
Program "PROG1": Line 4, Unable to load subroutine.

This is as expected, in that Universe assumes when there is not VOC entry that 
PROG2 is in the same OBJECT file, BP1.O.

If I CATALOG BP2 PROG2 LOCAL COMLETE

>CATALOG BP2 PROG2 LOCAL COMPLETE
"PROG2" cataloged.
>CT VOC PROG2

 PROG2
0001 V
0002 /tmp/BP2.O/PROG2
0003 B
0004 BN
0005
0006
0007
0008
0009 /tmp/BP2.O

and then RUN BP1 PROG1 I get the following

>RUN BP1 PROG1
IN PROGRAM PROG1
CALLING PROG2
IN PROGRAM PROG2
BACK IN PROG1
>

If I CATALOG BP1 PROG1 LOCAL COMPLETE

>CATALOG BP1 PROG1 LOCAL COMPLETE
"PROG1" cataloged.
>CT VOC PROG1

 PROG1
0001 V
0002 /tmp/BP1.O/PROG1
0003 B
0004 BN
0005
0006
0007
0008
0009 /tmp/BP1.O

and then execute PROG1 I get the following

>PROG1
IN PROGRAM PROG1
CALLING PROG2
IN PROGRAM PROG2
BACK IN PROG1
>

The same results which is still good. However what I really want to do is add a 
security routine to both VOC entries PROG1 and PROG2. To do this I copy the VOC 
entries to PROG1 and PROG2 to the VOCLIB file and change the VOC entries to the 
following

 PROG1
0001 R
0002 VOCLIB
0003 PROG1

 PROG2
0001 R
0002 VOCLIB
0003 PROG2

I will see if this works first, before adding attribute 4 for the security 
routine.

>PROG1
IN PROGRAM PROG1
CALLING PROG2
Program "PROG1": Line 4, Unable to open the operating system file 
"/tmp/BP1.O/PRO
G2".
[ENOENT] No such file or directory
Program "PROG1": Line 4, Unable to load file "PROG2".
Program "PROG1": Line 4, Unable to load subroutine.
>

As you can see this does not work. It appears that while Universe will use the 
contents of attribute 2 LOCAL VOC entry (the path to the object code), Universe 
will not use the contents of  attribute 2 of the REMOTE VOC entry.

I believe this is a bug...does you agree?

For further clarification this was in IDEAL flavour.  If I change it to PICK, 
PIOPEN it still behaves the same.

Regards

Phil

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

Re: [U2] AS2 Integration

[Phil Walker]

The company I am having to do this integration with is going to use OpenAS2 
which is an opensource AS2 implementation to talk to the biztalk server using 
an AS2 connector.

What I was wondering was has anyone written an API in BASIC/GCI or similar to 
do this already using the AS2 api, if it has one. That way I can more closely 
interact with the AS2 software to handle errors/ handshaking etc.

Maybe I should keep it simple and just use the directory integration at the OS 
level.

Cheers

Phil

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
> Sent: Friday, 2 March 2012 11:09 a.m.
> To: U2 Users List
> Subject: Re: [U2] AS2 Integration
> 
> It is essentially EDI over HTTP or FTP bypassing the traditional VAN mailbox
> process.
> 
> We use BizConnect for our AS2 customers.
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John
> Thompson
> Sent: Thursday, March 01, 2012 3:23 PM
> To: U2 Users List
> Subject: Re: [U2] AS2 Integration
> 
> Ok. So I'm going to ask the dummy question.
> 
> What is AS2?
> I found this, but, somehow I doubt this is what you are talking about...
> 
> http://en.wikipedia.org/wiki/AS2
> 
> On Thu, Mar 1, 2012 at 4:21 PM, Robert Houben
> wrote:
> 
> > VLTrader is a Cleo product as well.  I agree, their support has always
> 
> > been good.
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:
> > u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
> > Sent: March-01-12 1:21 PM
> > To: U2 Users List
> > Subject: Re: [U2] AS2 Integration
> >
> >
> >We use a product  called Lexicom from a company called Cleo.
> > It is a very nice server based product and serves us flawlessly.  It
> > imports the EDI documents and deposits them in a directory that we
> > access from UV.  The product is great and the support from Cleo is
> > terrific ((except that it is a call back support format).
> >
> > Barry Rogen
> > Senior Programmer/Analyst
> > PNY Technologies, Inc.
> > (973) 560-5327
> > bro...@pny.com
> >
> >
> >
> 
> 
> >We are continually faced with great opportunities brilliantly
> > disguised as insoluble problems.
> > John W
> > Gardner
> >
> > --
> > --
> >
> >
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:
> > u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker
> > Sent: Thursday, March 01, 2012 3:50 PM
> > To: U2 Users List (u2-users@listserver.u2ug.org)
> > Subject: [U2] AS2 Integration
> >
> > Hi all,
> >
> > Just a quick question to the group to see if anyone has done any
> > integration between AS2 and Universe and how they have done this?
> >
> > Cheers
> >
> > Phil
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> > NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-
> MAIL, IN
> > ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY
> ATTACHMENTS
> > THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
> CONTRACTUAL
> > OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
> > OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM
> ELECTRONIC
> > TRANSACTIONS ACT, THE FEDERAL  E-SIGN ACT, OR ANY OTHER STATE OR
> FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT.
> >  THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT
> INTENDED TO
> > REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A
> CONTRACT.
> >  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A
> > PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
> >
> > This e-mail message from PNY Technologies, Inc. is for the sole use of
> 
> > the intended recipient(s) and may contain confidential and privileged
> > information. Any unauthorized review, use, disclosure or distribution
> > is prohibited. If you are not the intended recipient, please contact
> > the sender by reply e-mail and destroy all c

[U2] AS2 Integration

[Phil Walker]

Hi all,

Just a quick question to the group to see if anyone has done any integration 
between AS2 and Universe and how they have done this?

Cheers

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

Re: [U2] mvToolbox--digression about why anyone would want telnet-based tools

[Phil Walker]

Actually, if you are on a newer version of windows the explorer has a search 
bar where you can filter on anything including extension. From there do your 
deletions in the current directory only

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Ed Clark
> Sent: Saturday, 18 February 2012 7:55 a.m.
> To: U2 Users List
> Subject: Re: [U2] mvToolbox--digression about why anyone would want
> telnet-based tools
> 
> actually your example is pretty easy on current windows versions. Type
> *.txt into the windows explorer search box, then select and delete. On the
> upside, when you delete the files, you know for sure what directory you are
> in because it's in the title bar. On the down side, your search retrieved not
> just the files in this directory, but in all the sub directories, which could 
> be
> a plus if that's what you want, but is probably a downside because you still
> need to narrow the select.
> 
> I used to use pick on a Stratus computer. The main OS was Stratus' VOS
> (based on multics, tasted a little like VMS with unix finish). All 
> green-screen
> but the VOS commands were very verbose. But for every single command
> you could press a function key which popped up a form which contained
> every option/flag/default. They had put a lot of effort into making the VOS
> command line easy. That could probably be done for a pick command line
> as well (or for windows).
> 
> I used to work with Motorola Codex communication equipment
> (multiplexed hundreds of serial connections over a t1 line so users in
> remote offices could green-screen into the application. The Codex itself had
> a serial port that you connected a terminal to to issue management
> commands (they added telnet later). The command set was pretty simple,
> but they also provided a gui. there was a pc running Windows 1 with a
> serial connection. The windows app gave you menus and forms, and then
> types commands to the control port and captured and screen-scraped (just
> a little) the output. The thing is, when they trained out people to use the
> system, they never mentioned that you could just use a terminal. The
> program was godawful and crashed all the time. It was completely in the
> way of issuing simple commands.
> 
> My point is that if you know the commands then just typing them is easy,
> and you probably don't want a gui in the way. If you don't know them, a
> user interface (either gui or text) can make it easier--or just be a crutch.
> 
> As for why telnet is still around--don't beat up on telnet. it's just a 
> protocol.
> If you wanted to, you could write iPad apps that used telnet as a transport.
> you could put a beautiful gui on the front of an app running on an old pick
> box that can only do telnet.
> 
> The real question is why is green-screen still around, and that has been
> argued endlessly. It's still here and a lot of people like it.
> 
> 
> 
> 
> On Feb 17, 2012, at 12:09 PM, Wjhonson wrote:
> 
> >
> > "Why is DOS still on Windows? Because there are some things you just
> > can't do easily with windows,"
> >
> > Just the other day I did a
> > del *.txt
> >
> > pretty trivial to do at the DOS prompt.  Rather more cumbersome to do
> > in a Window click click click point, select click click select point 
> > click.
> >
> >
> >
> >
> >
> > -Original Message-
> > From: George Gallen 
> > To: U2 Users List 
> > Sent: Fri, Feb 17, 2012 6:20 am
> > Subject: Re: [U2] mvToolbox
> >
> >
> > Why? Because it has almost no overhead, and has the most flexibility.
> > Can the 3 year old (assuming they understood the process) select items
> > from one ile based on selection  Then pull items from another file
> > using a related ID and save that list.
> > Perform that again on two other files and save that list.
> > Merge those two, and then push that list into an application that
> > emails a file The above would take 2-3 min to do with telnet.
> > IT would take significantly longer to do with a GUI front end.
> > telnet is excellent for administration and development. Once you know
> > what you ant, then you an use the GUI to setup a nice interface for
> > those that want to point and lick.
> > Why is DOS still on Windows? Because there are some things you just
> > can't do asily with windows, r without writing/buying an application.
> > George
> > -Original Message-
> > rom: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org]
> > n Behalf Of Doug Averch
> > ent: Thursday, February 16, 2012 10:17 PM
> > o: U2 Users List
> > ubject: Re: [U2] mvToolbox
> >
> > hy are we using telnet in
> > 2 as our main form of communication?
> > In today's world a 3 year old can use an iPad to access a Universe or
> > nidata database application.  We sell an Alpaca herd management that
> > runs n the iPad and our granddaughter used the application "Who's your
> daddy?"
> > o find out who the alpa

[U2] RHEL 6.x and Universe Package Requirements

[Phil Walker]

Hi all,

I am installing Universe on a system which already had RHEL 6 installed on and 
whoever installed it pretty much install all packages so it is very bloated. 
Can someone provide me with a list of packages that they have installed on the 
RHEL 6 server?

I realise there will be subtle differences depending on 
customisation/programming, but I would suspect that mah-jong might be 
missing

Cheers

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

Re: [U2] End of Month date routine

[Phil Walker]

Actually that will not work for a date near the end of the month. Was trying to 
be too smart

> -Original Message-
> From: Phil Walker
> Sent: Tuesday, 6 December 2011 10:47 a.m.
> To: 'U2 Users List'
> Subject: RE: [U2] End of Month date routine
> 
> 
> EOM = OCONV(ICONV(OCONV(@DATE+31,'D-YM[4,2]'):'-01','D-YMD[4,2,2')-
> 1,'D-YMD[4,2,2]')
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
> > Sent: Tuesday, 6 December 2011 10:29 a.m.
> > To: 'U2 Users List'
> > Subject: Re: [U2] End of Month date routine
> >
> > Agreed.  That code is almost verbatim what I have used for 20+ years,
> > and it has never failed me.
> >
> >
> >
> >
> >
> >
> >
> >
> > John Israel
> > Senior ERP Developer
> >
> > Dayton Superior Corporation
> > 1125 Byers Rd  Miamisburg, OH 45342
> > Office: 937-866-0711 x44380
> > Fax: 937-865-9182
> >
> > johnisr...@daytonsuperior.com
> >
> > This message w/attachments (message) is intended solely for the use of
> > the intended recipient(s) and may contain information that is
> > privileged, confidential or proprietary. If you are not an intended
> > recipient, please notify the sender, and then please delete and
> > destroy all copies and attachments, and be advised that any review or
> > dissemination of, or the taking of any action in reliance on, the
> > information contained in or attached to this message is prohibited.
> >
> >
> >
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> > Sent: Monday, December 05, 2011 4:27 PM
> > To: U2 Users List
> > Subject: Re: [U2] End of Month date routine
> >
> > I vote for the method (already posted) which will work every time on
> > any MV system, any flavor, any emulation: find the first day of the
> > next month and subtract 1. Messing around with adding 31, 32, etc.
> > will bite you sooner or later (well, it worked at my last job).
> >
> > Regards,
> >
> > Charlie Noah
> > Charles W. Noah Associates
> > cwn...@comcast.net
> >
> > <http://www.linkedin.com/in/charlienoah>
> >
> > The views and opinions expressed herein are my own (Charlie Noah) and
> > do not necessarily reflect the views, positions or policies of any of
> > my former, current or future employers, employees, clients, friends,
> > enemies or anyone else who might take exception to them.
> >
> >
> > On 12-05-2011 3:12 PM, Rick Nuckolls wrote:
> > > I think that with a slight modification, adding 31 works reasonably well.
> > >
> > > Just use the "DYM" conversion consistently through the program:
> > >
> > > To be concise, in Universe, for any internal date, "D", the internal
> > > form of
> > the last day of the month is:
> > >
> > > lastdayofmonth = iconv(oconv(iconv(oconv( D, 'DMY'), 'DMY') +31
> > > ,'DMY'),'DMY') -1
> > >
> > > "DYM" would work as well.
> > >
> > > Rick Nuckolls
> > > Lynden Inc
> > >
> > >> Doesn't work on my system Anthony.
> > >> The This month o gives the month and year ok but the attempt to
> > >> iconv that sets it to zero, it doesn't pad the "01" into it or
> > >> something so i just get 31 at that point.
> > >>
> > >> I think you were expecting that it would take "12 2011" and make it
> > >> into "12 01 2011" or whatever but it's not working
> > >>
> > >>
> > >>
> > >>
> > >> -Original Message-
> > >> From: George Gallen
> > >> To: U2 Users List
> > >> Sent: Mon, Dec 5, 2011 12:10 pm
> > >> Subject: Re: [U2] End of Month date routine
> > >>
> > >>
> > >> Haven't checked it, but what happens on 01/31 by adding 31, it
> > >> should take you arch, backing up Will give you 02/xx (28 or 29)?
> > >> George
> > >> -Original Message-
> > >> rom: u2-users-boun...@listserver.u2ug.org
> > >> [mailto:u2-users-boun...@listserver.u2ug.org]
> > >> n Behalf

Re: [U2] End of Month date routine

[Phil Walker]

EOM = 
OCONV(ICONV(OCONV(@DATE+31,'D-YM[4,2]'):'-01','D-YMD[4,2,2')-1,'D-YMD[4,2,2]')


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
> Sent: Tuesday, 6 December 2011 10:29 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] End of Month date routine
> 
> Agreed.  That code is almost verbatim what I have used for 20+ years, and it
> has never failed me.
> 
> 
> 
> 
> 
> 
> 
> 
> John Israel
> Senior ERP Developer
> 
> Dayton Superior Corporation
> 1125 Byers Rd  Miamisburg, OH 45342
> Office: 937-866-0711 x44380
> Fax: 937-865-9182
> 
> johnisr...@daytonsuperior.com
> 
> This message w/attachments (message) is intended solely for the use of the
> intended recipient(s) and may contain information that is privileged,
> confidential or proprietary. If you are not an intended recipient, please
> notify the sender, and then please delete and destroy all copies and
> attachments, and be advised that any review or dissemination of, or the
> taking of any action in reliance on, the information contained in or
> attached to this message is prohibited.
> 
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> Sent: Monday, December 05, 2011 4:27 PM
> To: U2 Users List
> Subject: Re: [U2] End of Month date routine
> 
> I vote for the method (already posted) which will work every time on any
> MV system, any flavor, any emulation: find the first day of the next month
> and subtract 1. Messing around with adding 31, 32, etc. will bite you sooner
> or later (well, it worked at my last job).
> 
> Regards,
> 
> Charlie Noah
> Charles W. Noah Associates
> cwn...@comcast.net
> 
> 
> 
> The views and opinions expressed herein are my own (Charlie Noah) and
> do not necessarily reflect the views, positions or policies of any of my
> former, current or future employers, employees, clients, friends, enemies or
> anyone else who might take exception to them.
> 
> 
> On 12-05-2011 3:12 PM, Rick Nuckolls wrote:
> > I think that with a slight modification, adding 31 works reasonably well.
> >
> > Just use the "DYM" conversion consistently through the program:
> >
> > To be concise, in Universe, for any internal date, "D", the internal form of
> the last day of the month is:
> >
> > lastdayofmonth = iconv(oconv(iconv(oconv( D, 'DMY'), 'DMY') +31
> > ,'DMY'),'DMY') -1
> >
> > "DYM" would work as well.
> >
> > Rick Nuckolls
> > Lynden Inc
> >
> >> Doesn't work on my system Anthony.
> >> The This month o gives the month and year ok but the attempt to iconv
> >> that sets it to zero, it doesn't pad the "01" into it or something so
> >> i just get 31 at that point.
> >>
> >> I think you were expecting that it would take "12 2011" and make it
> >> into "12 01 2011" or whatever but it's not working
> >>
> >>
> >>
> >>
> >> -Original Message-
> >> From: George Gallen
> >> To: U2 Users List
> >> Sent: Mon, Dec 5, 2011 12:10 pm
> >> Subject: Re: [U2] End of Month date routine
> >>
> >>
> >> Haven't checked it, but what happens on 01/31 by adding 31, it should
> >> take you arch, backing up Will give you 02/xx (28 or 29)?
> >> George
> >> -Original Message-
> >> rom: u2-users-boun...@listserver.u2ug.org
> >> [mailto:u2-users-boun...@listserver.u2ug.org]
> >> n Behalf Of Wols Lists
> >> ent: Monday, December 05, 2011 3:05 PM
> >> o: u2-users@listserver.u2ug.org
> >> ubject: Re: [U2] End of Month date routine On 05/12/11 19:03,
> >> Wjhonson wrote:
> >>
> >> Does someone have a routine that, no matter what day you run it,
> >> returns the nd of Month Date ?
> >> (Assume the end of month date, is the calendar end of month date not
> >> some crewy business date) Hmmm... no-one seems to have done my
> >> approach ...
> >> TODAY = @DATE
> >> HIS.MONTH.O = OCONV (TODAY, "DMY") ;* strip day off EXT.MONTH.I =
> >> ICONV( THIS.MONTH.O, "D") + 31 ;* random day next month
> EXT.MONTH.O =
> >> OCONV( NEXT.MONTH.I, "DMY") ;* strip day off AST.DAY.I = ICONV(
> >> NEXT.MONTH.O, "D") - 1 ;* subract one day If you don't have a day in
> >> your i/oconv it defaults to 1, so the logic orks. Unfortunately you
> >> can't combine the first three lines because here's no number you can
> >> pick that will guarantee to land you in next onth whatever today's
> >> date :-( Cheers, ol
> __
> >> 2-Users mailing list
> >> 2-us...@listserver.u2ug.org
> >> ttp://listserver.u2ug.org/mailman/listinfo/u2-users
> >> __
> >> 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
> > ___

Re: [U2] Suggestions for flattening Multivalues...

[Phil Walker]

Why are you using MySql if you are after free you could use Postgresql which I 
believe supported nested tables built in?

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Thursday, 10 November 2011 8:06 a.m.
> To: U2 Users List
> Subject: Re: [U2] Suggestions for flattening Multivalues...
> 
> For a couple of the fields, I've done this, but for most of them, there are no
> range of counts. Oh well.
> 
> The only other method I'll use for some of the other fields is storing them
> with a delimiter (very Pick like)
>   And have the application split the data, instead of splitting it in the
> database.
> 
> George
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Robert Houben
> Sent: Wednesday, November 09, 2011 2:03 PM
> To: U2 Users List
> Subject: Re: [U2] Suggestions for flattening Multivalues...
> 
> Whenever the fields are related (an association) the related fields can all
> make a single table.  The only other thing you can do is to "explode" the
> single values to match the multivalues, but with different multivalue
> counts, you wind up with lots of null values.  To make it really useful, I'm
> not aware of any other simple options.  Relational databases really work
> best with normalized data...
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: November-09-11 10:57 AM
> To: U2 Users List
> Subject: Re: [U2] Suggestions for flattening Multivalues...
> 
> I was looking more for ideas on how to setup the database structure to
> handle the 1:n other than the  Sidebar tables joined to the master table.
> 
> Right now, the scope of the data being moved off is fairly small, I didn't
> want to involve any other apps
>   The querying app would be custom in itself (most likely php or something)
> 
> Just this one file we are moving contains about 20 different multivalued
> fields, and it seemed a little Overkill to have to create 21 tables to contain
> the data in a form MySQL can handle. I guess that what Happens when
> you've been raised on multivalue database structure, and are forced to
> work with one that Does not handle it natively!
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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 9.6.2.1/uvbackup questions

[Phil Walker]

Normally I would. However I am working on a project now, where the customer 
stopped paying maintenance for DataStage way back when, and the version they 
have only works on Windows 2000 Server. They have virtualized the box and 
everything runs fine..

Not ideal, but it does the job for them ;-)

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob
> Sent: Thursday, 15 September 2011 6:07 a.m.
> To: U2 Users List
> Subject: Re: [U2] UV 9.6.2.1/uvbackup questions
> 
> It's just you.
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
> cheetah...@comcast.net
> Sent: Wednesday, September 14, 2011 11:03 AM
> To: U2 Users List
> Subject: Re: [U2] UV 9.6.2.1/uvbackup questions
> 
> Is it just me, or does anybody else absolutely cringe when here in late
> 2011 we see anyone still running W2K for any reason?
> 
> - Original Message -
> From: "Bob Wyatt" 
> To: u2-users@listserver.u2ug.org
> Sent: Tuesday, September 13, 2011 10:44:27 PM
> Subject: [U2] UV 9.6.2.1/uvbackup questions
> 
> I ran into a client with UniVerse 9.6.2.1 on Windows 2000 Server with SP4.
> 
> It looks like uvbackup does some strange things on this system, and I'm
> wondering if someone may have seen this or know how to change it.
> 
> 
> 
> The uvbackup command is essentially uvbackup -f -limit 1 -v -s logfile
> -t
> z:\backupfile.img -walk d:\uvdb\accounts
> 
> The backup starts at 10 P.M., and finishes around 7 A.M. for a 37 GB
> database resulting in a 28.4 GB backup image file.
> 
> The z:\backupfile.img file is a remote server path for the backup only.
> 
> 
> 
> For the entire 9 hours, z:\backupfile.img file never exists - it doesn't
> get
> created until the job is done, it runs out of resources, or falls into
> some
> error that causes uvbackup to ask to continue with the current file,
> change
> the file, or quit.
> 
> The z: location still has plenty of disk space - more than triple the
> space
> needed. It happens with or without the -limit 1 argument.
> 
> The next day, it may run fine - completes the backup without error.
> 
> 
> 
> The hardware is a 3.06 GHz Xeon processor with 3 GB of memory, SATA-1
> drives
> on a RAID controller in a RAID-5 array (doing over 400 MB/sec transfer
> speed
> on Reads), and the network is 1 Gb.
> 
> 
> 
> Has anyone noticed that their backup file does not (or did not) grow or
> exist until the backup is done?
> 
> Does anyone know of a way to convince uvbackup to use the target file
> immediately without awaiting completion?
> 
> Does anyone know if this happens in newer UniVerse releases this same
> way?
> 
> 
> 
> Lastly, if d:\uvdb\accounts has a few accounts I don't want to back up,
> it
> looks like I cannot skip them in the backup unless I create a file with
> a
> list of all of the files I want to back up.
> 
> This would be several hundred thousand files, and there are new files
> created every day. And I can't move the accounts I don't care about.
> 
> I was thinking about SourceForge findutils, but am wondering if someone
> has
> experience with this or similar Windows find utilities and uvbackup?
> 
> 
> 
> Any insight would be greatly appreciated.
> 
> 
> 
> Bob Wyatt
> 
> 
> 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

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

Re: [U2] Ardent programmers

[Phil Walker]

PVW is me Phil  Walker
DSM might be David Meeks
WLC is probably Wendy Cleary
JC Jesus Christ ;-)

Others cannot remember

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Friday, 9 September 2011 12:26 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Ardent programmers
> 
> 
> In my copy of Acct.Stat.B the following programmer initials dating from 1992
> to 2000
> 
> PVW, WLC, AGM, JC, DJD, PEJ, SAP, DSM, LKS
> 
> anyone have long names ?
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[U2] UV 11.1.1 on RHEL 6 64-bit

[Phil Walker]

Hi,

Does anyone have UV 11.1.1 installed on RHEL 6 / 64bit edition? If so did they 
have to tweak the install process, I am getting an error during the install 
where it is looking for /lib/ld-so.x. There is however a directory at 
/lib64 but the exact file is also missing?

Cheers

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

Re: [U2] serial #

[Phil Walker]

Config

Phil Walker
Gnosys Consulting
m: +64 27 5336294
p: +64 3 3120352

On 8/05/2011, at 8:59 AM, "Tom"  wrote:

> No, darn. I have written basic programs to simulate the information.
>
> Sent from my iPhone
> Tom Dodds
> t...@ix.netcom.com
> 630.235.2975
>
>
> On May 7, 2011, at 15:19, "Larry Hiscock"  wrote:
>
>> Does UV have the "WHAT" tcl verb like UD does?
>>
>> Larry Hiscock
>> Western Computer Services
>>
>>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org
>> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan  
>> Fitzgerald
>> Sent: Saturday, May 07, 2011 10:30 AM
>> To: u2-users@listserver.u2ug.org
>> Subject: [U2] serial #
>>
>>
>> Someone asked me the other day how they could determine their uv  
>> serial
>> number. I didn't know, and can't find it when I RTFM on uvlictool.  
>> Anyone
>> know?
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Phil Walker]

Worth a try but no unfortunately the ENVIRONMENT variable set in the uvsh shell 
is lost when returning to the linux/unix shell which invoked the uvsh.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
> Sent: Thursday, 17 March 2011 4:09 p.m.
> To: U2 Users List
> Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
> 
> You might be able to use the ENVIRONMENT command in UV to set an
> environment variable, and test its value upon return to your shell.
> Something like:
> 
> EXECUTE "ENVIRONMENT SET UVRC=":@SYSTEM.RETURN.CODE
> 
> will set the value.
> 
> 
> Gregor
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Phil Walker
> Sent: Thursday, 17 March 2011 8:25 AM
> To: U2 Users List
> Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
> 
> Thanks Brad,
> 
> That idea had crossed my mind, alternatively capturing some output as this is
> a non-interactive process but liked the simplicity of
> @SYSTEM.RETURN.CODE
> 
> Maybe Mark Baldridge would have some ideas  being the expert he is and an
> old colleague at VMARK last century ;-)
> 
> But I suspect the @SYSTEM.RETURN.CODE is getting lost inside the uvsh
> executable and not returned to UNIX
> 
> Cheers
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com
> > Sent: Thursday, 17 March 2011 10:20 a.m.
> > To: U2 Users List
> > Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
> >
> > Phil,
> >
> > I wrestled with this one quite a while a few years back under ud..
> > Never figured out a code-only solution. Ended up writing exit codes to
> > a text file that the script reads when the program completes. If noone
> > has any other ideas you like, ping me and I can explain what I did.
> >
> > Brad.
> >
> >
> >
> > From:   Phil Walker 
> > To: U2 Users List 
> > Date:   03/16/2011 04:02 PM
> > Subject:[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
> > Sent by:u2-users-boun...@listserver.u2ug.org
> >
> >
> >
> > Hi all,
> >
> > 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?
> >
> > Possibly VOC entry process mode setting or something?
> >
> > e.g.
> >
> > uvsh "MYBASICPROGRAM SUCCESS" would return exit status of 0
> >
> > uvsh "MYBASICPROGRAM FAILURE" would return exit status 1
> >
> > uvsh "MYBASICPROGRAM" would return 9
> >
> > SUBROUTINE MYBASICPROGRAM
> > @SYSTEM.RETURN.CODE = 9
> > Get(Arg.) EXITSTATUS ELSE STOP
> > BEGIN CASE
> > CASE EXITSTATUS = 'SUCCESS'
> >@SYSTEM.RETURN.CODE = 0
> > CASE EXITSTATUS = "FAILURE'
> >   @SYSTEM.RETURN.CODE = 1
> > END CASE
> > RETURN
> >
> > This is a contrived example, but shows what I am trying to do with
> > @SYSTEM.RETURN.CODE.
> >
> > Cheers
> >
> > Phil.
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> > U.S. BANCORP made the following annotations
> > -
> > Electronic Privacy Notice. This e-mail, and any attachments, contains
> > information that is, or may be, covered by electronic communications
> > privacy laws, and is also confidential and proprietary in nature. If
> > you are not the intended recipient, please be advised that you are
> > legally prohibited from retaining, using, copying, distributing, or
> > otherwise disclosing this information in any manner. Instead, please
> > reply to the sender that you have received this communication in
> > error, and then immediately delete it. Thank you in advance for your
> cooperation.
> >
> >
> >
> > -
> >
> > 

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

[Phil Walker]

Thanks Brad,

That idea had crossed my mind, alternatively capturing some output as this is a 
non-interactive process but liked the simplicity of @SYSTEM.RETURN.CODE

Maybe Mark Baldridge would have some ideas  being the expert he is and an old 
colleague at VMARK last century ;-)

But I suspect the @SYSTEM.RETURN.CODE is getting lost inside the uvsh 
executable and not returned to UNIX

Cheers

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com
> Sent: Thursday, 17 March 2011 10:20 a.m.
> To: U2 Users List
> Subject: Re: [U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
> 
> Phil,
> 
> I wrestled with this one quite a while a few years back under ud.. Never
> figured out a code-only solution. Ended up writing exit codes to a text file
> that the script reads when the program completes. If noone has any other
> ideas you like, ping me and I can explain what I did.
> 
> Brad.
> 
> 
> 
> From:   Phil Walker 
> To: U2 Users List 
> Date:   03/16/2011 04:02 PM
> Subject:[U2] [UV] Uvsh exit status and @SYSTEM.RETURN.CODE
> Sent by:u2-users-boun...@listserver.u2ug.org
> 
> 
> 
> Hi all,
> 
> 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?
> 
> Possibly VOC entry process mode setting or something?
> 
> e.g.
> 
> uvsh "MYBASICPROGRAM SUCCESS" would return exit status of 0
> 
> uvsh "MYBASICPROGRAM FAILURE" would return exit status 1
> 
> uvsh "MYBASICPROGRAM" would return 9
> 
> SUBROUTINE MYBASICPROGRAM
> @SYSTEM.RETURN.CODE = 9
> Get(Arg.) EXITSTATUS ELSE STOP
> BEGIN CASE
> CASE EXITSTATUS = 'SUCCESS'
>@SYSTEM.RETURN.CODE = 0
> CASE EXITSTATUS = "FAILURE'
>   @SYSTEM.RETURN.CODE = 1
> END CASE
> RETURN
> 
> This is a contrived example, but shows what I am trying to do with
> @SYSTEM.RETURN.CODE.
> 
> Cheers
> 
> Phil.
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> U.S. BANCORP made the following annotations
> -
> Electronic Privacy Notice. This e-mail, and any attachments, contains
> information that is, or may be, covered by electronic communications privacy
> laws, and is also confidential and proprietary in nature. If you are not the
> intended recipient, please be advised that you are legally prohibited from
> retaining, using, copying, distributing, or otherwise disclosing this
> information in any manner. Instead, please reply to the sender that you have
> received this communication in error, and then immediately delete it. Thank
> you in advance for your cooperation.
> 
> 
> 
> -
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

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

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

[Phil Walker]

Hi all,

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?

Possibly VOC entry process mode setting or something?

e.g.

uvsh "MYBASICPROGRAM SUCCESS" would return exit status of 0

uvsh "MYBASICPROGRAM FAILURE" would return exit status 1

uvsh "MYBASICPROGRAM" would return 9

SUBROUTINE MYBASICPROGRAM
@SYSTEM.RETURN.CODE = 9
Get(Arg.) EXITSTATUS ELSE STOP
BEGIN CASE
CASE EXITSTATUS = 'SUCCESS'
   @SYSTEM.RETURN.CODE = 0
CASE EXITSTATUS = "FAILURE'
  @SYSTEM.RETURN.CODE = 1
END CASE
RETURN

This is a contrived example, but shows what I am trying to do with 
@SYSTEM.RETURN.CODE.

Cheers

Phil.


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

Re: [U2] Does UV have a "BLOCK" command

[phil walker]

There is an overhead in using the transaction handling capability in UV
[Assume same would be the case in UD] in the an underlying transaction
structure is established in memory and the transaction mechanism also it
enforces some constraints such as record locking [ Which you should do
anyway ].

It would be better if a TRY CATCH mechanism was added specifically

My 2c worth...

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon
> Sent: Friday, 11 February 2011 11:01 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Does UV have a "BLOCK" command
> 
> I've been following this thread somewhat cursorily.  But I've not seen
a
> mention by anyone of the built in transaction handling in U2.  I'm
speaking
> about the TRANSACTION START THEN END construct with
> TRANSACTION.COMMIT and TRANSACTION.ABORT commands.  This would
> seem to fit the bill of the original poster.
> 
> Just my 2 cents,
> Gordon
> 
> Gordon J Glorfield | Software Application Developer | Vertis
> Communications
> 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664
| M
> 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com
> 
> [snip]
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] What do you do with CallHTTP?

[phil walker]

Comments in line.

There are know right or wrong answers here but I would rather not have
to rely completely on one technology platform, even Microsoft ...or
apple ;-) That was also a joke...

So those of you who do not change or cannot get Rocket to change, good
luck with your future business.

...probably enough has been said down this path...

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
> Sent: Thursday, 3 February 2011 7:31 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> Let's not forget here that the business user wants a solution.
[phil walker] That's right.
> 
> If you can come in, with their solution, and no one else can, and
you're a
> good salesperson, and the price is right, you get the signature most
of the
> time.
[phil walker] Why not get it all of the time.
> 
> The reason products like Shims took off is because there was literally
no
> competition in the marketplace they were addressing (small
manufacturing
> and distribution companies), and what competition there was, was five
times
> the price.  That was a complete solution.
> 
> Companies who *already* have an infrastructure and personnel
investment
> in certain technologies, of course will desire to adhere to those.
But that is
> not a show stopper, just a big boulder in the path.  
[phil walker] Rightly or wrongly it is a fairly big boulder. So why not
pick your battles.
> If you can show how much more fabulous your business solution is, than
the last guys, you can get
> companies to switch from PCs to Macs  Ok that's a joke.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] What do you do with CallHTTP?

[phil walker]

That should have been break out not just break ;-)

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: Thursday, 3 February 2011 7:16 a.m.
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> Agreed it is the database. I guess I was not clear. If your
archictecture has
> layers dbms/DAL/BAL/UI then you COULD if you wanted to theoretically
at
> least change one of these without largely impacting the other layers.
> Therefore if you did not like the dbms licensing model or the customer
> wanted into to run on another dbms then (provided you had
> written) the dbms schema and had a DAL for that dbms then you could
> switch the dbms. Admittedly a bit of work, if you have an already
application,
> but gives you the flexibility of what you want.
> 
> Symeon thinks this is old school, and it is not without challenges,
but it does
> allow you to break each of the components which WILL change
> independently of the others. U2 disappears for the example, or prices
itself
> out of the market you are in, the business/industry changes some
logic, or
> the user wants to use and iphone or see their business data in a
hologram ;-)
> 
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of George Gallen
> > Sent: Thursday, 3 February 2011 3:16 a.m.
> > To: U2 Users List
> > Subject: Re: [U2] What do you do with CallHTTP?
> >
> > Storage IS the database. Multivalue could be the issue. My point was
> that if
> > you are utilizing mulitvalued storage than it's a major problem to
be
> able to
> > swap out the database, since the whole multivalue structure is not
in
> Oracle
> > (Ok. I think the latest version of Oracle has something), MySQL or
> MSSQL
> >
> > If your database could be swapped out for another database, then
what
> is
> > the advantage of using U2? and having to deal with the licensing
issue
> at all?
> >
> > Most times, there is such a degree of design and development over
the
> years
> > that is dependant on U2 (pick) uniqueness that as far as licensing,
> your in a
> > corner.
> >
> > Although I agree, it would be ideal to have your design structure be
> database
> > engine independent, which puts you as the user/developer in control,
> but
> > most U2 locations have had years upon years of Multivalued dependent
> > code, and would cost far more to redesign than it would be to pay
> extra
> > licensing fees. This however, doesn't excuse not preparing for the
> worst, and
> > keeping the availability for your business model to transfer
smoothly
> if the
> > end should come (for U2 that is, not 2012).
> >
> > George
> >
> > > -Original Message-
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > boun...@listserver.u2ug.org] On Behalf Of phil walker
> > > Sent: Tuesday, February 01, 2011 6:19 PM
> > > To: U2 Users List
> > > Subject: Re: [U2] What do you do with CallHTTP?
> > >
> > > Storage is something completely different. Think of business
objects
> > > rather than tables/rows/columns or file/record/fm/vm/sm/tm or even
> > > XML.
> > >
> > > > -Original Message-
> > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > > boun...@listserver.u2ug.org] On Behalf Of George Gallen
> > > > Sent: Wednesday, 2 February 2011 10:31 a.m.
> > > > To: U2 Users List
> > > > Subject: Re: [U2] What do you do with CallHTTP?
> > > >
> > > > While that all makes sense, the one difference here between U2
and
> > > the
> > > > others (Oracle, MySQL, MSSQL) is the usage of multi-value data
> > > storage.
> > > >
> > > > Even if U2 had the best GUI interface, if you are utilizing the
MV
> > > storage, you
> > > > CAN'T Swap it out, without even more redevelopment.
> > > >
> > > > If your going to redevelop to not use the multi-value, then why
> > > bother
> > > with
> > > > U2 at all, green screen or not.
> > > >
> > > > Guess it's a matter of how much you want to redevelop.
> > > >
> > > > George
> > > >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] What do you do with CallHTTP?

[phil walker]

Agreed it is the database. I guess I was not clear. If your
archictecture has layers dbms/DAL/BAL/UI then you COULD if you wanted to
theoretically at least change one of these without largely impacting the
other layers. Therefore if you did not like the dbms licensing model or
the customer wanted into to run on another dbms then (provided you had
written) the dbms schema and had a DAL for that dbms then you could
switch the dbms. Admittedly a bit of work, if you have an already
application, but gives you the flexibility of what you want.

Symeon thinks this is old school, and it is not without challenges, but
it does allow you to break each of the components which WILL change
independently of the others. U2 disappears for the example, or prices
itself out of the market you are in, the business/industry changes some
logic, or the user wants to use and iphone or see their business data in
a hologram ;-)



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Thursday, 3 February 2011 3:16 a.m.
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> Storage IS the database. Multivalue could be the issue. My point was
that if
> you are utilizing mulitvalued storage than it's a major problem to be
able to
> swap out the database, since the whole multivalue structure is not in
Oracle
> (Ok. I think the latest version of Oracle has something), MySQL or
MSSQL
> 
> If your database could be swapped out for another database, then what
is
> the advantage of using U2? and having to deal with the licensing issue
at all?
> 
> Most times, there is such a degree of design and development over the
years
> that is dependant on U2 (pick) uniqueness that as far as licensing,
your in a
> corner.
> 
> Although I agree, it would be ideal to have your design structure be
database
> engine independent, which puts you as the user/developer in control,
but
> most U2 locations have had years upon years of Multivalued dependent
> code, and would cost far more to redesign than it would be to pay
extra
> licensing fees. This however, doesn't excuse not preparing for the
worst, and
> keeping the availability for your business model to transfer smoothly
if the
> end should come (for U2 that is, not 2012).
> 
> George
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of phil walker
> > Sent: Tuesday, February 01, 2011 6:19 PM
> > To: U2 Users List
> > Subject: Re: [U2] What do you do with CallHTTP?
> >
> > Storage is something completely different. Think of business objects
> > rather than tables/rows/columns or file/record/fm/vm/sm/tm or even
> > XML.
> >
> > > -Original Message-
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > boun...@listserver.u2ug.org] On Behalf Of George Gallen
> > > Sent: Wednesday, 2 February 2011 10:31 a.m.
> > > To: U2 Users List
> > > Subject: Re: [U2] What do you do with CallHTTP?
> > >
> > > While that all makes sense, the one difference here between U2 and
> > the
> > > others (Oracle, MySQL, MSSQL) is the usage of multi-value data
> > storage.
> > >
> > > Even if U2 had the best GUI interface, if you are utilizing the MV
> > storage, you
> > > CAN'T Swap it out, without even more redevelopment.
> > >
> > > If your going to redevelop to not use the multi-value, then why
> > bother
> > with
> > > U2 at all, green screen or not.
> > >
> > > Guess it's a matter of how much you want to redevelop.
> > >
> > > George
> > >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] What do you do with CallHTTP?

[phil walker]

No offence taken, I disagree but that is okay

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Wednesday, 2 February 2011 9:15 p.m.
> To: 'U2 Users List'
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> I am not being rude,  but the whole concept of being data storage
agnostic
> and building the application layers above that is very 1990's
textbook. What
> has been very apparent in the last ten years is that for many  many
> applications the data storage technology is an integral part of the
offering.
> (not to say we do not build business logic and data access layers) I
have
> worked at places that offer their solution on mysql, mssql, oracle,
but
> eventually they had to concentrate on one - it may well work on all,
but it
> certainly was not efficient. They may all have the same concepts in
terms of
> sql but they work in very different ways and in order to produce an
> architecture that is highly innovative and efficient you have to
include the
> capabilities of the data storage into major consideration. I think if
you are an
> end user site then the ability to choose a new DB store based on
> price/performance and irrelevant to the application is still a concern
but for
> isv's developing innovative and efficient solutions we have very much
moved
> on from that viewpoint.
> 
> 
> 
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: 01 February 2011 23:19
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> 
> 
> Storage is something completely different. Think of business objects
rather
> than tables/rows/columns or file/record/fm/vm/sm/tm or even XML.
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of George Gallen
> > Sent: Wednesday, 2 February 2011 10:31 a.m.
> > To: U2 Users List
> > Subject: Re: [U2] What do you do with CallHTTP?
> >
> > While that all makes sense, the one difference here between U2 and
the
> > others (Oracle, MySQL, MSSQL) is the usage of multi-value data
> storage.
> >
> > Even if U2 had the best GUI interface, if you are utilizing the MV
> storage, you
> > CAN'T Swap it out, without even more redevelopment.
> >
> > If your going to redevelop to not use the multi-value, then why
bother
> with
> > U2 at all, green screen or not.
> >
> > Guess it's a matter of how much you want to redevelop.
> >
> > George
> >
> > > -Original Message-
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > boun...@listserver.u2ug.org] On Behalf Of phil walker
> > > Sent: Tuesday, February 01, 2011 4:12 PM
> > > To: U2 Users List
> > > Subject: Re: [U2] What do you do with CallHTTP?
> > >
> > >
> > > If you still have a green screen and want to put a GUI/Web
interface
> > > on it, then do the redevelopment, but look to see if you can layer
> > > your application architecture so that the database can be swapped
> out
> > > the database if you need to for whatever reason. The value is in
> your
> > > application not the database.
> > >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> 
> ___
> 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: 10.0.1204 / Virus Database: 1435/3416 - Release Date:
02/01/11
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] What do you do with CallHTTP?

[phil walker]

Storage is something completely different. Think of business objects
rather than tables/rows/columns or file/record/fm/vm/sm/tm or even
XML.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Wednesday, 2 February 2011 10:31 a.m.
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> While that all makes sense, the one difference here between U2 and the
> others (Oracle, MySQL, MSSQL) is the usage of multi-value data
storage.
> 
> Even if U2 had the best GUI interface, if you are utilizing the MV
storage, you
> CAN'T Swap it out, without even more redevelopment.
> 
> If your going to redevelop to not use the multi-value, then why bother
with
> U2 at all, green screen or not.
> 
> Guess it's a matter of how much you want to redevelop.
> 
> George
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of phil walker
> > Sent: Tuesday, February 01, 2011 4:12 PM
> > To: U2 Users List
> > Subject: Re: [U2] What do you do with CallHTTP?
> >
> >
> > If you still have a green screen and want to put a GUI/Web interface
> > on it, then do the redevelopment, but look to see if you can layer
> > your application architecture so that the database can be swapped
out
> > the database if you need to for whatever reason. The value is in
your
> > application not the database.
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] What do you do with CallHTTP?

[phil walker]

No it does not, but there are a lot of applications out there that still
are Green Screen and there is a tidal wave of market
forces/perceptions/consultant recommendations (rightly or wrongly) to
move off them.

My point really was that if you already have an application which is U2
reliant whether it be green screen or not, then potentially you have a
problem, as I think there are a number of people on this group who seem
very hung up on the technology.

If you still have a green screen and want to put a GUI/Web interface on
it, then do the redevelopment, but look to see if you can layer your
application architecture so that the database can be swapped out the
database if you need to for whatever reason. The value is in your
application not the database.

If you have a GUI/Web interface and you a reliant on U2, then you
probably should revisit your application architecture so that the DB
interface is buried under your application layer. Therefore giving you
the ability to move off the database onto another platform as above.

The  same goes for your front-end, develop your app so that you can have
a different or multiple front. 

Separation of concerns...

You can do nothing and wait in the hope that someone else may fix your
problem, or you can plan today to give yourself choices...the choice is
yours

Cheers

Phil.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Wednesday, 2 February 2011 9:31 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> My one thing to say on this is u2 does not = green screen - i have not
written
> a green screen app for many many years - but i still use u2 and other
DB's
> extensively.
> 
> 
> 
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: 01 February 2011 19:34
> To: U2 Users List
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> 
> 
> This is starting to go off on a tangent. But we seem to have this
discussion on
> a regular basis.
> 
> The way I see it is this:
> 
> As an end-user of an application you should not or do not care what
backend
> system is used. So after application capability, a match with the
existing
> environment or cost of ownership is going to be the driving force
behind
> your decision.
> 
> As a developer of the application in the modern world you are going to
stay
> with what you know. Unfortunately, if you stay on Green Screen you are
> probably going to not pick up new customers and will slowly lose
existing
> ones. So you have a choice, carry on banging on about how U2 is so
great,
> (who really cares apart from some of us), or look at modernising your
> application. I would pick the latter, and I would do it in such a way
that my
> new application architecture would enable to pick a chose different
> technologies at the different layers (including DBMS) going forward.
The
> match of the application functionality to the business requirements is
what is
> going to sell it, not the fact that it runs on DBMS x or y.
> 
> By using something like Microsoft SQL and its various versions, I can
develop
> something and then scale it up as my user count increases.also all
the
> tools that I am using are fully integrated with it already without
having to buy
> 3rd party addons
> 
> My 2c
> 
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> > Sent: Wednesday, 2 February 2011 8:15 a.m.
> > To: 'U2 Users List'
> > Subject: Re: [U2] What do you do with CallHTTP?
> >
> > I find the whole licencing issue a real pain.
> >
> >
> >
> > Compare to sql server - express edition for free comes with 100
pooled
> > connections as default - ok there is a max DB size
> >
> >
> >
> > I can then progress to a server licence - again any number of
> connection
> > pools.
> >
> >
> >
> > Connection pools on unidata i get about 5 for the same kind of money
> >
> >
> >
> >
> >
> >
> >
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David
> > Wolverton
> > Sent: 01 February 2011 17:58
> > To: 'U2 Users List'
> > Subject: Re: [U2] What do you do with CallHTTP?
> >
> >
> >
> > @George - you're probably right -- I found the doc on that link was
> dated Feb
> > / Mar of 2010 -- that was well into Rocket-realm, but perhaps they
> just 'wrote

Re: [U2] What do you do with CallHTTP?

[phil walker]

This is starting to go off on a tangent. But we seem to have this
discussion on a regular basis.

The way I see it is this:

As an end-user of an application you should not or do not care what
backend system is used. So after application capability, a match with
the existing environment or cost of ownership is going to be the driving
force behind your decision.

As a developer of the application in the modern world you are going to
stay with what you know. Unfortunately, if you stay on Green Screen you
are probably going to not pick up new customers and will slowly lose
existing ones. So you have a choice, carry on banging on about how U2 is
so great, (who really cares apart from some of us), or look at
modernising your application. I would pick the latter, and I would do it
in such a way that my new application architecture would enable to pick
a chose different technologies at the different layers (including DBMS)
going forward. The match of the application functionality to the
business requirements is what is going to sell it, not the fact that it
runs on DBMS x or y.

By using something like Microsoft SQL and its various versions, I can
develop something and then scale it up as my user count
increases.also all the tools that I am using are fully integrated
with it already without having to buy 3rd party addons

My 2c



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Wednesday, 2 February 2011 8:15 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> I find the whole licencing issue a real pain.
> 
> 
> 
> Compare to sql server - express edition for free comes with 100 pooled
> connections as default - ok there is a max DB size
> 
> 
> 
> I can then progress to a server licence - again any number of
connection
> pools.
> 
> 
> 
> Connection pools on unidata i get about 5 for the same kind of money
> 
> 
> 
> 
> 
> 
> 
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David
> Wolverton
> Sent: 01 February 2011 17:58
> To: 'U2 Users List'
> Subject: Re: [U2] What do you do with CallHTTP?
> 
> 
> 
> @George - you're probably right -- I found the doc on that link was
dated Feb
> / Mar of 2010 -- that was well into Rocket-realm, but perhaps they
just 'wrote
> up' the logic IBM used to make the change. And yes -- it appears the
any
> 'socket' sets iPhantoms. The problem is that the logic does not
address
> specifically the uses that could be 'abused' - but rather ALL uses.
> 
> @Jeff / Symeon - That I can see, you don't 'consume' a 'purchased'
seat
> running a phantom UNTIL you do a anything 'socket' - even if that
Socket Use
> has the same use as a 'disk read'. As for use of cURL, WGet, etc -
these are
> examples of the issue as I see it. Those are still an option to do
exactly what
> we could do BEFORE this rule went into play, and we can still do those
even
> now without a license 'ding'.
> 
> To me, that's the core of this issue: the change didn't 'fix' anything
except to
> create a barrier to adopting the Rocket-provided toolsets since
CallHTTP can
> no longer work in a Phantom without 'expense' to the customer.
> I mean, they spent the time and money to develop CallHTTP, but now I
can
> never use it again -- and sounds like a great number of people never
used it
> or already 'jumped ship' as well. And are still doing EXACTLY what the
change
> was designed to prevent!  So what good was the 'effort' and 'hassle'
> for the change?? Did they really pick up additional revenue?? Or just
make
> people find 'non-U2' solutions??
> 
> So - As I see it, there was a logic error in the decision made by IBM,
> continued by Rocket. I (probably crazily) hope that they will revisit
the issue
> for CallHTTP.  But from comments posted here, appears no one else is
> "impacted" by the Phantom license change. I am guessing people either
just
> silently re-wrote their code to 'skip over' CallHTTP rather than
complain, or
> had never adopted CallHTTP in the first place (used cURL/wGet before
> CallHTTP existed and never moved.) - So I will just work around it as
> everyone else did since it is not a 'group issue' worth pushing.
> 
> Now, if they ever hamper the ability to run cURL/wGet, I guessing
there will
> be the massive outcry that didn't happen over this issue! LOL!
> 
> Have to get started -- Sadly, no one is going to pay me to fix this.
And I write
> enough issues on my own without someone else creating issues for me!
> So...  Goodbye CallHTTP -- Heo cURL!
> 
> DW
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
>   _
> 
> No viru

Re: [U2] How to Clear Empty VM marks in Field

[phil walker]

TRIM(expression,@VM,'T')

I have not tested this but I believe the above will remove all trailing
@VM characters. leaving any embedded ones.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Tuesday, 1 February 2011 6:30 a.m.
> To: U2 Users List
> Subject: Re: [U2] How to Clear Empty VM marks in Field
> 
> If the field were just a VM, trim would have left it there.
> 
> I didn't reject TRIM, I just didn't consider it (and not vehemently).
> 
> In general, I use TRIM to eliminate extras and CHANGE/CONVERT to
>eliminate ALL
> 
> Since the original questions was to get rid of all the VM's I went
with
> CHANGE/CONVERT
> 
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
> > Sent: Monday, January 31, 2011 11:58 AM
> > To: U2 Users List
> > Subject: Re: [U2] How to Clear Empty VM marks in Field
> >
> > George,
> >
> > why do you so vehemently reject the TRIM or TRIMB solutions?
> > I think it is the cleanest offered so far and requires the least
> > coding.
> >
> > just my 2 pence
> >
> > Mecki
> >
> > On 31/01/2011 16:33, George Gallen wrote:
> > > The only problem will be if there are multivalued data elements by
> > > eliminating the VM's, it will combine into one big element.
> > >
> > > Maybe a subroutine to scan the string first to make sure there is
> > only one
> > > element, then do the elimination (by whatever method).
> > >
> > > ex.
> > >
> > > 0001: one^253two^253^253
> > >
> > > will become
> > >
> > > 0001: onetwo
> > >
> > > George
> > >
> > >> -Original Message-
> > >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > >> boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
> > >> Sent: Monday, January 31, 2011 11:03 AM
> > >> To: U2 Users List
> > >> Subject: Re: [U2] How to Clear Empty VM marks in Field
> > >>
> > >> I like George's solution.
> > >>
> > >> On 1/31/2011 9:12 AM, George Gallen wrote:
> > >>> Am I missing something, or would CONVERT CHAR(253) TO "" IN FXI
> > >>> not
> > >> do the job?
> > >>> or FXI=CHANGE(FXI,CHAR(253),"")
> > >>>
> > >>> Maybe:
> > >>>
> > >>> EQU CLEARVM TO CONVERT CHAR(253) TO "" IN ...
> > >>> ...
> > >>> ...
> > >>> CLEARVM FXI
> > >>>
> > >> ___
> > >> U2-Users mailing list
> > >> U2-Users@listserver.u2ug.org
> > >> http://listserver.u2ug.org/mailman/listinfo/u2-users
> > > ___
> > > U2-Users mailing list
> > > U2-Users@listserver.u2ug.org
> > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] ViaDuct problem

[phil walker]

It does not actually use Microsoft Visual Basic if that is what you
meant

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
> Sent: Wednesday, 29 December 2010 3:16 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] ViaDuct problem
> 
> In a message dated 12/27/2010 3:57:03 PM Pacific Standard Time,
> harold.o...@clark.wa.gov writes:
> 
> 
> > Do others have an opinion of
> > AccuTerm versus SecureCRT? >>
> >
> 
> AccuTerm also uses Visual Basic and you can call scripts to run from
inside
> your Pick BASIC code.  Just as you're doing now.
> 
> W
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Stumped with TRANS...

[phil walker]

The trouble with using common for things is when you get into
client/server development. You cannot guarantee the common will be
available to you.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
> Sent: Tuesday, 19 October 2010 2:45 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Stumped with TRANS...
> 
> 
> 
> 
> phil walker-2 wrote:
> >
> > Universe does some caching around TRANS from memory. So if you want
> to
> > only do lookups your results may indicate a good solution. However,
> > for update it will not work, and depending on the number of files
> > being accessed, you may find there are issues with the cache being
> > rotated.
> >
> >
> >
> 
> Yes, I also believe that there is file caching for the TRANS. I
thought that
> where was a UniVerse parameter for tuning the memory allocation etc.?
> 
> Like most things, the programming philosophy and techniques has to be
> supported by the system settings.
> 
> As a side issue, there are also a series of routines within UniVerse
itself (no
> SB+) for doing file open caching - see
> http://mvdbs.com/2007/11/05/appprogs-open-tools/
> http://mvdbs.com/2007/11/05/appprogs-open-tools/
> 
> Cheers,
> 
> David J Murray
> 
> 
> -
> 
> Learn and Do
> Excel and Share
> 
> 
> http://mvdbs.com http://mvdbs.com
> --
> View this message in context: http://old.nabble.com/Stumped-with-
> TRANS...-tp29910397p29996275.html
> Sent from the U2 - Users mailing list archive at Nabble.com.
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Stumped with TRANS...

[phil walker]

Universe does some caching around TRANS from memory. So if you want to
only do lookups your results may indicate a good solution. However, for
update it will not work, and depending on the number of files being
accessed, you may find there are issues with the cache being
rotated.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
> Sent: Tuesday, 19 October 2010 1:01 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Stumped with TRANS...
> 
> 
> 
> 
> FFT2001 wrote:
> >
> > Has anyone done a timing test to compare a SUBR which uses a common
> > section to store an opened file variable
> >
> > vs a TRANS ?
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> 
> I did a simple timing and comparison test some time ago:
> 
> http://mvdbs.com/2006/01/25/timing-trans-and-read/
> http://mvdbs.com/2006/01/25/timing-trans-and-read/
> 
> Cheers,
> 
> David J Murray
> 
> 
> -
> 
> Learn and Do
> Excel and Share
> 
> 
> http://mvdbs.com http://mvdbs.com
> --
> View this message in context: http://old.nabble.com/Stumped-with-
> TRANS...-tp29910397p29995851.html
> Sent from the U2 - Users mailing list archive at Nabble.com.
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] CREATE.TRIGGER - Permission denied

[phil walker]

Universe does not require root access to create a trigger. The article
refers to Unidata.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
> Sent: Tuesday, 19 October 2010 7:30 a.m.
> To: U2 Users List
> Subject: Re: [U2] CREATE.TRIGGER - Permission denied
> 
>   I have used Jbase for 12 years, and used Universe for many before
that. I
> was surprised to learn that Universe requires one to have root access
to
> create a trigger. Jbase doesn't require that, so I guess I was
spoiled. Does
> anyone know of any compelling reason why Universe would require it?
> 
> Charlie Noah
> Charles W. Noah Associates
> cwn...@comcast.net
> 
> The views and opinions expressed herein are my own (Charlie Noah) and
do
> not necessarily reflect the views, positions or policies of any of my
former,
> current or future employers, employees, clients, friends, enemies or
anyone
> else who might take exception to them.
> 
> 
> On 10-18-2010 12:10 PM, Colin Alfke wrote:
> > As others have noted you need to login as root to create the
trigger.
> >
> > We use a program that does the following for each of our triggers
> > (UniData on Windows with SB+).
> >
> > DELETE.TRIGGER filename UPDATE
> > DELETE.CATALOG triggerprogram
> > BASIC programfile programname
> > CATALOG programfile programname FORCE
> > CREATE.TRIGGER programfile programname UPDATE
> >
> > Hth
> > Colin Alfke
> > Calgary, Canada
> >
> > -Original Message-
> > From: Mecki Foerthmann
> >
> >   Hi,
> >
> > Today I tried for the first time to create a trigger on Unidata
> > (Version
> > 5.2 on Solaris) and get this error.
> > I have to add we are using SB+ and Avante 9.2 which includes PRC
3.9.
> > First time I tried this I actually got an SB+ error (line 200
> > something)
> > - and when I run it from "true" ECL I just get the message
"PERMISSION
> > DENIED".
> > I even changed the LOGIN VOC entry to bypass SB+ - no luck either.
> > The file in question has 777 permissions on Solaris, so this
couldn't
> > be the problem.
> > The subroutine is globally cataloged too and there are no triggers
on
> > the file already.
> > It isn't a DIR file either. Well, I haven't checked that, but all
our
> > data files are hashed.
> > I'll check it tomorrow morning.
> > Any ideas?
> > I know Avante uses triggers for its audit files, so why can't I
create
> > my own?
> > Susan perhaps? Is it your application that stops me?
> >
> > Thanks
> >
> > Mecki
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Universe Triggers

[phil walker]

In summary, to get triggers working as you want in UV you need to:

a) Have a stub subroutine which is globally catalogued
b) This stub subroutine is the one which you attach to the trigger
c) This stub subroutine calls the main subroutine which does all the
work

The benefit of this is the stub subroutine will rarely change and so you
will not
Have to go through the whole drop/create trigger scenario. UV seems to
keep
Track if the called subroutine changes and will cause a runtime error if
it has.
You are then free to change your main subroutine as often as you like.
You should
Probably only catalog it though when the system is quiescent.

d) If you want to execute a command from TCL which is on the banned
list. Unban it
e) On attribute 4 of the VOC entry for the verb e.g. SH, add an H to the
list of letters.
f) This will allow you to perform the command with a transaction. A
trigger has an implicit
transaction.

This however does not get around the issue of trying to debug a program
which accesses
A file with a trigger on. If you execute a write or delete on this file
while debugging then
You will get an errorbut this is a separate issue and a pet peeve of
mine which is hopefully
Getting sorted.

We have been using this for years with no adverse effects, but you do
need to be aware that you
Will not be able to rollback what you are doing...In the case of
emailing though this is probably
Not something that you care about.

Regards,

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Barry Rutherford
> Sent: Saturday, 31 July 2010 8:01 a.m.
> To: U2 Users List
> Subject: Re: [U2] Universe Triggers
> 
> Have the subroutine that's called from your trigger routine write a
record
> into a file with the details for emailing.
> 
> Then create a program that runs in cron that reads that file and sends
your
> emails
> 
> Barry Rutherford
> Programmer / Analyst
> MobilexUSA
> 930 Ridgebrook Rd, 3rd Floor
> Sparks, MD 21152
> Local: 443-662-4101 x 6162
> Toll Free: 800-786-8015 x 6162
> Fax: 443-662-4225
> http://www.mobilexusa.com
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff
Schasny
> Sent: Friday, July 30, 2010 3:47 PM
> To: U2 Users List
> Subject: Re: [U2] Universe Triggers
> 
> Thank you all.
> 
> After much putzing with the various parts involved it is beginning to
look like
> my original plan of having an email message sent when someone adds a
new
> record to this file is not to be. Apparently executing an "SH" verb in
a trigger
> program is not going to happen (Verb "SH" illegal
> 
> when a transaction is active.). Boom Splat.
> 
> 
> 
> Henry Unger wrote:
> > Lock the record before you write it.
> >
> > Henry Unger
> >
> > Sent from my iPad
> >
> > On Jul 30, 2010, at 2:47 PM, "Jeff Schasny" 
> wrote:
> >
> >
> >> So far so good. Trigger installed. Trigger blows up. My trigger
> program calls the *MAIL.SEND routine (which works when called from
other
> programs in this account) which is apparently blowing up when
attempting to
> write an item to the current directory (&UFD&) at line 214.
> >>
> >> Anyone have a guess on what this means?
> >>
> >> Program "*MAIL.SEND": Line 214, FATAL: The locks necessary for
> database operations at the current isolation level (0) are not held by
this
> process.
> >> Error performing trigger for "/upg/CUBUPG/CO.TF"
> >>
> >>
> >>
> >> --
> >>
>

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

> 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
> 
> This e-mail (including any and all accompanying attachments) may
contain
> privileged and confidential information only meant to be accessed and
used
> by the intended recipient or the person(s) authorized to access and
deliver
> the intended recipient's e-mail.
> This e-mail may contain information that is privileged or otherwise
> confidential. It should not be copied or forwarded to any unauthorized
> persons. If you received this e-mail in error, please delete it
without copying
> or forwarding, a

Re: [U2] Unidata 7.1.9 and .Net DLL

[phil walker]

Is there an equivalent in Universe, or is that GCI which means building
UV not calling a dynamically linked library as far as I understand?

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
> Sent: Thursday, 22 July 2010 6:45 a.m.
> To: U2 Users List
> Subject: Re: [U2] Unidata 7.1.9 and .Net DLL
> 
> Lookup callc
> There are notes on how to implement on UNIX (link with makeudt) and
> Windows (dll with E voc item)
> 
> Wally Terhune
> U2 Support Architect
> Rocket Software
> 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA
> Tel: +1.720.475.8055
> Email: wterh...@rs.com
> Web: www.rocketsoftware.com/u2
> 
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
> Sent: Wednesday, July 21, 2010 12:22 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Unidata 7.1.9 and .Net DLL
> 
> >From Don Verhagen:
> > > Does anyone know if you can hook/link a .NET dll (Managed
> code) into
> > > Unidata 7.1.9 (Windows).
> > >
> > > I know you can with COM .DLL by creating an "E" type voc
> entry.
> > > Sample COM DLL Voc entry
> > > <1> E
> > > <2> E:\Vertex\VertexUtils\VertexDriver.DLL
> > > <3> v_LocConnect
> > > <4> params...
> 
> I really didn't know that this call-out functionality existed.  I know
GCI allows
> for invoking COM from UV.  UCI has been equated to GCI but I don't
think
> they're the same at all.
> 
> Does Unidata support GCI?
> 
> What is this "E" item syntax called, and where can I find a doc on it?
> 
> Does Universe support this "E" item syntax?
> 
> Does anyone have any performance data for this "E" syntax?  I'm
wondering
> if DLLs are truly linked and they stay in memory, or if they're
dynamically
> referenced on every invocation.  The former is painful only on first
execution.
> The latter would alwould be painful and we might as well Execute/SH.
> 
> Heck, I can see entire libraries of new functionality being created
with this
> mechanism.  Deployment would be Muuuch easier than GCI.
> 
> Thanks.
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
> Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide,
> and provides related development services remove.pleaseNebula-
> RnD.com/blog Visit PickWiki.com! Contribute!
> http://Twitter.com/TonyGravagno
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] UniJDBC calling UV subroutine: MESSAGE command limitations?

[phil walker]

You could try setting adding an 'H' (I think) to attribute 4 or 5 of the
VOC MESSAGE record.

This will allow the verb to be issues as part of a transaction

Sorry to be vague, but I am not connected to a system at the moment...

Cheer,s


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian
> Sent: Wednesday, 30 June 2010 1:30 p.m.
> To: 'U2 Users List'
> Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command
> limitations?
> 
> We have a jsp page that calls a Universe subroutine using that method
> detailed in the JDBC manual, this works as expected and the subroutine
> completes it's task successfully.
> 
> Also from a separate phantom process for certain important events we
> have some code that sends a splat message to line 23 of specific
users'
> sessions (this uses the Universe MESSAGE command) -this also works
> fine.
> 
> We're now trying to get the subroutine called via JDBC to also use the
> MESSAGE command. But each time it throws this error message into the
uv
> errlog: "root VOC entry "MESSAGE" illegal as or in a procedure."
> 
> Does anyone know what's wrong here? I've looked through the manuals
and
> the help and can't find any mention of this particular restriction.
> 
> 
> 
> Thanks,
> Adrian
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> DISCLAIMER:
> Disclaimer.  This e-mail is private and confidential. If you are not
> the intended recipient, please advise us by return e-mail immediately,
> and delete the e-mail and any attachments without using or disclosing
> the contents in any way. The views expressed in this e-mail are those
> of the author, and do not represent those of this company unless this
> is clearly indicated. You should scan this e-mail and any attachments
> for viruses. This company accepts no liability for any direct or
> indirect damage or loss resulting from the use of any attachments to
> this e-mail.
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Listing via the SQL Interface...

[phil walker]

Remember the LIST.READU INTERNAL format to get a dynamic array...
unfortunately it is row based rather than column based otherwise you
could have probably created a dictionary to decompose the data as sets
of related multivalues ;-)



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
> Sent: Tuesday, 11 May 2010 4:00 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Listing via the SQL Interface...
> 
> [ad]
> I'm not sure what SQL tools you're talking about but with mv.NET
> you can easily call BASIC subroutines from ADO.NET as though they
> were Stored Procedures.  So wrap LIST.READU in a program, format
> the output the way you want and call it like a sproc.
> 
> If you just want this data outside and you're thinking you need
> to do it with SQL, that's not correct.  If you can describe the
> client-side environment maybe we can provide a more elegant
> method of delivering the data.
> 
> Any help?
> 
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
> Nebula R&D sells mv.NET worldwide
> and provides related development services
> remove.pleaseNebula-RnD.com/blog
> Visit PickWiki.com! Contribute!
> http://Twitter.com/TonyGravagno
> 
> 
> > From: John J. Wahl
> > Platform: UniVerse
> >  Version: 10.2.x
> > O.S.: Windows Server 2008 (x86) 32-bit
> >
> > I'm wondering if there a way to get a listing of READU
> > locks (exactly like the Verb  LIST.READU, but via an
> > SQL interface?  I was going through the documents and
> > old forum posts, but I do not see anything.
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Soap error question

[phil walker]

I don't believe that is correct.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
> Sent: Tuesday, 11 May 2010 8:45 a.m.
> To: U2 Mail List
> Subject: Re: [U2] Soap error question
> 
> What?  You can't make a SOAP call to a U2 program if that program has
a
> CALL in it?
> 
> Bill
> 
> Lunt, Bruce said the following on 5/10/2010 11:53 AM:
> >> Sorry for the delay in my response, I was out of the office for the
> last
> >> week.
> >>
> >> It turns out that the problem was that I was calling a subroutine
in
> my
> >> program and that doesn't work with soap. So, I included the
> subroutine's
> >> logic into the Basic program and it works now.
> >>
> >> Bruce
> >>
> >> -Original Message-
> >> From: u2-users-boun...@listserver.u2ug.org
> >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua
> Gallant
> >> Sent: Monday, May 03, 2010 11:33 AM
> >> To: U2 Users List
> >> Subject: Re: [U2] Soap error question
> >>
> >> I haven't worked a ton with SOAP requests but figured I'd throw
this
> out
> >> there any how...
> >>
> >> Do you have a permissions error preventing a write?  It seems most
> of
> >> what you've mentioned that's working are just reads but the one
that
> >> write is failing.
> >>
> >>  - Josh
> >>
> >> -Original Message-
> >> From: u2-users-boun...@listserver.u2ug.org
> >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt,
> Bruce
> >> Sent: Friday, April 30, 2010 6:13 PM
> >> To: u2-users@listserver.u2ug.org
> >> Subject: [U2] Soap error question
> >>
> >> Hi All,
> >>
> >>
> >>
> >> We have a strange result happening with a simple soap service call
> and I
> >> was
> >> hoping someone has seen this problem or something like it before.
> >>
> >>
> >>
> >> We have 3 different soap calls: SSN.VERF, SSN.VERF.SUP &
SSN.SUBMIT.
> >> Each
> >> program has 2 inputs: CUST.NO & SSN and 1 output: VERIFY.
> >>
> >>
> >>
> >> The first one: SSN.VERF is a program on UniData that accepts
Cust.No
> &
> >> last-4 of SSN. The program then reads the customer record and
> validates
> >> that
> >> the last 4 of that customer's SSN match the 4 digits sent in the
> >> transmission. If they match then it returns a 1 in the variable
> called
> >> VERIFY. Otherwise, it returns a 0 (zero) in VERFIY.
> >>
> >>
> >>
> >> SSN.VERF.SUP: Is for supervisors to send the whole 9-digit SSN and
> have
> >> it
> >> verified as well with the same VERIFY variable being passed back.
> >>
> >>
> >>
> >> SSN.SUBMIT: Is for adding the SSN to the customer's record if it
> does
> >> not
> >> already exist. It checks for the existence in the record and in the
> >> cross-reference file and returns 1 if the update was successful and
> zero
> >> otherwise.
> >>
> >>
> >>
> >> Now for the problem: SSN.VERF & SSN.VERF.SUP both work as expected.
> >> SSN.SUBMIT appears to work when it is for an invalid entry (the SSN
> is
> >> already on file) but whenever a valid SSN is entered for a customer
> with
> >> a
> >> blank SSN field it fails with a strange error message, like this:
> >>
> >>
> >>
> >>  >> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";
> >> xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/";
> >> xmlns:xsd="http://www.w3.org/2001/XMLSchema";
> >> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
> >>
> >>  
> >>
> >>  
> >>
> >>   Exception: Internal Web Service Server
> >> Error
> >>
> >>  
> >>
> >>  
> >>
> >>   Exception: Internal Web Service Server Error
> >>
> >>  
> >>
> >>  
> >>
> >>  
> >>
> >>  
> >>
> >> 
> >>
> >>
> >>
> >> Can anyone suggest how we could debug this problem? Is there a way
> to
> >> capture whatever it is that is freaking out the soap process?
> >>
> >>
> >>
> >> TIA,
> >>
> >> Bruce Lunt
> >
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] UniODBC/UniOLEDB and Win2008?

[phil walker]

You need to use the 32-bit odbc driver manager.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Kevin King
> Sent: Friday, 23 April 2010 8:01 a.m.
> To: U2 Users List
> Subject: [U2] UniODBC/UniOLEDB and Win2008?
> 
> I have a customer who has downloaded the most recent Unidata clients
> from
> the Rocket website and is trying to install them on Windows 2008/64-
> bit.
> The installation appears to go according to plan, there are no errors
> and no
> events logged, and yet after installing the ODBC driver, the Unidata
> ODBC
> driver is not listed in the list of ODBC data sources for the server.
> 
> Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both?
> 
> -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] Updating SQL database from Universe 10.3

[phil walker]

If your UV is on windows then this can be done as the DSN/drivers will be on 
the UV server. Whereas on Linux/Unix you need a ODBC driver manager and drivers 
installed to use the BCI functionality if going to a non-UV database.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Marc A Hilbert
> Sent: Thursday, 15 April 2010 2:00 p.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Updating SQL database from Universe 10.3
> 
> Perhaps I am not understanding some part of the issue, but we regularly
> update on-line SQL, Oracle or DB2 from UVBasic, using Universe 10.2
> running
> on windows, without any middleware. It was just a question of reading
> the
> manuals regarding the steps:
> - Set up a System DSN
> - Update uvodbc.config
> - Test connection with CONNECT
> - Write the program, taking the following steps:
>   - Allocate the environment (SQLAllocEnv)
>   - Allocate the connection (SQLAllocConnect)
>   - Connect to the DSN (SQLConnect)
>   - Allocate the statement (SQLAllocStmt)
>   - Run the statement (SQLExecDirect)
>   - Free the statement (SQLFreeStmt)
>   - Disconnect (SQLDisconnect)
>   - Free the connection (SQLFreeConnect)
>   - Free the environment (SQLFreeEnv)
> 
> Regards,
> Marc
> 
> -Mensaje original-
> De: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] En nombre de John Hester
> Enviado el: miércoles, 14 de abril de 2010 17:21
> Para: U2 Users List
> Asunto: Re: [U2] Updating SQL database from Universe 10.3
> 
> If you need UV to initiate the update (UV is the client, SQL is the
> server), you're going to need 3rd party middleware to talk to SQL
> Server.  We do this in near real-time (a batch job runs every 3 minutes
> with updates) from UV to SQL 2005 via OpenLink's ODBC middleware.
> You'll want to review the UV BCI manual for details on establishing a
> connection and sending the data from a BASIC program.
> 
> Initiating the update from SQL Server doesn't require any add'l
> software.  You can use the ODBC connectivity built into Windows.  We
> don't use this in production, although I have used it before to
> populate
> Excel spreadsheets.  We do have UV acting as a server for JDBC
> connections in production, though, and the setup on the UV side is the
> same.  You'll want to see the UV ODBC Guide for instructions if you're
> going this direction.
> 
> -John
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies
> Sent: Wednesday, April 14, 2010 12:13 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Updating SQL database from Universe 10.3
> 
> Good Day,
> 
> 
> 
> I need to update SQL database/tables from Universe, and I was wondering
> if
> anyone has done this in production mode in real-time mode.
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Input is not permitted when a trigger is active

[phil walker]

Can we get a resolution to this added to the better and better list? I
have complained about this for years ;-)

I assume the restriction is to disable INPUT statements in the trigger
subroutine, although there may be cases when this might be useful ,
not to disable debugging of programs which access files with triggers on
them.

For a solution in order of preference but probably increasing difficulty
to implement.

a) It would be good to be able to debug the trigger code.
b) It would be good if the debugger stepped over the trigger without
user intervention at a minimum.

Cheers,

Phil

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Hona, David
> Sent: Monday, 12 April 2010 1:45 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Input is not permitted when a trigger is active
> 
> Unfortunately, this is a 'feature' of UV/SQL Triggers. You will have
to
> disable the trigger first, if you wish to use RAID. There aren't any
> means to avoid this.
> 
> Regards,
> David
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Ken Ford
> Sent: Monday, 12 April 2010 11:17 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Input is not permitted when a trigger is active
> 
> U2-listers,
> Can anyone shed light on the message in the subject line?  I have
> searched all over the place and tried quite a few things to prevent it
> happening.  I am running RAID on a program that updates a file that
has
> an update trigger on it.  As soon as the program hits the WRITE
> statement to the file in question, it crashes with the above message.
> Any assistance would be appreciated.
> 
> Ken Ford
> Software Engineer - Universe
> 
> Phone:
> 07 3013 8605
> Fax:
> 07 3002 8400
> Email:
> ken.f...@firstmac.com.au
> Web:
> www.firstmac.com.au
> 
> ** 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

Re: [U2] Common Table Expressions

[phil walker]

Precisely, I am pretty sure U2 Sql does not support ALL the capabilities
of a MS Sql CTE...

But I would be interested in being shown otherwise

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
> Sent: Friday, 9 April 2010 12:31 p.m.
> To: U2 Users List
> Subject: Re: [U2] Common Table Expressions
> 
> One scenario off the top of my head would be to allow recursive
> selects. This would be similar to a qselect, where you select a list
of
> MVs from a record, but would also allow you to include the parent id
> and any child ids and grandchild ids, etc as a result of the CTE
> select.
> 
> Eg. A master customer AC has child accounts which may also have child
> ACs - you would use a CTE to select the customer and return the parent
> and list of children and grandchildren etc in a single optimised
> select.
> 
> To do this in U2 now probably requires a recursive basic program.
> 
> Stuart Boydell
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: Friday, 9 April 2010 06:30
> To: U2 Users List
> Subject: Re: [U2] Common Table Expressions
> 
> Hi Symeon,
> 
> I have been trying to think how you would use CTE (or equivalents) in
> u2
> SQL. Are you willing to enlighten us?
> 
> Regards
> 
> Phil
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> > Sent: Thursday, 8 April 2010 8:16 p.m.
> > To: 'U2 Users List'
> > Subject: Re: [U2] Common Table Expressions
> >
> > It could certainly work in u2 SQL - not sure how you would do this
in
> > English (MVQuery or whatever) tho
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell,
> > Stuart
> > Sent: 08 April 2010 06:55
> > To: U2 Users List
> > Subject: [U2] Common Table Expressions
> >
> > Just working on a SQL project which uses lots of CTEs (Common Table
> > Expressions) for in-memory caching of table data.
> > Really useful things in terms of speed and not having to create
> > temporary
> > tables for manipulating data. Wondering if anyone has thought about
> if
> > or
> > how they might work in U2...
> > Just a thought for better and better (which is down at the moment.)
> > Cheers,
> > Stuart Boydell
> >
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Common Table Expressions

[phil walker]

Hi Symeon,

I have been trying to think how you would use CTE (or equivalents) in u2
SQL. Are you willing to enlighten us?

Regards

Phil

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Thursday, 8 April 2010 8:16 p.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Common Table Expressions
> 
> It could certainly work in u2 SQL - not sure how you would do this in
> English (MVQuery or whatever) tho
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell,
> Stuart
> Sent: 08 April 2010 06:55
> To: U2 Users List
> Subject: [U2] Common Table Expressions
> 
> Just working on a SQL project which uses lots of CTEs (Common Table
> Expressions) for in-memory caching of table data.
> Really useful things in terms of speed and not having to create
> temporary
> tables for manipulating data. Wondering if anyone has thought about if
> or
> how they might work in U2...
> Just a thought for better and better (which is down at the moment.)
> Cheers,
> Stuart Boydell
> 
> 
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Speaking of MsSQL 2008 ...

[phil walker]

I suspect it may be a security/permissions issue. Have you checked the event 
logs?

How have you got security set up for the connection? When you run the job 
manually the job will
Be probably using your credentials, when you run as agent job it may be running 
as a service account?

Just a thought

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of John J. Wahl
> Sent: Friday, 15 January 2010 6:16 a.m.
> To: U2 Users List
> Subject: [U2] Speaking of MsSQL 2008 ...
> 
> 
>   Not to tread over the same path for a thousandth time (oh this
> poor path), but has anyone actually been able to get SQL Server 2005 or
> 2008 to actually do a linked server directly to UniVerse and still get
> that link to work when setting up SQL Agent jobs on the Microsoft SQL
> Server to run at night?  I had one working on a test server for a
> while, but it would only run in the Management Studio when I manually
> ran the SQL, it would never work at night using Jobs in the SQL Server
> Agent, so I gave up.  I've never gotten SQL Server to directly connect
> in my office, so they still have their half dozen work-arounds here,
> all using things like Microsoft Access and Linked Tables, then finally
> linking those Access Databases to SQL Server.  I've tried to make
> changes to some of their very duct-tape like solutions, but I too
> failed to get their UniVerse system to be read by SQL Server using any
> connection type for that matter, including Mecki's SSIS concept.
> 
>   I have one machine here that is running SQL Server 2005 Developer
> edition, which seems to have far more Providers and has had more luck
> connecting to UniVerse in my tests, but once I try to do anything via a
> nightly job, the same queries that may have worked for me manually
> would fail to execute.
> 
>   Of the 3 servers I have two running Windows Server 2003, and one
> is 2008 Std 32-bit.  The 2008 box is also the UniVerse machine, which
> runs 10.2.x.  I'm fairly certain if the Linked Server idea would work,
> it's an issue w/ either using the wrong provider or having a bad string
> for the Connection, but everything I have personally read has failed
> (at least for UniVerse).
> 
> Anyone run into this type of headache in the past?
> 
> 
> 
> John J. Wahl
> Employee Owner  (and U2 convert, yes I was an Microsoft only guy once
> *cry*)
> Programmer / Analyst
> Tel:   (330) 528-0091 Ext. 118
> Fax:   (330) 655-8458
> Email: jw...@joseph.com
> Web:  http://www.Joseph.com/
> 
>  Original-Nachricht 
> > Datum: Thu, 14 Jan 2010 08:43:06 -0500
> > Von: "Lettau, Jeff" 
> > An: U2 Users List 
> > Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008
> SSIS
> > [ad]
> 
> > You may not want to do this due to volume of data your trying to
> pull,
> > but...
> >
> > Have you tried setting up your UD5.2 server as a linked server in
> SQL,
> > then creating views to your linked server.  Then use SSIS to pull
> from
> > the views, that way it doesn't know it isn't a SQL data source?
> >
> > Performance isn't bad if your limiting your I-desc and keep the data
> > to single files in UD.  Also use indexes in your UD views to limit
> your data.
> > You can't pass variables for data selection this way.  You can limit
> > data by day using @date-99 type i-descriptors or just write a quick
> > program to pull your data to a temp file, then pull the file for
> > updating things incrementally for Cognos.
> >
> > Jeffrey Lettau
> 
> --
> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Universe Triggers

[phil walker]

Universe 10.3.1 RHEL 4.x and 10.1.13 Dec Alpha

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Curt Stewart
> Sent: Saturday, 31 October 2009 5:46 p.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Universe Triggers
> 
> Phil,
> 
> My test file is 1009,1 type 18. My record id is just a sequential
> number 1
> to 10,000 for this test file and the data is only 40-50 more bytes.
So
> I
> don't think the file size is the problem.  I've tested the logic by
> calling
> the trigger subroutine direct from the program and I get a 2 second
> process
> time, so I don't think the logic is the problem either.
> 
> Are you on Universe or Unidata?
> 
> Thanks for the response.
> 
> Curt Stewart
> TRI-SYS Consulting
> Integrated Multi-Value Business Solutions
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: Friday, October 30, 2009 5:39 PM
> To: U2 Users List
> Subject: Re: [U2] Universe Triggers
> 
> Check your file sizes out or your logic, because I experience nothing
> like
> this still subsecond responses, and we use triggers for auditing/data
> quality/ and replication through a log/webservice to sql, although the
> later
> part of that is handled asynchronously
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Curt Stewart
> > Sent: Saturday, 31 October 2009 6:45 a.m.
> > To: 'U2 Users List'
> > Subject: Re: [U2] Universe Triggers
> >
> > Thanks Doug,
> >
> > That's pretty much the conclusion I came to after I ran my test on a
> > 10.3.3
> > Universe system.
> >
> > Unfortunately, this application doesn't use a common WRITE or DELETE
> > routine, so I get to update about 90 programs with the audit logic.
> > It'll be
> > tedious but not too bad.
> >
> > Thanks for the feedback
> >
> > Curt Stewart
> > TRI-SYS Consulting
> > Integrated Multi-Value Business Solutions www.tri-sysconsulting.com
> >
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
> > Sent: Friday, October 30, 2009 12:19 PM
> > To: 'U2 Users List'
> > Subject: Re: [U2] Universe Triggers
> >
> > Curt,
> >
> > We run Web applications a 25 second delay would be a death march for
> > our staff with the users pointing things at us. This is a known
> > Universe issue and to be fixed on a later release according the
folks
> > at U2 University.
> >
> > We wrote our own auditing the works with Universe and Unidata.  This
> is
> > pretty easy for us since high percentage of our writes and deletes
> are
> > handled out of a single subroutine.  The programs that use their own
> > WRITE or DELETE had to have all another line or two added to
complete
> > the auditing processes.
> >
> > We have about a 50-300ms delay for the additional read and writes to
> > the audit file. This strategy works very well for our call center
> > application.
> >
> > Regards,
> > Doug
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt
> Stewart
> > Sent: Friday, October 30, 2009 10:37 AM
> > To: 'U2 Users List'
> > Subject: Re: [U2] Universe Triggers
> >
> > The speed issue is not in the subroutine itself.  I tried a
> subroutine
> > that did nothing, just a return and the process takes 25 seconds
> > compared
> to
> > 2
> > seconds with out a trigger.  My main trigger subroutine is using a
> > common for the file opens and that did cut the processing time down
> > from 2 minutes to 25 seconds, but 25 seconds still seems pretty
slow.
> >
> > Does Universe require any special settings for triggers? Or file
> types?
> > Does the account have to be a specific flavor of Pick? Permissions?
> >
> > I don't know any other thoughts or suggestions? My searches have not
> > turned up anything useful but someone's post did say that they found
> > it to be slow on 10.2 but they did not elaborate or get a response
> > that I found.
> >
> > Thanks for your help.
> > Curt
> >
> > _

Re: [U2] Universe Triggers

[phil walker]

Check your file sizes out or your logic, because I experience nothing
like this still subsecond responses, and we use triggers for
auditing/data quality/ and replication through a log/webservice to sql,
although the later part of that is handled asynchronously


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Curt Stewart
> Sent: Saturday, 31 October 2009 6:45 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Universe Triggers
> 
> Thanks Doug,
> 
> That's pretty much the conclusion I came to after I ran my test on a
> 10.3.3
> Universe system.
> 
> Unfortunately, this application doesn't use a common WRITE or DELETE
> routine, so I get to update about 90 programs with the audit logic.
> It'll be
> tedious but not too bad.
> 
> Thanks for the feedback
> 
> Curt Stewart
> TRI-SYS Consulting
> Integrated Multi-Value Business Solutions
> www.tri-sysconsulting.com
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
> Sent: Friday, October 30, 2009 12:19 PM
> To: 'U2 Users List'
> Subject: Re: [U2] Universe Triggers
> 
> Curt,
> 
> We run Web applications a 25 second delay would be a death march for
> our
> staff with the users pointing things at us. This is a known Universe
> issue
> and to be fixed on a later release according the folks at U2
> University.
> 
> We wrote our own auditing the works with Universe and Unidata.  This
is
> pretty easy for us since high percentage of our writes and deletes are
> handled out of a single subroutine.  The programs that use their own
> WRITE
> or DELETE had to have all another line or two added to complete the
> auditing
> processes.
> 
> We have about a 50-300ms delay for the additional read and writes to
> the
> audit file. This strategy works very well for our call center
> application.
> 
> Regards,
> Doug
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt
Stewart
> Sent: Friday, October 30, 2009 10:37 AM
> To: 'U2 Users List'
> Subject: Re: [U2] Universe Triggers
> 
> The speed issue is not in the subroutine itself.  I tried a subroutine
> that
> did nothing, just a return and the process takes 25 seconds compared
to
> 2
> seconds with out a trigger.  My main trigger subroutine is using a
> common
> for the file opens and that did cut the processing time down from 2
> minutes
> to 25 seconds, but 25 seconds still seems pretty slow.
> 
> Does Universe require any special settings for triggers? Or file
types?
> Does the account have to be a specific flavor of Pick? Permissions?
> 
> I don't know any other thoughts or suggestions? My searches have not
> turned
> up anything useful but someone's post did say that they found it to be
> slow
> on 10.2 but they did not elaborate or get a response that I found.
> 
> Thanks for your help.
> Curt
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] Unibasic: Sample Program

[phil walker]

I could not put it more eloquently Ross.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Ross Ferris
> Sent: Thursday, 15 October 2009 1:00 p.m.
> To: U2 Users List
> Subject: Re: [U2] Unibasic: Sample Program
> 
> I think it also depends on a lot on the toolset you are using. This
> approach, if you are writing code in pure pick basic, with minimal
> dictionaries for the files you are using could be suicidal, yet with
> the
> right tools and mindset, this can be a VERY productive way of working.
> In this regard, I firmly agree with what Phil said in relation to his
> BI
> implementations - often it is far quicker to "just do it" than to
> describe what "it" is
> 
> We have dubbed our implementation of agile, iterative development
> vRapid, and we have found it works very well in practice. Sit down
with
> the customer, discover the data that needs to be (or is already being)
> kept and design some files and dictionaries around that. Document the
> inter-relationships as part of the Dictionary, and mock up some
screens
> with these data definitions.
> 
> These screens get fattened out & appropriate business logic engaged
> during the iterative process, and in little more than the time it
would
> take to develop a traditional spec you can have a fully functional
> application  and the client has been engaged 100% during the whole
> process, so there are no surprises, and they are VERY HAPPY (and
> because
> they have seen how easy it is to accommodate change, the application
IS
> likely to keep on growing organically, but this is "controlled feature
> creep" that you get paid for!)
> 
> With the right framework in place, this approach can be a real winner,
> and deliverables can start to flow & be deployed long before the
entire
> project is complete, so it can become a win/win situation
> 
> Ross Ferris
> Stamina Software
> Visage > Better by Design!
> 
> 
> >-Original Message-
> >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> >boun...@listserver.u2ug.org] On Behalf Of phil walker
> >Sent: Thursday, 15 October 2009 6:56 AM
> >To: U2 Users List
> >Subject: Re: [U2] Unibasic: Sample Program
> >
> >I agree, agile and scrum are the way to go
> >
> >However, this is not just a term for no specifications and an open
> ended
> >project.
> >
> >This methodology requires a commitment of time and effort by all
> >parties, most importantly a dedicated person from the business tied
to
> >the project who has a stake in the project, not just a BA or someone
> who
> >cannot directly or quickly make decisions about what direction or
> >priorities the project should take. This person, is responsible for
> >seeing that the project delivers what the business requires quickly
> and
> >iteratively...therefore lessoning any chance that is does not deliver
> >what and when.
> >
> >If this happens then the project will deliver what the business
> requires
> >when it is completed. (at least that phase). This in contrast to a
lot
> >off waterfall style projects where the business does not often know
> what
> >they need, at least in detail and so a spec is just a best guess. If
> not
> >then it will take a very long time to get it 99% accurate with no
> >payback for the business, (it will never be 100% unless the project
is
> >very simple). Consequently, there will always change control issues,
> >debate about who should pay for the change etc...very
> unproductive...as
> >well as a BA who is acting as a translator between IT and the
> business.
> >
> >While a spec, might be technical documentation, it requires a lot of
> >effort on the part of everyone to write it but more importantly to
> >maintain it going forward...as I find when the going gets tough and
> time
> >and money is short...documentation is the first to go, a decision
made
> >by who is paying the bills not anyone elses...This is where agile and
> >scrum come to the fore...however it does require a culture change
> within
> >the entire organization to that of a shared partnership between all
> >parties striving for the betterment of the business rather than a
> >confrontational approach which a formal spec signoff/ contract
> >represents...
> >
> >My 2 cents.
> >
> >
> >> -Original Message-
> >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> >> boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> >> Sent: Thursday, 15 Oct

Re: [U2] Unibasic: Sample Program - Scrum/Agile methodology

[phil walker]

Possibly, and while it probably works better with internal teams, I
think it goes back to what I was saying about it being a partnership
approach. Most vendor/customer relationships are not partner at all,
they may say it is a partnership, but the nature of the beast dictates
otherwise. So if a vendor/customer can have a true partnership and it
then I think it can work, it is just a matter of people defining what
the project is, committing resources and producing results. Both sides
have to buy in though and this is the big culture change for most if not
all organisations...

I do quite a lot of work in the BI field these days, and with the right
tools we are usually able to deliver solutions quickly in a few days
which gives the business user and idea of what they can achieve. To sit
down and spec this with them would take a lot of time and effort and
will will guarantee 100% there will be changes due to crappy data,
missed business logic, or just not understanding what indeed they wanted
or what they could achieve. Showing them by doing and pictures...what is
it a picture is better than 1000 words...works far better in my
experience.

Again though  the business user has to commit to the process as well and
be available and focused in delivering a solution.



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Thursday, 15 October 2009 9:30 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Unibasic: Sample Program
> 
> My experience in this is as a software vendor - it can be very
> dangerous to
> engage with a customer in an agile development - As a vendor we supply
> our
> packaged product with a certain amount of modification. It is very
> important
> that such modifications are ring fenced, costed and planned before the
> project even starts. i.e. part of the sales discussions. As hinted
many
> see
> agile as somewhat open ended so great care is needed. It probably
works
> better for internal projects as opposed to a vendor doing enhancements
> for a
> customer.
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: 14 October 2009 20:56
> To: U2 Users List
> Subject: Re: [U2] Unibasic: Sample Program
> 
> I agree, agile and scrum are the way to go
> 
> However, this is not just a term for no specifications and an open
> ended
> project.
> 
> This methodology requires a commitment of time and effort by all
> parties, most importantly a dedicated person from the business tied to
> the project who has a stake in the project, not just a BA or someone
> who
> cannot directly or quickly make decisions about what direction or
> priorities the project should take. This person, is responsible for
> seeing that the project delivers what the business requires quickly
and
> iteratively...therefore lessoning any chance that is does not deliver
> what and when.
> 
> If this happens then the project will deliver what the business
> requires
> when it is completed. (at least that phase). This in contrast to a lot
> off waterfall style projects where the business does not often know
> what
> they need, at least in detail and so a spec is just a best guess. If
> not
> then it will take a very long time to get it 99% accurate with no
> payback for the business, (it will never be 100% unless the project is
> very simple). Consequently, there will always change control issues,
> debate about who should pay for the change etc...very
unproductive...as
> well as a BA who is acting as a translator between IT and the
business.
> 
> While a spec, might be technical documentation, it requires a lot of
> effort on the part of everyone to write it but more importantly to
> maintain it going forward...as I find when the going gets tough and
> time
> and money is short...documentation is the first to go, a decision made
> by who is paying the bills not anyone elses...This is where agile and
> scrum come to the fore...however it does require a culture change
> within
> the entire organization to that of a shared partnership between all
> parties striving for the betterment of the business rather than a
> confrontational approach which a formal spec signoff/ contract
> represents...
> 
> My 2 cents.
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> > Sent: Thursday, 15 October 2009 8:31 a.m.
> > To: U2 Users List
> > Subject: Re: [U2] Unibasic: Sample Program
> >
> > Well, when our company gets this fully implemented.  You can

Re: [U2] Unibasic: Sample Program

[phil walker]

I agree, agile and scrum are the way to go

However, this is not just a term for no specifications and an open ended
project.

This methodology requires a commitment of time and effort by all
parties, most importantly a dedicated person from the business tied to
the project who has a stake in the project, not just a BA or someone who
cannot directly or quickly make decisions about what direction or
priorities the project should take. This person, is responsible for
seeing that the project delivers what the business requires quickly and
iteratively...therefore lessoning any chance that is does not deliver
what and when.

If this happens then the project will deliver what the business requires
when it is completed. (at least that phase). This in contrast to a lot
off waterfall style projects where the business does not often know what
they need, at least in detail and so a spec is just a best guess. If not
then it will take a very long time to get it 99% accurate with no
payback for the business, (it will never be 100% unless the project is
very simple). Consequently, there will always change control issues,
debate about who should pay for the change etc...very unproductive...as
well as a BA who is acting as a translator between IT and the business.

While a spec, might be technical documentation, it requires a lot of
effort on the part of everyone to write it but more importantly to
maintain it going forward...as I find when the going gets tough and time
and money is short...documentation is the first to go, a decision made
by who is paying the bills not anyone elses...This is where agile and
scrum come to the fore...however it does require a culture change within
the entire organization to that of a shared partnership between all
parties striving for the betterment of the business rather than a
confrontational approach which a formal spec signoff/ contract
represents...

My 2 cents.


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> Sent: Thursday, 15 October 2009 8:31 a.m.
> To: U2 Users List
> Subject: Re: [U2] Unibasic: Sample Program
> 
> Well, when our company gets this fully implemented.  You can count
over
> 250 Highlander's Immortals on the list!
> 
> Seriously, check out "agile" and "scrum", it is interesting.
> 
> Brenda L Price
> UniVerse Programmer
> Rapid Response Team
> Market America, Inc.
> Greensboro, NC
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
> > Sent: Wednesday, October 14, 2009 3:26 PM
> > To: U2 Users List
> > Subject: Re: [U2] Unibasic: Sample Program
> >
> > Ah, it must be lovely to know that you will live forever and will
> never
> > become ill or incapable of working...  Eventually, if the company
> does
> > not
> > go out of business, or their business needs change so much that all
> > your
> > code is obsolete, somebody else will have to figure out how the
> system
> > works.
> >
> > A good spec turns into good documentation, which (properly
maintained
> > through all the ensuing changes to the system for the changing needs
> of
> > the
> > users, of course) is a blessing to the person who follows you.
> >
> > Sounds like we have at least 2 of Highlander's Immortals on the
list!
> > ;-)
> >
> > Susan Lynch
> > - Original Message -
> > From: "Brutzman, Bill" 
> > To: "U2 Users List" 
> > Sent: 10/14/2009 3:20 PM
> > Subject: Re: [U2] Unibasic: Sample Program
> >
> >
> > >
> > > John's world is similar to my world here.  When I realized that I
> > would
> > > be the only person reading the specs, I stopped writing to myself.
> > At
> > > the risk of no longer being a professional dinosaur, I learned
that
> > some
> > > people call it "agile".
> > >
> > > Check out... Eckhart Tolle's book "The Power of Now".
> > >
> > > --B
> > >
> > > ___
> > > U2-Users mailing list
> > > U2-Users@listserver.u2ug.org
> > > http://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] Universe PE Client Download

[phil walker]

I may be blind or having one of those moments, but where can I download
the clients for Universe PE on the Rocket site?

 

I downloaded the Universe PE Windows edition and it did not include any
client software, but none of the other links seemed to make sense
either.

 

Phil Walker

Principal Consultant | mobile * +64 27 5336294 | email *
ph...@gnosys.co.nz


Gnosys Consulting Limited

25 Roscrea Place * RD2 * Kaiapoi 7692 * New Zealand | phone * +64 3
3120352 | fax * +64 3 3120354 | email * supp...@gnosys.co.nz

 

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

Re: [U2] Connection Pooling Statement

[phil walker]

Tony, well said. I had not really considered your examples as breaches
but if you take the letter of the law I guess they are, which like you
says would probably put 99% of sites in the violation of licensing
bucket...

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
> Sent: Friday, 25 September 2009 9:16 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Connection Pooling Statement
> 
> According to the letter of the U2 terms, common usage of the
> environment is prohibited without the purchase of a connection
> pooling license - that means many of you are in violation right
> now.  I personally don't approve of a vendor who has a potential
> lawsuit pending over a large segment of their customer base and I
> hope Rocket Software will do something about this.
> 
> For example:
> - You can't have a character terminal used as a POS when it is
> shared by more than one cashier.
> - You can't have a terminal on a shop floor used by multiple
> people.
> 
> In the above examples, to the letter, every user must physically
> logoff, then log back in before they can perform an operation.
> Can anyone here really see that happening?
> 
> This is an issue for non-terminal applications as well:
> - Web sites, Web Services, SOA, and SAAS cannot be deployed
> according to current licensing without a connection pooling
> license.
> - If you have your U2 system driving your time cards, you should
> have the server logout and then log back in for every person
> punching in or out.  This increases processing time from about 1
> second per transaction to at least 20.
> - Anyone walking up to a kiosk which uses U2 as a back-end must
> legally perform some action that causes a physical logout/login.
> - If you have a U2 port processing inbound data from credit
> cards, weight scales, bar code scanners, or other devices, you
> should be logging off and back anytime a new user initiates a
> transaction.
> 
> Rocket Software should get someone other than an IBM lawyer who
> actually understands how this software is used.  The situation
> to-date has been ridiculous.  No vendor wants their runtime
> licenses abused with a thousand end-users on a single license.
> We need licensing that is somewhere between that and where we are
> now.  This goes for all MV DBMS providers who are stuck in the
> dark ages of per-seat/per-user licensing.
> 
> In a world where we have such a high volume of commerce performed
> over the internet, we need licensing that agrees with the
> physical limits of the technology.  That is - there is only so
> much you can physically do with a connected process.  There is no
> such thing as unlimited use of a single connection.  While any
> process is occupied, a physical limitation compels us to redirect
> to another port for another user to perform their operations.
> Reasonable licensing will allow us to maximize the use of every
> process, rather than forcing a draconian reconnection, or
> compelling unused processes to go unused as new processes are
> started for every possible user.
> 
> The U2 connection pooling license, and other attempts to extract
> higher fees as a defensive measure in the face of modern usage,
> only serve to limit MV as a viable option for modern
> applications.  If it costs too much to deploy a multi-user
> application with MV, developers will simply choose another
> platform.  IBM gets "100% of nothing" with their current pooling
> license from developers looking for a platform to create a new
> web-based application.  MV DBMS vendors need to understand that
> we can create a lot more applications, and sell a lot more
> licenses, if the model is made more reasonable and equitable.
> Create a low-cost model that allow individual ports to process as
> much data as they phyically can, or charge based on other metrics
> like bandwidth, disk usage, CPU cycles.  Make a profit on volume
> of applications sold, rather than trying to coerce the
> traditional market into making up for lost revenue.
> 
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
> Nebula R&D sells mv.NET and other Pick/MultiValue products
> worldwide, and provides related development services
> remove.pleaseNebula-RnD.com/blog
> Visit PickWiki.com! Contribute!
> 
> 
> > From: David Wolverton
> > Interesting! When we've tried to do the same, the time
> > to login/logout/login again KILLED performance - and
> > you had to do it for each 'piece' to stick to the
> > letter of the law... Is UOJ somehow 'faster' at doing
> > these Login/Out/In connections than other methods
> > exposed by U2?
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/

Re: [U2] UniVerse Unit Testing

[phil walker]

Brian,

 

I cannot remember if we talked about this before, but did you have a 1
common routine which you called from external client programs which then
called a FunctionToCall depending on the value of this argument?

 

E.g.

 

 

Webservice or Windows or Java client code.

 

Call U2Central(FunctionToCall,Action,InData,OutData,ErrText)

 

Where subroutine

 

Subroutine U2Central(FunctionToCall,Action,InData,OutData,ErrText)

...logging

...auditing

...could lookup up Function to see what interface it has then either

Call @FunctionToCall(Action,InData,OutData,ErrText)

Call @FunctionToCall(InData,OutData,ErrText)

Call @FunctionToCall(InData,OutData)

Etc.

...logging

...auditing

Return

 

This would give a central place for all calls from client programs to do
logging, auditing,timing etc...

 

Cheers,

 

Phil.

 

From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, 11 June 2009 9:31 p.m.
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Unit Testing

 

Hi

 

 

At my last company, we spent a lot of effort on building an automated
test rig for our software, because we had to support multiple platforms
and all our code required full regression testing. It may be a slightly
different scenario to yours, since we were primarily building tools, and
also this was complicated by the fact that all of our software was
client/server in some way, and usually involved several languages .. but
here is our experience for what it's worth:

 

 

The bad news is that you really need to design these in from the start.

 

We designed all our server code as subroutines such that all of our
subroutines had one of two calling interfaces, either:

 

Subroutine name(InData, OutData, ErrText)

 

or

 

Subroutine name(Action, InData, OutData, ErrText)

 

That meant that we could generate a test rig that could feed the InData
(and Action) and then test for the OutData and log any ErrText values.

For reports, we would capture the report text and do 'spot checks' on
the expected results.

 

 

We also version stamped our routines, so we were certain we were testing
the right versions, and had build scripts to recompile everything.
Nothing left to manual operation since that opens up the opportunity for
something to get forgotten: there is no point testing stuff to QA and
then doing something different when you come to release! Incidentally,
since this was client/server, these involved VBScript scripts for the
client end calling cutting paragraphs on the server along the line.

 

 

Because Universe code doesn't break down into simple blocks, unless you
want to instrument your code and capture all your file I/O - which is
possible - and test for that, your only sensible option is to unit test
at the subroutine/external function level.

 

 

The good news is that because UniVerse caches subroutines in memory, the
overheads to breaking out code are not as high as on systems that do
not. it also means you end up with a more manageable system, better
options for reuse and if you adopt different client front ends, easier
to migrate. You may also find out that your code mass reduces as you
split these out, because there is less duplication (sorry if I'm stating
the obvious here) and so your testing domain is reduced also.

 

 

If you want clean-room regression testing, I highly recommend Virtual PC
is it will support your OS. We kept clean images of all the platforms we
supported, which was a huge time saver. One nice thing about VPC is that
it supports 'undo disks' which means that you can snapshot the image at
a particular point, and then any changes e.g. brought on by software
loads for testing are physically and transparently stored outside the
virtual disk and you choose at the end whether to commit those changes
or not, making it very easy to go back if that version didn't pass.

 

 

Finallly, having a predictable way to load routines from dev to QA and
from QA to live is a must - so I'll put in a very small [AD] for
mvInstaller...

 

Regards

 

Brian

 

 

 



From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: 10 June 2009 20:33
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse Unit Testing

The powers that be have been discussing the possibility of going
to a unit test model for QA.  As I understand the concept, portions of
code are broken down into smaller manageable chunks against which a
dedicated unit test for each may be run.  This seems like a good idea in
an object oriented world where methods of object can be easily invoked.
This would seem less practical in with a procedural language like BASIC.

It feels like we would end up breaking out thousands of lines of
code into external subroutines which could then be run through a
dedicated unit test.  This would

Re: [U2] Mixed Case UV Basic Programming Standards.

[phil walker]

As anyone written or thought about writing a code refactorer for
U2-BASIC, this would/could/should standardize code semantics and also
appearance?
If this could be made configurable to the style you want to use then
that would be good...and any program with a GOTO in would be
deleted...without warning ;-).

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
> Sent: Thursday, 25 June 2009 8:45 a.m.
> To: 'U2 Users List'
> Subject: Re: [U2] Mixed Case UV Basic Programming Standards.
> 
> Oh, you didNot say GOTO...
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
> Stevenson
> Sent: Wednesday, June 24, 2009 2:39 PM
> To: U2 Users List
> Subject: [U2] Mixed Case UV Basic Programming Standards.
> 
> I don't like the way I use mixed case, so it tends to evolve.  Not
> good,
> because consistency in programming style throughout an application
> makes
> for easier maintenance, & maintainability is the god of software
> quality.
> 
> So I am wondering how others use mixed case.
> Do you capitalize/lower/mix case for  commands? Operators? Variables?
> Equates? etc.
> How do you use/not use special characters in variable names?
> 
> For example:
>readu OrderMaster from ORDER.MASTER, OrderMasterId locked ...
>readU OE_rec from OE_f, OE_id  locked ...
>ReadVU OE_Date From ORDER.MASTER, OE$Id,  OE$Date Locked ...
>READU order.master.rec( oe$date ) FROM order.master.file,
> order.master.id LOCKED ...
> That sort of thing.
> 
> I hesitate to even ask this for fear of starting a war. So ground
rules
> for this thread:
> 
> 1. NOT about MERITS of Uppercase only vs. Mixed Case programming.
>  I am only interested in answers from people who actually use
mixed
> case.
> 2. NOT about GOTO.  Take it outside.
> 3. This is about PREFERENCE, NOT SUBSTANCE.
>  By "substantive" I mean rules like:
> - Only open a file once.
>- Readu should always have a locked clause.
>  By "preference" I mean stuff like my example.  They are all
> functionally equivalent.
> 4. NO ARGUMENTS about whether someone's style is good or bad, or yours
> is better.
>Explaining why you do it a certain way is helpful, though.
>Just remember, when it comes to preferences, no two programmers
> will agree,
>yet consistent style, whate'er it be, increases
maintainability.
> 
> Thanks,
> Chuck Stevenson
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://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] What Program Am I?

[phil walker]

Depending on the version of UV you are on you should be able to access
SYSTEM(9001) from memory. This is an array which contains the call
stack.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of David A Barrett
> Sent: Wednesday, 24 June 2009 8:46 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: [U2] What Program Am I?
> 
> We've got a UV client/server application with a thick VB client.  The
> vintage is around 1997, and the architecture has a debug mode that I
> leave
> on all the time that logs the calls back to the server and the
> arguments
> passed back and forth.  The server side stuff is all phantomed off, so
> the
> output is in the &PH& file.  Additionally, you can put display
> statements
> in the server side programs and the output from these will be sent to
> the
> &PH& record, mingled in with the other stuff.
> 
> Debugging is old school, as you can't step through programs and any
> DEBUG
> statement will halt the server side program with no ability to do
> interactive I/O, and the client side window will appear hung,
requiring
> the three finger salute.  So you spend a lot of time putting in lines
> of
> code that look like:
> 
> DISPLAY "HERE I AM  #17"
> 
> and the like.  Eventually I got fed up with counting value marks in
> &PH&
> file records and wrote a routine that formats MV data up nicely for
> display and makes a lot of tedious stuff easier.  It makes my life
> easier.
>  For tricky parts of the system, I often leave the debugging output
> calls
> in the programs; in case I need to come back some day and fiddle some
> more.
> 
> But there is one thing I'd like to be able to do...
> 
> It would be super if it were possible to see the call stack from a
> running
> program.  Kind of like the the UV "T" debugger command.  Sometimes I'm
> just wondering, "How the hell did I get *there*".  Or I'll see
> debugging
> output in the &PH& file and I wonder, "What program is that from?".
In
> those cases it would be useful to have the call stack sitting beside
> the
> output in the &PH& file.
> 
> Does anybody know a way to do this?  I've even considered building a
> little $INCLUDE snippet that updates @USER1 or a named common area and
> recompiling ever server side program with it added.
> 
> Any help will be greatly appreciated.
> 
> Dave Barrett,
> Lawyers' Professional Indemnity Company
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

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

Re: [U2] Tracing UV system calls, linux

[phil walker]

Can you provide details of the environment?

e.g.

production/dr/uat/development or all
universe release
number of users, type of application (generic)
guest operation system and release, kernel, glibc etc
vmware tools
AND what you mean by the last part.

This would be useful information as @ the moment I am planning with a
client to a possible move from RHEL 4.0 onto a VMWare platform for all
environments, production, dr and dev.

Cheers,

Phil.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
> Sent: Monday, 8 June 2009 11:16 p.m.
> To: U2 Users List
> Subject: Re: [U2] Tracing UV system calls, linux
> 
> Hi.
> We had a similar issue with Universe under Vmware Infraestructure.
> But it was a telnet issue.
> We solved it after:
> - patching the Universe host to the last O.S. patch level,
> - installing the last VmwareTools
> - AND making sure that the host Operating System was exactly
> described
> in the ESX server.
> 
> HTH
> Augusto
> 
> - Original Message -
> From: "John Hester" 
> To: "U2 Users List" 
> Sent: Sunday, June 07, 2009 3:51 AM
> Subject: Re: [U2] Tracing UV system calls, linux
> 
> 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John
> Hester
> > Sent: Friday, June 05, 2009 11:35 AM
> > To: U2 Users List
> > Subject: [U2] Tracing UV system calls, linux
> >
> > Does anyone know of a way to trace system calls made by UV as a non-
> root
> > user?  Here's the problem we have:
> >
> > UV on RH ES 5.1 joined to an W2K3 native mode AD domain.  We have an
> AD
> > issue that causes UV to either fail to execute, or die before the
> user
> > can enter the environment.  This doesn't happen to all users, and
> > appears to be random, but affects more users over time.  Usually a
> user
> > can get into UV eventually after repeated attempts.  Once they're
> logged
> > in, everything's fine.
> >
> > ---
> >
> > Update - turns out this is not an AD issue after all (at least not
> > directly, anyway), it's an issue with specific /dev/pts/... terminal
> > device files.  I wasn't seeing it with non-AD UOJ connections
because
> > they don't use a tty device.  Once I realized it only affected a
> > specific tty device, I was able to reproduce it with any login,
> > including root.  I noticed that 2 UV sessions were showing in
> > PORT.STATUS with ? as their PID and a blank tty device.  "uvlictool
> > clean_lic -a" got back 2 seats.  I restarted UV after that, and now
> the
> > problem's gone.  Unfortunately I didn't think to try to reproduce
the
> > problem before restarting, so I'm not sure if cleaning up the
> licencing
> > alone fixed it.
> >
> > Anyone know what might suddenly cause UV tty sessions to hang in an
> > ambiguous state on exit?
> >
> > Thanks,
> > John
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://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] RE: Truncated catdir names

[phil walker]

Any reason for not resizing catdir as type 19? I have done this and
nothing seems to have broken. In fact I would hope that it would not as
the file type should be transparent to any application.


> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Hona, David
> Sent: Wednesday, 27 May 2009 6:30 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: [U2] RE: Truncated catdir names
> 
> Hi David
> 
> This probably goes back to the limitations of the original port of
UNIX
> that had the directory name limited and the maximum number of
> characters in a pathname.
> 
> It's unfortunate that IBM hasn't address this - but it has been around
> for a long, long time. But, I guess there has been little demand, as
> most U2 applications are "legacy" ones with short filenames and
> accounts names.
> 
> You definitely should **NOT** resize your catdir to type 19 (or any
> other filetype)! :)
> 
> 
> Regards,
> David
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Norman, David (Health)
> Sent: Wednesday, 27 May 2009 4:02 PM
> To: 'u2-users@listserver.u2ug.org'
> Subject: [U2] Truncated catdir names
> 
> I made an unpleasant discovery when I recataloged (normally) one of my
> accounts (UV10.0, HP-UX).
> Some of the catalog names became too long (e.g.
> *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the
> catalog
> process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I
> had
> several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO,
> .NW,
> .RV, & .SE). All of these resulted in the same truncated name so only
1
> catdir
> entry was created, which was for the last one of the 5 cataloged. The
> catdir
> path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of
> *GET.COUN  .
> Trying to run the programs results in a warning "File name
> *SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE" too long. Truncated to
> "*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE."
> 
> Is this a known limitation ? Why does the directory nesting stop at
the
> 2nd
> level ? The VOC entries show the full names.  catdir is type 1 out of
> the
> box.
> 
> 
> David Norman
> Senior Software Engineer - SA Ambulance Service
> 
> ** 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
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Paragraphs and procwrite

[phil walker]

Okay, you can use @system_return_code or @userx to do this. They can
both be checked in the Paragraph after returning from the BASIC program
to see what happened.

If you want to know how let me know.

Cheers,

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of roy
> Sent: Tuesday, 26 May 2009 1:31 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Paragraphs and procwrite
> 
> To explain a little better ...
> 
> The paragraph calls many other procs and paragraphs as well as a
number
> of
> basic programs.  What I found is that if someone exits a basic
program,
> control is returned to the calling paragraph.
> 
> Since the paragraph is in use I cannot modify it and accomplish
> anything
> that way.
> 
> Obviously reading something from the command line won't work in this
> circumstance.
> 
> With a PQ type proc I could set a flag like INVALID and procwrite it
> back to
> the calling paragraph for testing to see if the proc should continue.
> 
> I believe the idea of using @user0 may work but I haven't had a chance
> to
> test it.
> 
> I was also hoping to avoid writing something to a file since there are
> many
> instances of this and clearing the flags could be a problem.
> 
> Thanks again,
> 
> Roy
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: Sunday, May 24, 2009 8:07 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Paragraphs and procwrite
> 
> Maybe I have come in late or are missing something in the question but
> can't you just use:
> 
> Command = 'paragraph ':arg1
> Execute Command
> 
> Then in the paragraph
> 
> Do something like
> 
> PA
> * <>
> 
> Cheers
> 
> Phil.
> 
> > -Original Message-
> > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> > us...@listserver.u2ug.org] On Behalf Of Jacques G.
> > Sent: Monday, 25 May 2009 12:01 p.m.
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] Paragraphs and procwrite
> >
> > You can have the basic program generate the paragraph dynamically,
> and
> > save it in the Voc under a temporary name.  You can even have that
> > paragraph delete itself when it is done.
> >
> >
> >
> > - Original Message 
> > From: Brian Leach 
> > To: u2-users@listserver.u2ug.org
> > Sent: Saturday, May 23, 2009 7:45:04 AM
> > Subject: RE: [U2] Paragraphs and procwrite
> >
> > Hi
> >
> > You could use one of the user-defined system variables: e.g. @USER0
> >
> > E.g.
> > PA
> > CallMyProgram
> > IF @USER0 = "SomeFlag" GO DoSomething
> >
> > PROGRAM CallMyProgram
> >   @USER0 = "SomeOtherFlagActually"
> > END
> >
> >
> > > -Original Message-
> > > From: owner-u2-us...@listserver.u2ug.org
> > > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of roy
> > > Sent: 22 May 2009 23:15
> > > To: u2-users@listserver.u2ug.org
> > > Subject: [U2] Paragraphs and procwrite
> > >
> > > Hi all,
> > >
> > >
> > >
> > > Is there a way to accomplish passing an argument from a basic
> > > program to a paragraph?
> > >
> > >
> > >
> > > Something like what procwrite does with a Proc?
> > >
> > >
> > >
> > > Thanks
> > > ---
> > > u2-users mailing list
> > > u2-users@listserver.u2ug.org
> > > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Paragraphs and procwrite

[phil walker]

Maybe I have come in late or are missing something in the question but
can't you just use:

Command = 'paragraph ':arg1
Execute Command

Then in the paragraph

Do something like

PA
* <>

Cheers

Phil.

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Jacques G.
> Sent: Monday, 25 May 2009 12:01 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Paragraphs and procwrite
> 
> You can have the basic program generate the paragraph dynamically, and
> save it in the Voc under a temporary name.  You can even have that
> paragraph delete itself when it is done.
> 
> 
> 
> - Original Message 
> From: Brian Leach 
> To: u2-users@listserver.u2ug.org
> Sent: Saturday, May 23, 2009 7:45:04 AM
> Subject: RE: [U2] Paragraphs and procwrite
> 
> Hi
> 
> You could use one of the user-defined system variables: e.g. @USER0
> 
> E.g.
> PA
> CallMyProgram
> IF @USER0 = "SomeFlag" GO DoSomething
> 
> PROGRAM CallMyProgram
>   @USER0 = "SomeOtherFlagActually"
> END
> 
> 
> > -Original Message-
> > From: owner-u2-us...@listserver.u2ug.org
> > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of roy
> > Sent: 22 May 2009 23:15
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Paragraphs and procwrite
> >
> > Hi all,
> >
> >
> >
> > Is there a way to accomplish passing an argument from a basic
> > program to a paragraph?
> >
> >
> >
> > Something like what procwrite does with a Proc?
> >
> >
> >
> > Thanks
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] DATE.FORMAT illegal when a transaction is active

[phil walker]

Universe triggers start an implicit transaction. As a transaction
requires that is is recoverable, then by default Universe does not allow
the execution of certain verbs within a transaction. You get around that
by putting an H into field of the VOC entry as suggested.


> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Ken Ford
> Sent: Thursday, 16 April 2009 2:52 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] DATE.FORMAT illegal when a transaction is active
> 
> Thank you to those who assisted with this issue.  Adding 'H' to the
> DATE.FORMAT verb did the trick.   However, it is not apparent why it
> did!
> Perhaps Universe thinks it is running a transaction when a file
trigger
> subroutine executes.  No transaction was active.
> 
> Regards,
> 
> Ken Ford
> 
> Universe Software Developer
> 
> [cid:image001.gif@01C9BE8F.CF28AD00]
> 
> Phone:
> 
> (07) 3013 8686
> 
> Email:
> 
> ken.f...@firstmac.com.au
> 
> Web:
> 
> www.firstmac.com.au
> 
> 
> 
> 
>
###
> ##
> 
> This email (inc all attachments) is for the use of the intended
> recipient(s)
> only.
> Privileged or confidential information may be contained in this
> communication.
> If you have received this email in error, please notify the sender
> immediately
> and then
> delete all copies of this message from your computer network. If you
> are not
> the
> intended recipient, you must not keep, use, disclose, copy or
> distribute this
> email
> without the author's prior permission. If you are the intended
> recipient and
> you do
> not wish to receive similar electronic messages from us in future,
then
> please
> respond to the sender to this effect.
> 
> We have taken precautions to minimise the risk of transmitting
software
> viruses, but
> advise you to carry out your own virus checks on this email and its
> attachments. We
> do not accept liability for any loss or damage caused by software
> viruses and
> do not
> represent that this transmission is free from viruses or other
defects.
> 
> FirstMac Limited (ABN 59 094 145 963)  (AFSL 290600)
>
###
> ##
> 
> 
> [demime 1.01d removed an attachment of type image/gif which had a name
> of image001.gif]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] universe sockets

[phil walker]

Sorry I was not clear enough. I was agreeing with Symeon, about the use
of classes to encapsulate the BLL from the DAL? Mind you, you could use
sockets in the DAL if you must ;-).

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of doug chanco
> Sent: Tuesday, 14 April 2009 2:16 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] universe sockets
> 
> I hope so, because I would like to develop an in house iphone app that
> our
> users can use to query our database for prices/quantity available and
> sadly
> Apple only allows socket access to the closed iphone OS.
> 
> If anyone has a pick server socket solution they would like to share
> I'd
> appriciate it (answering requests and spawning a program to handle
each
> incoming request) otherwise I may go the route of moving the socket
> server
> to the OS (using init.d to handle incoming requests and to spawn a
> program
> to handle each request).
> 
> But I think I am getting close (to getting a working non blocking pick
> socket server) and if I get it to work I'll post what I have to the
web
> site.
> 
> dougc
> 
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker
> Sent: Monday, April 13, 2009 5:36 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] universe sockets
> 
> Maybe someone could put an example of this on the U2ug website, or
> Brian
> could include it in his training materials if he has not already so
> that
> people have an idea how to accomplish this ;-).
> 
> > -Original Message-
> > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> > us...@listserver.u2ug.org] On Behalf Of Symeon Breen
> > Sent: Tuesday, 14 April 2009 9:30 a.m.
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] universe sockets
> >
> > > We want to explore other connection options that are not tied to
> > > uniobjects so that if we decide to switch from universe to say
> > database
> > > "x" we can do so easier.
> >
> >
> > My only comment on this is don't go writing socket code just for
this
> -
> > just
> > write a wrapper round the uniobjects code - so your code does not
> open
> > a
> > uniobjects connection and do read/write/select/run programs, it uses
> a
> > class
> > that you have written that in turn does this - pass a param to the
> > class
> > called DB and set it to "uv" - then when you want to switch to some
> > other DB
> > add the connectivity code to your class and away you go - basically
> you
> > are
> > building a DAL (Data access layer) upon which your BLL (business
> logic
> > layer) works - the bll does not care what the DB is or how it
> > communicates
> > that is the job of your DAL.
> >
> > Rgds
> > Symeon.
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] universe sockets

[phil walker]

Maybe someone could put an example of this on the U2ug website, or Brian
could include it in his training materials if he has not already so that
people have an idea how to accomplish this ;-).

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Tuesday, 14 April 2009 9:30 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] universe sockets
> 
> > We want to explore other connection options that are not tied to
> > uniobjects so that if we decide to switch from universe to say
> database
> > "x" we can do so easier.
> 
> 
> My only comment on this is don't go writing socket code just for this
-
> just
> write a wrapper round the uniobjects code - so your code does not open
> a
> uniobjects connection and do read/write/select/run programs, it uses a
> class
> that you have written that in turn does this - pass a param to the
> class
> called DB and set it to "uv" - then when you want to switch to some
> other DB
> add the connectivity code to your class and away you go - basically
you
> are
> building a DAL (Data access layer) upon which your BLL (business logic
> layer) works - the bll does not care what the DB is or how it
> communicates
> that is the job of your DAL.
> 
> Rgds
> Symeon.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] SQL a possibility?

[phil walker]

SELECT FILENAME SAVING SWITCHIT

Will work from TCL I believe

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Thursday, 2 April 2009 11:01 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: [U2] SQL a possibility?
> 
> I'm trying to save the first field of a .csv file to a select list,
> Yes, I can
> write  a program,
>but I also wanted to try to do it on the fly.
> 
> Using UV10.0.2 , unix on Information format
> 
> The source data looks like:
> '#12345566#','first','last',.
> '#12344555#','first','last',.
> 
> Basically, field one has the item ID of another file.
> 
> The source file gets read into a tempory file input file
> 
> I created an I-desc of the following:
> 
> SWITCHIT
> 0001: I
> 0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ;
> FIELDS(@1,REUSE(","),REUSE(1))
> ;
>   CONVERT(REUSE('"# '),REUSE(''),@2)
> 0003:
> 0004: DATA
> 0005: 20L
> 0006: M
> 
> The above will convert the whole record into one mutlivalue attribute,
> then strip off the first field delimited by the ","
> then strip out the # ,' and spaces
> 
> LIST FILENAME ITEMNAME SWITCHIT ID-SUPP   will list to the screen
> exactly what
> I want
> and so does
> SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME';
> 
> NowHow can I put that data into a saved-list? (Using either TCL or
> SQL?)
> for that matter, how do you save a list using SQL on Universe? I tried
> creating a view, but was told I
> had to create a schema in order to create tables...that's no
fun...
> 
> I could open a como file, list the output with no headings close the
> como
> file,
> edit it clean, the form-list the como file (work around 1)
> 
> George
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Does anybody have a hot backup server?

[phil walker]

If you have a cold backup server I believe it is free, but you do need
to get another license and sign an agreement.

What we do is, we have Universe installed and licensed on the DR machine
but not running. We use rsync to copy the data files from production to
dr on a regular cycle. When production goes down we start up the DR
machine and carry on.

Of course this solution is not completely failsafe, as the application
does not use transactions so it is possible that partial transactions
may be committed to dr depending on timing etc, so it may not suit
everyone, but it is enough for our needs.

Phil.

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Brutzman, Bill
> Sent: Thursday, 19 March 2009 9:16 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Does anybody have a hot backup server?
> 
> If it is Unix, consider using cron to copy data from A to B every hour
> or so.
> 
> I talked with IBM a while back on this.  My recollection is that IBM
> said we would have to buy UV user licenses for both machines.  We had
> some additional big $ license issues here so for us, that issue went
> away.
> 
> We are living with daily manual backups to both a portable hard drive
> (that goes offsite) and a local XP PC.
> 
> --Bill
> 
> 
> 
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell
> Sent: Wednesday, March 18, 2009 3:07 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Does anybody have a hot backup server?
> 
> I am trying to put together a backup strategy that involves keeping a
> standby server within two data hours of the primary. The idea is to be
> able to have users log into the backup server and keep the business
> running in the event of a crash.
> 
> I'd like to hear what solutions others have found for this.
> 
> I've been trying to contact IBM for the last 6 months but they haven't
> answered and my ERP vendor doesn't know how to do this.
> 
> Any ideas are appreciated.
> 
> TIA
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Common UNIX Printing System

[phil walker]

Yes on RHEL 4.0

> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
> us...@listserver.u2ug.org] On Behalf Of Bertrand, Ron
> Sent: Friday, 27 February 2009 12:46 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Common UNIX Printing System
> 
> Hey all - is anybody using CUPS with universe?
> 
> Ron Bertrand
> Analyst,AP SYS 3
> ISD/LIS/AMS
> Group Health Coop
> 206-901-4519
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV, Linux, and Active Directory

[phil walker]

We use Centrify DirectControl to do this.

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman Bauer
Sent: Wednesday, 28 January 2009 2:00 p.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] UV, Linux, and Active Directory

I am still learning UV, it's been a long three months of learning, but
I have to say that I really do like it. That being said, we run it on
Windows Server 2003. We recently tried to deploy it on Server 2008
which IBM says is possible in the docs. However it will not run on
Server 2008. My suggestion to my boss was to try running it on CentOS
5, when I was promptly rebuked for the idea. I was told that if we
were to do that our UV accounts could not authenticate against Active
Directory. And that may be somewhat tue given that our authentication
module was custom written.

How are you authenticating against AD on Linux? I would be very
interested in knowing, because I would love to move us off of UV for
Windows and run it on Linux because there is so much that I personaly
know that I can do running it on Linux that it takes major hoops to
pull of on Windows but is realatively trivial on Linux, like PDF
printing, Python scripting, Postgresql integration, Apache tricks,
etc;.

Thanks,

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