How to connect with MSSQL.

I am trying to connect to MSSQL (2019) with Visual Studio 2019, with the full trial of Visual Cobol. not the PE. As i was told it has limitations, maybe SQL connection being one of them, i dont know..

Anyways would like to connect to an MSSQL database, run a query, that will fetch report data. Then try and i guess read it into tables, and chunks at a time, not sure if VC helps with that, at EOF, if that exists in SQL want to display the data.

1. How do you do the connection.

2. Reading into tables. in chunks, how do i preallocate the tables for the chunks of data.

I know there are videos, but so far those videos are dated. Have not found one step by step video, to show the steps.

not showing off, but if its any help, im a both an expert in COBOL and also in MSSQL so i just need to in between part with MF VC. So i know cobol tables inside out, even on a very high level, and i know tssql, with all aspects of the select statements. Joins, SQL REPORTING SERVICES etc.

thanks.

I am trying to connect to MSSQL (2019) with Visual Studio 2019, with the full trial of Visual Cobol. not the PE. As i was told it has limitations, maybe SQL connection being one of them, i dont know..

Anyways would like to connect to an MSSQL database, run a query, that will fetch report data. Then try and i guess read it into tables, and chunks at a time, not sure if VC helps with that, at EOF, if that exists in SQL want to display the data.

1. How do you do the connection.

2. Reading into tables. in chunks, how do i preallocate the tables for the chunks of data.

I know there are videos, but so far those videos are dated. Have not found one step by step video, to show the steps.

not showing off, but if its any help, im a both an expert in COBOL and also in MSSQL so i just need to in between part with MF VC. So i know cobol tables inside out, even on a very high level, and i know tssql, with all aspects of the select statements. Joins, SQL REPORTING SERVICES etc.

thanks.

I am trying to connect to MSSQL (2019) with Visual Studio 2019, with the full trial of Visual Cobol. not the PE. As i was told it has limitations, maybe SQL connection being one of them, i dont know..

Anyways would like to connect to an MSSQL database, run a query, that will fetch report data. Then try and i guess read it into tables, and chunks at a time, not sure if VC helps with that, at EOF, if that exists in SQL want to display the data.

1. How do you do the connection.

2. Reading into tables. in chunks, how do i preallocate the tables for the chunks of data.

I know there are videos, but so far those videos are dated. Have not found one step by step video, to show the steps.

not showing off, but if its any help, im a both an expert in COBOL and also in MSSQL so i just need to in between part with MF VC. So i know cobol tables inside out, even on a very high level, and i know tssql, with all aspects of the select statements. Joins, SQL REPORTING SERVICES etc.

thanks.

i know to connect to sql should be super simple. however, nothing about the instructions out there are simple, everything is just made so theoretical, that you need to guess what they mean.  Just a simple example would do, i would be able to figure out the rest. thanks.

i know to connect to sql should be super simple. however, nothing about the instructions out there are simple, everything is just made so theoretical, that you need to guess what they mean.  Just a simple example would do, i would be able to figure out the rest. thanks.

I am trying to connect to MSSQL (2019) with Visual Studio 2019, with the full trial of Visual Cobol. not the PE. As i was told it has limitations, maybe SQL connection being one of them, i dont know..

Anyways would like to connect to an MSSQL database, run a query, that will fetch report data. Then try and i guess read it into tables, and chunks at a time, not sure if VC helps with that, at EOF, if that exists in SQL want to display the data.

1. How do you do the connection.

2. Reading into tables. in chunks, how do i preallocate the tables for the chunks of data.

I know there are videos, but so far those videos are dated. Have not found one step by step video, to show the steps.

not showing off, but if its any help, im a both an expert in COBOL and also in MSSQL so i just need to in between part with MF VC. So i know cobol tables inside out, even on a very high level, and i know tssql, with all aspects of the select statements. Joins, SQL REPORTING SERVICES etc.

thanks.

like is said, connecting to sql should be very easy, as i have connected to sql from many other programs, it being a piece of cake. but in MF the answers you get here, is, yes go read like 300  pages from 17 different manuals, and good luck.

