Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: help on ksh and sql..getting error as is too long. maximum size is 240 characters."
Top Forums UNIX for Advanced & Expert Users help on ksh and sql..getting error as is too long. maximum size is 240 characters." Post 302164829 by pooga17 on Wednesday 6th of February 2008 03:07:14 AM
Old 02-06-2008
help on ksh and sql..getting error as is too long. maximum size is 240 characters."
Hi,
In my script i am executing sql file and there are some variables in SQL files which are assigned at run time. one of the variable value is having more than 240 characters and at time of execution its getting failed with error as "is too long. maximum size is 240 characters."

Code:
variable**************
define maf_f=XXX','CMATMP','GMDF','GMDG','GMDINC','GMDSON','GMSINC','GMSMSF','GMSUPP','GMV3','GMVCFF','GMVCFR','GMVF','GMVFIT','GMVFXHGMVSTA','GMVG','GMVGH','GMVGV','GMVGVM','GMVINC','GMVMBLGMVBONGMVSTA','GMVSOHGMVSONGMVBONGMVSTA','GMVSONGMVBONGMVSTA','GMVSP','GMVSPHGMVSP','GMVTLHGMVTLMGMVBONGMVSTA','GMVTLMGMVBONGMVSTA','GMVXCF','GMVXCT','GMVXR','GMVXRFGMVXRA','INTVCF','INTVOC','SPFREE','S_1811','S_MØDE','S_WAP;
string beginning "XXX','CMAT..." is too long. maximum size is 240 characters.
*********************

And the value is getting assigned by ksh --- code is --

maf_f1=XXX
for i in `grep maf_f work_cdr.txt | awk '{print $4}' | sort -u`
do
maf_f1=$maf_f1"','"$i
done
****************************

I tried using split command by moving the data in temp file and then using &maf_feature1||&maf_feature2 at time of assigning varaible.

command used for splitting file :-
split -l 10 <file_name> segment

but the problem i am facing there are many variables and the segment file is getting overwritten..

Is there any way by which i can define the size of variable ... or any other method,,,

Please help on same
Thanks in advance,,,,
Pooja
 

10 More Discussions You Might Find Interesting

1. AIX

How to REMOVE USER that display error --> "Name is too long"

I wish to remove a user from the system... but an error occurr... I try to remove via SMITTY and try to remove via command line with rmuser -p (name of user) and does not works.... The system display that the "Name is too long" There another way to remove a user... or... (1 Reply)
Discussion started by: mgonzal
1 Replies

2. UNIX for Dummies Questions & Answers

Maximum input file size in "Diff" Command

Hello, Can anyone let me know what is the maximum file size that can be given as input for the "Diff" Command in Unix? I have a file size as large as 28MB and which can also increase. Will I face any issues with such a file size. If yes, What is the other alternative. Thanks in advance for... (1 Reply)
Discussion started by: Neeraja
1 Replies

3. UNIX for Dummies Questions & Answers

SQL Error "The cursor or statement is not available"

Trying to load a record into my test database and am getting an error: "The cursor or statement is not available". I've attached the file I'm trying to load and the file containing the sql I'm trying to run. Trying to copy a record from my production database to my test database, but the... (0 Replies)
Discussion started by: Monte Heeren
0 Replies

4. Shell Programming and Scripting

In ksh shell command - Print "-ABC" is giving error

Hi Guys, while executing the following command : print "-ABC" is giving following error : ksh: print: bad option(s) I cannot use echo for some other reasons, so any other option ? (2 Replies)
Discussion started by: sagarjani
2 Replies

5. Shell Programming and Scripting

"parse" SQL in bash or ksh

Hi! I've a text file programme1.out : CONNECT TO ORACLE (&CONXORA); CREATE TABLE TABLE1 AS SELECT ID_PERS FROM CONNECTION TO ORACLE ( SELECT DISTINCT PERS.ID_PERS FROM TAB_GRP GRP , TAB_PERS PERS WHERE DATE_DEB_GRP <=... (0 Replies)
Discussion started by: stagebi
0 Replies

6. Shell Programming and Scripting

ksh-script "arithmetic syntax error" comparing strings

Hi all, I´ve already searched the forum but can´t find what i am doing wrong. I am trying to compare two variables using ksh under red hat. The error I get is: -ksh: .: MDA=`md5sum /tmp/ftp_dir_after_transfer | cut -d' ' -f1 ` MDB=`md5sum /tmp/ftp_dir_before_transfer | cut -d' ' -f1 `... (3 Replies)
Discussion started by: old_mike
3 Replies

7. Shell Programming and Scripting

"Argument list too long" error

Hi everyone, I have a problem with my shell script. As a quick overview I need to change a template file 6561 times and copy the file into a new catalogue. Thanks to your forum I have managed to write a script to do so: #!/bin/sh template=$1 for values in {45,165,285}\ {45,165,285}\... (6 Replies)
Discussion started by: mario8eren
6 Replies

8. UNIX for Advanced & Expert Users

Trace "free(): invalid next size (normal)" error on arm-linux board

Hi guys, i'm running a program on samsumg 6410 arm cpu board. it caused an "free(): invalid next size (normal)" fail. i try to use gdb for remote debugging: 1, start gdb server on board: gdbserver 192.168.1.20:1234 ./HostAP Process ./HostAP created; pid = 499 Listening on port... (8 Replies)
Discussion started by: ss1969
8 Replies

9. Shell Programming and Scripting

How to avoid "Too many arguments" error, when passing a long String literal as input to a command?

Hi, I am using awk here. Inside an awk script, I have a variable which contains a very long XML data in string format (500kb). I want to pass this data (as argument) to curl command using system function. But getting Too many arguments error due to length of string data(payloadBlock). I... (4 Replies)
Discussion started by: cool.aquarian
4 Replies

10. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies

LEARN ABOUT MOJAVE

datetime::locale::gez

DateTime::Locale::gez(3)				User Contributed Perl Documentation				  DateTime::Locale::gez(3)

NAME

       DateTime::Locale::gez

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'gez' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Geez.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXXX
	 XXX

       Abbreviated (format)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXXX
	 XXX

       Abbreviated (stand-alone)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Months
       Wide (format)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Abbreviated (format)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Abbreviated (stand-alone)

	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 X/X
	 X/X

       Narrow

	 X/X
	 X/X

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXX 05 XXX XXXX 2008 X/X
	  1995-12-22T09:05:02 = XXXX 22 XXX XXXX 1995 X/X
	 -0010-09-15T04:44:23 = XXXXX 15 XXX XXXX -10 X/X

       Long

	  2008-02-05T18:30:30 = 05 XXX 2008
	  1995-12-22T09:05:02 = 22 XXX 1995
	 -0010-09-15T04:44:23 = 15 XXX -10

       Medium

	  2008-02-05T18:30:30 = 05-XXX-2008
	  1995-12-22T09:05:02 = 22-XXX-1995
	 -0010-09-15T04:44:23 = 15-XXX--10

       Short

	  2008-02-05T18:30:30 = 05/02/08
	  1995-12-22T09:05:02 = 22/12/95
	 -0010-09-15T04:44:23 = 15/09/-10

       Default

	  2008-02-05T18:30:30 = 05-XXX-2008
	  1995-12-22T09:05:02 = 22-XXX-1995
	 -0010-09-15T04:44:23 = 15-XXX--10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 6:30:30 XXX UTC
	  1995-12-22T09:05:02 = 9:05:02 XXX UTC
	 -0010-09-15T04:44:23 = 4:44:23 XXX UTC

       Long

	  2008-02-05T18:30:30 = 6:30:30 XXX UTC
	  1995-12-22T09:05:02 = 9:05:02 XXX UTC
	 -0010-09-15T04:44:23 = 4:44:23 XXX UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 XXX
	  1995-12-22T09:05:02 = 9:05:02 XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX

       Short

	  2008-02-05T18:30:30 = 6:30 XXX
	  1995-12-22T09:05:02 = 9:05 XXX
	 -0010-09-15T04:44:23 = 4:44 XXX

       Default

	  2008-02-05T18:30:30 = 6:30:30 XXX
	  1995-12-22T09:05:02 = 9:05:02 XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXX 05 XXX XXXX 2008 X/X 6:30:30 XXX UTC
	  1995-12-22T09:05:02 = XXXX 22 XXX XXXX 1995 X/X 9:05:02 XXX UTC
	 -0010-09-15T04:44:23 = XXXXX 15 XXX XXXX -10 X/X 4:44:23 XXX UTC

       Long

	  2008-02-05T18:30:30 = 05 XXX 2008 6:30:30 XXX UTC
	  1995-12-22T09:05:02 = 22 XXX 1995 9:05:02 XXX UTC
	 -0010-09-15T04:44:23 = 15 XXX -10 4:44:23 XXX UTC

       Medium

	  2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XXX
	  1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX
	 -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 XXX
	  1995-12-22T09:05:02 = 22/12/95 9:05 XXX
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 XXX

       Default

	  2008-02-05T18:30:30 = 05-XXX-2008 6:30:30 XXX
	  1995-12-22T09:05:02 = 22-XXX-1995 9:05:02 XXX
	 -0010-09-15T04:44:23 = 15-XXX--10 4:44:23 XXX

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 XXX
	  1995-12-22T09:05:02 = 22 XXX
	 -0010-09-15T04:44:23 = 15 XXX

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 XXX
	  1995-12-22T09:05:02 = 9:05 XXX
	 -0010-09-15T04:44:23 = 4:44 XXX

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 XXX
	  1995-12-22T09:05:02 = 9:05:02 XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = XXX, 2-5
	  1995-12-22T09:05:02 = XXX, 12-22
	 -0010-09-15T04:44:23 = XXX, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = XXX
	  1995-12-22T09:05:02 = XXX
	 -0010-09-15T04:44:23 = XXX

       MMMd (MMM d)

	  2008-02-05T18:30:30 = XXX 5
	  1995-12-22T09:05:02 = XXX 22
	 -0010-09-15T04:44:23 = XXX 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = XXX XXX 5
	  1995-12-22T09:05:02 = XXX XXX 22
	 -0010-09-15T04:44:23 = XXX XXX 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = XXX 5
	  1995-12-22T09:05:02 = XXX 22
	 -0010-09-15T04:44:23 = XXX 15

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 XXX
	  1995-12-22T09:05:02 = 22 XXX
	 -0010-09-15T04:44:23 = 15 XXX

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = XXX XXX 5
	  1995-12-22T09:05:02 = XXX XXX 22
	 -0010-09-15T04:44:23 = XXX XXX 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = XXX, 2008-2-5
	  1995-12-22T09:05:02 = XXX, 1995-12-22
	 -0010-09-15T04:44:23 = XXX, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 XXX
	  1995-12-22T09:05:02 = 1995 XXX
	 -0010-09-15T04:44:23 = -10 XXX

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = XXX, 2008 XXX 5
	  1995-12-22T09:05:02 = XXX, 1995 XXX 22
	 -0010-09-15T04:44:23 = XXX, -10 XXX 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 XXX
	  1995-12-22T09:05:02 = 1995 XXX
	 -0010-09-15T04:44:23 = -10 XXX

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = XXX 2008
	  1995-12-22T09:05:02 = XXX 1995
	 -0010-09-15T04:44:23 = XXX -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XXX

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						  DateTime::Locale::gez(3)
All times are GMT -4. The time now is 06:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy