Search found 6 matches

by routhu
Wed Sep 15, 2010 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date type conversion
Replies: 3
Views: 2355

chulett wrote:StringToDate() followed by DateToString() using an appropriate format mask in both cases. Don't have access to my reference materials but off the top of my pointy little head, %yyyy-%mmm-%dd and %yy-%mm-%dd respectively?

criag,

we can do the same using oconv and iconv functions too rite??
by routhu
Wed Sep 15, 2010 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 7.5x2 Installation on windows server 2003 R2
Replies: 7
Views: 3770

Than that's not the problem. Why not post your actual failure message, see what people can tell from that? ... criag, this is the structure of my sample parallel job: Seq File--> transformer-->dataset when i try to compile the job,the following error message pop ups: Output from transformer compila...
by routhu
Tue Sep 14, 2010 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 7.5x2 Installation on windows server 2003 R2
Replies: 7
Views: 3770

chulett wrote:Typically, the later versions include the earlier versions, but you can go back and install 1.1 without hurting your 2.0 installation. ...
I have both versions of .NET framework installed(1.1 & 2.0) but still the parallel jobs are failing.

:?
by routhu
Tue Sep 14, 2010 12:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting string to date!!
Replies: 23
Views: 11629

Re: Converting string to date!!

hi vivek,

trying using OconV & IconV Functions in the transformer

something like ---- Oconv(Iconv("03/13/2010", "D/MDY[2,2,4]"), "D/YMD") in the transformer derivation ..
it should work.
by routhu
Tue Sep 14, 2010 11:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 7.5x2 Installation on windows server 2003 R2
Replies: 7
Views: 3770

You'd have to be a wee bit more specific regarding what the nature of your problem running a PX job is. hi chulett, I think i figured out the reason. the .NEt framework v1.1 is required for running a datastage parallel jobs on windows . I have .NET framework 2.0 installed . does it support ds?
by routhu
Tue Sep 14, 2010 9:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 7.5x2 Installation on windows server 2003 R2
Replies: 7
Views: 3770

Datastage 7.5x2 Installation on windows server 2003 R2

Hi All,

I installed Datastage 7.5x2 on windows server 2003 R2

I am able to install it and run a server job successsfully.

the problem here is could able to run a parallel job.

I installed microsoft.net framework along with it.

Can any one help me out with this issue?

thanks in advance.