IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Simulation Tool to test SQL query online


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sgupta9

New User


Joined: 16 Jul 2008
Posts: 12
Location: pune

PostPosted: Thu Aug 26, 2010 1:11 am
Reply with quote

Hi,

Is there any tool or simulator using which i can test my SQL query online.


Thanks,
Shweta
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Aug 26, 2010 1:15 am
Reply with quote

on the mainframe a test subsystem
on the PC one of the many flavors of a database engine available as free downloads

since these forums are IBM oriented I would suggest DB2 EXPRESS
www-01.ibm.com/software/data/db2/express/
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Aug 26, 2010 1:27 am
Reply with quote

Hello,

Quote:
Is there any tool or simulator using which i can test my SQL query online.
Most people use SPUFI.

Possibly there is something i misunderstand. . .
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Thu Aug 26, 2010 10:22 am
Reply with quote

There is a query tool (QTADO) where you can run the sqls if you don't want to log in to mainframe.
There are few other things also, like development center adn command line processor. But, I guess none of these are free.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Thu Aug 26, 2010 6:28 pm
Reply with quote

Shweta,

You may want to try IBM Data Studio. Its Free.

Thanks,
Sushanth
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top