--- [EMAIL PROTECTED] wrote:
I need to run the WIN.IMPORT routine from a phantom and I can't seem to be
able to do this. Is there any way run file transfers that convert a file to
dbf format from within UV via a phantom process. Running UV 9.5.x on NT4
Thanks for any insight,
Les
Hi
It's also in the online help...
HELP FORCE
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 3:34 PM
To: [EMAIL PROTECTED]
Subject: RE: How to display a heading with a SELECT statement?
It does work with
Thanks Wendy. I appreciate your help.
Mark.
-Original Message-
From: Wendy Smoak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 5:57 PM
To: U2 Users Discussion List
Subject: RE: UOJ - UniSession Timeout
On Behalf Of Daly, Mark
I've tried using the UniSession setTimeout()
Hi all,
IBM initiated a metric called Function Points that attempts to provide a
means for measuring programming tools by the amount of code that has to be
written in order to produce a program of a certain complexity.
There have been several studies by which programming languages have been
Here is the basic structure I've been using in my export programs. It does
require that the directory you are working in is setup in the VOC for the
DELETE to work - I just wanted to be extra sure that it wouldn't pick up
anything from a prior run.
EXECUTE DELETE CONVERT.FILE, 'EXPORT.TXT'
I've worked with the function point methods for some time and I don't
think MV BASIC has been mapped. You could check with Dave Garmus, who is
a central figure in FP (Google him, he comes up near the front).
In order to do it you need to run some statistics against a number of
carefully selected
I'm back. I lost my machine yesterday afternoon.
-Original Message-
From: Larry Hiscock [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 2:21 PM
To: 'U2 Users Discussion List'
Subject: RE: [UD] OPENSEQ, WEOFSEQ, CLOSESEQ
Comments inline:
What version of UD are you running?
It's nice to have options.
My thanks again for the suggestions.
I'm going hunting for that post that Bruce was talking about. If
someone else finds it before me, feel free to shoot it my way. 8^)
Shawn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
I am hopeful someone can offer me some guidance.
I have to move data off of my Universe system and send it to a PC for
inclusion in a Excel Spreadsheet.
Some background:
Source data is alpha/ numeric and contains VM's, SVMs and TM
Source data fields are variable lengths
Requirements:
Output
In a message dated 4/14/2004 6:36:10 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
I've worked with the function point methods for some time and I don't
think MV BASIC has been mapped. You could check with Dave Garmus, who is
a central figure in FP (Google him, he comes up near the
I have a Universe ODBC connection with a client application as follows:
We have a Windows XP based application called ID Works by Claritus.
It is an application to take photo ids; print an id card with the
photo, barcodes and other information.
I have a Universe account setup with the necessary
First off, what are you planning to do with the data once you have it in
Excel? In most cases it won't be useful unless you explode/flatten the
data out. We have a few (UniData) solutions for turning LIST/SORT/CT
output into symbolic link/html(with or without table view)/csv files,
and use
Jim the short answer is you can't.
You can however strip all non printable characters by passing the data
through OCONV(mydata, MCP)
This turns all non printables into the period character .
To seperate your fields, pass the data through a conversion like
CONVERT(VM,|, mydata)
which will turns
You might look at Cedarville Download (ftp.cedarville.edu). Its a free
utility written in UD/UV Basic that will output CSV, HTML, XML, and DIF
files (all of which are directly readable by Excel) from command line
queries.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Jim,
I don't see why on earth you want to use fixed length data with Excel.
Do you need to normalize the data or are you intending to use multi-line
cells?
The best way to importing multiline cells into Excel is to generate a HTML
file that represents the spreadsheet cells as an HTML table.
In a message dated 4/14/2004 8:29:24 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
If you are normalizing the data, you can dump the data into an XML format
using an exploded SORT with the TOXML keyword. You can then load that
directly, at least if you are running Excel 2003.
Brian,
We are a Unix shop using Unidata 5.7. We are being asked to upgrade to 6.0 in our LIVE
system without much advanced preparation. If there is anybody who can point to
anything that we should be concerned or aware of, your input is highly desired. We are
scheduled to do this on 4/24 so don't have
The best way to importing multiline cells into Excel is to generate a HTML
file that represents the spreadsheet cells as an HTML table. You can then
import line breaks using the HTML br tag. It requires a few lines of
code,
but it is pretty trivial.
Has anyone ever tried using the SYLK
1) obtain a revolver loaded with one round.
2) take it to the office(s) of the person(s) involved and ask them to spin
the cylinder, point the gun to their head, and squeeze the trigger
3) if they refuse feign a suprised look and remind them that what they are
asking you to do is functionaly then
Jim,
What are you plans? Do you plan to do an upgrade or concurrent install? We do
concurrent installs and switch the pointers in our accounts to point to the new
install. In the past we have had global routines that needed to be pointed to and
test with the new account. Now we do local so
I use it all the time using our inhouse utilities and it works well. I
do remember something strange in the totalling logic of sylk, something
about being relative to the current row I believe.
Rich
Chuck Mongiovi wrote:
The best way to importing multiline cells into Excel is to generate a
True,
But Jim didn't specify his version of UniVerse.
if his version does support TOXML it may still be the simplest option, and
avoids having to do any coding.
If not, it is always available on the Personal Edition ...
Brian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Brian, not every implementation supports TOXML keyword
Will
But they all support Cedarville DOWNLOAD, which works better than the
TOXML keyword anyway. It will catch up, I'm sure, but for now, DOWNLOAD
is
Jim;
As you may have noticed from the replies: there are a number of ways to do
this. Depending on the number of files/fields and the frequency you want to
do this, and any connection options you currently have will affect your
final choice.
You may want something powerful like a data
Not as described. The phantom does not have a client, therefore the
win.import has nothing to talk to.
However, a few days ago, someone posted some source code for reading DBF
files within a basic program directly.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
I need some clarification.
Given the following:
X.DIR = X.HOME.WALDIES; * the VOC item 'X.HOME.WALDIES' is a
pointer to /home/waldies
X.FILE = SRW_TEST_SEQ.txt
OPENSEQ X.DIR,X.FILE TO FV.SEQ THEN
WEOFSEQ FV.SEQ
ELSE
...
END
Upon a successful open of X.DIR at X.FILE, will the
if the file x.file exists, it will write an end of file marker on it.
+-erasing what was in x.file.
it won't ( should not ) clear the x.dir directory.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Shawn Waldie
Sent: Wednesday, April 14, 2004 1:49 PM
To: U2
From: Shawn Waldie [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 1:48 PM
I need some clarification.
Given the following:
X.DIR = X.HOME.WALDIES; * the VOC item 'X.HOME.WALDIES' is a
pointer to /home/waldies
X.FILE = SRW_TEST_SEQ.txt
OPENSEQ X.DIR,X.FILE TO FV.SEQ THEN
WEOFSEQ
It will only clear whatever data is already in X.FILE.
It appears I made an incorrect statement in a previous post, and I must
correct myself. I previously stated that WRITESEQ will overwrite and
effectively clear a file. It does not.
The sequential file must be positioned at the end of file
- Original Message -
From: Lee Leitner [EMAIL PROTECTED]
To: U2 Users Discussion List [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 3:34 PM
Subject: Re: Productivity metrics
The other thing to do is try to interpolate using existing, measured
langauges. Indeed it might be fair
One last note on the AIX/UD6/DataStage issue; it appears that logging set
at 32 is indeed the only work around that I can get working, but IBM has
beat me to the punch when it comes to what to do with the log files.
Apparently defining dev/null in uniapi_admin as the log directory ends up
First, let me qualify this by saying we are not yet up on UD6 on our
production box. We are testing UD6 on our development box on Solaris and
seeing none of these problems. Is this just an AIX issue? It would be good
to know before we go live. Thanks Rod
-Original Message-
From: David
U2 TO DB2 --- Best thing to Happen.
Hopefully IBM will start integrating all IBM DB's into Flagship RDBMS
UDB.
Joe Eugene
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On
Behalf Of Roger Glenfield
Sent: Tuesday, April 13, 2004 11:21 PM
To: U2 Users
Re. item 1: Why a revolver? Give the person a semi-auto pistol
instead. Given their demonstrated intelligence, the difference would go
unnoticed.
At 08:40 AM 4/14/2004, Jeff Schasny wrote:
1) obtain a revolver loaded with one round.
snip
ob. advice: back up everything to tape first. Do it
U2 TO DB2 --- Best thing to Happen.
H... I don't think I'll touch that one other than to say that only time will tell.
Tom Firl
Columbia Ultimate
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
I don't really care what the backend DB engine is as long as I can use my
favorite set of tools to develop applications. But if a change to DB2 or
whatever is going to force me to severly change the way I operate, then I'd
see that as a bad thing.
Gordon J. Glorfield
Sr. Applications Developer
I am no expert on DOWNLOAD. However, today I loaded a new 7.10 version
for our development account (live and test will remain on 7.02 until
confirmation of functionality). About 10 minutes after I ftp'd the zip
file from cedarville, I was up and running on 7.10. The readme at
ftp.cedarville.edu
Can anyone share any experience they've had calling a RedBack RBO from .NET?
I've tried the following methods:
1. OleDbConnection to the RedPages OLE DB Provider: results in an error when
trying to call the RBO's .Create() method.
2. ADODB Connection (via COM Interop) to the RedPages OLE DB
There are a variety of ways that this can be achieved.
1. the records are stored in the relational database as a raw string
including value marks etc. This is meaningless data to DB2 users.
2. The data is converted into two dimensional databases, requiring data
typing, length definitions, etc.
We are migrating from a unix box, to Windows 2000 server, and have a 3rd
party spooler application called JRT. There is no JRT spooler app for
windows. It is a slick little app that uses SP commands to manipulate jobs
in the spool queue.
I know printing on windows is handled by print manager, but
2. The data is converted into two dimensional databases, requiring data
typing, length definitions, etc. Dirty data will be an issue that can
be covered a number of ways. The data will still look multi dimensional
to the application.
PostgreSQL supports multidimensional arrays, so perhaps DB2
Frank Bright wrote:
What are you plans? Do you plan to do an upgrade or
concurrent install? We do concurrent installs and switch the
pointers in our accounts to point to the new install. In the
past we have had global routines that needed to be pointed to
and test with the new account.
The way that jBase handles the problem is by requiring the database be
flattened out (i.e., no multivalues) and strict data typing. This is of
course the standard with 1NF databases. Unfortunately for most of us, it
means a complete redesign of the existing mv database structure. Over the
past
Yes, an RDBMS is still a costly investment for any company and that won't
change by front-ending it with what is otherwise bigger-bang-for-the-buck
software. The way DB2 does constraint-handling, strong-typing,
NULL-handling, etc are likely to be reasons to stick with what works and
doesn't
OK, Joe. So you subscribed under a different address to get around
having your inflammatory postings moderated. That is a clear act of
unwillingness to cooperate with the policies of this list.
buh-bye
plonk
*** END OF THREAD ***
DO NOT REPLY TO THIS THREAD ANY FURTHER
(That means *anyone*
*** END OF THREAD ***
DO NOT REPLY TO THIS THREAD ANY FURTHER
(That means *anyone* not just the poster of the message used for the
Moderator reply)
On Apr 14, 2004, at 13:39, Tom Firl wrote:
U2 TO DB2 --- Best thing to Happen.
H... I don't think I'll touch that one other than to say that
*** END OF THREAD ***
DO NOT REPLY TO THIS THREAD ANY FURTHER
(That means *anyone* not just the poster of the message used for the
Moderator reply)
On Apr 14, 2004, at 13:45, Gordon Glorfield wrote:
I don't really care what the backend DB engine is as long as I can use
my
favorite set of
I have a product called ESP (Extended SPooler) that can replace JRT. It
runs on both Unix, Linux, and Windows UV systems. UD is in the works.
(Did I mention that it cost a *lot* less grin)
Please contact me off line or at the number below for more details.
--
Regards,
Clif
I thought this was done behind the scenes ? For our part we are looking with
interest at what comes out of the mix in terms of XML databases over the next 18
months or so from the big 3 - Oracle, SQL Server DB2.
If we get these facilities natively from U2 (or another mv player), great. If
The other interesting thing I noted @ the HELLO WORLD site was that we had FULL source
code for things like delphi - even though 99.9% was produced automatically from the
IDE !
Ross Ferris
Stamina Software
Visage an Evolution in Software Development
-Original Message-
From: [EMAIL
Oh boy, I can smell the debates regarding programming styles in lieu of
reducing lines of code. Could this be where GOTO's have their day.
my 1 cent.
- Original Message -
From: Bob Dubery [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 7:24 AM
Subject: Productivity
I did not mean to kill the part of the discussion that was being held
under the previous Subject line that was talking about other-than-U2
datastores in a U2 environment. I seem to have caused some confusion
with my end-of-thread notice under that subject line. I was only
referring to
In the words from Hitchhiker's Guide, Oh, no. Not again.
On Apr 14, 2004, at 19:42, Mark Johnson wrote:
reducing lines of code. Could this be where GOTO's have their day.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Hi Steve
Just to correct you, jbase does not require you to move to 1NF files to
run on an RDBMS. Jbase will port multi dimensional data across to an
RDBMS and automatically handle the conversion to multiple tables
invisible to the application. The issue is in the quality of the
dictionary,
It is complex topic and more than a bit off-topic for this forum...also a
very very dry subject. *Yawn* ;-)
I'm not wanting to discuss the actual metric. We're having the regular
debate about should we keep going with UV and if not what should we
consider. One of the strengths of MV platforms
55 matches
Mail list logo