Search found 262 matches

by pavan_test
Mon Feb 22, 2010 9:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer stage function
Replies: 9
Views: 4105

Transformer stage function

I am reading a file in a single variable (longvarchar) in my job with a sequential file stage as my source. the problem is, I do not know how many columns will be there in the input file but the columns are separated by pipe | minimum number of columns in the file can be 19 and maximum 25. After I r...
by pavan_test
Thu Feb 11, 2010 9:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage silently dropping records.
Replies: 9
Views: 13432

Talk to your unix admin. This can also happen if your network has switch port issues.
by pavan_test
Wed Feb 10, 2010 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove duplicate stage warning
Replies: 5
Views: 3084

remove duplicate stage warning

I am getting this warning message from remove duplicate stage.

When checking operator: Operator of type "APT_TSortOperator": will partition despite the preserve-partitioning flag on the data set on input port 0.

can someone please suggest me how do I get rid of this message.

Thanks
Mark
by pavan_test
Mon Feb 08, 2010 2:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file stage warning
Replies: 2
Views: 1379

Re: sequential file stage warning

I Selected the option "Clear" in "Preserver Partitioning" in my previous stage and it worked.
by pavan_test
Mon Feb 08, 2010 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential file stage warning
Replies: 2
Views: 1379

sequential file stage warning

I have a job with a sequential file stage as target. the job completes successfully but i see this warning in the job log. Seq_File_1: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. How do I get rid of this warning. Thanks Mark
by pavan_test
Mon Feb 08, 2010 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify stage warning
Replies: 2
Views: 1463

modify stage warning

When I convert from double to decimal (decimal_from_dfloat) i get this warning message. Modify_1: When checking operator: When binding output schema variable "outRec": When binding output interface field "XXX" to field "XXX": Conversion from source type "dfloat&quo...
by pavan_test
Thu Feb 04, 2010 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BigInt
Replies: 3
Views: 3113

BigInt

is it one of those datastage implicit conversions
by pavan_test
Thu Feb 04, 2010 12:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BigInt
Replies: 3
Views: 3113

BigInt

can someone please suggest me how do i convert double to BigInt in datastage 8.1

Thanks
Mark
by pavan_test
Thu Jan 28, 2010 2:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: web services error
Replies: 8
Views: 6256

web services error

Are you refering to datastage server or the webservices server where I get the information (they are 3rd party).

Thanks
Mark
by pavan_test
Thu Jan 28, 2010 1:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: web services error
Replies: 8
Views: 6256

web services error

I agree. I re-ran the job after changing login information and the job aborted with a different error message, bad username and password exception.


the server which is hosting the webservices itself is not up and running. whom do i contact to find out the server is not running.

Thanks
Mark
by pavan_test
Thu Jan 28, 2010 10:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: web services error
Replies: 8
Views: 6256

web services error

I am thinking this is a web services connectivity error. JOBNAME_XXX.Add_Call_Info_Tfm: DSD.StageRun Active stage starting, tracemode = 0. JOBNAME_XXX.WS_Make_Call_Tfm: DSD.INTOpen Active stage starting, tracemode = 0. JOBNAME_XXX.Receive_Response_Tfm: DSD.INTOpen Active stage starting, tracemode = ...
by pavan_test
Thu Jan 28, 2010 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: web services error
Replies: 8
Views: 6256

web services error

Hi All, I have a etl job calling web service from datastage 8.1. when i try to run this job it is aborting due to JObNAME_XXX.WS_Make_Call_Tfm: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope...