View previous topic :: View next topic
|
Author |
Message |
cooolguyin Warnings : 1 New User
Joined: 12 May 2005 Posts: 10 Location: NY
|
|
|
|
Hi,
I wanna read the alpha numeric field from adabas file under some condition thro' NATURAL program and write it to a flat file using batch job. How do I write it in lower case in the dataset?
..thanks |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
Take a look at user exit 620 (USR0620N). Also, CMULT is an old method of doing this.
O. |
|
Back to top |
|
|
Ats
New User
Joined: 21 Jul 2010 Posts: 6 Location: Roaming
|
|
|
|
You may also want to look at EXAMINE TRANSLATE statement. This could also achieve what you are aiming at. |
|
Back to top |
|
|
Ralph Zbrog
New User
Joined: 21 Nov 2009 Posts: 58 Location: California
|
|
|
|
What exactly is the problem?
If the database contains lowercase text, then the flat file will contain lowercase text. Natural doesn't automatically convert text in a database field.
If the database contains uppercase text, then you can translate it with an EXAMINE statement.
Code: |
EXAMINE #TEXT TRANSLATE INTO LOWER CASE |
Is lower case content of a database field placed in a modifiable field of a map? Is the map field defined with upper case translation?
If you're having trouble specifying literals in lower case for conditional Natural code, there may be two issues.
Try the %L terminal command to tell Natural to turn off automatic upper case translation.
Enter the PROFILE command in the program editor, press PF4 for Additional Options, select General Defaults, and turn on the first two options (Editing in Lower Case and Dynamic Conversion of Lower Case). |
|
Back to top |
|
|
cooolguyin Warnings : 1 New User
Joined: 12 May 2005 Posts: 10 Location: NY
|
|
|
|
Thanks everyone.. My DB has this field in upper case." Examine translate "worked for my need.
Thanks Ralph for letting me know how to change the general defaults.. I never tried it before |
|
Back to top |
|
|
|