RE: [U2] RE: Unidata v6 into SQL 2005

[Angelo Collazo]

Graham,

We do it every day. We use UniData BCI and it works great. Documentation is
on the IBM website. Hope this helps.

Cheers,

Angelo

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Thursday, November 09, 2006 11:29 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] RE: Unidata v6 into SQL 2005

I have resolved the 200 character problem by splitting the field into
MV.

Next dilemma is how to get really time updates from Unidata into SQL. I
was thinking about adding a trigger to the Unidata file which execute a
SQL command to update the SQL database?

Very grateful for any advice on how anyone else has achieved really time
updates from Unidata to another database.

Thanks

Graham Forbes


-Original Message-
From: Forbes,G,Graham,JGFT C
Sent: Wednesday, November 08, 2006 12:53 PM
To: 'u2-users@listserver.u2ug.org'
Subject: Unidata v6 into SQL 2005


Hello all

Has anyone experienced problems importing data from Unidata into SQL
2005 using the IBM ODBC driver 3.01? I have a problem with text being
truncated at 200 characters and the import hanging on certain records.

Has anyone tried using Redback OLE DB?

Thanks

Graham
---
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] udt problem

[Angelo Collazo]

Ron is correct,

Do a cd $UDTBIN then do the tar -xvf and then updatesys.

Cheers,

Angelo Collazo
System Administrator


Long shot but this happened to me once. The tar file must be untar'd from
the udt directory, not your upgrade directory. Its meant to over right some
things.


Ron Sharcott (3635)


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christensen, Steve
Sent: Wednesday, November 08, 2006 3:23 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] udt problem


Thanks for the suggestions.  Unfortunately getting the following when
forcing the shutdown:

Attach shared memory fail.
stopud failed.
The Unidata service cannot be stopped.

Reboot does not fix the problem either.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin
Sent: Wednesday, November 08, 2006 4:14 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] udt problem

Did you try "stopud -f"? That will force UD to stop even if it thinks users
still have Unidata sessions running.

If that doesn't work, sounds like you need to reboot the server.

Note that these suggestions are only recommended as a last resort, as you
run the risk of corrupting your data.

Good luck,
Tom

>>> [EMAIL PROTECTED] 11/08/06 4:13 PM >>>
Can anyone tell me what to do about this problem:
Trying to start udt from command line generates the following error:

Start SMM first!

This is on Unidata 5.1.27 running locally.

Tried startud but it is running and stopud refuses to stop it.

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


-
This e-mail and any attachments may contain CONFIDENTIAL information,
including PROTECTED HEALTH INFORMATION. If you are not the intended
recipient, any use or disclosure of this information is STRICTLY PROHIBITED;
you are requested to delete this e-mail and any attachments, notify the
sender immediately, and notify the LabCorp Privacy Officer at
[EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722.
---
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] SB+ Documentation

[Angelo Collazo]

Here you go. I send a copy to you via [EMAIL PROTECTED] Hope it helps.


Cheers,

Angelo Collazo
System Administrator


Does anyone know if there is documentation available for SB+ xxPROCESS
file and/or the screen definition record?



Larry Cordrey| UniVerse Developer | Paciolan | Your tickets, your way.
[EMAIL PROTECTED] | www.paciolan.com <http://www.paciolan.com/>  |
949.476.1772
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type application/octet-stream which had 
a name of System_Builder_Docs.pdf]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Running UV command from Unix prompt

[Angelo Collazo]

Scott,

You should check and see if you also have a VOC entry called the same as the
account name, not just the LOGIN voc entry. Hope this helps.

Cheers,

Angelo Collazo
System Administrator


Hello all.

I am running a UV command from a Unix prompt (HPUX) and am attempting to
capture the output in a file. For instance,

/u1/uv/bin/uv "MYCOMMAND" > /tmp/MYOUTPUT.txt

The output file contains what appears to be terminal control characters
in the beginning although my program merely PRINTs "TEST", for instance,

$ ls -la /tmp/MYOUTPUT.txt
-rw-rw-r--   1 ltcpdevsdsccs  12 Nov  3 13:31
/tmp/MYOUTPUT.txt
$ more /tmp/MYOUTPUT.txt
^[[?1l^[>TEST
MYOUTPUT.txt: END

Is there a way to disable this from happening? I tried deleting the
login paragraph but that did not stop the characters from appearing.

Thanks in advance for you help.

...ds

***
This information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or privileged
material, the disclosure of which is governed by applicable law.  Any
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.  If you received this in
error, please contact the sender and destroy the materials contained in
this message.
***
---
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] Who uses Transaction Logging in Universe ???

[Angelo Collazo]

Patricia,

What are you trying to accomplish? 

AIX has a feature called snapshots.
The concept with snapshot is COW or copy on write, as opposed to a 
"moment in time" of JFS2 filesystem.

Cheers,

Angelo Collazo
System Administrator


-Original Message-
 
I am investigating using transaction logging on our Universe DB. We are
running 10.1.17 on AIX 5.3...



*   Who uses it - Love it or hate it?
*   Downsides/Upsides/Gotchyas!
*   Any 3rd party alternatives?
*   General Remarks



I need the 411 that the Universe PDF neglects to tell you about -



Thanks





Patricia M. Wilson

MIS Programmer

x 3095

813.635.3095

[EMAIL PROTECTED]
---
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] ODBC connections [ad]

[Angelo Collazo]

Paul,

Here is a document on how to configure Easysoft for UniVerse. In fact, It
was first installed for UniVerse then UniData. "Accessing ODBC Databases
from IBM UniVerse/UniData"

http://www.easysoft.com/applications/ibm-universe-unidata/odbc.html

You Can do a search on their website.

Also, Here is a "Success story" on the U2UG website. See link and story
below:
Using the EasySoft ODBC-ODBC Bridge product, we are able to establish
two-way connectivity between our Universe and Oracle databases.
http://www.u2ug.org/index.php?module=pnForum&func=viewtopic&topic=127

Posted: 03.08.2004, 15:29
We have just successfully connected our Universe database with our Oracle
database using Easysoft's ODBC-ODBC Bridge.

To sum up what we have accomplished, so that we can add to your knowledge
base:

The requirement is to enable an ODBC connection between Universe and Oracle,
both of which run on Unix. Either database must be able to initiate a
transaction, i.e. Universe can connect to Oracle and Oracle can connect to
Universe.

We tried the Data Direct ODBC client for Unix to tie Universe to Oracle, but
it served only the Universe BCI call to Oracle. It did not satisfy the need
to connect to Universe from Oracle using Oracle's Heterogenous Gateway.

Since Universe does not have an ODBC client that runs on Unix, we have to
bounce the ODBC call from our Oracle database to an NT/2000 server in order
to access the Universe ODBC client.

EasySoft, in England, has a product they call an ODBC-ODBC Bridge. This is
composed of an OOB server, which in our case runs on an NT/2000 box, and an
OOB client, which can run from Windows, Unix or Linux. When an ODBC call is
issued from the database, the OOB client on the local server calls the OOB
server on the NT/2000 box, which then redirects the call to the ODBC client
running on the NT/2000 server, which then proceeds to connect to the target
database.

Using the EasySoft ODBC-ODBC Bridge product, we are able to establish
two-way connectivity between our Universe and Oracle databases.

Licensing for the Easysoft ODBC-ODBC Bridge is based on the server. You can
have as many clients as needed. They have a per server license plan, or you
can get a site license if you need to have 4 or more servers on the same
site. 8-)

