<div>
I suggest that the DBA answer your question. <br />
<br />
He/She will at least know what that sp is supposed to do; we do not.
</div>


I suggest that the DBA answer your question.

He/She will at least know what that sp is supposed to do; we do not.

<div>
huyenb, do you still need help with this question?
</div>


huyenb, do you still need help with this question?

<div>
Hi Victor,<br />
<br />
I think I can closed this question<br />
<br />
Thank you all for helping.
</div>


Hi Victor,

I think I can closed this question

Thank you all for helping.

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
I hope that you can help me with this question, I am working on a multi servers (DB2 and SQL). The stored procedure will pull data from server A, then look &nbsp;up value from server B through Left Outer Join.<br />
<br />
The problem is DBA only allowing to use this EXEC dbo.spGetStaffing &nbsp;'01/01/2015', '07/01/2015' only, so no CREATE/INSERT/TRUNCATE, only the SELECT statement. Attach is the DataStage job, It's easy through SSIS or datastage but as Analyst, I need to testing and I am frustrated on how to use the data from Store procedure<br />
<br />
Please help!!<br />
<br />
Thank you so much!
</div>
</div>


Hi experts,

I hope that you can help me with this question, I am working on a multi servers (DB2 and SQL). The stored procedure will pull data from server A, then look  up value from server B through Left Outer Join.

The problem is DBA only allowing to use this EXEC dbo.spGetStaffing  '01/01/2015', '07/01/2015' only, so no CREATE/INSERT/TRUNCATE, only the SELECT statement. Attach is the DataStage job, It's easy through SSIS or datastage but as Analyst, I need to testing and I am frustrated on how to use the data from Store procedure

Please help!!

Thank you so much!

SELECT * FROM [Stored Procedure]

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.