Well since no response yet on how to connect to SQL, Microsoft SQL. What i am doing is creating the query in MS SQL, whatever it is, and then saving it as a CSV., sometimes the results are 50 record sometimes 1000s of records. Then i read in the csv file into a cobol program, simply insert it into a table, and process it from there. I simply unstring by commas.

The advantage i have when i use a raw csv file, is that i can create the tables dynamically, so i never need to know the  tables dimensions before hand.

I am not sure if i access sql directly, if i can still create the tables dynamically based on the query set.

But eventually i want to run the queries from cobol, and insert the data directly into the fields. I know it can be done and is quite easy, but what rules Micro Focus has about this, is written in manuals, but not easy to understand. Like i said a very simple example would do. If any experts are available, would be appreciated.

Well since no response yet on how to connect to SQL, Microsoft SQL. What i am doing is creating the query in MS SQL, whatever it is, and then saving it as a CSV., sometimes the results are 50 record sometimes 1000s of records. Then i read in the csv file into a cobol program, simply insert it into a table, and process it from there. I simply unstring by commas.

The advantage i have when i use a raw csv file, is that i can create the tables dynamically, so i never need to know the  tables dimensions before hand.

I am not sure if i access sql directly, if i can still create the tables dynamically based on the query set.

But eventually i want to run the queries from cobol, and insert the data directly into the fields. I know it can be done and is quite easy, but what rules Micro Focus has about this, is written in manuals, but not easy to understand. Like i said a very simple example would do. If any experts are available, would be appreciated.

I am not sure if you actually read any of the responses that we post here. Please let me know if you see this one because we have responded to every question you have had and you keep saying that nobody has responded yet.

I gave you a response on this thread that showed you how to connect, pointed you at a sample program (actually many samples for SQL in the browser) and provided a video link. Short of actually coding it for you I am unsure of what else you are looking for?

I am trying to connect to MSSQL (2019) with Visual Studio 2019, with the full trial of Visual Cobol. not the PE. As i was told it has limitations, maybe SQL connection being one of them, i dont know..

Anyways would like to connect to an MSSQL database, run a query, that will fetch report data. Then try and i guess read it into tables, and chunks at a time, not sure if VC helps with that, at EOF, if that exists in SQL want to display the data.

1. How do you do the connection.

2. Reading into tables. in chunks, how do i preallocate the tables for the chunks of data.

I know there are videos, but so far those videos are dated. Have not found one step by step video, to show the steps.

not showing off, but if its any help, im a both an expert in COBOL and also in MSSQL so i just need to in between part with MF VC. So i know cobol tables inside out, even on a very high level, and i know tssql, with all aspects of the select statements. Joins, SQL REPORTING SERVICES etc.

thanks.

There is tons and tons of information. But its all theoretical.

Normally when i study something, the instructor will have a sample database, that i can copy, insert into my database. then will show the code they use to connect and some sample queries. I mean this is not complicated, this could be shown in a 3 minute video. But instead you are being directed to read manuals of stuff, that has nothing to do with the simplicity of the objective. After all connecting from phython or c, is so easy, why not make it easy for Cobol. I understand i probably will never get a simple answer to this problem, im kind of used to it on this board, which is a shame. Since this board should promote MF, not make it complex. Unfortunately, will need to wait until i meet a Programmer that connect to sql, and see their code, before i know how to do it. Reading those manuals, to me is a waste of time, and is good, once you have done it once, so you can see what other options exist. So if someone here, could give me the simple directions, of how to do a simple query with the code, I think i will help many who are trying to do the same. By the way, if you are using any of the MF licenses, never change your sys date, i did, and now cant use MF for 5 days straight, though they are trying to help me out. I will say this MF is a step above say some other solutions i have seen so far. But at this point since i cant use MF im using some other solution, with less features than MF, but it still gets the job done, and should i change the date, it wont blow up, and it lets me open multiple instances with no hitch. With MF i once opened a 2nd instance same pc,  and poof, license was no longer valid. So far i need to step lightly and not go fancy, when using MF, not to get it upset, and lock me up.