DSXchange

No. It is in the dsenv file. In the job's log file, open the second entry which has listings of all the environment variables. Search for the environment variables i mentioned and see if they are set properly.

Go through the manuals. That should give you a kick start on the "how to's". We have "Data Quality" forum dedicated to Quality Stage issues. You can refer to them.

This is a seperate problem and requires a new thread. Start a new thread.

Thanks for sharing the solution. You can mark your post as resolved.

Really...
Anyways, heres the code.

The new file will have one row split into 12 rows the way you want it.

Did you try to do it yourself buddy. Give Roy's methodology a shot. Also if you dont know awk it will be hard for you to even understand the code i give you. Try to do it yourself, if nothing works out at the end then post again and i will give you the awk code.

I suggest having a chat with your unix system admin. He/she can give you an idea of how much the system can handle concurrently. If more processes need to be run, he/she can tune the kernal for the same.

A simple routine can do the trick as well using the methodoligy embedded in Craigs post. If you love awk, a single liner awk is enough.

Just getting tired of all the pleading... the whole point of this place is helping others, people don't need to end every post with a plea for help. Hang tight, be patient, you'll get whatever help people can provide when they can provide it... no groveling required. Thats true Craig. Been seeing t...

Do you have an explicit commit being passed at the end of your stored procedure inside the code? If yes then you need to take that out first and then try testing it.

If you are writing a script then the simplest way is to go for dsjob -ljobs option and redirect them to a text file. That file will then contail all your job names for that particular project.

chulett wrote:
Please Guru help me.

What gotton into you Craig

Any special reason why you want to use the transformer for this?

As ArndW suggested, nothing out of the box. What you could do is spit out the entire log using dsjob -logdetail to a file and then compress those files. Set AutoPurge option accordingly.

Welcome Aboard DBA
Does any job work with a transformer in it? Seems like the c++ compiler is not able to respond to the transformer. Double check the APT_LINKER and APT_COMPILER environment variables and assure that they are properly set.