How load load char numbers into DB2 Decimal fields (load utility)

Reid McBeth

How load load char numbers into DB2 Decimal fields (load utility)

Hi, wondering if anyone can help ???

I have a file with data that I need to load into a DB2 table (using DSNUTILB utility).

The input flat file has numeric data (but just in pain numbers in text) and the target DB2 column is defined as DECIMAL.  Is there a way to tell the load utility to do an auto conversion during the load utility run ?

Any help would be great, thanks

..Reid

Colin Clayton

How load char numbers into DB2 Decimal fields (load utility)
(in response to Reid McBeth)
Hi Reid,

For the full syntax and options please refer to the Utility Guide and Reference (or your ISV product doc).

The keyword you need to look at is DECIMAL EXTERNAL(length,scale)

Colin Clayton
CA Technologies

CA DB2 Tools Global User Community http://bit.ly/DB2tools



From: Reid McBeth [mailto:[login to unmask email]
Sent: 19 October 2017 18:58
To: [login to unmask email]
Subject: [DB2-L] - How load load char numbers into DB2 Decimal fields (load utility)


Hi, wondering if anyone can help ???

I have a file with data that I need to load into a DB2 table (using DSNUTILB utility).

The input flat file has numeric data (but just in pain numbers in text) and the target DB2 column is defined as DECIMAL. Is there a way to tell the load utility to do an auto conversion during the load utility run ?

Any help would be great, thanks

..Reid

-----End Original Message-----

Reid McBeth

How load char numbers into DB2 Decimal fields (load utility)
(in response to Colin Clayton)
Hi Colin,
Thanks so much – that worked like a charm
..Reid


Reid McBeth | IT Business Analyst | EETS-HR | TD Bank Financial Group
275 Dundas St. 16th Floor, London, ON | Tel:519-663-1752
[login to unmask email]<mailto:[login to unmask email]>


From: Clayton, Colin [mailto:[login to unmask email]
Sent: Friday, October 20, 2017 4:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: How load char numbers into DB2 Decimal fields (load utility)

Hi Reid,

For the full syntax and options please refer to the Utility Guide and Reference (or your ISV product doc).

The keyword you need to look at is DECIMAL EXTERNAL(length,scale)

Colin Clayton
CA Technologies
CA DB2 Tools Global User Community http://bit.ly/DB2tools https://clicktime.symantec.com/a/1/4ylppCGQQLqP0bff9S6LEtMmdASqih3GRawY7Ao8PvU=?d=kPM296P3gHZl9ISFWoj8IBaHoe5FVpckmmdyZZb49gt9Ksl0My7KVVWr9s7Zrz9SfRQJGEV1eWLPzEr0fP5cXmzzGAUebn1NX-nWlYbiO4HExRqRkRoDHHqffvjJgVM1FCHjAzg94SEX5FVNFIS0j17tfmYymmbFpJomdqlmKkkRod1MO5w5ixQaOIEzQ4v8VbOkYCzDRX13BNHdt1IEi6FmZ7kq_zErBUbUVf3elnmnwvW7HApnrewnp1rsD_jmsu94Kv8q-eN7XcZkE1uNDDz_R_nJTxx0Ediyl13D0EUobPdOkat457ocwO2fVT-1s2-IUKex9lvqHAeTf5-0v_-rmCJKOLPlcRq7oTpYtCS_vL4PAuoYoY_07UtgsgAWBPn_cejmXxlYyGAtQQP5rRU-KvwBxkTjEInBP8L1FtxQKf6Y2wJvjLATZKT8yQ5d1JXRevnwwkK3aiWKWlVM&u=http%3A%2F%2Fbit.ly%2FDB2tools


From: Reid McBeth [mailto:[login to unmask email]
Sent: 19 October 2017 18:58
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - How load load char numbers into DB2 Decimal fields (load utility)


Hi, wondering if anyone can help ???

I have a file with data that I need to load into a DB2 table (using DSNUTILB utility).

The input flat file has numeric data (but just in pain numbers in text) and the target DB2 column is defined as DECIMAL. Is there a way to tell the load utility to do an auto conversion during the load utility run ?

Any help would be great, thanks

..Reid

-----End Original Message-----

-----End Original Message-----

If you wish to unsubscribe from receiving commercial electronic messages from TD Bank Group, please click here or go to the following web address: www.td.com/tdoptout
Si vous souhaitez vous désabonner des messages électroniques de nature commerciale envoyés par Groupe Banque TD veuillez cliquer ici ou vous rendre à l'adresse td.com/tddesab

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.