Q

Creating extract files using BCPs

Sybase expert Mich Talebzadeh recommends creating a view from underlying tables and using the bcp command to create extract files.

I have to create a couple of extract files. What is the preferred method? Should I create views that join the tables and then bcp from the views or create a stored procedure to handle the all of this?

CREATE a VIEW on the underlying tables and then BCP out the VIEW

This was first published in March 2006

Dig deeper on Introduction to Linux system administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close