Dataset column limit

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Dataset column limit

Post by keshav0307 »

just wondering if there is any limit for number of columns for dataset.

i am getting the below error, when i have 49 columns
Contents of phantom output file =>
RT_SC89/OshExecuter.sh: line 20: 26692 Segmentation fault $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1

and when i have 40 columns it runs fine.
Nageshsunkoji
Participant
Posts: 222
Joined: Tue Aug 30, 2005 2:07 am
Location: pune
Contact:

Post by Nageshsunkoji »

Hi Keshav,

I dont think so , it is a problem with Dataset. In our project we have 200 columns in different datasets.Its running smoothly.Check the environment varibales if any to get the ORCHHOME limitation in your project level, override the default values.

Regards
Nagesh
NageshSunkoji

If you know anything SHARE it.............
If you Don't know anything LEARN it...............
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Sounds like something in column 41 through 49. Perhaps trying to shoehorn N+1 characters into a Char(N) field?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply