Re: [U2] U2 DataVu Query
Thanks for the response, Michael. The VOC entry for UD.ACCOUNT, in the data account chosen in the connection setup, is being overwritten. Prior to making the connection the VOC entry for UD.ACCOUNT is as follows: 001: F 002: c:\program files\ibm\ud71\sys\UD.ACCOUNT 003: c:\program files\ibm\ud71\sys\D_UD.ACCOUNT After selecting the the data account the VOC entry for UD.ACCOUNT is changed to: 001: F 002: ..\sys\UD.ACCOUNT 003: ..\sys\D_UD.ACCOUNT (the path for the data account is e:\data account name) I think U2 DataVu Query should not be overwriting the path to UD.ACCOUNT in the data account. Comments would be appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael Byrne Sent: Monday, December 06, 2010 9:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 DataVu Query You need to use CONVERT.SQL on UniData files (not for UniVerse files) for them to be visible. You may also need to GRANT privileges for specific users depending on what username will be connecting. There is a small mention of this in the readme that comes with the download. The following would make it available to all users. CONVERT.SQL MYFILE PUBLIC Michael Bruce McAdoo wrote: Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/U2-DataVu-Query-tp30261771p30389822.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You need to use CONVERT.SQL on UniData files (not for UniVerse files) for them to be visible. You may also need to GRANT privileges for specific users depending on what username will be connecting. There is a small mention of this in the readme that comes with the download. The following would make it available to all users. CONVERT.SQL MYFILE PUBLIC Michael Bruce McAdoo wrote: Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/U2-DataVu-Query-tp30261771p30389822.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 DataVu Query
Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You are missing a file in the sys account called UD.ACCOUNT. There is a tech note for BDT on that problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Friday, November 19, 2010 2:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
Thanks Doug, but actually the file UD.ACCOUNT in the sys account exists and is not missing. The VOC entry of UD.ACCOUNT in the account I'm trying to query (with U2 DataVu Query) seems to be changing after trying to display files via the Create New U2 Query. The VOC entry prior to trying to display files via the Create New U2 Query: 001: F 002: c:\program files\ibm\ud71\sys\UD.ACCOUNT 003: c:\program files\ibm\ud71\sys\D_UD.ACCOUNT The VOC entry after trying to display files via the Create New U2 Query: 001: F 002: ..\sys\UD.ACCOUNT 003: ..\sys\D_UD.ACCOUNT The account I'm trying to query is actually on an alternate drive (e:\). Does anyone know if this is the problem, or a solution to resolve tis problem? Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, November 19, 2010 3:47 PM To: 'U2 Users List' Subject: Re: [U2] U2 DataVu Query You are missing a file in the sys account called UD.ACCOUNT. There is a tech note for BDT on that problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Friday, November 19, 2010 2:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You need to populate that UD.ACCOUNT with a record for that UD.ACCOUNT. You can either manually create it or use UniAdmin to update an already created account. You may also need to fill in the description field. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Saturday, 20 November 2010 8:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users