Search found 42 matches

by Jagan617
Wed Sep 10, 2008 9:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is it possible to overwrite the values of job parameters
Replies: 4
Views: 2803

Is it possible to overwrite the values of job parameters

Is it possible to overwrite the values of job parameters thru the job. Can any one assist me on this.
by Jagan617
Wed Sep 10, 2008 9:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to pass values to environmental variables thru job
Replies: 4
Views: 1569

How to pass values to environmental variables thru job

I want to pass the values to the environmental variables in the server job. Can you pls assist me on this
by Jagan617
Tue Jul 08, 2008 9:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need to include sysdate into the file name
Replies: 2
Views: 1032

need to include sysdate into the file name



Actually i am ftping the file from the upstreams to ETL server, in the ETL server i need to keep the filename as TCyyyymmdd.txt where YYYYMMDD is the current date.

Can anyone assist me in this.
by Jagan617
Mon Jun 23, 2008 8:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is stored proceedure stage works in oracle 10G also?
Replies: 2
Views: 1295

Is stored proceedure stage works in oracle 10G also?

We are upgrading the oracle 8i to 10g database. In the jobs we are using stored proceedure stage. Will the same stage works for 10g also without changing.

Can any one confirm this.
by Jagan617
Mon Jun 23, 2008 8:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to convert varchar to Date
Replies: 3
Views: 1549

How to convert varchar to Date

I am getting varchar from source and i need to convert it to date? Can anyone assist me
by Jagan617
Sat Jun 14, 2008 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "oracle datatype not presently supported".
Replies: 5
Views: 2163

I cann't change the datatype, its coming from source itself.
Whats the alternative for this in datastage 7.5.1A?
by Jagan617
Sat Jun 14, 2008 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "oracle datatype not presently supported".
Replies: 5
Views: 2163

I cann't change the datatype, its coming from source itself.
Whats the alternative for this in datastage 7.5.1A?
by Jagan617
Fri Jun 13, 2008 11:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "oracle datatype not presently supported".
Replies: 5
Views: 2163

"oracle datatype not presently supported".

when accessing the oracle table which has column defined as BLOB datatype through oracle 8 stage in datastage 7.5.1A, i am getting the error
"oracle datatype not presently supported".

Pls can anyone help me in this.