Search found 86 matches

by madhukar
Wed Aug 02, 2006 2:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job failed : Output file full, and no more output files
Replies: 5
Views: 12832

Re: job failed : Output file full, and no more output files

Hi,

Also there may be a mismatch b/w partiton key, sort key and join key....
which means records are kept in memory for long waiting for a matching record.
by madhukar
Fri Jun 16, 2006 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: re: occurs 0-200 times depending on clause in CFF stage
Replies: 2
Views: 1583

Re: re: occurs 0-200 times depending on clause in CFF stage

Hi panic,

indexed columns in cobol file is not supported by Datasate CFF.

Regs
madhukar
by madhukar
Fri Jan 13, 2006 5:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: passing parameter as group by key to agg.
Replies: 1
Views: 762

passing parameter as group by key to agg.

hi all,

i need to pass parameter value to agg grp by key.

it can done by using a transformer by a creating a column and
assigning parameter value to it.

any other way to get the same result?
by madhukar
Fri Jan 13, 2006 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Joining 2 Datasets using between logic??
Replies: 8
Views: 2573

Re: Joining 2 Datasets using between logic??

ray,

2 options available in lookup

1 lookup on key
2 other than lookup key match , what else condition it has to meet

for the above req, we can give the following expn in lookup condition.
EFFECTIVE_DATE >= BILL_ST and EFFECTIVE_DATE <= BILL_END
by madhukar
Fri Jan 13, 2006 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning in Funnel stage
Replies: 9
Views: 6302

Re: Warning in Funnel stage

u will get RCP option in output/columns page
by madhukar
Fri Jan 13, 2006 2:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Joining 2 Datasets using between logic??
Replies: 8
Views: 2573

Re: Joining 2 Datasets using between logic??

[quote="MarkStewart"]I've created the 1st data set where I've left the FIN_YEAR and FIN_MONTH columns blank. The EFFECTIVE_DATE has a date value on the same dataset. I've created a 2nd data set with FIN_YEAR, FIN_MONTH, BILL_ST, BILL_END. How do I join the two datasets? I need to get the F...
by madhukar
Mon Jan 09, 2006 6:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ~~~Warning in job~~~
Replies: 11
Views: 5912

chk the order of the keys in partition and the sort key are different...
by madhukar
Thu Sep 01, 2005 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COMPILATION ERROR
Replies: 3
Views: 1675

COMPILATION ERROR

hI all i AM GETTING THIS ERROR DURING COMPILATION, #E TFAV 000000 09:27:51(002) <transform> When processing argument -inputschemaWhen processing schema: schema contains a field "END_DT" that is a subrec or tagged; only top-level fields are accepted ANYBODY KNOW WHY? REDARDS. MADHU
by madhukar
Mon Aug 15, 2005 9:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Empty Data Set
Replies: 3
Views: 2083

Empty Data Set

hi all,

How to create empty data sets?
And how to clear the existing data in a dataset?

regs
Madhukar
by madhukar
Wed May 25, 2005 4:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: row to column
Replies: 4
Views: 2165

it is a plugin stage
by madhukar
Tue May 24, 2005 6:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: blank rows in the file
Replies: 6
Views: 2122

blank rows in the file

hi all
hw to identify and remove blank rows from the source file