[U2] Problems with the IBM DB2 U2 Dotnet provider and vista
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), however the service pack does not. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
DQM (was [U2] Using ETL to extract data from UD to SQL)
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. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 8, 2008, at 6:00 PM, Boydell, Stuart wrote: nd dirty data to get to a set of data suitable for your DW/reporting requirements. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Triggers
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, May 08, 2008 8:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Triggers 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] UniVerse Triggers Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [Message truncated. Tap Edit->Mark for Download to get remaining portion.] --- 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] Using ETL to extract data from UD to SQL
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 determined the reasons for going through the process will give your business an ROI, it is worth getting it right... and there will be a learning curve. Schemas might look pretty straightforward at the end of it. Our rationale was to have an uptodate set of data off our transactional host to give us various non U2 reporting and interface benefits. We do our ETL process from UV to SQL then (among other uses) build Cognos cubes using the following method (basically): Use triggers on UV to track changed fact records. Use SQL Job scheduler to control periodic extracts and cube build: -Job reads parameter table from SQL of UV commands to run. -Job invokes Uniobjects process which runs the command (either LIST ... TOXML or subroutine) which selects changed "fact" records and "dimension" tables - returns XML. -Job invokes "SQLXMLBulkLoad" process to load SQL. (This tool is great!) -Job runs stored procs which re-key, check integrity and further cleanse the data. -Job invokes cube build. There's obviously a bit more control around it but this works quickly and effectively with gigabytes of data daily. It's all parameter driven so that changes are quick and simple. Much of the cleansing (and there is a lot of junk in our files) happens using UV LIST FMT/CONV TOXML and selection modifiers in the extract commands. Personally I'd steer away from ODBC or OLEDB which mix data format and data transport. I prefer the idea of coupling discrete tools which perform each function well. We use Cognos 8 which, according to our business analysts, works well. It can use just about any SQL data source and you could point it directly at your U2 db using ODBC but you'd miss the opportunity of taking processing off your transactional db and cleansing your data for reporting purposes. Regards Stuart >-Original Message- >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 application as well. >Now I've heard of this ETL product from Sybase that looks pretty simple >to use (drag-and drop) and is supposedly very fast since it doesn't use >ODBC but UniObjects. >So the question is, 'have any of you used it, and if yes, is it any good?' >Or do you have any recommendations, which mv-to-sql bridges are >worthwhile using. >This setting up schemas and sql-tables in UniData (we're still on 5.2) >seems to be way over my head, and I don't seem to be getting anywhere >that way. > >many thanks in advance > >Mecki Foerthmann ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- 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
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 main issue is that they automatically stamp the encoding attribute as UTF8, whereas without NLS turned on, UV is iso8859-1 by default. Try listing an item with a character > 128 and opening it in an xml parser (eg Internet Explorer). LIST CUST '123' NAME TOXML An invalid character was found in text content. Regards, Stuart >-Original Message- >I recently created another >screen to allow users to use the defined statement/report to output XML >to the &HOLD& file and to transfer the results to their PC. All well >and good, but then I found that Excel wouldn't pick up the results >properly. The reason for this is that the XML output is not quite to >the standard. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking
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 COMMON statements since we have big application programs with dozens of subPrograms (in each program) such that I do not want to chase down every sub. I expect to handle this problem with a little LOCKED.RECORDS file (on the side) that writes a record with user/time/date and deletes this record after users have completed their transactions. Maybe there is a better way... Perhaps it makes sense for IBM to consider enhancing UniBasic by bolting-on some object-oriented functionality. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Doug Chanco Sent: Thursday, May 08, 2008 4:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Record Locking Problem Your welcome BUT what does IBM need to fix? To me at least when a... dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Scared to recompile
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 get this situation resolved, you may want to consider some sort of version control system to prevent it from reoccuring. On Thu, May 8, 2008 at 1:01 PM, <[EMAIL PROTECTED]> wrote: > 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 place than the > object code thinks it is. That being said, I'd like to recompile all of the > programs after moving the directory. For a lot of reasons, that scares me. > > Does anyone know how to check for differences between 2 versions of object > code? > > Here is what I've tried so far... > > 1) Copy BP file > 2) Recompile program > 3) copy original object code to a test directory as "LIVE" > 4) remove program path from last line of this file. > 5) copy new object code to a test directory as "TEST" > 6) remove program path from lastl line of this file. > 7) execute unix diff for LIVE to TEST >ans: There are small differences but since they are unprintable > characters, I don't know what they are. > 8) execute unix cksum on both file and compare >ans: The check sum is different every time. > > Thanks a lot for any ideas that you might have. > --- > 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] Record Locking Problem
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 Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Thursday, May 08, 2008 3:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Record Locking Problem 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 open when a file is closed If this is not what you meant please forgive me dougc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 08, 2008 3:14 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Record Locking Problem 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/ -- This message has been scanned for viruses and dangerous content by SecureMail, and is believed to be clean. --- 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] Record Locking Problem
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 missed that). > If you have a locking defect, please open a support case and report it. > Thanks > > Wally Terhune > SWG Client Support - Information > Management Software > U2 Support Architect b IBM U2 > Client Support Team > 4700 S. Syracuse St., Denver, CO > 80237 > Tel: (303) 773-7969 T/L > 656-7969 > Mobile: (303) 807-6222 > [EMAIL PROTECTED] > > > > > > > > > > > > > "Brutzman, Bill" > <[EMAIL PROTECTED] > ft.com>To > Sent by: "'u2-users@listserver.u2ug.org'" > [EMAIL PROTECTED] > stserver.u2ug.org cc > >Subject > 05/08/2008 01:14 RE: [U2] Record Locking Problem > PM > > > Please respond to > [EMAIL PROTECTED] > er.u2ug.org > > > > > > > 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/ > > [demime 1.01d removed an attachment of type image/jpeg which had a name of > 25846144.jpg] > > [demime 1.01d removed an attachment of type image/gif which had a name of > graycol.gif] > > [demime 1.01d removed an attachment of type image/gif which had a name of > pic04887.gif] > > [demime 1.01d removed an attachment of type image/gif which had a name of > ecblank.gif] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England & Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking Problem
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 Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] "Brutzman, Bill" <[EMAIL PROTECTED] ft.com>To Sent by: "'u2-users@listserver.u2ug.org'" [EMAIL PROTECTED] stserver.u2ug.org cc Subject 05/08/2008 01:14 RE: [U2] Record Locking Problem PM Please respond to [EMAIL PROTECTED] er.u2ug.org 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/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 25846144.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic04887.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking Problem
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 open when a file is closed If this is not what you meant please forgive me dougc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 08, 2008 3:14 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Record Locking Problem 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/ -- This message has been scanned for viruses and dangerous content by SecureMail, and is believed to be clean. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking Problem
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
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 Server 2005 than the generic ODBC-ODBC bridge, I don't know. I'll post my results from using the demo in the next week or so. Good luck. Harold Oaks Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, May 08, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 - SQL Server ODBC Connection via Universe 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.3 Thanks in advance Marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Obey gravity, It's the law! --- 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 XML is not to standard
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]
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. Feel free to contact us at [EMAIL PROTECTED] for more info.[/AD] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, May 08, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 - SQL Server ODBC Connection via Universe 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.3 Thanks in advance Marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Obey gravity, It's the law! --- 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] Scared to recompile
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: u2-Users Subject: [U2] [UV] Scared to recompile 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 place than the object code thinks it is. That being said, I'd like to recompile all of the programs after moving the directory. For a lot of reasons, that scares me. Does anyone know how to check for differences between 2 versions of object code? Here is what I've tried so far... 1) Copy BP file 2) Recompile program 3) copy original object code to a test directory as "LIVE" 4) remove program path from last line of this file. 5) copy new object code to a test directory as "TEST" 6) remove program path from lastl line of this file. 7) execute unix diff for LIVE to TEST ans: There are small differences but since they are unprintable characters, I don't know what they are. 8) execute unix cksum on both file and compare ans: The check sum is different every time. Thanks a lot for any ideas that you might have. --- 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 Triggers
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- From: "Mike Randall"<[EMAIL PROTECTED]> Sent: 08/05/08 03:58:08 To: "u2-users@listserver.u2ug.org" Subject: RE: [U2] UniVerse Triggers Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [Message truncated. Tap Edit->Mark for Download to get remaining portion.] --- 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] U2 - SQL Server ODBC Connection via Universe
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.3 Thanks in advance Marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Obey gravity, It's the law! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Scared to recompile
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 place than the object code thinks it is. That being said, I'd like to recompile all of the programs after moving the directory. For a lot of reasons, that scares me. Does anyone know how to check for differences between 2 versions of object code? Here is what I've tried so far... 1) Copy BP file 2) Recompile program 3) copy original object code to a test directory as "LIVE" 4) remove program path from last line of this file. 5) copy new object code to a test directory as "TEST" 6) remove program path from lastl line of this file. 7) execute unix diff for LIVE to TEST ans: There are small differences but since they are unprintable characters, I don't know what they are. 8) execute unix cksum on both file and compare ans: The check sum is different every time. Thanks a lot for any ideas that you might have. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using ETL to extract data from UD to SQL[AD]
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 databases in sync. The customer is writing to both SQL Server and Oracle, and drives the writes off of triggers they've set on the Universe files. Feel free to contact us at [EMAIL PROTECTED] for more details.[/AD] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, May 08, 2008 5:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Using ETL to extract data from UD to SQL 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 drivers. My requirement was to feed SQL server to enable the use of the Microsoft Analysis Services and Reporting Services on large volumes of data. The side effect to our approach was the "reporting load" is non existent on the U2 server now since the updates are in real time. Bulk re-loading was not acceptable for 10M records. (And other tables that are at or around 1-3M records) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann Sent: Thursday, May 08, 2008 3:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] Using ETL to extract data from UD to SQL 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 application as well. Now I've heard of this ETL product from Sybase that looks pretty simple to use (drag-and drop) and is supposedly very fast since it doesn't use ODBC but UniObjects. So the question is, 'have any of you used it, and if yes, is it any good?' Or do you have any recommendations, which mv-to-sql bridges are worthwhile using. This setting up schemas and sql-tables in UniData (we're still on 5.2) seems to be way over my head, and I don't seem to be getting anywhere that way. many thanks in advance Mecki Foerthmann --- 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] Using ETL to extract data from UD to SQL
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 horrendous resource hog as is the production of cubes via Transformer. Consider a separate reporting server to handle this stuff and take the load off your ERP/transaction system. 2. Break every rule of database design when creating the tables to be accessed via Impromptu. ODBC statements with complex (or even simple really) table joins take forever. Create your reporting tables so that everything is in one table for a reporting area so that if possible your SQL statement for sales info is SELECT * from SALES. I'm talking about having the customer name, address, product description, salesperson name, etc as a field in every record. Not a pointer to another table but the actual text. 3. Learning to set up tables/ODBC access under Unidata is probably much easier and cheaper than purchasing and learning to use an ETL product. Besides, that way you just use a basic program to gather your data from the ERP system and write it all to a single "SALES" (for example) table. Feel free to contact me off list if you want to discuss specifics. Mecki Foerthmann wrote: > 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 application as well. > Now I've heard of this ETL product from Sybase that looks pretty > simple to use (drag-and drop) and is supposedly very fast since it > doesn't use ODBC but UniObjects. > So the question is, 'have any of you used it, and if yes, is it any > good?' > Or do you have any recommendations, which mv-to-sql bridges are > worthwhile using. > This setting up schemas and sql-tables in UniData (we're still on 5.2) > seems to be way over my head, and I don't seem to be getting anywhere > that way. > > many thanks in advance > > Mecki Foerthmann > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Record Locking Problems
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 releases the lock. The best way would be to pass in an open file handle. If that is not possible for some reason then open the file to a variable defined in named common and test to see if it is already open using FILEINFO() before attempting to do the open. such as: COMMON /MY.FILE.HANDLES/ F.THIS.FILE IF FILEINFO(F.THIS.FILE,0) = 0 THEN OPEN . END I would prefer passing in the open file handle myself if possible. Named common is very useful, but care needs to be taken in it's use. For example the common memory defined is associated to the process and not the account. Therefore if you logto another account without first exiting U2 the file handle would still be open, BUT pointed at the file in the account where it was opened. You would need to have logic in the logins to test for this or add additional checks (using FILEINFO again for the path where the file is located) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 "Brutzman, Bill" <[EMAIL PROTECTED] ft.com>To Sent by: "'u2-users@listserver.u2ug.org'" [EMAIL PROTECTED] stserver.u2ug.org cc Subject 05/07/2008 12:02 [U2] Record Locking Problems PM Please respond to [EMAIL PROTECTED] er.u2ug.org I am trying to make sure that if one Customer.Service rep is updating a Sales Order, then the other Cust.Svc rep is blocked from accessing the same record. The following code will indicates that the record is locked but when the 2nd user goes in (in an independent session), the second user gets in no problem. Since it does not seem to do what I think that it should, [1] I am wondering if I am missing something. [2] I am inclined to create a file to handle this (brute force) with multivalues for user, port, time, date, program, file, record. Comments would be appreciated. --Bill SUBROUTINE SUB.LOCK.SOH.R0 ( Record.ID, Error.Code ) prompt '' open 'SOH' to F.This.File else gosub Error.Opening.File gosub Lock.And.Hold goThe.End *--- -- *--- -- Lock.And.Hold: Lock.Test = recordlocked (F.This.File, Record.ID) crt '**11 Lock.Test ' : Lock.Test : ' [<] ' input Ans begin case case Lock.Test = 0 ; recordlocku F.This.File, Record.ID case 1 ; gosub Error.Record.Locked end case Lock.Test = recordlocked (F.This.File, Record.ID) crt '**12 Lock.Test ' : Lock.Test : ' [<] ' input Ans return *--- --- Error.Record.Locked: Lock.Test = recordlocked (F.This.File, Record.ID) crt '**13 Lock.Test ' : Lock.Test : ' [<] ' input Ans Error.Code = 'E' crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt '' : @(-6) crt crt ' ___ ' crt ' \ \ ' crt ' \ Error, Record Locked \' crt ' \__\Try Later ' crt ' ' crt
RE: [U2] Universe XML is not to standard
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: 08/05/08 00:27:15 To: "u2-users@listserver.u2ug.org" Subject: [U2] Universe XML is not to standard The software I am supporting has a user screen which builds and saves enquiry statements (English/Access/Recall). I recently created another screen to allow users to use the defined statement/report to output XML to the &HOLD& file and to transfer the results to their PC. All well and good, but then I found that Excel wouldn't pick up the results properly. The reason for this is that the XML output is not quite to the standard. For example, the command >LIST VOC 'VOC' F1 F2 TOXML gives the result -- -- While the command >LIST VOC 'VOC' F1 F2 TOXML HEADING "WAHOO 'D'" gives the result -- WAHOO 08 May 2008 -- It's not absolutely clear from the W3C standard itself, but it is very clear from the examples given with it; that the output must start with the string " <-- report heading follows WAHOO 08 May 2008 --> -- Does anyone else agree with me? Ought IBM change this? What do you think? Regards, Keith --- 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 XML is not to standard
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 screen which builds and saves enquiry statements (English/Access/Recall). I recently created another screen to allow users to use the defined statement/report to output XML to the &HOLD& file and to transfer the results to their PC. All well and good, but then I found that Excel wouldn't pick up the results properly. The reason for this is that the XML output is not quite to the standard. For example, the command >LIST VOC 'VOC' F1 F2 TOXML gives the result -- -- While the command >LIST VOC 'VOC' F1 F2 TOXML HEADING "WAHOO 'D'" gives the result -- WAHOO 08 May 2008 -- It's not absolutely clear from the W3C standard itself, but it is very clear from the examples given with it; that the output must start with the string " <-- report heading follows WAHOO 08 May 2008 --> -- Does anyone else agree with me? Ought IBM change this? What do you think? Regards, Keith --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.10/1421 - Release Date: 2008/05/07 05:23 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Triggers
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] UniVerse Triggers Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [Message truncated. Tap Edit->Mark for Download to get remaining portion.] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using ETL to extract data from UD to SQL
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 drivers. My requirement was to feed SQL server to enable the use of the Microsoft Analysis Services and Reporting Services on large volumes of data. The side effect to our approach was the "reporting load" is non existent on the U2 server now since the updates are in real time. Bulk re-loading was not acceptable for 10M records. (And other tables that are at or around 1-3M records) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann Sent: Thursday, May 08, 2008 3:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] Using ETL to extract data from UD to SQL 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 application as well. Now I've heard of this ETL product from Sybase that looks pretty simple to use (drag-and drop) and is supposedly very fast since it doesn't use ODBC but UniObjects. So the question is, 'have any of you used it, and if yes, is it any good?' Or do you have any recommendations, which mv-to-sql bridges are worthwhile using. This setting up schemas and sql-tables in UniData (we're still on 5.2) seems to be way over my head, and I don't seem to be getting anywhere that way. many thanks in advance Mecki Foerthmann --- 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] Cedarville Download version 7.30 available
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 corporations, colleges, and universities. The changes made in 7.30 (compared with 7.21) include: * Add HTML.DOCTYPE option. * Add HTML.TABLE.ONLY option. * Add NUM.VALUES LAST option. * Add NUM.SUBVALUES LAST option. * Improve installation validation routines: * Rename fields in DOWNLOAD.TEST.FILE. * Increase the number of records in DOWNLOAD.TEST.FILE. * Modify DOWNLOAD.TEST.PARAGRAPH for changes in field names and * more complex testing. * Documentation fix * Documentation indicates that @YEAR returns a four-digit year, * but it actually returns a two-digit year in standard * Unidata/Universe environments. * Documentation fix * Include HTML.HEAD in online help file. The file "000README.TXT" on the ftp site contains instructions for installing Download. As usual, the installation takes only a few minutes. A history of changes made in earlier versions is in the file "DOWNLOAD.VER" on the ftp site. Dave Rotman Associate Vice President for Technology Chief Information Officer Cedarville University 251 N. Main Street Cedarville, OH 45314 [EMAIL PROTECTED] voice 937-766-7905 fax 937-766-8819 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking Problems
>> 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
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 it is very clear from the examples given with it; that the output must start with the string " --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Record Locking Problems
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 structure, if you want to test this for yourself do a test on UniData and UniVerse on RECORDLOCKU v READU and you'll see there is almost no time difference on UniVerse. Regards, Jonathan D Smith SWG Client Support - Software U2 Service Delivery Team Technical Support Consultant Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Using ETL to extract data from UD to SQL
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 application as well. Now I've heard of this ETL product from Sybase that looks pretty simple to use (drag-and drop) and is supposedly very fast since it doesn't use ODBC but UniObjects. So the question is, 'have any of you used it, and if yes, is it any good?' Or do you have any recommendations, which mv-to-sql bridges are worthwhile using. This setting up schemas and sql-tables in UniData (we're still on 5.2) seems to be way over my head, and I don't seem to be getting anywhere that way. many thanks in advance Mecki Foerthmann --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/