Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can DECLARE Static Connection variables ?
Message
De
05/05/2003 12:45:26
 
 
À
05/05/2003 12:15:38
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00784929
Message ID:
00785013
Vues:
26
Hi Michael,

Because i want OPTIMIZE roundtrip whitout uses ODBC bindig ?var .
On these mode i can build one offline string command, and send
it to the Server, or send it one step by step in online mode.

Example ( metalanguage ):
OpenConnection(c1)
OpenStantment(s1,c1)
ODBCExec(s1,"DECLARE @contextVar1,@contextVar2 .... ")
ODBCExec(s1,"set @contextVar1=...,set @contextVar2=.... ")
ODBCPREPARE(s1,"SELECT ... from TX where X1=@contextVar1 and x2= @contextVar2 .... ")
OpenStantment(s2,c1)
ODBCPREPARE(s2,"SELECT ... from TY JOIN TZ ON Y1=@contextVar1 and Y2= @contextVar2 .... ")
ODBCExec(s1)
ODBCExec(s2)
.....
OpenStantment(s3,c1)
ODBCExec(s3,"DECLARE @writeVar1,@writeVar2 .... ")
OpenStantment(s4,c1)
ODBCPREPARE(s4,"insert tab1 (f1,f2,f3,f4)values(@contextVar1,@contextVar2,@writeVar1,@writeVar2")
-- cycle
ODBCExec(s3,"set writeVar1=...,set writeVar2=.... ")
ODBCExec(s4) -- exec update
ODBCExec(s3,"set writeVar1=...,set writeVar2=.... ")
ODBCExec(s4) -- exec update
ODBCExec(s3,"set writeVar1=...,set writeVar2=.... ")
ODBCExec(s4)
....

You known any DB Server with these feature ?

Fabio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform