Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Can I execute the SQL queries online or any tool to do it

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sreelu.s

New User


Joined: 23 Jul 2010
Posts: 10
Location: hyderabad

PostPosted: Thu Jul 12, 2012 12:05 am    Post subject: Can I execute the SQL queries online or any tool to do it
Reply with quote

Please let me know if I can practice the sql queries online / any tool ....

just wanna execute and see the result for my learning .....

Thanks in Advance.
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1544
Location: Andromeda Galaxy

PostPosted: Thu Jul 12, 2012 12:14 am    Post subject:
Reply with quote

Google Access mainframe for free it should help you to try some basic mainframe related stuff writing Cobol db2 programs and simple queries through spufis and rexx etc.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Thu Jul 12, 2012 12:21 am    Post subject:
Reply with quote

you can also download a free copy of db2's C-Express db2 vsn 9.7 and you can practice on your pc.
google for db2 c-express.
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Thu Jul 12, 2012 12:35 am    Post subject:
Reply with quote

For online SQL practice, use SQL Zoo.
IMHO, this is a fantasic website for learning basics and has definitely helped me to learn SQL.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1932
Location: UK

PostPosted: Thu Jul 12, 2012 2:02 am    Post subject:
Reply with quote

SPUFI?
Back to top
View user's profile Send private message
Peter Nancollis

New User


Joined: 15 Mar 2011
Posts: 47
Location: UK

PostPosted: Thu Jul 12, 2012 4:11 am    Post subject:
Reply with quote

also DSNTEP2/4 DSNTIAUL and DSNTIAD

[update ] sorry missed the on-line ... these of course are batch - unless you wrap up in with rexx/clist
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jul 12, 2012 3:14 pm    Post subject:
Reply with quote

SQLITE? SQL Server? MS Access?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 47 Fri Sep 29, 2017 1:08 pm
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us