Re: [U2] Using the BCI

[Wendy Smoak]

On 5/2/06, Victor St Clair <[EMAIL PROTECTED]> wrote:


I've seen this question asked from time to time, but I can't get into
the archives to find out what the answer has been.


What archives are you having trouble with?  I usually use Nabble:
  http://www.nabble.com/U2---Users-f801.html


I find myself the person assigned to a new development project with the
responsibility of learning to use the Basic Client Interface to access
data in an SQL2005 DB.   I have the BCI manual from IBM and am starting
my journey through it.  But I recall seeing comments in the past to the
effect of  "the examples supplied are not that useful, you can get
better examples at .".


I did okay with the manual and the example program, though IMO the
example overly complicates the process with all the error checking. 
You'll find a few messages of mine in the archives when I was fighting

with BCI about one thing or another.

The main problem is that depending on your combination of OS and
target database, it can be difficult-to-impossible to find both a
driver and driver manager so that ODBC access to an external DB
actually works.

For example, connecting from UniData on HP-UX to Sybase never
worked... we ended up buying a single-user Windows license for UniData
so we could finish the project.  (Which then required the addition of
NFA to talk to the original UniData instance on HP-UX!)

I see your second note saying you're on Windows, so you'll be fine
there.  Give it a try and let us know if you have questions.

--
Wendy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Using the BCI {Unclassified}

[HENDERSON MIKE, MR]

Look in the list archives for articles I posted.

The supplied documentation & program are rubbish, I have raised a Case
with IBM about it, but it's "priority 4" [ 4 ==> "fixed when they've
nothing else to do in Denver, cross-words all finished, too wet / cold
to go outside for a walk" ;-) ].


Look at the CONNECT program (in the BP file in the UV account), it's
quite a bit better.

There are some good examples in the Knowledge Base written by Paul Chang
at IBM Denver.
Try Q00178, Q00179, Q00180 , Q00182 - Q00187.


HTH


Mike

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Victor St Clair
> Sent: Wednesday, 3 May 2006 08:41
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Using the BCI
> 
> Hello All.
> 
> 
> 
> I've seen this question asked from time to time, but I can't 
> get into the archives to find out what the answer has been.
> 
> 
> 
> I find myself the person assigned to a new development 
> project with the responsibility of learning to use the Basic 
> Client Interface to access data in an SQL2005 DB.   
> I have the BCI manual from IBM and am starting
> my journey through it.  But I recall seeing comments in the 
> past to the effect of  "the examples supplied are not that 
> useful, you can get better examples at .".
> 
> 
> 
> The question is basically  "Are there any other sources of 
> information I can get on using the Basic Client Interface?" 
> If any one can point me in the direction of useful info I'd 
> greatly appreciate it.  
> And, if possible, are there any pitfalls I need to watch out for?
> 
> 
> 
> Thank you
> 
> 
> 
> Victor St. Clair
> 
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/

RE: [U2] UOJ Linux vs Windows

[phil walker]

I believe this is more or a linux permissions issue

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Little
Sent: Wednesday, 3 May 2006 4:01 p.m.
To: U2 UG
Subject: [U2] UOJ Linux vs Windows

Hi,
I am writing a java application for fun that essentially operates as an
GUI IDE/workspace/TCL shell.
I am connecting to UV with UOJ.

When I run my app at work, I'm in a full Windows environment.  When I
run this same app at home, I'm in a Linux environment - UniVerse PE.

The situation is this:
When I fire up the app at work and do a LISTU, I see all the users who
are logged into UV on that box, including my application which shows
(I'm sorry - this is from memory as I'm at home now) the
DOMAIN/username, port number a PID (I think) and a uvcs connection type.

When I run this app here at home and do a LISTU, I see nothing - except
if I have logged into Linux on that server, I will see the same output
as the bash command "who".

Knowing that UV PE is limited to 2 or 3 licenses, I would have expected
to be able to fire up only 2 or 3 instances of my application before
getting a connection error.  However I can start lots of instances with
no problem.  Granted - all instances are just sitting at TCL.
At work, I *presume* I could only start as many instances as licenses
available after which I would get a connection refusal.  (and RedBack
might crash, and a roomful of developers would glare at me).

