RE: [U2] UD: ODBC/OleDB access to selected records in a file
Funny you should mention it. We just started experimenting with XML yesterday. CR comes with an ODBC driver for XML files. UD's LISTTOXML seems to work as advertised. Many details remain to be investigated, but it looks promising so far. Jim --- John Jenkins [EMAIL PROTECTED] wrote: I seem to remember there is a link into ADO for CR ... maybe you could link into RBOs? XML might be another possible methodology - but I don't have a copy of CR to play with... Anyone got any inside information on these features in CR? Regards JayJay We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Jim Bullock wrote: Funny you should mention it. We just started experimenting with XML yesterday. CR comes with an ODBC driver for XML files. UD's LISTTOXML seems to work as advertised. Many details remain to be investigated, but it looks promising so far. If LIST...TOXML doesn't do exactly what you need, try Cedarville's DOWNLOAD utility. -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
I seem to remember there is a link into ADO for CR ... maybe you could link into RBOs? XML might be another possible methodology - but I don't have a copy of CR to play with... Anyone got any inside information on these features in CR? Regards JayJay We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD: ODBC/OleDB access to selected records in a file
I've found the best way for me to do what you are describing is to use UniObjects .Net to create a recordset from the UniData/UniVerse machine and then pass that recordset into a Crystal Report. Probably not what you want to hear, but it is a method to stitch together your current programs with your spiffy new Crystal Reports. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use. I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB -Original Message- From: Jim Bullock We are having quite a bit of success writing reports with Crystal Reports, using ODBC to access our UD6 database. We have gone through the exercise of flattening files, creating new dicts, etc. It's slow, but we are usually able to get what we need. We serve up the reports to the users with Crystal Enterprise and Apache. We are not, however, able to take advantage of one (IMHO) of the most powerful features of a U2 database, the ability to manipulate sets of id's through the use of SELECT, SAVE.LIST, GET.LIST, MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which do multiple selects on multiple files, saving foreign keys, eliminating duplicates, etc., to arrive at a final savedlist of id's of records to be put on a report. Currently we use this list of id's to write a report in UniQuery. We would love to be able to write this report instead in Crystal. There would be no SQL SELECT at all in the Crystal report, the selection of the proper records having already been accomplished by the server-based procedure. The natural, or so I thought, place to do this sort of thing is in a stored procedure. I got as far as seeing the stored procedure name via the OleDB driver, but was unsuccessful in actually seeing any data. Many e-mails and phone calls with our VAR and IBM later, we were pointed to a place in the UD documentation where it says stored procedures are not supported by UniData. We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Thanks, Ross. Actually when we were looking for our reporting solution a couple of years ago we looked at the available 'native' U2 products and, for various reasons, decided against them in favor of Crystal Enterprise. Your reference to The Drumheller Trick sent me Googling, but also set the wheels turning in my head. Maybe, just maybe... Thanks again. Jim --- Ross Ferris [EMAIL PROTECTED] wrote: Jim, Probably way to late in the day, but there are a number of non-ODBC/OleDB solutions that might have solved this problem for you. Names like mvQuery, Informer, and our own Visage.Reporter come to mind. I assume the other products have something similar to our facility where you can CALL a subroutine that returns a list of ID's to be processed, and we don't really care HOW the list is generated in the first place. So, as to the problem at hand, would a variation of the Drumheller Trick work ? SO that you operate on a file with a single, known key, BUT the field that you return is actually the result of a subroutine which has the necessary logic in it to manipulate your select lists - and from there traverse to the real file ? Never having played, not sure if this would work, but perhaps may trigger a thought in those with more first hand experience Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Tuesday, 15 March 2005 9:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD: ODBC/OleDB access to selected records in a file We are having quite a bit of success writing reports with Crystal Reports, using ODBC to access our UD6 database. We have gone through the exercise of flattening files, creating new dicts, etc. It's slow, but we are usually able to get what we need. We serve up the reports to the users with Crystal Enterprise and Apache. We are not, however, able to take advantage of one (IMHO) of the most powerful features of a U2 database, the ability to manipulate sets of id's through the use of SELECT, SAVE.LIST, GET.LIST, MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which do multiple selects on multiple files, saving foreign keys, eliminating duplicates, etc., to arrive at a final savedlist of id's of records to be put on a report. Currently we use this list of id's to write a report in UniQuery. We would love to be able to write this report instead in Crystal. There would be no SQL SELECT at all in the Crystal report, the selection of the proper records having already been accomplished by the server-based procedure. The natural, or so I thought, place to do this sort of thing is in a stored procedure. I got as far as seeing the stored procedure name via the OleDB driver, but was unsuccessful in actually seeing any data. Many e-mails and phone calls with our VAR and IBM later, we were pointed to a place in the UD documentation where it says stored procedures are not supported by UniData. We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 --- 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 Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard
RE: [U2] UD: ODBC/OleDB access to selected records in a file
To expand on Colins idea of a work file: What about creating a process which can be passed a list of column definitions (title,width,datatype, etc) and a set of report data thenand creates an ODBC enabled work file which could be accessed by crystal reports with a simple SELECT * FROM SQL statement. -Original Message- Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use. I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Thank you both for the workfile suggestion. We have toyed a bit with this idea. One of the challenges we face is that we have 200 users who can run reports via the Web and the Crystal Enterprise reporting engine. Two simultaneous users couldn't use a single workfile simultaneously. We haven't found an easy way to build, odbc-enable, and then destroy workfiles, but this is a method that bears further investigation. Thanks again to everyone who responded. Jim --- Jeff Schasny [EMAIL PROTECTED] wrote: To expand on Colins idea of a work file: What about creating a process which can be passed a list of column definitions (title,width,datatype, etc) and a set of report data thenand creates an ODBC enabled work file which could be accessed by crystal reports with a simple SELECT * FROM SQL statement. -Original Message- Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use. I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
If you really want to do selects on the fly, you might want to look into unibojects or uniobjects for java. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Tuesday, March 15, 2005 12:10 PM To: U2 Group Subject: RE: [U2] UD: ODBC/OleDB access to selected records in a file To expand on Colins idea of a work file: What about creating a process which can be passed a list of column definitions (title,width,datatype, etc) and a set of report data thenand creates an ODBC enabled work file which could be accessed by crystal reports with a simple SELECT * FROM SQL statement. -Original Message- Sorry, I haven't played much with our Crystal reports, but I think we had a similar problem. However, we didn't have the large library of paragraphs that we felt compelled to re-use. I didn't think it was all that slow. We did figure out how to do some neat things with Crystal though. What about calling a pre-process that creates a work file for reporting? Colin Alfke Calgary, AB Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- 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] UD: ODBC/OleDB access to selected records in a file
There are a couple of ways around that: you can use a different file for each user or you can put some sort of identifier in the key for each user. We did find some neat functionality in Crystal that meant we could use multiple data files with one report. I forget what their terminology for it was. Colin Alfke Calgary, Canada -Original Message- From: Jim Bullock Thank you both for the workfile suggestion. We have toyed a bit with this idea. One of the challenges we face is that we have 200 users who can run reports via the Web and the Crystal Enterprise reporting engine. Two simultaneous users couldn't use a single workfile simultaneously. We haven't found an easy way to build, odbc-enable, and then destroy workfiles, but this is a method that bears further investigation. Thanks again to everyone who responded. Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD: ODBC/OleDB access to selected records in a file
in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Don't do that Jim. I you have to use UniQuery, at least convert the text reports to PDF and email them to the users. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Raining data has an interface with U2 and Microsoft Report Server. I have not used it, but it may make better use of the PICK facilities and you would not have to flatten files. Microsoft Report Server is not a bad product allowing reports to be produced to html, pdf and other formats, xml driven formatting, scheduling and a number of other features. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Tuesday, 15 March 2005 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD: ODBC/OleDB access to selected records in a file in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Don't do that Jim. I you have to use UniQuery, at least convert the text reports to PDF and email them to the users. Craig --- 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] UD: ODBC/OleDB access to selected records in a file
Jim, Probably way to late in the day, but there are a number of non-ODBC/OleDB solutions that might have solved this problem for you. Names like mvQuery, Informer, and our own Visage.Reporter come to mind. I assume the other products have something similar to our facility where you can CALL a subroutine that returns a list of ID's to be processed, and we don't really care HOW the list is generated in the first place. So, as to the problem at hand, would a variation of the Drumheller Trick work ? SO that you operate on a file with a single, known key, BUT the field that you return is actually the result of a subroutine which has the necessary logic in it to manipulate your select lists - and from there traverse to the real file ? Never having played, not sure if this would work, but perhaps may trigger a thought in those with more first hand experience Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Tuesday, 15 March 2005 9:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD: ODBC/OleDB access to selected records in a file We are having quite a bit of success writing reports with Crystal Reports, using ODBC to access our UD6 database. We have gone through the exercise of flattening files, creating new dicts, etc. It's slow, but we are usually able to get what we need. We serve up the reports to the users with Crystal Enterprise and Apache. We are not, however, able to take advantage of one (IMHO) of the most powerful features of a U2 database, the ability to manipulate sets of id's through the use of SELECT, SAVE.LIST, GET.LIST, MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which do multiple selects on multiple files, saving foreign keys, eliminating duplicates, etc., to arrive at a final savedlist of id's of records to be put on a report. Currently we use this list of id's to write a report in UniQuery. We would love to be able to write this report instead in Crystal. There would be no SQL SELECT at all in the Crystal report, the selection of the proper records having already been accomplished by the server-based procedure. The natural, or so I thought, place to do this sort of thing is in a stored procedure. I got as far as seeing the stored procedure name via the OleDB driver, but was unsuccessful in actually seeing any data. Many e-mails and phone calls with our VAR and IBM later, we were pointed to a place in the UD documentation where it says stored procedures are not supported by UniData. We have racked our brains and have been unable to come up with a workaround for this gaping hole in the ODBC/OleDB interface to UniData. Before we give up entirely and resign ourselves to putting out paper reports with UniQuery, I thought I would ask this group if anyone has solved this problem. Anyone? Thanks in advance, Jim ...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt. -Howard Dean __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 --- 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 Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: ODBC/OleDB access to selected records in a file
Does UV SQL CALL syntax work for UD too? Can that be used to return the rows you need from basic or a paragraph? Stuart -Original Message- From: Jim Bullock The natural, or so I thought, place to do this sort of thing is in a stored procedure. I got as far as seeing the stored procedure name via the OleDB driver, but was unsuccessful in actually seeing any data. Many e-mails and phone calls with our VAR and IBM later, we were pointed to a place in the UD documentation where it says stored procedures are not supported by UniData. ** 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 email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/