Hope this helps.

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Janet Bond
Sent: Tuesday, October 31, 2006 8:31 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] ODBC connections [ad]

Hi Paul,

If you would like to call me I can get you connected with one of the
developers to discuss your options.

Janet
FusionWare Corporation
Sales Operation Manager
1.800.266.2326 x1159 [ad]



From: [EMAIL PROTECTED] on behalf of I-Rafferty, Paul
Sent: Tue 10/31/2006 1:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] ODBC connections



Thanks for the updates.

Unfortunately Easysoft do not sell odbc drivers for Universe.
We have decided to use one of the Oracle databases on Windows as a
gateway to the Universe database.
It seems to be the easiest way at this stage.

Thanks again.
Paul.


-Original Message-
From: Adrian Merrall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 31 October 2006 10:16 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] ODBC connections

> Also on your Universe on HPUX via odbc you will need an HPUX driver
> either
> 32 or 64 bit. You can get this from http://www.easysoft.com
<http://www.easysoft.com/>

I think from reading the OP Paul needs a Linux ODBC client that can
speak to Universe on HPUX.

If IBM only provide a windows based odbc client for Universe then he
might have a problem here.  A solution may be to use the JDBC driver
provided by IBM as Janet suggested but use a odbc-jdbc bridge so the
Oracle client can use ODBC.  A quick google shows one from easysoft and
one from Sun as part of the java stack.

Plan B is to talk directly to the Universe jdbc driver of course but if
you are going to be writing java code then consensus on the list is
usually to use uniobjects directly.

HTH
Adrian
---
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/

[demime 1.01d removed an attachment of type application/ms-tnef which had a
name of winmail.dat]
---
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] ODBC connections

[Angelo Collazo]

Paul,

Also on your Universe on HPUX via odbc you will need an HPUX driver either
32 or 64 bit. You can get this from http://www.easysoft.com

Cheers,

Angelo Collazo
System Administrator


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Janet Bond
Sent: Monday, October 30, 2006 1:54 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] ODBC connections

Hello Paul,

You are going to have to contact Oracle and see if they have a Linux
client for ODBC. Once you have this you should be able to configure the
access to your Universe server. The setup process will be like the
process you performed for your Oracle on Windows.

With ODBC being a Windows middleware you may find the Linux client does
not exist. You may have to use JDBC.

Hope this helps

Janet Bond
FusionWare Corporation
Sales Operation Manager
1.866.266.2326 x159

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of I-Rafferty,
Paul
Sent: Sunday, October 29, 2006 7:21 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] ODBC connections

Hi All,

I'm sure this questions already been asked so apologies in advance for
going over old ground.

Does anyone know of any ODBC drivers suitable for connection to Universe
on HPUX from Oracle running on RedHat linux.

I have installed the Universe ODBC driver on our Windows servers and all
is working well connecting to Universe on HPUX from Oracle on Windows.

However, we have a requirement to connect from Oracle on Redhat to
Universe on HPUX via odbc.


Thanks in advance.

Paul.
---
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] What Flavor UV ?

[Angelo Collazo]

Bill,

>From ECL/TCL do .RELLEVEL (DON'T FORGET THE DOT...)

Cheers,

Angelo Collazo
System Administrator


How do I determine what UniVerse flavor is running, on an old HP-UX machine?

--Bill

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ron White
Sent: Thursday, October 26, 2006 12:53 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] New Account Setup - Copy VOC ?


Brutzman, Bill wrote:
> In UniVerse 10.1, I can setup a new account with the Admin tool.
>
> Upon entering the command
>
>   ED VOC LOGIN
>
> I obtain
>
>   Verb "ED" is not in your account.
>
> Should I copy the VOC file from our main account to this new account?
>
> VOC in our main account is rather large, 1.3-MB.  VOC in the new account
is
> tiny, 40-KB.
>
> There is plenty of disk space.  I am surprised that "ED" functionality is
> not there on the new account.
>
> Suggestions would be appreciated.
>
> --Bill
>
>
I have never heard of this happening.  I would use UniAdmin to delete the
account and recreate it.  Check that the flavor and account path are
correct.
I am on M$ platform but it should work the same on *nix.

Ron White
---
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] Remote (qfile) restrictions - (UV)

[Angelo Collazo]

John,

One way of accomplishing this is to: (this varies base on what flavor you
are running (UniVerse IDEAL/PICK/REALITY/PRIME...)

This example is UniVerse/Pick flavor

1- Copy the SET-FILE VOC entry to SET-FILEB
2- Write a program that will prompt you for the account name and file name,
**BETTER YET,**DON'T prompt
SENT = TRIM(@SENTENCE)
ANAME = FIELD(SENT," ",2)
FNAME = FIELD(SENT," ",3)
IF ANAME = "" OR FNAME = "" THEN
PRINT "Usage: SET-FILE account_name file_name"
   STOP
END
*This way, if your PRODUCTION app's is using the SET-FILE then your new
program handles it.

3- PERFORM the SET-FILEB with account name and file name ONLY if it passes
your EDIT (restricted area) or create an ARRAY and
write to the VOC file.
4- DELETE VOC SET-FILE
5- AE or ED VOC SET-FILE
6- 001 PA
7- 002 YOUR PROGRAM NAME
or
  CATALOG your new program
8-

PS. TEST and DEBUG..hope it helps. 2 1/2 cents please...

Cheers,

Angelo

On UniVerse version 9.6.1.6  HP-UX

We can create "q-pointers" to any directory path on the system such that
writes to a q-pointed file will write to the specified directory.
Is there any way to restrict that mechanism to prevent "accidental"
access.

Our Production account is mirrored from the Production box onto the
backup (DEV) box as a (disaster recovery) account.
As such we need to be able to restore /activate it at short notice.
BUT
We do not want any inadvertent updates to that account via these
q-pointers.

Ideally I would like UniVerse to tell me that I cannot create a
q-pointer to a 'restricted' area. I don't think it will do that.
I do not want to change the unix permissions because that could
interfere with the DR copying processes and would probably need to be
undone if we need to switch over.


Any ideas would be welcome.

Cheers



John Rodgers
---
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: [sbs] RE: [U2] SBClient Question - Apply Logout Script to SBCLIENT

[Angelo Collazo]

Correction: /ud/bin/deleteuser NOT kill PID.

Cheers,

Angelo Collazo
System Administrator



Stuart or Others,

The solution provided here works well when the "logout_script" is executed
in normal SBClient logout but when you do a kill PID( I know, not a good
practice, but we have users idled for over five+ ours) on it, It does NOT
execute the "logout_script" and it shows the "Session Disconnected" and you
have to press .

Any solutions or other methods will be appreciated.

Cheers,

Angelo Collazo
System Administrator


   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/
---
SBSolutions mailing list
[EMAIL PROTECTED]
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] SBClient Question - Apply Logout Script to SBCLIENT

