RE: [U2] How to exit out mulitple loops?

2005-01-20 Thread Dennis Bartlett
Since you insist... FOR T=1 TO 10 FOR Q=1 TO 6 FOR X=1 TO 9 IF CONDITION THEN EXIT ; EXIT OR IF CONDITION THEN CONTINUE T NEXT X NEXT Q NEXT T FOR T=1 TO 10 until abort.flag 0 FOR Q=1 TO 6 until abort.flag 0

Re: [U2] Universe ODBC

2005-01-20 Thread Mats Carlid
OCONV( ICONV( DateFld :'-01', 'D2-YMD'),'D4,YMD') will do it assuming your data is YY-MM and you want the result to be the first day in the month. Note that you can't use it in a dict conversion field but in a program (as written) or in an I-descriptor as follows:. e.g. I ICONV(

[U2] Universe ODBC - Capture Select

2005-01-20 Thread Vincent MASSON
Dear all, Is there a way to capture the sql statement sent to Universe through an ODBC connection ? I'm using a tool to build queries (like Business Object) but I can't see the SELECT statement it builds. Any idea ? Thanks, Vincent MASSON mailto:[EMAIL PROTECTED] Infodata Sarl

Re: [U2] Universe ODBC

2005-01-20 Thread Mats Carlid
Ooops! see below Mats Carlid wrote: OCONV( ICONV( DateFld :'-01', 'D2-YMD'),'D4,YMD') will do it assuming your data is YY-MM and you want the result to be the first day in the month. Note that you can't use it in a dict conversion field but in a program (as written) or in an I-descriptor

RE: [U2] Universe ODBC - Capture Select

2005-01-20 Thread graham.forbes
Have you tried switching on logging (I think you can specify client and or server). Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vincent MASSON Sent: 20 January 2005 09:11 To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODBC -

RE : [U2] Universe ODBC - Capture Select

2005-01-20 Thread Vincent MASSON
If you're talking about the Create debug Log in the Data Source Setup, I tried but the log file is never feed with my sql statements. I don't know why ... Vincent MASSON Infodata Sarl Tel : (352) 33 16 48 Fax : (352) 33 75 55 -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] K = K

2005-01-20 Thread chris . dyson
I've just started at a new site running D3 7.2.1.RS on AIX and the REMOVE statement doesn't compile at all! It's very annoying as it's a very convenient way of processing dynamic arrays and with larger arrays far more efficient than counting the markers and FOR... NEXTing through it. I'm suprised

RE: [U2] K = K

2005-01-20 Thread Kevin King
Uh... Hate to break it to you, but... D3 isn't U2. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 20, 2005 7:57 AM To: u2-users@listserver.u2ug.org Subject:

RE: [U2] K = K

2005-01-20 Thread Bill H.
Chris: Place: $OPTIONS EXT at the beginning of the program then try to compile again. This should do the trick. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 20, 2005 6:57 AM To:

Re: [U2] K = K

2005-01-20 Thread Ron White
Try adding the $OPTIONS EXT compiler directive to the top of the program. Ron White - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, January 20, 2005 8:56 AM Subject: RE: [U2] K = K I've just started at a new site running D3 7.2.1.RS on AIX

Re: [U2] K = K

2005-01-20 Thread Stu Glancy
REMOVE is universal in U2 BASICs. You are not using a U2 BASIC. According to your comment you are using D3 which is not a U2 product. [EMAIL PROTECTED] wrote: I've just started at a new site running D3 7.2.1.RS on AIX and the REMOVE statement doesn't compile at all! It's very annoying as it's

Re: [U2] How to exit out mulitple loops?

2005-01-20 Thread FFT2001
In a message dated 1/20/2005 12:32:33 AM Pacific Standard Time, [EMAIL PROTECTED] writes: FOR T=1 TO 10 until abort.flag 0 FOR Q=1 TO 6 until abort.flag 0 You don't need the 0 part just say until abort.flag Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To

[U2] [AD] U2 Programmer/Analyst Position Announcement

2005-01-20 Thread itjobs
KraftMaid Cabinetry is the world's largest cabinet producer. We are located in the heart of Amish country in Geauga county, Ohio, but less that an hour from downtown Cleveland. Kraftmaid is seeking an experienced U2 developer for full-time salaried employment. 5+ years programming experience is

[U2] [UV] Time Output Conversion

2005-01-20 Thread Nick Cipollina
Is there an output conversion for time that will include the milliseconds? If I have a time that is 10:35:14 am and there are 35 milliseconds, how can I convert this to include them? Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road,

[U2] Universe account Name/ID

