DSXchange

Thanks Flash that makes me feel better but isn't it a good approach to do an upgrade rather than a re-install unless in my current position when there is no other go.

sAM

Afte a long day, i got to know from IBM support that my previous installation got "hosed" and they asked me to re-install with the new authorization codes. I had done the re-install and got my project re-imported back and in next few days i have to analyze the behaviour of the jobs on the ...

With the new license it is giving me another error message:
Dang!! IBM support is so lazy in response.

Thanks
sAM

Thanks Ray for the reply. I will perform upgrade with the new license and see how it goes.

Thanks
sAM

Thanks Ray for your reply.
I already opened an ecase with the support provider for new license but my query is " whether i will be able to connect and access the old projects after the installation/upgrade". It am not able to access it right now.

Hi Dxians, I had been upgrading DataStage 7.5.1.A version server installation and due to some acces issues with my login credentials after some time the upgrade process failed. Now when i tried again to upgrade the server the projects doesn't show up there, they seemed to be gone. I tried logging in...

Thanks for the response vincent but it had been resolved way back with the same solution you provided.

If a job is opened and left out then other users won't be able to access/open the same job. If i interpreted you question correctly.

Note: Delete the other post.

Try DecimaltoString() or StringfromDecimal() or DFloattoString().

I don't think there has to be any delimiter but try using brackets:

Yes, Pivot stage can be used in your scenario. Do a search on "Pivot" to know the implemenation.

Yes Pivot stage can be used in your scenario. Do a search on "Pivot" to know the implemenation.

Yes, Long is not supported but as an work-around use varchar with a bigger size.

Try the %year_cutoffyy option while converting instead of just %yy.

I got it. Thanks