Link to home
Start Free TrialLog in
Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America

asked on

need to insert control record one time in sql loader

I want to insert a record in a control table at the beginning of the load (with NEXTVAL seqno), then with the regular load will use CURRVAL.

Can I say something like "where rownum = 1" ? so it only happens once ?


APPEND INTO TABLE medpartd.etl_file_load_det
        when (rownum = 1) <-- something line this ??
        (
        etl_load_file_id "medpartd.etl_file_load_det.nextval",
        etl_file_nm constant 'MMR Load from CGI',
        etl_prcs_load_dt "sysdate"
        )
        INTO TABLE MEDPARTD.cgdp_stg_mthly_membshp_det
        (
        mthly_membshp_skey "medpartd.mor_rpt_det_seq.nextval",
        aud_insrt_id "user",
        aud_srce_sys_cd constant '194',
        aud_insrt_tmstp "localtimestamp",
        etl_load_file_id "medpartd.etl_file_load_det_seq.currval",
        MCO_CTRT_NBR  position (1:5) char,
        RUN_DT_OF_THE_FILE  position (6:13) char,
        PAYMT_DT  position (14:19) char,
        HIC_NBR  position (20:31) char,

Open in new window

Avatar of no worries :-) no nothing
no worries :-) no nothing
Flag of Greece image

rownum is for records selection
Avatar of Alaska Cowboy

ASKER

georgekl,

is there any way to accomplish what I'm trying to do ?
ASKER CERTIFIED SOLUTION
Avatar of Alaska Cowboy
Alaska Cowboy
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
self-solved.