Hi everybody there,

I am trying to convert IBM VAGEN - SMALLTALK programs and DB2 embedded SQL to Visual Studio 2005 and DB2.

The transact - SQL statements embedded into the SERVER side VAGEN ST codes are like:
EXEC SQL DECLARE crs_smt_Siq8_ CURSOR FOR
SELECT CSIRKOD, CYILKOD, CAYKODU, CBASTAR, CBITTAR, CKAPEND, CDEVBRC, CDEVALC, CMADDNO, CDONDZS, CSONYEV, CKISTAR, CDONADI, CTSTAMP
FROM TTAKVIM T1
WHERE CSIRKOD = :*hvTTAKVIM_EZE17_
AND (CYILKOD CONCAT CAYKODU) < :*hvTGECDOND_CTARIH_

ORDER BY 2 DESC ,3 DESC
;
I need to find how VS2005 may do this...

What I am looking for is not a STRORED PROCEDURE...
But an embedded transact-SQL if it exists at all...

Any help is warmly appreciated... Thank you for your vigil attention.


Kind regards.

Ali Riza SARAL
Ali R+ SARAL