DSXchange

I have multiple instance of /r /n in one field passing through the process explained bellow. The process flow is as follows. SAP INPUT ---------> HashFile-------->Flatfile--------->Target (Extract)(Remove dups) (Error???) Field with the bad data flows in from the SAP INPUT stage into a hash file to ...

Thank you Roy but it wont let me type in anything (guess that is because the parametre is encrypted) but i can use insert parametre. And sequencer_one is scheduled. Thats what I did....Hope it works this time.

Jobs are set up in the following order Sequencer_One ---> Calls -----> Sequencer_Two , Sequencer_Three......... Sequencer_Two ----->Calls-------> Job_1 , Job_2........ All variables are $PROJDEF and set up correctly in the administartor. All the user name passwords are passed in correctly for oracle...

We have installed the Enterprise Edition. The PX jobs just dont work good for extracts from SAP. Intial Ascential consultants were working with us and we decided for some reason not to go with px jobs. There are just a few test px jobs lying arround. Most of the datastage jobs are mainly used for ex...

Thank you I was waorried it might cause problems in the entire project.

I got the following error during importing the jobs for a project after instaltion of DS on a different server. The version od DS installed is the PX. However all the jobs are server jobs. Error calling DSR.RECORD (Action =2) Check Datastage is setup correctly in your project "Projectname"...

Thank you Guy' s for the feedback :D

I created a new project on a different server (dev to dev). copied the DSParam file from the old server into the new folder. Then went into the administrator and changed the setting and a couple of values. This reduced a lot of typing. I did the imports after this. Is it a common practise to do this...

HAVE THE FOLLOWING DATASTAGE ERROR Mismatch in number of column between data and link I use datastage 7.5 and use the ABAP pack to extract data. I get the above error after 3.7 million records. The ABAP stage uses the Build option to generate the ABAP and has two tables joined as an inner join. Has ...

I have raised the issue with asential... But this error is quiet persistant when I work with It. I do have the windows XP service pack2 --- and had the patch installed for it. That also does not help in any way. I did try going step by step and it still gives me problems. It is impossible for me to ...

cant seem to put a post on this site cant seem to find the link to it. I have problems with using the SAP R3 stage. I AM USING BUILD SQL TO GENERATE THE ABAP When I click on generate ABAP no ABAP code is generated. The second time I click on this it closes my datastage designer client. For tables wi...

Opens a new word for me

I need to do the following Create a Hashfile with the following composite keys Field one - Integer --Duplicates Allowed [Defined as key on creation] Field two - Date [Defined as key on creation] Field Three - Date [Defined as key on creation] Use Hash File as a look up for the above created hash fil...