How to load data with Special Characters
Posted: Thu Nov 06, 2008 8:44 pm
Hi and thanks for reading ...
We have a database that we are extracting from that has the possibility of ALL and ANY special characters that is humanly / computerly (is that a word?) possible. So ... We can't use a pipe (|) delimiter or any other type of delimiter.
If our data was just varchar, we could use fixed length formats and dump the data, then move it to our target platform, then load the data. However, we are using DB2 8.2 and 9.5 which we have CLOB data. So, space is now an issue with fixed length records ...
Long story short, is there an easy method to dump the data in a variable length format with some kind of delimiter? Since our application / database accepts all special characters, I don't know how we can dump the data, then read it ...
We have DS Server 8.0.1 running on SUSE Linux 10. We were thinking we could extract and land the data in XML files. However, we are not having any luck with using the XML approach. We can't get the XSDs right and there is not much documentation, tutorials, or classes that address this that we have sought.
Please help ...
Thanks,
Benny
We have a database that we are extracting from that has the possibility of ALL and ANY special characters that is humanly / computerly (is that a word?) possible. So ... We can't use a pipe (|) delimiter or any other type of delimiter.
If our data was just varchar, we could use fixed length formats and dump the data, then move it to our target platform, then load the data. However, we are using DB2 8.2 and 9.5 which we have CLOB data. So, space is now an issue with fixed length records ...
Long story short, is there an easy method to dump the data in a variable length format with some kind of delimiter? Since our application / database accepts all special characters, I don't know how we can dump the data, then read it ...
We have DS Server 8.0.1 running on SUSE Linux 10. We were thinking we could extract and land the data in XML files. However, we are not having any luck with using the XML approach. We can't get the XSDs right and there is not much documentation, tutorials, or classes that address this that we have sought.
Please help ...
Thanks,
Benny