Silver_mani Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358818297' post='1303149063'] hmm.. even though the job3 finish ayna sare...it will again start frm job3..since the cjeck point only captures until tht point..anteenaa in tht case...[b]if in an example case job3 loads the data into a table..and we restart the sequence..then it will again try to insert the same records into the table..then may be proper handling has to be taken care of[/b] sarle..how abt the nxt one [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]another question was sequence job properties lo inko opton untadi "Automatically handle activities that fail" ani what is the use of it?[/background][/size][/font][/color] [/quote] job abort avutundi baa ........nee keys correct ga vunte duplicates insert avvavu baa .......it should be an update to the table ....so nee Load option should be Insert Then Update .
mrudhula99 Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358818297' post='1303149063'] hmm.. even though the job3 finish ayna sare...it will again start frm job3..since the cjeck point only captures until tht point..anteenaa in tht case...if in an example case job3 loads the data into a table..and we restart the sequence..then it will again try to insert the same records into the table..then may be proper handling has to be taken care of sarle..how abt the nxt one [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]another question was sequence job properties lo inko opton untadi "Automatically handle activities that fail" ani what is the use of it?[/background][/size][/font][/color] [/quote] may be fail aina kuda.... job continue avuthundhi emooo.... kani... nuvvu paina cheppav kadha... job3 fail ayyendhi ani.. so andhukee akkada nundii mali job start avuthundhiii..
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='Silver_mani' timestamp='1358818547' post='1303149072'] job abort avutundi baa ........nee keys correct ga vunte duplicates insert avvavu baa .......it should be an update to the table ....so nee Load option should be Insert Then Update . [/quote] oh kk baa..
mrudhula99 Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358822232' post='1303149423'] oh kk baa.. [/quote] [size=4] [/size][size=4] [/size]
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='mrudhula99' timestamp='1358818627' post='1303149077'] may be fail aina kuda.... job continue avuthundhi emooo.... [b]kani... nuvvu paina cheppav kadha... job3 fail ayyendhi ani.. so andhukee akkada nundii mali job start avuthundhiii..[/b] [/quote] job3 finished with warnings ante..it doesn't mean it failed..the overall sequence gets failed due to that warnings..but nuvvu anadi correct ee lee..DS don't know abt all these thngs..it will start running frm job3 up on restart..
mrudhula99 Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358822373' post='1303149435'] job3 finished with warnings ante..it doesn't mean it failed..the overall sequence gets failed due to that warnings..but nuvvu anadi correct ee lee..DS don't know abt all these thngs..it will start running frm job3 up on restart.. [/quote] nuvvu option change cheyyochu.. incase warning ganaka.. 3kante ekuva untee.. pass cheyyee or else seq ni fail cheyyee ani.. condition kavalantee cheppu... will let you know..
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='mrudhula99' timestamp='1358822322' post='1303149431'] [size=4] [/size] [/quote]
mrudhula99 Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358822537' post='1303149452'] [/quote] you will be grounded for this... [size=4] [/size]
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='mrudhula99' timestamp='1358822445' post='1303149445'] nuvvu option change cheyyochu.. incase warning ganaka.. 3kante ekuva untee.. pass cheyyee or else seq ni fail cheyyee ani.. condition kavalantee cheppu... will let you know.. [/quote] yaa..but maa lead gadu..... programming language lo naaku nachani padaloo warnings okati anee type lee..so our jobs should be warning free
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='mrudhula99' timestamp='1358822590' post='1303149457'] you will be grounded for this... [/quote] nuvventi agnatam lo undi reply luu istunnavu[img]http://www.andhrafriends.com/uploads/gallery/album_19/gallery_731_19_208317.gif[/img]
Silver_mani Posted January 22, 2013 Report Posted January 22, 2013 Native Error Code = -407: Msg = [IBM][CLI Driver][DB2/NT64] SQL0407N [b]Assignment of a NULL value to a NOT NULL column [/b]"TBSPACEID=140, TABLEID=4, COLNO=1" is not allowed. SQLSTATE=23502 data antha check chesanu ........no nulls ....... poddune tala tirugutundi .......any ideas ? [img]http://i.imgflip.com/c9tm.gif[/img]
dalapathi Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358818297' post='1303149063'] hmm.. even though the job3 finish ayna sare...it will again start frm job3..since the cjeck point only captures until tht point..anteenaa in tht case...if in an example case job3 loads the data into a table..and we restart the sequence..then it will again try to insert the same records into the table..then may be proper handling has to be taken care of sarle..how abt the nxt one [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247,247,247)]another question was sequence job properties lo inko opton untadi "Automatically handle activities that fail" ani what is the use of it?[/background][/size][/font][/color] [/quote] memu restart points vaadutaamu sequencer lo ... Nested condition ani oka stage vuntahid kadaa sequencer lo ... andhulo restart points istaamu ... vaatini parmaeters lo oka environmental variable ichi andhulo order istaamu ... deni taruvata edhi ani ... ekkada aagitey manual gaa memu akkada nundi run chestaam
Silver_mani Posted January 22, 2013 Report Posted January 22, 2013 [quote name='dalapathi' timestamp='1358878240' post='1303152770'] memu restart points vaadutaamu sequencer lo ... Nested condition ani oka stage vuntahid kadaa sequencer lo ... andhulo restart points istaamu ... vaatini parmaeters lo oka environmental variable ichi andhulo order istaamu ... deni taruvata edhi ani ... ekkada aagitey manual gaa memu akkada nundi run chestaam [/quote] dala mayya naa question ki answer cheppava ??
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='Silver_mani' timestamp='1358876960' post='1303152610'] Native Error Code = -407: Msg = [IBM][CLI Driver][DB2/NT64] SQL0407N [b]Assignment of a NULL value to a NOT NULL column [/b]"TBSPACEID=140, TABLEID=4, COLNO=1" is not allowed. SQLSTATE=23502 data antha check chesanu ........no nulls ....... poddune tala tirugutundi .......any ideas ? [img]http://i.imgflip.com/c9tm.gif[/img] [/quote] data antha chk ante..may be u might miss some thng baa...run the job wiith a single row and see baa
Silver_mani Posted January 22, 2013 Report Posted January 22, 2013 [quote name='arey ooo samba' timestamp='1358879593' post='1303152978'] data antha chk ante..may be u might miss some thng baa...run the job wiith a single row and see baa [/quote] ayanni aipoyayi baa ...dba ki cheppina ...chusi chepta annadu
Recommended Posts