https://community.blueprism.com/t5/Digital-Exchange/Getting-csv-string-output-from-ODBC-VBO/m-p/98603#M3115 <P>Rather than read in the full result set and then try to split it into pieces, which would still consume memory, another approach would be to extract smaller chunks using a series of queries. For example SELECT...WHERE ID BETWEEN 1 AND 1000, SELECT...WHERE ID BETWEEN 1001 AND 2000, etc.</P> Fri, 06 Oct 2023 08:21:47 GMT John__Carter 2023-10-06T08:21:47Z https://community.blueprism.com/t5/Digital-Exchange/Getting-csv-string-output-from-ODBC-VBO/m-p/98602#M3114 <P>Hello All,</P> <P> </P><P>I have run into a challenge wherein I need to use "Data-ODBC" to fetch data from databricks table. The VBO only allows to get output as collection but since the dataset is large, I am running into system out of memory. It is not possible to build a logic to split data and bring it in so wanted to check if the below code can be altered to get a string output to have csv instead.&nbsp;</P> <P> </P><DIV>OdbcDataAdapter adapter = new OdbcDataAdapter(queryString, conn);</DIV> <DIV>adapter.SelectCommand.CommandTimeout = Convert.ToInt32(timeout);</DIV> <DIV></DIV> <DIV>DataSet dataSet = new DataSet();</DIV> <DIV></DIV> <DIV>try</DIV> <DIV>{</DIV> <DIV><SPAN> adapter.Fill(dataSet);</SPAN></DIV> <DIV><SPAN> status = true;</SPAN></DIV> <DIV><SPAN> errMsg = "";</SPAN></DIV> <DIV><SPAN> results = dataSet.Tables[0];</SPAN></DIV> <DIV>}</DIV> <DIV>catch (Exception ex)</DIV> <DIV>{</DIV> <DIV><SPAN> status = false;</SPAN></DIV> <DIV><SPAN> errMsg = ex.Message;</SPAN></DIV> <DIV><SPAN> results = null;</SPAN></DIV> <DIV>}</DIV> <DIV></DIV> <P>Would appreciate any guidance&nbsp;</P> Thu, 05 Oct 2023 18:56:43 GMT https://community.blueprism.com/t5/Digital-Exchange/Getting-csv-string-output-from-ODBC-VBO/m-p/98602#M3114 NupurSood 2023-10-05T18:56:43Z https://community.blueprism.com/t5/Digital-Exchange/Getting-csv-string-output-from-ODBC-VBO/m-p/98603#M3115 <P>Rather than read in the full result set and then try to split it into pieces, which would still consume memory, another approach would be to extract smaller chunks using a series of queries. For example SELECT...WHERE ID BETWEEN 1 AND 1000, SELECT...WHERE ID BETWEEN 1001 AND 2000, etc.</P> Fri, 06 Oct 2023 08:21:47 GMT https://community.blueprism.com/t5/Digital-Exchange/Getting-csv-string-output-from-ODBC-VBO/m-p/98603#M3115 John__Carter 2023-10-06T08:21:47Z