|
|
| Author |
Message |
rajesh_mbt
Active User
Joined: 27 Mar 2006 Posts: 56 Location: India
|
|
|
|
Hi All,
Is there is any command to check the syntax of SQL query before executing in SPUFI? Thanks inadvance |
|
| Back to top |
|
 |
References
|
Posted: Fri Apr 25, 2008 4:20 pm Post subject: Re: To check syntax of SQL before executing in SPUFI |
 |
|
|
 |
ashimer
Active User
Joined: 13 Feb 2004 Posts: 297 Location: Bangalore
|
|
|
|
Run the query in spufi ..
Spufi itself will give you warnings or errors if there is any problem with the query syntax .. |
|
| Back to top |
|
 |
rajesh_mbt
Active User
Joined: 27 Mar 2006 Posts: 56 Location: India
|
|
|
|
| Thanks Ashmir for your reply,I would like to know whether any command to check syntax for SQL other than running in SPUFI like for example we can check syntax of jcl before submitting the job. |
|
| Back to top |
|
 |
stodolas
Senior Member
Joined: 13 Jun 2007 Posts: 647 Location: Wisconsin
|
|
|
|
| I've only seen this in external tools. |
|
| Back to top |
|
 |
|
|