Hi,
I am trying to simulate a Sybase stored procedure function using a DataStage routine.
I don't want to be using BCI as it is slow (I've tested this), and furthermore, I don't want to call a stored procedure
as we are hoping to have DataStage replace stored procedures.
What I want is...
Try this:
1. Create a new table that is based from an excel spreadsheet.
CREATE excel_table (
account char(4) null,
amount int null
)
Then insert data from Excel spreadsheet using INSERT INTO command:
INSERT INTO excel_table
Values (1000, 25)...
Select system from main
where main.site_number=sites.site_number
and sites.site_name=?
Two things are missing from the script.
1. You need to include the second table in the script as well i.e. site table.
2. The second where clause statment for this sql is incomplete. Therefore it does...
Hi,
Could anybody please advise where can I get the OLE DB Provider for Sybase? I am attempting to use Microsoft Visual Interdev on top of our warehouse which is running on Sybase 11.9. Thanks very in advance.
-bRyce :-)
Hi,
Could anybody please advise where can I get the OLE DB Provider for Sybase? I am attempting to use Visual Interdev on top of our warehouse which is running on Sybase 11.9. Thanks very in advance.
-bRyce :-)
You might not have an appropriate permission to establish ODBC connetion. It might be a good idea to consult your local network admin to provide you a permission to accomplish this.
-bRyce
Yes, both servers are in the same NT domain.
Yes, the application is using an ODBC dBase IV driver to connect to the database. Should I try to get Visual FoxPro driver installed on both servers in order to create a connection?
Hi
Thanks for the reply.
As far as I am concerned, the report format can be customised according to your requirements. However, I am wondering if the display setting of Webi/Infoview module can be modified.
The senario is that we prefer not to have Business Objects related messages...
Both servers (PROD and SAMPLE) are running on NT Server. I am attempting to connect to an application which is located on SAMPLE using one of our report writer applications. This application has DBASE as the database backend.
NOTE:
PROD = Production Server/Main Server
SAMPLE = Other Server
Hi All,
Thank you very much for your assistance in advance.
I have encountered with an issue which I am unable to figure out the solution. The senario is that I am uanble to create the ODBC connection from one of our Production Servers (I call this here as PROD) to a database which is located...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.