hi friends,

i have a list of db2 stored procedures stored as files... i want to write a windows shell script to compile all the stored procedures into the DB2 database...
i tried to do as follows:
my script: compile_db2_files.bat
--------------------------------------------------------------------------
db2cmd /c /w /i db2 -tf db2compile.db2 -l db2compile.log -r db2report.log
--------------------------------------------------------------------------
and the db2compile.db2 file contains
--------------------------------------------------------------------------
connect to sample;
-td@ -f all_data_types.sql;
-td@ -f all_data_types11.sql;
--------------------------------------------------------------------------

executed the script as follows:
--------------------------------------------------------------------------
db2cmd -c -w -i compile_db2_files.bat
--------------------------------------------------------------------------

the output in the command prompt is:
--------------------------------------------------------------------------

Database Connection Information

Database server = DB2/NT 8.1.0
SQL authorization ID = JAYAKUMA...
Local database alias = SAMPLE


DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "-" was found following "BEGIN-OF-STATEMENT".
Expected tokens may include: "SELECT". SQLSTATE=42601
--------------------------------------------------------------------------

plz can anyone tell me where i'm going wrong???

Jake

Hi,

"db2 -tf ..." -t means the sql file has ";" character delimiter. Try to remove this from command so: "db2 -f ...".

Hope this helps,
Grofaty

thanks for your reply. i tried what u said.
but if u see the db2compile.db2 file, i terminated every command with ";". so after i removed "t" it says "sample;" database doesn't exist. of course, it is right, since ";" considered as a valid character. then i removed the ";" but this time too it says the same error. good u please tell me how to specify a command to compile a stored procedure file within the db2 command file, ie in db2compile.db2 file in my case...

Appreciate your effort.
Jake

A db2 script (db2compile.db2 in your case) can only contain SQL statements and CLP commands; "-td@ -f all_data_types.sql" is neither.

You'll have to execute the "all_data_types*" scripts separately:
Note that you'll need to include "connect" command in each of them in that case.

thanks for the clarification....

since i have a large number of files, it is difficult for me to add 'conect to sample' statement to every procedure.
so can you tell me anyother alternative
Appreciate your help.
Jake

Create a batch (say, "allproc.bat") file containing and run

hurray! it works...
thanks buddy

Jake

hi,

Thanks........... for the bat file
I also want this