DSXchange

the data sorted after selected from db is : Type line col amt Stu 1 2 100 Stu 1 2 110 Stu 1 4 200 Stu 4 1 999 Stu 4 3 111 line is 1~15 and col is 1~4 the total amt for col 2 when line =1 is 210 and the total amt for col 4 when line =1 is 200, so the output for line=1 is 0,210,0,200 also the output f...

I mean if in the early stage i only get the data whose type is Stu, and line is 4, so i can calculate the number only for Stu which line is 4, but the number for Stu whose line<4 should be 3 lines ,all are 0,0,0,0 i don't know how to generate the 3 lines and output before the number which i calculat...

I mean if in the early stage i only get the data whose type is Stu, and line is 4, so i can calculate the number only for Stu which line is 4, but the number for Stu whose line<4 should be 3 lines ,all are 0,0,0,0 i don't know how to generate the 3 lines and output before the number which i calculat...

Thanks

if in the temp there is only Stu information whose line number is 4, and the all zero's lines should be gerenated by a routine?

a table named temp for information of people in db, and the sp is : v_type ='Stu' v_col_number := 1; v_line := 1; v_linecol5_total := 0; v_col1_total := 0; v_col2_total := 0; v_col3_total := 0; v_col4_total := 0; v_col5_total := 0; v_line_buf := ''; v_mat_days := 0; v_n1 := 'N'; v_n2 := 'N'; v_n3 :=...

check the constrain in lookup stage, try to select continue

Hi,all a store procedure after selecting some records then variable1=0 variable2=0 while (variable1<15) loop while (variable2<10) loop sum(amt) where varibale1= field1 and variable2= field2 variable2:= variable2+1 end loop variable1:=variable1+1 end loop how to implement this via DS job