Stored procdure ( schema name. procedurename)

[Former Member]

Hi ,

where we specify the name of store procedure : if it has something like schemaname.storedprocedure name : in that case how shld i go about ?

since in data type we cannot give <b>.</b> .

Thanks

[justin_santhanam · Accepted solution]

Hi,

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

In the above structue, your question is how can we have scehma.spname in <table> .........</table> right?

If I understood u correctly,then

Take Constant [ Schema.SPname] -

---

>map to the target in <table> </table> node.

While calling the tables in AS400 we will use the same format.

Best regards,

raj.

[Former Member · Accepted solution]

Ok ,then what will I map in the storedprocedurename NODE if I map schema.stprocname in TABLE NODE.

Thnx

[justin_santhanam · Accepted solution]

Hi,

In the table node only u have to map the constant which I mentioned earlier.

Best regards,

raj.

[Former Member · Accepted solution]

Ok

Is there any parent child relation ,I need to follow .

Statement

Storedprocname

action

table

Or some other parent child relation ? Or it does not matter?

Thanks

[justin_santhanam · Accepted solution]

Hi,

I couldn't understand, can u plz explain lil bit comprehensive.

Best regards,

raj.

[Former Member · Accepted solution]

Do we need to follow any parent child relation :

STATEMENT

[child]storeprocedurename

[child]action

[child]table

Thanks

[Former Member · Accepted solution]

I am talking in above message ,the structure of DATA TYPE for stored procedure.

Thanks

[justin_santhanam · Accepted solution]

Hi,

Ofcourse, there must be parent-child relationship.

See the blog and see the struture ,that u need to create.

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Best regards,

raj.

[Former Member · Accepted solution]

The blog does not give level at which to declare table NODE but I guess it will be at same level as action NODE.

Thanks

[justin_santhanam · Accepted solution]

Hi,

Let me clear you. Actually there are two types of creating the stored procedure struture. One with Table node and other without it.

Structure -1

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

In the above case <storedProcedureName action=” EXECUTE”> what ever name u give in the StoredProcedureName will consider as real store procedure name. In the blog u can see the sp_GetROle which is the stored procedure name. It doesn't have table node. The above struture has one disadvantage u can't give scehma.spname right?

To over come the above disdvantage we can create another structure with Table node in it.

Structure -2

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

If you have table node in the strutucre , then what ever value u give in the table node tag will consider as real stored procedure name. Here u can map constant as u like, schema.spname

<Table> node must be child of <storedProcedureName action=” EXECUTE”>, action is the attribute of <storedProcedureName> , hope it helps!!!

If it doesn't , reply back.

Best regards,

raj.

[Former Member · Accepted solution]

Thanks Raj .

It helped.

Awarding your points.

Regards,