Sponsored Content
Full Discussion: Sybase load statement issue
Top Forums Programming Sybase load statement issue Post 302542250 by irudayaraj on Wednesday 27th of July 2011 05:00:24 AM
Old 07-27-2011
Sybase load statement issue

hi,
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

Code:
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
Code:
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 06:20 AM..
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

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. 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

7. 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

8. 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

9. 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
LOAD(7) 						  PostgreSQL 9.2.7 Documentation						   LOAD(7)

NAME
LOAD - load a shared library file SYNOPSIS
LOAD 'filename' DESCRIPTION
This command loads a shared library file into the PostgreSQL server's address space. If the file has been loaded already, the command does nothing. Shared library files that contain C functions are automatically loaded whenever one of their functions is called. Therefore, an explicit LOAD is usually only needed to load a library that modifies the server's behavior through "hooks" rather than providing a set of functions. The file name is specified in the same way as for shared library names in CREATE FUNCTION (CREATE_FUNCTION(7)); in particular, one can rely on a search path and automatic addition of the system's standard shared library file name extension. See Section 35.9, "C-Language Functions", in the documentation for more information on this topic. Non-superusers can only apply LOAD to library files located in $libdir/plugins/ -- the specified filename must begin with exactly that string. (It is the database administrator's responsibility to ensure that only "safe" libraries are installed there.) COMPATIBILITY
LOAD is a PostgreSQL extension. SEE ALSO
CREATE FUNCTION (CREATE_FUNCTION(7)) PostgreSQL 9.2.7 2014-02-17 LOAD(7)
All times are GMT -4. The time now is 06:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy