Simple Extended Procedure

Question

Post reply

Simple Extended Procedure

karthik M

One Orange Chip

Points: 29139
More actions
June 5, 2008 at 7:30 am

#71613

Hi All,
I have one new task. I have to write a new extended stored procedure which will fetch the data from Mainframe and need to insert into sqlserver and sybase. It is mandatory.Because we are using both databases in production.
I have searched about ESP on Google, but all those articles are just saying about ESP , but it doesn't give any examples. so can anybody refer some URL to know about it with basic examples ?
If anybody want to give basic examples to connect Mainframe , then it would be appreciated.
is there any difference in writing xp between sybase and sqlserver ? i hope,there should be.
Inputs are highly appreciable !
karthik

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

karthik M One Orange Chip Points: 29139 More actions · Answer 1

karthik M

One Orange Chip

Points: 29139

June 9, 2008 at 12:31 am

#825971

Any Inputs ?

karthik

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 2

I would think that a Linked Server would be able to do that... Search for it in Books Online for the details. They're pretty easy to make.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You don't need an extended procedure for that. You should also not be considering writing extended procs unless you have a very good grasp of C++. It's waaay easy to crash your server with an xp.

Do you have an OLE DB/ODBC driver for the mainframe?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

karthik M One Orange Chip Points: 29139 More actions · Answer 4

It's waaay easy to crash your server with an xp.

I am not getting you.

karthik

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Extended stored procedures are written in C++. They can do anything. If you write one badly (not handle errors, mess up memory access, etc) you can very easily cause the SQL server to crash when the extended proc is run.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dbajunior SSCrazy Points: 2307 More actions · Answer 6

To get data from our AS400, we use either ASNA Product Suite or IBM iSeries Access for Windows. I tend to prefer the latter due to ease of use, but they both do the job quite well.