Routine Output question

[velagapudi_k]

When I am executing a TCL command in a routine to get the category of a job in a project, the output is returned as below

Developers Work Area
\U495278 Velagapudi\
JDAXml

How can I get it as below

Developers Work Area\U495278 Velagapudi\JDAXml

[nick.bond]

Code: Select all

Ereplace(yourString, @FM, '')

[ray.wurlod]

The wraparound in the column is caused by the default display width in the file dictionary. The inserted character to trigger the wraparound is not @FM, so Nick's suggestion won't work. What you need to do is to override the dictionary specification with a field qualifier - in this case FMT to override the format. For example:

Code: Select all

SELECT NAME, CATEGORY FMT '40L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%' ORDER BY 2,1;