dalapathi Posted December 18, 2012 Report 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]
qwerty1204 Posted December 18, 2012 Author Report 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]
dalapathi Posted December 18, 2012 Report 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]
qwerty1204 Posted December 18, 2012 Author Report 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]
mrudhula99 Posted December 18, 2012 Report 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
mrudhula99 Posted December 18, 2012 Report 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]
dalapathi Posted December 18, 2012 Report 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
qwerty1204 Posted December 18, 2012 Author Report 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]
pandemkodi Posted December 18, 2012 Report 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
Maximus Posted December 18, 2012 Report 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]
mrudhula99 Posted December 18, 2012 Report Posted December 18, 2012 [quote name='pandemkodi' timestamp='1355859011' post='1302974674'] datastage never commits partially inserted rows if job get aborted [/quote] it will ...
Kakateyudu Posted December 18, 2012 Report Posted December 18, 2012 [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
mrudhula99 Posted December 18, 2012 Report 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...
pandemkodi Posted December 18, 2012 Report Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355859360' post='1302974721'] it will ... [/quote] no..
mrudhula99 Posted December 18, 2012 Report 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?
Recommended Posts