var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how do one execute a command line program
I would like to know how to execute a command line program i.e. a batch file in dos and passing parameters to it.
I am familiar with MS SQL's way - herewith a simple stored procedure in MS SQL which I would like to be converted in DB2 syntax;
CREATE procedure ebc
declare @cmdstr varchar(50)
declare @tmpid integer
select @tmpid = (select id + 1 from ebc_counter)
set id = @tmpid
select @cmdstr = ''
select @cmdstr = 'c:\test.bat' + ' ' + @cycle + ' ' + convert(varchar(10),@tmpid)
exec xp_cmdshell @cmdstr
Hope someone can help me!
DB2 procedures do not allow anything else but only SQL commands.
You try that in a function, i mean UDF's.