× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ranarohitp(*) reported 2013-04-22T12:53:17Z  · last modified 2013-04-26T12:59:08Z

Does not insert data for default column


Dev
Kin-Hong Wong
kin-hong
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component Tools - Import Tool
Version 14.0

ADS version : ads-windows-x64-14.0-dev-41
Database:Sybase Anywhere 12

  1. Connect to Sybase Anywhere.
  2. Create a new table Person,use given below script
    CREATE TABLE dbo.Persons
    (
    P_Id int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255),
    UNIQUE (P_Id)
    )
  3. Go to Persons table right click and say alter table,assign default value to city column and say alter table.
  4. Create new text file on your machine which have the following contents and save.
    "P_Id","LastName","FirstName","Address"
    1,"a","b","c"
    2,"d","e","f"
    3,"g","h","i"
  5. Now go to Tools->Import Data->Connect to Sybase anywhere->Import file saved.click next->From Schema and table drop down select respective values and click next->In option tab from "Destination" drop down->choose "Import into database",click on next button->On Transaction tab don't make any change to default values and say next.It will give error message on status tab saying "Error: Row: 4 -- JZ0SA: Prepared Statement: Input parameter not set, index: 4."
  6. Again follow step 5 but under Option tab from "Destination" drop down->Choose "Preview INSERT Statement" and say next it will take you to "Preview" Tab,now take any query,open new query analyzer window and execute the query,it will insert record into the database.

So here system should insert data in both the cases,it should not fail at step 5 as we have not included default column and which is the default behavior of any database,if you don't include a column having default value then specified default value will be inserted.

 

4 attachments
  • 2

    2013-04-22T13:07:30Z

    114 KB

  • 1

    2013-04-22T13:07:30Z

    116 KB

  • 3

    2013-04-22T13:07:31Z

    118 KB

  • Export.txt

    2013-04-22T13:32:48Z

    84 B

Issue #8712

Closed
Fixed
Resolved 2013-04-25T16:31:13Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017