SQL Anywhere 10 version -DBISQL tool ->I am trying to execute the insert statements around .35 million lines, even i split it to 3 or 4 files it is hanging to load the files.

1) is there any options to remove the leading spaces/trailing spaces to minimize the no. of lines with the .SQL file insert query statements

2)is there any option to minimize the lines of insert query statement in .SQL file

3)How many line of codes is good to execute with DBISQL tool?

asked 16 Oct '20, 02:54

Sankar's gravatar image

Sankar
906611
accept rate: 0%


I don't know about particular "numbers" - just a few hints:

  • For lange inserts, I would generally recommend the LOAD TABLE statement (but make sure it fits your requirements for transaction logging, say, because you use SQL Remote or the MobiLink client, or for recovery purposes).
  • Use the READ command within DBISQL instead of loading a huge SQL script into the GUI.
  • Any decent text editor should help to remove unnecessary white space (if that is a problem at all...)
  • FWIW: Version 12 has introduced INSERT with multiple value lists within one INSERT statement.
permanent link

answered 16 Oct '20, 03:21

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

Thanks a lot Volker Barth , working fine with Read command

(16 Oct '20, 03:42) Sankar
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×105

question asked: 16 Oct '20, 02:54

question was seen: 751 times

last updated: 16 Oct '20, 03:42