SQL Server 6.5 updates from UV 9.4 on AIX 
Author Message
 SQL Server 6.5 updates from UV 9.4 on AIX

I'm looking for a neat solution to this small problem:
A> I have a transaction database in Universe on AIX that creates entries in
a temp table in an on-going basis.
B> I have another windows based transaction application using SQL Server
6.5.
C> I want to have a timer event in the windows application (VB) check the UV
Temp Table for any records, and if there are any, extract them to a table in
SQL 6.5 and then delete the Temp records in the UV temp table.

Ideally I would use uvODBC and a SQL Server stored procedure, but that is
not available until SQL 7.0 (Which for other reasons, I can't upgrade to
yet).
I thought it would be great if there were a way to either:
1. Directly run a UV VOC entry from a simple script file in the windows
environment OR
2. Have the script file call a unix shell script that can log into UV and
execute the VOC entry.

The result of the VOC entry is to create an ASCII text file that I will FTP
over.

Thanks in advance,
Chuck Appelquist



Sun, 24 Mar 2002 03:00:00 GMT
 SQL Server 6.5 updates from UV 9.4 on AIX



Quote:
> I'm looking for a neat solution to this small problem:
> A> I have a transaction database in Universe on AIX that creates entries in
> a temp table in an on-going basis.
> B> I have another windows based transaction application using SQL Server
> 6.5.
> C> I want to have a timer event in the windows application (VB) check the UV
> Temp Table for any records, and if there are any, extract them to a table in
> SQL 6.5 and then delete the Temp records in the UV temp table.

> Ideally I would use uvODBC and a SQL Server stored procedure, but that is
> not available until SQL 7.0 (Which for other reasons, I can't upgrade to
> yet).
> I thought it would be great if there were a way to either:
> 1. Directly run a UV VOC entry from a simple script file in the windows
> environment OR
> 2. Have the script file call a unix shell script that can log into UV and
> execute the VOC entry.

> The result of the VOC entry is to create an ASCII text file that I will FTP
> over.

> Thanks in advance,
> Chuck Appelquist

Hmmm.
I use Unidata.
I kick of many processes from Cron by setting a UNIX environment variable
I call $UDTPROCESS.
The cron will run a script that sets up the Unidata environment ($UDTPATH
etc) and assigns my $UDTPROCESS to PROC name.
The script changes directory to a unidata directory (one with a VOC) and
runs unidata with the udt unix command.
The LOGIN paragraph runs a UNIBASIC program that PCPERFORMs an echo of
$UDTPROCESS and captures the result.
If $UDTPROCESS has been set I chain of to that program/proc whatever.

This works just great, we even use this mechanisn to output HTML to our
web site when called from a CGI script. (www.fliway.com)

regards,
Jeremy Thomson

Y2K, what Y2K bug, It aint my problem buddy ;-)



Mon, 01 Apr 2002 03:00:00 GMT
 SQL Server 6.5 updates from UV 9.4 on AIX
To run any Universe process from shell:
cd /to/the/req/directory
/usr/opt/uv/bin/uv COMMAND
where
- COMMAND can be a Program, PROC, Paragraph, etc.
- if you have a LOGIN VOC entry, you need to bypass any interactive

PHANTOM

steve haddon


Quote:


> > I'm looking for a neat solution to this small problem:
> > A> I have a transaction database in Universe on AIX that creates entries
in
> > a temp table in an on-going basis.
> > B> I have another windows based transaction application using SQL Server
> > 6.5.
> > C> I want to have a timer event in the windows application (VB) check
the UV
> > Temp Table for any records, and if there are any, extract them to a
table in
> > SQL 6.5 and then delete the Temp records in the UV temp table.

> > Ideally I would use uvODBC and a SQL Server stored procedure, but that
is
> > not available until SQL 7.0 (Which for other reasons, I can't upgrade to
> > yet).
> > I thought it would be great if there were a way to either:
> > 1. Directly run a UV VOC entry from a simple script file in the windows
> > environment OR
> > 2. Have the script file call a unix shell script that can log into UV
and
> > execute the VOC entry.

> > The result of the VOC entry is to create an ASCII text file that I will
FTP
> > over.

> > Thanks in advance,
> > Chuck Appelquist

> Hmmm.
> I use Unidata.
> I kick of many processes from Cron by setting a UNIX environment variable
> I call $UDTPROCESS.
> The cron will run a script that sets up the Unidata environment ($UDTPATH
> etc) and assigns my $UDTPROCESS to PROC name.
> The script changes directory to a unidata directory (one with a VOC) and
> runs unidata with the udt unix command.
> The LOGIN paragraph runs a UNIBASIC program that PCPERFORMs an echo of
> $UDTPROCESS and captures the result.
> If $UDTPROCESS has been set I chain of to that program/proc whatever.

> This works just great, we even use this mechanisn to output HTML to our
> web site when called from a CGI script. (www.fliway.com)

> regards,
> Jeremy Thomson

> Y2K, what Y2K bug, It aint my problem buddy ;-)



Mon, 01 Apr 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Installing Informix 9.4 IDS on AIX Bombed out with this error

2. Permission Error installing Informix 9.4 IDS on AIX 4.3.3

3. UniVerse 9.4 on AIX 4.3.2

4. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

5. Informix Server 9.4 Installation Problem

6. Problem W/ UniVerse Obejcts and Windows 2000 Server (UniVerse 9.4 for NT)

7. SQL Server 6.5 poor insert/update performance when access by terminal servers

8. Updating from SQL 6.5 trial to SQL 6.5 full

9. Problem in executing same SQL Update stmt many times in SQL Server 6.5

10. transfer database from one SQL Server 6.5 to another SQL Server 6.5

11. Transfer database from one SQL Server 6.5 to another SQL Server 6.5

12. Cascading Updates in SQL Server 6.5 and 7.0


 
Powered by phpBB® Forum Software