[U2] Problems with the IBM DB2 U2 Dotnet provider and vista

2008-05-08 Thread David Jordan
Has anyone had a problem installing the new IBM.Net Data provider Ver 9.5 service pack onto Vista. When you double click on the setup.exe and click the Vista allow access, it comes back the program has stopped working. The Ver9.5 installed OK on Vista (it just does not connect to U2 databases), ho

DQM (was [U2] Using ETL to extract data from UD to SQL)

2008-05-08 Thread Clifton Oliver
I wanted to change the subject line to see is we Listizens have any interest in discussing Data Quality Management. How do you cleanse MultiValue non-typed data for integration with strongly datatyped non-MV applications? Anyone want to kick off the discussion? Regards, Clif -- W. Clifto

RE: [U2] UniVerse Triggers

2008-05-08 Thread Mike Randall
Brian, An excellent article. One that should be required reading by every systems architect that works in the U2 environment. I'm stunned that many don't realize the power in triggers, especially those of you supporting systems with no source! Again, great article. Mike Randall, MCP

RE: [U2] Using ETL to extract data from UD to SQL

2008-05-08 Thread Boydell, Stuart
There is going to be a lot of effort for any ETL (Extract, transform, load) on an 'heritage' database. You will have to deal with weird table/file structures (who did it and why is it that way?!!) and dirty data to get to a set of data suitable for your DW/reporting requirements. If you have deter

RE: [U2] Universe XML is not to standard

2008-05-08 Thread Boydell, Stuart
Spaces at top and bottom ... agreed. Other things - are to get rid of the spaces around the " = " signs - just annoying as it adds and extra 2 chars per field - in our situation we're dealing with hundreds of MBs of XML that already wend over the network, get stored somewhere ... However, my m

RE: [U2] Record Locking

2008-05-08 Thread Brutzman, Bill
When a program sets a lock... and then a subprogram (called by that program) needs to OPEN the same file/record... and it unlocks the first lock (or creates its own independent lock) then... the locksmith needs another combination. I want global record-locking without using global variables or COM

Re: [U2] [UV] Scared to recompile

2008-05-08 Thread David Scoggins
Maybe I'm missing something, but I think you might want to look at the VLIST command. Execute a VLIST on a LIVE program, capture the output, do a VLIST on TEST, capture that output, and compare the two. if they are substantially the same, great, if not, then proceed with caution. And once you ge

RE: [U2] Record Locking Problem

2008-05-08 Thread Bessel, Karen
There wasn't any code in his program that closed the file? Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com -Original Messa

Re: [U2] Record Locking Problem

2008-05-08 Thread George Land
Agreed, I've not seen anything in this thread that needed fixing. George Land www.u2k.com On 08/05/2008 21:22, "Wally Terhune" <[EMAIL PROTECTED]> wrote: > fix what? > I didn't follow this very closely as I don't recall even seeing what > database or version was referenced (though I may have mi

RE: [U2] Record Locking Problem

2008-05-08 Thread Wally Terhune
fix what? I didn't follow this very closely as I don't recall even seeing what database or version was referenced (though I may have missed that). If you have a locking defect, please open a support case and report it. Thanks

RE: [U2] Record Locking Problem

2008-05-08 Thread Doug Chanco
Your welcome BUT what does IBM need to fix? To me at least when a program sets a lock and then closes the file the lock should go away . if that's what needs to be "fixed" I for one hope they don't as I work on a lot of old crappy code that would seriously break were locks to be held op

RE: [U2] Record Locking Problem

2008-05-08 Thread Brutzman, Bill
Thanks to all those who responded, especially Rich Taylor. Perhaps IBM will fix this someday. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 - SQL Server ODBC Connection via Universe

2008-05-08 Thread Oaks, Harold
Marc: I am just now in the process of evaluating an "ODBC-ODBC bridge" from the British company Easysoft. There is a 14-day free trial of their products, which is nice. Another product they have is a specific ODBC-SQL driver that might be more efficient for your specific need to connect to SQL S

Re: [U2] Universe XML is not to standard

2008-05-08 Thread Rex Gozar
Dennis, Even with HDR.SUP, IBM sends FF and LF before the " Wouldn't it be easier to use HDR.SUP? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] RE: U2 - SQL Server ODBC Connection via Universe[AD]

