Try using this,

SELECT DISTINCT object.name

FROM OPENQUERY(MOJAVEZA, 'SELECT name FROM Operator.dbo.sysobjects WHERE xtype != ''S''' ) as object

WHERE NOT EXISTS

     (SELECT *

       FROM ListOfSystemObjects

      WHERE object.name COLLATE DATABASE_DEFAULT =  ListOfSystemObjects.ObjectsName)

Normally...

create table ##mytable(name varchar(25))

insert ##mytable

select 'Manisha'''

insert ##mytable

select 'Man''isha'

select * from ##mytable

Thanks,

Ganesh

If you have a db2 instance on your box, it should have a Microsoft OLE DB Provider for DB2.

Else follow this link

http://www-306.ibm.com/software/data/db2/udb/ad/v7/oledb.html

Thanks,

Ganesh

use this function in the place of temp: IDENTITY(int, 1,1)

insert into a temporary table and select the temporary table.

I hope that will solve your problem.

Cheers,

Ganesh

Zap across the data from the temporary file to a temporary table.

From, the temporary table zap across the data to the destination table by creating transformation.

don't create a transformation for...

I would like to share few things

The data file coming out from a db2 database from a mainframe environment

1. There is no concept NULL, it is  treated a s hex...

There are 2 scenarious for this.

DB2 in Mainframes

1. Create a COBOL program to out the data to a text or dat file

2. BCP in the data to SQL Server 2000

DB2...

http://www.sqldts.com/

tq

I would suggest to loop through table, dynamically build the bcp out string and execute it for each rows.

I hope it helps.

Thanks,

Ganesh

You can use this to limit the file extension

And UCase(Right(strFIL,Len(cEXT))) = cEXT Then

 Option Explicit

    '*

     Const cVBS = "renamer.vbs"

     Const cPRE = "OK"

     Const cEXT = "XML"

      Const cFOL = "c:\NACHA\"

    '*

     Dim strFIL

     Dim strGFI

     Dim intMOV

         intMOV = 0

    '*

    ...

Follow this link, it might help you.

http://groups-beta.google.com/group/comp.databases.ms-sqlserver/browse_frm/thread/25c8bb8e11c84167/0d65488b62d42220?q=call+oracle+stored+procedure+from+sqlserver&_done=%2Fgroups%3Fq%3Dcall+oracle+stored+procedure+from+sqlserver%26hl%3Den%26lr%3D%26sa%3DN%26tab%3Dwg%26&_doneTitle=Back+to+Search&&d#0d65488b62d42220

Noeld,

Since you are online now, Iam posting this question to you. Thanks for the info. I really get a good hold on the explaination by Celko. I appreciate it.

Using a...

Thank you.

Could you please explain me, how best the splitting of this procedure would add value in the performance.

My concerns:

Using dynamic sql:

1. Unnecessary maintenance of 5 more stored procedure is...