Connent to mainframes and access a file, for instance a CSV file

Question

I have two things to do here.

1) Connect to the mainframes (via TN3270 with a file transfer type of FTP)
2) Read a dataset xxxx.yyyy.D (all the contents of the data set)

Note: The data set may be of CSV(comma separated value) format.

Answer 1

Hi Monika,


Pragma automatic_index command is by deafult true in Sqlite.

so when you  used Pragma automatic_index=true, its mean indexing will be continue


to stop default indexing use 

sqlite> Pragma automatic_index=false.