2008-05-08 Thread Robert Houben
We have a product that uses JDBC to connect to SQL Server (various flavors - we've had to do both 2000 and 2005). It allows you to call subroutines that mimic the functionality of WRITE, READ, COPY and other commands to let you read/write single valued data to/from SQL Server, Oracle and others

RE: [U2] [UV] Scared to recompile

2008-05-08 Thread Robert Houben
The date and time of compilation are stamped into the object code. This means that you will always have a different binary and a different checksum. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 08, 2008 10:02 AM To

Re: [U2] UniVerse Triggers

2008-05-08 Thread Clifton Oliver
The Nov/Dec 2007 issue, available at: http://www.intl-spectrum.com/t/135520/link.aspx On May 8, 2008, at 5:35 AM, Brian Leach wrote: Mike If you check the recent issues (pdfs on their site) I wrote an article on triggers for Spectrum you might find useful. Brian -Original Message-

[U2] U2 - SQL Server ODBC Connection via Universe

2008-05-08 Thread Caminiti, Marc
Has anyone had success in setting up a ODBC connection from Universe to MS SQL Server 2005? We are needing to get data imported into SQL Server and I was hoping that there is an "easy" way for UniVerse to connect to the database and do the inserts on its own. Universe 10.0.9 running on Red Hat 7.

[U2] [UV] Scared to recompile

2008-05-08 Thread iggchamp
Hi all, UV10.1 / HPUX I have a situation that I am hoping you all can help me with. I want to move my program files from to a different directory. The problem is that the path to the programs are contained in the object code. I know that the debugger won't work if the program is a different

RE: [U2] Using ETL to extract data from UD to SQL[AD]

2008-05-08 Thread Robert Houben
We have a new product for Universe that allows you to do the equivalent of a read or write of single-valued PICK data directly to a relational table in SQL Server, Oracle, DB2, or whatever. We have customers doing this in real time on production systems, allowing them to keep their relational d

Re: [U2] Using ETL to extract data from UD to SQL

2008-05-08 Thread Jeff Schasny
I used Cognos Impromptu/Transformer/Powerplay about 8 years ago to develop a data warehouse product for a Universe based ERP vendor and at the time it accessed whatever database you pointed it at via ODBC. Is this not still the case? If so, here are some points to ponder: 1. ODBC is a horrendou

Re: [U2] Record Locking Problems

2008-05-08 Thread Richard Taylor
I assume that the SUB.LOCKED.SOH.RO is called to do the lock and then returns. The problem is that you open the file in this routine to do the locking against. Once this subroutine ends that file handle will go out of scope (it was defined local to this subroutine) and the file is closed. That r

RE: [U2] Universe XML is not to standard

2008-05-08 Thread Brian Leach
Keith I'm not sure that the modifiers like HEADING and the break handling in RetrieVe make sense in the XML context anyway. I'd rather see a separate keyword if you want to add a comment element. Brian -Original Message- From: "Keith Johnson (DSLWN)"<[EMAIL PROTECTED]> Sent:

RE: [U2] Universe XML is not to standard

2008-05-08 Thread Dennis Bartlett
Wouldn't it be easier to use HDR.SUP? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson (DSLWN) Sent: 08 May 2008 01:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe XML is not to standard The software I am supporting has a user s

RE: [U2] UniVerse Triggers

2008-05-08 Thread Brian Leach
Mike If you check the recent issues (pdfs on their site) I wrote an article on triggers for Spectrum you might find useful. Brian -Original Message- From: "Mike Randall"<[EMAIL PROTECTED]> Sent: 08/05/08 03:58:08 To: "u2-users@listserver.u2ug.org" Subject: RE: [U2] UniV

RE: [U2] Using ETL to extract data from UD to SQL

2008-05-08 Thread Marc Harbeson
I demoed Epiror's variant of this product, and found that is does indeed look quite nice, but it still is a batch update / scheduled update tool. Therefore myself and a few friends went forward with building something that can perform transactional updates using triggers, BCI and ODBC client drive

[U2] Cedarville Download version 7.30 available

2008-05-08 Thread David L. Rotman
I am pleased to announce that version 7.30 of Cedarville Download is available on our ftp site: ftp.cedarville.edu Download is a utility that uses LIST-style syntax to create output in a variety of formats (csv, tab, HTML, XML, etc.). Download is a mature product that is in use by several cor

RE: [U2] Record Locking Problems

2008-05-08 Thread Dennis Bartlett
>> I am certainly NOT trying to change anyone's coding style, I am just curious IMPRESSIVELY POLITICALLY CORRECT ;-) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Universe XML is not to standard

2008-05-08 Thread Rex Gozar
I too ran into the issue where extra characters precede the "string, causing incompatibilities with other apps. I handled it, but I shouldn't have to --- Yes, IBM should correct their implementation. rex Keith Johnson (DSLWN) wrote: It's not absolutely clear from the W3C standard itself, but

Re: [U2] Record Locking Problems

2008-05-08 Thread Jonathan D Smith
Hi Karen, For reference although the RECORDLOCKU statement does not support an array in it's syntax it does read the record on UniVerse, it does not on UniData. Your assumption is correct that it shouldn't read the record, as it only needs to access the lock table which is a memory structu

[U2] Using ETL to extract data from UD to SQL

2008-05-08 Thread Mecki Foerthmann
Hi group, have any of you had any experience using ETL from Sybase? The company I work for has bought Cognos for reporting and data mining purposes on their other non-mv applications, and I have given the task (and I told them, it should be possible) to make this work with our UniData ERP appl