@@@@calling All Datastage Developers@@@@

[Silver_mani]

[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]

[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]

[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]

[quote name='arey ooo samba' timestamp='1358822232' post='1303149423']

oh kk baa..
[/quote]
[size=4] [/size][size=4] [/size]

[qwerty1204]

[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]

[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]

[quote name='mrudhula99' timestamp='1358822322' post='1303149431']
[size=4] [/size]
[/quote]

[mrudhula99]

[quote name='arey ooo samba' timestamp='1358822537' post='1303149452']


[/quote]


you will be grounded for this... [size=4] [/size]

[qwerty1204]

[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]

[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]

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]

[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]

[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]

[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]

[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