Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Third Party Products

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th February 2002, 08:37
halvorn's Avatar
halvorn halvorn is offline
Member
 
Join Date: Jan 2002
Location: Norway
Posts: 47
halvorn is on a distinguished road
Lightbulb A powerful SQL worksheet with edit capability

Which I use every day

In addition to being a powerful SQL worksheet with edit capability, DIM is a tool for converting or sharing data between different databases or within the same database. Applications for DIM may be:

1. View information from the database using SQL statements, like a SQL worksheet presenting the data in a grid.
2. Use action Queries as UPDATE, INSERT, DELETE, DROP, CREATE etc.
3. Save the SQL statements for later use.
4. Edit or add directly in the database through the worksheet grid that is showing data based on a SQL statement.
5. Copy data from the worksheet grid to a spreadsheet program like Excel.
6. Copy/Insert data from one table/query/view to another, internally or between different database.
7. Edit/Update data in one table/query/view based on data from another, internally or between different database.
8. Use a scheduler that executes integration jobs, like 6 and 7 above, at defined times.
9. Compare differences between tables/queries/views.
10. Create Views on an Oracle Db. Test the SQL syntax by Execute SQL, give the View a name and decide if it shall be Read Only.
11. Rebuild Oracle Indexes Easily.
12. Paste into Oracle or Other DB's from Excel, by using the Grid below.

More info:
http://easydoc.tripod.com/dim.htm
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Strange requirement Renegade Tools Development 8 7th April 2004 16:06
(Embedded SQL) and (Dynamic SQL) nopadon Tools Development 2 6th December 2003 06:55
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 13:22


All times are GMT +2. The time now is 14:03.


©2001-2017 - Baanboard.com - Baanforums.com