DSXchange

Hello!

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 !!

Regards

Isn't the delimiter character a property of the stage/link?

yes it is!! but if I define delimiter character i.e. "%" or "," and someone use this character in varchar column problem comes back!!

Luk wrote:yes it is!! but if I define delimiter character i.e. "%" or "," and someone use this character in varchar column problem comes back!!

try using ^ or ~ and see how it works, don't forget to change delimiter sign in Sybase IQ Bulks plug in too..

I was using this tricks before, from sql2k dump text file with ^ delimiter and load in IQ using that sign too..

YA

try using ^ or ~ and see how it works

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

CMIIW

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!

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!

nope job will be stop.