Re: Wintegrate Phantom

2004-04-14 Thread Anthony Corrente
--- [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

RE: How to display a heading with a SELECT statement?

2004-04-14 Thread Hona, David S
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

RE: UOJ - UniSession Timeout

2004-04-14 Thread Daly, Mark
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()

Productivity metrics

2004-04-14 Thread Bob Dubery
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

RE: Productivity metrics

2004-04-14 Thread Brian Leach
By 'lines of code' I wonder what they mean? Lines of source code? Number of Actions? Source or executable statements? Ok, so how about an alternative - volume of typing? I've been doing some thread work with Delphi, which relies heavily on Borland's snappily named

Re: Productivity metrics

2004-04-14 Thread Bob Dubery
- Original Message - From: Brian Leach [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 1:55 PM Subject: RE: Productivity metrics By 'lines of code' I wonder what they mean? Lines of source code? Number of Actions? Source or

RE: [UD] OPENSEQ, WEOFSEQ, CLOSESEQ

2004-04-14 Thread alfkec
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'

RE: Productivity metrics

2004-04-14 Thread Brian Leach
Ok I see. Meaningless then. You can write some pretty hairy nested stuff into a single 'C' statement. How is that counted? If you call a library function, do you count all the lines in that function? If you execute a SQL command under TSQL, how much of the SQL library is included in the tally?

Re: Productivity metrics

2004-04-14 Thread Lee Leitner
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

RE: [UD] OPENSEQ, WEOFSEQ, CLOSESEQ

2004-04-14 Thread Shawn Waldie
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?

RE: [UD] OPENSEQ, WEOFSEQ, CLOSESEQ

2004-04-14 Thread Shawn Waldie
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:

UV to Text Conversion Standard?

2004-04-14 Thread james . ronan
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

Re: Productivity metrics

2004-04-14 Thread FFT2001
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

Universe ODBC question concerning Multi-valued Fields

2004-04-14 Thread Denny Watkins
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

Re: UV to Text Conversion Standard?

2004-04-14 Thread David Beahm
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

Re: UV to Text Conversion Standard?

2004-04-14 Thread FFT2001
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

RE: UV to Text Conversion Standard?

2004-04-14 Thread Jeff Schasny
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

RE: The future of U2

2004-04-14 Thread Tom Firl
Has any one heard any specifics about the implementation? I'd be interested in knowing whether or not Universe applications using DB2 as a data store will require setting up a Universe SQL schema. I'm supposing that it will... Tom Firl Columbia Ultimate -Original Message- From:

RE: UV to Text Conversion Standard?

2004-04-14 Thread Brian Leach
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.

Re: UV to Text Conversion Standard?

2004-04-14 Thread FFT2001
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,

New: Unidata 6.0 upgrade from 5.7

2004-04-14 Thread Yeatrakas,James
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

RE: UV to Text Conversion Standard?

2004-04-14 Thread Chuck Mongiovi
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

RE: Unidata 6.0 upgrade from 5.7

2004-04-14 Thread Jeff Schasny
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

RE: Unidata 6.0 upgrade from 5.7

2004-04-14 Thread Bright, Frank
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

Re: UV to Text Conversion Standard?

2004-04-14 Thread Richard A. Wilson
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

RE: UV to Text Conversion Standard?

2004-04-14 Thread Brian Leach
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

RE: UV to Text Conversion Standard?

2004-04-14 Thread Wendy Smoak
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

RE: UV to Text Conversion Standard?

2004-04-14 Thread alfkec
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

RE: Wintegrate Phantom

2004-04-14 Thread Troy Buss (Logitek Systems)
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]

WEOFSEQ

2004-04-14 Thread Shawn Waldie
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

RE: WEOFSEQ

2004-04-14 Thread Peter Olson
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

Re: WEOFSEQ

2004-04-14 Thread Allen Egerton
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

RE: WEOFSEQ

2004-04-14 Thread Larry Hiscock
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

Re: Productivity metrics

2004-04-14 Thread Dubery
- 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

RE: Objectcall headache...

2004-04-14 Thread David Litzau
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

RE: Objectcall headache...

2004-04-14 Thread Baakkonen, Rodney
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

RE: The future of U2

2004-04-14 Thread Joe Eugene
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: Unidata 6.0 upgrade from 5.7

2004-04-14 Thread Kent Walker
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

RE: The future of U2

2004-04-14 Thread Tom Firl
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

RE: The future of U2

2004-04-14 Thread Gordon Glorfield
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

RE: UV to Text Conversion Standard?

2004-04-14 Thread Morelli, David
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

Accessing RedBack RBOs from .NET

2004-04-14 Thread Tony Evans
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

RE: The future of U2

2004-04-14 Thread djordan
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.

Is anyone using a spooler wrapper for universe on Windows?

2004-04-14 Thread Bobby Ramirez
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

Re: The future of U2

2004-04-14 Thread Craig Bennett
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

RE: Unidata 6.0 upgrade from 5.7

2004-04-14 Thread Ken Wallis
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.

RE: The future of U2

2004-04-14 Thread Steve Mayo
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

RE: The future of U2

2004-04-14 Thread Dawn M. Wolthuis
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

[ADMIN] Re: The future of U2

2004-04-14 Thread Clif Oliver
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*

Re: The future of U2

2004-04-14 Thread Clif Oliver
*** 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

Re: The future of U2

2004-04-14 Thread Clif Oliver
*** 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

[AD] Re: Is anyone using a spooler wrapper for universe on Windows?

2004-04-14 Thread Clifton Oliver
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

RE: The future of U2

2004-04-14 Thread Ross Ferris
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

RE: Productivity metrics

2004-04-14 Thread Ross Ferris
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

Re: Productivity metrics

2004-04-14 Thread Mark Johnson
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

Database decoupling (Was: Future of U2)

2004-04-14 Thread Clif Oliver
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

Re: Productivity metrics

2004-04-14 Thread Clif Oliver
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

Jbase handles multivalue on RDBMS

2004-04-14 Thread djordan
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,

Re: Productivity metrics

2004-04-14 Thread Bob Dubery
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