[U2] UniRPC returning 39125

2010-01-06 Thread David Wolverton
I have a connection throwing 39125 when I try to RPC That means 'bad account' - yet the account connect data looks perfect to me... Anyone else seen 39125 during RPC? Any guidance? ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] UniRPC returning 39125

2010-01-06 Thread Brian Leach
Hi David Are you going in as the same user you would use to telnet? If not, does the user have permission on that account directory? Are you using an absolute pathname for the account, and if not, does it work if you do? Regards Brian -Original Message- From:

Re: [U2] UniRPC returning 39125

2010-01-06 Thread Rex Gozar
David, Does the account have both VOC and VOCLIB files? I ran into a similar situation where my VOCLIB was corrupted. rex David Wolverton wrote: Yes - same user/password... Yes - Absolute Pathname I'm calling UniData from UniVerse using Intercall calls Has worked in the past ..

Re: [U2] UniRPC returning 39125

2010-01-06 Thread Rex Gozar
David, Sorry, I'm not sure about Unidata, but when I used InterCall with Universe it did not recognize a directory as an account unless it had both a VOC and a VOCLIB. In my situation, I had a zero-byte VOCLIB which caused ic_opensession to fail with a bad account error. Perhaps Unidata

Re: [U2] UniRPC returning 39125

2010-01-06 Thread Rex Gozar
David, Also, are you using a literal string within a C program? Of course, backslashes within windows paths will need to be escaped. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniRPC returning 39125

2010-01-06 Thread David Wolverton
Yes I can -- so the problem is not 'UniData' as much as it is the 'ic_opensession' 'knowing' that it's in a legit UniData account (somehow!) I just sent a support ticket to Rocket to see what they say DW -Original Message- From: u2-users-boun...@listserver.u2ug.org

[U2] Count question

2010-01-06 Thread Ed Hess
Hi all, Using UniVerse 9.6 on AIX4.1, I'm trying to write a routine to count the number of occurrences of values than 0, for example, against this attribute: 0011: 4|0|0|0}4|23|4|0 I'd like to return a value of '4' for the 4 values 0. Not having much luck with COUNT or DCOUNT.

Re: [U2] Count question

2010-01-06 Thread Kevin King
Are those the real delimiters? I would think you're going to need a couple of loops to do what you want. COUNT will only count the number of times a character/string appears inside of another one and DCOUNT counts the number of delimited strings. Perhaps something like this:..assuming VALUES is

Re: [U2] Count question

2010-01-06 Thread Boydell, Stuart
LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,0)) Stuart Boydell -Original Message- Hi all, Using UniVerse 9.6 on AIX4.1, I'm trying to write a routine to count the number of occurrences of values than 0, for example, against this attribute: 0011: 4|0|0|0}4|23|4|0 I'd like to

Re: [U2] Count question

2010-01-06 Thread Marc Rutherford
I am assuming he is displaying system delimiters, in which case use REMOVE. Then you don't have to worry about what the delimiter may be. CNT = 0 LOOP REMOVE VALUE FROM VALUES SETTING MORE IF VALUE = 0 THEN CNT += 1 END WHILE MORE DO REPEAT Marc Rutherford Senior

Re: [U2] Count question

2010-01-06 Thread Boydell, Stuart
Whoops - forgot the reuse function: LIST MY.FILE EVAL SUM(GTS(MY.MV.FIELD,REUSE(0))) eg LIST GRTRANS EVAL SUM(GTS(REC.QTY,REUSE(0))) FMT 10R REC.QTY G38781801 1 G46781921 2 18675004 1

Re: [U2] Count question

2010-01-06 Thread Bernard Lubin
Hi Ed, I would just extract one element at a time and check if the value is 0 COUNTER = 0 THE.FIELD = THE.RECORD11 LOOP REMOVE THE.VALUE FROM THE.FIELD SETTING MORE.DATA IF VALUE 0 THEN COUNTER += 1 WHILE MORE DO REPEAT You can also accumulate the total by each field, by checking on the

Re: [U2] Count question

2010-01-06 Thread Marc Rutherford
Nice. Marc Rutherford Senior Programmer/Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Wednesday, January 06, 2010 3:13 PM To: U2 Users List

Re: [U2] Count Question

2010-01-06 Thread Brutzman, Bill
Ed: I would do it something like the following. When it is found to work ok, I would get rid of the given explanatory diagnostics. --Bill