MVSFORUMS.com

cobcurious · Beginner Joined: 04 Oct 2003 Posts: 68 Topics: 25

Hi,
I am using DB2, LOAD utlity. While loading the data, I want to replace character "/" in date field with a "." How can I do this ?

Thanks in advance
Cobcurious

kolusu · Posted: Thu Apr 26, 2007 12:25 pm Post subject:

cobcurious,

1. Code a FIELDPROC on the column
2. Run the load file thru an utility and replace the character

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

cobcurious · Beginner Joined: 04 Oct 2003 Posts: 68 Topics: 25

Can you please tell how to use FIELDPROC here ???

LOAD DATA
INDDN (SYSREC)
LOG NO
REPLACE
COPYDDN(SYSCP101)
INTO TABLE NMK.TAB (
RLTNSHP_STRT_DTE POSITION( 113: 122)
DATE EXTERNAL( 10),

RLTNSHP_END_DTE POSITION( 123: 132)
DATE EXTERNAL( 10) )

kolusu · Posted: Thu Apr 26, 2007 1:01 pm Post subject:

cobcurious,

Fieldproc is something that you define at the time of creating/ALTERING the DB2 table.

Search for FIELDPROC in this link for a better understanding

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/5.36?DT=20010718164132

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Manas Biswal · Posted: Thu Apr 26, 2007 2:40 pm Post subject:

kolusu,

I am a little fuzzy on this but won't a fieldproc decode the value back when there is a select or an unload.

cobcurious,

Do you need the "/" permanently changed to "," ?

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

you can using DFSORT process the record before LOAD
try INREC/OUTREC OVERLAYY

cobcurious · Beginner Joined: 04 Oct 2003 Posts: 68 Topics: 25

Hi,

Thanks to Kolusu and videlord for your time.

Videlord,
There is no doubt DFSORT would have been one of the best alternative to use but due to some time restrictions I was not keen on using it. Anyways,I would request you to please let me know how can we use it in this scenario.

Kolusu,
Since in my project, we don't have access to create database tables, FIELDPROC can't be used. I would appreciate if you can please suggest any other trick of getting around this problem.

Thanks again
Cobcurious

kolusu · Posted: Tue May 01, 2007 12:36 pm Post subject:

cobcurious · Beginner Joined: 04 Oct 2003 Posts: 68 Topics: 25

Hi Kolusu,

I have n't tried the above idea. The problem was solved by the data sender to correct the format in which the data was being sent.

I will definitely try using the scalar function.

Thanks very much for your time.

Thanks
Cobcurious