I have encountered dangerous difficulties during loading data from MSSQL server to sybase IQ!
Ascential (sory IBM) IQ plugin, creates flat file with data, adn loading script on hard disk and then (manualy or by Open Client) sends IQ command which runs loading script and loads flat file with data into IQ server.
Each data column in flat file is separated with some character (default "|") which you can define on your own in loading script.
What is the problem??In my source database in one column (type varchar) I have character string which includes "|" character!!! And IQ loading script takes it as column separator!
and finally the question, is there in DS some possibility to avoid such situation, maybe you have some ideas? Because I don't want to put in every varchar column following condition: If column includes "|" change it !!
I can use any character and it will be working. Do you think that ^ or ~ is better character and there is less propability that you can encounter theese characters in strings writing by databases users??
Luk wrote:
I can use any character and it will be working. Do you think that ^ or ~ is better character and there is less propability that you can encounter theese characters in strings writing by databases users??
As far as I know users is very rare for using ^ or ~ instead of | or , sign
I ask another question - is there in DS possibility that loading into IQ using IQ bulk plugin will be continued when there will be warning??
Now job stops when there is a warning!
Luk wrote:but danger that your jobs fails still exist
I ask another question - is there in DS possibility that loading into IQ using IQ bulk plugin will be continued when there will be warning??
Now job stops when there is a warning!