[Angelo Collazo]

Stuart or Others,

The solution provided here works well when the "logout_script" is executed
in normal SBClient logout but when you do a kill PID( I know, not a good
practice, but we have users idled for over five+ ours) on it, It does NOT
execute the "logout_script" and it shows the "Session Disconnected" and you
have to press .

Any solutions or other methods will be appreciated.

Cheers,

Angelo Collazo
System Administrator


   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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Cron job creates many &PH& entries

[Angelo Collazo]

Scott,

Why are you running this job as a phantom every minute and not just the
DUPCHECK program? Can you send a copy of it?

Cheers,

Angelo Collazo
System Administrator


Universe 10.1.4, pick flavor, Red Hat

I have a UV phantom cron job that runs every minute. It checks a
directory for any inbound files, processes them, then writes them to an
outbound directory. My problem is that the &PH& directory is filling up
with DUPCHECK_time_date files (1440 per day). Anyone know how to turn
off this feature?

Here is the cron job:

#!/bin/sh
TERM=ansi ; export TERM
cd /usr/yyy/XXX
/usr/ibm/uv/bin/uv "PHANTOM DUPCHECK"

DUPCHECK is a cataloged basic program in the XXX account.

Thanks,

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
---
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] SBClient Question - Apply Logout Script to SBCLIENT

[Angelo Collazo]

This worked for me. Thanks Stuart.

Cheers,

Angelo Collazo
System Administrator


   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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Re: U2 Users Digest V1 #1346

[Angelo Collazo]

Retired, go ahead and rub it in.

Enjoy and Cheers,

Angelo Collazo
System Administrator


Please unsubscribe me. I am retired.
Thank you
George W. Kitchen

Witnessing isn't just a job to be done, it's a life to be lived

- Original Message -
From: "U2 Users Digest" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2006 4:05 AM
Subject: U2 Users Digest V1 #1346


>
> U2 Users Digest  Wednesday, October 4 2006  Volume 01 : Number
1346
>
>
>
> In this issue:
>
> [U2] [UV] How to create unix ".netrc" file?
> RE: [U2] [UV] How to create unix ".netrc" file?
> RE: [U2] [UV] How to create unix ".netrc" file?
> [U2] PE License
>
> --
>
> Date: Wed, 4 Oct 2006 15:56:49 +1000
> From: [EMAIL PROTECTED]
> Subject: [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.
> **
>
> --
>
> Date: Wed, 04 Oct 2006 16:41:35 +1000
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: RE: [U2] [UV] How to create unix ".netrc" file?
>
> [EMAIL PROTECTED] wrote:
> > 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?
>
> use vi? ;^)
>
> From inside UV, I'd try:
>
> EXECUTE \SH -c "touch /home/acctb/.netrc"\
>
> and then open it, read it and modify it before writing back.
>
> Cheers,
>
> Ken
>
> --
>
> Date: Wed, 4 Oct 2006 14:55:24 +0800
> From: "Womack, Adrian" <[EMAIL PROTECTED]>
> 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.
>
> - -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
> Sent: Wednesday, 4 October 2006 1:57 PM
> To: u2-users@listserver.u2ug.org
> Subject: [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
>
>
>
>
> DISCLAIMER:
> 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.
>
> --
>
> Date: Wed, 4 Oct 2006 09:21:55 +0200
> From: "Andrew Lakeland" <[EMAIL PROTECTED]>
> Subject: [U2] PE License
>
> Has anyone had any problems with the licenses on the latest Personal=0D=0A
> Edition.=0D=0A
> =0D=0A
>  =0D=0A
> =0D=0A
> I can load the software and 

RE: [U2] PORT.STATUS bug?

[Angelo Collazo]

Scott,

We run AIX 5.3 and UniData 6.1.17-64 and we have the same problem with
phantoms.

What we did is create a baby sitter that stops and starts our phantoms every
three hours.

In our case is not related to PORT.STATUS, just phantoms hanging. In our
case PORT.STATUS  is based of the /ud/include/udtconfignfig and the variable
is TMP=/flo164/tmp/

Hope this helps.

Cheers,

Angelo Collazo
System Administrator

Hi all,

HPUX 11
UV10.1.8

Has anyone had any problems with PORT.STATUS causing phantom jobs to hang?
We have background jobs that, every once in a while, will hang.  When
looking at the output from PORT.STATUS the last command is always some
simple EXECUTE.  For example, the batch job EXECUTES a SH -C "ls
./dir/whatever*" and, seemingly, fails to return.

I did see the following in the PH record
":nanosleep: Interrupted system call"

How does PORT.STATUS work internally anywho?

Thanks,

Scott
---
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] SBClient Question - Apply Logout Script to SBCLIENT

[Angelo Collazo]

I was wondering if anyone has already done this and care to share the
results. I have been given the following task:

- Create script that will close out SBCLIENT session and
not prompt end-user to save changes to session


- * There is a slot in SBLCLIENT that allows custom scripts,
but we have not been able to provide the proper syntax
to get this to work


- - Problem on Terminal Server that keeps the session active
even though the end-user closed out the session from
Terminal Server

Cheers,

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

RE: [U2][UV] Version question

[Angelo Collazo]

Nick,

>From ecl/tcl do a .L RELLEVEL. Hope this helps.

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina
Sent: Thursday, September 21, 2006 8:50 AM
To: u2-users@listserver.u2ug.org
Subject: [U2][UV] Version question

How can I tell which version of universe is installed on the server?  I know
this has been asked before, but I cannot find the email.

Thanks,

Nick Cipollina

MCTS, MCP
ACS Heritage, Inc.
2810 North Parham Road, Suite 210
Richmond, VA 23294
(804)965-8294
---
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] Select with Multiple Indices Not Working

[Angelo Collazo]

If you have the luxury and can do a build.index on primetime then do it.
This would rule out corrupted indexes.

Hope It helps.

Cheers,

Angelo

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave S
Sent: Tuesday, August 29, 2006 9:54 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select with Multiple Indices Not Working

We have a file that has the customer number and invoice date indexed.

  When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH
INV.DATE = '12/14/05'" no items are selected.

  We are running Unidata 6.0.6.

  Is anyone aware of any issues ?


-
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small
Business.
---
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] Convert to date and Time

[Angelo Collazo]

Krish,