2005-01-20 Thread Bob Woodward
Hi Folks. I'm trying to find the simplest way to figure out which account a program is running in, within the program. Basically, between a development/testing account and the live account. I've got a number of ways to extrapolate where I am but I'm hoping that there is some system variable

RE: [U2] Universe ODBC

2005-01-20 Thread Maresh, Mel
how about something like this YEAR = FIELD(PERIOD,'-',1) MONTH = FIELD(PERIOD,'-',2) IF YEAR GE 30 THEN YEAR = '19':YEAR ELSE YEAR = '20':YEAR MONTH += 1 ; IF MONTH = 13 THEN MONTH = 1 ; YEAR +=1 DATE = ICONV((MONTH:.1.:YEAR),'D') - 1 PERIOD = DATE'DY4':',':DATE'DM':',':DATE'DD' -Original

RE: [U2] Universe account Name/ID

2005-01-20 Thread George Gallen
I know it can be modified but... what about EXECUTE WHO CAPTURING STUFF ; ACCT=FIELD(STUFF, ,2) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Thursday, January 20, 2005 1:20 PM To: U2-Users List Subject: [U2] Universe account Name/ID

RE: [U2] Universe account Name/ID

2005-01-20 Thread Nick Cipollina
@WHO will tell you which account you are running on. OCONV(, U50BB) will give you the PORT and Account. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, January 20, 2005 1:20 PM To: U2-Users List

Re: [U2] Universe account Name/ID

2005-01-20 Thread Lance Jahnke
@WHO -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: U2-Users List u2-users@listserver.u2ug.org Sent: Thu Jan 20 12:20:06 2005 Subject: [U2] Universe account Name/ID Hi Folks. I'm trying to find the simplest way to figure out which account a program is running in,

Re: [U2] Universe account Name/ID

2005-01-20 Thread Peter D Olson
@who / who ? This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby

Re: [U2] Universe account Name/ID

2005-01-20 Thread Clifton Oliver
@WHO *The name of the current UniVerse | |account directory. Nonstacked. Bob Woodward wrote: Hi Folks. I'm trying to find the simplest way to figure out which account a program is running in, within the program. Basically, between a

RE: [U2] Universe account Name/ID

2005-01-20 Thread Rajesh Menon
How about.. @PATH - Path name of current account or EXECUTE WHO CAPTURING DUMMY FIELD(DUMMY, , 2) = Account name -Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, January 20, 2005 10:20 AM To: U2-Users List Subject:

Unclassified RE: [U2] Universe account Name/ID

2005-01-20 Thread HENDERSON MIKE, MR
@WHO See HELP BASIC @variables page down to @WHO -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, 21 January 2005 07:20 To: U2-Users List Subject: [U2] Universe account Name/ID Hi Folks. I'm trying to find the simplest way

RE: [U2] Universe account Name/ID

2005-01-20 Thread Rajesh Menon
@WHO ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, January 20, 2005 10:20 AM To: U2-Users List Subject: [U2] Universe account Name/ID Hi Folks. I'm trying to find the simplest way to figure out which account a program

RE: [U2] Universe account Name/ID

2005-01-20 Thread Chauhan, Savita
That is so cool little thing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Thursday, January 20, 2005 1:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe account Name/ID @WHO will tell you which account you are

RE: [U2] Universe account Name/ID

2005-01-20 Thread Bob Woodward
@WHO gives me the windows user id but not the Universe Account. The OCONV gives me both pieces of information I need. I didn't ask about the PORT number but this works out great. Thanks Nick! Bob -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On

RE: [U2] [UV] Device Licensing

2005-01-20 Thread Dave Schexnayder
Dianne, Device licensing only works with SBClient/UV tools. It does not work with other terminal emulators. And for SBClient to work, it must be at least 5.2.x. Each tool, UniObjects, SBClient, etc. has a device licensing .dll that handshakes with the server to determine the license count.

RE: [U2] Universe account Name/ID

2005-01-20 Thread Marilyn Hilb
One hint on using these. Read the descriptions carefully. If you use LOGTO not all of these variables will change with the new logto account name/path. Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original

RE: [U2] Universe account Name/ID

2005-01-20 Thread Bob Woodward
Now this is weird! Now @WHO IS giving me the account name, NOT the Windows user id. scratching bald spot on head I could SWEAR that it was my login ID when I first checked! Sorry about that, folks. Walking off muttering something about needing stronger drugs... Bob -Original

RE: [U2] [UV] Device Licensing

2005-01-20 Thread Bob Woodward
I don't have a LISTUSER command in my copy of Universe so I think that's unique to UDT. The only way I've been able to feel comfortable that device licensing was working was when I do a LISTU and see the uid column has the same value for multiple entries of the same User Name. I believe if you

