Re: [U2] OT Employment: Will work for food or manye
Will, Willing to post your resume? If you want people to help, it might help if they knew some of the details that make you worth promoting. Also, as I just said in the Selling MV class I did at Spectrum: "Sometimes you need to come in the door as the MS Office Trainer, the Network Guru, etc." You may need to get in the door with secondary skills and help a new shop convert to MV once they have faith in your opinions. - Chuck will wrote: Looks like I am losing my last major contract and nothing new is developing in the MV world locally or telecommute. If you have any leads you could help keep another disenfranchised MV professional off the streets... :-) Take care, Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic files, big transactions
Andre, I'm with Rick. He suggested "new partfile". But maybe some kind of queue or workfile, that routinely gets flushed, merging to modulo 1. And maybe zero length record or very small, so that 250 ids all land in the same group? Is group size 4KB? What does that have to do with the lock table in memory, you (or some lurker) may ask? When a record is locked, UV uses the inode & group# to determine where to plant the lock in the lock table. So that means that all these records will be assigned to the same lock group, since inode & group# (i.e., 1) will be the same for all. If you gave it a larger minimum.modulus, or converted that queue/work file to static, then, when you lock many or all records at once, that would spread the load across several lock groups, since the inode&group# combo would vary from record to record. cds P.S. I *think* splits and merges are suspended on groups that have records currently in the lock table. (Since group# determines where something is in the lock table, you couldn't have that being changed out from under you.) So as long as a record remains locked, your dynamic file will be not quite so dynamic. You might be hitting that, too. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Colin: Thanks! I'm getting success, with questions. :-) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 45 characters. *--: P 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: D_VOC Bottom. *--: FI Filed "DTAWEB" in file "VOC". 2 Demo (0)-> LIST DTAWEB errno=2: No such file or directory can not stat() in U_get_fileid(),fname=\\AsiOlyWaWeb\WebDev. Open file error. 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 30 characters. *--: 2 002: \\AsiOlyWaWeb\WebDev 002: \\AsiOlyWaWeb\E$\WebDev *--: fi Filed "DTAWEB" in file "VOC". 2 Demo (0)-> LIST DTAWEB ID-SUPP @ID_A LIST DTAWEB ID-SUPP @ID_A 18:33:21 Mar 09 2007 1 VOC... achdemo.html advantos advantos.NET aspnet_client DesignBais Logs sps WebExamples 8 records listed 2 Demo (0)-> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - First question is why am I getting directories listed here? I'd expect to only get one item listed (the "achdemo.html" file (item)). Secondly, why would I have to use the Window administrative "$" share reference? I explicitly "shared" the directory (gave it a "share" name the same as the directory), it works in DOS, what's up with UD? I've been under the impression UD handles this kind of thing easily. Since I'm not finding it easy at all I must be missing something critical. I've spent hours in the documentation and can't find anything on the IBM technical site. Not being able to access network shares from with UD is definitely causing problems. This brings up whole slew of questions regarding security. Am I able to write anything I want to anywhere I create a "path" VOC entry? Can I assume UD on NT runs under the administrator's credentials? Should I just blow off management of any security since it's so intertwined with the O/S? Any thoughts on this would be greatly appreciated. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2007 4:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Sharing a network directory Bill Try: Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: D_VOC Bottom. In one of your earlier examples you had D_VOC in <3>. You need this to list the file. You could leave as is and still be able to edit files. If you do delete the file in UniData it will tell you that it is a remote file and remove the VOC item. It won't delete either the directory or the D_VOC. Hth Colin Alfke Calgary Canada --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Bill Try: Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: D_VOC Bottom. In one of your earlier examples you had D_VOC in <3>. You need this to list the file. You could leave as is and still be able to edit files. If you do delete the file in UniData it will tell you that it is a remote file and remove the VOC item. It won't delete either the directory or the D_VOC. Hth Colin Alfke Calgary Canada >-Original Message- >From: Bill H [snip] > >I modified the "DTAWEB" (VOC) item on the dbms and tried to >list the contents. > >2 Demo (0)-> AE VOC DTAWEB >Top of "DTAWEB" in "VOC", 3 lines, 51 characters. >*--: p >001: DIR >002: \\AsiOlyWaWeb\E$\WebDev >003: \\AsiOlyWaWeb\E$\WebDev >Bottom. > >2 Demo (0)-> LIST DTAWEB >Open \\AsiOlyWaWeb\E$\WebDev error. >Open file DTAWEB error. > [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic files, big transactions
UniVerse's CONFIGURE.FILE does nothing apart from update the file header. You need RESIZE filename * * * USING directorypath to actually effect an immediate change. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Anyone AIX 5.3 with UV 9.6 Upgrade C/C++ runtime to V8.0.0.4 ?
Garry The O/S C compiler is used by UniVerse (and UniData) if you are compiling and linking C functions into UniVerse for use via the GCI from UniBASIC (or UniData via CALLC). All current versions of UniData and UniVerse have references in the documentation to the Compiler version used for to build the database. Check the usual release note files Beyond this, there may be other reasons for specifying a specific compiler associated with your software vendor's application and usage - on that question I will pass. (just to throw one in the pot : compiler bug fixes?) Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 March 2007 19:39 To: u2-users@listserver.u2ug.org Subject: [U2] Anyone AIX 5.3 with UV 9.6 Upgrade C/C++ runtime to V8.0.0.4 ? We are getting ready to upgrade our system to AIX 5.3 plus add memory and disk. However one of our software vendors (Evault) is telling us we need to upgrade the IBM XL C/C++ Enterprise Edition to V8.0 for AIX runtime enbironment with a minimum patch level of 8.0.0.4. Is anyone aware of any problems with running UV 9.6 on the V8.0.0.4 C/C++ ? Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 --- 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: Spam:Re: [U2] Dynamic files, big transactions
Jerry, Observe: In the example below, you will note that CONFIGURE.FILE has no effect on the physical size of the ALPHA file, and the size is defined by the current modulus. The modulus can be computed from the size of a dynamic file using modulus = (totalbytes - 2048)/2048, which will yield "23" for the BETA file size. To double check that there was not some sort of sparse creation algorithm involved, I added 3 small records to the "modulus 23" ALPHA file, and found that they all appeared in the same group. ANALYZE.FILE will give you the true modulus (see below). In the case of ALPHA, deleting records will not contract the file unless the current modulus is greater than 23. These examples are on a Solaris system. There is a chance that Windows behaves differently. -Rick :CREATE.FILE ALPHA DYNAMIC Creating file "ALPHA" as Type 30. Creating file "D_ALPHA" as Type 3, Modulo 1, Separation 2. Added "@ID", the default record for RetrieVe, to "D_ALPHA". :! ls -l ALPHA total 16 -rw-rw-r-- 1 rick piadm 4096 Mar 9 13:53 DATA.30 -rw-rw-r-- 1 rick piadm 2048 Mar 9 13:53 OVER.30 :CONFIGURE.FILE ALPHA MINIMUM.MODULUS 23 File name = ALPHA Changing Minimum Modulus from 1 to 23. File name = ALPHA configured. :.X2 02 ! ls -l ALPHA total 16 -rw-rw-r-- 1 rick piadm 4096 Mar 9 13:53 DATA.30 -rw-rw-r-- 1 rick piadm 2048 Mar 9 13:53 OVER.30 :CREATE.FILE BETA DYNAMIC MINIMUM.MODULUS 23 Creating file "BETA" as Type 30. Creating file "D_BETA" as Type 3, Modulo 1, Separation 2. Added "@ID", the default record for RetrieVe, to "D_BETA". :! ls -l BETA total 112 -rw-rw-r-- 1 rick piadm 49152 Mar 9 13:54 DATA.30 -rw-rw-r-- 1 rick piadm 2048 Mar 9 13:54 OVER.30 : :ANALYZE.FILE ALPHA File name .. ALPHA Pathname ... ALPHA File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 1 current ( minimum 23 ) Large record size .. 1628 bytes Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 2% (actual) Total size . 6144 bytes On Mar 9, 2007, at 1:14 PM, Jerry wrote: Did you mean that UniVerse doesn't have the CONFIGURE.FILE or what? Because UniVerse has the CONFIGURE.FILE command, the keyword MINIMUM.MODULUS, and it works immediate without using the IMMEDIATE key word. - Original Message - From: "Richard Nuckolls" <[EMAIL PROTECTED]> To: Sent: Friday, March 09, 2007 2:35 PM Subject: Spam:Re: [U2] Dynamic files, big transactions CONFIGURE.FILE MINIMUM.MODULUS ... (in the Prime/PI Open version) would accept a keyword of IMMEDIATE to force the splitting of groups. Universe lacks this option, so you should specify MINIMUM.MODULUS at the time that you create the part file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Colin: I stay away from domains as much as possible; it wrecks havoc on all kinds of software. The two machines (an IIS web server and a UniData dbms server) are on the same "workgroup", have the exact same administrator name and password (when I remote desktop in). "WebDev" is both the share name and the actual name of a directory in "E:" of the IIS Web server. When I open a DOS window on the UD server I can list the remote directory by using either path syntax: C:\Documents and Settings\myuser>dir \\asiolywaweb\webdev (or dir \\asiolywaweb\e$\webdev) Volume in drive \\asiolywaweb\webdev is Web Volume Serial Number is A4D8-DA0E Directory of \\asiolywaweb\webdev 03/04/2007 02:21 AM . 03/04/2007 02:21 AM .. 01/13/2003 01:16 PM 7,109 achdemo.html 03/08/2007 09:09 PM advantos 02/28/2007 12:42 PM advantos.NET 02/28/2007 12:42 PM aspnet_client 02/28/2007 12:41 PM DesignBais 02/28/2007 12:41 PM Logs 03/04/2007 02:21 AM sps 02/28/2007 12:41 PM WebExamples 1 File(s) 7,109 bytes 9 Dir(s) 121,820,229,632 bytes free C:\Documents and Settings\myuser> I modified the "DTAWEB" (VOC) item on the dbms and tried to list the contents. 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: \\AsiOlyWaWeb\E$\WebDev Bottom. 2 Demo (0)-> LIST DTAWEB Open \\AsiOlyWaWeb\E$\WebDev error. Open file DTAWEB error. ...but excluding the "E$" in the path I get a different error from UD. 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: \\AsiOlyWaWeb\WebDev Bottom. 2 Demo (0)-> LIST DTAWEB errno=2: No such file or directory can not stat() in U_get_fileid(),fname=\\AsiOlyWaWeb\WebDev. Open file error. 2 Demo (0)-> I'm thinking there's something obvious I'm missing, maybe a UniAdmin configuration. Or maybe UD runs under different credentials, so there would be permission problems from inside of UD. Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Sharing a network directory Are the UD and web server on the same domain? I haven't been able to get it to work across domains (but I haven't tried really hard yet). It looks like webdev is a share name. Try something like \\asiolywaweb\c$\web\dev (or whatever the path is to the directory). If that doesn't work let us see what !dir \\AsiOlyWaWeb\WebDev gives you. Hth Colin Alfke Calgary Canada >-Original Message- >From: Bill H > >For the life of me I can't seem to get this to work in UniData. I >have... > >:AE VOC DTAWEB >Top of "DTAWEB" in "VOC", 3 lines, 30 characters. >*--: P >001: DIR >002: \\AsiOlyWaWeb\WebDev >003: D_VOC >Bottom. > >From Windows Explorer on the UD server I simply enter >"\\AsiOlyWaWeb\WebDev" >into the address field and I get everything listed from the web server >as I'd expect. But I can't get UniData (v7.1.9) to access the file. >All I get >is: > >:LIST DTAWEB >errno=2: No such file or directory >Open directory file DTAWEB error. >Open file error. --- 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: Spam:Re: [U2] Dynamic files, big transactions
Did you mean that UniVerse doesn't have the CONFIGURE.FILE or what? Because UniVerse has the CONFIGURE.FILE command, the keyword MINIMUM.MODULUS, and it works immediate without using the IMMEDIATE key word. - Original Message - From: "Richard Nuckolls" <[EMAIL PROTECTED]> To: Sent: Friday, March 09, 2007 2:35 PM Subject: Spam:Re: [U2] Dynamic files, big transactions CONFIGURE.FILE MINIMUM.MODULUS ... (in the Prime/PI Open version) would accept a keyword of IMMEDIATE to force the splitting of groups. Universe lacks this option, so you should specify MINIMUM.MODULUS at the time that you create the part file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Anyone AIX 5.3 with UV 9.6 Upgrade C/C++ runtime to V8.0.0.4 ?
We are getting ready to upgrade our system to AIX 5.3 plus add memory and disk. However one of our software vendors (Evault) is telling us we need to upgrade the IBM XL C/C++ Enterprise Edition to V8.0 for AIX runtime enbironment with a minimum patch level of 8.0.0.4. Is anyone aware of any problems with running UV 9.6 on the V8.0.0.4 C/C++ ? Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic files, big transactions
Andre, This seemed very strange, since normally 250 record keys would never hash into the same group of a dynamic file. The exception might be if you created a new part file and then sought to lock and add a large group of records at one time. The "new" dynamic part file would have a modulus of 1, and all of the records that hashed into that file would be locked in the same group until some of them were written, and the file split to a larger modulus. If your algorithm for the Distributed file could cause this situation, then the solution may be to create the new parts with a MINIMUM.MODULUS value large enough to split out the record keys into separate groups (~23? Bigger is better). CONFIGURE.FILE MINIMUM.MODULUS ... (in the Prime/PI Open version) would accept a keyword of IMMEDIATE to force the splitting of groups. Universe lacks this option, so you should specify MINIMUM.MODULUS at the time that you create the part file. -Rick Nuckolls Lynden Inc. On Mar 9, 2007, at 10:39 AM, Andre Meij wrote: Hi, We have a highly technical problem with universe related to the locking tables and their configuration: We have a big application running on Universe 10.1 (Solaris). This application is build on Distributed Dynamic files. Some of the keys are auto numbers; others are supplied by external systems. With our current settings we can have a maximum of 250 locks in one group; this means most certainly for auto numbers we can only lock records 1000 to 1249 without getting an abort and a rollback because a new lock cannot be acquired. This 250th lock cannot be acquired because all these locks fall within the same lock group which is limited to 250 locks. I know of 2 uvconfig parameters that define this locking behavior however the maximum settings of these settings are limited by the maximum size of the shared memory segment. # GLTABSZ - sets the number of group lock entries GLTABSZ 250 # RLTABSZ - sets the number of read lock entries RLTABSZ 250 Our testing indicated that these numbers cannot be raised any higher (due to the shared memory limit). This all means that I cannot lock more than 250 records in one transaction; this is unfortunately not always enough, we occasionally have to implement some extensive tricks to circumvent this. I very much would like to see this resolved on a Universe level so that the programmers can stop worrying about this. Anyone who has experience or knows of someone with experience, please help :-). Maybe you have knowledge of this problem yourself or know of somebody within IBM who could help us resolve this. Regards, Andre Meij Innovate-IT --- 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] Dynamic files, big transactions
Hi Andre It is hard to suggest a best approach without understanding your application. Usually if you are going to lock 250 records at the same time in the same file, you should be considering escalating to locking the File. This is a bigger problem for RDBMS, which is why they prefer optimistic locking to pessimistic locking. If File Locking is not acceptable, you should consider moving to an optimistic model. With Large number of records being locked, you could be increasing youre chances of deadlock situations as well. Regards David Jordan > > With our current settings we can have a maximum of 250 locks in one group; > this means most certainly for auto numbers we can only lock records 1000 > to > 1249 without getting an abort and a rollback because a new lock cannot be > acquired. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Old Dog, New Tricks
You can always test, IF TEMP = '' THEN TEMP = "NULL" and likewise on the end that processes after the ARRAY is completed. 1~2~NULL~4~5~NULL~... on the receiving end would be IF ARRAY = "NULL" THEN ARRAY = "" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bjorn Behr Sent: Friday, March 09, 2007 00:48 To: u2-users@listserver.u2ug.org Subject: [U2] Old Dog, New Tricks The only problem with using <-1> is that it the value is null, it does not append it. This could cause problems, esp. when doing this with dependant rows. Program Example: 001 ARRAY = "" 002 FOR J = 1 TO 10 003IF (NOT(MOD(J,5))) THEN 004 TEMP = "" 005END ELSE 006 TEMP = J 007END 008ARRAY<-1> = TEMP 009 NEXT J 010 CRT ARRAY Result: 1~2~3~4~6~7~8~9~ Regards Bjorn Behr --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] DBF file parser in UV Basic?
Thanks everyone for the great ideas and suggestions!! Jerry, The 'DOWNLOAD' program is a great tool, but looks oriented for output (only) from UV. Colin & Manu, the command line file converters from DBF to TXT is also a great idea. This may be a quick way to get those parsed. Barry, thanks for Don's contact info. -Troy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Dynamic files, big transactions
Hi, We have a highly technical problem with universe related to the locking tables and their configuration: We have a big application running on Universe 10.1 (Solaris). This application is build on Distributed Dynamic files. Some of the keys are auto numbers; others are supplied by external systems. With our current settings we can have a maximum of 250 locks in one group; this means most certainly for auto numbers we can only lock records 1000 to 1249 without getting an abort and a rollback because a new lock cannot be acquired. This 250th lock cannot be acquired because all these locks fall within the same lock group which is limited to 250 locks. I know of 2 uvconfig parameters that define this locking behavior however the maximum settings of these settings are limited by the maximum size of the shared memory segment. # GLTABSZ - sets the number of group lock entries GLTABSZ 250 # RLTABSZ - sets the number of read lock entries RLTABSZ 250 Our testing indicated that these numbers cannot be raised any higher (due to the shared memory limit). This all means that I cannot lock more than 250 records in one transaction; this is unfortunately not always enough, we occasionally have to implement some extensive tricks to circumvent this. I very much would like to see this resolved on a Universe level so that the programmers can stop worrying about this. Anyone who has experience or knows of someone with experience, please help :-). Maybe you have knowledge of this problem yourself or know of somebody within IBM who could help us resolve this. Regards, Andre Meij Innovate-IT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Spam:RE: [U2] [UV] DBF file parser in UV Basic?
Does Cedarville's DOWNLOAD do this? http://www.cedarville.edu/departments/compserv/ftp.htm - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, March 09, 2007 8:10 AM Subject: Spam:RE: [U2] [UV] DBF file parser in UV Basic? You're probably better off using one of the many "converter" tools to convert the files to text and then import. That's all I do. There's lots of free DBF viewers, just pick one you like. Sorry, It's been about 1.5 years since the last one I did and I don't remember which one I used. Hth Colin Alfke Calgary Canada -Original Message- From: Buss, Troy (Logitek Systems) I may need to parse out several DBF files for import and processing in Universe10.0 (Windows Server version). Does anyone already have a generic Universe Basic program they would care to share that will parse out the DBF file format particularly compatible with visual foxpro? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Are the UD and web server on the same domain? I haven't been able to get it to work across domains (but I haven't tried really hard yet). It looks like webdev is a share name. Try something like \\asiolywaweb\c$\web\dev (or whatever the path is to the directory). If that doesn't work let us see what !dir \\AsiOlyWaWeb\WebDev gives you. Hth Colin Alfke Calgary Canada >-Original Message- >From: Bill H > >For the life of me I can't seem to get this to work in >UniData. I have... > >:AE VOC DTAWEB >Top of "DTAWEB" in "VOC", 3 lines, 30 characters. >*--: P >001: DIR >002: \\AsiOlyWaWeb\WebDev >003: D_VOC >Bottom. > >From Windows Explorer on the UD server I simply enter >"\\AsiOlyWaWeb\WebDev" >into the address field and I get everything listed from the >web server as I'd expect. But I can't get UniData (v7.1.9) to >access the file. All I get >is: > >:LIST DTAWEB >errno=2: No such file or directory >Open directory file DTAWEB error. >Open file error. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Old Dog, New Tricks
I've run into many sets of dissyncronized mv values because of this. Thus, my brain now forces me to do a DCOUNT of the independent attribute to get the current number of values and increment from there. I've even seen this code X<1,-1>=CHAR(253):"FRED" that really screwed things up. No excuse for using a delimiter when delimiters are implied. My 1 cent Mark Johnson - Original Message - From: "Bjorn Behr" <[EMAIL PROTECTED]> To: Sent: Friday, March 09, 2007 3:47 AM Subject: [U2] Old Dog, New Tricks > The only problem with using <-1> is that it the value is null, it does not > append it. This could cause problems, esp. when doing this with dependant > rows. > > Program Example: > 001 ARRAY = "" > 002 FOR J = 1 TO 10 > 003IF (NOT(MOD(J,5))) THEN > 004 TEMP = "" > 005END ELSE > 006 TEMP = J > 007END > 008ARRAY<-1> = TEMP > 009 NEXT J > 010 CRT ARRAY > > Result: > 1~2~3~4~6~7~8~9~ > > Regards > Bjorn Behr > --- > 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] old dog, new tricks
Is the internal methods behind REMOVE the same as EXTRACT (or <>). Again, about a year ago, I had an issue with an attributed xref rec of the invoices for a customer that had grown to almost 150,000 invoices. The original programmer used <> with a counter and it took very long to 'age' that cust on an inquiry screen. (don't solve my A/R problems). This was on a D3 box. So I utilized the REMOVE command and it went from around 3 minutes to around 15 seconds. BTW. To use REMOVE on D3, you need the OPTION $EXT command earlier. I'm gonna try your LEN vs #"" to see if that makes sense. As an experienced programmer though, I would have to see if it really matters on regular small values instead of these monster values. I've used #"" a zillion times. Thanks Mark johnson - Original Message - From: "Stevenson, Charles" <[EMAIL PROTECTED]> To: Sent: Friday, March 09, 2007 1:48 AM Subject: RE: [U2] old dog, new tricks > To add to Adrian's explanation, when a string is in memory, the first > few bytes at that string's address is not actual data, but metadata > about the string, including its length, so UV immediately knows where > the string ends (& where the next string begins). > Therefore <-1> can make an immediate jump, rather than searching through > the string counting attributes. > > This also implies that something like > IF LEN( X ) THEN > is faster than something like > IF (X # '') THEN > . > > You can also see why & aren't particularly fast, since > they aren't at the end of the srting. > > UV keeps similar metadata up front about the last attribute accessed, & > the remove pointer. That is what makes both REMOVE/REVREMOVE and > EXTRACTs of sequential s so fast. > > cds > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] DBF file parser in UV Basic?
You're probably better off using one of the many "converter" tools to convert the files to text and then import. That's all I do. There's lots of free DBF viewers, just pick one you like. Sorry, It's been about 1.5 years since the last one I did and I don't remember which one I used. Hth Colin Alfke Calgary Canada >-Original Message- >From: Buss, Troy (Logitek Systems) > >I may need to parse out several DBF files for import and >processing in Universe10.0 (Windows Server version). > >Does anyone already have a generic Universe Basic program they >would care to share that will parse out the DBF file format >particularly compatible with visual foxpro? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] old dog, new tricks
raise() & lower() are your friends -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: March 8, 2007 9:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] old dog, new tricks Also, I think UV is optimized for AMs vs VMs, so that it pays to CONVERT @VM TO @AM IN XXX, do your thing, then CONVERT @VM TO @AM IN XXX back when done if you need VMs. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Old Dog, New Tricks
In UniVerse, $OPTIONS EXTRA.DELIM > - Original Message - > From: "Bjorn Behr" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: [U2] Old Dog, New Tricks > Date: Fri, 9 Mar 2007 10:47:32 +0200 > > > The only problem with using <-1> is that it the value is null, it does not > append it. This could cause problems, esp. when doing this with dependant > rows. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] DBF file parser in UV Basic?
We have actually written a callable subroutine that will do just this. The only problem is, the dbf has to be a FoxPro 2.6 dbf. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Thursday, March 08, 2007 8:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] DBF file parser in UV Basic? I may need to parse out several DBF files for import and processing in Universe10.0 (Windows Server version). Does anyone already have a generic Universe Basic program they would care to share that will parse out the DBF file format particularly compatible with visual foxpro? Here is a specification: http://www.dbf2002.com/dbf-file-format.html http://www.dbase.com/knowledgebase/int/db7_file_fmt.htm Thanks! -Troy --- 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: Spam:RE: [U2] [UV] DBF file parser in UV Basic?
We received a very nice solution care of Don Verhagen. You might want to reach out to him ... Donald Verhagen ([EMAIL PROTECTED]) Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: Friday, March 09, 2007 7:40 AM To: u2-users@listserver.u2ug.org Subject: Spam:RE: [U2] [UV] DBF file parser in UV Basic? I "think" you can open the DBF file with Excel and then save as tab-delimited Text file. Then you can read easily in UV. Assuming your file isn't too big. Mark -- "Buss, Troy \(Logitek Systems\)" <[EMAIL PROTECTED]> wrote: I may need to parse out several DBF files for import and processing in Universe10.0 (Windows Server version). Does anyone already have a generic Universe Basic program they would care to share that will parse out the DBF file format particularly compatible with visual foxpro? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] DBF file parser in UV Basic?
I "think" you can open the DBF file with Excel and then save as tab-delimited Text file. Then you can read easily in UV. Assuming your file isn't too big. Mark -- "Buss, Troy \(Logitek Systems\)" <[EMAIL PROTECTED]> wrote: I may need to parse out several DBF files for import and processing in Universe10.0 (Windows Server version). Does anyone already have a generic Universe Basic program they would care to share that will parse out the DBF file format particularly compatible with visual foxpro? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Old Dog, New Tricks
The only problem with using <-1> is that it the value is null, it does not append it. This could cause problems, esp. when doing this with dependant rows. Program Example: 001 ARRAY = "" 002 FOR J = 1 TO 10 003IF (NOT(MOD(J,5))) THEN 004 TEMP = "" 005END ELSE 006 TEMP = J 007END 008ARRAY<-1> = TEMP 009 NEXT J 010 CRT ARRAY Result: 1~2~3~4~6~7~8~9~ Regards Bjorn Behr --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] DBF file parser in UV Basic?
Hi, I don't have a univere basic, but I have a little prog.exe to convert dbf to txt with commande line automation (dbf > txt AND txt > dbf) very easy to use. Send me a private mail, I'm ready to share it. [EMAIL PROTECTED] I hope this help. Manu- Original Message - From: "Buss, Troy (Logitek Systems)" <[EMAIL PROTECTED]> To: Sent: Friday, March 09, 2007 2:07 AM Subject: [U2] [UV] DBF file parser in UV Basic? I may need to parse out several DBF files for import and processing in Universe10.0 (Windows Server version). Does anyone already have a generic Universe Basic program they would care to share that will parse out the DBF file format particularly compatible with visual foxpro? Here is a specification: http://www.dbf2002.com/dbf-file-format.html http://www.dbase.com/knowledgebase/int/db7_file_fmt.htm Thanks! -Troy --- 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/
