Open command in ODBC stage

vcsasikala · Post by **vcsasikala** » Fri Dec 02, 2011 5:20 am

Hi,
Will the Query in open command of ODBC stage run once in a parallel job with 4 nodes?

or

Will it run once for each node?

ray.wurlod · Post by **ray.wurlod** » Fri Dec 02, 2011 3:39 pm

Is the stage running in sequential mode or in parallel mode?

vcsasikala · Post by **vcsasikala** » Sat Dec 03, 2011 10:15 pm

in parallel mode.

Actually we need to truncate the table before loading. Since we are using lower version of DB2, We are using delete from table tabe_name in open command of ODBC stage which runs in parallel mode. if the delte command tries to delete the same record in each node the table will get locked.

thats where the question raises. Will the open command run once in a job execution or once for each node?

chulett · Post by **chulett** » Sun Dec 04, 2011 12:14 am

Once for each node if the stage is running in parallel mode.

cooperjv · Post by **cooperjv** » Tue Dec 06, 2011 5:48 pm

The default execution mode of the ODBC stage is sequential and this cannot be changed.

So the open command will be executed only once