Oppolzer - Informatik / Blog


Blog-Hauptseite      Neuester Artikel      Älterer Artikel      Neuerer Artikel      Älterer gleiche Kategorie      Neuerer gleiche Kategorie

DB2-L - Wie speichert man Dezimalzahlen und Zeichenketten zusammen in einem String?

Subject:

Native SQL Stored Proc string question - How to string several packed decimal values and CHAR values

From:

Bernd Oppolzer <bernd.oppolzer@T-ONLINE.DE>

Reply-To:

DB2 List <db2-l@lists.idug.org>

Date:

2014.05.07 01:47:00


I guess the answer to the original question is the HEX function
which was already mentioned.

Regarding FOR BIT DATA: because you have CHAR strings
and packed decimal data in one column, you will not be able
to cross platform boundaries anyway. If you do conversions,
your decimal data will be garbage, and if you don't, you will
get EBCDIC chars on ASCII machines etc.; so you need to make
sure that there will be no code translations, no matter if there is
a FOR BIT DATA clause on the column or not.

To put the different data in one column is really a very bad idea ...

Kind regards

Bernd



Am 06.05.2014 22:21, schrieb R.R.:
>
> Mark,
>
> Thanks. I'll try FOR BIT DATA and let you know.
>
> R.
>
>
> -----End Original Message-----

Blog-Hauptseite      Neuester Artikel      Älterer Artikel      Neuerer Artikel      Älterer gleiche Kategorie      Neuerer gleiche Kategorie