how to insert data using a stored procedure in sap hana?????

[Former Member]

hello,

    Im new to sap hana db.My task is to write a stored procedure in sap hana to insert values in to a table .

   My table(sample) contains the following columns....

  email---varchar(100)

firstname---varchar(50)

lastname---varchar(50)

username---varchar(50)

password---varchar(100)

birthday---date

gender---varchar(10)

country---varchar(50)

state---varchar(50)

city---varchar(50)

How to write a stored procedure to insert values in to table(sample)????

plz help me out

thanks in advance

[rindia · Accepted solution]

Hi Sindhuja,

I created a column table "SRK"."SAMPLE" same as yours except that i missed state column. I created procedure SRK.SAMPLE_PROC as:

DROP PROCEDURE SRK.SAMPLE_PROC;

CREATE PROCEDURE SRK.SAMPLE_PROC (IN EMAIL VARCHAR (100)

                           , IN F_NAME VARCHAR (50)

                           , IN L_NAME VARCHAR (50)

                           , IN U_NAME VARCHAR (50)

                           , IN PW VARCHAR (100)

                           , IN BDAY DATE

                           , IN GENDER VARCHAR (10)

                           , IN COUNTRY VARCHAR (50)

                           , IN CITY VARCHAR (50)

                            )

LANGUAGE SQLSCRIPT AS

BEGIN

INSERT INTO "SRK"."SAMPLE" VALUES (EMAIL, F_NAME, L_NAME, U_NAME, PW, BDAY, GENDER, COUNTRY, CITY);

END;

CALL SRK.SAMPLE_PROC (

                       'ABC@GMAIL.COM'

                      ,'RAJ'

                      ,'SALLA'

                      ,'RAJKUMAR'

                      ,'Ae457tgUybd'

                      ,'19000101'

                      ,'MALE'

                      ,'INDIA'

                      ,'HYDERABAD'

                      );

Below is the screenshot which created the procedure and also inserted a record in table SAMPLE.

 

Regards

Raj

[Former Member · Accepted solution]

i tried it before...it worked ..tanq

[SrinivasReddy]

Hi Sindu

Creation  of Store Procedures on the Table to insert values

CREATE  SCHEMA  SCH

CREATE COLUMN TABLE "SCH"."MYTABLE"( "EMAIL" VARCHAR (100) NULL,

       "FIRSTNAME" VARCHAR (50) NULL,

       "LASTNAME" VARCHAR (50) NULL,

       "USERNAME" VARCHAR (50) NULL,

       "PASSWORD" VARCHAR (100) NULL,

       "BIRTHDAY" DATE NULL,

       "GENDER" VARCHAR (10) NULL,

       "COUNTRY" VARCHAR (50) NULL,

       "STATE" VARCHAR (50) NULL,

       "CITY" VARCHAR (50) NULL);

CREATE PROCEDURE SCH.MY_INSERT_PROCS (IN EMAIL VARCHAR(100),

       IN FIRSTNAME VARCHAR(50) ,

       IN LASTNAME VARCHAR(50),

       IN USERNAME VARCHAR(50),

       IN PASSWORD VARCHAR(100),

       IN BIRTHDAY DATE,

       IN GENDER VARCHAR(10),

       IN COUNTRY VARCHAR(50),

       IN STATE VARCHAR(50),

       IN CITY VARCHAR(50) ) LANGUAGE SQLSCRIPT AS

BEGIN INSERT

INTO "SCH"."MYTABLE" VALUES (EMAIL ,

      FIRSTNAME,

      LASTNAME,

      USERNAME,

            PASSWORD,

      BIRTHDAY,

      GENDER,

      COUNTRY,

      STATE,

      CITY)

;

END

;

Regards

Srinivas