Re: [UV] VARIABLE-1 = and Basic Compile $OPTIONSEXTRA.DELIMwork consistently
this is not exactly correct while you are correct that the 3 statements result in 2 attributes, the 2nd state does indeed have aneffect A='abc' ;* A=abc , len(A)=3 A-1='' ;* A=abc:@FM , len(A)=4 A-1='def' ;* A=abc:@FM:def , len(A)=7 when EXTRA.DELIM is used the results are : A='abc' ;* A=abc , len(A)=3 A-1='' ;* A=abc:@FM , len(A)=4 A-1='def' ;* A=abc:@FM:@FM:def , len(A)=8 - Original Message - From: Louis Windsor To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 6:42 AM Subject: Re: [UV] VARIABLE-1 = "" and Basic Compile "$OPTIONSEXTRA.DELIM"work "consistently" Sorry for jumping in without checking my facts first. You are right the sequence A = 'abc' A-1 = '' A-1 = 'def' results in A having TWO attributes NOT three. The second statement has no effect. This is as it works on Windows XP Prof and the Personnel version of UniVerse. If my memory serves me this is also how it works on UV9.6 on Unix (HPUX). Again I think the statement A-1='' is always ineffective. UV without over- riding options etc will never insert a null at the end of a string variable. My experience is mainly with Pick flavour. Louis - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 5:34 PM Subject: Re: [UV] VARIABLE-1 = "" and Basic Compile "$OPTIONS EXTRA.DELIM"work "consistently" The same documentation goes on to say: In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string and the new element is appended to the end of the dynamic array, the end of a field, or the end of a value, a delimiter is appended to the dynamic array, field, or value. Use the -EXTRA.DELIM option of the $OPTIONS statement to make the REPLACE function work as it does in IDEAL, PICK, and REALITY flavor accounts. In my opinion this behaviour is still unexpectedand here is why I say so: If Information behaves the same as PICK as you say, then the behaviour is still contrary to documentation because in the example I gave below, a @FM was still appended even if the string to be added was empty: i.e. A = 'abc' A-1 = '' A-1 = 'def' will result in 3 fields. According to the REPLACEextract you quoted,A-1 = '' should not add a field mark regardless of whether A is empty or not for PICK flavour. Marco Marco,As some previous replies were saying, the behaviour you describe is normaland documented. The explanation for this is found in the "REPLACE" Basicfunction, which is the equivalent for the angle brackets notation at theleft of an assignment operator ("=") for dynamic arrays handling.For more information, please refer to the Basic documentation manual (File"BASIC.pdf" in the CDROM library)Here is an excerpt of the documentation :REPLACE functionSyntaxREPLACE (_expression_, field#, value#, subvalue# { , | ; } replacement)REPLACE (_expression_ [ ,field# [ ,value#] ] ; replacement)variable field# [ ,value# [ ,subvalue#] ] .../...In IDEAL, PICK, PIOPEN, and REALITY flavor accounts, if replacement is anempty string and an attempt is made to append the new element to the endof the dynamic ar ray, field, or value, the dynamic array, field, or valueis leftunchanged; additional delimiters are not appended. Use the EXTRA.DELIMoption of the $OPTIONS statement to make the REPLACE function appenda delimiter to the dynamic array, field, or value/...The fact is that "UniVerse" is mainly designed to reproduce the behaviourof legacy products in the "Pick" family. In this case, the implementationof the "INFORMATION" and "IDEAL" flavour followed the default behaviour in"Pick" native products.I hope this answered your question.Regards,Hervé BALESTRIERISupport Technique Avancé - IBM Data Management - Produits "U2"- Forwarded by Herve Balestrieri/France/IBM on 03/02/2004 09:35 -Marco Manyevere <[EMAIL PROTECTED] .com cc: Sent by: Subject: VARIABLE-1 = '' Inconsistent behaviour u2-users-bounces@ oliver.com 03/02 /2004 05:55 Please respond to U2 Users Discussion List Hi All,Consider the program:A = ''A-1 = ''A-1 = ''A-1 = 3A-1 = ''A-1 = 4PRINT A3I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV9.6 [NT] running information flavour.Regards,MarcoBT Yahoo! Broadband - Free modem offer, sign up online today and save £80___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users Yahoo! Messenger - Communicate instantly..."Ping" your friends
Re: VARIABLE-1 = '' Inconsistent behaviour
we use the A[x,] as well as A[*,x,] constructs a lot - no trailing characters/fields - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:14 AM Subject: Re: VARIABLE-1 = '' Inconsistent behaviour I worked on an application that had: A=INSERT(A,1,-1;NEWVAL:@VM) and it was tricky. You should develop your own best approach to this concept of managing manual delimiters. BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you use A=A[2,1000]. My question is if the second value in [] exceeds the length of A are there any surprising trailing characters? I've used A=A[2,10] (or some knowingly high number) with no consequences over the years. my 1 cent. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 2:09 AM Subject: RE: VARIABLE-1 = '' Inconsistent behaviour One easy way I sometimes use is to just concatenate a field mark along with the new value and then remove the first field mark at the end... eg. A = LOOP INPUT B A := @FM:B UNTIL condition REPEAT A = A[2,LEN(A)-1] AdrianW -Original Message- From: Marco Manyevere [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 15:00 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACE says something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; * May be empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but this involves maintaining a counter for the dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: I think this is a feature. Universe does NOT insert non-significant nulls. In other words your first two (A-1 = '') do not do anything! It is consistent in its' behaviour as you can count on it to do the above. It has done this as long as I remember. I found this out through bitter experience. Louis - Original Message - From: Marco mailto:[EMAIL PROTECTED] Manyevere To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 12:55 PM Subject: VARIABLE-1 = '' Inconsistent behaviour Hi All, Consider the program: A = '' A-1 = '' A-1 = '' A-1 = 3 A-1 = '' A-1 = 4 PRINT A3 I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. Regards, Marco _ BT Yahoo! Broadband - Free modem offer, sign http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk up online today and save £80 _ ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m Yahoo! Messenger - Communicate instantly...Ping your friends today! http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/download/index.html Download Messenger Now Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
uv connectivity list archive
2 questions that I know have been answered here before : 1) what facilities are available to access external databases ( SQL Server etc. ) from within uniVerse ? 2) where is the archive for this list and how do we search it ? gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: odbc client hangs
Hi John, I don't think so , the client is connecting to the server and getting most of the way through the connection process according to the server log. I would think that a DNS problem would cause no connection to be made at all and a time out error to occur - which does happen as expected if the VPN client is not running or a bogus server is supplied I would also expect this to happen with both machines. My guess is that some dll or other component has gotten corrupted somewhere although I have no idea which that might be. For now I have moved my development efforts from the problem machine to the OK machine as my dev machine will be getting a re-install shortly. gerry - Original Message - From: John Jenkins [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Thursday, February 26, 2004 5:57 PM Subject: RE: odbc client hangs two-pennorth Any chance this relates to DNS lookup or doamin authentication?? /two-pennorth Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry simpson Sent: 26 February 2004 16:52 To: [EMAIL PROTECTED] Subject: odbc client hangs I have uvpe 10.0.4 and uvodbc 3.7 installed on a w2k server. I had been able to establish connections to a remote universe installation ( hpux 11 uv 10 ) using uvodbc through a vpn connection. somewhere along the line things have gone wrong. now when i try to connect to the remote server , even just do a test via odbc config , the client hangs and the cpu usage goes to 100% and stays there indefinately. if i try to connect to the local universe server ( same machine ) the connection goes through but takes much too long and still takes 100% cpu until the connection is established. i tried disabling all universe services , uninstalling odbc client , rebooting reinstalling odbc client all to no effect. I have another w2ks setup which has no problem at all connecting to the same remote universe installation - this second machine however does not have universe installed on it. all uv related dlls I have looked at are the same version on both machines. turning server log on from both clients shows that the client is hanging just after the server has responded to the GetInfo request and the server is left sitting Reading synchronization token ... until the client resets the connection - which happens of course when the client process is cancelled/killed. the archive mentions this problem as having been fixed in odbc 3.7 anyone seen this or have any suggestions ? gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Trigger FILE parameter
Hi Ray , this does not work. LIST.SICA always lists the file name as it was when the 1st trigger was created even if the triggers are dropped and recreated. - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Saturday, February 28, 2004 7:45 AM Subject: Re: [UV] Trigger FILE parameter The only way to modify the SICA after a CNAME is to drop the trigger and create it afresh. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Two ways to acquire the U2 Tech Support Survival Kit CD
Hi Wally, what about those who won't be able to attend these show ? gerry - Original Message - From: Logan, David (SST - Adelaide) [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 3:24 PM Subject: RE: Two ways to acquire the U2 Tech Support Survival Kit CD Hi Wally, What about us down here? Is it available outside the US? Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Wednesday, 3 March 2004 6:38 AM To: [EMAIL PROTECTED] Subject: Two ways to acquire the U2 Tech Support Survival Kit CD Limited supplies will be available at the IBM booth at two upcoming conferences: Spectrum Datatel Users Group (U2 partner) Both conferences are the week of March 14. I know many of you plan to attend Spectrum. There are also a number of Datatel clients who post to this list, as well. Drop by the IBM booth! ps - I will also be speaking at the Datatel Users Group conference on Sunday March 14 - 10:00am - 12:15 pm. Then lounging around until a 4:30 round table session. Stop by and say hello... Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV losing print characters
hi , a client has reported that they are randomly infrequently having characters dropped from print jobs. this recently happened during an invoice run where a tax value of 1147.90 was printed as 117.90 - the invoice total printed correctly, the invoice data on file has the correct value and a reprint shows the correct value. I am thinking that this is - a problem with the printer in question ( i am not yet sure if this is a single printer issue or not ) - a problem with a network connection - an issue to be raised with either IBM or HP has anyone seen this happen before ? gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV losing print characters
thanks for the reply martin. - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 3:51 AM Subject: Re: UV losing print characters The most common cause of this in my experience is incorrect use of flow control with serial printers. For the non-techies (are there any on this list?) Your UV system can probably produce data faster than the printer can handle it so it needs a way to say stop!. There are fundamentally two techniques in use though there are variants. The first technique uses one of the wires in the printer cable (DTR - Data Terminal Ready), to say stop/go. The other technique sends a character (X-OFF, Ctrl-S) from the printer to the computer to say stop and (X-ON, Ctrl-Q) to say go. (If you've ever wondered why this works on most terminal output processes, they often do the same). If your computer is set up to use DTR but your printer is expecting to use X-OFF/X-ON, the system is not going to stop sending data when required and you lose characters. Obviously, the same happens if the settings are the other way around too. A variation on this which is more difficult to find is that not some low cost serial cables don't have a DTR wire. So, you printer says stop but this never gets to the other end of the cable. You say that this is an infrequent problem. Although that makes this sort of scenario less likely, it can still happen because many modern printers have buffers large enough to hold quite big print jobs. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 - Original Message - From: gerry simpson [EMAIL PROTECTED] Subject: UV losing print characters a client has reported that they are randomly infrequently having characters dropped from print jobs. this recently happened during an invoice run where a tax value of 1147.90 was printed as 117.90 - the invoice total printed correctly, the invoice data on file has the correct value and a reprint shows the correct value. I am thinking that this is - a problem with the printer in question ( i am not yet sure if this is a single printer issue or not ) - a problem with a network connection - an issue to be raised with either IBM or HP has anyone seen this happen before ? gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SQL Server , UniOLEDB subtables
we have set up universe 10 in SQL Server 2K as a linked database via UniOLEDB. we have a test file set up that consists of 2 single valued fields 2 multi valued fields at the universe command prompt we can access both the table and the virtual table for the multi values : SELECT * FROM TEST.TAB ; @IDS1 S2M1 M2 AAA A B CD G H BBB I J K L M N O P SELECT * FROM TEST.TAB_MV ; @IDM1 M2 @ASSOC_ROW AAA CD 1 G H 2 BBBK L 1 MN2 O P3 in SQL Server the following works just fine - we get the expected 2 row table with the columns @ID , S1 S2 : SELECT * FROM OPENQUERY( [UVCON] , 'SELECT * FROM TEST.TAB') however any attempt to access the sub table : SELECT * FROM OPENQUERY( [UVCON] , 'SELECT * FROM TEST.TAB_MV') pretty much causes the pc to come grinding to a halt - cpu usage goes to 100%, connection activity stops and we have to restart SQL Server to abort the select. I have not been able to locate any type of error info either in uv or on the pc. I tried double quoting the table name assuming this was a problem with the _ character - no effect In the linked database properties I set a query timeout of 30 seconds and a connection timeout of 30 seconds but I have let this query run for 10 minutes without getting any timeout errors. any ideas ? does universe keep any type of log for oleDB access - i can't find one to see if the request is even getting to universe. gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
another try - DELETE uv data from SQL Server via oleDB
ok - so i'll take another 2 tracks with this one. with universe set up in SQL Server as a linked database using unioledb : 1. how do we DELETE from a uv table ? DELETE FROM [LINKEDUVDB]...[TAB1] WHERE [FLD1] = 'SOMEVAL' DELETE FROM [LINKEDUVDB]...[TAB1] SELECT [EMAIL PROTECTED] FROM [LINKEDUVDB]...[TAB1] WHERE [FLD1]='SOMEVAL' DELETE FROM [LINKEDUVDB]...[TAB1] WHERE [EMAIL PROTECTED] IN ( SELECT [EMAIL PROTECTED] FROM [LINKEDUVDB]...[TAB1] WHERE [FLD1]='SOMEVAL') all generate : Server: Msg 7306, Level 16, State 2, Line 1 Could not open table 'TAB1' from OLE DB provider 'IBM.UniOLEDB'. The provider could not support a row lookup position. why is this ? I would have though that all universe tables have a unique column (row lookup position) in @ID ? select * from openquery([ODBC-BASIC] , 'DELETE FROM TAB1 WHERE FLD1 = ''SOMEVAL''') results in this 'informative' message : Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'IBM.UniOLEDB' reported an error. The provider did not give any information about the error. 2 . does anyone know how to execute a universe subroutine/command ? select * from openquery([ODBC-BASIC] , '*X'') select * from openquery([ODBC-BASIC] , 'CALL *X'') select * from openquery([ODBC-BASIC] , '{CALL *X}'') all result in : Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'IBM.UniOLEDB' reported an error. The provider did not give any information about the error. this seems to be the case for any statment other than SELECT exec [LINKEDUVDB]...[*X] results in : Server: Msg 7212, Level 17, State 1, Line 1 Could not execute procedure '*X' on remote server 'ODBC-BASIC'. gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: SQL Server , UniOLEDB subtables
Thanks David the docs 'explain' how to enable server side uci logging via the UVHOME/serverdebug file this file doesn not currently exist and no format beyond 'column' values is given. do you know what the format of this file is ? what delimits a column , space , comma , tab , colon ? i've tried all 4 but have yet to see a debug log file appear. do we have to restart uci/uv to have changes take effect ? gerry - Original Message - From: Hona, David S [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 2:26 AM Subject: RE: SQL Server , UniOLEDB subtables I suggest you read-up on how to enable the UCI logging feature. As UniOLEDB uses UCI to communicate with UV. See 'Administrative Supplement for Client APIs' pages 3-21 and 3-22. Of course, this will just help with issues at the UV end. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry simpson Sent: Tuesday, March 09, 2004 5:38 AM To: [EMAIL PROTECTED] Subject: SQL Server , UniOLEDB subtables we have set up universe 10 in SQL Server 2K as a linked database via UniOLEDB. we have a test file set up that consists of 2 single valued fields 2 multi valued fields at the universe command prompt we can access both the table and the virtual table for the multi values : SELECT * FROM TEST.TAB ; [snip] any ideas ? does universe keep any type of log for oleDB access - i can't find one to see if the request is even getting to universe. gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Mvquery Client Not Responding
lol - you tell 'em Will i think i might join you at that - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 13, 2004 12:06 AM Subject: Re: Mvquery Client Not Responding In a message dated 3/11/2004 8:12:17 AM Pacific Standard Time, [EMAIL PROTECTED] writes: 1. Please do not post mvQuery questions to this list. Either send them to your mvQuery supplier, or to mvquery support. I'm going to buy mvQuery just so I can post twelve questions a day on it to this list. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
testing
sorry - please ignore -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users