Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 54
	Members: 0
	Total: 54

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Format Issues

1 Replies

0 Subscribed to this topic

19 Subscribed to this forum

Sort:

Author

Messages

Shasidhar Vemireddy

Basic Member

Posts: 14

10/23/2006 6:30 PM

I have a column that needs to be populated it is CHAR(17), i need to populate this fied with the EMPLOYEE number which is numeric (size 9). so when i try to move the value directly into the CHAR field the end result is something like this

"000002456 "..however i want soemthing like this
"2465 ".I tried various formatting options including lawson API's with no good result.Does anyone have a suggestion ?

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

10/23/2006 10:08 PM

You can do it yourself with COBOL code; it's a two-step process. First move the employee number to a numeric-edited field [i.e. PIC Z(9)]. Then use a loop to move character-by-character thru an alphanumeric field that redefines the edited field.

You can also look at the 5000-HREMP-FORMAT-FIELD API from HREMPFMT.