I can't find PIC9(8) Data format. Give an idea

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

Post Reply
venugopal81
Participant
Posts: 49
Joined: Sat Mar 26, 2005 12:19 am

I can't find PIC9(8) Data format. Give an idea

Post by venugopal81 »

fieldname - invoice date
data-format - pic9(8)
length- 8

Given above is my data format. I want import my source definitions with

pic9(8) data format. Where we can find this data type.


thanks

venu
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

PIC 9(8) is COBOL notation for an eight digit numeric field. So, pick one of the numeric data types (Numeric, Decimal, Integer) and set the Length to 8.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

You have a cobol file defn. Import it used proper option of CFD. Otherwise, select number(8) or integer(8) scale 0.
Post Reply