RE: [U2] How do you find out about file operation within an index?
Hi Phil, Thanks again. Here's the trigger code. Not sure what you meant by 'log' file. MY.TRIGGER 0001 SUBROUTINE MY.TRIGGER( TRIGGER.NAME, SCHEMA, FILE, EVENT, TIME, NEWREC.ID, NEWREC, OLDREC.ID, OLDREC, ASSOC, ASSOC.EVENT, COUNT, CHAIN, CASCADE ) 0002 ** 0003 * define a trigger for testing reasons 0004 * 0005 ** 0006 $INCLUDE SYINCLUDE COMMON 0007 COMMON/SQLTRIG/ AUDITFV 0008 * 0009 NEWREC<2> = "OK" 0010 RETURN Here's the executing program. 0001 PROGRAM TEST.TRIG 0002 * 0003 $INCLUDE SYINCLUDE COMMON 0004 * 0005 OPEN '','JUNK.TRIG' TO JUNK.TRIG ELSE STOP 201, 'JUNK.TRIG' 0006 * 0007 RECORD = "5" 0008 ID = "1" 0009 * 0010 CRT OCONV( TIME(), "MTHS" ) 0011 START.TIME = TIME() 0012 FOR X = 1 TO 5000 0013 IF NOT(MOD(X, 1000)) THEN CRT X 0014 WRITE RECORD TO JUNK.TRIG,ID 0015 NEXT X 0016 END.TIME = TIME() 0017 CRT OCONV( TIME(), "MTHS" ) 0018 * 0019 DIFF = END.TIME - START.TIME 0020 PRINT "DIFF: ":OCONV( DIFF, "MTS" ) 0021 * 0022 RETURN Results. Without Trigger >RUN BP TEST.TRIG 05:00:24pm 1000 2000 3000 4000 5000 05:00:24pm DIFF: 00:00:00 With Trigger >RUN BP TEST.TRIG 05:02:07pm 1000 2000 3000 4000 5000 05:02:34pm DIFF: 00:00:27 Comments welcomed :) Regards, Jeff Marcos This e-mail is for the use of the intended recipient(s) only. If you have received in error, please notify the sender immediately and delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. Corporate Express checks all outgoing mail and accepts no liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent: Thursday, 11 May 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you find out about file operation within an index? Jeff, I cannot see how you can do it any quicker? The only thing you could hope for is that IBM look at how they call they trigger subroutine, (while they are fixing the issue with the debugger - my personal battle...:-) ), as whatever basic code you come up with to capture the information will be the same as what you put in the trigger. The advantage of the trigger is that you are assured that it will be executed Maybe you can check your code to see how efficient it is in doing writes. Hopefully it is only doing the write once, and not repeatedly doing the writes or writevs. as this will indeed cause the trigger to fire more than once. The other thing to do with the trigger code is to open the 'log' file variable into common, and be very efficient in what you are doing... Do not take this as a criticism of your code, as without seeing it, noone could say. But as the code is going to be called every time the database does a write or a delete then it needs to be efficient. Cheers, Phil. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Marcos Sent: Thursday, 11 May 2006 12:31 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you find out about file operation within an index? Thanks for the feed back Phil, but triggers are too slow. We ran a very simple test and found with triggers, it took 27 seconds to update 5000 records. Without a trigger it took < 1 second... Regards, Jeff Marcos This e-mail is for the use of the intended recipient(s) only. If you have received in error, please notify the sender immediately and delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. Corporate Express checks all outgoing mail and accepts no liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAI
RE: [U2] How do you find out about file operation within an index?
Jeff, TEST.TRIG isn't doing very much, it's writing the same few bytes into the same bit of memory every time. What happens if you (re)size JUNK.TRIG to have a modulus of 5000 and change "ID" on line 14 of TEST.TRIG to "X". It won't make the trigger run any faster, but it will make TEST.TRIG do a little more work so *maybe* the trigger overhead will reduce as a proportion of the whole. my 2 cents Piers --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Mark M Novak/MN/USB is out of the office.
I will be out of the office starting 05/11/2006 and will not return until 05/15/2006. I will respond to your message when I return. -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] unirpc daemon, stopping and re-starting it from cron
We've had similar issues and found that it isn't a UniVerse issue. It was processes using UniRPC connections (InterCall, UniObjects, UniCall/OBDC, etc.) still being active during the shutdown. These processes keep their socket connections open. This can prevent UniRPC from starting back up. The problem sounds like that you may have a process(es) using UniRPC when you shutdown UniVerse. If this is the case, under Sun Solaris and UV 9.1.4 we would see processes still using UniRPC go into "FIN_WAIT_2" state for their still open TCP socket connection. If that was the case, we could guarantee that the UVRPC daemon (has it was called before UV 9.5.x) wouldn't start back up. Once those TCP connections cleared (went "away"), it was okay to start back up...sometimes it took awhile to clear though. Check what connections you have active, by issusing a: $ netstat -a | grep uvrpc *.uvrpc *.*0 0 49152 0 LISTEN If nothing is connected, you're safe to shutdown (like the above example). If you got processed connect - it may be bad. Strangely, under UV 10.1.12 and Solaris 9, we can now happily stop UV and start it up again...UniRPC *seems* to come backup -- even if processes are connected with open sockets. Could be wrong or just plain lucky, of course. We deal with this situation by adding to the uv.rc script, our own "uv_kill_processes" script which looks for UV processes and the shared memory segments. It loops until all are UV processes are killed (up to 4 attempts). This also deals with the UV shutdown process "aborting" if shared memory segments aren't released. Hopefully, this should help you out in some way. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Wednesday, May 10, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] unirpc daemon, stopping and re-starting it from cron Hello, We have a cron job which does the following: 1- Uses Universe's uv.rc script to stop Universe and unirpc daemon 2- Make a backup of the Production account into a different filesystem on the production machine. 3- Restart Universe & unirps using the uv.rc script 4- Start the backup to tape of the copy of the production environment. When Universe is re-started along with the unirpc daemon within the cron job, Universe works but the unirpc daemon doesn't work correctly. It must be stopped manually from the uv menu and re-started. Has anyone here encountered a similar problem ? I've tried to get support help from IBM but I get the run-around. I'm told that IBM won't debug my companies script even though I've repeatedly told them that the script we are using the uv.rc script that was written by IBM. We are running Universe 10.1.8 on a HP.UX 11i machine. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Nilsson Veness is out of the office.
I will be out of the office starting 08/05/2006 and will not return until 15/05/2006. I will respond to your message when I return. This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Fw: [U2] Unidata logging of BASIC Runtime errors
Craig Bennett wrote: Wally, Collect your thoughts and funnel them thru the U2UG Better and Better committee... That is likely a better way than flooding this list. Just my recommendation. As a UV user I don't mind what happens to UniData; but wouldn't it be great if UV and UD logged to syslog (every platform except windows) or the windows error logs? All of a sudden monitoring U2 errors is just like any other installed program -- sysadmins feel good, logs get rotated and archived in a standard way. And everyone knows where to look even if they haven't read a U2 manual. Surely this couldn't be that much harder than implementing your own logging system? For bonus points expose the system logging functionality into U2 itself so that application writers can also write to the system logs where this is appropriate. I checked to see if the error messages were being sent to stderr very early in my 'exploration'. They're not. My initial reaction was "why not?" We're going to use como with any program that touches GL. It's overkill, but the SOX auditors don't seem to live in the real world anyway. Thanks for all the suggestions and responses. -- Dave --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Turn off account creation
I did know this. The problem with the UV.FLAVOR solution is that the message and user prompt are STILL displayed - the request was to NOT have the message and prompt displayed. Setting UV.FLAVOR to N (cannot create accounts) only comes into play once you've answered 'y' to the "Would you like to set it up (Y/N)" question, at which point you get the "You are not allowed to create uniVerse accounts" message. My take on the request was to entirely remove the message and prompt, basically making uv a no-op if the directory was not an existing uniVerse account. However, re-reading the request I do see "'...or disallow the "y" answer', which the UV.FLAVOR solution would solve. Guess there are a few ways (as always!) to resolve this! =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= "Happiness comes through doors you didn't even know you left open." - Anonymous Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct "phil walker" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/10/2006 05:12 PM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] UV Turn off account creation Glenn, I am surprised you don't know this but you can put an entry in UV.FLAVOR. I cannot remember the exact details but if you search in the documentation for UV.FLAVOR it will tell you. Cheers, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Thursday, 11 May 2006 9:01 a.m. To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; User group U2 Subject: Re: [U2] UV Turn off account creation [EMAIL PROTECTED] wrote on 05/10/2006 03:55:01 PM: > Hi All: > > > > We are running UniVerse 10.1.11 on an AIX 5.2.3 system. > > Does anyone know how to turn off the ability to create on the fly UniVerse > Accounts? > > I want to turn the message shown below or disallow the "y" answer. > This functionality is embedded within the startup process of uniVerse, so there really isn't any switch or configuration you can set to disable that. What I have seen done is to copy uv to uv_real (or a name you prefer), then write a new "uv" wrapper that looks to see if a "VOC" file exists in the current directory - if one exists, then exec uv_real, otherwise just exit out. Make certain to set execute permissions for everyone on this wrapper. Note that this only solves the "uv" problem; if someone types "uvsh" (or for that matter "uv_real"!) they will experience the same issue, but I don't recall if universe will still work if you wrapper uvsh. Been a while since I've worked with the environment. Good luck. --- 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] Unidata logging of BASIC Runtime errors
How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384 Split/Merge type = KEYDATA Grp# Bytes Records 0 770 1> 1 1158318>> 2 0 0 3 1210922>> 4 0 0 5 964717> 6 0 0 7 1221520 8 0 0 9 1033819>>> 10 0 0 11 1077619>>> 12 0 0 13 1028118>> 14 0 0 15 1047119>>> 16 0 0 17 1211522>> 18 0 0 19 1081219>>> I have experimented with blocksize, KEYONLY, HASHTYPE of 1 and this was the best I could do. I am sure that if I brought this file over to Universe, I could find an algorithm that could handle this compound key a lot better. If you need sample data for files that don't hash well, I have some good examples besides this one. The developers seem to love intelligent keys, and sometimes what they come up with does not hash worth a damn. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Wednesday, May 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: Fw: [U2] Unidata logging of BASIC Runtime errors So - we are starting our planning cycle for the next release of UniData now. Is this something that there is a ground-swell of support for? If so - what would it look like? All or nothing switch? UDT.OPTIONS? udtconfig setting? environment variable? All users? Just selected users? New log name - eg unibasic.errlog vs udt.errlog? Some limit to the number logged before shutting it off? (concern about log size and filling disk?) ALL UniBasic run-time errors or warnings logged - regardless of fatality? Just some class of errors? Is so - how would you define the ones you want logged? Collect your thoughts and funnel them thru the U2UG Better and Better committee... That is likely a better way than flooding this list. Just my recommendation. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 05/10/2006 05:27 PM - "Bill Haskett" <[EMAIL PROTECTED] os.net>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata logging of BASIC 05/10/2006 04:07 Runtime errors PM Please respond to [EMAIL PROTECTED] er.u2ug.org Dave: UniData does not have logging for BASIC runtime errors (IBM got back with me on this). There aren't enough requests for this feature to include it in UniData. :-( Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of pic00485.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] unirpc daemon, stopping and re-starting it from cron
Hmmm...I just realized... Had the same type of issue with UV 9.6 on AIX 5.2 so we had a similar kill process, often telnet connections would not release especially if the user had shelled out to perform a process (most notably to go to SMIT), along with samba sessions...the spooler would also be stopped. Then uv.rc would be executed to restart universe, and the spooler restarted If the shutdown was performed out-of-sync it would at times result in a memory segment error and the shutdown and system up process would have to be executed over. (this was fun cross-eyed at 3AM) If you aren't doing so already, I would suggest capturing all cron errors to a log file you can easily review -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hona, David S Sent: Thursday, May 11, 2006 5:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] unirpc daemon, stopping and re-starting it from cron We've had similar issues and found that it isn't a UniVerse issue. It was processes using UniRPC connections (InterCall, UniObjects, UniCall/OBDC, etc.) still being active during the shutdown. These processes keep their socket connections open. This can prevent UniRPC from starting back up. The problem sounds like that you may have a process(es) using UniRPC when you shutdown UniVerse. If this is the case, under Sun Solaris and UV 9.1.4 we would see processes still using UniRPC go into "FIN_WAIT_2" state for their still open TCP socket connection. If that was the case, we could guarantee that the UVRPC daemon (has it was called before UV 9.5.x) wouldn't start back up. Once those TCP connections cleared (went "away"), it was okay to start back up...sometimes it took awhile to clear though. Check what connections you have active, by issusing a: $ netstat -a | grep uvrpc *.uvrpc *.*0 0 49152 0 LISTEN If nothing is connected, you're safe to shutdown (like the above example). If you got processed connect - it may be bad. Strangely, under UV 10.1.12 and Solaris 9, we can now happily stop UV and start it up again...UniRPC *seems* to come backup -- even if processes are connected with open sockets. Could be wrong or just plain lucky, of course. We deal with this situation by adding to the uv.rc script, our own "uv_kill_processes" script which looks for UV processes and the shared memory segments. It loops until all are UV processes are killed (up to 4 attempts). This also deals with the UV shutdown process "aborting" if shared memory segments aren't released. Hopefully, this should help you out in some way. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Wednesday, May 10, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] unirpc daemon, stopping and re-starting it from cron Hello, We have a cron job which does the following: 1- Uses Universe's uv.rc script to stop Universe and unirpc daemon 2- Make a backup of the Production account into a different filesystem on the production machine. 3- Restart Universe & unirps using the uv.rc script 4- Start the backup to tape of the copy of the production environment. When Universe is re-started along with the unirpc daemon within the cron job, Universe works but the unirpc daemon doesn't work correctly. It must be stopped manually from the uv menu and re-started. Has anyone here encountered a similar problem ? I've tried to get support help from IBM but I get the run-around. I'm told that IBM won't debug my companies script even though I've repeatedly told them that the script we are using the uv.rc script that was written by IBM. We are running Universe 10.1.8 on a HP.UX 11i machine. --- 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] Linked server fails when using Analysis services
I'm trying to build a cube in Analysis services in MS SQL. I've setup my data source to the local database and I'm choosing a view that uses an openquery to Unidata. The view works without issues, I can browse my data inside the analysis services, but when I try to actually process the cube I get this error. Data source provider error: Cannot get the column information from OLE DB provider "IBM.UniOLEDB" for linked server "M2K".;42000;The OLE DB provider "IBM.UniOLEDB" for linked server "M2K" reported an error. Access denied.;42000; Time:5/11/2006 10:34:05 AM I'm guessing that there is a setting I can add to the linked server to allow the column information being read? I don't want to take the time to pull the data into a table in SQL since it is a load of data and isn't necessary to archive in SQL. Can't I just use the linked server with a view and build my cube? For my test I'm only pulling the top 9 rows so it's not like it's timing out or anything. Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] VB6 UniObjects to VB.NET question
Greetings, all. I am converting some VB6 code with UniObjects to VB.NET (2005). The following snippet is not working on .NET. I've search the list archives and am still not understanding the issue. objDynAry = objFILE.Record objDynAry.Field(3).StringValue = CStr(Now) objFILE.Record = objDynAry The third statement is the one that works on VB6 but take the On Error routine in .NET. Can someone explain to me what the problem is? (Yes, I could code around this, but this kind of thing is done a lot in this code--not my code, BTW ☺ Thanks for any insight. -- Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
Have you tried undersizing the file to force data into the other groups? From the sample, it looks as if your groups with data are not overflowing and consequently, the file may be oversized. Of course I am not looking at the entire stats so I could be off base. At 09:07 AM 5/11/2006, Baakkonen, Rodney A (Rod) 46K wrote: How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] VB6 UniObjects to VB.NET question
Clif, I suspect that in VB6, the first line transfered the values, but in VB.Net it is transfering the pointer. Here's the difference: ABC = 100^200^300 DEF = ABC DEF<3> = 400 ABC = DEF The above moves the values into DEF (line 2), modifies DEF separately from ABC (line 3) and then updates ABC with the same value as DEF (line 4). This is, I believe how VB6 does it. The other way to read the above is that DEF receives a pointer to ABC (line 2) which makes them share the same spot in memory. We modify the value in ABC and DEF at the same time (line 3) because they are functionally the same variable. You can't perform the '=' (line 4) because you are trying to change the pointer in ABC to itself. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 [EMAIL PROTECTED] wrote: | Greetings, all. | | I am converting some VB6 code with UniObjects to VB.NET (2005). The | following | snippet is not working on .NET. I've search the list archives and am still | not | understanding the issue. | | objDynAry = objFILE.Record | objDynAry.Field(3).StringValue = CStr(Now) | objFILE.Record = objDynAry | | The third statement is the one that works on VB6 but take the On Error | routine | in .NET. | | Can someone explain to me what the problem is? (Yes, I could code around | this, | but this kind of thing is done a lot in this code--not my code, BTW | ☺ | | Thanks for any insight. | | | -- | | Regards, | | Clif | --- | 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] VB6 UniObjects to VB.NET question
Hello I took a quick look at our code. A case like yours would be written objFILE.Record.StringArray = objDynAry.StringArray Since the Record property is a UniDynArray I initially tried to do assignments the way your VB6 code does it, but it didn't work. What error do you get when you try this assignment? I'm assuming you're not using UniObjects.net? I think then you'd need to use the Insert or Replace methods of Record. I'm still a little new to the .net version of UO. I think the syntax would be objFile.Record.Replace(objDynAry.StringValue) This would replace the entire Record with objDynAry Victor St. Clair -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 11, 2006 8:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] VB6 UniObjects to VB.NET question Greetings, all. I am converting some VB6 code with UniObjects to VB.NET (2005). The following snippet is not working on .NET. I've search the list archives and am still not understanding the issue. objDynAry = objFILE.Record objDynAry.Field(3).StringValue = CStr(Now) objFILE.Record = objDynAry The third statement is the one that works on VB6 but take the On Error routine in .NET. Can someone explain to me what the problem is? (Yes, I could code around this, but this kind of thing is done a lot in this code--not my code, BTW ☺ Thanks for any insight. -- Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
I have seen this happen before when the minimum.modulo is too small (usually the original size of the file). As to the "#" delimiter in the key, that will contribute to poor hashing, but I would recommend the first step to be resizing, and resetting the minimum.modulo to the same size as the resize modulo. HTH --- Regards, Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Thursday, May 11, 2006 09:07 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Unidata logging of BASIC Runtime errors How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384 Split/Merge type = KEYDATA Grp# Bytes Records 0 770 1> 1 1158318>> 2 0 0 3 1210922>> 4 0 0 5 964717> 6 0 0 7 1221520 8 0 0 9 1033819>>> 10 0 0 11 1077619>>> 12 0 0 13 1028118>> 14 0 0 15 1047119>>> 16 0 0 17 1211522>> 18 0 0 19 1081219>>> I have experimented with blocksize, KEYONLY, HASHTYPE of 1 and this was the best I could do. I am sure that if I brought this file over to Universe, I could find an algorithm that could handle this compound key a lot better. If you need sample data for files that don't hash well, I have some good examples besides this one. The developers seem to love intelligent keys, and sometimes what they come up with does not hash worth a damn. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Wednesday, May 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: Fw: [U2] Unidata logging of BASIC Runtime errors So - we are starting our planning cycle for the next release of UniData now. Is this something that there is a ground-swell of support for? If so - what would it look like? All or nothing switch? UDT.OPTIONS? udtconfig setting? environment variable? All users? Just selected users? New log name - eg unibasic.errlog vs udt.errlog? Some limit to the number logged before shutting it off? (concern about log size and filling disk?) ALL UniBasic run-time errors or warnings logged - regardless of fatality? Just some class of errors? Is so - how would you define the ones you want logged? Collect your thoughts and funnel them thru the U2UG Better and Better committee... That is likely a better way than flooding this list. Just my recommendation. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 05/10/2006 05:27 PM - "Bill Haskett" <[EMAIL PROTECTED] os.net>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata logging of BASIC 05/10/2006 04:07 Runtime errors PM Please respond to [EMAIL PROTECTED] er.u2ug.org Dave: UniData does not have logging for BASIC runtime errors (IBM got back with me on this). There aren't enough requests for this feature to include it in UniData. :-( Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of pic00485.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- 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] Linked server fails when using Analysis services
I run into the similar situation while using linking Universe server in SQL. Eventually I got it fixed is: 1) check the User account and make sure it has right to read the UniVerse tables. 2) make sure the column name used in UniVerse view is not uniVerse reserved word. If you could view the data from Excel via ODBC, most of time it should work in SQL server. Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, May 11, 2006 10:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Linked server fails when using Analysis services I'm trying to build a cube in Analysis services in MS SQL. I've setup my data source to the local database and I'm choosing a view that uses an openquery to Unidata. The view works without issues, I can browse my data inside the analysis services, but when I try to actually process the cube I get this error. Data source provider error: Cannot get the column information from OLE DB provider "IBM.UniOLEDB" for linked server "M2K".;42000;The OLE DB provider "IBM.UniOLEDB" for linked server "M2K" reported an error. Access denied.;42000; Time:5/11/2006 10:34:05 AM I'm guessing that there is a setting I can add to the linked server to allow the column information being read? I don't want to take the time to pull the data into a table in SQL since it is a load of data and isn't necessary to archive in SQL. Can't I just use the linked server with a view and build my cube? For my test I'm only pulling the top 9 rows so it's not like it's timing out or anything. Jeffrey Lettau ERP Systems Manager polkaudio --- 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: Fw: [U2] Unidata logging of BASIC Runtime errors {Unclassified}
Well, for Windows platforms, you can do something like this (this is from ECL, but with a tiny bit of code...): :! eventcreate /t information /id 999 /l System /so MyModule /d "Error Test" /t = ERROR | WARNING | INFORMATION /id = Event ID /l (lowercase L) = APPLICATION OR SYSTEM /so = SourceName (any text, but most likely it's the offending program name) /d = Description There are many other options (you can even specify a different computer to send the event information to). Regards, Jim [snip] Yes, Yes, YES! CALL OSEventLog(Category, Type, EventID, DescriptionText) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
Some of that is due to the KEYDATA causing splits. And when the records in the group gets rerun through the hashing algorithm using the new modulo, they hash into groups that already have a lot of records in them. And the new groups get nothing. So the hashing algorithm never puts any records into some of these groups. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Doug Miller Sent: Thursday, May 11, 2006 10:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata logging of BASIC Runtime errors Have you tried undersizing the file to force data into the other groups? From the sample, it looks as if your groups with data are not overflowing and consequently, the file may be oversized. Of course I am not looking at the entire stats so I could be off base. At 09:07 AM 5/11/2006, Baakkonen, Rodney A (Rod) 46K wrote: >How about some other hashing algorithms like Universe has. I have some files >that have compound keys, where the separator is a '#' and the hashing is >awful. This is what GROUP.STAT looks like: Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- 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 logging of BASIC Runtime errors
The minimum modulo is not that bad. The current mod is 529447, and the minimum 482029. Primary File Head (dat001): modulo --> 122069 hashtype > 96 version -> 3 blksiz --> 15 (16384) idxinf --> 10 bproof --> 1 multi-over file -> 0 rm --> 255 prt_at --> 192 nullv --> 129 beg_modulo --> 0 file_limit --> 20 Overflow File Head (over001): modulo --> 0 (not used) hashtype > 0 (not used) block size --> 0 (1024) (not used) next_block --> 0 (block 0) block_count -> 0 max_blk_cnt -> 4077 file_logical_end > -2070724608 current_modulo --> 529447 min_modulo --> 482029 split_factor > 95 merge_factor > 40 grp_fre_blk_cnt -> 5 file_limit --> 20 total_free_blk --> 0 p_file_cnt --> 5 o_file_cnt --> 1 Free Block List: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert DunnMiller Sent: Thursday, May 11, 2006 11:42 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] Unidata logging of BASIC Runtime errors I have seen this happen before when the minimum.modulo is too small (usually the original size of the file). As to the "#" delimiter in the key, that will contribute to poor hashing, but I would recommend the first step to be resizing, and resetting the minimum.modulo to the same size as the resize modulo. HTH --- Regards, Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Thursday, May 11, 2006 09:07 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Unidata logging of BASIC Runtime errors How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384 Split/Merge type = KEYDATA Grp# Bytes Records 0 770 1> 1 1158318>> 2 0 0 3 1210922>> 4 0 0 5 964717> 6 0 0 7 1221520 8 0 0 9 1033819>>> 10 0 0 11 1077619>>> 12 0 0 13 1028118>> 14 0 0 15 1047119>>> 16 0 0 17 1211522>> 18 0 0 19 1081219>>> I have experimented with blocksize, KEYONLY, HASHTYPE of 1 and this was the best I could do. I am sure that if I brought this file over to Universe, I could find an algorithm that could handle this compound key a lot better. If you need sample data for files that don't hash well, I have some good examples besides this one. The developers seem to love intelligent keys, and sometimes what they come up with does not hash worth a damn. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Wednesday, May 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: Fw: [U2] Unidata logging of BASIC Runtime errors So - we are starting our planning cycle for the next release of UniData now. Is this something that there is a ground-swell of support for? If so - what would it look like? All or nothing switch? UDT.OPTIONS? udtconfig setting? environment variable? All users? Just selected users? New log name - eg unibasic.errlog vs udt.errlog? Some limit to the number logged before shutting it off? (concern about log size and filling disk?) ALL UniBasic run-time errors or warnings logged - regardless of fatality? Just some class of errors? Is so - how would you define the ones you want logged? Collect your thoughts and funnel them thru the U2UG Better and Better committee... That is likely a better way than flooding this list. Just my recommendation. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 05/10/2006 05:27 PM - "Bill Haskett" <[EMAIL PROTECTED] os.net>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata logging of BASIC 05/10/2006 04:07 Runtime errors PM Please respond to [EMAIL PROTECTED]
Fw: [U2] Unidata logging of BASIC Runtime errors
average record size? standard deviation from average on record size? Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 05/11/2006 03:36 PM - "Baakkonen, Rodney A (Rod) 46K" To com> cc Sent by: [EMAIL PROTECTED] Subject stserver.u2ug.org RE: [U2] Unidata logging of BASIC Runtime errors 05/11/2006 03:16 PM Please respond to [EMAIL PROTECTED] er.u2ug.org The minimum modulo is not that bad. The current mod is 529447, and the minimum 482029. Primary File Head (dat001): modulo --> 122069 hashtype > 96 version -> 3 blksiz --> 15 (16384) idxinf --> 10 bproof --> 1 multi-over file -> 0 rm --> 255 prt_at --> 192 nullv --> 129 beg_modulo --> 0 file_limit --> 20 Overflow File Head (over001): modulo --> 0 (not used) hashtype > 0 (not used) block size --> 0 (1024) (not used) next_block --> 0 (block 0) block_count -> 0 max_blk_cnt -> 4077 file_logical_end > -2070724608 current_modulo --> 529447 min_modulo --> 482029 split_factor > 95 merge_factor > 40 grp_fre_blk_cnt -> 5 file_limit --> 20 total_free_blk --> 0 p_file_cnt --> 5 o_file_cnt --> 1 Free Block List: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert DunnMiller Sent: Thursday, May 11, 2006 11:42 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] Unidata logging of BASIC Runtime errors I have seen this happen before when the minimum.modulo is too small (usually the original size of the file). As to the "#" delimiter in the key, that will contribute to poor hashing, but I would recommend the first step to be resizing, and resetting the minimum.modulo to the same size as the resize modulo. HTH --- Regards, Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Thursday, May 11, 2006 09:07 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Unidata logging of BASIC Runtime errors How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384 Split/Merge type = KEYDATA Grp# Bytes Records 0 770 1> 1 1158318>> 2 0 0 3 1210922>> 4 0 0 5 964717> 6 0 0 7 1221520 8 0 0 9 1033819>>> 10 0 0 11 1077619>>> 12 0 0 13 1028118>> 14 0 0 15 1047119>>> 16 0 0 17 1211522>> 18 0 0 19 1081219>>> I have experimented with blocksize, KEYONLY, HASHTYPE of 1 and this was the best I could do. I am sure that if I brought this file over to Universe, I could find an algorithm that could handle this compound key a lot better. If you need sample data for files that don't hash well, I have some good examples besides this one. The developers seem to love intelligent keys, and sometimes what they come up with does not hash worth a damn. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Wednesday, May 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: Fw: [U2] Unidata logging of BASIC Runtime errors So - we are starting our planning cycle for the next release of UniData now. Is this something that there is a ground-swell of support for? If so - what would it look like? All or nothing switch? UDT.OPTIONS? udtconfig setting? environment variable? All users? Just selected users? New log name - eg unibasic.errlog vs udt.errlog? Some limit to the number logged before shutting it off? (concern about log size and filling disk?) ALL UniBasic run-time errors or warnings logged - regardless of fatality? Just some class of errors? Is so - how would you define the ones you want logged? Collect your thoughts and funnel them thru the U2UG Better and Better comm
RE: [U2] VB6 UniObjects to VB.NET question
>?snippet is not working on .NET. I've search the list archives and am still >not >understanding the issue. >objDynAry = objFILE.Record >objDynAry.Field(3).StringValue = CStr(Now) >objFILE.Record = objDynAry VB6 will work out the default property of an object. .Net does not accept default properties, you have to define the property. I suspect this should be something like objFILE.Record = obj.DynAry.ToString Regards David Jordan Managing Consultant [EMAIL PROTECTED] DACONO Holdings Pty Ltd www.dacono.com.au PO Box 909 Lane Cove NSW 2066 Australia I am converting some VB6 code with UniObjects to VB.NET (2005). The following The third statement is the one that works on VB6 but take the On Error routine in .NET. Can someone explain to me what the problem is? (Yes, I could code around this, but this kind of thing is done a lot in this code--not my code, BTW ☺ Thanks for any insight. -- Regards, Clif --- 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: Fw: [U2] Unidata logging of BASIC Runtime errors {Unclassified}
Thanks, Jim
That's brilliant ... Except it doesn't work in Transaction State because
you can't do a "DOS /c ...", you get a 'Verb "DOS" illegal when a
transaction is active' error. Darn, it would have been really useful
otherwise.
That's why we need a UV-supported method.
But actually, if you're on UV 10.1 you can use the new GCI function
"UVRunCommand" [see Issue Number 5616 in the Release Notes] even in
transaction State.
Gee, another reason to upgrade! :-)
Mike
> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of
> James Canale, Jr.
> Sent: Friday, 12 May 2006 05:28
> To: u2-users@listserver.u2ug.org
> Subject: RE: Fw: [U2] Unidata logging of BASIC Runtime errors
{Unclassified}
>
> Well, for Windows platforms, you can do something like this
> (this is from ECL, but with a tiny bit of code...):
>
> :! eventcreate /t information /id 999 /l System /so MyModule /d
"Error Test"
>
> /t = ERROR | WARNING | INFORMATION
> /id = Event ID
> /l (lowercase L) = APPLICATION OR SYSTEM /so = SourceName
> (any text, but most likely it's the offending program name)
> /d = Description
>
> There are many other options (you can even specify a
> different computer to send the event information to).
>
> Regards,
>
> Jim
>
>
> [snip]
>
> Yes, Yes, YES!
> CALL OSEventLog(Category, Type, EventID, DescriptionText)
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: Fw: [U2] Unidata logging of BASIC Runtime errors {Unclassified}
Mike, But actually, if you're on UV 10.1 you can use the new GCI function "UVRunCommand" [see Issue Number 5616 in the Release Notes] even in transaction State. Gee, another reason to upgrade! :-) Or you could call the windows api functions directly from GCI. I'd find you the reference in O'Reilly but my Safari tokens for the month are all used up. Either way if its trivial using GCI it can't be that hard to build into U2 itself. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] xls to text
> Does anyone know where I can get FREE software that will convert Excel > files to text files in command line mode ? Rudy, None that I know of but I do have experience with the jakarta poi library from apache. I have only used it to create spreadsheets but it also supports reading them. You would need to cobble together a java prog that read the spreadsheet and spat out what you want but based on my experience with the library it shouldn't be too hard. Not quite what you wanted but if you can't find anything else... As it is java you could run it on pretty much any platform as well. Regards, Adrian How about trying openoffice.org? I'm not sure if it has commandline options, but it does everything else... > > Thx, > > > > Rudy > > > > > > Rudy Cooper > > > > Technical Project Lead > > Sage Publications > > Information Technology Development > (805) 410-7724 > > [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\<._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- 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] How do you find out about file operation within an index?
>I'm wondering if there is a way to identify, within a file index, what >type of file operation has occurred. Hello, Jeff. Listed below is a program that uses the index like a trigger. It can only detect WRITE and DELETE statements though. I used this approach with PI and PI/open as they never supported triggers (unless one considered the AKUFS a trigger). I have not tried this approach on UniVerse so I can not speak to its performance, however, I suspect it will work reasonably well. If you do give it a try, please let me know your results. Ask me questions about what it is doing if things are unclear. I published an article in Infocus and an NPUG proceedings that describes the algorithm in detail but I do not have that in electronic form. :-( Best regards, Gyle ** SUBROUTINE BUILD.POD.INDEX(result) * This program projects a nested Purchase Order into a normalized form suitable for reporting purposes. $INCLUDE PO.EQUATE.INS.IBAS $INCLUDE POD.EQUATE.INS.IBAS DIM temporary.pod.record(2000) DIM purchase.order.record(100) EQUATE TRUE TO 1 EQUATE FALSE TO 0 EQUATE ADD TO 1 EQUATE DELETING TO 2 EQUATE UPDATE.FIRST.CALL TO 3 EQUATE UPDATE.SECOND.CALL TO 4 EQUATE NEEDLESS.WRITE.PERFORMED TO 5 EQUATE BUILDING.INDEX TO 6 COMMON /PO.POD/ Po.File.Variable, Pod.File.Variable, Last.Updated.Id, Last.Mode, Last.Added.Id, Build.Time result = "" IF NOT(FILEINFO(Po.File.Variable, 0)) THEN OPEN "", "PO" TO Po.File.Variable ELSE PRINT PRINT "Unable to open the PO file! (BUILD.POD.INDEX)" RETURN END Last.Updated.Id = "" Last.Added.Id = "" Last.Mode = "" Build.Time = 0 END IF NOT(FILEINFO(Pod.File.Variable, 0)) THEN OPEN "", "POD" TO Pod.File.Variable ELSE PRINT PRINT "Unable to open the POD file! (BUILD.POD.INDEX)" RETURN END Last.Updated.Id = "" Last.Added.Id = "" Last.Mode = "" Build.Time = 0 END IF @SENTENCE[1, 11] = "BUILD.INDEX" THEN Last.Mode = BUILDING.INDEX END ELSE Build.Time = 0 READ temporary.record FROM Po.File.Variable, @ID THEN IF temporary.record = @RECORD THEN BEGIN CASE CASE @ID = Last.Updated.Id Last.Mode = UPDATE.SECOND.CALL Last.Added.Id = "" CASE @ID = Last.Added.Id Last.Mode = NEEDLESS.WRITE.PERFORMED Last.Added.Id = "" CASE TRUE Last.Mode = ADD Last.Added.Id = @ID END CASE Last.Updated.Id = "" END ELSE Last.Mode = UPDATE.FIRST.CALL Last.Added.Id = "" Last.Updated.Id = @ID END END ELSE Last.Mode = DELETING Last.Updated.Id = "" Last.Added.Id = "" temporary.record = "" END END display.error.messages = TRUE ON Last.Mode GOSUB add:, delete:, update:, update.phase.2:, needless.write.performed:, build: RETURN add: GOSUB build.pod.records: IF result # "ERROR" THEN GOSUB write.pod.records: END RETURN delete: display.error.messages = FALSE GOSUB build.pod.records: GOSUB delete.pod.records: RETURN update: display.error.messages = FALSE GOSUB build.pod.records: IF result # "ERROR" THEN GOSUB write.pod.records: END RETURN update.phase.2: GOSUB delete.pod.records: GOSUB build.pod.records: IF result # "ERROR" THEN GOSUB write.pod.records: END RETURN needless.write.performed: display.error.messages = FALSE GOSUB build.pod.records: RETURN build: IF Build.Time = 0 THEN PRINT "Clearing the POD file. (BUILD.POD.INDEX)" CLEARFILE Pod.File.Variable Build.Time = 1 END GOSUB build.pod.records: IF result # "ERROR" THEN GOSUB write.pod.records: END RETURN build.pod.records: MATPARSE purchase.order.record FROM @RECORD, @FM detail.record.counter = 0 errors = "" result = "" number.of.backordered.line.items = 0 number.of.excess.receipt.line.items = 0 customer.id = purchase.order.record(PO.VENDOR.NUMBER) IF customer.id = "" THEN customer.id = purchase.order.record(6) END customer.po = purchase.order.record(PO.PURCHASE.ORDER.NUMBER) current.order.status = purchase.order.record(PO.STATUS) hold = purchase.order.record(14) purchase.order.type = purchase.o
Re: [U2] xls to text
Rudy,
> Does anyone know where I can get FREE software that will convert Excel
> files to text files in command line mode ?
Have you considered a perl script? The Spreadsheet::ParseExcel::Simple
module is very easy to use.
This might even work for you (no promises there aren't errors):
#!/usr/bin/perl
use Spreadsheet::ParseExcel::Simple;
my $xls = Spreadsheet::ParseExcel::Simple->read('./source.xls');
my $sheet = ($xls->sheets)[0];
my @data='';
open(CSV, ">./destination.txt");
$" = ",";
while ($sheet->has_data) {
my @data = $sheet->next_row;
for(i=0; i < @data; i++){
# Double Quote Quotes
$data[i] =~ s/"/""/g;
# Quotes around any field containing commas or double quotes
if ($data[i] =~ /[,"]/){
$data[i] = "\"$data[i]\"";
}
}
print CSV "@data\n";
}
close(CSV);
regards,
Craig
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] D3 to U2 - how to import a FileSave tape
If I to a 'file save' from D3 to a 'disk' tape device, then ZIP the file from a Linux Box onto a Windows Box and unZIP it to do 'account restores' on a U2 box... What surprises await me? The issue on a test conversion I need to run is that the tape drive on the Linux box cannot be accessed on a Windows Box, and go figure, I don't have $3k to throw down for a one-time conversion So - I'd like to use the tape 'disk' file to import. But would love any knowledge from those bearing the arrows of being leaders on this process! They have about 2GB of data - likely much smaller ZIPed, so I can get it on a single 'tape file' and 'ftp' it from one machine to the other (while I'm at lunch...). From there, is it 'smooth sailing'? Also, this customer could care less if I dropped them into UniVerse or UniData - I use UniData more, but that's just a preference I can get over if UniVerse makes this substantially easier. TIA for any thoughts - David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] D3 to U2 - how to import a FileSave tape
I've done a number of these. We had a D3/Aix box that I would restore the tapes on. I would then run a program that renamed all of the D3 files as upper case (made things come through cleaner on UD). It pretty much simply selects the file-of-files and does a rename to xxyyz and then back to the original name 'MCU'd. I had a pseudo floppy setup (with a 512 block-size). I did an account-save to it then used SFU (now free) to copy the file to the UD windows box. I think I also checked that a binary ftp transfer worked. I then created the tape device in UD (making sure to set the 512 block size). Then did an acct-restore. Worked like a charm. We converted approx 50 clients like this. Others haven't had very good luck. Once you get the data into UD note that D3 is not case-sensitive - but UD is. At least by default, I believe it's an option now. That means that all of your primary and foreign keys need to be in the same case. My old boss even tried taking the unix file the D3 save creates and running it through a Unix utility to upper case ALL of the data. We have a lot of "textual" data that didn't really lend itself to this method, YMMV. I have some more complete notes at work that I can post in the morning if you like. hth Colin Alfke Calgary Canada From: David Wolverton If I to a 'file save' from D3 to a 'disk' tape device, then ZIP the file from a Linux Box onto a Windows Box and unZIP it to do 'account restores' on a U2 box... What surprises await me? The issue on a test conversion I need to run is that the tape drive on the Linux box cannot be accessed on a Windows Box, and go figure, I don't have $3k to throw down for a one-time conversion So - I'd like to use the tape 'disk' file to import. But would love any knowledge from those bearing the arrows of being leaders on this process! They have about 2GB of data - likely much smaller ZIPed, so I can get it on a single 'tape file' and 'ftp' it from one machine to the other (while I'm at lunch...). From there, is it 'smooth sailing'? Also, this customer could care less if I dropped them into UniVerse or UniData - I use UniData more, but that's just a preference I can get over if UniVerse makes this substantially easier. TIA for any thoughts - David [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/
