JDL File and SCRIPT MODIFY

Hello,

I would like to update SCRIPT properties job.
JobModify limit to 500 characters.

JDL Files has no limit.
I would like to add a carriage return in line after
this syntax SET [JOBNUMBER] SCRIPT=Dim TEST, boolean

I have 400 Jobs in my 27x7 Database and I don't
want use .jal.

Thank you,

I don't think JDL files can be used to update multi-line properties like SCRIPT. So your choice is either using internal JAL scripts or external programs or scripts using any of the supported APIs. For example, you can use DDE from an Excel macro or COM or Java API. There are plenty of options.

By the way where the 500 characters limitation came from? I've never heard of that.

: Hello,

: I would like to update SCRIPT properties job.
: JobModify limit to 500 characters.

: JDL Files has no limit.
: I would like to add a carriage return in line after
: this syntax SET [JOBNUMBER] SCRIPT=Dim TEST, boolean

: I have 400 Jobs in my 27x7 Database and I don't
: want use .jal.

: Thank you,

: I don't think JDL files can be used to update multi-line properties like
: SCRIPT. So your choice is either using internal JAL scripts or external
: programs or scripts using any of the supported APIs. For example, you can
: use DDE from an Excel macro or COM or Java API. There are plenty of
: options.

: By the way where the 500 characters limitation came from? I've never heard of
: that.

Example :
Dim SCRIPT, string
Dim JOB_ID_MODEL, number, 428
JobCreate( job_id )
JobDescribe ( JOB_ID_MODEL, "SCRIPT", SCRIPT )
mailsend ("xx@xx.xx","","xx@xx.xx","TEST1", SCRIPT)
JobModify ( job_id, "SCRIPT", SCRIPT )
JobDescribe( job_id, "SCRIPT", SCRIPT )
mailsend ("xx@xx.xx","","xx@xx.xx","TEST2", SCRIPT)

TEST1 is good not TEST2.
I have 8000 characters in job 428 and only 474 characters in my new Job.

I have read on your forum some message where user have the same problem.

Interesting... so that's the internal DDE limit for string values. Then your choices are limited to use of COM or Java APIs. For example, you can write a .VBS script to do the change. Sample scripts are available in the COM API manual.

You can also off-load job scripts to user-defined statements (the Script Library feature) and call them from job scripts passing the required parameters. This will also help you to keep job scripts small and easily modify/create them from anywhere.

: Example : Dim SCRIPT, string
: Dim JOB_ID_MODEL, number, 428
: JobCreate( job_id )
: JobDescribe ( JOB_ID_MODEL, "SCRIPT", SCRIPT )
: mailsend
: ("xx@xx.xx","","xx@xx.xx","TEST1",
: SCRIPT)
: JobModify ( job_id, "SCRIPT", SCRIPT )
: JobDescribe( job_id, "SCRIPT", SCRIPT )
: mailsend
: ("xx@xx.xx","","xx@xx.xx","TEST2",
: SCRIPT)

: TEST1 is good not TEST2.
: I have 8000 characters in job 428 and only 474 characters in my new Job.

: I have read on your forum some message where user have the same problem.

: Interesting... so that's the internal DDE limit for string values. Then your
: choices are limited to use of COM or Java APIs. For example, you can write
: a .VBS script to do the change. Sample scripts are available in the COM
: API manual.

: You can also off-load job scripts to user-defined statements (the Script
: Library feature) and call them from job scripts passing the required
: parameters. This will also help you to keep job scripts small and easily
: modify/create them from anywhere.

Thank you !