cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase error code=102, SQLState="42000" , while using import tool in Sybase ASE

SybDBA
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (0)