Re: How to set variables in DTS
Ummm... I don't understand well.
Informix -> SQL-Server (Oracle?)
If you need to insert data in a Sql-Server table from an Informix one, then you can use the linked server feature of Sql-Server.
J.
-----Original Message-----
From: jeroen@wallenburg.demon.nl
To: informix-list@iiug.org
Date: 1 Aug 2005 06:36:06 -0700
Subject: How to set variables in DTS
I have an informix database from which i need to fill a table in SQL
every half hour. Within SQL I have the following code where hsplit the
local SQL table is:
declare @mytime as datetime
declare @hourtime as varchar(2)
declare @minutetime as varchar(2)
declare @variable as int
set @mytime = dateadd(mi, -30, getdate())
set @hourtime = datepart (hh,@mytime)
set @minutetime = datepart(mi, @mytime)
set @variable = @hourtime + case
when (@minutetime / 30 < 1)
then '00'
else '30'
end
select * from hsplit
where starttime =@variable
When i use the ODBC connection via Openlink to the Oracle dbase i get
syntax errors.....can anyone help me to resolve this?
Jean Sagi
jeansagi@myrealbox.com
jeansagi@gmail.com
sending to informix-list