Re: [U2] [OT] SQL Query
On 07/11/12 16:31, Bill Brutzman wrote: The joins that I have tried seem to max out at like... three tables. in UV have a look at SET.SQL to tweak the workspace memory used for the current session. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [OT] CareerBuider.com exploiting animals in their advertising
Hi, Sorry this is off topic, but as it involves a company that some of you may use for job placement I thought it's not too inappropriate. For the upcoming US Super Bowl the job placement company CareerBuilder intend to run TV advertisements using Chimpanzees as unruly office workers. Although the 'fun antics' of chimps may seem harmless, sorry to say there are very sad consequences for them. Previously CareerBuilder has agreed not to exploit Chimpanzees in their advertising and this reversal has no doubt been based on having had good advertising success rate overriding their commitment to desist. I don't need to expand on the ethical implications of this position by a job placement company. If you believe that going back on a promise or cruelty to animals are morally unsupportable please consider writing to CareerBuilder to make your feelings known. You can read more about it here https://secure.peta.org/site/Advocacy?cmd=displaypage=UserActionid=3494 Thank you for reading and apologies for posting off topic. Regards, Stuart Boydell stu...@sbcs.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] File Delete Logging UV
You might want to have a look at OS level tools which will monitor a file in realtime... something like FAM or Tripwire: http://oss.sgi.com/projects/fam/faq.html http://www.blacksheepnetworks.com/security/resources/aix-tripwire.html If you use AIX, it has an auditing subsystem which would probably cover your requirements. http://ps-2.kev009.com:8081/AIXtip/monitor_users.htm http://www.redbooks.ibm.com/abstracts/sg246396.html Regards, Stuart Boydell -Original Message- We have a VOC file that keeps disappearing from an account, at both a unix and uv level, and I not sure what process is doing it, so I would like to log a delete to a file --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET - Reference / Experience / Advice
Just a question. I'm wondering what the IBM UO.Net pooling provides over using MS Enterprise Services pooling with UO.Net? The MS pooling component is built into the Windows OS (Enterprise Services for .Net aka Component Services). The IBM option seems to be expensive as far as licencing goes especially in light that seemingly similar functionality is already available. Can anyone tell me or are there any whitepapers or manuals available on IBM U2 pooling that might describe any benefits it might have that would justify the extra cost? Thanks, Stuart Boydell The connection pooling portion of UO.NET has be extremely tested for one U2 Channel Partner ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects for .NET - Reference / Experience / Advice
Hi David, Are there any whitepapers or info about it. I'm assuming now that there is some U2 server-side componentry that might make it faster or have more functionality than pooling thru Ent Services. I'd be interested to compare. We are using Ent Services for our procurement web service and are finding performance is good and reliable. Haven't had to touch it in 2 years and it has handled everything thrown at it with aplomb (and it has been hammered) so I can't see a reason to change and pay for pooling right now. However, if there was significant functionality in the IBM product not in ES it could be worth investigating. Stuart Boydell From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S [EMAIL PROTECTED] Sent: Wednesday, 29 November 2006 09:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects for .NET - Reference / Experience / Advice Once you see Connection Pooling in action with UO.NET, you wouldn't want to go back! IBM has some examples applications you can download from their website in VB.NET and C#, using connection pooling. Unfortunately, there is a separate license and cost associated with it. But it is worth it, for those that need it. You only need to buy the licenses you require. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT sub-command
Ron, I donbt know what the command does but shouldnbt it be spelt OPTIMIZE? Even for the adherents of Webster I wouldnbt think therebd be many people who spelt it OPTOb Which leads me to suspect that itbs a CUSTAMYSED command. Check whatbs in it b is it a copy of an existing b Kb type modifier? Stuart From: Ron Hutchings We are on UV 10.0.11 PICK flavor Someone has encoded a NO.OPTOMIZE sub-command on some selects on one of our files. I cannot find documentation regarding using this sub-command on a SELECT. Removing it gives no detectable difference. Does anyone have insight into the use of this sub-command? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT sub-command
Ron, By the way b a quick search of UV docs shows there is a NO.OPTIMIZE command documented in the SQLUSER.PDF of the UniVerse (pp 3-9) documentation. Apparently it disables the WHERE optimisation function. Maybe the developer just got the spelling wrong. Regards, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] callHTTP
Stu, I forgot to mention what you might expect back in the response and headers fields. The response will contain whatever the web service you are posting to/requesting from is programmed to respond with. In the case of a web service, for example, it will probably return an XML document. In the case of a web site it may return whatever exists at that URL eg html or possibly a zip or doc file for example. If you get something like this in your response, the http Headers should contain the mime type and other info about the document. Generally, it will then be up to you to handle and process the file with whichever tools you determine are appropriate. Generally I think most web protocols will do some form of ascii encoding (b64/uucp/etc) to ensure that the file is web safe. If you receive the file in this way then you have to uncompress/uuucp/b64 it. Otherwise, if the file is potentially binary then you need to handle it more delicately with UV as writes, for example, can munge the file. Also, the potential size of a file could be an issue. HTH Stuart Boydell From: Stuart.Boydell This shows how to post a simple (xml) purchase order to a web service - response contained in 'response'. program TEST.POST equ E.THIS.PROG to 'TEST.POST' equ E.URL to 'http://10.1.1.123/eprocurement.aspx' equ E.POST to 'POST:text/xml' ;*// note mime type is possibly optional sessionHandle = '' httpHeaders = '' httpStatus = '' postData = ' ns0:PO xmlns:ns0=http://HTTPRequestResponse.POSchema; ItemItem01 /Item Price500 /Price /ns0:PO' if not(createRequest(E.URL,E.POST,sessionHandle)) then crt 'return status=':submitRequest(sessionHandle,6,postData,httpHeaders,response ,httpStatus) end crt 'httpStatus=':httpStatus crt 'httpHeaders=':httpHeaders crt 'response=':response the:end Stuart Boydell ___ From: Stu Glancy Does anyone have any examples of using callHTTP to GET and/or POST. I'm in the early stages of figuring out how to use callHTTP and have had some success in being able to GET but it's only html that comes back. I need examples of GETting a file or POSTing a file. Any help would be appreciated. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Strange characters in XML output
Hmmm, I haven't seen anything like this but the L10 being appended looks suspiciously like a bad conversion justification that might be appending to the file name. I would check all the dictionaries involved in this listing, including @id, @, @select, any 'PH's and any other dict control items to make sure they aren't mal-formed. Stuart Example 1: LIST PERSONNEL.F BADGE.NO NAME DOB ID.SUP SAMPLE 10 TOXML ?xml version=1.0? ROOT PERSONNEL.FL10 BADGE.NO = 10 NAME = Martinez, Elizabeth DOB = 03/15/57/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Programatically changing the number of lines for a Wyse 60 emulation
Don't know if you can do 30 lines in native Wyse60 - only 24/25 or 42/43. If it's Wyse60 in an emulator (eg. NetTerm/Accuterm/Wintegrate/DynamicConnect et al) then there may be other specific calls for the emulator software. The command to change W60 to 42 lines is: ESC e * And back to 25: ESC e ) __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Grant [EMAIL PROTECTED] Sent: Friday, 3 November 2006 14:55 To: u2-users@listserver.u2ug.org Subject: [U2] Programatically changing the number of lines for a Wyse 60 emulation Hi Can anyone help me with the control characters necessary to change the number of lines for a Wyse 60 terminal emulation. The default is 25 and we need to change it to 30 and back again within a program. Thanks Anthony Grant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] How to create unix .netrc file?
Just wondering how to create a new unix file prefixed with a dot. I have tried: openpath b/home/acctb to ff then write x on ff,b.netrcb However, this creates b ?.netrcb with a question mark. Anyone know what might be a better way to do this? Thanks, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to create unix .netrc file?
Thanks - that's what I ended up doing. Stuart __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian [EMAIL PROTECTED] Sent: Wednesday, 4 October 2006 16:55 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] How to create unix .netrc file? I wanted to do something similar (allowing a user to edit their .profile record from within UV). What I ended up doing was using a file name without a dot and then using SH to execute a unix cp to change the file's name. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to create unix .netrc file?
Can you explain why it might be a breach of security to write a standard Unix file to your home directory? S __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb [EMAIL PROTECTED] Sent: Wednesday, 4 October 2006 23:28 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] How to create unix .netrc file? It's also a breach of security. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SBClient Question - Apply Logout Script to SBCLIENT
Angelo, From within SBServer, you can CALL TU.SESSION.CLOSE() from an exit verb which will close the session without a dialog. Or a script: Script Name: logout_script Trigger String: script_started Trigger Response: [exit_session(265)][script_end()] Assign this script to your logout script in the setup menu. This script apparently only works with the window close button or the file exit menu and so you probably need to use both methods to always suppress the close/save dialog box. I'm not sure if either of these will clean up your sessions/licences like SH.OFF (the normal logout method) does. Cheers, Stuart __ - Create script that will close out SBCLIENT session and not prompt end-user to save changes to session ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Slooooooow BASIC Verb
Stuart, you can replicate the slow BASIC verb? If so, what causes have you identified? Kevin, I think it occurs under windows too but can't check at the moment. Basically (excuse the pun) occurs when there is NO carriage return at the end of the last line. On UV/AIX . in a pc editor (Notepad.exe) typed following 3 lines: program test.compile.with.no.final.cr crt system(99) * last line - comment with no CR - the file stops here | Transferred it (ascii ftp) to a basic lib folder under unix. Then start to compile it and it stops until break key hit. Interestingly the following variation: crt system(99) end compiles but vlists without the final character of the line. Eg if last line is: 'end' = 'en' 'end ;* comments' = 'end ;* comment' Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Slooooooow BASIC Verb
From: Mark Eastwood I had similar problem once because ... put an extra CR (carriage-return) after last line of code; caused BASIC to hang. Original Message- I have a client running Unidata 5.2 on Windows NT and the BASIC verb is either taking several minutes to compile anything or it's hung. -- Sorry for the late reply... I can replicate this behaviour on *nix if there is NO carriage return at the end of the last text line (even comments) of a program. The native U2 editors all suffix a CR at the end of a program automatically whereas other editors (PC or *nix) may not. Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Debugging a program using distributed files causes core dump
Does the process continue through a program where the source file is pointing to the object file ... like the DF algorithm ... the debugger could maybe be trying to display or traverse binary where it expects source? Or through a program compiled with source symbols suppressed or raid suppression on or source code removed?? Just some random thoughts. Stuart Boydell __ This is our first experience with distributed files. While debugging programs that have selected the whole file I get core dumps sometimes when I tell it to continue. As long as I am stepping through the program I am ok, as soon as I hit continue it blows up. I can take the debug statement out and run the programs without them blowing up. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] UV/Net [not UV.NET] performance
...It gets even more confusing because I think the guy was actually talking about UV/Net - He's talking about SELECT performance which indicates he's talking about the remote file RCP protocol... See the second or third last para where he refers to UV / Net. Uodotnet probably doesn't even work with UV9.6. [or maybe it does]. Stuart __ Sent: Sunday, 10 September 2006 00:11 Sorry, John...I was confused reading your post. You asked about UV.NET while I spoke of mv.NET. Again, sorry for the useless response. :-0 -Original Message- The UV.NET documentation does say... Performance. You should expect some decrease in performance when accessing remote files with UV/Net. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help - UV intermittent roving file open error
Really? It's redimensioning in common here on UV10, aix, PICK flavour, no question about it. Exactly for the purpose of a file open subroutine used in hundreds of programs with hundreds of users... No complaints. I have even just written a test program which redims a vector in common and works. Although it seems logical not to be able to change a dimension in common, if common variables are just pointers to a memory slot then extending an array probably just means pointing to some non-sequential memory for the new dimensions (just a guess). Maybe there is some other flavour/uvconfig flag which affects this? Stuart __ Dimensioned arrays can be resized - BUT arrays defined in common can't. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help - UV intermittent roving file open error
Do you check/change accounts when you open files? Changing accts will probably cause issues. Check FILEINFO(). Also, dimensioned arrays can be dynamically resized b might also be helpful? SUB OPEN.FILE.SUB(FNAME,FVAR,ERR) COMMON /OPEN.FILES/ FNAMELIST, FVARLIST(1), LAST.ACCT $OPTIONS -STATIC.DIM ;* redimension array on the fly IF UNASSIGNED(LAST.ACCT) THEN LAST.ACCT = bb ;* check account b otherwise can screw up filepointers IF @WHO # LAST.ACCT THEN MAT FVARLIST = bb FNAMELIST = bb LAST.ACCT = @WHO END FIND FNAME IN FNAMELIST SETTING A THEN IF FILEINFO(FVAR(A),0) THEN ;* valid file handle b END ELSE FNAMELIST = DELETE(FNAMELIST,A) GOSUB OPEN.FILE: END END ELSE GOSUB OPEN.FILE: END ... RETURN OPEN.FILE: NEXT.POS = DCOUNT(FNAMELIST,@AM) + 1 DIM FVARLIST(NEXT.POS) ;* redimension array on the fly OPEN b b RETURN Stuart Boydell From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger [EMAIL PROTECTED] Sent: Friday, 25 August 2006 10:08 To: u2-users@listserver.u2ug.org Subject: [U2] Need help - UV intermittent roving file open error I have a little file open subroutine that I use in a lot of places to keep open files in common: Recently (within the last two weeks) I have started getting the following error: [SNIP] Program SB1: Line 6, Read operation failure. [EBADF] Bad file number Any suggestions will be greatly appreciated- perhaps the OPEN.FILE.SUB needs to be more robust? I suppose I could do a test read like READ XXX FROM FILEVAR,TEST ON ERROR after opening the file in the OPEN.FILE.SUB, but that doesn't really solve the problem and seems like a lot of overhead. OPEN.FILE.SUB is embedded in a lot of places and I really don't want to have to replace it with discrete file opens everywhere! ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Calling SB process from VB6
Martin, If you absolutely need to run an SB+ process, you can also use the SBCOM object b supplied with SBClient. Combined with a login script, this will handle login and environment setup for you. We use this component from a VB app to call some GUI screens, which works reasonably well and reliably. Examples are in the SBClient manual. Stuart Boydell I am trying to call an SB+ process from VB6 through Uniobjects. The problem lies in establishing a login to SB. Has anyone any experience of doing this? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LISTB (tab delimited output)
b LIST b TOXMLb generates XML that works pretty well with current versions of Excel (XP/2003). Stuart I have used ListB verb on Unidata (manage 2000) I have created a ListB verb on D3 (by adding a switch to the list verb) Is this feature on UniVerse? What it forms is output that is tab delimited. Creating an excel ready spooled file. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UODOTNET.DLL
Currently I only have 7149 in the GAC but you should be able to have another version alongside. This build came with Clients for UniVerse 10.1B, which is downloadable from IBM U2 - trials betas. http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-03 -31+14%3A19%3A42.178111RS_TACT=104CBW71S_CMP=s= Open your dot net framework config and load it into the assembly cache. (Thanks to David Cooper from Bluefinity for this tip) You just need to add UODOTNET.dll into the GAC on each workstation/system that uses UniObjects.NET. I'm not sure why IBM don't do this as part of their SDK install... Cheers, Stuart Boydell __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno [EMAIL PROTECTED] Sent: Wednesday, 12 July 2006 10:57 To: u2-users@listserver.u2ug.org Subject: [U2] UODOTNET.DLL Please forgive a quick post being made without appropriate prior investigation. I'm hoping someone will have a quick answer for what might otherwise take several hours of research. I'm told there are two versions of UODOTNET.dll: 2.1.0.7137 and 2.1.0.7149 Where can we get the new build? We may need this file for use with another project that was built with it. If UO.NET is managed code, can the two versions co-exist? I would assume so since this is one of the big benefits of .NET. If UO.NET is a big wrapper around COM (which I believe it is), then might there be a registration issue (DLL Hell) if the two cuts are loaded/running on the same system? Thanks! Tony, TG@ remove.thisNebula-RnD.com http:// we.really.dislike.spamNebula-RnD.com New blog postings: http:// remove.this.partNebula-RnD.com/blog --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] What is wrong with this OCONV?
Could I suggest you have a look at this program - it might do what you want: http://www.pickwiki.com/cgi-bin/wiki.pl?URLEncode Regards, Stuart __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton [EMAIL PROTECTED] Sent: Friday, 30 June 2006 03:20 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] What is wrong with this OCONV? I am tring to get Hex data back for a URL encode... What is wrong with this statement: X = OCONV(,,MX) X is being returned as , instead of the Hex Value of , - 2C What am I missing -- this seems fine on UniData - But UniVerse isn't working... 'Still a UniVerse Newbie'... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with SQL select
Is this a limitation on I-types in SQL selects? It would seem so based on your report. What does support have to say? Seems like... VAR support is next port o' call. Has anyone come across this problem before and is there a work around? I haven't, but I haven't tried large orderded SELECTs on four I-types. Alternatively, can someone suggest another way to do this using a single ReVise statement? You said you could do it in RetrieVe; are you sure you can't use TOXML with that? I've used TOXML with LIST in 10.0.4 Yes, sure. TOXML doesn't do BREAK.ON/DET.SUP which is required for SQL DISTINCT equivalence. Ta muchly, S ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv] Help with SQL select
Many thanks. Cheers, Stuart __ UniVerse SQL SELECT DISTINCT and RetrieVe SELECT ... SAVING UNIQUE ... (which are semantically identical queries) need the UniVerse parameter ALLOWMARKS=1 to work with medium-large queries. This parameter is set by default = 0. There is an enhancement request at IBM for documenting this behaviour (ECase 7837), as it has been stated to be permanent in UniVerse. The DISTINCT or SAVING UNIQUE clauses make the query engine internally building a B-tree in memory, but when a certain amount of data is to be treated, this memory is flushed into a temporary B-Tree file growing with the rest of the selected field concerned. By design, the Record IDs written into this particularType 25 temporary file are containing marks, thus the problem with the ALLOWMARKS parameter = 0. Hope this will help. Regards, Hervi BALESTRIERI Support Technique Avanci - Produits U2 ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Question about a dictionary item
Under very specific scenarios, something like this should work. But if the string 'COMBO YS' exists more then once, it will only retrieve the first value. And the syntax must be very consistent. 1 I 2 INDEX(@RECORD 999,COMBO YS,1);IF @1 0 THEN @RECORD 999[EMAIL PROTECTED]9,6] ELSE Use the vector functions IFS() and INDEXS() instead, then you don't have to worry about how often it occurs. 001 I 002 ifs(indexs(NOTES,'COMBO YS',1),fields(NOTES,' ',3),'') ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [uv] Help with SQL select
Hi, Ibm trying to get a unique list from a delimited field into an XML document. If I use a SQL bDISTINCTb select it aborts half way through. In ReVise it bwouldb be SORT FILE BY COL1 BREAK.ON COL1 COL2 COL3 COL4 DET.SUP ID.SUP except that I canbt use a TOXML clause with this statement. In SQL itbs b SELECT DISTINCT COL1,COL2,COL3,COL4 FROM FILE ORDER BY COL1 TOXML;b . But Ibm finding when I run this from TCL that this stops halfway through with an b Aborting!b error. All of the COLn fields are I-types which do a field() extract on a single delimitated attribute. (eg FIELD(@RECORD2,'/',2)). If I take out one of the columns or the DISTINCT clause in the SQL statement then it selects to the end of the table. If I add columns it aborts earlier. The ORDER.BY and the TOXML clauses donbt seem to make any difference. Is this a limitation on I-types in SQL selects? Has anyone come across this problem before and is there a work around? Alternatively, can someone suggest another way to do this using a single ReVise statement? This is on UV10.0.7/AIX, in an SB+ 5.0.4 account at real TCL. Thanks, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] .net and Biztalk - part deux
Bob, we enquired about doing this but were told that Biztalk (2004) is not really that well suited for real time web type interactions. It's forte is asyncrounous and long running transactions. The internal architecture of Biztalk relies on messages which are stored in SQL database. Sometimes these messages will be held up if the server is doing something else. It can be relied on for reliability but not for synchronous comms. We ended up having an IIS-U2 webservices which spin off messages to BT but doesn't go through BT to reach U2. However, there may be better handling for this type of synchronous architecture with BT2006. -- Stuart Boydell [EMAIL PROTECTED] wrote: - To: U2-Users \(E-mail\) u2-users@listserver.u2ug.org From: Bob Witney [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] Date: 22/06/2006 18:38 Subject: [U2] .net and Biztalk - part deux Many thanks to all who came back to me on this One last question has ANYONE out there ever succesfully connected to a websit to U2 via Biztalk to do Real Time XML exchanges? i.e - web - biztalk - u2 system - biztalk - web I know that it can do file transfers,I have seen the product and it has some nice functionality, but I am being asked to use it to do interactive messaging (a booking process) and from what has been said I don't think it will fit. Bob __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ___ ___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ * * This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. * * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UV] Formating a XML string
Absolutely! By using a stylesheet you can pretty-print your XML in U2 (see the UniBasic XDOMTransform() function - Google `pretty-print xml' and you will get a plethora of hints on how to do this). __ Does Universe have a software tool to format a XML string so that is nicely indented ? Ei from: ?xml version=1.0 encoding=utf-8 ? Foo FoobarXXX /Foobar /Foo To: ?xml version=1.0 encoding=utf-8 ? Foo FoobarXXX /Foobar /Foo ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ICONV 'DW' [was:UniVerse Internal Date Blackout]
Brian, your apology is graciously accepted ;-) To clear up the misunderstanding, the conversion and the rules should be consistent with ICONVing a month name. Use `DMA' instead of `DWA' in the sample program from my original post and you'll get the gist of it. As far as ISO conversion goes - here's a hypothetical question for you: If 2 book orders came in from the web each for 1 Da Vinci Code, you only have 1 in stock, which order gets priority? The one dated 2006-04-30T02:56:32+11:00 or the other dated 2006-04-29T11:56:32-05:00? That's right, you have to cut the book in half... even though one order was dated the 30^th and the other the 29^th they were raised at exactly the same moment in time (spooky music plays - camera pans to cryptic symbols ...) and have the same temporal priority. The fact that ISO date time is a recognised international standard and is used extensively in XML, is language and OS independent and that it DOESN'T separate date and time is actually something I wish Pick did better. It is functionality that IBM already have in other products and could easily incorporate into a U2. Cheers, Stuart __ Stuart Speaking of ICONV, anyone noticed that `DWx' conversions are fubar. Sorry to sound negative and apologies if I'm misunderstanding your gripe but.. How can you ICONV with a DW? Date conversions should ICONV to a specific date to be meaningful: if you want to convert a Monday - which Monday? This Monday, last Monday, nearest Monday, the first Monday (this year), first Monday ever? (give or take a couple of billion years). And if IBM did pluck one of those out of a hat, you can bet your bottom dollar half the people on the list would complain that it wasn't *their* interpretation. Some conversions just ain't meant to be reversible. This, along with my other gripe of not easily handling ISO standard dates (-mm-ddTHH:mm:ssZ) it seems like an That really stems from the fact that MVDBMS sensibly separate date and time: something I so often wish other languages did! You can get the date format using: D-YMD[4,2,2] Eg. LIST BOOK_SALES SALE_DATE CONV D-YMD[4,2,2] LIST BOOK_SALES SALE_DATE SALE_DATE CONV D-YMD[4,2,2] 09:26:16am 13 Jun 2006 PAGE 1 BOOK_SALES... Sale Date.. Sale Date.. 13660*37800*1 25 MAY 2005 2005-05-25 13512*63000*1 28 DEC 2004 2004-12-28 13715*54000*3 19 JUL 2005 2005-07-19 Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ICONV 'DW' [was:UniVerse Internal Date Blackout]
Gidday Ray, UniVerse has always behaved this way; ICONV(n, D) where n is a digit in the range 1-31 yields a date in January of the current year. It is even documented (at least in the source code) as doing so. Therefore, and on this basis, Iconv(n, DW) will ignore the W. In fact I think depending on your flavour, any 'plain' number will be regarded as an internal date. This is not at issue, however allowing the conversion of the literal string bWEDNESDAYb to the integer 3, or perhaps a date value which correlates with some significant Wednesday is. You can now convert bJUNEb to 1/6/2006 and I think that for consistency bDWAb [also DWB] should have similar behaviours to bDMAb. There's probably an argument for an enhancement request. In the meantime the product does allow for user-defined conversions (user exits), so you do have a workaround. Yes, I have asked for an enhancement request for ISO date/time handling which has so-far been rejected, but if enough people need it then Ibm sure theybll budge. Yes, I have a workaround - see pickwiki.com/cgi-bin/wiki.pl?DateUtility Regards, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ICONV 'DW' [was:UniVerse Internal Date Blackout]
Speaking of ICONV, anyone noticed that `DWx' conversions are fubar. For example, the `W' token gets ignored on ICONV and you can't reciprocally ICONV the day name of week as below using DWA. Also converting oconv/iconv using `DW' (leaving the `A'/'B' off) converts the day of the week to the day of January, current year. e.g. Tuesday gets turned into Monday 2^nd Jan where with the `W' token I would expect it to convert to maybe convert to the first Tuesday of the year. This, along with my other gripe of not easily handling ISO standard dates (-mm-ddTHH:mm:ssZ) it seems like an incompleteness to an otherwise excellent function. Stuart X = OCONV(DATE(),'DWA') Y = ICONV(X,'DWA') Z = STATUS() CRT X,'':Y:'',Z ;* = TUESDAY__1 X = OCONV(DATE(),'DW') Y = ICONV(X,'DW') Z = STATUS() CRT X,'':Y:'',Z,OCONV(Y,'DWDMBYL') ;* = 2_13882_0_Mon 02 Jan 2006 END __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod [EMAIL PROTECTED] Sent: Sunday, 11 June 2006 07:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Internal Date Blackout See http://www.pickwiki.com/cgi-bin/wiki.pl?Date_Conversion_With_ICONV for a discussion of how ICONV deals with wholly numeric external dates. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Locking Error (Maybe SB+, maybe UV)
1. Probably obvious but this I-trigger is running within a transaction so all item updates should be update-locked first (recordlocku, matreadu, readvu, etc). 2. Is there more than one i-trigger? 3. Is there an SB+ style index on your file? That may require other locks to be set manually. We have i-triggers on lots of different files that are fired from SB+ and non-SB+ routines alike. The only issue is when there's a basic program which updates one of those files using begin/end transaction and the i-trigger hiccups. I work around it by calling the i-trigger sub from within the transaction to compensate. (Hopefully IBM are working on that one). That's all I can think of off hand. -- Stuart Boydell [EMAIL PROTECTED] wrote: - To: u2-users@listserver.u2ug.org From: Charles Barouch Sent by: [EMAIL PROTECTED] Date: 27/05/2006 01:46 Subject: [U2] Locking Error (Maybe SB+, maybe UV) I'm getting this error and I don't know how to fix it. A full reboot hasn't helped: Program UPDATE.OI.GL.FROM.ORDER: Line 97, FATAL: The locks necessary for database operations at the current isolation level (0) are not held by this process. The program is a basic subroutine which is called by an index (this is an index trigger). I've recompiled the subroutine and rebuilt the index. The error line (97) is the MATWRITE command for the routine. When I trigger it from TCL it still works. When SB+ program triggers it, it fails with this errorr. It used to work everywhere. All help appreciated. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ * * This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. * * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
ED DICT FILE REC.COUNT 001 I 002 @RECCOUNT 003 004 Cnt 005 5R 006 S SORT FILE WITH REC.COUNT 2 N'es pas? __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen [EMAIL PROTECTED] Sent: Friday, 26 May 2006 05:16 To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Client interested in using Dynamic Connect with application software written with SBPlus
From: Kevin King I haven't explored DC, but I would like some clarification: There is NO WAY that DC can accept a download from the host, or simply that it's not supported with the TU... routines? Just won't TU - it has a reasonable ftp up/download client interface, kermit client AND kermit server, also x/y/zmodem, ascii (stream) screen dump, print screen to editor. There is some scripting ability available but I haven't looked into how far it goes regarding automating transfers. Stuart * * This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. * * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Globalization studies, relative to U2
Do you mean something like National Language Support (NLS) http://publib.boulder.ibm.com/epubs/pdf/25119180.pdf With NLS mode enabled, you can use UniVerse in various languages and countries. You can do the following: - Input data in many character sets (dependent on your local keyboard) - Retrieve data and format it using your own conventions or those of another country - Output data to a screen or printer using the character sets and display conventions of different countries - Write programs that run in different languages and countries without source changes or recompilation We need to provide currency translation in the near future, and eventually content localization. If someone has some links to read, or documents it would give us a leg up. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Client interested in using Dynamic Connect with application software written with SBPlus
I use Dynamic Connect in preference to SBClient. I have NO issues with it using it against SB+/UV in VT220 mode. It is less powerful than say, b Nettermb (another well-loved emulator I have used) but it is free and quite serviceable for the price! As others have mentioned, it wonbt do SB+ downloads, smart client, tu.xxx routines and their ilk but it does have some SB+ smarts for printing boxes and the like. Setup: In SB+ in the terminal definition screen (/TERM.DEFN), start by creating a new emulation by copying one of the Wintegrate emulations supplied with SB+. Make sure the OE Term type is vt220 and PC Terminal type is set to 2 (aka Termite mode). This will give you a good colour emulation right off the bat. In the Setup /Terminal dialog of DC make sure that you have the sb and sb_keys extensions highlighted. Cheers. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Lynch [EMAIL PROTECTED] Sent: Friday, 19 May 2006 03:09 To: u2-users@listserver.u2ug.org Subject: [U2] Client interested in using Dynamic Connect with application software written with SBPlus Folks, OK, before anyone asks if I am insane, my first response to the client was in the negative because SB Plus and SBClient are a team - even having different versions can cause odd behaviors, especially in things like downloads and email. But the client is both persistent (Dynamic Connect is, after all, free!) and not good at giving details, and she wants a recommendation on terminal emulation because she is having trouble with determining a good setting. I told her vt220 was probably her best bet, since that is what we use in SBClient. However, I am asking here in case someone else has already been down this road, and can give me some guidance on what issues she is likely to encounter. (And yes, I know there is an sbsolutions list, but this list seems more likely to know Dynamic Connect...) Eagerly awaiting your ingenious workarounds and 'war stories'... Thanks in advance! Susan M. Lynch F.W. Davison Company, Inc. Confidentiality Notice: This e-mail message and any accompanying documents is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, distribution, or copying is prohibited. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT FILE Depth and Assoc
John, Yep, I think you're probably right about A-types being inherently MV. According to the documentation I mentioned before (which you read of-course ;) the S/M in an `A' type dictionary is only relevant to SQL statements and not Retrieve. So unless your front-end can interrogate the DICT and do something with the value in attr 5 to build specific WHEN expressions, I would go with the previous suggestion and convert them to D and I types, they're heaps (a quantum) more functional. FYI - LIST DICT uses an I-type to interrogate the dictionary field; if you're brave (!!)) you can change this in DICT.DICT to report anything you like. S __ From: John Kent if you make either on of these S, LIST DICT still displays the depth and assoc as M not S On what does it base this decision. It looks like Universe assumes all A types are inherently multivalue. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT FILE Depth and Assoc
John,
If Design Bais is riding on the back of SB+ field definitions then you
may be able to use D/I types. SB+ can be set to create and maintain D
I types by setting DMCONT SB.CONTROL34,1 = 1 ([EMAIL PROTECTED]34,1).
At last look there was a bug in the UV version of SB.FD.S regarding
setting the S/M field for I(function) type derived fields. Maybe
they've fixed it. I just wrote a quick/dirty wrapper for SB.FD.S which
handled it.
0001 subroutine SB.FD.S
0002 * wrapper to 'fix' SB+ I(function) derived fields not setting S/M
field correctly
0003
0004 include DMSKELCODE COMMON
0005
0006localParam = PARAM
0007localKey= KEY
0008localValue = VALUE
0009localRecord = RECORD
0010localFile = F.FILE
0011
0012 sbFDS = '*SB+.DEFN*SB.FD.S' ;*// globally catalogue original
SB+ subroutine.
0013call @sbFDS
0014
0015 if SB.CONT34,1 = 1 and localParam = 4 and
localRecord8[1,2] = 'I(' and index(localRecord2,'M',1) = 0 then
0016 recordlocku localFile,localKey locked return
0017 writev 'S' on localFile,localKey,6
0018end
0019
0020 return
__
Stuart,
it just so happens that Design Bais will convert D types to A types
when
you modify anything that is not confined to their extended dictionary.
Maybe System Builder does the same thing ?
Hence you can end up loosing certain dict info such as S/M, SQL
settings and
Value marks in the headings.
Even though i came from a pick background i prefer D Is so i am not
happy
about this and would prefer the original dictionary type be
maintained.
Hopefully this will be addressed but in the meantime if its an issue i
can
create a separate dictionary but it means you have to be careful in
accounts
that are not primarily DB.
jak
**
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support
Centre (+61 3 9269 7555) immediately, who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer related viruses.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT FILE Depth and Assoc
You can use attribute 4 and 5 of the dictionary (UV System Description pdf pp5-20 for complete details) or use the Retrieve keywords MULTIVALUE and SINGLEVALUE at TCL to override default behaviours. Cheers, Stuart __ Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M Knowing this can be useful when combining dict items with a WHEN via a front end ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unit testing and UniObjects for Java
Mainly using Nunit for .NET but this is derived from Junit. Highly recommended *. http://junit.sourceforge.net/ From: Wendy Smoak I'd love to hear how you're unit testing your UOJ dependent code. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML processing
I had a similar thing happen, we were getting some accented characters ( 7F/127) and the parser would jerk to a halt (sometimes). Our issue was that the XML was actually written in iso-8859-1 encoding but the encoding element in the XML said UTF-8 ?xml version=1.0 encoding=utf-8 ?. I think the way it works is that UTF-8 expects -007f characters to be single byte for ASCII compatibility and after that as double byte. Mostly this is fine if all the characters are under 007F (127). In this case, when the parser got to the accent character it would throw it's hands in the air (like it did in fact care) saying okay - you've told me it's utf-8, but then when I read this character that should have another byte with it, but it doesn't - what is going on!? Check that your encoding, element is correct. If the encoding element says UTF-8 and the text is actually ASCII then the parser may be having difficulty when it sees an over 127 character and thinks that the text should be Unicode. Try changing the encoding to ISO-8859-1 (or something suitable) and see what happens. Stuart __ some instances where particular elements have foreign language characters in (over char 127). This seems to be giving me a segmentation faults in the open stage, if i use an EXT that tries to extract data from that element or any elements after the element in question. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] GOSUB variable-name?
The purpose of this type of indirection is (or should be) both business and
application related. It's a methodology which helps cohesion (understanding
the problem). I don't see why you should have separate methods for the
business logic from the programming mumbo jumbo.
For example if you pass into a program a description of something you want
it to do, CALL SomeProg('GetCustomerBalance',...) that is business related.
Now if by CALL SomeProg('PaintScreen',...), that is programming mumbo
jumbo, either way, whatever happens within the scope of that call 'is' a
black box.
By using descriptive method arguments it creates cohesion, where you can
pretty much understand 'what' a component does but don't have to know 'how'
it does it (as long as it's working) without having to take the lid off it.
The conversation here has just been a debate on whether a program
could/should branch to a label with the same name by compiler or by
construction. Then if by construction, how do you do it. I don't think
there's any real disagreement in the wider computing world about the
soundness of the methodology, viz object methods. Generally this type of
interface is called dynamic dispatch and it's a widely used and respected
method.
Stuart
It is always wrong to specify directly in a calling program which branch
the
execution should take in a program that is called. It does not matter
whether it is using GOSUB @variable or CASE statement. It is also wrong
to
pass into the called program the information from where it is been
called. \
Each parameter passed inside a program should have a business-related
meaning, not programming jumbo-mumbo.
**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this email in error please notify the Spotless IS Support Centre (+61 3 9269
7555) immediately, who will advise further action. This footnote also confirms
that this email message has been scanned for the presence of computer related
viruses.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [sbs] UniObjects and ASP
SB+ related how? Try posting this to the U2 Users group ... though you might be better off with an IIS forum. Goodluck, Stuart __ From: Barry Whitfield Sent: Friday, 10 February 2006 21:05 To: [EMAIL PROTECTED] Subject: [sbs] UniObjects and ASP I have recently developed an activeX control in VB6 which uses UniObjects to establish a portal from an ASP website into our UniVerse data bases. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SB directory files
Anybody ever run into a problem with SB+ being unable to read directory files, Type 1 19? No problems here, SB+ 5.0.4/UniVerse 10.0.7/AIX 5.1. Type 1 and Type 19 files, a mixed bag of delimiters (think of a character between 0 and 255 - it's probably been used). What specific problems are you having? Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: XML Issue - 'ISO-8859-1'
The standalone attribute is unrelated to the encoding attribute and tells the parser that a DTD is required or not. The attribute is optional and if you aren't using a DTD, leave it out. If you don't know what a DTD is then you probably aren't using one - they're a way to validate the structure of an XML document but they're becoming less common these days and have largely been replaced by xml schemas (.xsd). Also, be aware that UniVerse without NLS uses an ISO-8859-1 based character set. For example, XML documents generated by UniVerse which included a character greater than char(128) (eg Cafi blend coffee) will be misinterpreted by most XML parsers if the encoding attribute is set to UTF-8. Try using the following header: ?xml version=1.0 encoding=iso-8859-1? __ From: Nancy Fisher I tried to look up what standalone means - but didn't really get it. I wondered if it meant it wasn't using mapping? * * This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. * * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: XML Issue - 'ISO-8859-1'
Hmmm, encoding problems... that should have been cafe with a char(233) (e-acute in courier font). S __ From: Stuart.Boydell Also, be aware that UniVerse without NLS uses an ISO-8859-1 based character set. For example, XML documents generated by UniVerse which included a character greater than char(128) (eg Cafi blend coffee) will be misinterpreted by most XML parsers if the encoding attribute is set to UTF-8. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Vlist Header Information
Does anyone know another way to get the header information from the first 10 or so lines of a vlist? (other than by using a vlist). Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Vlist Header Information
Thanks Gyle, very good stuff. Stuart __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gyle Iverson [EMAIL PROTECTED] Sent: Wednesday, 1 February 2006 15:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Vlist Header Information Does anyone know another way to get the header information from the first 10 or so lines of a vlist? (other than by using a vlist). Hello, Stuart. You can use the SRS.UV.HEADER subroutine to get at all the header information shown by VLIST and much more. The SRS.UV.HEADER source code may be downloaded from http://www.srs4uv.com/srs_uv_header.htm. Hope this helps. Best regards, Gyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Separate catalog space 2 instances of Unidata installed
From your sig I presume you are going to be running under Linux; UV at least, works under virtualisation, eg VMWare or Xen, to allow many separate virtual machines running UV on one physical box. We are in the midst of setting up one single user (or low user count) virtual machines for each of our developers and several various test VMs all on one low cost SUSE box using Xen. Everything is under source control, everything gets backed up, new VMs are instantiated in a few minutes. Our production systems are on a separate physical machine. Cheers, Stuart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Pflueger [EMAIL PROTECTED] Sent: Thursday, 19 January 2006 22:00 To: U2 User Group Mailing List u2-users@listserver.u2ug.org Subject: [U2] [UD] Separate catalog space 2 instances of Unidata installed Hi, We are in the early planning stages of building a new dev/test box and would like some feedback on how best to setup Unidata with 2 instances (devtest) with separate catalog spaces as an ultimate goal. Is this even possible on the same box? Oh, and we're planning to goto Unidata 7.1.0 on this new box as well which will run Solaris 8. I was hoping someone out there has done this and could send some simple procedures on how to make this happen...or should I just RTM as I haven't honestly done that yet. :-) Thanks in advance, Andy Pflueger Application Developer Ivy Hill - Louisville, KY -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UNiOLEDB
I'm wondering what peoples experience of using UniOLEDB is. General impressions, is it reliable? Does it run in unmanaged code? How about the CALL interface, does it work okay from the .NET framework? Does the standard ADO.NET pooling work okay with it? Are there any gotchas that have come up? Thanks, -- Stuart Boydell [EMAIL PROTECTED] ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] re: [u2] DCOUNT
Haven't seen anyone mention vector functions here. Do many people use them? In situations where you are performing identical operations on every value in a dynamic array, I rekon vector functions are a more efficient way of handling multivalues then dcount/loop constructs. A simple example of adding 1 to every attribute; instead of: max = dcount(var15,@vm) for i = 1 to max var15,i += 1 next you use: var15 = adds(var15,reuse(1)) Cheers, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MS XML Import to UD
Hi Don, I'm not sure that there's anything non-standard about MS generated XML. On the whole MS seem to adhere pretty closely to the w3 standards they helped to write. Are you referring to the xxx:yyy format of the elements? The issue I think you are finding here is that the elements are defined using namespaces, this makes elements appear as MyNamespace:ElementName unless the default namespace is used, which makes elements look like ElementName ... Namespaces become VERY useful when you start combining XML documents, for example, if you embeded an XML document inside another XML document, you might find that without the use of namespaces, some element names may clash. Using Namespaces you are assured that clashes are highly improbable. See w3.org for more info about namespaces. The Uni xml parser error is declaring that it couldn't find the namespace definition for rs in the XML document you have supplied. A namespace definition will look like: xmlns:rs=urn:schemas-microsoft-com:rowset It could be defined only once or many times, in any element above or including the rs:data element and look something like... rs:data xmlns:rs=urn:schemas-microsoft-com:rowset. There will probably be another dinfination [lol] for xmlns:z=#RowsetSchema So, firstly, have you got the namespace defined in the xml document you are parsing? If not try adding it to the document and see if that fixes the issue. HTH, Stuart -Original Message- From: Donald Bridges Sent: Thursday, 8 December 2005 10:59 I am working on an import to bring a XML file from Microsoft Access into a UD account. The problem I have encounter is ... When I run the list command on the resultingdatasetusingthe .ext file with the line start=rs:data/z:row dictionary=D.CLIENT.MASTER null=EMPTY/, I get a error message XMLParser error message: U2XMAP/U2XML_extraction: Cannot find the dinfination(yes, this is correct) for NameSpace rs. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MS XML Import to UD
Gidday Kevin, I don't have any other suggestions; namespace parsing is working fine here with UV (10.0.7). Good luck, Stuart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King [EMAIL PROTECTED] Sent: Thursday, 8 December 2005 14:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] MS XML Import to UD Stuart, Don sent me the file yesterday as a quick review and the namespace definition is there. It doesn't look like Unidata's doing anything with it tho. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unix to SQL Server
We're using the SQLXML IIS interface to update our data warehouse. This is SQL middleware if you like, but comes with MSSQL-2k. Nothing to install on UV, we run stock standard UV basic programs using the Http and XML basic functions to update and retrieve data. Stuart -Original Message- Subject: [U2] Unix to SQL Server I know I'm probably going over old ground again, but what's the present state of play for UniVerse on HP-UX connecting to SQL Server on w2000/2003 to update tables ? Do I need middleware ? If so, what is recommended ? UV10.0.16 HP-UX 11 ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] submitRequest
What's the value of RESULT? Is the request POST or GET? Are you using SSL? Have you tried increasing the timeout? Stuart -Original Message- RESULT=submitRequest(RHANDLE,6000,,RHEAD,RDATA,RSTAT) RHEAD, RDATA AND RSTAT are always null (empty). Any thoughts or ideas would be incredibly appreciated. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] How to read a post [was: how to find records with a in the data]
Seems this post is causing some reading difficulties. An advantage I find of trimming posts when replying is that I often manage to read the original post to the very end; ADD notwithstanding... 8-} Stuart -Original Message- SEARCH FILENAME prompts STRING: and you enter Kathy Tymoczko wrote: ESEARCH does work, but we thought we should be able to do this somehow with SELECT. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Double Indexes
UV _should_ optimise 2-up secondary index selections (Glenn put a really good whitepaper on the list about indexes once - I can't find my copy now), use LIST/EXPLAIN to see if your indices are in use... My 2mil record test file uses 2 indices without a struggle returning a result in about a second or so. LIST SUPPORD IF REC.TYPE = O AND IF ORD.DATE = 11/04/04 EXPLAIN Single-variable predicates processed in index: F6 = 'O' AND F3 = '13251' Optimizing query block 0 Driver source: SUPPORD Access method: select list 0 with 249 ids UniVerse/SQL: Press any key to continue or 'Q' to quit -- Or try MERGE.LIST to see if that improves performance: SELECT FILE WITH DATE = 10.18 TO 1 SELECT FILE WITH CUST = 12345 TO 2 MERGE.LIST 1 INTERSECT 2 [EMAIL PROTECTED] wrote: - To: From: Mark Johnson Sent by: [EMAIL PROTECTED] Date: 21/10/2005 13:50 Subject: [U2] Double Indexes I'm wondering if a UD or UV system behaves similarly to a D3 problem I see. File contains 6,000,000 records. First field is DATE and 2nd field is CUST. Both are INDEXed. SELECT FILE WITH DATE = 10.18 quickly returns 11,000 items CLEARSELECT SELECT FILE WITH CUST = 12345 quickly returns 180,000 items CLEARSELECT SELECT FILE WITH DATE = 10.18 AND CUST = 12345 takes forever as if the indexes aren't there. I don't know if the double test in the SELECT statement ignores the INDEX on either (or the first) or is encumbered by taking the 11,000 quick DATE items and then hashingly goes through them looking for CUST. If I try SELECT FILE WITH DATE = 10.18 then SELECT FILE WITH CUST = 12345 it still takes longer than I would expect. Is a double INDEX a strange animal. Does U2 support indexing virtual fields, ie DATE.CUST? I don't think D3 can. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV][OT]Embed command in CSV file?
From universe, I am creating a sequential file which is formatted as a CSV [snip] ...does anyone know if it is possible to embed some kind of command Barry, no, it's not possible in csv, closest is to embed a formula. However, if your users are on Office 2003, you might be best off creating your document as XML where you will have access to complete (Excel) control over your document. If they are on earlier versions of Excel then creating your document as HTML will give moderate control over the format of the doc. HTH, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Strange $INCLUDE problem
UV is 31 characters - they'd have to be long common names for that to be the cause of Bob's issue. I was thinking it's more likely that some interaction between the first and second include and the IF THEN / END to be the cause or, as someone suggested, there's not enough carriage returns at the end of the (1st or 2nd) include item. S -Original Message- From the Unidata basic manual: /common.name/ Specifies a name for a named common variable. common.name can have any valid variable name no longer than seven characters. Default (no common name provided) stores the variable in unnamed common. Bob, your two common areas will be treated as one I think. Bjvrn Eklund ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] AIX COPY TO SAMBA DIRECTORY
Charles, Is there a reason you don't want to use uvbackup? The answer to your question about copying is easy but, from your description it's not an optimal way to achieve what your management are apparently asking for. Using COPY will not give your backups ANY integrity and will possibly will get you into more trouble and give you more headaches than using the tools that are already in U2 and designed for doing backups. Good luck, Stuart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 18 October 2005 07:45 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] AIX COPY TO SAMBA DIRECTORY Is there a way to create a text file from a Universe database to a SAMBA directory? I have tried the COPYI FROM PRODUCT TO CONV.DATA/CUST.TXT but this does not work since the CUST.TXT does not exist. I want to copy selected Universe files to text file so that these can be burned to CD-ROM for an offsite storage. Management is clamoring for redundant backups and media in wake of Katrina and Rita storms. Any suggestions? Garry Smith Dir. Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes - iconv
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid
[EMAIL PROTECTED]
And the last can swing both ways:
iconv( 20051013, DYMD[4'',2'',2] ) = 13801
The last conversion is also kinda default (at least in uv) :
iconv( 20051013,D4) = 13801
and
iconv(051013,D) = 13801
and I think that:
iconv( 20051013,D) = 13801
though ISO8601 requires iconv formating : iconv('2005-10-13','dymd') :
at least when DATE.FORMAT is ON
--
Stu
**
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support
Centre (+61 3 9269 7555) immediately, who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer related viruses.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Stuart Boydell is out of the office.
I will be out of the office starting 14-10-2005 and will not return until 17-10-2005. I will respond to your message when I return. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
... 0007: dwambyl[, ,,2, ] ... Also, see Ray Wurlords article: http://www.pickwiki.com/cgi-bin/wiki.pl?Date_Conversion_With_ OCONV -Original Message- From: Rick Ward I'm trying to output a nicely formatted date (eg, Wednesday, Oct 12, 2005), and I've tried doing it via date conversion codes in dictionary field 7. I can get ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse/Windows and VMWare {Unclassified}
Michael ,
Yes is the answer, we've be trialling UV (10.1.12)/VMware and also
with SUSE/Xen. Both of which work/play with UV just fine (so far).
We are setting up 'single' user development environments for each
developer and a floating number of test environments. We currently
have 3 of these running simultaneously but figure we will stretch that
out to about 15 on our hardware platform.
Xen is interesting but as yet doesn't overtly support Windows. VMware
is probably simpler to manage and at this point has more configuration
options.
Also note that Microsoft are rejigging their licencing for virtual
images of their OSs to make licencing more practical
http://www.arnnet.com.au/index.php?id=314305239eid=-100
Cheers,
Stuart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON
MIKE, MR [EMAIL PROTECTED]
Sent: Wednesday, 12 October 2005 12:11
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse/Windows and VMWare {Unclassified}
Folks,
We are considering a server consolidation exercise, particularly
for our
Development and Test environments, using VMWare to provide several
'virtual server' environments on a single physical box. One part of
this proposal is that my UniVerse Development server will become a
virtual server image on a box shared with up to three other virtual
servers.
This development server is currently running UV 10.0.15 on Windows
Server 2003, and will soon (I hope) be upgraded to 10.1.11.
I have no worries at all about hardware capacity, our dual
P-III/933 1GB
RAM system hardly ever gets very busy (unless we accidentally code
a
hard loop!), and the replacement system will certainly way
outperform
that with a couple of dual-core Opterons or Xeons, masses of RAM
and a
bunch of 15000rpm disks.
What I am a little concerned about is whether UV will 'play nicely
with
the other children'
Has anyone got any experience with running UniVerse under VMWare?
Are there any traps to beware of, or do you have any tips you could
pass
along?
Thanks in advance
Mike
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/
**
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support
Centre (+61 3 9269 7555) immediately, who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer related viruses.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OPEN vs TRANS + Vector
Wow, thanks! and caveat heeded. Vectorally (and RTFM) challenged, Stuart -Original Message- From: Stevenson, Charles Vectoring (is 'vector' a verb?) is built into TRANS already. No need to abandon in favour of OCONVS T-correlative. You can specify a dynamic array of IDs for the target file to read. I have used the Translate code with OCONVS() function when it is stylistically in keeping with the use of vector functions around it and only because there isn't a vector version of TRANS(), but personally I wouldn't use it outside of that situation. custProductIDs = splice(reuse(custId),'*',productIds) instead of / as well as this: prices = oconvs(custProductIDs,'TCUST.PRODUCT;X;;99') this works fine (even better I think): prices = TRANS( 'CUST.PRODUCT', custProductIDs, 99, 'X' ) But a caution: If CUST.PRODUCT 99 is multivalued /or sub-valued: * T-correlative converts all delimiters to spaces when OCONVS returns. (consistent with PICK.) * TRANS will lower the returned delimiters. (almost consistent with PI.) - if called from Retrieve, the delimiters are lowered enough to keep the association with the dict equivalent of custProductIDs which might be multi-SUB-valued or even have TMs or lower. - if called from Basic, not that smart, just lowered once, so you might lose the association with custProductIDs. The above for UV. Mileage for UD may vary. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] the 4 letter word
I'd say it's more like collecting cigarette butts out of rubbish bins, wrapping the tobacco in old fish and chip paper and inhaling deeply... If you're an indigent nicotine addict, it's still satisfying, you get your hit no matter what and you don't care if anyone tells you otherwise. ;-) -Original Message- The-command-that-must-not-be-named is like a fine cigar. You know you shouldn't. You know it's bad for you. Nonetheless, it's satisfying when done right. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsing XML
Tony, I'm interested, why not just use xslt to convert the XML directly into a U2 string and then pass in the data using uodotnet subroutines. Is there some advantage in using an extra step of converting to ADO? Stuart -Original Message- It's very easy to create/parse XML with .NET technologies. If you have a schema then you can read an XML document, convert it into an ADO.NET dataset in one statement, then you can push it into U2 very easily after that with mv.NET or PDP.NET. UO.NET would take more work because it does not have robust (any?) ADO.NET dataset manipulation capabilities. (Need to recheck that sorry.) If you don't have a schema then one can be inferred from the data but it may not be as precisely defined as it would if you had a schema. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fw: More U2 programming hints
... the next question I'd ask is, can I use an index?. Yes? External select. No? Internal. or use the basic SELECTINDEX statement. Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Universe and .NET
Nick, We do something similar, have a look at COM+ object pooling (google/msdn). You can start up a configurable number of sessions (setting common) and call them from managed classes as required. When processing is quiescent for a set period of time, the sessions will close. We're using this method to provide connectivity between our ASPX and BizTalk services back to UV. We don't have any patches (that I know of on uodotnet) and throughput is adequate (At least bettering the previous homebaked UV to UV socket transfer service we were previously running for speed, manageability and reliability). We have a ping process which returns a time from an initial ASPX call, opening or activating a session and calling a UV subroutine to the final genration of the response message. The first time takes 3-5 seconds, after that around 300ms. Also, I believe a future release of U2 will have support for session pooling built in. Regards, Stuart -Original Message- From: Nick Cipollina The reason that our current processes are so fast is that we read as much common data as humanly possible into memory at start-up so there is little overhead while the process is running. If I have to call a subroutine from .NET, that would actually slow processing down. I need to get the data into .NET's memory to do something similar. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Integrating .NET and UniVerse 10
Not any of the below but we're using Uodotnet with Com+ object pooling for web services (via ASP.NET). Quite satisfactory. Stuart http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cossd k/html/954cf9ee-e76c-4faf-99aa-3648a7bb8a59.asp -Original Message- From: Simon Jackson Hi All, We are looking at integrating our UniVerse 10 system with applications written in .NET, particularly ASP.NET. We are currently evaluating five mechanisms for accessing UniVerse data: * UVODBC * RedBack * PDP.NET (http://www.rainingdata.com/products/connect/dotnet/index.html) * MV.NET (http://bluefinity.com/) * UniConduit (http://www.conduitit.hostecom.com/Products.htm) Does anyone have any experience with these products that would be useful for us to know? Thanks. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Capture Error (UV 10.1.7, AIX 5.2)
After looking again, I'm not sure that the UVTMP items suffixes (capture9xx) relate to the file creation time??? I had a look at some of ours and had a rethink about how they are generated. They look like time stamps but don't appear to relate to the creation time of the files. Maybe whatever algorithm they're using (something like rnd(time()) ??) to generate the suffix... maybe they should be using guids instead. Stuart -Original Message- From: Ray Wurlod Now then, this would be a design flaw (IBM, are you listening?). I wonder if the SS.THTT method of keeping time could be applied here... (where SS.THTT = SecondS.Tenths,Hundredths,Thousandths,Ten-Thousandths). The two letter sequencer on the end is supposed to be the mechanism for avoiding duplication. This should be aa, ab, ac, ... ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Manipulating numbered select lists
I have an executed SELECTion statement where the criteria exceeds the TCL line buffer length. In this case selecting on hundreds of branches (indexed) and a couple of other (indexed) criteria :: SELECT TRX WHERE BRANCH = 000100020003... So I have experimented with breaking up the selection (in a controlled loop in code) and using MERGE.LIST to build up my selection aka Hammurabi... SELECT TRX ..limited branches.. TO 1 SELECT TRX ..limited branches.. TO 2 MERGE.LIST 1 UNION 2 TO 1 SELECT TRX ..limited branches.. TO 2 MERGE.LIST 1 UNION 2 TO 1 ... Which leaves me with a select list in numbered list 1. I would then like to move that to list 0. The only way I have found so far is either: 1. SELECT TRX FROM 1 - which takes a longish time. Or 2. SAVE.LIST TRX:PORT FROM 1 @AM GET.LIST TRX.PORT - which seems messy. Anyone know a more elegant way of doing this? Cheers, Stuart -- Stuart Boydell Spotless Limited +61 03 9269 7398 +61 0411 150 246 [EMAIL PROTECTED] ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVTMP items [was:Capture Error (UV 10.1.7, AIX 5.2)]
Interesting, I think we might be getting flack from a similar thing occuring with transaction processing. We have processes running from phantoms that update within a basic transaction (potentially lots of thesetransactions happening simultaneously). They generate cache9xx items in $uvtmp. These cache items hold the copies of the items being updated in the trx. Occasionally we will get locks from a prior transaction reinstantiatingthemselvesinthelock table, and it seems the transaction has referenced a pre-existing cache artifact. I hadn't looked very closely at the ID and had presumed they were 'pid' based but realise now that they are 'second' based which is a very coarse granularity. I have IBM looking at this now. Are you able to confirm the sequencer bug or is it just a theory? (UV 10.0.7/AIX) Cheers, Stuart -Original Message- From: Ray Wurlod Generating the same capturebpaa file name ... and there's a bug that stops the sequencer (aa, ab, etc.) from doing its thing?) ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Listserver is Bowdlerising my posts... help
I have tried plain text - but even that gets chomped (sometimes) S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 9 September 2005 01:32 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Listserver is Bowdlerising my posts... help Set your email program to send plain text only. Most mail group admin programs don't like MIME/HTML emails. HTH, Karl Hey, Can somebody do something about this please? -- Stuart Boydell Spotless Limited +61 03 9269 7398 +61 0411 150 246 [EMAIL PROTECTED] ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Listserver is Bowdlerising my posts... help
Hey, Can somebody do something about this please? -- Stuart Boydell Spotless Limited +61 03 9269 7398 +61 0411 150 246 [EMAIL PROTECTED] ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Trigger on a dictionary
Anyone know how to (neatly) add a trigger to a dictionary? create trigger blah after insert or update or delete on DICT FILE for each row calling *blah; UniVerse/SQL: DICT Unexpected Apart from maybe creating a temporary voc entry to the D_FILE not sure how to do this. Regards, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Undefined Vars
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Undefined Vars
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Real Trigger vs. Kludgy Trigger via an Index
Well, for raw speed the kludgy i-type index method is faster, however, for reliability and the ability to know when the trigger was fired (before/after, update/insert/delete) you will probably need to use the file trigger mechanism. As someone raised in an issue recently, triggers run in a transaction (which of course, doesn't allow you to run the debugger through it). However, it should be simple enough to create a test interface for your trigger program before you apply it to the file. Personally, I think there are definite advantages to running triggers within a transaction (opposed to i-type updates that IIRC won't allow it). One being that any associated updates/deletes are managed as a single update, so all updates are synchronised and/or if your trigger decides that the update can't or shouldn't be happening, then it can roll back all changes automatically via the transaction mechanism. Stuart. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Stanley [EMAIL PROTECTED] Sent: Tuesday, 2 August 2005 10:02 To: u2-users@listserver.u2ug.org Subject: [U2] Real Trigger vs. Kludgy Trigger via an Index Before UV supported real file triggers, we used a kludgy way of doing it by creating an index on an i-descriptor dictionary, which then called a BASIC program to do our 'trigger stuff'. Does anyone have any input on what would now be faster? The real trigger or the 'index' trigger? I'm probably being lazy, because I know how to setup the 'index' trigger, but haven't yet ever tried the 'real' trigger. It would be worth it if I thought performance would be significantly better. Thanks. Robin Stanley Paciolan, Inc --- 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] Connecting SQL server from Universe
Read or update? Doesn't matter, my experience is using SQL XML on SQL 2K. We use http from UniVerse to update MSSQL with updategrams (an MS term). It works well, no need to install anything that wasn't already installed. Works across port 80 /or 443 through our firewalls. Not as fast as but reasonable performance compared with ODBC et al. Convenience overrides. You need MS SQL 2000 with IIS configured with support for SQL XML. On the UV side we just use 'EXECUTE LIST ... TOXML CAPTURING XML.UPDATE.DATA' to generate the XML updategrams but I understand recent versions of UV have improved support for generating XML in basic. There are risks using that method as large amounts of data in the capturing variable could blow your workspace. You can also use IIS SQL XML support to read (XML) data from MSSQL. Regards, Stuart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yang, Songying, JIMS [EMAIL PROTECTED] Sent: Tuesday, 26 July 2005 02:04 To: u2-users@listserver.u2ug.org Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Uvnetd error
We're getting an error message on a newly built windows machine when trying to connect from aix using remote files. uvnetd: EURO functionality enabled on remote machine. This seems familiar but indexinfocus is not up at the moment and I can't remember what this related to. NLS is not installed and the CONFIG setup looks the same as the dev machine... Anyone have any ideas? UV 10.0.4/Win2k UV 10.0.7/aix Cheers, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] mu2sings
Whilst I ponder on a version of UV that doesn't really support system(9001), I was just musing that it's counter intuitive, not to have any form of reflection available in UV. People have already mentioned how useful it would be to have internal subroutine indirection eg. mySub = 'blah' gosub @mySub I was also thinking how useful it would be to have an @ variable or some such that told you what the current program name (c.) was. eg. subroutine blah open file else stop @program:' file open fail at line ':@currentline Also a function, like SetDiagnostics(), that will throw an exception WITH a return message for UOJ/UON would also be nice... Cheers, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] How does UV authenticate to Windows
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] How does UV authenticate to Windows
Alternatively, anyone can loginto the UV account using the UV Shell without any authentication whatsoever. Please explain, exactly, how do you get to the server desktop to open a shell command without authenticating? Cheers, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] How does UV authenticate to Windows
This question came up on our SOX audit. Specifically how does UV authenticate a user to Windows at login time? U2 hopefully use the standard Windows authentication api. I doubt they would have use a home-made or otherwise non-standard module as it would probably break between MS security patches. In later versions of U2 there is also the option of using SSL. Details of the api can be found on-line here. http://msdn.microsoft.com/library/en-us/secauthn/security/using_authentication.asp Cheers, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Virtual OS environment for UV
I'm interested to know if anyone is using virtual environments to run UV - eg Virtual PC under Win or LPAR under Aix etc. We are thinking that this may be a good way to effectively replicate the live environment for development, testing and training. If so, what has your experience been? Are there licencing issues for UV? Regards, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Virtual OS environment for UV
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Virtual OS environment for UV
Thanks, this is sounding more and more promising. [EMAIL PROTECTED] wrote: - There are lots of DataStage sites running in LPARs on AIX. DataStage is still close enough to UniVerse to count as a no problems response. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
Ross, I'm not derogating the use of sequential IDs but IIRC, the bloke had a reason not to use a sequential id counter and wanted an alternative. The uuid spec states that uuid should cater for time adjustments on the local clock, hence, shouldn't be vulnerable (Of course, in the real world, that depends on how the spec has been implimented). The uuid can be sequentialised and can gauranteed to be unique to a high degree of certainty in time and space. There are no locking or contention issues when a uuid is generated opposed to a heavily used key generator. I stand by my assertion that a uuid is a viable and justifiable solution in the original posters problem space. ;-) Cheers, Stuart [EMAIL PROTECTED] wrote: - This would still make things vulnerable whenever date/time changed on the generating machine the beauty of the sequential ID is that fact that nit WILL be in real time order, regardless of what people do with dae time of the machine ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Virtual OS environment for UV
This sounds good. Do you run multiple instances of UV simultaneously? Any issues there? [EMAIL PROTECTED] wrote: - Stuart, I run everything under Virtual PC, including UniVerse. This allows me to take simple spot saves, and to move my entire working environment between PCs without worrying about hardware differences: something I have had to do several times in the past. I also keep clean images zipped that include personal editions of each of the databases so I can unzip them for installation testing. Saves a huge amount of time. Brian ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
Given an uuid string generated by AIX uuid_gen: b6e7ce371f25.02.ac.1e.10.03.00.00.00 Under Windows uuidgen.exe -x: 9b0a5933-e7b1-11d9-868e-000bcdf8b9a5 The first part(s) of these are time based, though it may be difficult (but not impossible) to convert it back into a UV date/time format, the string will date/time sort either automatically in the aix case or by sorting on the (4th?,) 3rd, 2nd then 1st parts in the MS case. Doing a google search on 'uuid primary key' results in alternating for and against arguments. Regards, Stuart Boydell [EMAIL PROTECTED] wrote on 28-06-2005 17.20.58: But I don't think there is a way to extract a time element from the UUID, is there ? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
Another possability is to implement the UUID generator for your OS. It's gauranteed to be unique and you can also implement this scheme across machines. eg. aix: sh -c /.../uuid_gen linux: uuidgen win: uuidgen.exe (win sdk command line tool) or CreateObject(Scriptlet.TypeLib).Guid,38 (Win Scripting Host) Regards, Stuart Boydell [EMAIL PROTECTED] wrote on 28-06-2005 10.14.15: So I want a system wide sequential ID not per file. Using time and looping if the key exists will allow me to do this, as I have down to milliseconds for the key. However the regular time can be effected by Daylight savings time and I want to guarantee time order. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
One thing I forgot to mention about using system(99) is that, if for any reason, the machines clock is adjusted backwards (eg. ntd), there is an increased probability of duplicate numbers arising. With uuid, this should be handled by the uuid implimentation. Regards, Stuart Boydell [EMAIL PROTECTED] wrote on 28-06-2005 12.04.04: Another possability is to implement the UUID generator for your OS. It's sp. possibility!! gauranteed to be unique and you can also implement this scheme across machines. eg. aix: sh -c /.../uuid_gen linux: uuidgen win: uuidgen.exe (win sdk command line tool) or CreateObject(Scriptlet.TypeLib).Guid,38 (Win Scripting Host) Regards, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Stuart Boydell is on annual leave.
I will be out of the office starting 11-06-2005 and will not return until 21-06-2005. I will respond to your message when I return. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Stuart Boydell is on annual leave.
I will be out of the office starting 11-06-2005 and will not return until 21-06-2005. I will respond to your message when I return. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Triggers, RAID and SQL 2005
We use them. they're good, though slower than i-type pseudo triggers, they give more flexibility. Triggers begin a transaction, which you aren't supposed to be able to step through using a debugger. Regards, -- Stuart Boydell [EMAIL PROTECTED] wrote on 10-06-2005 13.57.58: I have found what I believe to be a problem with implementing triggers in UniVerse. If I have a trigger on a file and a developer is trying to resolve a problem in a program which happens to update/delete that file an issue using 'RAID' the debugger ;-) When the developer steps over the write statement, which in itself can be hard to determine when that will be given RAID's ability to not display the real debug position, then the trigger fails as no input is allowed within a trigger, and the program does not complete as normal. Granted you normally do not debug a program in production, but sometimes you may have to, and in any case in development you would still have triggers in, so as I see it this issue must be resolved. For if not I cannot see how I can propose using triggers at all. On a philosophical note, I cannot see why you cannot debug trigger code or indeed have an input statement if that is what you inclined to dolet the developer hang themselves... As a matter of interest how many people are using triggers? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