Why don't you just transfer the data to MS Excel already converted?
Example.
DT=OCONV(FIELD(DATE_Time_Qty,'*',1),'D4/')
TM1=FIELD(DATE_Time_Qty,'*',2)
TM=OCONV(FIELD(TM1,'.',1),'MT')

You can create a dict or eval item.

Hope it helps.

Cheers,
Angelo
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 29, 2006 9:53 AM
To: [EMAIL PROTECTED]
Subject: [U2] Convert to date and Time

I need to convert a Multivalue field to Date and Time format in MS Excel.
The Mutivalue filed has the following description and the value next to
that.
Date_Time_Qty: 14121*31190.858
Any suggestion is appreciated.
Thanks.

Krish
---
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] Monitoring UniData services and deamons

[Angelo Collazo]

Im in the processes of installing a Resource Management Engine (application
manager) and I needed to know if anyone could add additional information
that I should be also monitoring other than the ones below.

SMM is started. root 131248  1   0 11:39:40  pts/0  0:00 /ud/bin/smm -t
60
Unirpcd is started  root 221254  1   0 11:39:43  pts/0  0:00
/ud/unishared/unirpc/unirpcd
SBCS is started. root 184674  1   0 11:39:44  pts/0  0:00
/ud/bin/sbcs -r
CLEANUPD is started. root 274780  1   0 11:39:47  pts/0  0:00
/ud/bin/cleanupd -m 10 -t 20

Environment: UniData 6.1.17-64 under AIX 5.3

Cheers and TIA,

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

RE: [U2] Set udt priority on Unix (Solaris,Aix,HP)

[Angelo Collazo]

Here is how to INCREASE priority on AIX, Hope it helps. I know, it's kind of
backwards. Don't shoot the messenger.
AIX-RENICE;aix-nice
renice -n 5 -p 2076946  ;*by using a positive 5 = increase nice
;*priority number, which makes it slower(+ 5 =
;*slower)
renice -n -5 -p 2076946 ;*by using a negative 5 = decrease nice
;*priority number, which makes it faster(- 5 =
;*slower)


Cheers,

Angelo

> How do you do this on Unix for udt and can you set the priority for a
> phantom process ?

I haven't done this, but I assume you can use nice for the particular udt
and change it's scheduling priority.

Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"You're not right, Daddy"
my 3-year old showing her wisdom
---
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] Unidata/Oracle connection problem

[Angelo Collazo]

Sara,

Is your UniVerse a 32bit or 64bit dbms?

Cheers,

Angelo

We have been transferring data from UniVerse to Oracle and SQLServer for
many years now using the BCI.  We also query those databases and bring data
to UniVerse also using BCI.

We use Openlink software  http://www.openlinksw.com/
   as the ODBC Manager which is linked into
UniVerse.  Works very well.  Our users expect real-time replication of data
as they create it in UniVerse and expect to be able to use in immediately in
Oracle.  Normally this expectation is satisfied.

Sara Burns

Sara Burns (SEB)


Integration Manager

Public Trust
Phone: +64 (04) 978 4534 (DDI)

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>


The information contained in this communication (including any attachment)
is confidential. If you are not the intended recipient, please destroy this
communication. You must not disclose, copy or use in any way the information
contained in this communication. Any views expressed in this communication
are not necessarily the views of Public Trust. No representation is made
that this communication is free of error, virus or interference.

.



A family trust can help you protect your assets if the unexpected happens.
To find out how a family trust works and if one's right for you, call 0800
505 405.
---
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] Unidata/Oracle connection problem

[Angelo Collazo]

Here you go.
http://www.easysoft.com/

Cheers,

Angelo

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor
Sent: Wednesday, August 02, 2006 9:54 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata/Oracle connection problem

   Yes

   Actually  we  identified another problem. That being the fact that the
   Oracle  client  on  Unix did NOT include an ODBC driver from what I am
   being  told.   We  are  investigating other commercial and open source
   drivers.  If anyone has any suggestions it would be appreciated.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  "Angelo
   Collazo" <[EMAIL PROTECTED]>
   Sent: Tuesday, August 01, 2006 4:36 PM
   To: 
   Subject: RE: [U2] Unidata/Oracle connection problem

   Richard,
   Did you do a relink.udlibs? That is what CONNECT uses.
   Cheers,
   Angelo
   More info on this:
   I was able to successfully use the Oracle Client using SQLplus.
   However attempts to use CONNECT from the tcl prompt return the
   following:
   SQLConnect error: Status = -1 SQLState = 0 Natcode = 3349920
   We think our problem is in the libodbc.sl (HPUX version 11). This is
   still linked to the file in the Unidata application path. We can not
   find any other occurrence of this file. This is the ODBC Driver
   manager and I believe that this is necessary.
   Can anyone point out what you are using for this and where you got the
   file?
   Thanks
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   __
   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED] On Behalf Of Richard
   Taylor
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem
   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   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@l

RE: [U2] OT: Email Attachment Universe Linux

[Angelo Collazo]

Anthony,

If you look at the properties of your outlook email (the one that worked
properly), you will see this text "MIME-Version: 1.0" Content-Type:
multipart/mixed.. "This is a multi-part message in MIME format. ". You
need to echo this text, see below: The key is "multipart/"

Hope this helps,
Cheers,

Angelo
***
CMD = ''
CMD<-1> = 't="':EMAIL:'"'
CMD<-1> = 'f="x.com"'
CMD<-1> = 'F="The IBM"'
CMD<-1> = 'a="/tmp/':TNAME:'"'
CMD<-1> = 'A="':TNAME:'.txt"'
CMD<-1> = 's="Emailing: ${A}"'
CMD<-1> = 'p=`perl -e ':SQ:'printf "_NextPart_%03D_%04D_%08X.%08X",'
CMD<-1> = '   rand(1000), rand(1),time(),time()+1':SQ:'`'
CMD<-1> = '('
CMD<-1> = 'echo "Return-path: <${f}>"'
CMD<-1> = 'echo "From: \"${F}\" <${f}>"'
 ***
CMD<-1> = 'echo "To: \"${t}\""'
CMD<-1> = 'echo "Subject: ${s}"'
CMD<-1> = 'echo "MIME-Version: 1.0"'
CMD<-1> = 'echo "Content-Type: multipart/mixed':SEMI:'\n\tboundary=\"=$
CMD<-1> = 'echo "This is a multi-part message in MIME format.\n--=${p}"
CMD<-1> = 'echo "Content-Type: text/plain':SEMI:'\n\tcharset=\"iso-8859-1\"
CMD<-1> = 'echo "Content-Transfer-Encoding: 7bit\n"'
*!*CMD<-1> = 'if [ ! -z "${b}" ]'
*!*CMD<-1> = 'then'
*!*CMD<-1> = '  cat "${b}"'
*!*CMD<-1> = 'fi'
CMD<-1> = 'if [ ! -z "${a}" ]'
CMD<-1> = 'then'
CMD<-1> = '  echo "--=${p}"'

