DSXchange

Probably you are doing the lookup in a transformer stage where you have the main link coming from the sequential file and the reference from the hash file stage. You might be updating the hash file somewhere first from a database stage probably ODBC. so in reference link remove the hash file and dir...

if you have checked everything then its strange if you do not get any data from the hash to the look up although you have matching data. The job as i suppose you are looking at have some source link entering the lookup and there being a database link updaing the hash file that goes into the lookup r...

I have a requirement where I have to get the value in the output field as '00000000' which is a date field. The requirement is to be done in the transformer and gets further into IDOC Sap Stage. I tried the following function: StringToDate("00000000","%yyyy%mm%dd") It transforms ...

There also being settings in the DS Administrator Project Properties that restricts the logs as based on the last runs of the job. Verify that and that should give you a picture that how many runs of the logs are captured for the jobs in the project.

ulimit -a is giving me.. It should be a warning and not an error. It is not causing the issue it should be something else. Verify the file path and the file name and also the delimiter in the file properties probably quotes and others. Probably try to copy some sequential file stage from any other r...

Hi,
My requirement is like there is a string say "abcpqrxyz"
i want it to convert it into "abc-pqr-xyz"

In server i could cut the strings and concatenate with "-" in between.

But i need to do this in parallel job.

Please suggest.
Thanks
Abhijit

can u please let me know a bit more on how to do the bulk loading

Hi, I am trying to import around 60 Million Records from SAP R3 ABAP Stage to the DB2 Database. The source stage is the ABAP Program Stage to pull the records from R3 using the ABAP program. Then we are getting the data loaded into DB2 database without any transformation in between. In this process ...

If you are doing Inner Join on the Col1 the output would have one record.
So try to remove the duplicates with key being Col1 and then sort the records using the Hash Partitioning, before you do the join ...
Probably on doing that you wont be getting this error.
Thanks
Abhijit

You can parameterize the query limit offcourse.
Check on the records how would you like to filter that into six groups based on which you may use the query limits in that. You can create that parameter in the Job properties .
Abhijit

include the following statement in the beginning of yours shell script if its not there....

#!/bin/ksh

Abhijit

check the DNS name in the network setting if the project you are connecting is in server with a designated dns configuration suppose you have yours server at ABC@xyz.com check if the domain name xyz.com is added in the network setting DNS names if not add it else while you login to datastage put the...

just right click on the job name in the repository window in designer and say delete.... if it does not gets deleted then probably some issue with urs connection between client and server. try to compile the job i hope it should yet give error. Deletion of jobs have nothing to do with its status. If...

Its true the SMTP mail server being not set up for offshore..... Also try sending mail using unix do a test if it works else check the log.... From UNIX you can send mail using the following command. mailx -s "Type Subject Here" mail_id\@domain < "file name to be mailed as content&quo...

You may try the command as..... ps -ef | grep DSD this would show all the datastage jobs running in the server and you can explore the process using the process id. Further regarding the memory utilization you may check the size the scratchdisk while the job is running the command du -g . or df -g .