Page 1 of 1
Job Parameter Limit
Posted: Mon Dec 24, 2007 7:42 am
by shivadas
Hi All,
I have a job parameter which is of String data type, I am assiging a value for it which is more than 1053 Char length, it is ignoring the values after 1050 character....
How do i increase the size of the string in Job Parameter...
Posted: Mon Dec 24, 2007 8:05 am
by chulett
You can't AFAIK, but perhaps you can split it into multiple parameters. Where are you using this?
Posted: Mon Dec 24, 2007 8:16 am
by ArndW
I'm not sure if that is a DS limitation. What UNIX platform are you on and have you checked to see what your LINE_MAX setting might be?
Job Parameter Limit
Posted: Mon Dec 24, 2007 8:18 am
by shivadas
this parameter i am using in the SQL statement.
Job Parameter limit
Posted: Mon Dec 24, 2007 8:36 am
by shivadas
ArndW, i am using AIX ver 5
when i say echo $LINE_MAX it returns blank...
Dont know how do i check the line_max... Can you help me on this
Posted: Mon Dec 24, 2007 8:39 am
by ArndW
You won't find it using echo. Look into your file /usr/include/sys/limits.h and search for the assignment of LINE_MAX
Job Parameter limit
Posted: Mon Dec 24, 2007 8:40 am
by shivadas
ArndW, i am using AIX ver 5
when i say echo $LINE_MAX it returns blank...
Dont know how do i check the line_max... Can you help me on this
Posted: Mon Dec 24, 2007 8:47 am
by ArndW
Shivadas - what do you mean you don't know how to get the LINE_MAX?
I just posted instructions on how you can see your setting.
Posted: Mon Dec 24, 2007 8:57 am
by chulett
Or it may be a stage limitation on the size of the SQL.. which stage?