Sara Burns | 1 Mar 02:05 2004


There are times you just hang your head in shame.  This is one of those.

My problem with $OPTIONS TIME.MILLISECOND was that I could not type.  Within
my include file I had milliseconds (plural).  This would have just done
nothing except that the command before it was $OPTIONS PICK.  Put together
these reverted to the default for PICK obviously using seconds.  Not what I

Thanks to those who helped me investigate this more fully.  You learn
something new every day.

Apologies for responding so late but I was on leave on Friday and my home
email address is rejected by the list.

Sara Burns

Sara Burns (SEB) 
Project Leader (Vantive)
Public Trust 
Phone: +64 (04) 474-3841 (DDI) 

Mobile: 027 457 5974
< <mailto:Sara.Burns <at>> mailto:Sara.Burns <at>>

Information contained in this communication is confidential. If you are not
the intended recipient the information should not be used, disclosed, copied
or commercialised. The information is not necessarily the views nor the
official communication of Public Trust. No guarantee or representation is
made that the communication is free of errors, virus or interference.
(Continue reading)

mkmullane | 1 Mar 02:13 2004

Help on Initiating Wintegrate Import/Export Routine From TCL or as a Subroutine Call

I would like any advice on initiating import &/or export macros in Wintegrate either 
directly from TCL or as a subroutine call.   We have a requirement for lots of these 
processes, but the problem is that the contents of the macro can be variable, & 
sometimes users don't realise this or enter the wrong thing.   If they could be 
initiated from either TCL, or called via a subroutine in Universe (or both), then that 
would be great.   I would be grateful if anyone can provide examples, or souce 



u2-users mailing list
u2-users <at>

Scott Richardson | 1 Mar 02:42 2004

Re: telnet

Have you applied any Microsoft Windows XP Secrity or Critical updates
Perhaps running a firewall like Zone Alarm, or Norton Internet Security?

Try setting the UV telent port to something like 2051.
Have you changed Windows User Logon and or Password recently? Changed the
Systems name, WorkGroup, or IP Address?

Double checked the Administrative Tools - Services - Properties? See if you
start it from there. If not, sometimes it yields or more descriptive clue as
to why it
won't start from there.

What's eventlog say?

----- Original Message ----- 
From: "Greg York" <gregyork <at>>
To: "'U2 Users Discussion List'" <u2-users <at>>
Sent: Sunday, February 29, 2004 5:35 PM
Subject: RE: telnet

> Hi David
> The telnet service isn't started. Any other things to look at?
> This dam thing as been running without any problems for a long time, the
> only config or additional software that has been installed is a new 10.6
> of VET
(Continue reading)

Stuart Boydell | 1 Mar 03:06 2004

RE: [UV] XML conversion in UV 10.1

Hi John,
We are using UV/10.0.17/aix to receive and convert XML documents. This works
quite well. It uses an extraction document, which is based on a subset of
XPath to extract data from XML documents and formats the output into a
dynamic array. Semantically, it's not always obvious why there are certain
requirements for the extraction document but, it works.

We parse documents into a number of dynamic arrays, correlating to our file
structures. There's a small amount of Basic code to prepare and parse the
XML and handle error conditions.

I believe that the changes for 10.1 are all positive with more Basic
functions and better access to the DOM.

