Hi Ray,
I feel that, the configuration file may not be the reason, because we are using the same config file for all our jobs. Below is my OSH code.
Code: Select all
Parallel job initiated
# OSH / orchestrate script for Job EquipmentSAPFileLoad compiled at 23:38:24 07 FEB 2006
#################################################################
#### STAGE: Tbl_Equipment_Master
## Operator
odbcread
## Operator options
-db_cs [&DSProjectMapName]
-data_source '[&_SQL_Data_Source]'
-user '[&_SQL_USER_ID]'
-password [&_SQL_Password]
-table '[&_Source_Table_Name]'
-use_strings
## General options
[ident('Tbl_Equipment_Master'); jobmon_ident('Tbl_Equipment_Master')]
## Outputs
0> [modify (
EQUNR1:not_nullable string[max=18]=EQUNR1;
DATSL:nullable timestamp=DATSL;
EQTYP:nullable string[1]=EQTYP;
EQKTX:nullable string[max=50]=EQKTX;
TXLINE:nullable string[max=70]=TXLINE;
EQART:nullable string[max=50]=EQART;
BEGRU:nullable string[max=50]=BEGRU;
GROES:nullable string[max=50]=GROES;
BRGEW:nullable string[max=13]=BRGEW;
GEWE1:nullable string[max=3]=GEWE1;
INVNR:nullable string[max=50]=INVNR;
INBDT:nullable timestamp=INBDT;
ANSDT:nullable timestamp=ANSDT;
ANSWT:nullable string[max=50]=ANSWT;
WAERS:nullable string[max=50]=WAERS;
HERST:nullable string[max=50]=HERST;
HERLD:nullable string[max=50]=HERLD;
BAUJJ:nullable string[max=50]=BAUJJ;
BAUNM:nullable string[max=50]=BAUNM;
TYPBZ:nullable string[max=50]=TYPBZ;
MAPAR:nullable string[max=50]=MAPAR;
SERGE:nullable string[max=50]=SERGE;
SWERK:not_nullable string[max=50]=SWERK;
STORT:nullable string[max=50]=STORT;
MSGRP:nullable string[max=50]=MSGRP;
EQFNR:nullable string[max=50]=EQFNR;
RBNR:nullable string[max=50]=RBNR;
KOSTL:nullable string[max=50]=KOSTL;
BUKRS:nullable string[max=50]=BUKRS;
INGRP:nullable string[max=50]=INGRP;
IWERK:nullable string[max=50]=IWERK;
GEWRK:nullable string[max=50]=GEWRK;
TPLNR:nullable string[max=50]=TPLNR;
POSNR:nullable string[max=50]=POSNR;
TIDNR:nullable string[max=50]=TIDNR;
SUBMT:nullable string[max=50]=SUBMT;
DATUM:nullable timestamp=DATUM;
USEIT:nullable string[max=50]=USEIT;
HSTPS:nullable string[max=50]=HSTPS;
EQUNR:nullable string[max=50]=EQUNR;
DATDN:nullable timestamp=DATDN;
UZTDN:nullable timestamp=UZTDN;
MATNR:nullable string[max=50]=MATNR;
SERNR:nullable string[max=50]=SERNR;
CHARGE:nullable string[max=50]=CHARGE;
ROWID:not_nullable int64=ROWID;
keep
EQUNR1,DATSL,EQTYP,EQKTX,
TXLINE,EQART,BEGRU,GROES,
BRGEW,GEWE1,INVNR,INBDT,
ANSDT,ANSWT,WAERS,HERST,
HERLD,BAUJJ,BAUNM,TYPBZ,
MAPAR,SERGE,SWERK,STORT,
MSGRP,EQFNR,RBNR,KOSTL,
BUKRS,INGRP,IWERK,GEWRK,
TPLNR,POSNR,TIDNR,SUBMT,
DATUM,USEIT,HSTPS,EQUNR,
DATDN,UZTDN,MATNR,SERNR,
CHARGE,ROWID;
)] 'Tbl_Equipment_Master:ToTRANS.v'
;
#################################################################
#### STAGE: Txt_Equipment_Master
## Operator
export
## Operator options
-schema record
{final_delim=end, record_delim_string='\r\n', delim=',', null_field=' ', quote=double}
(
EQUNR1:string[max=18];
DATSL:nullable string[max=23] {null_field=''};
EQTYP:nullable string[max=1] {null_field=''};
EQKTX:nullable string[max=50] {null_field=''};
TXLINE:nullable string[max=70] {null_field=''};
EQART:nullable string[max=50] {null_field=''};
BEGRU:nullable string[max=50] {null_field=''};
GROES:nullable string[max=50] {null_field=''};
BRGEW:nullable string[max=13] {null_field=''};
GEWE1:nullable string[max=3] {null_field=''};
INVNR:nullable string[max=50] {null_field=''};
INBDT:nullable string[max=23] {null_field=''};
ANSDT:nullable string[max=23] {null_field=''};
ANSWT:nullable string[max=50] {null_field=''};
WAERS:nullable string[max=50] {null_field=''};
HERST:nullable string[max=50] {null_field=''};
HERLD:nullable string[max=50] {null_field=''};
BAUJJ:nullable string[max=50] {null_field=''};
BAUNM:nullable string[max=50] {null_field=''};
TYPBZ:nullable string[max=50] {null_field=''};
MAPAR:nullable string[max=50] {null_field=''};
SERGE:nullable string[max=50] {null_field=''};
SWERK:string[max=50];
STORT:nullable string[max=50] {null_field=''};
MSGRP:nullable string[max=50] {null_field=''};
EQFNR:nullable string[max=50] {null_field=''};
RBNR:nullable string[max=50] {null_field=''};
KOSTL:nullable string[max=50] {null_field=''};
BUKRS:nullable string[max=50] {null_field=''};
INGRP:nullable string[max=50] {null_field=''};
IWERK:nullable string[max=50] {null_field=''};
GEWRK:nullable string[max=50] {null_field=''};
TPLNR:nullable string[max=50] {null_field=''};
POSNR:nullable string[max=50] {null_field=''};
TIDNR:nullable string[max=50] {null_field=''};
SUBMT:nullable string[max=50] {null_field=''};
DATUM:nullable string[max=23] {null_field=''};
USEIT:nullable string[max=50] {null_field=''};
HSTPS:nullable string[max=50] {null_field=''};
EQUNR:nullable string[max=50] {null_field=''};
DATDN:nullable string[max=23] {null_field=''};
UZTDN:nullable string[max=23] {null_field=''};
MATNR:nullable string[max=50] {null_field=''};
SERNR:nullable string[max=50] {null_field=''};
CHARGE:nullable string[max=50] {null_field=''};
ROWID:int64 {quote=none};
)
-file '[&_Target_File_Path]/[&_Target_File_Name]'
-overwrite
-rejects continue
## General options
[ident('Txt_Equipment_Master'); jobmon_ident('Txt_Equipment_Master')]
## Inputs
0< 'TRANS:ToSEQ.v'
;
#################################################################
#### STAGE: TRANS
## Operator
transform
## Operator options
-flag run
-name 'V0S3_EquipmentSAPFileLoad_TRANS'
## General options
[ident('TRANS'); jobmon_ident('TRANS')]
## Inputs
0< 'Tbl_Equipment_Master:ToTRANS.v'
## Outputs
0> [] 'TRANS:ToSEQ.v'
;
# End of OSH code
Hi Kumar,
I can see the data by opening the data file as well as thru DS Stage.
Thanks.