topic Re: Drop if exists and create not working for Sybase connection in Talend Studio

Drop if exists and create not working for Sybase connection

Anonymous — Thu, 26 May 2016 20:38:03 GMT

If I use drop and create table if exists on tcreatetable component with a Sybase connection I am getting the error that the table already exists. Please Help

Re: Drop if exists and create not working for Sybase connection

Anonymous — Fri, 27 May 2016 03:52:59 GMT

Hi,
Do you use same table name which is present in other database? Have you tried to use "Create table " table action in tCreateTable to see if it works?
Best regards
Sabrina

Re: Drop if exists and create not working for Sybase connection

Anonymous — Fri, 27 May 2016 14:15:37 GMT

Create table does work if table is not already created. Drop and create does not work.

Re: Drop if exists and create not working for Sybase connection

Anonymous — Mon, 30 May 2016 08:56:23 GMT

Hi,

Do you use same table name which is present in other database?

Could you please indicate the build version you are using?

Best regards

Sabrina

Re: Drop if exists and create not working for Sybase connection

Anonymous — Tue, 31 May 2016 14:17:20 GMT

The table does already exist in the database.

Talend Open Studio for Big Data
Version 6.1.1