Search found 200 matches

by dnat
Wed Nov 14, 2007 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC table definition issue
Replies: 5
Views: 1530

ODBC table definition issue

We imported a table definition of a table through ODBC. When we changed the column width for one table and tried to import it again with the same name(i.e replaced the table definition), the length of the column did not change.It shows the same definition as it had earlier. We tried many times, but ...
by dnat
Mon Sep 24, 2007 5:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: double quote in sequential file
Replies: 3
Views: 1492

i have declared it as varchar. The record is getting rejected in the Sequential file stage itself. It is not even passing to the next stage.
by dnat
Mon Sep 24, 2007 4:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: double quote in sequential file
Replies: 3
Views: 1492

double quote in sequential file

I have a a Sequential file where the records are delimited by comma(,) and double quote. There is a record like this in the data file:- "1111111","aa aa aa","""xxxxxx""","nnnnn" But when i read this record in the sequential file , it is get...
by dnat
Mon Sep 17, 2007 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer logic
Replies: 3
Views: 1470

I have unchecked the option "Automatically handle activities that fail" and now the job is running even if the job activity fails and goes into the next loop.
by dnat
Mon Sep 17, 2007 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer logic
Replies: 3
Views: 1470

Sequencer logic

Hi, I have to run a sequencer for a set of files in a loop. So, i have the sequencer like this:- Main sequencer:- Start loop-->Job activity 1-->Job activity 2-->End loop This sequencer loops for every file until all the files are processed. Job activity 1 is a Job sequence which processes the data. ...