Search found 29 matches

by hemanthakumar
Thu Jan 29, 2009 12:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which version of datastage (parallel job) is support.....
Replies: 4
Views: 2262

Hi,
Datastage7.5x2 support the windows platform (windows xp , professional) to install on your local pc .
by hemanthakumar
Thu Jan 29, 2009 12:05 am
Forum: General
Topic: capture duplicate data
Replies: 8
Views: 3450

Hi, Use the following stages. Source----Aggregator----Transformer----Tgt1 | | Tgt2 In Aggregator group by id,count(id) then for Transaformer stage take targets then in Constraint write count > 1 to Tgt1, otherwise for Tgt2.It will work.
by hemanthakumar
Wed Jan 28, 2009 1:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re:Run the jobs through command line
Replies: 3
Views: 1016

Hi ray,
Thanks for the reply,I wii check in forum.
by hemanthakumar
Wed Jan 28, 2009 12:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re:Run the jobs through command line
Replies: 3
Views: 1016

Re:Run the jobs through command line

Hi All,
How to Run the jobs through command line.
by hemanthakumar
Fri Jan 02, 2009 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: preserve partitioning
Replies: 3
Views: 1734

hi,
In which stage you are getting this warning ?
by hemanthakumar
Mon Dec 08, 2008 3:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in FTP unix script
Replies: 5
Views: 4533

Hi,
To transfer file from one server to another server use coreftp software,this is userfriendly.For this software download from google.
by hemanthakumar
Mon Dec 08, 2008 3:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Last calender date
Replies: 8
Views: 5140

Last Calender Date

Hi Sateesh,
For last month last date use this follwing logic:
DateFromJulianDay(JulianDayFromDate(CurrentDate()) - CurrentDate() [9,2])
by hemanthakumar
Wed Oct 29, 2008 3:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error while importing a job
Replies: 7
Views: 4231

if u restart the server then the deadlock cleared,then u can import the job first try to kill the pid in unix for that job last preference is to restart the server.
by hemanthakumar
Wed Oct 29, 2008 3:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Character warnig in datastage
Replies: 4
Views: 6693

try with UTF-8 IN NLS setting in each stage.
by hemanthakumar
Wed Oct 29, 2008 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: timeout while waiting for an event
Replies: 1
Views: 1658

timeout while waiting for an event

hi everybody,
while running the sequence job iam getting the follwing problem " Controller problem: Error calling DSRunJob(RFPEDW032_08), code=-14
[Timed out while waiting for an event]"let me know any solution for this problem.

Thanks
hemanth
by hemanthakumar
Mon Aug 04, 2008 9:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage PX Warning: Import consumed only 27bytes of the re
Replies: 5
Views: 4894

Datastage PX Warning: Import consumed only 27bytes of the re

Hi,
My source is sequential file .txt formate,while loading to the target sequential file iam getting some contol characters in source file.How to remove the control characters in source sequential file.
by hemanthakumar
Wed Jul 23, 2008 9:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage PX Warning:
Replies: 7
Views: 2544

Datastage PX Warning:

Hi All, My source is sequentialfile in this file the Column Name is CityName,Datatype is char and it is Null field.While loading to target(Sequentialfile) iam getting the following warning: When checking operator: When validating export schema: At field "CityName": Exporting nullable field...
by hemanthakumar
Tue Jul 08, 2008 3:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage PX Warning
Replies: 3
Views: 978

Datastage PX Warning

When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.
by hemanthakumar
Wed May 07, 2008 4:36 am
Forum: IBM QualityStage
Topic: Datastage
Replies: 1
Views: 1242

Datastage

Iam facing this type of error to view the data in DB2.So any idea about this please reply to me



##F IIS-DSEE-TNDB-00228 14:27:37(000)<maim_program> Fatal Error:
APT_DB2Utils::dbversion:unrecognized version string:'DSN08015'.