Is there difference in the way the UniRPCd handles connections and
licensing on Linux and Windows?
Am I only consuming a license on Linux when I "do work"?

Thanks
Bob Little
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UOJ Linux vs Windows

[Bob Little]

Hi,
I am writing a java application for fun that essentially operates as an 
GUI IDE/workspace/TCL shell.

I am connecting to UV with UOJ.

When I run my app at work, I'm in a full Windows environment.  When I 
run this same app at home, I'm in a Linux environment - UniVerse PE.


The situation is this:
When I fire up the app at work and do a LISTU, I see all the users who 
are logged into UV on that box, including my application which shows 
(I'm sorry - this is from memory as I'm at home now) the 
DOMAIN/username, port number a PID (I think) and a uvcs connection type.


When I run this app here at home and do a LISTU, I see nothing - except 
if I have logged into Linux on that server, I will see the same output 
as the bash command "who".


Knowing that UV PE is limited to 2 or 3 licenses, I would have expected 
to be able to fire up only 2 or 3 instances of my application before 
getting a connection error.  However I can start lots of instances with 
no problem.  Granted - all instances are just sitting at TCL.
At work, I *presume* I could only start as many instances as licenses 
available after which I would get a connection refusal.  (and RedBack 
might crash, and a roomful of developers would glare at me).


Is there difference in the way the UniRPCd handles connections and 
licensing on Linux and Windows?

Am I only consuming a license on Linux when I "do work"?

Thanks
Bob Little
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Forum General Question

[Mark Johnson]

So one renegade email auto-responder changed this for everyone.
Too bad that was the only solution.

- Original Message -
From: "Larry Hiscock" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 02, 2006 1:47 PM
Subject: RE: [U2] Forum General Question


> 50+ in a single day?  Try 1500+ in an hour :-S
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield
> Sent: Tuesday, May 02, 2006 6:52 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Forum General Question
>
> Somebody's auto-email-responder zoomed out 50+ "I'll be back in the
> office on blah, blah, blah" in a single day.  At one point even
> responding to it's own 'responses'.
>
> Mark Johnson wrote:
> > So why was it changed in the first place. I wonder how many liked it
that
> > way.
> > Mark Johnson
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Forum General Question

[Mark Johnson]

So one person's screwed-up auto-responder changes it for everyone else.
Doesn't seem right.

- Original Message -
From: "Roger Glenfield" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 02, 2006 9:52 AM
Subject: Re: [U2] Forum General Question


> Somebody's auto-email-responder zoomed out 50+ "I'll be back in the
> office on blah, blah, blah" in a single day.  At one point even
> responding to it's own 'responses'.
>
> Mark Johnson wrote:
> > So why was it changed in the first place. I wonder how many liked it
that
> > way.
> > Mark Johnson
> ---
> 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] Forum General Question

[Mark Johnson]

Actually not. That's probably why I'm asking why the volume appears low.
- Original Message - 
From: "Nick Cipollina" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, May 02, 2006 9:52 AM
Subject: RE: [U2] Forum General Question


> Haven't you seen any of the about 3000 emails on this subject?
> 
> Thanks,
>  
> Nick Cipollina
>  
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Tuesday, May 02, 2006 9:21 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Forum General Question
> 
> So why was it changed in the first place. I wonder how many liked it
> that
> way.
> Mark Johnson
> - Original Message -
> From: "Richard Brown" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, May 01, 2006 11:45 PM
> Subject: Re: [U2] Forum General Question
> 
> 
> > I think what Larry is saying is that it is now back to the first
> scenario
> > you described.  When you hit reply,  the message goes to the list,
> which
> is
> > then distributed to all of us.  I subscribe to different list.  Some I
> have
> > to know to hit 'reply to all' to get my message to everyone.  Some I
> can
> > just hit reply and it goes to the list & the poster.  The poster will
> get
> it
> > twice,  once from me, once from the list.  Personally I don't care
> which
> way
> > it is setup.  If I reply wrong for the list,  that is my bad.
> >
> > Richard
> >
> > - Original Message -
> > From: "Mark Johnson" <[EMAIL PROTECTED]>
> > To: 
> > Sent: Monday, May 01, 2006 11:20 PM
> > Subject: [U2] Forum General Question
> >
> >
> > > While I'm a MV person, I don't know everything about all of this
> > > email/web/forum/thread stuff.
> > >
> > > What was the kind of U2 forum whereby a person posted a request and
> > everyone
> > > got it. Then each answer got sprayed to everyone. And so on until it
> died.
> > >
> > > Now, it appears that only the person issuing the question gets the
> reply
> > and
> > > many of us who might learn something of their public discussion are
> out
> of
> > the
> > > loop.
> > >
> > > Am I detecting this properly.
> > >
> > > Thanks
> > > Mark Johnson
> > > ---
> > > u2-users mailing list
> > > u2-users@listserver.u2ug.org
> > > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> 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] Runtime errors

