Search found 5168 matches

by kumar_s
Fri May 05, 2006 3:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to skip the 1st two lines of a CSV file, then start read
Replies: 4
Views: 3611

Not sure you can find the SKIP option in sequential stage, but you can find this option in HEAD stage which is available in Development/Debug category in the Pallet. If you want to skip first two rows, use the filter option in the sequential stage or before job subroutine to use the tail +3 <filenam...
by kumar_s
Mon May 01, 2006 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delete object
Replies: 3
Views: 1290

That a the solution. Perhaps you could posted the full log. If the complain is about DS_JOBS, you could check whether the entry in the DS_JOBS by SELECT * FROM DS_JOBS WHERE NAME LIKE '%job name%' . And if you find the entry, make sure it is pointing to the same category as you expected. There may b...
by kumar_s
Mon May 01, 2006 6:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running PX on windows
Replies: 9
Views: 3126

PX can be installed on Windows with the all the prerequisetes intalled like C++ compiler.
Let us know what is the error you get while abort?
by kumar_s
Mon May 01, 2006 6:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer not in MVS
Replies: 7
Views: 1489

Not sure about MVS, so perhaps you can wait till a better suggestion. But you should be able to call batch jobs to trigger execute the conditional check.
by kumar_s
Wed Apr 26, 2006 5:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About INROWNUM Variable
Replies: 4
Views: 1212

Even the data is not well partioned, the ROWNUM will give the number of row passed in/out of the partiton. So there shouldnt be any gaps if you considire altogether.
by kumar_s
Wed Apr 26, 2006 4:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Certification Pass Score
Replies: 18
Views: 5581

But Pavan is not Ray :lol:
by kumar_s
Wed Apr 26, 2006 4:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No color change in link
Replies: 13
Views: 4087

Make sure the setting in adminstrator is turned on.
Parallel ---> Reporting ---> APT_NO_JOBMON --> FALSE
by kumar_s
Wed Apr 26, 2006 4:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About INROWNUM Variable
Replies: 4
Views: 1212

What exactly you need to get?
@PARTITIONNUM will give the partition number for the particular instance.
by kumar_s
Wed Apr 26, 2006 4:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IDOC Segment
Replies: 3
Views: 897

Check for null using IsNull() and get substring of the S.
by kumar_s
Tue Apr 25, 2006 6:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Terminating abruptly and getting locked
Replies: 21
Views: 4892

Welcome Aboard :D
For running a job, it is not necessary to be opened in a Designer. And if it is accessed by director, it should not get locked if closed abruptly. For clearing the lock you use Cleanup Resource. And first try to find why the session getting closed.
by kumar_s
Tue Apr 25, 2006 12:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running job in control M
Replies: 16
Views: 17532

Restratability may be taken care by Job Sequence, where as there are some points like %CPU usage at a point of instance and I/O rate... which need to be taken care during configuring in ^M
by kumar_s
Tue Apr 25, 2006 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: QUERY UNIVERSE DATABASE
Replies: 18
Views: 7773

Already mentioned.
To get the informations about the jobs query DS_JOBS.
To get the metadate of this file use LIST DICT DS_JOBS.
by kumar_s
Tue Apr 25, 2006 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: connect failed --Oracle error: -2127
Replies: 9
Views: 4728

Are the environmental varialbe SID and USER been defiend in the new environment?
by kumar_s
Fri Apr 21, 2006 4:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The job is not running when i extract data from oracle 10G
Replies: 5
Views: 989

Is both server and parallel edition runs on same OS?
dsenv is not for windows.