DSXchange

Try DecimalToString function with "suppress_zero" parameter

Change the value of APT_STRING_PADCHAR variable to '' or Hex value 0x20.

you can do this either at project level or can add this parameter in the job and change its value for the specific job.

just check if you are using the same column elsewhere in transformer. In addition to this put the property NullFieldValue='' in the Reject(sequential File)...

Also if-then-else syntax is redundant as you can use the function NullToValue(Source,'A') directly.

Provide some more information like

What is the error your offshore team is getting while trying to login on DataStage ?

Either run the job in sequential mode or insert a transformer after the sequential file to copy the msg_id with each if the messages and later you can partition all the data based on msg_id.

try using the below command:

touch /opt/Ascential/Data/AIS_MIG_MAINT/MIGRATION/TEST/1200_Completed.txt

but for this you should have the write permission on this directory

Hi All, We are just trying to use the SAP Plug-in in one of pur projects on DataStage Version 8.0 and just want to know following things:- 1) Do we have a plug-in to connect to SAP Version ECC 6.0 ? 2) Are there any separate adapters to writer to ISU and CRM ? 3) Also Are we breaching some SAP licen...

Thanks Divyesh,

Got the problem resolved by following the steps given by you.

Hi All, Whenever I am running the profiling jobs using the Parallel Extender the temp space i.e. /tmp directory on the server is getting full which in effect causes the profiling job to abort. I have tried changing the TEMP parameter to a different directory but the Orchestrate files are still getti...

Hi, We are trying to do the profiling on the source files and are finding that jobs for few files are getting aborted. We tried to do the analysis for each column seperately for those files and found that only for some specific columns the jobs are getting aborted. The Profile Stage Error files just...

Can you please tell us which version of DataStage you have tried to install. The reason why I am asking this is that I have tried installing DataStage 7.5.1 but it didn't work.

I later found out in one of the Readme files that only DataStage 7.5x2 can work on Windows XP Pro.

Are you doing some pre-sorting before aggregation ?

Definitely its an space/memory issue. Temporary fix can be to run the job as sequential or make aggregator stage as sequential.

It seems you are running th job on 2 node configuration and since you are having 3 input files to join so it is resulting in 6 entries.

Column import will work fine in your case. Just define the schema as Fixed length file with no delimiter.

dsusr

The problem has been resolved, we can have the following option in the schema:-

TT=Stream

The above will work for all fixed length files which dont have any end of line delimiter.

TT=Fixed --- this option will work for the fixed length files with end of line delimeter.