Meaning of FETCH_CURSOR jconnect_implicit_1 in Sybase
Even if fetch size is set to 1, it doesn't mean a cursor will be created for each row; it simply means the driver will request rows of an open cursor be sent to the client one by one instead of in batches. Still inefficient, but not that inefficient. However, there's no indication there that fetch size is set to 1; jconnect_implicit_1: seems to be simply an automatically generated name of a  bind variable. I believe Sqoop fetch size can be controlled with the --fetch-size command line argument.