DB2 Load from cursor

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
elrodvt
Participant
Posts: 1
Joined: Thu Sep 01, 2016 9:54 am

DB2 Load from cursor

Post by elrodvt »

Is it possible to implement the "db2 load from cursor" functionality?
I thought that if I created a stage for the select (from a federated table using the db2 connector stage) and then connect a DRS stage using the bulk load from cursor options I would get that result. However it still runs all the data through the engine using a named pipe. Or that is my supposition since it is 5x slower than my sql script run on the target db.

Using db2 clp I can execute a file like the below and get the function I want:
declare t cursor for select xxxx from <nickname of federated table> where yyy;
load from t of cursor replace into yyy nonrecoverable;

I'm fairly new to DS so pardon any loose terminology above.
Post Reply