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

kumear · New User Joined: 24 Jan 2006 Posts: 7

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

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

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 ..

priyesh.agrawal · Posted: Tue Feb 07, 2006 3:47 pm

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.

ratan_crazy · New User Joined: 31 Jan 2006 Posts: 2

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.

unni_nss · New User Joined: 20 Sep 2005 Posts: 19

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.

tamal_babu · New User Joined: 06 Feb 2006 Posts: 17 Location: Kolkata

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.

kumear · New User Joined: 24 Jan 2006 Posts: 7

Hi firends,

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

by

kumear