× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ranarohitp(*) reported 2013-04-23T06:19:23Z  · last modified 2013-04-26T12:46:10Z

Does not insert data for identity 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 and set identity option to on for P_Id column
    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. Create new text file on your machine which have the following contents and save.
    "LastName","FirstName","Address","City"
    a,b,c,d
    f,g,h,i
    j,k,l,m
     
  4. 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: 2 -- JZ0SA: Prepared Statement: Input parameter not set, index: 0."
     
  5. 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.

     If for a column we have set identity insert then it should implicitly insert values for that column and should not give syntax error.

1 attachment

Issue #8722

Closed
Fixed
Resolved 2013-04-25T16:31:26Z
 
 
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