Search found 5168 matches

by kumar_s
Thu Apr 06, 2006 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Precision and scale problem
Replies: 3
Views: 973

Yes decimal can be converted to float.
If your input are all with the same pattern, input could also be read as decimal.
by kumar_s
Thu Apr 06, 2006 12:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: extracting a zip file from a job
Replies: 14
Views: 3255

So rather than beliveing in Datastge, you may start writing your own logic using routine or any bat file to wait for file and extract the same.
by kumar_s
Thu Apr 06, 2006 12:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: set to defaults in sequential file stage
Replies: 5
Views: 1074

Why cant you read the column as decimal and apply column defaults as 0s.
by kumar_s
Thu Apr 06, 2006 12:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I get the full /path/project list?
Replies: 9
Views: 2300

The same will be displayed in adminstrator client.
If you select a project from Projects tab, bottom of the client will show you the Project pathname.
by kumar_s
Tue Apr 04, 2006 10:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read only project?
Replies: 6
Views: 1426

Again you can search for key work READONLY, DS_JOBS, DS_OBJECTS to get more commands.
One of the method would be

Code: Select all

UPDATE DS_JOBOBJECTS SET READONLY = 'NRO' WHERE READONLY = 'RO'
by kumar_s
Tue Apr 04, 2006 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Routines
Replies: 13
Views: 2476

May I know how you use this basic routine in your PX jobs :shock:
by kumar_s
Tue Apr 04, 2006 9:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Problem with Multi Instance Jobs
Replies: 6
Views: 1839

You administrator may use

Code: Select all

chdev -l sys0 -a maxuproc='nnn'
command to increase the max number of process per id.
by kumar_s
Tue Apr 04, 2006 9:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Problem with Multi Instance Jobs
Replies: 6
Views: 1839

Try to execute the jobs with two or more different userid parallely. If this goes, you need to alter your default settings.
by kumar_s
Tue Apr 04, 2006 8:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Timezone Conversion
Replies: 8
Views: 5876

If you search for the same in the forum, you may get some informations like using Basic routine or TZ environmental variable from unix.
The first option may not be usefule for your case, since you need to work out record wise. Perhaps you can try for the second approach.
by kumar_s
Tue Apr 04, 2006 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Problem with Multi Instance Jobs
Replies: 6
Views: 1839

There are limitation for max number of processors involved for each user in Unix. You can speak to you admin to increase the value.
by kumar_s
Tue Apr 04, 2006 8:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance on Job Design
Replies: 5
Views: 1176

Number of process involved in 3 different job Sequence calling 3 different jobs at the same time is more that single Job Sequence calling 3 jobs.
by kumar_s
Tue Apr 04, 2006 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Timezone Conversion
Replies: 8
Views: 5876

By saying Converting from one timestamp to another, do you mean updating set of records from old file to a new file with a updated timestamp?
by kumar_s
Tue Apr 04, 2006 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Operations in Parallel routine
Replies: 9
Views: 2106

It may not be directly possible using single lookup stage. But by knowing you exact requirement, like what sort of data is to be looked up, what are the ranges of the discretion of data... the lookup table can be loaded with some manipulation so that a single column can be maintained to lookup. Else...
by kumar_s
Tue Apr 04, 2006 8:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding sequence restarting
Replies: 8
Views: 2484

Yes, if 'Add checkpoints so sequence is restartable on failure' is selected and if BaseSeq1 as execution mode as 'Run' and the jobs with 'Reset if required and rerun' should work.
by kumar_s
Tue Apr 04, 2006 6:06 am
Forum: Site/Forum
Topic: Do we need a General Forum?
Replies: 13
Views: 6610

I agree to JobSequence.