CMD<-1> = '  echo "Content-Type: octet-stream':SEMI:'\n\tname=\"${A}.gz\""'
CMD<-1> = '  echo "Content-Disposition: attachment':SEMI:'\n\tfilename=\"${
CMD<-1> = '  echo "Content-Transfer-Encoding: base64\n"'
CMD<-1> = '  cat "${a}" | /tcpprint/crnl | gzip |'
CMD<-1> = 'perl -MMIME::Base64 -0777 -ne ':SQ:'print encode_base64($_)'
CMD<-1> = 'fi'
CMD<-1> = 'echo "--=${p}--"'
CMD<-1> = ') | /usr/sbin/sendmail ':SENDMAIL.OPTS:' "${t}"'
***





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz
Sent: Wednesday, August 02, 2006 10:57 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] OT: Email Attachment Universe Linux

Hey guys,

We have a program that distributes information via various methods.  One
of which is to email the file as a PDF.  So, one of our users was on AOL
and then switched to Cox.  They read their email via the cox webmail
site on a browser.  The problem is that the attachment is coming over as
part of the message now and not as an attachment.  However, if they use
outlook as the email client, then the file is presented as an
attachment.  So, webmail client is doing something different than
outlook.  If I send an attachment to the person using outlook on my PC,
then the attachment comes thru as an attachment on the webmail client.

So, I think the problem is the way I am sending the email / attachment.
I am using the following;

uuencode MYFILE.PDF MYFILE.PDF | mail -s MYFILE.PDF -n
[EMAIL PROTECTED]

This is being done on a Linux machine and we are shelling out of
Universe to issue the command.  Any suggestions on how to make it better
?

Thanks

Anthony
---
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] Unidata/Oracle connection problem

[Angelo Collazo]

Richard,

Did you do a relink.udlibs? That is what CONNECT uses.

Cheers,

Angelo


   More info on this:

   I  was  able  to  successfully  use  the  Oracle Client using SQLplus.
   However  attempts  to  use  CONNECT  from  the  tcl  prompt return the
   following:

   SQLConnect error:  Status = -1  SQLState = 0  Natcode = 3349920

   We  think our problem is in the libodbc.sl (HPUX version 11).  This is
   still  linked to the file in the Unidata application path.  We can not
   find  any  other  occurrence  of  this  file.  This is the ODBC Driver
   manager and I believe that this is necessary.

   Can anyone point out what you are using for this and where you got the
   file?

   Thanks

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  Richard
   Taylor <[EMAIL PROTECTED]>
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem

   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   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] Unidata/Oracle connection problem

[Angelo Collazo]

Rich,

One important issue to know is to determine if you need a 64 or 32 bit UNIX
driver. Also what is your .udlibs soft link look like? Hope this helps.


Take a look-see at this link.
http://www.easysoft.com/cgi-bin/search/search.cgi



Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor
Sent: Monday, July 31, 2006 3:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata/Oracle connection problem

   I  am  attempting to setup a data source under Unix to allow access to
   an  Oracle  database.   I  am  having a lot of trouble getting this to
   work.

   I have:

   7Installed the oracle client

   7Setup a place to hold the driving library

   7 Setup  a  folder  to  hold  my  odbc.ini  file  and  set the
   ODBCSYSINI environment variable to point there.

   7I created the odbc.ini file as shown below.

   7 My  oracle  dba  also  did  some configuration setup for the
   Oracle client and was able to connect through the client.

   [DV83]

   Driver=/usr/local/lib/hsdb_odbc.sl

   Description=Oracle ODBC on test system

   SERVER=testserver

   PORT=1521

   USER=test_user

   Password=**

   Database=DV83

   OPTION=3

   SOCKET=

   TraceFile=/production/udtmp/odbc_rich.trace

   Trace=1

   Can  anyone  tell me if they have successfully gotten a BCI connection
   going  to  Oracle  and  how  you did it. By the way I am on an HP Unix
   system.

   Thanks in advance for any help.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
---
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] [ot] 128mb flash drives (seems like a good price)

[Angelo Collazo]

George,

I'm getting ready to order one, It wants a "Referral's Email", should I  use
your email? You might get a nice gift.


Cheers,

Angelo,
http://www.ewiz.com/detail.php?src=eb&name=ALUMI-128

Seems like a good price, looked like free shipping using UPS ground.

and now, back to our regular programming

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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV - tech support

[Angelo Collazo]

So did you pay or not?

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Friday, July 07, 2006 11:32 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV - tech support

I beg to differ.Below is an email I received from microsoft
when I attempted to report a bug I found in IE 6
(What other company do you know of that charges you to report a bug to
them?)

Hello George,
Thank you for contacting Microsoft Online Customer Service.
I apologize for any delay in our response to your issue. Due to an increase
in requests, our response may be longer than usual. We appreciate your
patience.

I understand you have identified a bug in Internet Explorer 6 and you would
like to report this bug.
I request you contact the Microsoft Product Support Services team to submit
a report with regard to the bug you have identified in Internet Explorer 6.
You may contact them by calling (800) 642-7676. Representatives in this team
are available 24 hours a day. You may have to pay for the support and then
arrange for a refund if the SP determines the issue is in fact produced by a
bug.

You may also submit a Product Bug Report through mail by sending a letter
containing a complete description of the bug including the actions,
software, and hardware associated with the bug and whether or not it is
consistently reproducible. This letter can be sent to the address specified
below:

Attn:  Development Group
Microsoft Corporation
One Microsoft Way
Redmond, WA 98052
You may have to pay for the support and then arrange for a refund if the SP
determines the issue is in fact produced by a bug.

George, I hope the above information is helpful. If you have additional
concerns, please do write back to us
http://support.microsoft.com/oas/default.aspx?gprid=1139

Thank you for using Microsoft products and services
Rajeesh
Microsoft Online Customer Service Representative
If you have any feedback about your Online Customer Service experience,
please send an e-mail to my manager, Nikhil Ramachandran, at
[EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Marc Harbeson
> Sent: Friday, July 07, 2006 11:09 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] UV - tech support
>
>
> 
> This whole access think of IBM's is a big pile of crap.
>
> You would think getting end CLIENTS access to what they NEED
> would be a
> simple process - one that even the likes of Microsoft does better than
> IBM is doing.
>
> At least under the Informix flag we could get to the damn documents...
> 
---
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 Version for Windows 2003

[Angelo Collazo]

Rodrigo,

You can install the latest version. As far as I know this version  is
compiled on a 64 bit machine, but is  NOT 64 bit written. This came from an
instructor in Denver. Hope this helps.

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rodrigo Girlando
Sent: Thursday, June 22, 2006 3:07 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe Version for Windows 2003

>  Hi,
>
> This is my first mail, my name is Rodrigo and i would like to know if
> somenone could tell which is the version of Univese i have to install on a
> server with Windows 2003 (64 bits)
>
> Thanks,
>
>
> Rodrigo
---
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] How to connect file remotely

