Job Parameter Limit

shivadas · Post by **shivadas** » Mon Dec 24, 2007 7:42 am

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

chulett · Post by **chulett** » Mon Dec 24, 2007 8:05 am

You can't AFAIK, but perhaps you can split it into multiple parameters. Where are you using this?

ArndW · Post by **ArndW** » Mon Dec 24, 2007 8:16 am

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?

shivadas · Post by **shivadas** » Mon Dec 24, 2007 8:18 am

this parameter i am using in the SQL statement.

shivadas · Post by **shivadas** » Mon Dec 24, 2007 8:36 am

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

ArndW · Post by **ArndW** » Mon Dec 24, 2007 8:39 am

You won't find it using echo. Look into your file /usr/include/sys/limits.h and search for the assignment of LINE_MAX

shivadas · Post by **shivadas** » Mon Dec 24, 2007 8:40 am

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

ArndW · Post by **ArndW** » Mon Dec 24, 2007 8:47 am

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.

chulett · Post by **chulett** » Mon Dec 24, 2007 8:57 am

Or it may be a stage limitation on the size of the SQL.. which stage?

DSXchange