Search found 2 matches

by mahindru
Tue Sep 13, 2005 11:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading Parameters From Database directly
Replies: 14
Views: 14880

Re: Reading Parameters From Database directly

Here is one solution that I am using 1. Create a Unix script to select all the necessary parameter values from the database and store them in the unix variables in that script. Unix_Variable=`sqlplus -silent user/passwd <<END set pagesize 0 linesize 170 feedback off verify off heading off echo off s...
by mahindru
Mon Jul 25, 2005 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: only one proces returns rows from partitioned table
Replies: 1
Views: 1108

Re: only one proces returns rows from partitioned table

Hi, I'm selecting data from an oracle stage(one table). When selecting without the partition table option (so with one process) I get 2000000 records back (all records from table) . When I put the partition option and take a 16-node configfile It only returns 160000 records and stops without error....