on 05-24-2016 4:06 PM
Hi All Gurus and Experts,
Greetings of the day !!
With due respect
{
Does this issue still persist with Interactive SQL , as one of the user facing this same issue, even error is same.
As at that time in this thread an user named 'Neal' said that it might be a bug of import utility. if he is right then its been long time 2009-2016(almost 7 yrs.)
SAP Sybase Forums - ASE - General Discussion - Import CSV into Sybase
What may be the cause of this , as if everyone forcing to use 'INPUT from' or 'bcp in' then what is the need of this ?
please put some light on this.
}
Thanks & Regards
pankaj
I've just used ASE 16.0 SP02 PL02's Interactive SQL to import a tab delimited data file with no problems. I created the data file by BCPing out of sysindexes. I created an empty user table version of sysindexes, by doing "select * into b from sysindexes where 1 = 2". All of the rows were imported in to b with no problems.
I also used it to copy data from one table to another. That is a useful part of the tool. Using BCP to import data from a table in a different ASE server would either need a data file to be created to hold the data exported from the source table, or the use of a pipe to BCP out and in simultaneously.
I cannot say why the import tool was added to Interactive SQL, Maybe to make it more tempting to users of paid for GUIs?
I would reiterate the point that the reply posts in the old link that you supplied made : namely to use BCP to import data from files. If you can use Interactive SQL then you should be able to use BCP in a command window. Granted, it's not a GUI interface but it is more configurable than the import tool. For example, there does not appear to be a way to change the row terminator in the import tool, so it probably won't be able to handle data that spans multiple lines for a single row. BCP can handle data like that because both the column and row terminators can be specified, using -t and -r respectively.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.