|
View previous topic :: View next topic
|
| Author |
Message |
neelus.s
New User
Joined: 05 Apr 2007
Posts: 4
Location: Minneapolis
|
|
|
|
Hi All,
I have two fields in a PS file which are alphnumeric.
The data in these 2 fields have to be loaded into a DB2 table. The datatype of these 2 fields in the DB2 table is FLOAT.
This conversion have to be done in a COBOL program as per the requirement.
Sample data:
Field-1 : 48.67634567 (There is a space after this data in the file which indicates it as a positive field)
Field-2: -67.78897678
Pleas help me
Regards,
Neelima |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
Convert the number to a numeric and load it.
Look at the NUMVAL intrinsic. |
|
| Back to top |
|
|
prasadvrk
Active User
Joined: 31 May 2006
Posts: 200
Location: Netherlands
|
|
|
|
| Have you created DCLGEN for this table. I you did then it will declare the variable as equivalent COBOL variable. Move the alphanumeric field in to the COBOL variable and load the table. |
|
| Back to top |
|
|
|
|
