DBISQL - Query Execution Issue

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?

dbisql

asked 16 Oct '20, 02:54

Sankar
90●5●5●10
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Barth
39.3k●355●539●809
accept rate: 33%

Thanks a lot Volker Barth , working fine with Read command

(16 Oct '20, 03:42) Sankar

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

dbisql ×102

question asked: 16 Oct '20, 02:54

question was seen: 579 times

last updated: 16 Oct '20, 03:42

SAP SQL Anywhere

DBISQL - Query Execution Issue

Follow this question

Related questions