Migrating DB2 Embedded SQL for C/C++ (ESQL/C) to SQL Server 2012 - Pre-Compiler Needed.

Question

Hi

  Is there any pre-compliler available for converting .SQC to .C files. We are actually migrating from DB2 (Existing) to Microsoft SQL Server.

Source Environment: DB2 Database and AIX Operating System

Target Environment : SQL Server and Linux(Red Hat Linux 6.4)

Source environment,the batch program are written in ESQL/C connect with DB2 Library .A DB2 "PREP" pre-compiler that converts Embedded SQL statements(.sqc) into function calls(.c) that can be accepted by a C compiler. Then the C compiler compiles the resulting source code into an executable program.

Target Environment,We can't find any pre-compiler that converts Embedded SQL statements(.sqc) into function calls(.c) that can be accepted by a C compiler.

Kindly help.

Thanks in advance.

Regards,

Saravanan K

Answer 1

Might try them over here.

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=csharpgeneral%2Cvcgeneral%2Csqltools%2Csqlsetupandupgrade&filter=alltypes&sort=lastpostdesc

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

Answer 2

Hi Team,

  In DB2 database, ("PREP") pre-compiler is used to convert ESQL/C (.sqc) to (.c) program.

  When i tried to find equal Pre-compiler for SQL Server 2012,i am unable to find the pre-compiler.

  Could you let me know whether any Pre-compiler available for SQL Server 2012.

   If available kindly assist how to handle it/If not available what is the aliter source.

  Thanks in advance.

  Regards,

  Saravanan K

  

 

Answer 3

Hi Dave,

Any solutions for my post. Please let me know.

Regards,

Saravanan K

Answer 4

This is "where is" forum for direction on where best to ask questions so I'd try re-asking in the forums I linked.

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.