DSXchange

I will suggest you to create a sample job and try to see if you are able to read your text from sequential stage.

share your findings

Could you please tell us how did you resolve this issue

Try to use Unicode in column definition of the field which has these extended ascii char, then see if your out has same char after processing through job. after then you can covert the ascii of these char into spaces etc.

if your reference data is small enough to fit into RAM, job throughput will be more

We are trying to move from Legacy systems to SAP , what I am trying to understand is , can we load the data from Legacy system to SAP using IDocs via DataStage. For eg can I load materials into MARA table. Yes you can Load data to sap table using IDoc Stage, but you need to choose right Message Typ...

it will pick up value defined in system/OS enviorment variable

Check datastage director log if it is aborting due to crosssing the maximum no of warning limit.

@INROWNUM - Input row counter. For use in constraints and derivations in Transformer stages.

@OUTROWNUM - Output row counter (per link). For use in derivations in Transformer stages.

so if there is any drop of records at transformer you can see the different no for both

Hello All,

Can anyone send me link or learning material on IBM Information Server Packs for SAP R/3 V6.0

Thanks,
Deepak

verify your jobs and check if you are creating same dataset by using two different job on same time. may be you can restart your job, it should fix your issue. some time this errror comes when one job is trying to create dataset and other job is also same time trying to create it and before creation...

execute your db2 stage in sequential mode, may be you are running your reference stage in parallel mode.

go to stage propertise and click advance and change execution mode to sequential mode

if any inone still facing the issue, can add below two environement without pre-fixing $ to variable in user defined enviorment variable APT_CONFIG_FILE=C:/Ascential/DataStage/Configurations/2Node.apt APT_ORCHHOME=C:/Ascential/DataStage/PXEngine steps 1- goto control pannel ->system propertise -> ad...

put copy stage in middle of reject link from lookup and database stage. and unchacked key fields

this is called vertical pioveting, can be done by using two sort stages and 1 transformer stage 1st sort stage - sort the databased on key column and enable key change column 2nd sort stage - use 'dont sort previosuly sorted' data on key column and sort key change field in ascending order. 3rd trans...

you can also used LTrim function