DSXchange

Your umask needs to go in 2 places. It should be 002 in dsenv and uv.rc. In older version uv.rc is copied to /etc/rc2.d. In newer versions it is a link to DSEngine/samples/uv.rc. umask 002 Is the line you need to add if it is not there. you need to stop and start DataStage for the dsenv file to be r...

Download SaveAsBmp.bat from my tips page. It runs dsjob.exe to get a list of jobs in a project and then runs the Designer.exe with each job name with a /SaveAsBmp= option. So you should be able to modify this to run this command to export each job as XML. Make the first step to remove the output fil...

I just looked at KeyMgtGetNextValue. It only writes to one key value. It does not need to write this record until the end of the job. It writes this record more times than it needs to. It should be rewritten but this version is much safer to distribute. The faster version would always need to reseed...

Who is Ken?

You had to update the same hash file key twice otherwise it would not have to wait. You have to have duplicates or you are using up all the locks available. How many rows we talking about?

No. You need the readu. You do not need the writeu.

Panic DO NOT TYPE IN ALL CAPS. If you do not respect our wishes then leave the web site. I think your attitude is rude. Craig politely asked you not to post in CAPS. You asked questions posting urgent in the topic. We do not make any money answering your questions. When you are rude then it is no lo...

Change writeu to write. The writeu leaves the record locked.

Do a search there are lots of shell scripts posted already if you want to go that route.

Here is a routine which can be used in a routine activity which can be sent parameters. I will add this to my tips page soon. * ----------------------------------------------------------------- * EtlSendMail(EmailTo, EmailFrom, EmailServer, EmailSubject, EmailMsg) * -------------------------...

If it is not too big then post it in this thread with alt-c code tags around it.

Here is another tip. Do an "exact" search to find words like "iconv" and "oconv".

Build a stage variable. Add a CrLf or just Cr for each entry.

svRow = ""
svRow = svRow : "<city name='" : Link.City: "'" : CrLf
... next col

CrLf should be a stage variable set it to char(13):char(10).

We think it is because you have the job up in Designer.

You cannot read these 2 repeating groups in a server job in one link. It will give you an error. I had this issue in EtlStats. The dsjob.exe will export row counts as XML. There are repeating groups for parameters and links names. I would process this a sequential file with one column and build the ...

VC has a copy of the job. It is a project so you can delete within the VC project.