XML to CSV. The method to use for that would be XSL/XSLT - the tool depends
on what skills you have available to roll you own using Java, Perl, MSXML,
etc or want to buy. Search GOOGLE you will find plenty of examples ("convert
XML to CSV" = 101 hits).


> -----Original Message-----
> From: u2-users-bounces <at> [mailto:u2-users-bounces <at>]On
> Behalf Of John Hester
> Sent: Saturday, 28 February 2004 07:41
> To: U2 Users Discussion List
> Subject: [UV] XML conversion in UV 10.1
(Continue reading)

Bob Modrich | 1 Mar 05:25 2004

UniVerse to excel feeds

Hi Don,
	About 2 monthes ago I was looking for the same type of program. I wanted to
parse hold files and send directly into excel all automatically formatted.
It would be great if IBM could add a feature to the U2 spooler for at least
their report writer ie (List/Sort) routines to send to hold files with a
delimited format.
I solved this by writing a program that reads a spooled hold file and
then parses the columns. I then used excel automation in the program
to format columns, autofit columns, format cells etc. This worked well until
I deployed program on the Unidata windows server and ran across a
number of issues with using excel this way. Microsoft has documented some of
the issues at;EN-US;q257757

They say "Microsoft does not currently recommend, and does not support,
Automation of Microsoft Office applications from any unattended,
non-interactive client application or component (including ASP, DCOM, and NT
Services), because Office may exhibit unstable behavior and/or deadlock when
run in this environment."

Having gove down this route I found a company called Aspose that has  a .net
dll which provides an object model which can be used to format and write
excel files without having excel loaded. Their web site is
It took me about a week to incorporate their object model into my project
and it has been successful. The only requirement for the hold file is that
each column heading must end in a (.) period so that the parser knows where
a column ends.
The .net program gets executed from a  unibasic program and then if the user
wants to open the .xls file after parsing and formatting takes place the
networked .xls file is automatically opened by Excel on the client computer.
(Continue reading)

Tony Gravagno | 1 Mar 06:50 2004

RE: UniVerse to excel feeds

Bob Modrich wrote
>This worked 
>well until I deployed program on the Unidata windows 
>server and ran across a number of issues with using excel this 
>way. Microsoft has documented some of the issues at 

>They say "Microsoft does not currently recommend, and does not support,
> Automation of Microsoft Office applications from any unattended, non-
> interactive client application or component (including ASP, DCOM, and NT
> Services), because Office may exhibit unstable behavior and/or deadlock
> run in this environment."

Except for reentrancy and scalability, it's relatively easy to code around
all of the issues they've presented.  I think their statement is less
technical and more intended to discourage multi-user access to Excel.  It's
designed and licensed as a single-user desktop app, and they don't get paid
for multiple users in a networked environment.

Nebula R&D
TG <at>


u2-users mailing list
u2-users <at>

(Continue reading)

gerry simpson | 1 Mar 09:39 2004

Re: [UV] Trigger FILE parameter

Hi Ray ,

this does not work. LIST.SICA always lists the file name as it was when the
1st trigger was created even if the triggers are dropped and recreated.

----- Original Message ----- 
From: "Ray Wurlod" <rayw <at>>
To: "U2 Users Discussion List" <u2-users <at>>
Sent: Saturday, February 28, 2004 7:45 AM
Subject: Re: [UV] Trigger FILE parameter

> The only way to modify the SICA after a CNAME is to drop the trigger and
create it afresh.
> -- 
> u2-users mailing list
> u2-users <at>


u2-users mailing list
u2-users <at>

Brian Leach | 1 Mar 10:46 2004

RE: When is developing with UniObjects the correct approach?


UniObjects is the quickest route for client/server work with U2. It emulates
the native model for direct file and stored procedure operations - you open
a file, read a record by key, perform operations, write it back. Fast and
very efficient for transactional applications.

The advantage/disadvantage of UniObjects is that it is a permanent per-user
connection. In other words, each Objects session operates as a database
user, just like a TELNET session. This is essential for integrating with
BASIC procedures that expect things like common (persistent) variables to
remain between calls and that use pessimistic locking (the default for U2
systems). If you are writing a transactional application for a predictable
number of users, UniObjects is the way to go.

BTW the best way to consider using UniObjects (and we've been using it since
day one of its release) is to code all of your procedures in BASIC on the
server first, unit test them, then write the front end to deploy against
them. Makes debugging in a 'black box' environment very much easier, and
allows you to gain performance improvements by keeping the logic close to
the server.

Now the drawback is if you want to deploy into a Web/Browser based
environment, or any environment where you want to scale up the number of
users without scaling up the number of sessions on the database (e.g. a
public service where the number of users cannot be predicted) UniObjects
does not provide that ability (for the reasons above). For that, you need to
use a tool like RedBack, which is specifically designed around a responder

(Continue reading)

Greg York | 1 Mar 11:01 2004

RE: telnet


I found that 10.6 of VET was the cause, they told me to switch off email
monitoring and hey presto telnet to the localhost was fine. 

-----Original Message-----
From: u2-users-bounces <at> [mailto:u2-users-bounces <at>] On
Behalf Of Logan, David (SST - Adelaide)
Sent: Monday, March 01, 2004 9:24 AM
To: U2 Users Discussion List
Subject: RE: telnet

Hi Greg,

Check to see the original telnet daemon hasn't started (should be in
services). Universe uses the same port and if it is already being used, you
will not be able to start the universe daemon.


David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000

+61 8 8408 4273
+61 417 268 665

(Continue reading)

Marco Manyevere | 1 Mar 11:08 2004

[UV] Recursive GOSUB

Hi All,

Can a UV GOSUB directly or indirectly refer to itself? Something like so:


Regards, Marco

  Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now

u2-users mailing list
u2-users <at>