RE: [U2] XML and Accuterm
Glen wrote: I'm pretty sure that Accuterm has no capability to perform socket connections using scripts. It has VBA(Visual Basic for Applications) capabilities, which is nothing like VB. That is not my experience. VBA is a lot like VB. I have no experience of Accuterm but if it has a decent implementation of VBA then you could do whatever you like that you can do in VB including using standard Microsoft XML libraries which include methods for sending and receiving XML via HTTP (just an example). Regards, Rob Wills (rob dot wills at tigerinfotech dot com) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Port number
Hi all, I'm hoping that somebody can unearth a gem to help with the following: I'm working with uniobjects on Unidata 5.2 (Winblows) and have a situation where a user logs into the system and runs a particular application. This does things using the Unidata port number - ie, it writes records and so forth with the port number as part of the record id - before executing a VB application. Inside the VB app, I'd like to pick up the Unidata port number, but I can't suss out a way of picking it up via uniobjects for use in further processing. Any ideas? Thanks in advance. SC --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
Al, This works on universe: TEXT = CHANGE(TEXT, @SM:@SM, @VM:@VM) TEXT = CONVERT(@SM, , TEXT) TEXT = FMTS(TEXT, 50T) TEXT = CONVERT(@VM:@TM, @SM:@SM, TEXT) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
Nope. Tried it with a couple different sessions and no change in behavior. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 8:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] DISABLE.INDEX from BASIC In a message dated 8/24/05 3:59:23 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: I'll UPDATE.INDEX and do the LIST.INDEX again and it says the same thing again. Try logging off that session, then back on and try it again. It might work now. Maybe it holds an old pointer with the outdated info. Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
What does the L_filename look like? It stores all of the records written to the file while the index was disabled. Perhaps a permission issue on it? Is the file in use while you are doing this? The disable.index won't come into effect on a file until it is closed in basic - perhaps that's also true of enable.index. Perhaps a trigger on the file is keeping it open. The basic command INDICES() may also provide some more info/clues. At this stage you may have to remove the index and rebuild it. Sorry, not much help. Once I found the disable.index caused the entire record to be written to the log each time it was updated I realized it was not going to work for us. There was a problem with the udtsort.exe and indexes - but I think that might have been an earlier version. Colin Alfke Calgary, AB -Original Message- From: Kevin King Is there a BASIC equivalent to the DISABLE.INDEX TCL command on Unidata 5.2? I have a weird situation at a client site now where I'll do a LIST.INDEX on a particular file and it'll say Enabled, Indices require updating, I'll UPDATE.INDEX and do the LIST.INDEX again and it says the same thing again. I've searched through ever scrap of code I can find to see if there's a program writing to this file that is turning off the automatic updates or writing somehow without the index update, and I can't find DISABLE.INDEX or ENABLE.INDEX anywhere in code. Any ideas? -Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Port number
Can you write the port number to a specific location just before calling the VB app and then have it read it from that location? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Carter Sent: Thursday, August 25, 2005 5:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] Port number Hi all, I'm hoping that somebody can unearth a gem to help with the following: I'm working with uniobjects on Unidata 5.2 (Winblows) and have a situation where a user logs into the system and runs a particular application. This does things using the Unidata port number - ie, it writes records and so forth with the port number as part of the record id - before executing a VB application. Inside the VB app, I'd like to pick up the Unidata port number, but I can't suss out a way of picking it up via uniobjects for use in further processing. Any ideas? Thanks in advance. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.11 XP SP2
Has anyone run into problems with UniVerse 10.1.11 on Windows XP SP2. I cannot get telnet or Uniobjects to work. Telnet: --- If the system event log: UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. Actions Taken: I have done a netstat -oan and found nothing on port 23. I have also switched the SP2 firewall off and this has made no changes. I have tried running telnet against a different port number. I can call universe through telnet on another machine from the suspect machine. UniVerse Administrator: - Login fails with the message RPC Connection Error 1 -The RPC failed The service starts with no problem and failure does not raise an event in the Windows event log. I am also running Microsofts Anti spyware but this does not affect UniVerse on a Windows 2003 machine. Stumped Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.11 XP SP2
David, I don't know if this will help. We have seen similar issues on Win 2003 servers. Below is a little blurb we have internally on it. When trying to log into UniAdmin for UniVerse 10.1 on a Windows 2003 server. This resulted in the ODBC connection getting an invalid user id or password error when trying to connect If RRAS is running it can automatically turn on the firewall and block the port that the RPC service listens on, which is port 31438. UniVerse RPC Service is not tied in with Windows RPC service. So, UniVerse RPC can fail and Windows RPC will still be running. If Windows 2003 is running IIS v6.0 it can interfere with the RPC port. To correct it, open IIS and right click on Web Sites. Click on the Service tab and check the box that says Run WWW service in IIS 5.0 isolation mode. Then reboot the server. Mike Dallaire Mortgage Builder Software Inc. (248) 208-3223 ext. 103 [EMAIL PROTECTED] www.mortgagebuilder.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, August 25, 2005 9:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV 10.1.11 XP SP2 Has anyone run into problems with UniVerse 10.1.11 on Windows XP SP2. I cannot get telnet or Uniobjects to work. Telnet: --- If the system event log: UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. Actions Taken: I have done a netstat -oan and found nothing on port 23. I have also switched the SP2 firewall off and this has made no changes. I have tried running telnet against a different port number. I can call universe through telnet on another machine from the suspect machine. UniVerse Administrator: - Login fails with the message RPC Connection Error 1 -The RPC failed The service starts with no problem and failure does not raise an event in the Windows event log. I am also running Microsofts Anti spyware but this does not affect UniVerse on a Windows 2003 machine. Stumped Regards David Jordan --- 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 10.1.11 XP SP2
Yeah, I did have that exact same problem until I uninstalled the software I use for my Verizon phone to magically turn it into a very bad wireless modem. As so as I uninstalled that, telnet and rpc worked again. It must have something to do with all the various layered TCP stack products. I meant to reinstall the Verizon stuff again after getting UniVerse back up to see if it broke it again and never got around to it. AB David Jordan wrote: Has anyone run into problems with UniVerse 10.1.11 on Windows XP SP2. I cannot get telnet or Uniobjects to work. Telnet: --- If the system event log: UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. Actions Taken: I have done a netstat -oan and found nothing on port 23. I have also switched the SP2 firewall off and this has made no changes. I have tried running telnet against a different port number. I can call universe through telnet on another machine from the suspect machine. UniVerse Administrator: - Login fails with the message RPC Connection Error 1 -The RPC failed The service starts with no problem and failure does not raise an event in the Windows event log. I am also running Microsofts Anti spyware but this does not affect UniVerse on a Windows 2003 machine. Stumped Regards David Jordan --- 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] XML and Accuterm
In a message dated 8/25/2005 12:41:26 AM Pacific Standard Time, [EMAIL PROTECTED] writes: VB including using standard Microsoft XML libraries which include methods for sending and receiving XML via HTTP Do you have example code where you do this? Thanks Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Port number
In a message dated 8/25/2005 4:28:30 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Inside the VB app, I'd like to pick up the Unidata port number, but I can't suss out a way of picking it up via uniobjects for use in further processing write it out to C:/Temp/PortNumber or /temp/(user)/PortNumber Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] DISABLE.INDEX from BASIC
In a message dated 8/25/2005 6:09:05 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Nope. Tried it with a couple different sessions and no change in behavior. delete index then create it again? Maybe the index is screwy from some craziness in the past. Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
I had a similar problem a few months ago while converting from D3 to UD. UniBasic lacks the FOLD() function that D3 had. Lots of folks here offered great advice and I put together this subroutine from the best pieces form all of it. SUBROUTINE FOLDER(DATA.IN,COL.WIDTH,DELIM,DATA.OUT) *** break monolithic string on word space nearest desired *** column width and return data with delimiters DATA.IN = TRIM(DATA.IN) DATA.OUT = TEMP = LINE.CNT = 0 NUMWORD = DCOUNT(DATA.IN, ) FOR X = 1 TO NUMWORD WORD = FIELD(DATA.IN, ,X) WORDLEN = LEN(WORD) TEMPLEN = LEN(TEMP) IF (TEMPLEN + WORDLEN + 1) COL.WIDTH THEN LINE.CNT += 1 IF LINE.CNT 1 THEN DATA.OUT := DELIM DATA.OUT := TEMP TEMP = END IF TEMP # THEN TEMP := TEMP := WORD NEXT X IF TEMP # THEN LINE.CNT += 1 IF LINE.CNT 1 THEN DATA.OUT := DELIM DATA.OUT := TEMP TEMP = END RETURN Perhaps you could use this by taking your data, stripping all @TM, @SVM, @VM to leave a big chunk of just text and feed it through the subroutine. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Vegetables are what food eats. === -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Al DeWitt Sent: Wednesday, August 24, 2005 6:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Formatting Data Part of the problem, I believe is that our ECLTYPE and BASICTYPE are P, Pick. Commands are not working the way I expect because I'm approaching this from a UV mindset (I can't help it, it's what I know). I'm being told that NEWLINE = FMT(TRIM(LINE),'55T') would turn 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,' into 'Fourscore and seven years ago our fathers brought [EMAIL PROTECTED] 'on this continent a new nation,' However, the command: NEWLINE = FMT(TRIM(LINE),'55T') does not work. It just gives me the letter T. The command: NEWLINE = FMT(TRIM(LINE),'T#55') sort of works. If LINE = 'Fourscore and seven years ago our fathers brought forth on this continent a new nation,', the FMT command produces 'TFourscore and seven years ago our fathers brought forth' but loses 'on this continent a new nation,' I don't think UniData's Pick flavor is up to the task, but I'm open to any ideas. --Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, August 24, 2005 6:02 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Formatting Data Consider Socratic Programming... that is, break the problem down into elemental pieces. Please consider broadcasting a few lines of the bug-laden code. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 8/24/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
No problems. What about putting a wrapper around the disable.index command to log how it's being run? What about ODBC access to the account? I'm not sure what it can do to the index but Colin Alfke Calgary, AB -Original Message- From: Kevin King No triggers, thanks. But you may have hit on something. What if someone disabled the index, then a program opened the file, the index was enabled, but the program still has that file open and thinks the index is still disabled? That might explain a great deal. I have removed the index and rebuilt it - several times. I've deleted the X item from AIX and started the whole deal all over. No change. Today, the DISABLE.INDEX command is temporarily MIA. This is to rule out someone manually entering this command. And now we watch. Thanks for the ideas. I appreciate the feedback. -Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML and Accuterm
In a message dated 8/25/2005 12:41:26 AM Pacific Standard Time, [EMAIL PROTECTED] writes: VB including using standard Microsoft XML libraries which include methods for sending and receiving XML via HTTP Do you have example code where you do this? Thanks I would also be interested in seeing any examples you have of that. thanks Victor St. Clair --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Data
The use of the callable routine !FOLD was suggested a day or two ago. It is very affective in that it naturally breaks on space. If you use the remove to display the folded text it save a great deal of coding. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
I'm considering the wrapper idea, but I figure it's easier to put it under an arcane name for a day or so just to watch. And I've confirmed no ODBC access to this particular file. So far so good. Couple of hours now and no problems. Perhaps it was that DISABLE.INDEX and then the file got opened by BASIC - SB+ BASIC at that, so you know those file buffers may have stayed open like forever... -K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC No problems. What about putting a wrapper around the disable.index command to log how it's being run? What about ODBC access to the account? I'm not sure what it can do to the index but --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] XML and Accuterm
In a message dated 8/24/2005 10:26:39 PM Pacific Standard Time, [EMAIL PROTECTED] writes: have the client shell out, execute the function, return data to a local file, Do you have an example of how to execute a request like that in Windows or Unix and return the result to a local file? Thanks Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
No triggers, thanks. But you may have hit on something. What if someone disabled the index, then a program opened the file, the index was enabled, but the program still has that file open and thinks the index is still disabled? That might explain a great deal. I have removed the index and rebuilt it - several times. I've deleted the X item from AIX and started the whole deal all over. No change. Today, the DISABLE.INDEX command is temporarily MIA. This is to rule out someone manually entering this command. And now we watch. Thanks for the ideas. I appreciate the feedback. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 6:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC What does the L_filename look like? It stores all of the records written to the file while the index was disabled. Perhaps a permission issue on it? Is the file in use while you are doing this? The disable.index won't come into effect on a file until it is closed in basic - perhaps that's also true of enable.index. Perhaps a trigger on the file is keeping it open. The basic command INDICES() may also provide some more info/clues. At this stage you may have to remove the index and rebuild it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Port number
Kevin, Thanks for replying. What you suggest is what I currently do, however I was hoping that some kindly and knowledgeable soul would spring a surprise on me! I can see that the GetAtVariable method of the session object can pull in various @variables, and I can also see that, for the most part in a windows environment and a VB app, knowing the port number is probably fairly meaningless, but in a system that combines SB+ gui and VB, it does still have a use. I can achieve my aim by doing a noddy subroutine that returns @UDTNO, but my hope was that it might be available (and undocumented) via uniobjects. Thanks anyway! SC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 25 August 2005 13:51 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Port number Can you write the port number to a specific location just before calling the VB app and then have it read it from that location? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Carter Sent: Thursday, August 25, 2005 5:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] Port number Hi all, I'm hoping that somebody can unearth a gem to help with the following: I'm working with uniobjects on Unidata 5.2 (Winblows) and have a situation where a user logs into the system and runs a particular application. This does things using the Unidata port number - ie, it writes records and so forth with the port number as part of the record id - before executing a VB application. Inside the VB app, I'd like to pick up the Unidata port number, but I can't suss out a way of picking it up via uniobjects for use in further processing. Any ideas? Thanks in advance. --- 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] DISABLE.INDEX from BASIC
Okay, it's definitely NOT DISABLE.INDEX. The problem has occurred again, but with a slightly different manifestation. LIST.INDEX shows the indexes are enabled, built, and no updates pending. However, when I select the file using that indexed field, I get nothing. If I disable the index and execute the exact same select statement, I get 28 records. Here's the selection statement, and yes, it's Prelude: SELECT BIN.QUEUE WITH BTREE_DEFAULT = 001!002!O] Again, this is UD 5.2 on AIX, and DISABLE.INDEX isn't even around as a verb from TCL. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date = 06-27-05 AND Inv_So_Date = 09-25-05; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. 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: [U2] unioledb connection from SQL2000
Up here, in the Great White North, we have to watch the regional settings. Sometimes using a different date format causes problems - whether it's the order or the delimiter. It seems to be a problem with your dates - so this is where I would start... Colin Alfke Calgary, AB -Original Message- From: Lettau, Jeff We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date = 06-27-05 AND Inv_So_Date = 09-25-05; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. Jeffrey Lettau --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML and Accuterm
In my original post, I admitted to not actually using Accuterm. I was basically saying that if Accuterm supported VBA then it should definitely be possible to send and receive XML just as you could in VB. I've since been on the Accuterm site just to check what it can do. It does seem to have the capability to use VB object libraries and here's a URL link to a page on their site which goes into a lot of detail: http://www.asent.com/email_white_paper.htm As for the actual code to send and receive XML, I will need to dig that out of an application and I'll post it tomorrow hopefully. Regards, Rob Wills (rob dot wills at tigerinfotech dot com) [EMAIL PROTECTED] wrote on 25/08/2005 15:20:08: In a message dated 8/25/2005 12:41:26 AM Pacific Standard Time, [EMAIL PROTECTED] writes: VB including using standard Microsoft XML libraries which include methods for sending and receiving XML via HTTP Do you have example code where you do this? Thanks I would also be interested in seeing any examples you have of that. thanks Victor St. Clair --- 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] DISABLE.INDEX from BASIC
Sorry dude, been there, done that, bought the shirt. I've done this exact sequence dozens of times and the problem persists. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: Thursday, August 25, 2005 11:00 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC IT sounds like it is time to do a 'DELETE.INDEX', 'CREATE.INDEX', 'BUILD.INDEX'. There must be something out of sync and you may never figure out the why. We have had indexes that produced different results when using 'REQUIRE.INDEX' and 'NO.INDEX'. The only way to go forward was to rebuild. We now have a database of our Unidata indexes and a program to do this rebuild if the need arises. - Rod -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 11:12 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC Okay, it's definitely NOT DISABLE.INDEX. The problem has occurred again, but with a slightly different manifestation. LIST.INDEX shows the indexes are enabled, built, and no updates pending. However, when I select the file using that indexed field, I get nothing. If I disable the index and execute the exact same select statement, I get 28 records. Here's the selection statement, and yes, it's Prelude: SELECT BIN.QUEUE WITH BTREE_DEFAULT = 001!002!O] Again, this is UD 5.2 on AIX, and DISABLE.INDEX isn't even around as a verb from TCL. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
First off. Thanks for the response. Next. We figured it out. We used an updated driver from our version 6.03??? Unidata disk instead of the 5.2??? Version that was on the old server. I think the numbers of the actual driver are not that different. But to make a long post shorter I'll just say the answer to the question is formatting. The date needs to be 2005-06-27 not 06-27-05 Why? I don't know. And do I care? Not all that much now that it works. So the secret word of the day is International date format. So It's 3 words. So sue me. I'll return to lurking again. Thanks. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, August 25, 2005 2:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unioledb connection from SQL2000 What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date = 06-27-05 AND Inv_So_Date = 09-25-05; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
Okay, here's some specifics about the problem I'm experiencing: Alternate Key Index Details for File BIN.QUEUEPage 1 File.. BIN.QUEUE Alternate key length.. 35 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 1 (0 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr BTREE_DEFAULT V TxtYes Yes Yes Yes M OCONV(@ID,G0!5 ) --- Keys in this file look like this: --- LIST BIN.QUEUE 11:49:34 AUG 25 2005 1 BIN.QUEUE. 001!001!O!13738!AAL2C!AAL2C 001!001!C!13591!XL2C!XL2C 001!001!C!13591!XM2A!XM2A 001!001!C!13591!XN3C!XN3C 001!001!C!13591!XO3A!XO3A 001!001!C!13591!XP2B!XP2B 001!001!C!13591!XP4C!XP4C --- Therefore, given that BTREE_DEFAULT is OCONV(@ID,G0!5) these two SELECT statements should return the exact same results: --- :SELECT BIN.QUEUE WITH BTREE_DEFAULT = 001!001] 671 records selected to list 0. CLEARSELECT :SELECT BIN.QUEUE WITH @ID = 001!001] 638 records selected to list 0. --- And as you can see, they return different things. And immediately after this test and a subsequent CLEARSELECT: --- Alternate Key Index Details for File BIN.QUEUEPage 1 File.. BIN.QUEUE Alternate key length.. 35 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 1 (0 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr BTREE_DEFAULT V TxtYes Yes Yes Yes M OCONV(@ID,G0!5 ) --- Note the Enabled, No updates pending. Then following a BUILD.INDEX BIN.QUEUE ALL: --- :BUILD.INDEX BIN.QUEUE ALL One * represents 1000 records Building BTREE_DEFAULT ... 671 record(s) processed. :SELECT BIN.QUEUE WITH @ID = 001!001] 642 records selected to list 0. CLEARSELECT :SELECT BIN.QUEUE WITH BTREE_DEFAULT = 001!001] 642 records selected to list 0. And though it was corrected via the BUILD.INDEX, it won't last. Here's what's sitting @ AIX: $ ls -l *BIN.QUEUE -rwxrwxrwx 1 root ud 278528 Aug 25 11:55 BIN.QUEUE -rwxrwxrwx 1 root ud49152 Aug 24 13:01 D_BIN.QUEUE -rwxrwxrwx 1 root ud 110592 Aug 25 11:54 X_BIN.QUEUE $ Though I didn't illustrate it, there was no L_ item prior to the BUILD.INDEX. And unfortunately I can't change the programming to factor out this index due to the way the vendor application has been programmed. Getting this index to be reliable seems to be the only solution. Also there are no triggers on this file. Help? P.S. Are there any logs available in Unidata that might illustrate some faults in the indexing processor? -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
To the point where the actual file holding the indexes was deleted and created (X_ or idx)? -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC Sorry dude, been there, done that, bought the shirt. I've done this exact sequence dozens of times and the problem persists. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: Thursday, August 25, 2005 11:00 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC IT sounds like it is time to do a 'DELETE.INDEX', 'CREATE.INDEX', 'BUILD.INDEX'. There must be something out of sync and you may never figure out the why. We have had indexes that produced different results when using 'REQUIRE.INDEX' and 'NO.INDEX'. The only way to go forward was to rebuild. We now have a database of our Unidata indexes and a program to do this rebuild if the need arises. - Rod -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 11:12 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC Okay, it's definitely NOT DISABLE.INDEX. The problem has occurred again, but with a slightly different manifestation. LIST.INDEX shows the indexes are enabled, built, and no updates pending. However, when I select the file using that indexed field, I get nothing. If I disable the index and execute the exact same select statement, I get 28 records. Here's the selection statement, and yes, it's Prelude: SELECT BIN.QUEUE WITH BTREE_DEFAULT = 001!002!O] Again, this is UD 5.2 on AIX, and DISABLE.INDEX isn't even around as a verb from TCL. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 --- 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] XML and Accuterm
Interesting. If you have a registered ActiveX or DLL, then you can create an instance of it using 2K and 2K2's VBA scripting. You also will need documentation on the methods and elements that the object contains. I've been using 97 for many years now, so I never knew about that. I just recently upgraded to 2K2. Thanks for the info. So, there is a possibility to use an ActiveX object that can post and retrieve XML documents. The white paper is specifically for integrating Accuterm into Office, with a focus on Outlook. In order to post and retrieve XML documents, the ActiveX control or DLL will have to do that behind the scenes. Maybe there are some free or non-free controls out there specifically for that. I dunno. I still prefer to do things like that from MV using platform independant tools Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] XML and Accuterm In my original post, I admitted to not actually using Accuterm. I was basically saying that if Accuterm supported VBA then it should definitely be possible to send and receive XML just as you could in VB. I've since been on the Accuterm site just to check what it can do. It does seem to have the capability to use VB object libraries and here's a URL link to a page on their site which goes into a lot of detail: http://www.asent.com/email_white_paper.htm As for the actual code to send and receive XML, I will need to dig that out of an application and I'll post it tomorrow hopefully. Regards, Rob Wills (rob dot wills at tigerinfotech dot com) [EMAIL PROTECTED] wrote on 25/08/2005 15:20:08: In a message dated 8/25/2005 12:41:26 AM Pacific Standard Time, [EMAIL PROTECTED] writes: VB including using standard Microsoft XML libraries which include methods for sending and receiving XML via HTTP Do you have example code where you do this? Thanks I would also be interested in seeing any examples you have of that. thanks Victor St. Clair --- 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] [UD] DISABLE.INDEX from BASIC
Deleted via DELETE.INDEX, removed via rm, and verified via ls. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: Thursday, August 25, 2005 1:20 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC To the point where the actual file holding the indexes was deleted and created (X_ or idx)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
That's precisely how it presented to us. If it was built on an earlier version it would update OK - but as soon as we rebuilt it just wasn't right. Other ideas: Check the *log files in @udthome/bin. Likely udt.log, udt.errlog, not sure if 5.2 had udtsort.log? Make sure you have enough space in /tmp (@udttmp) as the index needs it. Usually you get an error though if it runs out of space. If the rebuild didn't work when everyone was off (and you made sure it was deleted at the Aix level) then you could delete the index (make sure it's gone) copy all of the records out of the file. Re-create the index, copy all of the records back in. I did notice that it looks like the index is defined as a M though it looks like it should be an S. Try re-saving the dict item in SB+, make sure 6 of the UD dictionary is S and then delete and re-create the index - while everyone is off. Good luck Colin Alfke Calgary, AB -Original Message- From: Kevin King I've tried rebuilding the index both while the users are logged on, and when the users are logged off, and the problem persists. We've even rebooted. I've recommended to the client they need to contact the vendor (which is their only path to IBM) so we'll see where that gets us. What's weird is that this worked just fine until a few days ago. I rebuilt the index via BUILD.INDEX and trouble started. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: free info - was XML and Accuterm
Will wrote: Tony writes: have the client shell out, execute the function, return data to a local file, Do you have an example of how to execute a request like that in Windows or Unix and return the result to a local file? Thanks Sorry Will. This is my business. I take the time to research how to use technologies and I sell that information and related services to my clients who don't have the time to do that research on their own. I stop short of providing detailed code sequences especially when there are (in this case) examples provided with AccuTerm itself and in their web forum. For the XML request and parsing, I wrote a free series of articles on this topic in Spectrum magazine that spanned four issues and included links to a multitude of sites for information, freeware, and products. The world is full of examples like this and I don't think it's fair to put the burden on people in this forum to produce data that's easily available elsewhere. I'll also note that Rob Wills just went to the Accuterm web site and got info that anyone could get, and generously volunteered to come up with more info from research tomorrow. That's very helpful and I'd usually do the same myself, but in this case Rob is volunteering to do research simply because Will doesn't feel like doing it. That is so wrong. I'm only going off on this because this request for examples reminds me of the how do I connect to the web thread that went on for weeks with detailed solutions - simply because a couple people wanted the information spoon fed to them without doing their homework outside of this U2-specific forum. C'mon, you don't want examples, you want copy/paste code for your specific project and the questions will keep coming until every aspect of the project is complete. I know this is harsh. But every time I post a note like this somewhere I get flamed by some people for being a grouch and I get emails of praise from others for drawing the line somewhere - I'll take the risk. I'm sorry, I'll provide as much free info as I can to benefit as many people as possible, and I've been doing so in MV forums like this for over 10 years. But when the questions get this specific I have to ask people to do their own homework. There are those of us who work hard and study hard so that we can sell our knowledge as a product and thus pay our bills. There is value to what we do, as is evident by the fact that people are going to take info they find here and sell it to someone else as their own know-how. There's no accident to my calling my company Research and Development. We'll do the research and/or we'll do the development - we consider both of these as equally valuable offerings in this market where many people need as much information as they need assistance with development using modern technologies. Tony Gravagno Nebula Research and Development --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: free info - was XML and Accuterm
It's even more thrilling when the people looking for the examples purport to being consultants themselves and are, in effect, competitors. God Bless ya Tony. Besides, you've reached a certain age you have the right to be curmudgeonly. Al Tony Gravagno wrote: Will wrote: Tony writes: have the client shell out, execute the function, return data to a local file, Do you have an example of how to execute a request like that in Windows or Unix and return the result to a local file? Thanks Sorry Will. This is my business. I take the time to research how to use technologies and I sell that information and related services to my clients who don't have the time to do that research on their own. I stop short of providing detailed code sequences especially when there are (in this case) examples provided with AccuTerm itself and in their web forum. For the XML request and parsing, I wrote a free series of articles on this topic in Spectrum magazine that spanned four issues and included links to a multitude of sites for information, freeware, and products. The world is full of examples like this and I don't think it's fair to put the burden on people in this forum to produce data that's easily available elsewhere. I'll also note that Rob Wills just went to the Accuterm web site and got info that anyone could get, and generously volunteered to come up with more info from research tomorrow. That's very helpful and I'd usually do the same myself, but in this case Rob is volunteering to do research simply because Will doesn't feel like doing it. That is so wrong. I'm only going off on this because this request for examples reminds me of the how do I connect to the web thread that went on for weeks with detailed solutions - simply because a couple people wanted the information spoon fed to them without doing their homework outside of this U2-specific forum. C'mon, you don't want examples, you want copy/paste code for your specific project and the questions will keep coming until every aspect of the project is complete. I know this is harsh. But every time I post a note like this somewhere I get flamed by some people for being a grouch and I get emails of praise from others for drawing the line somewhere - I'll take the risk. I'm sorry, I'll provide as much free info as I can to benefit as many people as possible, and I've been doing so in MV forums like this for over 10 years. But when the questions get this specific I have to ask people to do their own homework. There are those of us who work hard and study hard so that we can sell our knowledge as a product and thus pay our bills. There is value to what we do, as is evident by the fact that people are going to take info they find here and sell it to someone else as their own know-how. There's no accident to my calling my company Research and Development. We'll do the research and/or we'll do the development - we consider both of these as equally valuable offerings in this market where many people need as much information as they need assistance with development using modern technologies. Tony Gravagno Nebula Research and Development --- 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] DISABLE.INDEX from BASIC
I've tried both the M and S. I only left it M when I saw this index working perfectly on another site using this same software. Going spelunking for logs now. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC That's precisely how it presented to us. If it was built on an earlier version it would update OK - but as soon as we rebuilt it just wasn't right. Other ideas: Check the *log files in @udthome/bin. Likely udt.log, udt.errlog, not sure if 5.2 had udtsort.log? Make sure you have enough space in /tmp (@udttmp) as the index needs it. Usually you get an error though if it runs out of space. If the rebuild didn't work when everyone was off (and you made sure it was deleted at the Aix level) then you could delete the index (make sure it's gone) copy all of the records out of the file. Re-create the index, copy all of the records back in. I did notice that it looks like the index is defined as a M though it looks like it should be an S. Try re-saving the dict item in SB+, make sure 6 of the UD dictionary is S and then delete and re-create the index - while everyone is off. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] DISABLE.INDEX from BASIC
Nothing of consequence in the logs. No udtsort.log, but I looked through everything else matching *log. 90% free on /tmp as reported by df. And now it's stopped. It did this yesterday also; stopped in the afternoon and then came back at about 10am this morning. Man, this is some weird kung fu. -K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC Check the *log files in @udthome/bin. Likely udt.log, udt.errlog, not sure if 5.2 had udtsort.log? Make sure you have enough space in /tmp (@udttmp) as the index needs it. Usually you get an error though if it runs out of space. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: free info - was XML and Accuterm
Ok. What the heck is curmudgeonly and how to you pronounce it! lol! Thanks, Marilyn A. Hilb [EMAIL PROTECTED] www.valuepart.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Bell Sent: Thursday, August 25, 2005 3:23 PM To: u2-users@listserver.u2ug.org Subject:Re: [U2] RE: free info - was XML and Accuterm It's even more thrilling when the people looking for the examples purport to being consultants themselves and are, in effect, competitors. God Bless ya Tony. Besides, you've reached a certain age you have the right to be curmudgeonly. Al --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: free info - was XML and Accuterm
From www.dictionary.com Dictionary - Thesaurus - Web Top Web Results for curmudgeonly 2 entries found for curmudgeonly. cur7mudg7eon( P ) Pronunciation Key (kr-mjn) n. An ill-tempered person full of resentment and stubborn notions. [Origin unknown.] cur7mudgeon7ly adj. cur7mudgeon7ry n. Source: The American Heritage. Dictionary of the English Language, Fourth Edition Copyright ) 2000 by Houghton Mifflin Company. Published by Houghton Mifflin Company. All rights reserved. curmudgeonly adj : brusque and surly and forbidding; crusty remarks; a crusty old man; his curmudgeonly temper; gruff manner; a gruff reply [syn: crusty, gruff, ill-humored, ill-humoured] Source: WordNet . 2.0, ) 2003 Princeton University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marilyn Hilb Sent: Thursday, August 25, 2005 14:02 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: free info - was XML and Accuterm Ok. What the heck is curmudgeonly and how to you pronounce it! lol! Thanks, Marilyn A. Hilb [EMAIL PROTECTED] www.valuepart.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Bell Sent: Thursday, August 25, 2005 3:23 PM To: u2-users@listserver.u2ug.org Subject:Re: [U2] RE: free info - was XML and Accuterm It's even more thrilling when the people looking for the examples purport to being consultants themselves and are, in effect, competitors. God Bless ya Tony. Besides, you've reached a certain age you have the right to be curmudgeonly. Al --- 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] DISABLE.INDEX from BASIC
Thanks, but the index - for whatever reason - is on the first 5 of 6 ! delimited fields in the key. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: Thursday, August 25, 2005 2:55 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC I guess I am going to have to pay more attention to this thread. So it has to be data related if it can be rebuilt over and over. One thought is that you have some control characters in the data to throw the indexes for a loop. Not always easy to find. We actually found a record today in a Unidata file with a CHAR(255) in it. I don't think an index would like that. But you may have already covered that too. We have about 1200 files indexed and never gotten to this point with an index problem. I will be interested to see what you find. Good luck. Rod -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:58 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC Deleted via DELETE.INDEX, removed via rm, and verified via ls. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: Thursday, August 25, 2005 1:20 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] DISABLE.INDEX from BASIC To the point where the actual file holding the indexes was deleted and created (X_ or idx)? --- 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 8/22/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: free info - was XML and Accuterm
Every party needs a pooper that's why we invited you **!!JUST KIDDING!!** I too make my living being an independent, and while I may give away small snippets of code from time to time, I draw the line there. If I see a .edu at the end of the sender's email address I will usually divulge more than normal. Live long and prosper Tony!! :) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno Sent: Thursday, August 25, 2005 13:09 To: u2-users@listserver.u2ug.org Subject: [U2] RE: free info - was XML and Accuterm Will wrote: Tony writes: have the client shell out, execute the function, return data to a local file, Do you have an example of how to execute a request like that in Windows or Unix and return the result to a local file? Thanks Sorry Will. This is my business. I take the time to research how to use technologies and I sell that information and related services to my clients who don't have the time to do that research on their own. I stop short of providing detailed code sequences especially when there are (in this case) examples provided with AccuTerm itself and in their web forum. For the XML request and parsing, I wrote a free series of articles on this topic in Spectrum magazine that spanned four issues and included links to a multitude of sites for information, freeware, and products. The world is full of examples like this and I don't think it's fair to put the burden on people in this forum to produce data that's easily available elsewhere. I'll also note that Rob Wills just went to the Accuterm web site and got info that anyone could get, and generously volunteered to come up with more info from research tomorrow. That's very helpful and I'd usually do the same myself, but in this case Rob is volunteering to do research simply because Will doesn't feel like doing it. That is so wrong. I'm only going off on this because this request for examples reminds me of the how do I connect to the web thread that went on for weeks with detailed solutions - simply because a couple people wanted the information spoon fed to them without doing their homework outside of this U2-specific forum. C'mon, you don't want examples, you want copy/paste code for your specific project and the questions will keep coming until every aspect of the project is complete. I know this is harsh. But every time I post a note like this somewhere I get flamed by some people for being a grouch and I get emails of praise from others for drawing the line somewhere - I'll take the risk. I'm sorry, I'll provide as much free info as I can to benefit as many people as possible, and I've been doing so in MV forums like this for over 10 years. But when the questions get this specific I have to ask people to do their own homework. There are those of us who work hard and study hard so that we can sell our knowledge as a product and thus pay our bills. There is value to what we do, as is evident by the fact that people are going to take info they find here and sell it to someone else as their own know-how. There's no accident to my calling my company Research and Development. We'll do the research and/or we'll do the development - we consider both of these as equally valuable offerings in this market where many people need as much information as they need assistance with development using modern technologies. Tony Gravagno Nebula Research and Development --- 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] UniSubroutine + Java
Hello all, Based on Wendy's recommendation, I have moved on to UniSubroutine as my vehicle for extracting XML reports from UniVerse. When I run the code below, I get a UniSubroutineException: Wrong number of arguments supplied to the subroutine when I execute getServicePopulation.call(). The subroutine takes two arguments: the XML string to be returned by the routine, and the service for which I want the population. SERVICE.POPULATION runs from within UniVerse and does indeed expect 2 args. Any ideas? Code below. Rick //UniSubroutine test UniSubroutine getServicePopulation = uSession.subroutine(SERVICE.POPULATION,2); System.out.println(Number of arguments = + getServicePopulation.getNumArgs()); getServicePopulation.setArg(0,testText); getServicePopulation.setArg(1,ES); System.out.println(Subroutine set up, routine name = + getServicePopulation.getRoutineName()); System.out.println(Calling subroutine...); getServicePopulation.call(); System.out.println(Subroutine finished... ); System.out.println(Subroutine: Arg0 = + getServicePopulation.getArg(0)); System.out.println( Arg1 = + getServicePopulation.getArg(1)); System.out.println(Results displayed, resetting args...); getServicePopulation.resetArgs(); __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: free info - was XML and Accuterm
In a message dated 8/25/05 1:15:26 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: I stop short of providing detailed code sequences especially when there are (in this case) examples provided with AccuTerm itself and in their web forum. Actually I already asked Pete at Accusoft and he said there are no such examples. I think you misread what was posted. But thanks. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: free info - was XML and Accuterm
In a message dated 8/25/05 1:15:26 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: I know this is harsh. But every time I post a note like this somewhere I get flamed by some people for being a grouch Tony your public insulting is out-of-line. Thanks. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] XML and Accuterm
In a message dated 8/25/05 11:49:01 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I've since been on the Accuterm site just to check what it can do. It does seem to have the capability to use VB object libraries and here's a URL link to a page on their site which goes into a lot of detail: http://www.asent.com/email_white_paper.htm Tony this link as you can see goes into detail on how to use VB Object libraries. I think it's really horrible that you think it's just fine to go into long-winded detail discussions of what a piece of crap I am. I have posted dozens of code examples myself here and am always trying to be helpful to others in this forum. I do not just come here for help, I actively seek to help others. And yes I also make my living by selling my services, but I know as you do, that most of the people who use this list, aren't looking to buy anything. So when I ask for a little help in an area I'm not comforable with suddenly I'm a troll, a loser, a waste, a user of other's knowledge without contributing. That's not how it works Tony Gravagno. How it works is we each contribute and we each gain. Sorry if you feel like you have no need to help anyone except by your occasional advertisements without putting [AD] in your heading, and thereby causing all of us to read through your long diatribes about your great software/service that we can't all live without. Well guess what Tony, Mr perfect who-never-needs-any-help-from-anyone-else? I don't care what you think. So have a nice day. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/