Oninit cdi / Archive
Talk to an expert →

? scripts are these?

Posted in 1999

Topics: General Discussion

Son Trung Nguyen — — source: Informix-list mailing list archive (1991-1998)

Hello Netters, Could someone help? I need to understand the follow scripts ASAP but can't seem to find information anywhere. I was told it works with Redbricks so that's informix right? Anyway, are these any information on the syntax on the web? anyone got any documentations you can email me? I am desperate! Thanks in advance LOAD DATA INPUTFILE '-' MODIFY FORMAT SEPARATED BY '~' DISCARDFILE '$DISCARDFILE' --DISCARDS 100 AUTOROWGEN OFF OPTIMIZE OFF INTO TABLE T_INTERNET_DETAIL ( DETAIL_TYPE_CD INTEGER EXTERNAL, SEQUENCE_NO INTEGER EXTERNAL, CALL_SESSION_ID INTEGER EXTERNAL, START_DATE DATE 'YYYYMMDD', START_TIME TIME 'HH:II:SS', END_DATE DATE 'YYYYMMDD', END_TIME TIME 'HH:II:SS', APPLICATION_TYPE_CD INTEGER EXTERNAL, CIRN_NPA CHARACTER, CIRN_NXX CHARACTER, CIRN_LINE_NO CHARACTER, BILLING_NPA CHARACTER, BILLING_NXX CHARACTER,

↪ replying to Son Trung Nguyen
FuzzNutz — — source: Informix-list mailing list archive (1991-1998)

Once upon a time -> Fri, 20 Aug 1999 00:27:11 GMT hidden deep in the post of<FGqMLB.AsB.0.bloor@torfree.net> Son Trung Nguyen proclaimed: >Hello Netters, > >Could someone help? I need to understand the follow scripts >ASAP but can't seem to find information anywhere. I was told >it works with Redbricks so that's informix right? Anyway, >are these any information on the syntax on the web? anyone >got any documentations you can email me? I am desperate! > >Thanks in advance > >LOAD DATA >INPUTFILE '-' >MODIFY >FORMAT SEPARATED BY '~' >DISCARDFILE '$DISCARDFILE' >--DISCARDS 100 >AUTOROWGEN OFF >OPTIMIZE OFF >INTO TABLE T_INTERNET_DETAIL >( > DETAIL_TYPE_CD INTEGER EXTERNAL, > SEQUENCE_NO INTEGER EXTERNAL, > CALL_SESSION_ID INTEGER EXTERNAL, > START_DATE DATE 'YYYYMMDD', > START_TIME TIME 'HH:II:SS', > END_DATE DATE 'YYYYMMDD', > END_TIME TIME 'HH:II:SS', > APPLICATION_TYPE_CD INTEGER EXTERNAL, > CIRN_NPA CHARACTER, > CIRN_NXX CHARACTER, > CIRN_LINE_NO CHARACTER, > BILLING_NPA CHARACTER, > BILLING_NXX CHARACTER, If I'm not mistaken that's SQL*Loader syntax Try the Oracle website

↪ replying to Son Trung Nguyen
FuzzNutz — — source: Informix-list mailing list archive (1991-1998)

Son Trung Nguyen wrote: >Hello Netters, > >Could someone help? I need to understand the follow scripts >ASAP but can't seem to find information anywhere. I was told >it works with Redbricks so that's informix right? Anyway, >are these any information on the syntax on the web? anyone >got any documentations you can email me? I am desperate! > >Thanks in advance > >LOAD DATA >INPUTFILE '-' >MODIFY >FORMAT SEPARATED BY '~' >DISCARDFILE '$DISCARDFILE' >--DISCARDS 100 >AUTOROWGEN OFF >OPTIMIZE OFF >INTO TABLE T_INTERNET_DETAIL >( > DETAIL_TYPE_CD INTEGER EXTERNAL, > SEQUENCE_NO INTEGER EXTERNAL, > CALL_SESSION_ID INTEGER EXTERNAL, > START_DATE DATE 'YYYYMMDD', > START_TIME TIME 'HH:II:SS', > END_DATE DATE 'YYYYMMDD', > END_TIME TIME 'HH:II:SS', > APPLICATION_TYPE_CD INTEGER EXTERNAL, > CIRN_NPA CHARACTER, > CIRN_NXX CHARACTER, > CIRN_LINE_NO CHARACTER, > BILLING_NPA CHARACTER, > BILLING_NXX CHARACTER, If I'm not mistaken that's SQL*Loader syntax Try the Oracle website