Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
parvathi
Participant
Posts: 103 Joined: Wed Jul 05, 2006 4:48 am
Contact:
Post
by parvathi » Tue Dec 05, 2006 3:10 am
Hi all
while importing the meta data of the table in an oracle stage
the length of my column is 22 and under display it is shown as 24.
what actually display column will do and its importance and what is dataelement
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Dec 05, 2006 3:44 am
What data type, what precision?
For example, NUMBER(22,2) needs one place for the decimal place and one for the sign. Total 24.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
parvathi
Participant
Posts: 103 Joined: Wed Jul 05, 2006 4:48 am
Contact:
Post
by parvathi » Tue Dec 05, 2006 4:02 am
The datatype is number 22 in oracle
but i didnot mention the precision
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Dec 05, 2006 5:21 am
In that case precision is 0.
"-2837213623238928331187." contains 24 characters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
parvathi
Participant
Posts: 103 Joined: Wed Jul 05, 2006 4:48 am
Contact:
Post
by parvathi » Tue Dec 05, 2006 5:55 am
THANKS
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 05, 2006 8:40 am
parvathi wrote: what actually display column will do and its importance
To actually answer your question - It controls the initial width of the column in the data grid when you View Data... nothing more, nothing less.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Dec 05, 2006 6:50 pm
But wait! There's more!
It (Display Width) also controls the column width if you write to (or read from) a fixed-width sequential file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 05, 2006 6:51 pm
Not in the
Oracle stage, which was the specific question I was answering.
-craig
"You can never have too many knives" -- Logan Nine Fingers