Search found 258 matches

by samyamkrishna
Tue Mar 29, 2011 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchadmin command
Replies: 7
Views: 5207

1. Source the dsenv file.
2. you should complete file path like /temp/proj/chk.ds if you only give chk.ds the command will not work.
by samyamkrishna
Tue Mar 29, 2011 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display "$" in output file column name
Replies: 3
Views: 1801

Re: Display "$" in output file column name

This is probably because you cannot give $ as a column name. You can give teh column name as "AAAAAAAAA" then in the after job subroutine you can replace it with DENM_$5_A using Sed command sed -e "s/AAAAAAAAA/DENM_$5_A/ig" $file > /tmp/tempfile.tmp; mv /tmp/tempfile.tmp $file Th...
by samyamkrishna
Mon Mar 28, 2011 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP not working for Shared Container
Replies: 14
Views: 8978

The output of the Copy Stage is RCP enabled?
by samyamkrishna
Mon Mar 28, 2011 7:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is the sequence of calculating stage variable
Replies: 2
Views: 1805

Re: what is the sequence of calculating stage variable

Hi,

The sequence is from top to bottom.

First variable gets calculated first.
Then second ,
then third.
by samyamkrishna
Mon Mar 28, 2011 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can aggregator stage be of some help
Replies: 21
Views: 10867

This can be achived by what Ray suggested.
Fork Join.
by samyamkrishna
Tue Mar 22, 2011 5:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to validate data
Replies: 7
Views: 2427

Do you know what is the valid data or is there any requirement saying what exactly is valid data. Based on what the requirement is you have to do the validation.

So what exactly is Valid data for you?
by samyamkrishna
Tue Feb 22, 2011 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COBOL COPY BOOK
Replies: 2
Views: 1804

Thanks a lot Ray
by samyamkrishna
Tue Feb 22, 2011 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COBOL COPY BOOK
Replies: 2
Views: 1804

COBOL COPY BOOK

Hi, I have a source file which has teh following structure. PIC S9(16)V9(02). and PIC S9(04)V9(02). Its a fixed width file. I do not have a sample file. How should i read it. PIC S9(16)V9(02). should i read as inputcolumn[1,17] or inputcolumn[1,19] and S9(04)V9(02). should i read as inputcolumn[1,5]...
by samyamkrishna
Tue Feb 01, 2011 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FATAL Error in transformer
Replies: 8
Views: 5108

I executed teh job with a single node configuration. It aborted againg with the same error. I executed the transformer alone with a row generator. works fine. The tarnsfor which aborts, has a lot of substring functions. i am reading a complex file using a sequential filestage. teh complex file has 7...
by samyamkrishna
Tue Feb 01, 2011 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FATAL Error in transformer
Replies: 8
Views: 5108

Yes i checked out the other posts with teh similar error. I have set $DSIPC_OPEN_TIMEOUT = 680. The ulimit shows teh following. $ ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 4194304 memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descript...
by samyamkrishna
Mon Jan 31, 2011 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FATAL Error in transformer
Replies: 8
Views: 5108

FATAL Error in transformer

TrnsValidJE,0: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.

APT_TransformOperatorImplV214S0_NonZero0JB_TrnsValidJE in TrnsValidJE], partition 0 of 2, processID 2,478,262 on etlax006_01, player 77 terminated unexpectedly.


What should i be doing?
by samyamkrishna
Fri Jan 28, 2011 5:02 am
Forum: General
Topic: How to specify project in uvsh ?
Replies: 2
Views: 1709

Re: How to specify project in uvsh ?

after uvsh do LOGTO PROJ_NAME
Then you can run the DS_JOBS.CATEGORY.
by samyamkrishna
Tue Jan 18, 2011 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Set Error
Replies: 9
Views: 5263

Re: Data Set Error

have you given teh update policy as overwrite.