Search found 177 matches

by kamalshil
Thu Jan 22, 2015 12:53 pm
Forum: General
Topic: Auto-purge of jobs not happening correctly
Replies: 2
Views: 2026

Auto-purge of jobs not happening correctly

Hi We have recently migrated from DS 8.5 to DS 8.7 We have multiple multi-instance jobs running in parallel. Till now in DS 8.5 we had setting to keep only log older than 2 days. Which was achieved by setting a property in using Administrator - > logs -> older than (days) -> set to 2. Now we did the...
by kamalshil
Thu May 22, 2014 9:46 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD stages license requirnment
Replies: 6
Views: 8493

Hi,
Yes "use" word I used for deploying the DS job as a web service.
by kamalshil
Thu May 22, 2014 9:45 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD stages license requirnment
Replies: 6
Views: 8493

Hi,
Thanks for the reply. I was looking for this information.
by kamalshil
Wed May 21, 2014 12:48 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD stages license requirnment
Replies: 6
Views: 8493

ISD stages license requirnment

Hi, We are trying to use a DS job as web service. where as there I have came across some steps in documents . When I am following them I am not able to create an Information services project using the "IBM InfoSphere Information Server Console" I have logged in as root access but still see...
by kamalshil
Wed Jan 16, 2013 2:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass input column values on output link on MQ Connector
Replies: 5
Views: 4260

Thanks for information.
I have already this that by concatenate and write to final input.
Is there a way we can pass through few input columns on the output link??
by kamalshil
Tue Jan 15, 2013 5:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass input column values on output link on MQ Connector
Replies: 5
Views: 4260

One additional Info:
Send 4 columns on the input link of the MQ connector stage.
Only 1st Column got written to the Queue remaining all 3 columns got discarded.
by kamalshil
Mon Jan 14, 2013 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass input column values on output link on MQ Connector
Replies: 5
Views: 4260

Example of columns :

Code: Select all

Column A - Goes to Queue
Column B - Pass through on the output link
Column C - Pass through on the output link
by kamalshil
Fri Jan 11, 2013 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass input column values on output link on MQ Connector
Replies: 5
Views: 4260

Pass input column values on output link on MQ Connector

Hi, I am using MQ Connector Stage for writing a XML Message which I am generating from XML output stage. My requirement is write the generated XML to Queue. And Read the output message received on the reply queue on the output link on th MQ connector stage. Till this scenario its working fine. Now 2...
by kamalshil
Tue Jan 31, 2012 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector issue in migration
Replies: 2
Views: 5140

Oracle Connector issue in migration

Hi, We are developing the jobs in a project using the oracle connector stage in 8.5. And associating it with the Database connection set. It works fine in the development environment. But when we migrate it to another environment or new project we compile & run. While running we are getting the ...
by kamalshil
Wed Dec 15, 2010 4:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing timestamp as parameter.
Replies: 5
Views: 4026

Passed as string as the format expected by the database
by kamalshil
Mon Sep 13, 2010 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort because of Index in diffrent Environment
Replies: 4
Views: 2959

Yes as my target table has no index.
so there is no need to use index option to add index or drop index.
by kamalshil
Mon Sep 13, 2010 3:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abort because of Index in diffrent Environment
Replies: 4
Views: 2959

Abort because of Index in diffrent Environment

Hi, I am using oracle enterprise stage for loading the table. Write method is 'Load'. write mode is 'Truncate'. And target table has no index. In our dev environment and testing its running fine. But when we put this code in different environment its giving below abort message. Indexes on table 'TMP...
by kamalshil
Mon Aug 30, 2010 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To read input file dynamically
Replies: 1
Views: 1755

To read input file dynamically

Hi All, I have 5 input files which but with different structure. We need to read the input flow and write into output file. My question is we need to make this read of input file dynamically so that any time when required we will read only 10 columns or 5 columns and write into output file. And plan...
by kamalshil
Wed Jul 21, 2010 2:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Index rebuild failed
Replies: 4
Views: 4066

ArndW wrote:This is not a DataStage limitation, but a database one and thus cannot be solved by DataStage. ...
Thanks,
But parameter i need to take care at the database end to make this possible to work the Load method.

Or i have to use the upsert option.
by kamalshil
Wed Jul 21, 2010 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Index rebuild failed
Replies: 4
Views: 4066

Index rebuild failed

Hi all, My table is partitioned. And when i am trying to load the table with the load option. And Index Mode = rebuild. I am getting below fatal error: Ora_load: The -index rebuild option may not be used on a partitioned index; table 'TABLENAME' contains one or more partitioned indexes. What has to ...