Read Packed unsigned fields

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
ahmedwaseem2000
Premium Member
Premium Member
Posts: 145
Joined: Fri Sep 15, 2006 12:23 pm

Read Packed unsigned fields

Post by ahmedwaseem2000 »

Hi,

I am trying to read packed unsigned fields. do you know how do I do that? because packed fields are always have a signed nibble appended to it and in complex flat file when I try to remove the signed = ? then it doesnt read.

thanks for you help!!
munch9
Premium Member
Premium Member
Posts: 34
Joined: Fri Sep 15, 2006 7:26 am

Post by munch9 »

What is the source of these fields?

From an IBM system, even if a field is defined as unsigned there is still a trailing nibble (typicaly x'F') where the sign would normally be.

Removing 'signed=?' works ok for these fields, are you saying that there is no sign/placeholder nibble at all?
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

If its a mainframe file , ask for COBOL definition and import the same .
Nag
Post Reply