Unanswered: VAGEN - Smalltalk DB2 migration to Visual Studio 2005 DB2
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.