DD config xml attributes documentation

Is it just me, or does anyone else think that the docs arent very good?

i cant seem to find any good documentation on how to execute an sql query before the deployment starts. it seems like i should be using the element but i cant find any single place in the docs which describes the valid attributes and their values and what they mean.

Find more posts tagged with

Comments

moonkhanna

what do you want to do. Please elaborate.

Ambuj

Is it just me, or does anyone else think that the docs arent very good?

i cant seem to find any good documentation on how to execute an sql query before the deployment starts. it seems like i should be using the element but i cant find any single place in the docs which describes the valid attributes and their values and what they mean.

What are you trying to do?
Can you please explain your requirement?

There should be some ways to solve your problem. Smiley Happy

koryakm

I found a way to call a stored procedure using the

element, which is great, but what i really would rather have is the ability to write sql statements in the element.

for instance, i have a stored procedure that does a
delete * from table;
commit;

there is really no reason for this to be a stored procedure since it takes no arguments, and is really simple

so. is there a way to put small amounts of sql into the sql tag, and have this be executed without needing to use special flags to the iwcmd ?

Ambuj

I found a way to call a stored procedure using the

element, which is great, but what i really would rather have is the ability to write sql statements in the element.

for instance, i have a stored procedure that does a
delete * from table;
commit;

there is really no reason for this to be a stored procedure since it takes no arguments, and is really simple

so. is there a way to put small amounts of sql into the sql tag, and have this be executed without needing to use special flags to the iwcmd ?

I still didn't get your requirement. If you want to execute a SQL statement, you can very well do that in IPL. Please let us know when you want to execute that SQL?

moonkhanna

You may like to check your Database configuration for security issues. I think, your database\ server is secured not to let external applications run SQL Statements.. but only allows Stored Procedures... In which case, you will either have to get your DB\ server security changed or have your SQL Statements as SPs on your DB.

Maybe check if SQL Server uses some other port for SQL Statements and that port is blocked on your DB Server

I think, this will remain the same with ipl as well