Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richxyz
Starting Member
12 Posts |
 Posted - 2007-10-02 : 13:07:04
|
| I have an export file created by a UNIX-Perl script using the command below to output the file. A line-feed/carriage-return character is getting inserted at the 230th position causing problems in the data. I thought the -w1024 switch here would prevent this from happening. When I run a similar query that returns data with less than 230 characters, it runs fine - with no problem. I am not familiar with UNIX or PERL - does anyone know how to extend the file width so that it doesn't put a carriage return at 230?system("isql -S$DB_CONN -U$DB_USER -P$DB_PASS -d$DB_CATALOG -o$output_file -w1024 -Q\"$query\""); |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
UNIX PERL script using isql