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?
Open command in ODBC stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Wed Jun 20, 2007 1:13 am
- Location: Chennai
Open command in ODBC stage
Regards,
Sasikala V C
Sasikala V C
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 26
- Joined: Wed Jun 20, 2007 1:13 am
- Location: Chennai
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?
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?
Regards,
Sasikala V C
Sasikala V C