Difference between Procedure create via Modeler and Development ?

[pavneet_rana]

Hi to all,

As i know, we can create procedure via Modeler and Development, what the difference between them ?

Please also provide document for same.

Also

If we create procedure via Development perspective in HANA., we can create procedure via below 2 way .

1.  File -> New File-> Procedure name(.procedure)

and

2. Via Stored Procedure (file format (.hdbprocedure)

Both have difference symbols for procedure.

Please can you explain, why this 2 method also in development perspective also ?.

Please also provide document for same.

Regards

Pavneet Rana

[Former Member]

HI,

procedure:

1. can contain local types,

2. xml files

hdbprocedure:

1. no local types (use CDS file to declare IN/OUT complex structures),

2. text files

Seems xml procedures will be deprecated soon.

Denis.

[Former Member]

Hi Pavneet,

There is no difference between these 2...Procedures can be created either by Modeller or a HANA Development associate.

You can see similar things in SQL Console also..There are different areas in HANA studio from where you can execute any SQL scripts.

Regards,

Joydeep.