How to use SQL command not supported by Netcobol

[clages]

Hi , I am new in this Forum
But very Old in Cobol (several of them)
Now a day iam using Netcobol x Crystal Reports x Ms-sql x Grid(janusGrid, ExpressquantunGrid and Others)

I saw someone question how to create a table inside
netcobol.
as frederico said a few sql command is not suported
then i use to call a SP to do This

example

To Create a Table
1 - In Enterprise manager i create the Table
2 - Then i Gerenate the SQL Script to Create a table
3 - In net cobol
Exec SQL call Createtable() End-Exec

Att

Carlos Lages
Rio de Janeiro

 

[fredericofonseca]

Hi Carlos,


As I said previously NetCobol is very restrictive on its SQL Usage.


You better off sticking with ADO as per the following faq209-5475.


However if you wish to use ESQL, then you can still do some of the stuff if using SP's. If do do this but are still getting errors, then please post the error here.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[clages]

Hi


I dont like to use ADO to manage tables for some reasons

1 - We Write too much, even a table has 2 columns
2 - Using ADO i have already problems using Commas.
Field like 9999,99
3 - Using Stored Procedure, i can change the the Table Layout without Compiling
4 - Using Entreprise Manage , I create the Table then
I generate the SQLScript to be used any time.

tks

Carlos Lages
Dec
Rio de janeiro-rj