1. Set up a user account in iSERIES (AS400) with the same username and password as the user currently logged in the Windows server.

2. In the iSERIES (Operations) navigator set...

This has nothing to do with scripttimeout. But the time SQL Server thinks the query is estimated to run.

Change the setting on database level.

Properties -> Connections

But 200.000 rows ?

Hi fellas

I represent the byer side not the seller side !

I stand for my opinion that you have all that you need already.

The difficult...

Hi Lori

Analysis Services holds its own data. So when the data is transformed it is independent of MS SQL Server. You  can put any data in Analysis Services from any...

Hi Jamie

The idé is if Lori has a MS SQL Server system then he can use the FREE Olap solution provided with it.

The data should come from the centralised...

If you have a SQL Server in your org. then you already have a OLAP solution for FREE. With EXCEL installed you have everything you will need.

Hi

What does 'connect by prior' do ? What is the results you are expecting ?

Hi Lori

All of these tools are Query tools. How to show the data.

The hard part is to transform the data. Usually you hire a consultant for this.

You should not try...

How does your current code look like ?

Why not use the XML bellow ?

<object name="<name of table here">

  <property <name of column here>="<value of column here>"/>

  <property <name of column...

Journaled is the same as logging in MS SQL Server. It is the mecanism that gives you the ability to do TRASACTIONS and to sync with other databases.

Try putting a clusterad key on the table. And sort it by for example invoice date (first column) if it is a invoice table. Then we can talk more.

Trust me....

If you have permission to delete and insert ? Why not ?

Remember that you can set the ODBC source to read-only if you want.

Another tip is that you should set...

It is simple to fix this.

1. Open the ODBC source.

2. Go to the tab 'Performance'.

3. Click the button 'Advanced'

4. Uncheck the option for 'row blocking'. Se picture below.

Sorry it´s in...

What do you guys mean with check constraints ? Hur du you have to set up the tables ?