2 magic Stored Procedures that simultate dbimport

HI Folks, some time ago, a certain John F.M.III (anonymous name ;-) ) published a couple of stored procedures that simulate dbimport and dbexport, using dynamic SQL and external tables. I think this was in developerworks, not sure. Those SPs are very handy and simple to use. Did anyone save these SPs? In that case can you share or point to the right URL ? Thanks in advance Eric

Hi Eric, Just look at this link: http://planetids.com/content/how-create-stored-procedure-which-emulates-very-fas t-dbexport-dirty-read-mode How to create a stored procedure which emulates a very fast dbexport in dirty read mode. | planetIDS.com<http://planetids.com/content/how-create-stored-procedure-which-emu lates-very-fast-dbexport-dirty-read-mode> planetids.com This is a simple stored procedure which will export the current database to the specified directory without locking the database. While this is a very simple procedure it can be extend very easily to accommodate parallel unloads based on the size of a table, scan tables in parallel and many other ways to customize this produce for your own needs. I hope this will help. Kind regards, Patrick ________________________________ De : ids-bounces@iiug.org <ids-bounces@iiug.org> de la part de ERIC VERCELLETTO <eric.vercelletto@begooden-it.com> Envoyé : lundi 5 février 2018 17:27 À : ids@iiug.org Objet : 2 magic Stored Procedures that simultate dbimport [40660] HI Folks, some time ago, a certain John F.M.III (anonymous name ;-) ) published a couple of stored procedures that simulate dbimport and dbexport, using dynamic SQL and external tables. I think this was in developerworks, not sure. Those SPs are very handy and simple to use. Did anyone save these SPs? In that case can you share or point to the right URL ? Thanks in advance Eric ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi Patrick, that is the one! thank you!