How to list the Job names under the category?

[ray.wurlod]

The wrapping occurs because the names you chose are longer than the default column display width. Override with the FMT keyword.

Code: Select all

SELECT NAME FMT '48L' FROM DS_JOBS WHERE CATEGORY LIKE '<<Category Name>>%' AND NAME NOT LIKE '\\%';

[us1aslam1us]

Thanks Ray, that works fine.

[videsh77]

Thanks Ray, it helps.