Sybase load statement issue

Thread Tools Search this Thread
Top Forums Programming Sybase load statement issue
# 1  
Old 07-27-2011
Sybase load statement issue

I am trying to load a sybase table using a file ( unit separator is the delimiter) which is in IQ server.

I Used load statment as below

execute ('LOAD TABLE schemaname.tablename (' || ' name, age, date, Symbols) from ' || ' '' /filepath/file.txt '' ' || ' QUOTES off ' || ' DELIMITED BY ' || ' ''\x1F'' ' || 'ROW DELIMITED BY ' || ' ''\n'' ' || ' FORMAT ASCII NOTIFY 1 WITH CHECKPOINT ON STRIP ON ESCAPES OFF')

but this is throwing an error as
ASA Error -1013028: An invalid size (too large) was specified for a LOAD option

I could not track this error. Can someone please help with this?
or can some one throw light how to use hexadecimal values like /x1F during loading.

The hexadecimal usage of unit separator( ^_ ) as x1F is not allowed in sybase?
can hexadecimal values be used?Smilie

Thanks in advance

Last edited by pludi; 07-27-2011 at 07:20 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

Sybase ASE Soundex Function Issue -Need Suggestion

Dear Team I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records Though the command works for characters and provides unique code for similar outputs. But when i try with Starting numbers ( Followed with Street address ) , soundex... (1 Reply)
Discussion started by: Perlbaby
1 Replies

2. Programming

Sybase ASE: Query to find correct format issue.

Hi Team , I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column. SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Discussion started by: Perlbaby
2 Replies

3. UNIX for Dummies Questions & Answers

Libraries load issue

I am trying to upgrade Autosys to r11.3.5 how ever while running the setup i am getting below error , I went through some of the Known errors , found to command the export LD_ASSUME_KERNEL parameter , which i did however didnot work . Could some pleae look into this asap. Starting all... (1 Reply)
Discussion started by: rakesh_411
1 Replies

4. UNIX for Dummies Questions & Answers

Client web pages very slow to load. Squid issue?

Hi. I have netBSD box acting as gateway, ftp, mail & web server, etc. It is now seven years old and has never missed a beat. The only problem is that the (Windows) boxes in my little network are now experiencing VERY slow web page loads. The other problem is that in the years since a Unix... (0 Replies)
Discussion started by: torontobob
0 Replies

5. UNIX for Dummies Questions & Answers

linux tomcat load average issue

Hello I am running a liferay application in tomcat on one of my hosted linux machine having 4GB of ram and 1 CPU. I get the tomcat response really slow and with much digging I found that the cpu might be loaded and can be tracked with top command. The following is the output of top command:... (0 Replies)
Discussion started by: dhavaln
0 Replies

6. Red Hat

Apache Load Balaning sticky session issue

Few doubts in apache load balancing - I want to clear my doubts about apache load balancing.i have configured apache load balancing for two application servers. 1. When we set load balancing for two application servers then for one connection to application server we will get one jsession id... (5 Replies)
Discussion started by: ganesh_gore
5 Replies

7. Shell Programming and Scripting

Sybase Connection Issue

I am trying this >$ /usr/sybase/bin/isql -UABC -Pdef -SXYZ -b Getting the following error. Help is appreciated (1 Reply)
Discussion started by: pinnacle
1 Replies

8. Shell Programming and Scripting

executing mysql load statement from shell script

Hi, I have a piece of shell script which will connect to mysql database and execute a load statement(which will load datas in a file to the database table).The code is working and the data is in the tables. Now my requirement is, i need to grab the output from the load statement... (4 Replies)
Discussion started by: DILEEP410
4 Replies

9. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies
Login or Register to Ask a Question