[Angelo Collazo]

Eugene,

All you simply need to do is share your laptop drive and map it on the
network with the path info. Hope this helps.

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Eugene Perry
Sent: Thursday, June 22, 2006 6:42 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] How to connect file remotely

Hello,

I am using a copy of Universe PE on my laptop and I am interested in
accessing
a file over the network.  Is there anyway to do that and how?

Thanks

Eugene
---
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] XML.H

[Angelo Collazo]

Are you talking about this? Symeon.

**
*
*   Header file for XML BASIC programs
*
*   Module  %M% Version %I% Date%H%
*
*   (c) Copyright 2002 IBM Inc. - All Rights Reserved
*   This is unpublished proprietary source code of Ardent Software Inc.
*   The copyright notice above does not evidence any actual or intented
*   publication of such source code.
*

***
*
*   Maintenence log - insert most recent change descriptions at top
*
*   Date GTAR# WHO
Description.
*
*   11/06/03   ZJH add for U2XMAP APIs.
*

*

* XML RETCODES and defines.

EQU XML.SUCCESS TO0
EQU XML.ERROR   TO   -1
EQU XML.INVALID.HANDLE  TO   -2
EQU XML.EOF TO  100

* Open mode for XMAPOpen() and XMLOpen()
EQU XML.READTO  0
EQU XML.WRITE   TO  1
EQU XML.READWRITE   TO  2
EQU XML.CREATE  TO  3

* Write mode for XMLWrite()
EQU XML.TO.FILE TO  0
EQU XML.TO.STRING   TO  1
EQU XML.TO.DOM  TO  2

* Flag for form File or from STRING
EQU XML.FROM.FILE   TO  0
EQU XML.FROM.STRING TO  1
EQU XML.FROM.DOMTO  2

* Field type for XMAP RELATIONSHIP (for internal use only)
EQU XML.NORMAL.FIELDTO  0
EQU XML.GENERATED.IDTO  1
EQU XML.ORDER.COLUMNTO  2
EQU XML.GEN.CANDIDATEKEYTO  3
EQU XML.CANDIDATE.KEY   TO  4
EQU XML.FOREIGN.KEY TO  5
EQU XML.GEN.FOREIGNKEY  TO  6

* Generated KEY type
EQU XKEY.XFIELD TO  1
EQU XKEY.SUBR   TO  2

* Macro for XDOM operations
EQU XDOM.TRUETO 1
EQU XDOM.FALSE   TO 0

EQU XDOM.DUP TO 1
EQU XDOM.NODUP   TO 0

* DOM Node type constants
EQU XDOM.NONETO 0
EQU XDOM.ELEMENT.NODETO 1
EQU XDOM.ATTR.NODE   TO 2
EQU XDOM.TEXT.NODE   TO 3
EQU XDOM.CDATA.NODE  TO 4
EQU XDOM.ENTITY.REF.NODE TO 5
EQU XDOM.ENTITY.NODE TO 6
EQU XDOM.PROC.INST.NODE  TO 7
EQU XDOM.COMMENT.NODETO 8
EQU XDOM.DOC.NODETO 9
EQU XDOM.DOC.TYPE.NODE   TO 10
EQU XDOM.DOC.FRAG.NODE   TO 11
EQU XDOM.NOTATION.NODE   TO 12
EQU XDOM.XML.DECL.NODE   TO 13

* DOM node traverse constants
EQU XDOM.NEXT.SIBLINGTO 0
EQU XDOM.PREV.SIBLINGTO 1
EQU XDOM.PARENT  TO 2
EQU XDOM.CHILD   TO 3
EQU XDOM.NEXT.SIBLING.WITH.SAME.NAME TO 4
EQU XDOM.PREV.SIBLING.WITH.SAME.NAME TO 5

* DOM child node index constant
EQU XDOM.FIRST.CHILDTO  0
EQU XDOM.LAST.CHILD TO  -1

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Symeon Breen
Sent: Wednesday, June 21, 2006 12:33 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] XML.H

Hi Guys - I seem to remember this being mentioned before, but I can not find
the email.

The XML.H include shipped with udt 7.1 does not have the equates for the
XDOM api (e.g. XML.FROM.FILE). Can someone pass them on to me please.


Thanks
Symeon.
---
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] Unidata 6 into SQL 2005

[Angelo Collazo]

Graham,

If you are running your U2 database under Windows, You can download the
CLIENT(s) and use the native U2 ODBC drivers. See this link:
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trials&S_
TACT=105AGX11&S_CMP=DNLD

If your are running under UNIX you to purchase one. Two I know of.

1- http://www.easysoft.com/
2- http://www.datadirect.com/index.ssp
3- Open source (http://www.mysql.com/) and search for ODBC. Two versions
UNIX(AIX/HP/Others) and Linux unixODBC)

May the force be with you.

Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 9:22 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata 6 into SQL 2005

Does anyone have any advice for which odbc drivers are best for
importing Unidata data into a SQL 2005 database?

Thanks

Graham

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall
Sent: Tuesday, June 20, 2006 2:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] .net - universe 10.1.14

Redback and .Net work perfectly together.   I've used it in a variety of
applications using both C# and VB.Net.   Full power of .Net is available
as
Redback simply makes U2 available.  You can build a Data Access Layer
where
U2 looks like any other database to .Net.

If you are from the .Net/SQL world,  you can access your Universe data
via
ADO same as other databases.   If you are not an ADO guru,  Redback
provides
its' own more U2 friendly commands to also access the Universe data and
programs.

You have total freedom in deciding how much or how little of your
business
logic to be in U2 or .Net.

Unlike like some of the other offerings,  Redback is not a 'do something
on
the web for the U2 programmer' type of application.   It is a true
enabler
to allow you to use U2 with the web and do whatever you can do in your
web
technology of choice.

Mike.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Tuesday, June 20, 2006 3:30 AM
To: U2-Users (E-mail)
Subject: [U2] .net - universe 10.1.14

Apologies I asked this before then went on tour for 3 weeks and my
wonderfull staff cleared by emails

So

I am looking to tie Universe 10.1.14 to a .net development

I am looking at biztalk and redback and one other piece of software to
facilitate this

Any experiences/opinions will be gratefully received (and read this
time)


Bob Witney
IT Senior
EXPLORE!
Nelson House
55 Victoria Road
Farnborough
Hampshire
GU14 7PA, UK
  Tel:  01252 379489
Mob: 07973 451156
www.explore.co.uk




__
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/
---
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] ODBC question

[Angelo Collazo]

After researching the data extraction from an SQL database via UniData/BCI
running on AIX I have realized that a third party ODBC driver is needed for
UNIX to behave like a client. An install document called "How to set up the
Easysoft ODBC-ODBC Bridge with UniData was sent to me by one of our fellow
groupies.( Brian Leach).  I have found the following so far(still
searching):

1- Easysoft USD 1399.00 for a single license
2- OpenAccessSoftware   USD  $995.00for a single cpu