[U2] Wintegrate ML-SEND

2005-01-20 Thread Mike Randall
Can it send html formatted messages as well as standard text messages? If so, what's required for them? TIA, Mike Randall --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Device Licensing

2005-01-20 Thread Veenhof, Peter
Accuterm has this option in the Telnet Settings Dialog: Use U2 device licensing (advanced option) If this option is set, multiple connections (sessions) to Enterprise versions of UniData and UniVerse consume only a single user license. When the suppress LF option is checked, the response sent to

Re: [U2] [UV] Device Licensing

2005-01-20 Thread Leroy Dreyfuss
Dianne, Assuming you have a version of Accuterm that supports U2 Device Licensing, you can run bin/uvlictool from the OS command line to see. An example using my laptop: C:\IBM\UVbin\uvlictool Device licensing is in effect. No. Pid, Package Device name IP address Device sub-key

RE: [U2] [UV] Device Licensing

2005-01-20 Thread Ed Clark
Looking at accuterm 5.oe, under tools|settings on the connection tab, there's an advanced button on the right side. Clicking that brings up a form which includes an option to use U2 device licensing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hanley,

Re: [U2] [UV] Device Licensing

2005-01-20 Thread Dianne Ackerman
Yes, it does have that switch and it's checked. -Dianne Hanley, Iain wrote: Dianne, Does Accuterm have a switch for device licensing? wIntegrate/Dynamic Connect both have preference settings to support device licensing on UniData and UniVerse, so it may be that Accuterm does not have the ability

Re: [U2] [UV] Device Licensing

2005-01-20 Thread Dianne Ackerman
Thanks, Bob, I didn't think to look for that - I'll check it out. -Dianne Bob Woodward wrote: I don't have a LISTUSER command in my copy of Universe so I think that's unique to UDT. The only way I've been able to feel comfortable that device licensing was working was when I do a LISTU and see

Unclassified RE: [U2] [UV] Device Licensing

2005-01-20 Thread HENDERSON MIKE, MR
Bob At (real) TCL, LOGTO UV DOS [path]\UVCD bin [path]\UV\binuvlictool Server Edition mode of licensing is in effect. No. Pid, Package Device name IP address Device sub-key 1 3424 2 3944 3 308 4 2928 5 3744 6 2220 6 license seats are in use. 14 license seats are

Re: [U2] [UV] Device Licensing

2005-01-20 Thread Dianne Ackerman
Actually, it does work with both Accuterm and HostAccess also. -Dianne Dave Schexnayder wrote: Dianne, Device licensing only works with SBClient/UV tools. It does not work with other terminal emulators. And for SBClient to work, it must be at least 5.2.x. Each tool, UniObjects, SBClient, etc.

Re: [U2] [UV] Device Licensing

2005-01-20 Thread Bruce Nichol
Goo'day, At 15:51 20/01/05 -0500, you wrote: Actually, it does work with both Accuterm and HostAccess also. -Dianne My understanding, but I'm only a mere male, is that if TE developers and (now) IBM come to some arrangemnt IBM will pass on the secret herbs and spices to allow *that* TE to

RE: [U2] Universe account Name/ID

2005-01-20 Thread Bruce Nichol
Goo'day, At 18:37 20/01/05 -0800, you wrote: Why is it '@WHO' provides the account name, and @ACCOUNT provides the who it is (aka person's logon)??? Are these sort of reversed?? Drives me nuts too. I think you'd have to go wy back to the original MDD WHO (U50BB) which gave port number

Re: [U2] Wintegrate ML-SEND

2005-01-20 Thread Mark Johnson
I drove off that bridge late last year. Wintegrate doesn't seem to have a HTML toggle. One client that needs it ended up using BLAT. A little clunky but it handles the formatted output that I needed HTML for. I don't know if Accuterm handles HTML but I know that it's more sophisticated than

Re: [U2] Universe account Name/ID

2005-01-20 Thread Mark Johnson
Try taking a legacy native AP system with no user identification (same logon) and home-grown user stuff and migrating it to D3. I'm 3 for 3 on letting them keep their application-level user-ids as opposed to the system-level. One client is coming around but it's still teaching an old dog new

RE: [U2] Wintegrate ML-SEND

2005-01-20 Thread Tony Gravagno
Mike Randall wrote: Can it send html formatted messages as well as standard text messages? If so, what's required for them? [ad] After listening to people ask about e-mail solutions for years and hearing the typical responses that invitably have issues (AccuTerm, wIntegrate, Blat, mutt,