[Bill Haskett]

Dave:

I have an request in with IBM for this information.  I didn't get any
feedback on the list and if I get an answer I'll post it for you and anyone
else who might want it.

Bill

 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker
> Sent: Tuesday, May 02, 2006 7:14 AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: [U2] Runtime errors
> 
> I'm sure we've all seen the user that ignores umpteen "WARNING:
> UNINITIALIZED VARIABLE USED! Zero Assumed!" errors scrolling
> up their screen.
> 
> Is there a way to log non-fatal runtime errors so that they 
> may be reviewed later? Are they already logged someplace that
> I'm not aware of? I've checked the various logs in /usr/ud/
> bin/saved_logs without finding what I'm looking for. 
> 
> TIA,
> --
> Dave Walker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] RE: Using the BCI

[Victor St Clair]

Hello



I forgot to add that we are using UniData 7.1, almost always on Windows,
although it's not impossible that we might need to install our UniData
app on a Unix box.



Thanks again



Victor St. Clair

Jenkon



[EMAIL PROTECTED] 

360-256-4400 Phone

360-256-9623 Fax

www.jenkon.com



From: Victor St Clair
Sent: Tuesday, May 02, 2006 1:41 PM
To: u2-users@listserver.u2ug.org
Subject: Using the BCI



Hello All.



I've seen this question asked from time to time, but I can't get into
the archives to find out what the answer has been.



I find myself the person assigned to a new development project with the
responsibility of learning to use the Basic Client Interface to access
data in an SQL2005 DB.   I have the BCI manual from IBM and am starting
my journey through it.  But I recall seeing comments in the past to the
effect of  "the examples supplied are not that useful, you can get
better examples at .".



The question is basically  "Are there any other sources of information I
can get on using the Basic Client Interface?"   If any one can point me
in the direction of useful info I'd greatly appreciate it.  And, if
possible, are there any pitfalls I need to watch out for?



Thank you



Victor St. Clair


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Using the BCI

[Victor St Clair]

Hello All.



I've seen this question asked from time to time, but I can't get into
the archives to find out what the answer has been.



I find myself the person assigned to a new development project with the
responsibility of learning to use the Basic Client Interface to access
data in an SQL2005 DB.   I have the BCI manual from IBM and am starting
my journey through it.  But I recall seeing comments in the past to the
effect of  "the examples supplied are not that useful, you can get
better examples at .".



The question is basically  "Are there any other sources of information I
can get on using the Basic Client Interface?"   If any one can point me
in the direction of useful info I'd greatly appreciate it.  And, if
possible, are there any pitfalls I need to watch out for?



Thank you



Victor St. Clair


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Forcing Subroutine to be Re-read

[u2]

I don't know of any way to force another process to refresh it's
subroutine cache (maybe someone else has the answer to that) but it's a
good idea sometimes for a background process to periodically restart
itself, i.e, for a program named WATCHER running as a phantom:
0001 MAX.TIME=3600
0002 LAST.TIME=TIME()
0003 LOOP
0004   GOSUB DO.SOMETHING.USEFULL:
0005 UNTIL TIME()-LAST.TIME > MAX.TIME DO REPEAT
0006 CHAIN "WATCHER"
WATCHER does it's stuff for an hour, and then restarts itself via chain.
This clears the subroutine cache as well as allowing it to reload a new
version of itself.
You could also have the program check a flag, or the timestamp on a
program, and restart itself (or shut itself down cleanly) based on other
events.


> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Tuesday, May 02, 2006 2:03 PM
> To: u2-Users
> Subject: [U2] [UV] Forcing Subroutine to be Re-read
> 
> 
> Hi all,
> 
> UV9.6.1.14
> HPUX 11
> 
> I have a background processor that calls a number of 
> subroutines.  Everytime I make a change to any of the 
> subroutines, I have to shutdown the job and restart it 
> because the subroutine is still in memory.  Does anyone know 
> of a way that I can force the background job to reread the subroutine?
> 
> Thanks in advance,
> 
> Scott
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.5.1/328 - Release 
> Date: 5/1/2006
>  
> 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/328 - Release Date: 5/1/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Forcing Subroutine to be Re-read

[Allen E. Elwood]

I think NEWPCODE only works for the session that is executing NEWPCODE, so
it would have to be inside of the calling program.  You'd have to have it
poll a flag, and if the flag changed, then NEWPCODE and de-set the flag.

hth,
Allen

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Trevor Fulton
Sent: Tuesday, May 02, 2006 11:42
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Forcing Subroutine to be Re-read


NEWPCODE on Unidata does this, I do not know if the same command is
available in Universe.

Trevor.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 02 May 2006 19:03
To: u2-Users
Subject: [U2] [UV] Forcing Subroutine to be Re-read

Hi all,

UV9.6.1.14
HPUX 11

I have a background processor that calls a number of subroutines.
Everytime I make a change to any of the subroutines, I have to shutdown
the job and restart it because the subroutine is still in memory.  Does
anyone know of a way that I can force the background job to reread the
subroutine?

Thanks in advance,

Scott
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


This e-mail is for the use of the intended recipient(s) only. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not use, disclose
or distribute this e-mail without the author's prior permission. We have
taken precautions to minimize the risk of transmitting software viruses, but
we advise you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Forcing Subroutine to be Re-read

[Trevor Fulton]

NEWPCODE on Unidata does this, I do not know if the same command is
available in Universe.

Trevor. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 02 May 2006 19:03
To: u2-Users
Subject: [U2] [UV] Forcing Subroutine to be Re-read

Hi all,

UV9.6.1.14
HPUX 11

I have a background processor that calls a number of subroutines.
Everytime I make a change to any of the subroutines, I have to shutdown
the job and restart it because the subroutine is still in memory.  Does
anyone know of a way that I can force the background job to reread the
subroutine?

Thanks in advance,

Scott
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


This e-mail is for the use of the intended recipient(s) only. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not use, disclose or 
distribute this e-mail without the author's prior permission. We have taken 
precautions to minimize the risk of transmitting software viruses, but we 
advise you to carry out your own virus checks on any attachment to this 
message. We cannot accept liability for any loss or damage caused by software 
viruses.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [UV] Forcing Subroutine to be Re-read

[iggchamp]

Hi all,

UV9.6.1.14
HPUX 11

I have a background processor that calls a number of subroutines.  Everytime I 
make a change to any of the subroutines, I have to shutdown the job and restart 
it because the subroutine is still in memory.  Does anyone know of a way that I 
can force the background job to reread the subroutine?

Thanks in advance,

Scott
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Forum General Question

[Larry Hiscock]

50+ in a single day?  Try 1500+ in an hour :-S
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield
Sent: Tuesday, May 02, 2006 6:52 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Forum General Question

Somebody's auto-email-responder zoomed out 50+ "I'll be back in the 
office on blah, blah, blah" in a single day.  At one point even 
responding to it's own 'responses'.

Mark Johnson wrote:
> So why was it changed in the first place. I wonder how many liked it that
> way.
> Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] AccuTerm 2K2 keepalives in UniData

[Bill Haskett]

I use AccuTerm mostly and it has a "keepalive" function that sends a signal
to the server every two minutes.  I'm seeing these CHAR(255):CHAR(252) (IAC
and WON'T) characters display at TCL (or in a menu) every two minutes on
UniData.  These characters interfere with data input.  This does not seem to
occur in UniVerse (or D3).

