SQL Stored Procedure

["Banerjee, Amitava" <Amitava.Banerjee@xxxxxxxxxx>]

Hi All,
I am having some problems while working/creating SQL procedure. 

Sample:

DROP PROCEDURE DB2BETT001;            
CREATE PROCEDURE DB2BETT001 (         
IN @EXTOYT CHAR (32)                  
 )LANGUAGE SQL MODIFIES SQL DATA BEGIN
                                      
DELETE FROM LIBRARY01.FILE1       
WHERE  EXTOYT = @EXTOYT;              
END;                                  


Questions:
1. Can the dot (.) in "delete from library01.file1" be replaced by slash ('/')? 
Like library01/file1? What is the difference? 

2. What we are seeing is if we hardcode the library in CREATE PROCEDURE 
statement (CREATE PROCEDURE PROCLIB.DB@BETT001), it is compiling fine with the 
dot, otherwise we are giving slash. Is there any link between these two things? 
Or are we doing all wrong?

3. If we don't want to hardcode the library in CREATE PROCEDURE statement, 
where does the object goes? I thought (somebody told me) that it goes to the 
top most library in the library list. But that is not happening. The object is 
going to the user's, who ever is signed in, default library. How do we control 
that?

4. We are using the following command to create the objects
RUNSQLSTM SRCFILE(PROCLIB/QSQLSRC) SRCMBR(DB2BETT001) COMMIT(*NONE) 
NAMING(*SQL) DYNUSRPRF(*OWNER) 

Please let me know if I am missing something, doing all wrong.

Thank you
Amitava
 
--------------------------------------------------------

This message (including any attachments) is only for the use of the person(s) 
for whom it is intended. It may contain Mattel confidential, proprietary and/or 
trade secret information. If you are not the intended recipient, you should not 
copy, distribute or use this information for any purpose, and you should delete 
this message and inform the sender immediately.