Question:
a- Anyone using another lower cost vendor's ODBC driver and can share 
the
cost? And if so, are you happy with it.

Cheers,

Angelo Collazo
System Administrator
Silver Line Windows

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dana Baron
Sent: Thursday, June 08, 2006 9:33 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] ODBC question

Hi Marc,

Good question. Yes we have licenses for both Unidata and ODBC, however, our
server crashed hard a few months ago and I had to re-install Unidata (and
just about everything else). I haven't tried using ODBC since then. It could
be that the ODBC license wasn't re-installed correctly.

Dana Baron
System Manager
Smugglers' Notch Resort


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson
Sent: Thursday, June 08, 2006 8:08 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] ODBC question

Do you have a license to use ODBC?  Or  Is your UniData licensed?


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron
Sent: Thursday, June 08, 2006 8:11 AM
To: U2-Users
Subject: [U2] ODBC question

Hi,

While we're talking Unidata ODBC...

I'm having trouble getting UNIDATA ODBC working here. Server is Tru64
Unix.
Client is windows. UCI seems to be set up correctly. I can access the
data
and create views, etc with VSG. But, when I try to import or link to the
data from Access or Excel, I get the following error:

The ODBC screen pops up with most of the parameters filled in, except my
password. I put in the password (and yes, I've tried it a million times
and
the password is correct!) and an error pop-up says:

[Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not
authorized

Anyone have any suggestions?

Dana Baron
System Manager
Smugglers' Notch Resort
---
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] IBM U2 UniData ODBC sample working program

[Angelo Collazo]

Symeon,

1- What vendor are you using for the ODBC libraries/driver running under
UNIX?
2- Are you happy with them
3-

Cheers,

Angelo Collazo
System Administrator
Silver Line Windows

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Symeon Breen
Sent: Friday, June 02, 2006 9:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] IBM U2 UniData ODBC sample working program

Angelo - I have lots - i will send one on to you off list if that is ok 


Symeon.

On 02/06/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Angelo
>
> Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?)
>
> For BCI, check the (new) knowledge base at:
> www.mvopen.org/kb/
>
> There is an article on there "Accessing SQL Data through BCI".
> This takes you through the steps and there is demo data/programs
> available.
>
> For ODBC, I have a similar article - but I can't post it yet! (I'm still
> waiting for the official publication before I'm allowed to do that). But
if
> you email me offlist I can send you a copy.
>
> Brian
>
> >After searching the archive and to no avail, I would like to know if
> anyone
> >has a sample working program or (BCI.DEMO) working that could share a
> copy
> >of it.
> >
> >Cheers,
> >
> >Angelo
> >---
> >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] UDT Sequential File Length

[Angelo Collazo]

Brian,

I use OPENSEQ, READSEQ and WRITESEQ if needed. Hope this helps

Cheers,

Angelo

All,

Is there a simple way of getting the size of a file opened sequentially
under UniData short of actually reading though it in BASIC ? Something
equivalent to using the Status statement on UniVerse?

Must be OS neutral - no shelling out to "ls" or "DIR" I'm afraid.

Thanks

Brian
---
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] IBM U2 UniData ODBC sample working program

[Angelo Collazo]

Hello fellow groupies,


After downloading the document called "Accessing SQL Data through BCI", the
example is from U2 under Windows. It talks about U2 under UNIX but it
requires additional steps on how setup up ODBC because it is not native to
UNIX. I have found a .pdf file on the IBM website called Basic SQL client
Interface Guide for UniVerse. This one shows how from UNIX and UniVerse but
I need UNIX and Unidata.

My Enviroment on UniData versus UniVerse.

1- I 'm trying to follow the UNIX/UniVerse part of it and I will translate
all uv(uvhome vs udhome, uvlibs vs udlibs, ext...) I wanted to now the
following:
a- Needs UniRpc and I have UniRpc running in AIX/UniData.
root:/:# psgrep rpc

Search for "rpc"...
 UID PIDPPID   CSTIMETTY  TIME CMD
  daemon   98438   86376   0   Apr 22  -  0:00 /usr/sbin/rpc.statd
root 1622126   1   0   Jun 04  -  0:01
/ud/unishared/unirpc/unirpcd
root  102792   86376   0   Apr 22  -  0:00 /usr/sbin/rpc.lockd

b- Needs to run relink.uvlibs and I I have relink.udlibs? It shows that it
requires for UniVerse to be re-started?

Question:
1- Not sure if I should execute the relink.udlibs If UniRpc is already
running?, See My Enviroment #1.

c- Needs a file called UVodbc.config configured but I do NOT have a file
called UDodbc.config?

Question:
2- 2- I found ALL of this files under $UDTHOME:
root:/:# find ./ -name '*odbc*' -print|more
./ud/bin/lib.d/uddlls/libodbc.a
./ud/bin/lib.d/uddlls/odbc.so
./ud/bin/lib/uddlls/libodbc.a
./ud/bin/lib/uddlls/odbc.so
./ud/lib/uddlls/libodbc.a
./ud/lib/uddlls/odbc.so

./.odbc.ini ??  INVALID IP Address, could have been 
by predecessor trying
to setup UniData ODBC at one point?
root:/:# cat ./.odbc.ini
[MySQL-test]
Description = MySQL test database
Trace   = Off
TraceFile   = stderr
Driver  = MySQL
SERVER  = 192.168.1.26
USER= pharvey
PASSWORD=
PORT= 3306
DATABASE= test

[PostgreSQL]
Description = PostgreSQL driver for Linux & Win32
Driver  = /usr/local/lib/libodbcpsql.so
Setup   = /usr/local/lib/libodbcpsqlS.s
3- Talks about using UniAdmin or the UV account for data source creation but
the UniAdmin for the ud/sys for UniData does not have this feature?
Question:
4- What is the equivalent setup of the data source for UniData?

TIA and Cheers fellow groupies.
Angelo,
[EMAIL PROTECTED]


Angelo

Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?)

For BCI, check the (new) knowledge base at:
www.mvopen.org/kb/

There is an article on there "Accessing SQL Data through BCI".
This takes you through the steps and there is demo data/programs available.

For ODBC, I have a similar article - but I can't post it yet! (I'm still
waiting for the official publication before I'm allowed to do that). But if
you email me offlist I can send you a copy.

Brian

>After searching the archive and to no avail, I would like to know if anyone
>has a sample working program or (BCI.DEMO) working that could share a copy
>of it.
>
>Cheers,
>
>Angelo
>---
>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] IBM U2 UniData ODBC sample working program

[Angelo Collazo]

104 Symeon.

Thanks
[EMAIL PROTECTED]


Cheers,


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Symeon Breen
Sent: Friday, June 02, 2006 9:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] IBM U2 UniData ODBC sample working program

Angelo - I have lots - i will send one on to you off list if that is ok 


Symeon.

On 02/06/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Angelo
>
> Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?)
>
> For BCI, check the (new) knowledge base at:
> www.mvopen.org/kb/
>
> There is an article on there "Accessing SQL Data through BCI".
> This takes you through the steps and there is demo data/programs
> available.
>
> For ODBC, I have a similar article - but I can't post it yet! (I'm still
> waiting for the official publication before I'm allowed to do that). But
if
> you email me offlist I can send you a copy.
>
> Brian
>
> >After searching the archive and to no avail, I would like to know if
> anyone
> >has a sample working program or (BCI.DEMO) working that could share a
> copy
> >of it.
> >
> >Cheers,
> >
> >Angelo
> >---
> >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] IBM U2 UniData ODBC sample working program

[Angelo Collazo]

Bingo Brian, It's "ODBC from UniData (BCI)" and this document "Accessing SQL
Data through BCI" looks' like it has what I need. Once I get a working
sample program I will post it just so it will get documented in the list so
it can be searched, Or maybe my search criteria "UniData ODBC sample" in the
U2UG" in http://www.u2ug.org/ and then cliked on "Search the Site and Forum"
http://www.u2ug.org/index.php?name=Search  was not enough?


Cheers,

Angelo Collazo
System Administrator
Silver Line Windows
800-234-4228 ext.4495
732-509-8820 fax

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Friday, June 02, 2006 4:12 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] IBM U2 UniData ODBC sample working program

Angelo

Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?)

For BCI, check the (new) knowledge base at:
www.mvopen.org/kb/

There is an article on there "Accessing SQL Data through BCI".
This takes you through the steps and there is demo data/programs available.

For ODBC, I have a similar article - but I can't post it yet! (I'm still
waiting for the official publication before I'm allowed to do that). But if
you email me offlist I can send you a copy.

Brian

>After searching the archive and to no avail, I would like to know if anyone
>has a sample working program or (BCI.DEMO) working that could share a copy
>of it.
>
>Cheers,
>
>Angelo
>---
>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] IBM U2 UniData ODBC sample working program

[Angelo Collazo]

After searching the archive and to no avail, I would like to know if anyone
has a sample working program or (BCI.DEMO) working that could share a copy
of it.

Cheers,

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

RE: [U2] UV; RetrieVe's xml to Excel

[Angelo Collazo]

Adrian,

So what would it take to post the solution (with code) for those of us who
do not want to re-invent the wheel?


Cheers,

Angelo
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Adrian Merrall
Sent: Thursday, May 25, 2006 6:01 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV; RetrieVe's xml to Excel

Tom,

> Has anyone successfully developed a methodology to generate RetrieVe
reports
> so they have the proper schema to go right into an existing Excel
> spreadsheet?

Not straight into Excel no - but I wrote a java prog that takes the
XML (although generated by udbasic, not a query in this case) and uses
the apache poi library to generate the spreadsheet.

The java prog uses apache digester to parse the XML then generates the
spreadsheet and either writes it to a permanent file location or uses
the javamail api to mail it as an attachment.  Users love this, run
the prog and a short time later the spreadsheet is in their inbox.
For end of month processing etc. I write it to a samba mounted area
rather than emailing it so all the accountants can see it.

The poi stuff isn't hard, most of the work is making it look pretty
(colours, underlines, alignment etc).  Poi itself is very efficient.
To generate a spreadsheet with 5000 cells might take several seconds
to parse the XML but a second or less to turn it into a spreadsheet.

Sounds complex but if you have a vague idea how javamail and apache
digester works (google for tutorials) the whole thing only took a few
days and works very well and if you don't its a good excuse to play
with them.

All the java libs (poi, digester and mail) are cross platform, I
developed on my XP desktop and deployed on RHEL2.1.

HTH

Adrian
---
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: [SPAM] - [U2] [UD] XML Parse/Open/ReadXMLData - Bayesian Filter detected spam

[Angelo Collazo]

Donald ,

I can't see how it gets to the write statement ?
MOREDATA = 1
LOOP WHILE (MOREDATA=1) DO

Cheers,
 
Angelo Collazo
Sr. Programmer
PNY Technologies, Inc.
Phone:  (973) 560-5333
Fax:  (973) 560-5280
E-Mail:  [EMAIL PROTECTED]

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Don Verhagen
Sent: Monday, November 29, 2004 12:37 PM
To: [EMAIL PROTECTED]
Subject: [SPAM] - [U2] [UD] XML Parse/Open/ReadXMLData - Bayesian Filter
detected spam

I'm having a problem with creating an extraction file in Unidata 6.0.9
on HPUX 11.11i. It's not writting to the correct attribute as defined by
the dictionary item named in "field".

Simple XML Doc(test.xml):


Node1
Node2
Node3

-
Extraction Record (text.ext)











-
Test Program
*$BASICTYPE "U"
SUBROUTINE B.TEST.XML
OPEN '','TEST.FILE' TO F.TF ELSE RETURN
*
XML.FNAME = "_XML_/test.xml"
EXT.FNAME = "_XML_/TEST.EXT"
*
STATUS = PREPAREXML(XML.FNAME,F_XML)
IF NOT(STATUS) THEN
  STATUS = OPENXMLDATA(F_XML,EXT.FNAME,D_XML)
  IF NOT(STATUS) THEN
MOREDATA = 1
LOOP WHILE (MOREDATA=1) DO
  STATUS = READXMLDATA(D_XML,THIS.REC)
  IF NOT(STATUS) THEN
WRITE THIS.REC ON F.TF,'DON.XML'
MOREDATA = 0
  END ELSE
  MOREDATA = 0
  STOP 'XML ERROR'
END
  END
REPEAT
*
STATUS = CLOSEXMLDATA(D_XML)
STATUS = RELEASEXML(F_XML)

  END ELSE
   PRINT 'OPENXML ERROR'
  END
END ELSE
  PRINT 'PREPARE ERROR'
END
-

Results of Test record (DON.XML) written to TEST.FILE:
<1> node1
<2> node3
-
Unidata appears to just be writing the data out sequentially rather than
using the attribute number in the dictionary item.

Any ideas?

Thanks,


--
Donald Verhagen  
Application Development Manager
[EMAIL PROTECTED] 
Tandem Staffing Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

This e-mail message from PNY Technologies, Inc. is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution is prohibited. If you 
are not the intended recipient, please contact the sender by reply e-mail and 
destroy all copies of the original message. 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Anyone Had Any Issues With UV & WinXP SP ?

[Angelo Collazo]

Mary,

I have installed UV 10(free version) and I don't know the login and
password?, Does it use the XP Login info?

Thanks,

Angelo,
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 20, 2004 11:53 PM
Subject: [U2] Anyone Had Any Issues With UV & WinXP SP ?


> Hi All,
>
> I was just wondering if anyone has installed the latest Windows XP Service
Pack on a
> system running Universe, & whether they'd come across any issues with it ?
>
> Thanks in anticipation.
>
>
> MARY MULLANE
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/