According to Asent, "There is no specification for telnet keepalives, so we
improvised them in AccuTerm. AccuTerm sends a telnet DM command every two
minutes. The telnet spec says that unless a connection is in "urgent mode",
DM commands are ignored. It looks like IBM did not interpret the spec the
same way we did, and treats the DM command as data. Here's a quote from
RFC854:  'When in normal mode, a DM is a no operation; when in urgent mode,
it signals the end of the urgent processing.'".

Does anyone else have this problem with AccuTerm "keepalives" and UniData?
If so, have you found a "work-around" for this?

As always, any assistance will be appreciated.

Bill Haskett
Advantos Systems, Inc.
www.advantos.net
(760)944-5570 (CA)
(360)923-4838 (WA)  
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Runtime errors

[asvin . dattani]

HI Dave,

Probably no use to you because I note that you are running Unidata, but on 
Universe there is file in the Universe install directory called errlog. 
This logs all these run time errors.

It's been some years since I worked on Unidata, but I do vaguely recall a 
similar file there... .perhaps some of the Unidata people will chime in.

You could also consider outputting to a como. So, in the menu program you 
execute COMO ON portnumber*program, then execute the program, and then do 
a COMO OFF.  You can then read the como directly from the &COMO& file, and 
check it for run time error messages.

hth,

asvin





Dave Walker <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
02/05/2006 15:14
Mail Size: 4423
Please respond to
u2-users@listserver.u2ug.org


To
"'u2-users@listserver.u2ug.org'" 
cc

Subject
[U2] Runtime errors
Entity
Investment Banking Europe - IBEU






I'm sure we've all seen the user that ignores umpteen "WARNING:
UNINITIALIZED VARIABLE USED! Zero Assumed!" errors scrolling up their
screen.

Is there a way to log non-fatal runtime errors so that they may be 
reviewed
later? Are they already logged someplace that I'm not aware of? I've 
checked
the various logs in /usr/ud/bin/saved_logs without finding what I'm 
looking
for.

TIA,
--
Dave Walker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/



HSBC Bank plc may be solicited in the course of its placement efforts for 
a new issue, by investment clients of the firm for whom the Bank as a firm 
already provides other services. It may equally decide to allocate to its 
own proprietary book or with an associate of HSBC Group. This represents a 
potential conflict of interest. HSBC Bank plc has internal arrangements 
designed to ensure that the firm would give unbiased and full advice to 
the corporate finance client about the valuation and pricing of the 
offering as well as internal systems, controls and procedures to identify 
and manage conflicts of interest.

HSBC Bank plc
Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom
Registered in England - Number 14259
Authorised and regulated by the Financial Services Authority.




-
This transmission has been issued by a member of the HSBC Group "HSBC"
for the information of the addressee only and should not be reproduced
and/or distributed to any other person. Each page attached hereto must
be read in conjunction with any disclaimer which forms part of it.
Unless otherwise stated, this transmission is neither an offer nor the
solicitation of an offer to sell or purchase any investment. Its
contents are based on information obtained from sources believed to be
reliable but HSBC makes no representation and accepts no responsibility
or liability as to its completeness or accuracy.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Forum General Question

[gerry-u2ug]

A couple of out-of-office replies flooding the list with replies to
themselves 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: May 2, 2006 09:21
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Forum General Question

So why was it changed in the first place. I wonder how many liked it
that way.
Mark Johnson
- Original Message -
From: "Richard Brown" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 01, 2006 11:45 PM
Subject: Re: [U2] Forum General Question


> I think what Larry is saying is that it is now back to the first 
> scenario you described.  When you hit reply,  the message goes to the 
> list, which
is
> then distributed to all of us.  I subscribe to different list.  Some I
have
> to know to hit 'reply to all' to get my message to everyone.  Some I 
> can just hit reply and it goes to the list & the poster.  The poster 
> will get
it
> twice,  once from me, once from the list.  Personally I don't care 
> which
way
> it is setup.  If I reply wrong for the list,  that is my bad.
>
> Richard
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, May 01, 2006 11:20 PM
> Subject: [U2] Forum General Question
>
>
> > While I'm a MV person, I don't know everything about all of this 
> > email/web/forum/thread stuff.
> >
> > What was the kind of U2 forum whereby a person posted a request and
> everyone
> > got it. Then each answer got sprayed to everyone. And so on until it
died.
> >
> > Now, it appears that only the person issuing the question gets the 
> > reply
> and
> > many of us who might learn something of their public discussion are 
> > out
of
> the
> > loop.
> >
> > Am I detecting this properly.
> >
> > Thanks
> > Mark Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Runtime errors

