Re: [U2] Uniobjects - What Is It?
Hi John, We have our shipping software setup to execute a sql stored procedure which calls an Avante subroutine with UniObjects. I'll send it to you offline in a bit. Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:10 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are there any Avanté users out there that have things written with UniObjects that would be willing to share an example of something they have done? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, May 19, 2011 10:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? I imagine most people simply use it to run subroutines in external applications, but you can achieve a lot (perhaps most or all?) of the things you can do at the prompt and UniBasic program with uniobjects natively in .net, java or any other language that you can use UO with. You can also deploy it with the application and open a session directly which is the one thing Redback can't do. We actually use both since some of our third party software is built on redback and our internal software runs through a WCF webservice that manages a "connection pool" of uniobjects sessions in a windows service. I haven't ever done anything with RBOs and redpages but I haven't ever seen the need when I can do everything much more easily right in my .net applications (obviously backed by UniBasic Subs on the server). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, May 19, 2011 9:05 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects - What Is It? Are you saying that UniObjects are used instead of Redback or is it used in addition to Redback? Without giving away company secrets, can you briefly describe some real world examples of what kind of applications were written with UniObjects? Loosely speaking, what practical uses are there that I am not grasping? If I am content with doing things from TCL, why do I need this? Is this more for end-user applications (i.e. not programmers)? What sort of things can I take to management that I could do with UniObjects that will make them go WOW! John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, May 19, 2011 9:52 AM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? >>> What are UniObjects? Uniobjects are libraries. Theses can be included in a variety of applications and provide access to U2 databases. On Linux there is Uniobjects for Java. There is a version for .NET. And there is an older COM version that can be used for applications that don't support .NET. I mainly use the Uniobjects for Java to access data from our Unidata system from PHP. I use some .NET in VB applications. The COM version is used in some Domino agents.. HTH Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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 ___ 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] UDODBC v7
Does anyone have the odbc manual for version 7? I'm having trouble with the new driver options and I'm not seeing the documentation install on the client cd. Thanks, Amy ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback
Thanks for the followup Jake. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Tuesday, August 03, 2010 2:35 PM To: U2 Users List Subject: Re: [U2] Redback Just in case someone else comes across this in the future, I wanted to let you know that I figured out what the problem was. It had to do with some of the registry settings for IIS (see: http://mcsknowledge.com/Articles.aspx?&P_ID=11&A_ID=111). I originally discounted it since mine was reporting 'rgw.ini' and not '' and my version of windows is 32bit not 64bit but when I made these changes my gateway now reports 'c:\inetput\wwwroot\rgw.ini' like it should. When I try and hit an account I get an actual error now so at least I can make some progress. Thanks for your help, Jake -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Monday, August 02, 2010 5:20 PM To: U2 Users List Subject: Re: [U2] Redback I'm not sure where that port is coming from. Just to be sure I went and deleted all of the rgw.ini files (I had a few from reinstalls) and left only the newest one. SHOWRGW.exe displays the accounts I have setup in this RGW.INI so I would expect I have the right file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent: Monday, August 02, 2010 4:36 PM To: U2 Users List Subject: Re: [U2] Redback Jake, This line :- Can't connect to account 'DATAFLO' (DATAFLO:8413) rc=-1 suggests you are trying to connect on port 8413. Have you checked you don't have multiple rgw.ini files. In the early days of Redback the location of this file seemed to move with every release and I've been caught out a number of times with a system having two or more copies of rgw.ini containing conflicting information. HTH, Andy - Original Message From: "Holt, Jake" To: U2 Users List Sent: Mon, 2 August, 2010 17:21:47 Subject: [U2] Redback We're currently running Universe 10.0.21 and I have RedBack 4.1.3.2 (its old, long story...). I can get everything to install properly it would seem but when I go to test it I get the following error: http://jonah/scripts/rgw.dll/DATAFLO *** Sorry, an error has occurred in rgw.dll running on host 'JONAH' (192.168.221.15) at 'Mon Aug 02 10:57:57 2010' at line 1161 of 'rgwi.c'. Can't connect to account 'DATAFLO' (DATAFLO:8413) rc=-1. [rgw.ini file is 'rgw.ini'] (RedBack ErrorCode = 0xf0060010) (System ErrorCode=11004 - The requested name is valid, but no data of the requested type was found. ) *** If I test just the gateway itself I get: http://jonah/scripts/rgw.dll/ You have successfully performed a test connection to the RedBack Requester (rgw) running on host 'JONAH' (192.168.221.15). Your RedBack accounts will be looked up in file 'rgw.ini'. * So it looks to be reading the rgw.ini file properly. This looks like a DNS error, but if I change rgw/rgwresp to use the IP it gives me the exact same error. The virtual directory for the redback "scripts" folder is under the default website in IIS. I've also added the web extension for the responder. I've tried about everything I can think to try including reinstalling both the server and gateway 3 or 4 times. The licensing isn't displaying any issues, I've run ENABLE.RBO and REDBACK.UPG. Anyone have any ideas? Thanks, Jake We're running on Windows Server 2003 32bit. Files: *** RGWRESP.INI: [Default] delim=254 startbackend=1 nresponders=2 backend=E:\UV\uv\bin\uv.exe perfstats=1 [Default.Environment] TERM=dumb RBHOME=e:\Redback\UVServer\RedBack COMSPEC=C:\WINDOWS\system32\cmd.exe SystemRoot=C:\WINDOWS Path=C:\WINDOWS\system32\;C:\WINDOWS\;e:\Redback\UVServer\RedBack\rgw\bi n UVHOME=E:\UV\uv UVBIN=E:\UV\uv\bin RedBack=1 [LogLevel] panic=1 err=1 wrn=1 inf=1 init=1 trace=1 verb=1 big=1 [Accounts] DATAFLO [DATAFLO] port= workdir=E:\dbms\LIVE\DATAFLO RGW.INI: DATAFLO 192.168.221.15: [LogLevel] panic=1 err=1 wrn=1 inf=1 init=1 trace=1 verb=1 big=1 ___ 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 ___ 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/mail
Re: [U2] UniData 'QUIT'
Kevin Thank you so much! I need to wait until the morning once the load on the server picks up to normal, but for now... clearing out that temp directory seemed to have fixed this! Appreciate everyone's help! Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 12:13 PM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' Yeah, that's exactly what I'm asking. If you restart Unidata, that *should *be cleared or at least reduced, but if not, I would wonder why it's so dang full...? On Thu, Jun 24, 2010 at 12:44 PM, Amy Cook wrote: > It started happening on the 14th. We rebooted minimum once a day the > 14th-16th, and I have restarted UniData without a reboot twice since > then as part of troubleshooting in the evenings when people aren't on > system. > > Wow! I'm not sure this is what you're asking, but my unidata temp space > is set to e:\ud\temp...and it's huge...51g239k files. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King > Sent: Thursday, June 24, 2010 11:36 AM > To: U2 Users List > Subject: Re: [U2] UniData 'QUIT' > > How much space is being occupied for Unidata temp space? Have you > restarted > Unidata on that box anytime recently? > ___ > 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 > -- -Kevin http://www.PrecisOnline.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] UniData 'QUIT'
I'm assuming if UniData is stopped...that it's ok to clear the temp directory? There are files in there from last year, so if something is supposed to be cleaning them up (I mean something besides me) it doesn't appear to be. (it's now on my checklist!) Cool, at least this gives me something to try tonight...i had run out of ideas to troubleshoot. I'll stop unidata, clear temp, start unidata, do my mutli-session udt testing...all with no one else on and nothing else running. Plus then once I've disconnected, I can see what's hanging out in temp in case that tells me anything. Thanks for everyone's input! I'll report back tomorrow... Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 12:13 PM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' Yeah, that's exactly what I'm asking. If you restart Unidata, that *should *be cleared or at least reduced, but if not, I would wonder why it's so dang full...? On Thu, Jun 24, 2010 at 12:44 PM, Amy Cook wrote: > It started happening on the 14th. We rebooted minimum once a day the > 14th-16th, and I have restarted UniData without a reboot twice since > then as part of troubleshooting in the evenings when people aren't on > system. > > Wow! I'm not sure this is what you're asking, but my unidata temp space > is set to e:\ud\temp...and it's huge...51g239k files. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King > Sent: Thursday, June 24, 2010 11:36 AM > To: U2 Users List > Subject: Re: [U2] UniData 'QUIT' > > How much space is being occupied for Unidata temp space? Have you > restarted > Unidata on that box anytime recently? > ___ > 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 > -- -Kevin http://www.PrecisOnline.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] UniData 'QUIT'
It started happening on the 14th. We rebooted minimum once a day the 14th-16th, and I have restarted UniData without a reboot twice since then as part of troubleshooting in the evenings when people aren't on system. Wow! I'm not sure this is what you're asking, but my unidata temp space is set to e:\ud\temp...and it's huge...51g239k files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 11:36 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' How much space is being occupied for Unidata temp space? Have you restarted Unidata on that box anytime recently? ___ 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] UniData 'QUIT'
Yep, verified. (UniData) UniData Release 6.1 Build: (5150) (c) Copyright IBM Corporation 2005. All rights reserved. Current UniData home is E:\ud\. Current working directory is E:\ud\demo. :CT VOC LO VOC: LO: S QUIT : -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 10:41 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' did you verify that LO is the default UV LO and not overwritten by anything? If so, that definitely says the issue is in UV. ___ 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] UniData 'QUIT'
Nope, it's the same. I just recreated the 1/2/4 session scenario, and it behaved the same way as QUIT. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 10:36 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' Amy, is LO (rather than QUIT) any faster? ___ 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] UniData 'QUIT'
I logged into 6 udt's on server. I did a 'MYSELF' on last session so I could get my port and find pid. I did the PORT.STATUS on that pid, and it shows my MYSELF command in my stack. Then, I went back to server, logged out all 6 sessions at once (with pid 49528 being the last one I logged out so it was hanging the longest), and did a .X on the PORT.STATUS - showed nothing in stack. PORT.STATUS PID 49528 CALL.STACK Licensed/Effective # of UsersSql iPhantom Total 113 / 113 1 094 Udtno Pid User Port Last command processed 154 49528 acook 29677744 MYSELF Session is not in BASIC. ECL session stack MYSELF :.X PORT.STATUS PID 49528 CALL.STACK Licensed/Effective # of UsersSql iPhantom Total 113 / 113 1 088 Udtno Pid User Port Last command processed : -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Amy Cook Sent: Thursday, June 24, 2010 10:20 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' Yeah, that's what I've been doing, I've taken telnet and SB out of the picture. This is specifically through udt.exe on the server, which logs me into unidata demo account. There is no ON.EXIT in VOC. Process Explorer didn't tell me anything, just highlighted it red as it was trying to terminate. Nothing that we know of has changed on the server. We checked windows updates in add/remove, nothing recent. We have not updated the database or increased licenses since we've been live on this server. No changes to unidata configuration. No new hardware. No errors re": existing hardware. Server had been rebooted about a week earlier, so even if we had some updates we didn't know about (auto update is turned off), they would have been put into effect after that reboot. I'll recreate situation and check PORT.STATUS. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Thursday, June 24, 2010 10:14 AM To: 'U2 Users List' Subject: Re: [U2] UniData 'QUIT' If you were on *nix I would suggest looking at your wtmp file. What's changed on the server? Did you add more licenses without updating udtconfig (or made changes to udtconfig)? Is there an ON.EXIT VOC item (not likely in the DEMO account as well)? Even though you don't see them through listuser I wonder if PORT.STATUS PID CALL.STACK could tell you anything. Look at the processes using Process Explorer or Process Monitor from <http://technet.microsoft.com/en-ca/sysinternals/default.aspx> which may provide clues as to what it's hanging up on. What happens if you connect directly to udt.exe on the server (rather than going through telnet)? Hth Colin Alfke Calgary, Canada -Original Message- From: Amy Cook As a test, a co-worker suggested I see if the time increased with multiple sessions. Again, udt'd into demo account, issued quit command: 1 session = 3 seconds 2 sessions = 5-6 seconds 4 sessions = 14 seconds 8 sessions = 1st ended at 21 seconds, 2nd at 35, 3rd at 40, then last couple cleaned up by 50 seconds. I don't necessarily think it matters that they were all logged in as me, but they were, in case that sparks anything for anyone. I DO think it matters that they were all trying to logout at the same time. I currently have 16 record locks, none of them are mine. -Original Message- From: Bill Haskett Kevin: Quit may be in UV but it's the "off" command in UniData. I've had to remove it from our application and replaced it with "off", which cleans up our application, then quits. I suspect SB+ doing something similar with "quit" by replacing the default verb with their version. Bill Kevin King said the following on 6/24/2010 8:56 AM: > John has an interesting point. I thought QUIT was UV but looking into the > system in front of me right now it appears to be an SB+ thing running SH.OFF > out of DMSH. So that makes me wonder if the file size of DMSECURITY or > DMCONT or one of those DM files might be having an impact? ___ 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] UniData 'QUIT'
Yeah, that's what I've been doing, I've taken telnet and SB out of the picture. This is specifically through udt.exe on the server, which logs me into unidata demo account. There is no ON.EXIT in VOC. Process Explorer didn't tell me anything, just highlighted it red as it was trying to terminate. Nothing that we know of has changed on the server. We checked windows updates in add/remove, nothing recent. We have not updated the database or increased licenses since we've been live on this server. No changes to unidata configuration. No new hardware. No errors re": existing hardware. Server had been rebooted about a week earlier, so even if we had some updates we didn't know about (auto update is turned off), they would have been put into effect after that reboot. I'll recreate situation and check PORT.STATUS. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Thursday, June 24, 2010 10:14 AM To: 'U2 Users List' Subject: Re: [U2] UniData 'QUIT' If you were on *nix I would suggest looking at your wtmp file. What's changed on the server? Did you add more licenses without updating udtconfig (or made changes to udtconfig)? Is there an ON.EXIT VOC item (not likely in the DEMO account as well)? Even though you don't see them through listuser I wonder if PORT.STATUS PID CALL.STACK could tell you anything. Look at the processes using Process Explorer or Process Monitor from <http://technet.microsoft.com/en-ca/sysinternals/default.aspx> which may provide clues as to what it's hanging up on. What happens if you connect directly to udt.exe on the server (rather than going through telnet)? Hth Colin Alfke Calgary, Canada -Original Message- From: Amy Cook As a test, a co-worker suggested I see if the time increased with multiple sessions. Again, udt'd into demo account, issued quit command: 1 session = 3 seconds 2 sessions = 5-6 seconds 4 sessions = 14 seconds 8 sessions = 1st ended at 21 seconds, 2nd at 35, 3rd at 40, then last couple cleaned up by 50 seconds. I don't necessarily think it matters that they were all logged in as me, but they were, in case that sparks anything for anyone. I DO think it matters that they were all trying to logout at the same time. I currently have 16 record locks, none of them are mine. -Original Message- From: Bill Haskett Kevin: Quit may be in UV but it's the "off" command in UniData. I've had to remove it from our application and replaced it with "off", which cleans up our application, then quits. I suspect SB+ doing something similar with "quit" by replacing the default verb with their version. Bill Kevin King said the following on 6/24/2010 8:56 AM: > John has an interesting point. I thought QUIT was UV but looking into the > system in front of me right now it appears to be an SB+ thing running SH.OFF > out of DMSH. So that makes me wonder if the file size of DMSECURITY or > DMCONT or one of those DM files might be having an impact? ___ 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] UniData 'QUIT'
As a test, a co-worker suggested I see if the time increased with multiple sessions. Again, udt'd into demo account, issued quit command: 1 session = 3 seconds 2 sessions = 5-6 seconds 4 sessions = 14 seconds 8 sessions = 1st ended at 21 seconds, 2nd at 35, 3rd at 40, then last couple cleaned up by 50 seconds. I don't necessarily think it matters that they were all logged in as me, but they were, in case that sparks anything for anyone. I DO think it matters that they were all trying to logout at the same time. I currently have 16 record locks, none of them are mine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, June 24, 2010 9:14 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' Kevin: Quit may be in UV but it's the "off" command in UniData. I've had to remove it from our application and replaced it with "off", which cleans up our application, then quits. I suspect SB+ doing something similar with "quit" by replacing the default verb with their version. Bill Kevin King said the following on 6/24/2010 8:56 AM: > John has an interesting point. I thought QUIT was UV but looking into the > system in front of me right now it appears to be an SB+ thing running SH.OFF > out of DMSH. So that makes me wonder if the file size of DMSECURITY or > DMCONT or one of those DM files might be having an impact? > ___ > 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] UniData 'QUIT'
Btw, at the point where there's quite a few udt.exe's that exist at o/s but are already released from unidata (as I see through listuser, anyway)...those udt.exe's are consuming zero cpu. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, June 24, 2010 8:47 AM To: 'U2 Users List' Subject: Re: [U2] UniData 'QUIT' The QUIT command just exits the udt process. Of course udt itself will do some tidying up at that point - releasing locks etc, then the OS will do some tidying up with regard memory space etc. I have seen quit take a long time when the udt process has got hold of a lot of ram, so check out the process and see how much ram/cpu it is using, also check the lock table to see if it is having to release a lot of locks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Amy Cook Sent: 24 June 2010 16:31 To: U2 Users List Subject: [U2] UniData 'QUIT' Can anyone tell me exactly what the QUIT verb does? Does it issue a stopudt? Does it also do a 'kill' or windows equivalent of o/s process id? I'm asking because we have a situation where: 1) When I issue the quit command (using demo account for testing purposes), it takes a minimum of 3 seconds now to logout. It's never been anything but immediate up until a week and a half ago. 2) if we have numerous phantoms running, they seems to be hitting this same delay in logging out, and within a couple minutes, that 3 seconds grows to 20 seconds...up to 20 minutes or more...waiting on the other sessions to logout. 3) At the point where it's taking a long time to logout...the database has already released the session. Listuser no longer shows that phantom session. But the Task Manager shows it's still active to the O/S. At first we were focused on the phantoms, but these are the only sessions that really log in, do something, then immediately log out...creating the perfect environment for building up the 'queue' for logout. Since we've been through a ton of troubleshooting already, I'm trying to start over at ground zero and figure out why a simple unidata session to the demo account doesn't immediately log out when I issue the quit command. Any ideas?? TIA, Amy ___ 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] UniData 'QUIT'
I'll check that right now. But remember, I've taken my app and SB out of the picture by doing it in demo. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 8:57 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' John has an interesting point. I thought QUIT was UV but looking into the system in front of me right now it appears to be an SB+ thing running SH.OFF out of DMSH. So that makes me wonder if the file size of DMSECURITY or DMCONT or one of those DM files might be having an impact? ___ 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] UniData 'QUIT'
Well. I've turned off the processing that creates those phantoms, but here's what was happening last week, and I can re-create at will (but I have to watch it closely because other things - specifically uniobjects calls - hang up behind them and fail.) I remember now, we did try to do a LIST.READU EVERY, and we get a syntax error (ud 6.1.16). Just tried it again, same error. I currently have 14 record locks from a LIST.READU, which is probably average for any moment during the day. But there are no record locks associated with my unidata session to demo. I initiate udt, then type quit, doing nothing else in between. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, June 24, 2010 8:47 AM To: 'U2 Users List' Subject: Re: [U2] UniData 'QUIT' The QUIT command just exits the udt process. Of course udt itself will do some tidying up at that point - releasing locks etc, then the OS will do some tidying up with regard memory space etc. I have seen quit take a long time when the udt process has got hold of a lot of ram, so check out the process and see how much ram/cpu it is using, also check the lock table to see if it is having to release a lot of locks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Amy Cook Sent: 24 June 2010 16:31 To: U2 Users List Subject: [U2] UniData 'QUIT' Can anyone tell me exactly what the QUIT verb does? Does it issue a stopudt? Does it also do a 'kill' or windows equivalent of o/s process id? I'm asking because we have a situation where: 1) When I issue the quit command (using demo account for testing purposes), it takes a minimum of 3 seconds now to logout. It's never been anything but immediate up until a week and a half ago. 2) if we have numerous phantoms running, they seems to be hitting this same delay in logging out, and within a couple minutes, that 3 seconds grows to 20 seconds...up to 20 minutes or more...waiting on the other sessions to logout. 3) At the point where it's taking a long time to logout...the database has already released the session. Listuser no longer shows that phantom session. But the Task Manager shows it's still active to the O/S. At first we were focused on the phantoms, but these are the only sessions that really log in, do something, then immediately log out...creating the perfect environment for building up the 'queue' for logout. Since we've been through a ton of troubleshooting already, I'm trying to start over at ground zero and figure out why a simple unidata session to the demo account doesn't immediately log out when I issue the quit command. Any ideas?? TIA, Amy ___ 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] UniData 'QUIT'
>From a LIST.READU? Or is there another admin command to view lock table? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, June 24, 2010 8:40 AM To: U2 Users List Subject: Re: [U2] UniData 'QUIT' Amy, what's the lock table look like during these delays? ___ 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] UniData 'QUIT'
Can anyone tell me exactly what the QUIT verb does? Does it issue a stopudt? Does it also do a 'kill' or windows equivalent of o/s process id? I'm asking because we have a situation where: 1) When I issue the quit command (using demo account for testing purposes), it takes a minimum of 3 seconds now to logout. It's never been anything but immediate up until a week and a half ago. 2) if we have numerous phantoms running, they seems to be hitting this same delay in logging out, and within a couple minutes, that 3 seconds grows to 20 seconds...up to 20 minutes or more...waiting on the other sessions to logout. 3) At the point where it's taking a long time to logout...the database has already released the session. Listuser no longer shows that phantom session. But the Task Manager shows it's still active to the O/S. At first we were focused on the phantoms, but these are the only sessions that really log in, do something, then immediately log out...creating the perfect environment for building up the 'queue' for logout. Since we've been through a ton of troubleshooting already, I'm trying to start over at ground zero and figure out why a simple unidata session to the demo account doesn't immediately log out when I issue the quit command. Any ideas?? TIA, Amy ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CLEAN.SYSTEM
John, Is this an event viewer error, or is this coming from one of the RedBack logs? (If Event Viewer, is there anything telling in the redback logs?) I've never had to run clean.system for any RedBack related issues - not saying that wouldn't be beneficial because I don't know one way or the other - but I thought there was a WW.xxx command that cleared out redback 'work' files, same as clean.system would for IIWORK. Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, May 05, 2010 12:25 PM To: U2 Users List Subject: [U2] CLEAN.SYSTEM I am getting an error in RedBack. Error code = 0XF002001E Sorry, an error has occurred in RGWSCHED I am being told to run /CLEAN.SYSTEM to see if this solves the problem. 1) what does this SB command do? 2) is this likely to fix the problem with RedBack? John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 ___ 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] UniData 6.1 index corruption
Thank you Colin. Good idea - that worked. And thanks for the info on guide_ndx. Have a nice day, Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Monday, July 13, 2009 1:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 6.1 index corruption Not sure if this was available in 6.1 but here is the help for GUIDE_NDX. Generally, if I have an error in an index and decide to delete it I will delete ALL which also deletes the X_ at the OS level and then completely rebuild it. guide_ndx Syntax guide_ndx{-x |-X}{1|2 |3},{index_names, ... | ALL} [-t template |-T template] filename Description As with other UniData file types, an index file could become corrupt due to hardware failures, the interruption of a write to the index file, or an incomplete write. The guide_ndx utility checks for physical and logical corruption of an index file. If an index file is corrupt, UniData displays a run time error when a UniData process tries to access the index. If the index file is associated with a recoverable file, a message is written to the sm.log. The guide_ndx command creates two files, the GUIDE_XERROR.LIS and the GUIDE_STATS.LIS. GUIDE_ERROR.LIS lists any corruption found in the index file, and GUIDE_STATS.LIS list statistics about the index. If you have a corrupt index, you must rebuild it using the CREATE.INDEX and BUILD.INDEX commands. For more information and creating and building indexes, see Using UniData. Note: We recommend deleting the index with the DELETE.INDEX ALL command. Using the ALL option deletes all alternate key indexes and the index file itself. Parameters The following table describes each parameter of the syntax. Parameter Description -x{1 | 2 | 3} Determines the type of checking guide_ndx performs. * 1 - Performs physical checking * 2 - Performs logical checking * 3 - Performs physical and logical checking index_names The index names you want guide_ndx to check. Separate each index name with a comma, or enter ALL to check all indexes for the file. -t template The template to use for output files. The default is GUIDE. filenameThe name of the data file containing the index. hth Colin Alfke Calgary, Canada > From: amy_cook > > I'm in the process of rebuilding indexes on our new server (changed > platforms, ran convidx, but rebuilding just to be sure). > > During a BUILD.INDEX FILENAME ALL on one of the files, I kept on getting > disconnected from my telnet session. So I started building the indexes > individually. I isolated the problem one, and then attempted to delete > the index. Got confirmation on screen 'CUST.LAST' deleted, but then it > disconnected my session. Went back in and index still there. > > Trying to gather more information, I listed the file using the index > that's causing problems and get: > > Index: invalid 'next' (2441216) of node 4648960. > > Searching index failed 1 > > > I'm having trouble finding my UD documentation - is there a file utility > specific to indexes? > > TIA, > Amy _ Send and receive email from all of your webmail accounts. http://go.microsoft.com/?linkid=9671356 ___ 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] UniData 6.1 index corruption
I'm in the process of rebuilding indexes on our new server (changed platforms, ran convidx, but rebuilding just to be sure). During a BUILD.INDEX FILENAME ALL on one of the files, I kept on getting disconnected from my telnet session. So I started building the indexes individually. I isolated the problem one, and then attempted to delete the index. Got confirmation on screen 'CUST.LAST' deleted, but then it disconnected my session. Went back in and index still there. Trying to gather more information, I listed the file using the index that's causing problems and get: Index: invalid 'next' (2441216) of node 4648960. Searching index failed 1 I'm having trouble finding my UD documentation - is there a file utility specific to indexes? TIA, Amy ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniData ODBC error: join: write error (#0)
Anyone ever seen this one before? I'm assuming it's a data error, because this query's been working for 2 years (it's just a query, no updating being done) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Invalid Lock Sequence Write Errors
I'm getting the following error that's bailing me out of a UniData (version 6.0.9) subroutine. Because I thought it might be corruption, I ran guide, found no corruption, but a little undersized. I created a new file at correct modulo, then copied all records from original file over, then renamed new file to INVWHS. All records copied over (did a count on both). Ran guide on the new file and everything was as it should be. But I'm still getting the errors. So...I went in and verified I could edit the individual record, file it, even copy to new record name and delete original, and that's all working. In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 UPL error = 102 : Invalid lock sequence In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 Lockname (3 76257 1073807361) RX -- 13359104 PT->fid -- (376257 1073807361) IX R(13359104)--[1 0] 703(X 1) In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 upl lock er ror(102). In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 1: error in U_dyn_hash for file 'INVWHS', key '46483*195', number=6522 In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 Fatal error : WRITE error This is not just one record (hit about 20 so far), but here's the syntax below: The syntax at line 115 is WRITE ITEM.WH ON FILE.WH,WH.KEY. The record was locked about 10 lines earlier... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects 30102 error
Never mind - figured it out. Had a typo in a file path for a file I was creating with a PCPERFORM. Assume the program bailed on that Thanks, Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Wednesday, June 04, 2008 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects 30102 error Does anyone know the 30102 error? The documentation I'm looking at goes from 30101 to 30103. Thanks, Amy --- 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] UniObjects 30102 error
Does anyone know the 30102 error? The documentation I'm looking at goes from 30101 to 30103. Thanks, Amy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Anyone able to resize the UDODBC privilege file?
Anyone able to resize the privilege file? I'm on UniData 6.0.9 on HPUX. I can resize all the associated SQL files, views, etc, as long as I do so as sqlmgr (the user that created the schema). However - if I try to resize privilege file, I consistently 'break' it. Get the dreaded: 'No privilege on file...' error. And have to go back and re-run schema generation from scratch. Verified that sqlmgr is still the owner of privilege file and permissions are 666, as they were before. Any ideas? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData and RedBack
David, I don't know how reliable this is, just throwing it out there, but the redback sessions also don't have an IP address, whereas the telnet sessions from workstations do. !listuser -i We also start responders as user redback (unix), so that's what we use. Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, April 05, 2007 8:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData and RedBack The 'NT Logon' for RedBack users appears to be "System" - Would that be the most 'reliable'/best approach? I could check @LOGNAME for that... > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, April 05, 2007 9:37 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniData and RedBack > > David > > I've only used RedBack with UniVerse, but.. > > Why not create a specific user e.g. 'redback' and use that > when you start the responders? Then you can check for that > user name in your program. > > Brian > > Is there a way to tell that a session is a RedBack session vs > a UniData telnet session? > > I thought @USER.TYPE would tell me - but both UniData telnet > and RedBack sessions return a "0". I was thinking RedBack > would return a "2". > > How else can a BASIC program tell if it is being called from > the Web or not? --- 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] UniODBC with ASP error
Wendy, Can you do a SQL select of the table that your asp is accessing? I seem to remember seeing this error on an i-descriptor included in the view which was using a subroutine that had an $INCLUDES in it... It's a long shot, but something to look at. Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody Sent: Monday, January 08, 2007 1:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniODBC with ASP error Hi all, I am working on CAS project that has an error I could not figure out. Does anyone experience call Datatel subroutine with error out on asp page? It bomb out on a S.EVALUATE.PROGRAM subroutine in Unibasic program. On my ASP pages it shows Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]Unidata lower level function error with fetch Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- 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] ODBC Error
Al, Is it possible that you lost network connectivity between the client executing the query, and the unidata server, during the query? I'm responding from memory, so I could be off, but I'm thinking this might be the culprit. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Tuesday, July 18, 2006 3:17 PM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC Error Has anybody know what this error means? SQL Status: IM985 Error code: 81001 [Ardent][UniData ODBC Driver][UniData RDBMS][IBM][SQL Client][RPC] error code = 81001 Albert L. DeWitt Jr. Senior Programmer Analyst Stylmark, Inc. (V) 763-574-8705 (F) 763-574-1052 [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] UniBasic CRLF over NFS mount
Actually, it was working ftp, but not over NFS which is what I needed. File was being created w/ LF only after each attribute, but needed a CRLF. Added a CHAR(13) to end of each attribute, so it creates it now CRLF, which is what I was missing. Thanks, Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Verhagen Sent: Thursday, February 10, 2005 8:55 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniBasic CRLF over NFS mount If you're using FTP to do the transfer from UNIX to DOS (which you say you are) then make the the FTP Transfer mode is ASCII, it usually defaults to BINARY (BIN). Most FTP clients will automatically convert CR to CRLF when transfering in ASCII mode. "ASSIGN 1 to SYSTEM(1017)" In Unidata the equivalent command for no conversion is "NOCONVERT [ON | OFF]" Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 1690 S Congress Avenue, Suite 210 Delray Beach, FL 33445 USA Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 >>> [EMAIL PROTECTED] 7:37:01 PM 02/09/2005 >>> There should be a ux2dos or unix2dos program in the operating system you can use to convert cr to crlf. Example: cat foo.txt| ux2dos > new.txt ; mv new.txt foo.txt You can execute this statement from your basic program etc... -Original Message- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Sent: Wed Feb 09 16:33:13 2005 Subject: [U2] UniBasic CRLF over NFS mount I'm building a flat file in UniBasic on a unix system, then writing it to an NFS mount point. The file attributes are interpreted as CRLF's when I ftp the file over to the windows system, but when I write or move the file over to the NFS mount, the attributes are only separated by unrecognizable characters (to notepad). The problem is, the version of the (BarTender) application I'm upgrading to, requires a CRLF before/after one of the attributes. Any suggestions/thoughts? TIA, Amy --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniBasic CRLF over NFS mount
It is unidata, but I'll see if I can find the equivalent... Thanks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 3:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniBasic CRLF over NFS mount is this universe ? try putting "ASSIGN 1 to SYSTEM(1017)" immediately before the write , this tells universe not to convert the record when writing. there is a comparable statement in Unidata but I don't recall it. Kevin Lynch -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Wednesday, February 09, 2005 5:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniBasic CRLF over NFS mount I'm building a flat file in UniBasic on a unix system, then writing it to an NFS mount point. The file attributes are interpreted as CRLF's when I ftp the file over to the windows system, but when I write or move the file over to the NFS mount, the attributes are only separated by unrecognizable characters (to notepad). The problem is, the version of the (BarTender) application I'm upgrading to, requires a CRLF before/after one of the attributes. Any suggestions/thoughts? TIA, Amy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the Inbound TSH Mail Filter Please Report any issues to [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/
[U2] UniBasic CRLF over NFS mount
I'm building a flat file in UniBasic on a unix system, then writing it to an NFS mount point. The file attributes are interpreted as CRLF's when I ftp the file over to the windows system, but when I write or move the file over to the NFS mount, the attributes are only separated by unrecognizable characters (to notepad). The problem is, the version of the (BarTender) application I'm upgrading to, requires a CRLF before/after one of the attributes. Any suggestions/thoughts? TIA, Amy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData ODBC / Prompt for selection criteria
Just to let everyone know, this is a bug. It was reported to IBM back in 2002, and it's still not fixed. They now have a new eCase for it, 7477, which is apparently in 'Advanced Tech Support' awaiting prioritization, etc... If this is something you might like to do (a fairly standard request for a query design), please let IBM or your VAR know--I imagine the more interest that's shown, the more priority that will be placed on the eCase. Thanks, Amy -Original Message- From: Amy Cook Sent: Wednesday, January 19, 2005 7:22 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UniData ODBC / Prompt for selection criteria Sorry, no I mean that I'm prompting from the 3rd party client. (i.e. in MSAccess, the selection criteria is [Please enter the fiscal year] ...or something to that effect... which would bring up the dialog box for the person running the query. In that example, if I enter 2004 in the dialog box, I get the error. If I enter 2004 into the selection criteria itself, the query works. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Tuesday, January 18, 2005 9:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData ODBC / Prompt for selection criteria Do you mean you're trying to do an <> prompt through an ODBC connection? You're a brave soul. I would prompt for imput in the 3rd party client and pass the full string through... hth Colin Alfke -Original Message- From: Amy Cook I know this issue has been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- 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] UniData ODBC / Prompt for selection criteria
Sorry, no I mean that I'm prompting from the 3rd party client. (i.e. in MSAccess, the selection criteria is [Please enter the fiscal year] ...or something to that effect... which would bring up the dialog box for the person running the query. In that example, if I enter 2004 in the dialog box, I get the error. If I enter 2004 into the selection criteria itself, the query works. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Tuesday, January 18, 2005 9:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData ODBC / Prompt for selection criteria Do you mean you're trying to do an <> prompt through an ODBC connection? You're a brave soul. I would prompt for imput in the 3rd party client and pass the full string through... hth Colin Alfke -Original Message----- From: Amy Cook I know this issue has been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- 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] UniData ODBC / Prompt for selection criteria
I know this issue has been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
Yeah...the frustrating part (for me anyways) is managing the privileges. Try on the views, hopefully that will doit. Or...what we've ended up doingis generating the schema as a generic user (we created a unix account called sqlmgr) then when we deliver an access database, the password is saved. Anyone creating queries will login via odbc as sqlmgr. Just so you know, if you wish to do that now, I believe you'll need to cleanup the schema then regenerate as the generic user (so everything's owned by the same person). I'm not sure how you do that in vsg...i don't have it loaded right now. But...there's probably an option to do so? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Tuesday, November 23, 2004 7:01 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata Odbc Thanks Amy. I was granting Select to Public on the SQL tables , but not on the views maybe that could help. The consultant is pointing his ERWIN tool at MS access ,to show the columns. -Original Message- # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Odbc
Hi Steven, I've never used ERWIN, and we actually generate our schema through our application which calls the schema API that VSG does, so I'm a little sketchy on the exact details as they happen through VSG hopefully you'll get a better answer back from the rest of the group. But...I think when you create the schema through VSG, you're telling the schema API what fields to include in the 'new' SQL table dictionary. Those fields you've chosen to include are placed in a new dictionary with the given table name (let's say you have a file called CUSTMASTER in UniData, and you include F1 - F10 in a SQL table called CUSTOMER). This actually creates a new VOC entry called CUSTOMER, pointing to the original data file CUSTMASTER, and the new dictionary D_CUSTOMER. You then create the view on this table, which you report off of. I believe it's when you create the view(s) that you create the SQLColumns table (happens automatically through VSG), which is probably where ERWIN is looking for it's metadata. (verify that w/ the consultant?) It's either that, or the dictionary items of the tables that come up in SQLTables. (However, if that's the case, it's probably a function of the UniData ODBC driver, so ERWIN shouldn't have to do anything different from the front end then MSAccess is doing.) The other thing I'd check...if you created the schema logged into the database as yourself, then you'd have to grant privilege on any views that you want the consultant to have access to (unless he's logging in as the same user you created the schema as). You do that thru VSG as well. This is SQL privilege, not your unix permissions... HTH, Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Tuesday, November 23, 2004 11:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata Odbc Hi -- has anybody used a tool called ERWIN against unidata ( using ODBC). This is a database modelling-reverse engineering tool one of our consultants is using to gain a graphical look at our schema. The tool doesn't appear to be showing column names for the tables/views , although MS access can see the column names. Any thoughts? Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, November 22, 2004 1:39 PM To: U2 Users (E-mail) Subject: [U2] Unidata Odbc Hi -- I am attempting to set up an ODBC connection to Unidta 5.2.2 I have figured that I need to edit the ud_database file in /usr/ud52/include before the ODBC connection I am using MS access -- Get External Data - Import and using the demo database However , I get a blank dialog box named "Import Objects" -- shouldn't I see a list of files from the VOC? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email an
RE: [U2] Unidata Odbc
Steven, You will have had to first generate schema on your account to create the SQL system files, views and privileges on them. I believe the import is looking for objects in the SQLTables table (?) (which is created when you generate schema). If you've setup the server side access and installed the odbc driver on your workstation, also install Visual Schema Generator (VSG) from the client cd, and connect with that. The VSG pdf will give you a good overview Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, November 22, 2004 1:39 PM To: U2 Users (E-mail) Subject: [U2] Unidata Odbc Hi -- I am attempting to set up an ODBC connection to Unidta 5.2.2 I have figured that I need to edit the ud_database file in /usr/ud52/include before the ODBC connection I am using MS access -- Get External Data - Import and using the demo database However , I get a blank dialog box named "Import Objects" -- shouldn't I see a list of files from the VOC? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata and UniBasic training
Actually, Marilyn, I agree. I took a basics class - more on the structure of the database than any programming - from Raining Data. It met my needs at the time, but you'd probably want to focus on unibasic if you're a programmer. On another note...don't know why I didn't think of this before, but I took a system builder class from Kevin King, and it was EXCELLENT. Regardless if your application is built on SB, he's also a great resource for UniData. If you like, contact me offline, or try: http://www.precisonline.com/train.html ~Amy [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, November 10, 2004 12:55 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata and UniBasic training Just a warning from someone that programs on Unidata and Raining data Pick systems, they are different animals. There are similarities, but there are huge differences on some of the syntax of the statements, dict items, access language, printer setup, etc. If you're going to be programming in Unidata, by all means take the IBM classes!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Amy Cook Sent: Wednesday, November 10, 2004 11:56 To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata and UniBasic training Marilyn, Try Raining Data classes www.rainingdata.com, or IBM at http://www-306.ibm.com/services/learning/ites.wss/us/en?pageType=page&co ntentID=a523 Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Osaka Sent: Wednesday, November 10, 2004 11:38 AM To: [EMAIL PROTECTED] Subject: [U2] Unidata and UniBasic training Hi, we are fairly new to Unidata. Does anyone have any suggestions on where there are some introductory courses to learn UniData and UniBasic? Online tutorials, or classes in Canada or the US would be ideal. Thanks Marilyn Osaka Manager, Data Services/Research JuneWarren Publishing Ltd. Phone: (780)944-9333 ext.254 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata and UniBasic training
Marilyn, Try Raining Data classes www.rainingdata.com, or IBM at http://www-306.ibm.com/services/learning/ites.wss/us/en?pageType=page&co ntentID=a523 Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Osaka Sent: Wednesday, November 10, 2004 11:38 AM To: [EMAIL PROTECTED] Subject: [U2] Unidata and UniBasic training Hi, we are fairly new to Unidata. Does anyone have any suggestions on where there are some introductory courses to learn UniData and UniBasic? Online tutorials, or classes in Canada or the US would be ideal. Thanks Marilyn Osaka Manager, Data Services/Research JuneWarren Publishing Ltd. Phone: (780)944-9333 ext.254 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] merging data - fuzzy keys
Wow...do you ever have overlap? A bill-to and ship-to with the same name, and in the same citybut different customer numbers in your production database? What if someone spelled something wrong or with a different abbreviation in your excel db than your production? If you had the key to your customer master, it'd be easy...write a little upload utility from a flat file, or an update query using odbc. Any chance you can get that to add to your excel db? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Kunzman Sent: Tuesday, November 02, 2004 2:25 PM To: [EMAIL PROTECTED] Subject: [U2][UD] merging data - fuzzy keys I am working on a project to populate industry information (SIC, NAICS, etc.) into my customer database from a different database (excel). The only thing somewhat in common is the customer name, city, and state. By using these common data elements, I have limited success with SOUNDEX. Is there some other tool/utility I could use to help me merge this data? Unidata 6.0 HP9000 RP5470/ HPUX 11.11 Thanks in advance. Steve --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] JDBC and Unidata and Virtual Fields
Hi Kathy, We don't personally use JDBC, nor do I use VSG, because our application has a front end that calls the schema API. But the schm.pdf in the UniData documentation indicates you can build them into the view from there. Hope that's what you were looking for, Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kms Sent: Tuesday, October 05, 2004 7:47 AM To: [EMAIL PROTECTED] Subject: [U2] JDBC and Unidata and Virtual Fields Hi. Thought I would try posting one more time -- I am developing an application using JDBC accessing a Unidata database. I am using Uniobjects to retrieve the data and I know I have to build views to access the multivalue fields, but can I also access virtual fields or do I have to recreate them? Thank you. Kathy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UvOdbc
Actually, unless your universe is running on unix, make sure your (DSN) login is DOMAIN\username. That often resolves that error. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Wednesday, September 22, 2004 1:18 PM To: [EMAIL PROTECTED] Subject: [U2] UvOdbc I'm having a problem getting my odbc connection to UV working. I know many of you have already overcome this problem so I'm looking for some help in getting this going on my end. Here is what we have: UV 10.0.10 W2K (UV Server) W2K (Client) Wintegrate 4.2.1 Client side odbc driver = IBM Universe ODBC Driver 3.07.02.1130 File = FASTPA32.DLL Date = 06/19/2002 100 user license for UVODBC My ultimate goal is to query UV tables from Sql Server, but as a "simple" test I thought I would try using Excel. I used the existing user dsn for "UV/ODBC Sales Sample". I changed the server connection information to reflect my system obviously. Here is my problem: I can ping my server without a problem, the moment I click the "Test" button I get the following error: UniVerse ODBC configuration test failed. [IBM][UVODBC][0301892]Error ID: 110 Severity: SEVERE Facility: LINKERR - TCP error The odbc documentation, yes I actually read the documentation, states the following for Error id 110: TCP error. Other error messages (including strange character sequences) typically indicate that the port number in the Link Parameters field in the configu-ration file is incorrectly specified; you have connected to a service other than the rexec daemon (UNIX). Use UniVerse ODBC Config to check the port number of the rexec or autostart daemon or service (typically 512). Retry the connection. If this fails, reboot your PC and try again. If this fails, check to see if the host and its TCP/IP inetd, rexec, or autostart daemon are running. Error ID: 110, Severity: SEVERE, Facility: LINKERR My odbc config says 512, so I'm not really sure where the problem could be. I even turned on the trace in the odbc configuration editor, I see the error, but I have no idea what it means. Here's the trace: If someone could enlighten me I would greatly appreciate it. thx, rudy e uvodbc_config 6c8-7f0 ENTER SQLAllocEnv HENV * 0142FBFC e uvodbc_config 6c8-7f0 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x0142FBFC ( 0x00911540) e uvodbc_config 6c8-7f0 ENTER SQLAllocConnect HENV00911540 HDBC * 0142FBF8 e uvodbc_config 6c8-7f0 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV00911540 HDBC * 0x0142FBF8 ( 0x009115e8) e uvodbc_config 6c8-7f0 ENTER SQLDriverConnectW HDBC009115E8 HWND000604BC WCHAR * 0x00237310 [ -3] "**\ 0" SWORD -3 WCHAR * 0x00237310 SWORD8 SWORD * 0x UWORD3 e uvodbc_config 6c8-7f0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR) HDBC009115E8 HWND000604BC WCHAR * 0x00237310 [ -3] "**\ 0" SWORD -3 WCHAR * 0x00237310 SWORD8 SWORD * 0x UWORD3 DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110 Severity: SEVERE Facility: LINKERR - TCP error (10054) e uvodbc_config 6c8-7f0 ENTER SQLErrorW HENV00911540 HDBC009115E8 HSTMT WCHAR * 0x0142FBB8 (NYI) SDWORD *0x0142FC04 WCHAR * 0x0142F7B8 SWORD 511 SWORD * 0x0142FC00 e uvodbc_config 6c8-7f0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV00911540 HDBC009115E8 HSTMT WCHAR * 0x0142FBB8 (NYI) SDWORD *0x0142FC04 (10054) WCHAR * 0x0142F7B8 [ 84] "[IBM][UVODBC][0301892]Error ID: 110 Sever" SWORD 511 SWORD * 0x0142FC00 (84) e uvodbc_config 6c8-7f0 ENTER SQLFreeConnect HDBC009115E8 e uvodbc_config 6c8-7f0 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC009115E8 e uvodbc_config 6c8-7f0 ENTER SQLFreeEnv
RE: [U2][UD] ODBC to UniData
You know...i just thought of something. Login to unix as the same user you're trying to execute the odbc query from. Then cd over to the unidata account (coldev) & drop to TCL. Type LIST VOC = "DV_]" Choose one of those view names, and then type SQL SELECT * FROM XXX_NF; (Where XXX is one if the views from the list above, i.e DV_XXX_NF) Reason I'm saying to do this, is you're taking the driver out of the pictureplus then you know it's not unix permissions on the schema files, but rather something having to do w/ the driver or uci/rpc connection to this account. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: [U2][UD] ODBC to UniData Hi, I have been trying to connect to our UniData server via ODBC. It connects fine to the demo database. But when I try to connect to my own test database from MS-Access or VSG, it gives an error message "You don't have permissions to chdir to /datatel/development/coldev" !! I create files using Envision API from Datatel in the DEVelopment account/database (/datatel/development/coldev). The entry in my ud_database file looks like this: DATABASE=demo UDTHOME=/usr/ud52 UDTACCT=/usr/ud52/demo TRACE_LEVEL=0 DATABASE=test_db UDTHOME=/usr/ud52 UDTACCT=/datatel/development/coldev TRACE_LEVEL=0 I have been fiddling around with so many things, changing permissions on files, changing the ownership, etc, as suggested by a few people; but nothing seems to work!!! Do I have to make some change/entry in some other file too for me to be able to access the DEV account/database via ODBC? Can someone tell me what am I doing wrong? Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] ODBC to UniData
What I do rememberis logging in as the person that created the schema, let's call that account 'sqlmgr'. Then, I did a whoami (I think from the directory that had the sticky bit set...like in your case, /datatel/development, and it showed me as root. But, since root didn't have privilege (not permission, but SQL privilege), I couldn't access the schema files. But I'm not sure if you actually see your 'effective permission', or if we did some sort of trace that showed me my effective permission when trying to execute? Tell me...do you have unidata support (or application support that's a reseller for unidata?) I worked with one of the guys at IBM on this problem...i think it was Paul Chang) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Davis, Dawn Sent: Thursday, September 09, 2004 12:47 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData I DID have the same problem, but can't remember how I fixed it :( I know this may not make a whole heck of alota sense...but for some reason I went into the registry on my local pc, found the reg key for the pathname of the datatel db, and typed in manually the rest of the pathname, as editing the uciconfig file thru the uciconfig editor program wouldn't allow the whole pathname. Obiously, opening the file w/ notepad or something would also do the trick, but for some reason the registry key would not be updated. Also, someone somewhere said to have ONLY the required info in the uci.config file. Here are the contents of mine: [ODBC DATA SOURCES] DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = xxx.xxx.xx.xxx Try taking OUT the db pathname from this file. See if it works. Dawn Janel Davis DBA II [EMAIL PROTECTED] (410) 386-8058 Carroll Community College 1601 Washington Road Westminster, MD 21157 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 2:26 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData I tried logging in as root to connect. That didn't work either !! I guess the permissions don't apply to root or does it?! Isn't there anyone out there, who had the same problem and remembers how to fix? I guess not, otherwise you would have replied by now. -Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Thursday, September 09, 2004 12:19 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Hmmm...well I wish I could remember exactly how we fixed it, but I have a feeling it's something to do w/ the effective permissions of the person you're logging in as (who I'm assuming is the owner of the schema files...that is, the person who created the schema?) Since the sticky bit can change the effective user id of the person who's executing a file/cmd, then I think it might be seeing you as someone other than the owner of the schema files, and not allowing you to connect. I'm sure there's someone on the list who's a more experienced unix admin that Iwho might be able to help prove out (or disprove) this theory? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Forgot to add something: The permissions on the demo database (/usr/ud52/demo) are: usr : drwx r-x r-x ud52: drwx rws --- demo: drwx rws --- The permissions on my test database (/datatel/development/coldev) are: datatel : drwx rwx --- development : drwx rws --- coldev : drwx rwx --- The permissions on demo and my test database are almost the same except for the first directory. Does unix treats a user as 'others' if he/she tries to connect via ODBC, even though I have to enter my user id and password to connect? My earlier reply: All the directories have rwx for 'owner' and 'group'. Do I need to have it for 'others' too? The permissions are like this: drwx rwx --- for datatel and coldev. The sticky bit is set on development though as drwx rws --- . - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Thursday, September 09, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData If I remember correctly, you have to have rwx permission on every directory in the path, i.e. rwx permission on /datatel, on datatel/development, and on datatel/development/coldev Jim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita &
RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata
Actually, excel should prove to them it's not the driver that's the problem...the unidata driver supports level 2 API conformance. What exactly is it they're claiming that the odbc driver doesn't support, since it clearly works for other (Microsoft) applications? (but I'm with will...if xml is working for you, I'd stick w/ that...although I'm assuming you're staying it's not working for file sizes over 100mb). Anyway, are you getting an error? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Peterson Sent: Thursday, September 09, 2004 7:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata Unidata Version 6.0 and UniData ODBC, Version 3.1.4. I can connect using Excel, haven't tried Access or others but will try them in order to plead my case. Business Objects Data Integrator is an ETL tool. It has the ability to Use XML file formats on import, which has been working fine with file sizes under 100 Megabytes. I've been using XML, but thought I'd try ODBC. I may need to explore UniOLEDB also. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Wednesday, September 08, 2004 11:28 PM To: [EMAIL PROTECTED] Subject: RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata What version of the driver are you using? What version of UniData? We use it to connect with Crystal Reports 9? There are a number of tools that you can use to test the connection. I've used Access and Excel but my favourite is from: http://gpoulose.home.att.net/. Good luck Colin Alfke Calgary, AB -Original Message- From: Craig Peterson [mailto:[EMAIL PROTECTED] Sent: Wed 08/09/2004 3:58 PM To: [EMAIL PROTECTED] Cc: Subject:[U2] ODBC driver for VSG (Visual Schema Generator) Unidata Does anyone know if the ODBC driver for Unidata's VSG is supported By Datadirect? I have used the VSG to make our Unidata files ODBC compliant and am trying to import them as data stores in Business Objects Data Integrator , but am having difficulty. Tech at Business Objects claims the problem is with the ODBC driver. Craig Peterson Programmer/Analyst APMC --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] ODBC to UniData
Hmmm...well I wish I could remember exactly how we fixed it, but I have a feeling it's something to do w/ the effective permissions of the person you're logging in as (who I'm assuming is the owner of the schema files...that is, the person who created the schema?) Since the sticky bit can change the effective user id of the person who's executing a file/cmd, then I think it might be seeing you as someone other than the owner of the schema files, and not allowing you to connect. I'm sure there's someone on the list who's a more experienced unix admin that Iwho might be able to help prove out (or disprove) this theory? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Forgot to add something: The permissions on the demo database (/usr/ud52/demo) are: usr : drwx r-x r-x ud52: drwx rws --- demo: drwx rws --- The permissions on my test database (/datatel/development/coldev) are: datatel : drwx rwx --- development : drwx rws --- coldev : drwx rwx --- The permissions on demo and my test database are almost the same except for the first directory. Does unix treats a user as 'others' if he/she tries to connect via ODBC, even though I have to enter my user id and password to connect? My earlier reply: All the directories have rwx for 'owner' and 'group'. Do I need to have it for 'others' too? The permissions are like this: drwx rwx --- for datatel and coldev. The sticky bit is set on development though as drwx rws --- . - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Thursday, September 09, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData If I remember correctly, you have to have rwx permission on every directory in the path, i.e. rwx permission on /datatel, on datatel/development, and on datatel/development/coldev Jim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita > Sent: Thursday, September 09, 2004 7:50 AM > To: [EMAIL PROTECTED] > Subject: [U2][UD] ODBC to UniData > > Hi, > > I have been trying to connect to our UniData server via ODBC. > It connects fine to the demo database. > But when I try to connect to my own test database from MS-Access or VSG, > it gives an error message "You don't have permissions to chdir to > /datatel/development/coldev" !! > = "Never doubt that a small group of thoughtful committed people can change the world: indeed it's the only thing that ever has!" Margaret Meade __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] ODBC to UniData
Hm...ok, shot in the dark here.. What does your uci config file look like on your machine? Do you have any parameter defined besides the 4 basics? (like perhaps an account name?) DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = x Second, I seem to remember (this was a while ago...) seeing this specifically on an AIX system where sticky bit was setcan't remember if it was on the unirpcd or maybe the privilege file or VOC in the account directory. However, if this were the case, obviously it would be account specific since you can connect to demo, so that would point me away from any unirpcd or anything in $UDTBIN. Maybe a better question to ask isAt what point do you get the error? Is it after you've been prompted to enter the password to connect? Before you are prompted to choose from your list of views? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 8:37 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData It says permission. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Thursday, September 09, 2004 10:27 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Does it say permissions or privilege? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: [U2][UD] ODBC to UniData Hi, I have been trying to connect to our UniData server via ODBC. It connects fine to the demo database. But when I try to connect to my own test database from MS-Access or VSG, it gives an error message "You don't have permissions to chdir to /datatel/development/coldev" !! I create files using Envision API from Datatel in the DEVelopment account/database (/datatel/development/coldev). The entry in my ud_database file looks like this: DATABASE=demo UDTHOME=/usr/ud52 UDTACCT=/usr/ud52/demo TRACE_LEVEL=0 DATABASE=test_db UDTHOME=/usr/ud52 UDTACCT=/datatel/development/coldev TRACE_LEVEL=0 I have been fiddling around with so many things, changing permissions on files, changing the ownership, etc, as suggested by a few people; but nothing seems to work!!! Do I have to make some change/entry in some other file too for me to be able to access the DEV account/database via ODBC? Can someone tell me what am I doing wrong? Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] ODBC to UniData
Does it say permissions or privilege? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 7:50 AM To: [EMAIL PROTECTED] Subject: [U2][UD] ODBC to UniData Hi, I have been trying to connect to our UniData server via ODBC. It connects fine to the demo database. But when I try to connect to my own test database from MS-Access or VSG, it gives an error message "You don't have permissions to chdir to /datatel/development/coldev" !! I create files using Envision API from Datatel in the DEVelopment account/database (/datatel/development/coldev). The entry in my ud_database file looks like this: DATABASE=demo UDTHOME=/usr/ud52 UDTACCT=/usr/ud52/demo TRACE_LEVEL=0 DATABASE=test_db UDTHOME=/usr/ud52 UDTACCT=/datatel/development/coldev TRACE_LEVEL=0 I have been fiddling around with so many things, changing permissions on files, changing the ownership, etc, as suggested by a few people; but nothing seems to work!!! Do I have to make some change/entry in some other file too for me to be able to access the DEV account/database via ODBC? Can someone tell me what am I doing wrong? Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata
Hi Craig, I don't know what Business Objects is... but can you prove to them your data is normalized correctly by linking the table via Access or MSQuery? I remember working w/ a UPS tech, and he was claiming the same thingbut I was able to prove it wasn't the driver, because other compliant apps could retrieve the data. Is there a particular error you're getting? I (we) might be able to help? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Peterson Sent: Wednesday, September 08, 2004 2:58 PM To: [EMAIL PROTECTED] Subject: [U2] ODBC driver for VSG (Visual Schema Generator) Unidata Does anyone know if the ODBC driver for Unidata's VSG is supported By Datadirect? I have used the VSG to make our Unidata files ODBC compliant and am trying to import them as data stores in Business Objects Data Integrator , but am having difficulty. Tech at Business Objects claims the problem is with the ODBC driver. Craig Peterson Programmer/Analyst APMC --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Windows PE - can UV & UD co-exist on the same box ?
Ross, I don't know about PE, but I seem to remember on the server edition that you could define the telnet port the same place you defined the welcome banner. (course I just went and looked in UniData Admin and couldn't find it) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Wednesday, August 18, 2004 4:31 PM To: [EMAIL PROTECTED] Subject: [U2] [UD] Windows PE - can UV & UD co-exist on the same box ? I know, RTFM, but (as a shortcut) Can UV & UD co-exist on the same windows box ? I've just tried installing UD PE on my XP machine (which already had UV & D3 installed), but no joy. Reports a message with UDTelnet not starting - UD is running as I can access with console app, just no telnet. I already had UV Telnet server working on a non-standard port (233, so it could co-exist with D3 - D3 isn't running though, so it isn't trying to "steal" port 23) I can not see a way to configure telnet port as you can with UV, so assume [yeah, I know] that UD is stuck on port 23. Just about to load onto a "real server", but would still be nice to be able to "play with" on my notebook Ross Ferris Stamina Software Visage an Evolution in Software Development --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.740 / Virus Database: 494 - Release Date: 16/08/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
We're close to the same... >Change Request via module-specific superuser. >Write up a proposal that includes description of problem, what the mod will do to fix the problem, and any ongoing maintenance that will be required as a result of the mod. Sign off from the requestor, requestor's department manager, and IT manager. >Do the mod. Programmer signs off that it's finished. >IT manager delivers change to pilot, signs off. >Superuser tests in pilot, signs off. >IT manager delivers change to live, signs off. Amazing that the process to get a mod in place sometimes takes lots longer than the mod itselfweek or two ago, I just needed to change the length of a field...uugghhh! But that's the part where we've felt the most pain. Most of the other points we had to meet were minor changes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:24 PM To: [EMAIL PROTECTED] Subject: Re: [U2] [OT] Sarbanes-Oxley Same here. We have established a fairly extensive Change Control Tracking system with approval tracking at every stage. Change Request -> Approval Modification -> Approval Testing -> Approval Move to production -> Approval Final -> Approval Vance Alspach J & L Industrial Supply I was just wondering what lengths other departments/companies are doing to satisfy the requirements imposed by the Sarbanes-Oxley act? How much of an impact is it on your operations? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: non-admin groups access to universe nt
Hi Kevin, Just catching up on email, so not sure if anyone's gotten back to you yet. I don't use UniVerse anymore, but I used to support it, and I remember having to do an additional step (course this was back at uv 9.5x...so don't know if it's changed). If you connect with universe admin, click on ... i think it was network...something. Then there was some sort of option to choose home...or home dir for the user. (maybe user options or usersomething) Sorry to be so vague. Hopefully if this is the step you were missing, you'll be able to find it w/ what I could recall. (or maybe someone else was already able to help) Have a nice day, Amy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: Wednesday, July 28, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: Just wondering if anyone has any suggestions on how to allow 'non-admin' groups access to Universe on NT..my users that are members of Admin login perfectly, but a second group (webuser), has similar permissions and has been configured to "log on locally", but is still not able to login. Thanks, Kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is it possible to nest 'LOOP / WHILE READNEXT / REPEAT'loops?
Great! Thanks Dianne. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Tuesday, June 22, 2004 12:34 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Is it possible to nest 'LOOP / WHILE READNEXT / REPEAT'loops? You'll have to name each list, for example, EXECUTE CMD CAPTURING JUNK RTNLIST LISTNAME Then you can do READNEXT ITEM.ID FROM LISTNAME Then the program can keep track -Dianne Amy Cook wrote: >UniData, BASICTYPE P > > > >While debugging something I'm working on, I figured out I couldn't use >the LOOP / WHILE READNEXT / REPEAT as I had originally planned...seems >if you nest one inside the other, it loses track of which 'next' you're >asking for (I'm sure this is by design, I just either haven't run across >it yet, or am not using an option that is available to me...) > > > >For instance, in the code below, if my first active select list at line >003 contained 2 record ID's (1 & 2), and my second active select list at >line 011 also contained 2 record ID's, (A & B), then by the time I read >in my first SOD.ID at line 013, it was reading the 2nd record of my >first active select list (i.e. '2' instead of 'A') > > > >001: CMD = 'SELECT SOHDR WITH DATE GE "':BEG.DT:'" AND WITH DATE LE >"':END.DT:'"' > >002: CMD = CMD:' AND WITH STATUS NE "C" AND WITH PROD_LINE = "':ITP:'"' > >003: EXECUTE CMD CAPTURING JUNK;*need error trap > >004: LOOP > >005: WHILE READNEXT ITEM.ID DO > >006:READ SOH.REC FROM SOH,ITEM.ID ELSE SOH.REC='' > >007:BILL2 = SOH.REC<2> ;*bill-to >cust > >008:SLSPROG.ID = SOH.REC<15> > >009:READV SLSPROG FROM SYST,"OSC*":SLSPROG.ID,4 ELSE SLSPROG='' >;*SlsProg Desc > >010:CMD1 = 'SELECT SODET = "':ITEM.ID:']"' > >011:EXECUTE CMD1 CAPTURING SOD.JUNK > >012:LOOP > >013:WHILE READNEXT SOD.ID DO > >014: READ SOD.REC FROM SOD,SOD.ID ELSE SOD.REC='' ;*line >record > > > > > > > >Anyway...does anyone have either > >(a) a way to nest READNEXT's, or > >(b) another suggestion? ...I was thinking maybe a count on the records >of the 2nd file that meet my criteria, then a FOR/NEXT...? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Is it possible to nest 'LOOP / WHILE READNEXT / REPEAT' loops?
UniData, BASICTYPE P While debugging something I'm working on, I figured out I couldn't use the LOOP / WHILE READNEXT / REPEAT as I had originally planned...seems if you nest one inside the other, it loses track of which 'next' you're asking for (I'm sure this is by design, I just either haven't run across it yet, or am not using an option that is available to me...) For instance, in the code below, if my first active select list at line 003 contained 2 record ID's (1 & 2), and my second active select list at line 011 also contained 2 record ID's, (A & B), then by the time I read in my first SOD.ID at line 013, it was reading the 2nd record of my first active select list (i.e. '2' instead of 'A') 001: CMD = 'SELECT SOHDR WITH DATE GE "':BEG.DT:'" AND WITH DATE LE "':END.DT:'"' 002: CMD = CMD:' AND WITH STATUS NE "C" AND WITH PROD_LINE = "':ITP:'"' 003: EXECUTE CMD CAPTURING JUNK;*need error trap 004: LOOP 005: WHILE READNEXT ITEM.ID DO 006:READ SOH.REC FROM SOH,ITEM.ID ELSE SOH.REC='' 007:BILL2 = SOH.REC<2> ;*bill-to cust 008:SLSPROG.ID = SOH.REC<15> 009:READV SLSPROG FROM SYST,"OSC*":SLSPROG.ID,4 ELSE SLSPROG='' ;*SlsProg Desc 010:CMD1 = 'SELECT SODET = "':ITEM.ID:']"' 011:EXECUTE CMD1 CAPTURING SOD.JUNK 012:LOOP 013:WHILE READNEXT SOD.ID DO 014: READ SOD.REC FROM SOD,SOD.ID ELSE SOD.REC='' ;*line record Anyway...does anyone have either (a) a way to nest READNEXT's, or (b) another suggestion? ...I was thinking maybe a count on the records of the 2nd file that meet my criteria, then a FOR/NEXT...? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/