Search found 92 matches

by ambasta
Fri Feb 16, 2007 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate Identifier
Replies: 5
Views: 2890

hi Ambasta, Check if column propagation function is activated ! You maybe have it and declare another field with same name ? If not, check your look up or other additional flow stages to see if another column has same name. Thanks a lot Loubi. In one of the system RCP was enabled.i made it disable....
by ambasta
Fri Feb 16, 2007 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate Identifier
Replies: 5
Views: 2890

Duplicate Identifier

I am getting the following error at run time.. "main_program: Fatal Error: Added field has duplicate identifier(): "... Same job is working in other servers..I tested the job in three different environment.it is running fine in two,but job is aborting in one of the server.. Can anyone plea...
by ambasta
Tue Dec 26, 2006 5:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix giving Error while extracting records from SAP
Replies: 3
Views: 1614

Unix giving Error while extracting records from SAP

Hi Friends, Am getting error like, EXT_V_IBIN_SYVAL,0: Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:161] While extracting from SAP -Job gets aborted after passing 40 lacs record -My Source is = SAP nearly 1 crore records -Target = Sequential file -OS = Unix Kindl...
by ambasta
Thu Nov 02, 2006 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to split one record into several records
Replies: 11
Views: 3893

Thanks Ray,
Can you please elaborate... how to do that in transformer stage??I am having very urgent requirement.can you please help me??

Thanks
by ambasta
Thu Nov 02, 2006 12:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to split one record into several records
Replies: 11
Views: 3893

Thanks Shantanu for your precious Input.but i cannot use server job and in Parallel job there is no Basic Transformer.
by ambasta
Thu Nov 02, 2006 10:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to split one record into several records
Replies: 11
Views: 3893

Thanks Ray,
I cannot create any additional column.what i need to do is...split one record and populate it as several records.I am not aware of pivot stage.can you plz explaim me a bit...

Thanks.
by ambasta
Thu Nov 02, 2006 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to split one record into several records
Replies: 11
Views: 3893

How to split one record into several records

Hi All, I am writing from dataset to Oracle.From Dataset Col.A[char(20)] and Col.B[char(30)] is coming.I need to populate Col.X using Col.A and col.B,but Col.X is having datatype as Char(2) only.Logic is... if Col.B is having data of more than 2 character then populate 2-2 char one by one.It is diff...
by ambasta
Wed Nov 01, 2006 9:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP extract
Replies: 3
Views: 2036

Hi Rick, Some time it happens.what i can suggets you is..try to generate the program from scratch.i think it will help you ....sometime while generating the problem ...parsing is not happening properly or program encounters some error and led to performance issue.Second thing i want to tell you is.....
by ambasta
Wed Nov 01, 2006 7:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP extract
Replies: 3
Views: 2036

Hi Rick, the problem can be huge amount of data.else as u specified you using too many ABAP[4] stages.this will also lead to performance issue.what i can suggest u is,....u can use function Module calling and hence reduce no. of Abap Stages.Try this or else can u plz elaborate u problem in some data...
by ambasta
Wed Nov 01, 2006 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while viewing data from OCI stage
Replies: 5
Views: 2351

Hi Kumar Its asking only table name,user and password and I supplied correct values for all the three. By the way I am working on 7.5x2 version on windows XP mohan Hi Mohan, apart from User name and Pwd you will also have to specify which server you want to connect,provided u r not having local sys...
by ambasta
Wed Nov 01, 2006 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: All objects in the Job become PLUG objects.
Replies: 9
Views: 4382

Hi Pankaj,
i also faced the same prob.that time some one suggested me to uninstall the client and again re install.i think this will also do for u???Just give a trial....or else if u got any input from DS guys!!plz let us know.
Thanks.
by ambasta
Wed Nov 01, 2006 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RE:string to date
Replies: 4
Views: 2675

while deriving the column at transformer stage u can use stringtodate function and also specify ur desired format.
by ambasta
Wed Nov 01, 2006 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process only last row
Replies: 5
Views: 2325

Hi, just before transformet u can use sort stage by sorting ascending.and again in next Aggregatator stage u can use max of the no to find out the greatest and i think i will definitely do for u.Please let us know ...did it worked???

Thanks
by ambasta
Mon Oct 30, 2006 6:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: adding column names to reject file
Replies: 15
Views: 4582

Hi all, sorry for replying so late. I dont have reject link from sequential file. Reject links are from stages like transformer, lookup. For one of my files I have 150 columns, so hardcoding the column names is difficult. Iam not reading from files which have column names, instead I am trying to wr...
by ambasta
Sat Oct 28, 2006 8:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: adding column names to reject file
Replies: 15
Views: 4582

Hi Ssunda, If i am getting your ques. right, then ...you are writing from File to File and at transformer you are taking one Reject Sequential file.what i can suggest you is...Hardcord the column name and then concatenate it with your data. If your Column is TRY the use "TRY":inputlink.col...