export 를 받으실때 sql 문으로 원하는 형태의 데이터를 만들어 주시면 됩니다. 

export to s.ixf of ixf select * from st where ~~~;
import from s.ixf of ixf commitcount 10000 replace_create into com;

원하시는 답변인지 모르겠네요. 


아래는 예제입니다.

create table t1(c1 integer, c2 char(5))
insert into t1 values (1,'a'),(1,'b'),(1,'c'), (2,'a'),(2,'b'),(2,'c'),(2,'d'), (3,'a'),(3,'b')

select * from t1

C1          C2  
----------- -----
          1 a   
          1 b   
          1 c   
          2 a   
          2 b   
          2 c   
          2 d   
          3 a   
          3 b   

  9 record(s) selected.

select c1,c2,rownumber() over(partition by c1) rn, max(rownumber() over(partition by c1)) over(partition by c1) max from t1

C1          C2    RN                   MAX                
----------- ----- -------------------- --------------------
          1 a                        1                    3
          1 b                        2                    3
          1 c                        3                    3
          2 a                        1                    4
          2 b                        2                    4
          2 c                        3                    4
          2 d                        4                    4
          3 a                        1                    2
          3 b                        2                    2

  9 record(s) selected.

select c1,max(value(case when rn = max-3 then c2 end,''))||

              max(value(case when rn = max-2 then c2 end,''))||

              max(value(case when rn = max-1 then c2 end,''))||

             max(value(case when rn = max-0 then c2 end,''))

from ( select c1,c2,rownumber() over(partition by c1) rn, max(rownumber() over(partition by c1)) over(partition by c1) max from t1 where c1=1 ) a group by c1

C1          2                  
----------- --------------------
          1 a    b    c        

  1 record(s) selected.