|
View previous topic :: View next topic
|
| Author |
Message |
bhaskar_kanteti
Active User
Joined: 01 Feb 2007
Posts: 123
Location: Hyderabad
|
|
|
|
Hi,
I am unloading data from a table. If a particular field is not found in the table i need to default with zeroes or spaces.
How can i do this for Numeric, Alpha Numeric, Comp-3, Comp
I had given as follows
| Code: |
Select ABC,
DEF,
XYZ,
CHAR( ),
FLOAT( )
From TABLE1;
|
But copybook length is not matching.
How to defalut the fields.
Thanks in advance. |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| bhaskar_kanteti wrote: |
Hi,
I am unloading data from a table. If a particular field is not found in the table i need to default with zeroes or spaces.
How can i do this for Numeric, Alpha Numeric, Comp-3, Comp
I had given as follows
| Code: |
Select ABC,
DEF,
XYZ,
CHAR( ),
FLOAT( )
From TABLE1;
|
But copybook length is not matching.
How to defalut the fields.
Thanks in advance. |
Except for NULLABLE fields all the fields will have a value. Nullable fields will have a separate null indicator which will be x'ff' for a null field. |
|
| Back to top |
|
|
|
|
