tommy Posted July 7, 2013 Author Report Posted July 7, 2013 already procedure undhi bhayya..nenu just dani run chesi tablle ni update cheyali....
tommy Posted July 7, 2013 Author Report Posted July 7, 2013 [quote name='mahesh123' timestamp='1373234258' post='1303928859'] nuvvu clear ga adugu ...adigindi clear ga ledu.... neekem kavali adi step by step clear ga chepu.... i can help you [/quote] Bhayya nenu kotha ga job lo cherenu....and lady who used to update tables is on leave...so every mon tables update chestaru anta...nannu cheyamanaru... ameni adigithe em ledu procedure run chesi data ni populate cheyi and see that data lo todays date undali andi...
tommy Posted July 7, 2013 Author Report Posted July 7, 2013 [quote name='tommy' timestamp='1373234596' post='1303928868'] Bhayya nenu kotha ga job lo cherenu....and lady who used to update tables is on leave...so every mon tables update chestaru anta...nannu cheyamanaru... ameni adigithe em ledu procedure run chesi data ni populate cheyi and see that data lo todays date undali andi... [/quote] ani cheppi table peru chepindhi...and store the updated data into another table andhi....
tommy Posted July 7, 2013 Author Report Posted July 7, 2013 exact conversationbetween me and that is this...email chesindhi [color=#282828][font=helvetica, arial, sans-serif][size=5] [color=#000000][font=Calibri]run AZ-SMY-YPC-RPT-TBL-DEV and make sure the data is populated and matches with current date.[/font][/color][/size][/font][/color] [color=#282828][font=arial, sans-serif][size=3][size=5][color=#000000][font=Calibri]Then store it to AZ-SMY-YPC-RPT-TBL.and also [/font][/color][color=#1F497D][font=Calibri]check that AZ_LOAD_SMY_YPC_FNL_RPT_TBL PROCEDURE has run and AZ_SMY_YPC_FNL_RPT_TBL also updated..[/font][/color][/size][/size][/font][/color]
SUbba LIngam Posted July 7, 2013 Report Posted July 7, 2013 first di table name ayithe query chesi data mottam updated ga undo ledo chudamantunnadu anukunta,,,,,,,,,,, Toad lo run cheyadanii F5 or F9 key use cheyochu.
ArjunPalwai Posted July 7, 2013 Report Posted July 7, 2013 [quote name='tommy' timestamp='1373234288' post='1303928861'] already procedure undhi bhayya..nenu just dani run chesi tablle ni update cheyali.... [/quote] naku telisi. update statement procedure lo undi anukunta. you need to execute the procedure. syntax for procedure execution: EXECUTE [or EXEC] package_name.procedure_name; idi run chesi choodu. and check the table after the execution. I think it helps.
Recommended Posts