dalapathi Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='Maximus' timestamp='1355853887' post='1302973942'] [img]http://lh6.ggpht.com/-pLotjruTwU8/T9VQrBiE0lI/AAAAAAAAGng/JioSCX6SR0U/s150/Trivikram-1.gif[/img]voorikey lepa..ee thread loki eppudu raledu...[size=5][b]future lo evarikayiana use avuthundemo ani oka post vesa...[/b][/size] [/quote] Link to comment Share on other sites More sharing options...
qwerty1204 Posted December 18, 2012 Author Report Share Posted December 18, 2012 [quote name='dalapathi' timestamp='1355853591' post='1302973906'] Wrong thread loki vachianv Maxi ... neeku ikkademi pani[img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] [/quote] dala baa eni ila vachia ala vellipoyavuu [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] Link to comment Share on other sites More sharing options...
dalapathi Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355857477' post='1302974487'] dala baa eni ila vachia ala vellipoyavuu [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] [/quote] Office verey chotiki move ayyindhi ... cubes ani open gaa vunanayi ... [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] Link to comment Share on other sites More sharing options...
qwerty1204 Posted December 18, 2012 Author Report Share Posted December 18, 2012 [quote name='dalapathi' timestamp='1355858059' post='1302974563'] Office verey chotiki move ayyindhi ... cubes ani open gaa vunanayi ... [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] [/quote] ohh kk..aite ika DB taginchesavaa[img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] Link to comment Share on other sites More sharing options...
mrudhula99 Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355853372' post='1302973875'] I have to insert 500 rows in a DB2 table....oka 100 rows insert ayyka due to space issues or some other issues job abort aite................aa load ayna 100 records ni ela rollback chestamu [/quote] db admin ki cheppu delete cheyyamantee cheyyaraa?? or else try to reload new data.. truncate and reload Link to comment Share on other sites More sharing options...
mrudhula99 Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='dalapathi' timestamp='1355858059' post='1302974563'] Office verey chotiki move ayyindhi ... cubes ani open gaa vunanayi ... [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] [/quote] Link to comment Share on other sites More sharing options...
dalapathi Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355858422' post='1302974607'] ohh kk..aite ika DB taginchesavaa[img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] [/quote] Yeah, lite gaa Link to comment Share on other sites More sharing options...
qwerty1204 Posted December 18, 2012 Author Report Share Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355858718' post='1302974632'] db admin ki cheppu delete cheyyamantee cheyyaraa?? or else try to reload new data.. truncate and reload [/quote] manual ga kakunda..once the job fails it has to taken by it self ani [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] Link to comment Share on other sites More sharing options...
pandemkodi Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355853372' post='1302973875'] I have to insert 500 rows in a DB2 table....oka 100 rows insert ayyka due to space issues or some other issues job abort aite................aa load ayna 100 records ni ela rollback chestamu [/quote] datastage never commits partially inserted rows if job gets aborted Link to comment Share on other sites More sharing options...
Maximus Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='dalapathi' timestamp='1355858962' post='1302974665'] Yeah, lite gaa [/quote][img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmi%20laugh.gif[/img] Link to comment Share on other sites More sharing options...
mrudhula99 Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='pandemkodi' timestamp='1355859011' post='1302974674'] datastage never commits partially inserted rows if job get aborted [/quote] it will ... Link to comment Share on other sites More sharing options...
Kakateyudu Posted December 18, 2012 Report Share Posted December 18, 2012 [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img] Link to comment Share on other sites More sharing options...
mrudhula99 Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355858977' post='1302974669'] manual ga kakunda..once the job fails it has to taken by it self ani [img]http://lh4.ggpht.com/-JZOvoBfN6w8/UGD9BmzNPQI/AAAAAAAAHb8/l4Mf4YWBTvA/s150/Brahmi-3.gif[/img] [/quote] it has to be taken by itself a?? table ki theleidhu ga.. nee data lo trash undhani... it will load whatever comes first... Link to comment Share on other sites More sharing options...
pandemkodi Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355859360' post='1302974721'] it will ... [/quote] no.. Link to comment Share on other sites More sharing options...
mrudhula99 Posted December 18, 2012 Report Share Posted December 18, 2012 [quote name='pandemkodi' timestamp='1355859492' post='1302974746'] no.. [/quote] file ki kuda sagam sagam lod cheyyadhaa?? incase job run avuthunnapudu suppose 1000 rows load ayyaka.. nenu job stop chesaa anukoo... appudu emavuthundhii? Link to comment Share on other sites More sharing options...
Recommended Posts