Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Why to use more than three semi-colons with END in SPUFI

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

New User


Joined: 24 Jan 2006
Posts: 7

PostPosted: Sun Feb 05, 2006 8:09 pm    Post subject: Why to use more than three semi-colons with END in SPUFI
Reply with quote

Hi All,

when we to exec SPUFI that time we type END ;;; ,my doubt is why to use more than three semi-colons,if i use one ; that shows error....


Thanks?ards

Kumear
Back to top
View user's profile Send private message

parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Tue Feb 07, 2006 2:41 pm    Post subject:
Reply with quote

Well kumear,

I never got an error while using only one semicolon to seperate two SQL statements.

I would like to see what error you get ..
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Tue Feb 07, 2006 3:47 pm    Post subject: Re: Why to use more than three semi-colons with END in SPUFI
Reply with quote

kumear,

I also use a single ";" to terminate SPUFI query, Not seen 3 semi colons.

Please paste error message along with SQL query for a better understanding.

Regards,

Priyesh.
Back to top
View user's profile Send private message
ratan_crazy

New User


Joined: 31 Jan 2006
Posts: 2

PostPosted: Tue Feb 07, 2006 4:34 pm    Post subject:
Reply with quote

Hi Kumear,

I understood your question u mean to ask that why we use
end ;;; for executing a sql queries in spufi ?


Here when we specify 'end' command it will go to
previous screen and
whereas ';' refers to one ENTER key i.e., it is equal to
pressing an enter key. So, when u specify 'end ;;;'
it will go to the previous screen and then presses three enter
keys which will open the output screen of the spool and
vice-versa...

Let me know in case i'm wrong.

Thanks in Advance,
Ratna kumar A.
Back to top
View user's profile Send private message
unni_nss

New User


Joined: 20 Sep 2005
Posts: 19

PostPosted: Tue Feb 07, 2006 4:40 pm    Post subject: Re: Why to use more than three semi-colons with END in SPUFI
Reply with quote

Normally we use more than one semocolons at the commond line to directly execute the sql statement and will show the result.but tis u should write in command line.


but when u r writing the query,suppose if u want subsequent insertion,then query can be splitted with one semicolon and will execute all the statements.
Back to top
View user's profile Send private message
tamal_babu

New User


Joined: 06 Feb 2006
Posts: 17
Location: Kolkata

PostPosted: Sun Feb 19, 2006 9:39 am    Post subject: Re: Why to use more than three semi-colons with END in SPUFI
Reply with quote

Hi Kumear,
I agree with Ratan here. We give 3 semi-colons to execute an Sql stmnt in SPUFI to bypass 3 screens on the way to the output screen which u will encounter when u normally press Enter. ; is actually repsenting ENTER here.
Back to top
View user's profile Send private message
kumear

New User


Joined: 24 Jan 2006
Posts: 7

PostPosted: Sun Feb 19, 2006 6:31 pm    Post subject:
Reply with quote

Hi firends,

I got it now ... Thanks to all for sharing your valuable information,


by

kumear
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
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm
No new posts Not able to access the DB2 via SPUFI sakthikumarT DB2 6 Sat Nov 28, 2015 1:52 am
No new posts DB2 program returned data is dif than... pradeepkit DB2 1 Tue Mar 03, 2015 5:39 am
No new posts How to skip foriegn Key constraint in... Arunkumar.chinnappa DB2 5 Fri Feb 07, 2014 2:17 pm
No new posts SPUFI => CSV Mike 1304 DB2 27 Tue Jan 21, 2014 10:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us