Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query across server/db into temp table

Status
Not open for further replies.
coders4hire

coders4hire

IS-IT--Management
Dec 31, 2003
22
US
We have a HISTORY table on a backup server. I've never written a stored procedure in Sybase. I would like to open the backup server, and export the HISTORY table to the PRODUCTION server into a temp table where I can then do a join and export.
1. Can that be done?
2. Could you give me some sample code?

Thanks,
Doug

---
doug@coders4hire.com
 
Sort by date Sort by votes
Hello, why you don't do this via a pipeline powerbuilder? it work fine for this.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Copy file from Sybase db to a network share that powerbuilder user does not have access to
Replies
0
Views
232
CharlesSwaim
C
RubensLott
  • Locked
  • Question
Open a PDF file stored on a table
Replies
1
Views
212
RubensLott
RubensLott
MIchaelFeldman1
  • Locked
  • Question
Strange Error. Please help. Powerbuilder with SQL Server
Replies
2
Views
126
MIchaelFeldman1
MIchaelFeldman1
Tanvir Ahmad
  • Locked
  • Question
PB 12.5.2 connectivity to SQL server 2017
Replies
1
Views
87
mbalent
mbalent
Dom71555
  • Locked
  • Question
Need help with a datawindo accessing a dynamic temp table
Replies
4
Views
95
Dom71555
Dom71555

Part and Inventory Search

Sponsor

Back
Top