DSXchange

This is the best option :

Str("0",8-len(Column):Column

Use a len(Str,"0" with column)

anbu wrote:Check this post
http://dsxchange.com/viewtopic.php?t=130570

Thansk Anbu

Hi All,

Can anyone suggest a process to find out all the job names which refer to a particular hash file say "ABC" . This hash file is being used as a lookup in various jobs.

Its in datastage 7.5 server edition.

Appreciate your help

thanks duke.....

since i will be getting 1 to 3 rows per transaction ........and if 1 row loads in the 1st database table and while loading the second row in the seconds database table the job is getting aborted resulting the nullfying the rollback function

Chulett....in the server job ODBC stage we have Read Uncommitted Read committed repeatable read serializable versioning auto commit if i am not if i specify "0" for read commit the rollback feature should work but being multiple stages used ...how can i solve my prob. even it is a server o...

oh ya i just came to work..... "You could blow out your rollback segment in the database. I thought if the transaction size was 0 then it commits all or nothing. You could also commit one row at a time. That may solve your problem." do you mean this would work for me if i work on server jobs

Thanks for all your responses....

If it is in the case of server jobs...can anyone guide me how to do that....

we have to use only parallel jobs....

Thanks Chulet.....I am a bit confused how to manage this in PX jobs

Is there way where i can write a script to roll back if the jobstatus code is aborted?

Hi, I have designed a DS job where i will be inserting /updating data into 6 different tables. Since being a webservice i have to develop the service as one single job. The problem i am having is if the job gets aborted ....few of the initial tables are being inserted with some data...instead since ...

yup even i feel that.....anyways thanks for the confirmation

Hi All,

Just curious if we can deploy a sequence of jobs as a webservice?

Ray/Chulett i guess you guys have an answer for this

Hi,

I am get a fatal error when i am deploying DS job as a service. The job get aborted as SIGNT error. Not sure why it is getting aborted... The DS job runs fine as a job but when deployed a s a service it get SIGNIT error n aborts.

Appreciate all your help.

Thanks

Sorry forgot to mention i am using the odbc stages