[Dave Walker]

I'm sure we've all seen the user that ignores umpteen "WARNING:
UNINITIALIZED VARIABLE USED! Zero Assumed!" errors scrolling up their
screen.

Is there a way to log non-fatal runtime errors so that they may be reviewed
later? Are they already logged someplace that I'm not aware of? I've checked
the various logs in /usr/ud/bin/saved_logs without finding what I'm looking
for. 

TIA,
--
Dave Walker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Forum General Question

[Nick Cipollina]

Haven't you seen any of the about 3000 emails on this subject?

Thanks,
 
Nick Cipollina
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Tuesday, May 02, 2006 9:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Forum General Question

So why was it changed in the first place. I wonder how many liked it
that
way.
Mark Johnson
- Original Message -
From: "Richard Brown" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 01, 2006 11:45 PM
Subject: Re: [U2] Forum General Question


> I think what Larry is saying is that it is now back to the first
scenario
> you described.  When you hit reply,  the message goes to the list,
which
is
> then distributed to all of us.  I subscribe to different list.  Some I
have
> to know to hit 'reply to all' to get my message to everyone.  Some I
can
> just hit reply and it goes to the list & the poster.  The poster will
get
it
> twice,  once from me, once from the list.  Personally I don't care
which
way
> it is setup.  If I reply wrong for the list,  that is my bad.
>
> Richard
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, May 01, 2006 11:20 PM
> Subject: [U2] Forum General Question
>
>
> > While I'm a MV person, I don't know everything about all of this
> > email/web/forum/thread stuff.
> >
> > What was the kind of U2 forum whereby a person posted a request and
> everyone
> > got it. Then each answer got sprayed to everyone. And so on until it
died.
> >
> > Now, it appears that only the person issuing the question gets the
reply
> and
> > many of us who might learn something of their public discussion are
out
of
> the
> > loop.
> >
> > Am I detecting this properly.
> >
> > Thanks
> > Mark Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Forum General Question

[Roger Glenfield]

Somebody's auto-email-responder zoomed out 50+ "I'll be back in the 
office on blah, blah, blah" in a single day.  At one point even 
responding to it's own 'responses'.


Mark Johnson wrote:

So why was it changed in the first place. I wonder how many liked it that
way.
Mark Johnson

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Forum General Question

[Mark Johnson]

So why was it changed in the first place. I wonder how many liked it that
way.
Mark Johnson
- Original Message -
From: "Richard Brown" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 01, 2006 11:45 PM
Subject: Re: [U2] Forum General Question


> I think what Larry is saying is that it is now back to the first scenario
> you described.  When you hit reply,  the message goes to the list, which
is
> then distributed to all of us.  I subscribe to different list.  Some I
have
> to know to hit 'reply to all' to get my message to everyone.  Some I can
> just hit reply and it goes to the list & the poster.  The poster will get
it
> twice,  once from me, once from the list.  Personally I don't care which
way
> it is setup.  If I reply wrong for the list,  that is my bad.
>
> Richard
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: 
> Sent: Monday, May 01, 2006 11:20 PM
> Subject: [U2] Forum General Question
>
>
> > While I'm a MV person, I don't know everything about all of this
> > email/web/forum/thread stuff.
> >
> > What was the kind of U2 forum whereby a person posted a request and
> everyone
> > got it. Then each answer got sprayed to everyone. And so on until it
died.
> >
> > Now, it appears that only the person issuing the question gets the reply
> and
> > many of us who might learn something of their public discussion are out
of
> the
> > loop.
> >
> > Am I detecting this properly.
> >
> > Thanks
> > Mark Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniVerse + PERL

[brian]

This sounds like an ODBC rather than a perl problem:

Have you enabled the account for ODBC? If it has not been created as a SQL 
Schema, you need to explicitly set up ODBC in that account using the HS.ADMIN 
menu in the HS.ADMIN account. (LOGTO HS.ADMIN, run HS.ADMIN, select option 3 to 
enable an account).

