Search found 17 matches

by naidu
Tue Nov 03, 2009 9:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error msg
Replies: 7
Views: 4448

Error msg

Hi all I have migrated the job from 7.5 version to 8.1 version and the job runs fine in 7.5 but when i am trying to run the job in 8.1 it shows the following error message. Can any one help me to resolve this error message, below is the error message TRN_Sales_Check,3: Job aborting due to row limit ...
by naidu
Fri Oct 30, 2009 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 4
Views: 2362

chulett wrote:As noted many times here, 8.x does more stringent checking on things like this. Post your data and syntax, you'll need to correct it to avoid that warning. ...
what do you mean by data and syntax
i am CFF stage as source and generating 23 Sequential files so please tell me what data you want.
by naidu
Thu Oct 29, 2009 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 4
Views: 2362

Conversion error

Hi all I am trying to run all the jobs in 8.1 version which are developed in 7.5 version and i am getting this warning message and when i run the same job in 7.5 i am not getting any messages so can any one help out how to get rid of this warning TRN_Map2,0: Conversion error calling conversion routi...
by naidu
Wed Oct 28, 2009 11:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion warning message
Replies: 3
Views: 2184

ray.wurlod wrote:All calculation inside the Aggregator stage are performed as dfloat. Your design specifies an output column as integer data type. This generates the alert messages, because not all dfloat numbers ca ...
Thanks for your reply and what should i do to remove this warning
by naidu
Wed Oct 28, 2009 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion warning message
Replies: 3
Views: 2184

Conversion warning message

Hi all I am getting this warning message and i don't know about "dfloat" can any one help me to remove this warning message. I have migrated this job from 7.5 version to 8.1 version it works fine in 7.5 version no warning messages but in 8.5 it shows the warning message. Below is the warni...
by naidu
Wed Oct 28, 2009 9:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Geting warning's in decimal conversion
Replies: 11
Views: 4279

chulett wrote:Not necessarily the wisest choice. Any chance you could answer my last question? ...
Yeah Craig my source Decimal[38,1] and your target is Decimal[7,1]
by naidu
Wed Oct 28, 2009 8:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Geting warning's in decimal conversion
Replies: 11
Views: 4279

You can check if the particular warning is downgraded to information or suppressed from log on 7.5 V. If it is the case then you can do the same in 8V. The mentioned activity is done on director. not sure whether it will get migrated when upgraded from one to other. Thanks i am suppressing all the ...
by naidu
Tue Oct 27, 2009 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Geting warning's in decimal conversion
Replies: 11
Views: 4279

So there is nuthing i can do to avoid these warnings
by naidu
Mon Oct 26, 2009 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Geting warning's in decimal conversion
Replies: 11
Views: 4279

Thanks for the reply i jus want to tell more details about the job the source is oracle stage and the targets are oracle and CFF stages and the job is migrated from 7.5v to 8.1v and it is running fine without any warnings in 7.5v and why does it shows warning messages in 8.1 could you please help me...
by naidu
Mon Oct 26, 2009 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing V8.1 in UNIX Server
Replies: 2
Views: 1455

Installing V8.1 in UNIX Server

Hi
Can any one explain the steps to install v8.1 in a UNIX server
by naidu
Mon Oct 26, 2009 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Geting warning's in decimal conversion
Replies: 11
Views: 4279

Geting warning's in decimal conversion

Hi All I am getting this warning can any one tell me how can i get rid of this warning " ORCL_Src_OFOEtl: When checking operator: When binding output interface field "DESEASONALIZED_FCST" to field "DESEASONALIZED_FCST": Implicit conversion from source type "decimal[38,1...
by naidu
Wed Oct 21, 2009 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 5
Views: 3394

We had this same problem, there is a client side patch you need to install (assuming it is exactly the same issue) patch_JR31443v2_client_windows_81.zip patch_JR31443v2_clientupdater_windows_8100.zip Although best to contact support to confirm there isn't a more recent roll-up patch resolving this ...
by naidu
Mon Oct 19, 2009 7:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 4
Views: 2662

Hi Craig Hulett
I still didn't get any solution for my error and i want to explain my error clearly and more over i am new to this forum so posted it again.
by naidu
Sun Oct 18, 2009 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 5
Views: 3394

It is clear that your actual data format and metadata don't match. Start off with the first field, what is it called, what is the PIC clause for it and have you used a binary or similar editor to compare the actual file contents with your picture clause? Hi Thanks for your reply my actual data form...
by naidu
Sun Oct 18, 2009 4:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex flat file
Replies: 4
Views: 2662

Complex flat file

Hi We have moved all the jobs from 7.5 version to 8.1 version and when i am trying to view the data in CFF (Complex Flat File) stage it shows the following error Error: - <Complex_Flat_File_12> Formatted length of fields and record (0) less than declared length (164) >##E IIS-DSEE-TOPK-00007 16:59:4...