<< Click to Display Table of Contents >> Navigation:  SshNetIbmi Class > SshNetIbmi Methods > ExecuteSqlQueryToCsvFileXmlSvc Method

Summary

This function queries the IBM i DB2 database with selected SQL statement and returns results to Csv file in one step.

 

Parameters

 

sSQL - SQL Select. INSERT, UPDATE and DELETE not allowed.

 

sCsvOutputFile - Output CSV result file

 

replace - Replace output file True=Replace file,False=Do not replace

 

sFieldSepchar - Field delimiter/separator. Default = Comma

 

sFieldDataDelimChar - Field data delimiter character. Default = double quotes.

 

Returns

True=CSV file written successfully, False=Failure writing CSV output file.