BUT BEFORE YOU DO SO...

I would suggest reading the UniODBC and UCI guides before doing so unless it is 
just a test account. There are a couple of steps you need to perform before it 
is likely to be successful: as a minimum you need to ensure any fields you are 
working with use D/I types (not A/S) and have their SQL types, M/S and any 
associations fully defined. You will also need to include them in an @SELECT 
phrase in the dictionary to make columns visible. 

There's a few other things that you should really do to make a clean ODBC-like 
view, but that will probably be enough for testing the concept. Oh, and 
remember to run HS.UPDATE.FILEINFO after any dictionary changes: ODBC uses a 
file information cache that only updates after this command.

I have a draft article about using UniVerse ODBC/OleDB I can probably send you 
if you email me off-list: sorry to anyone else but it won't be publically 
available until next month (it is being printed in a newsletter first).

Brian

>Dear All
>
>
>
>Is it possible to use Perl connect to UniVerse backend  to run some UV
>Command , like CREATE FILE , SELECT FILE?
>
>
>
>Current im trying using DBD::ODBC , the uv connection is find but
>statement execution failed . any idea ??
>
>
>
>
>
>use DBD::ODBC;
>
>my $db = DBI->connect('dbi:ODBC:UVSOURCE',"userid","password") ||
>die("Connection failed") ;
>
>my $cmd="SELECT * FROM VOC;" ;
>
>my $stmt= $db->prepare($cmd);
>
>
>
>Error Shown as below :
>
>
>
>DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 ,
>Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around "VOC"):
>SQL statement referenced a nonexistent table or view.
>
>
>
>
>
>Thanks & Regards
>---
>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] UniVerse + PERL

[Hona, David S]

Try removing the ";" (semi-colon) from your SQL query. It isn't
required.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong
Sent: Tuesday, 2 May 2006 8:36 PM
To: U2-Users New Lists
Subject: [U2] UniVerse + PERL

Dear All



Is it possible to use Perl connect to UniVerse backend  to run some UV
Command , like CREATE FILE , SELECT FILE?



Current im trying using DBD::ODBC , the uv connection is find but
statement execution failed . any idea ??





use DBD::ODBC;

my $db = DBI->connect('dbi:ODBC:UVSOURCE',"userid","password") ||
die("Connection failed") ;

my $cmd="SELECT * FROM VOC;" ;

my $stmt= $db->prepare($cmd);



Error Shown as below :



DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 ,
Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around "VOC"):
SQL statement referenced a nonexistent table or view.





Thanks & Regards
---
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] UniVerse + PERL

[Christophe Marchal]

Hi,

Another way is to use swig (www.swig.org) combine with Intercall UV 
library to make a new perl library.
With this tools, you got a "pure" perl library with all functions to 
access your Universe.


I used this with Python successfully :-)

Christophe Marchal

Ang Suan Yong wrote:

Dear All



Is it possible to use Perl connect to UniVerse backend  to run some UV
Command , like CREATE FILE , SELECT FILE?



Current im trying using DBD::ODBC , the uv connection is find but
statement execution failed . any idea ??





use DBD::ODBC;

my $db = DBI->connect('dbi:ODBC:UVSOURCE',"userid","password") ||
die("Connection failed") ;

my $cmd="SELECT * FROM VOC;" ;

my $stmt= $db->prepare($cmd);



Error Shown as below :



DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 ,
Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around "VOC"):
SQL statement referenced a nonexistent table or view.





Thanks & Regards
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UniVerse + PERL

[Ang Suan Yong]

Dear All



Is it possible to use Perl connect to UniVerse backend  to run some UV
Command , like CREATE FILE , SELECT FILE?



Current im trying using DBD::ODBC , the uv connection is find but
statement execution failed . any idea ??





use DBD::ODBC;

my $db = DBI->connect('dbi:ODBC:UVSOURCE',"userid","password") ||
die("Connection failed") ;

my $cmd="SELECT * FROM VOC;" ;

my $stmt= $db->prepare($cmd);



Error Shown as below :



DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 ,
Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around "VOC"):
SQL statement referenced a nonexistent table or view.





Thanks & Regards
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/