Regarding User defind query in parallel Jobs

mohandl · Post by **mohandl** » Sun Jul 27, 2008 11:21 pm

Hi all,

i have one user defind query like below

delete * from <<table_name>>;

Insert into <<table_name>>
(

--
--
---
)
select * from <<Table_name1>>

The above user defined query i have to place in single stage in Parallel Job like (serevr jobs ODBC stage)

I am trying to place in DRS or Entrprise ODBC ,But i am not able place at a time, Is there any way to palce whole SQL query.

Regards,
Mohan

keshav0307 · Post by **keshav0307** » Sun Jul 27, 2008 11:35 pm

what is the database.
oracle, you can try for Stored procedure stage.

mohandl · Post by **mohandl** » Sun Jul 27, 2008 11:53 pm

Hi Keshav ,

My database is SQL Server.

keshav0307 · Post by **keshav0307** » Mon Jul 28, 2008 2:38 am

so this query will run only once?

OddJob · Post by **OddJob** » Mon Jul 28, 2008 4:48 am

In the past I have issued this kind of call in the 'Open' command string or in the 'Before' sql section.

For the actual data extract part I've included a 'SELECT COUNT(*)' for the table being populated to allow further checks and reporting on the actual number of records inserted.