CMD file has 256 character length limit

Question

I am generating a .CMD file using Informatica 9.5. It creates two MOVE commands (in the same file, 2 separate lines) with paths being picked from parameter files. The total length of the MOVE command exceeds 256 characters, and when the .CMD file is generated, it truncates this path when it reaches that character limit.

How do I resolve this issue?

The expression I am using in Informatica transformation is:

'MOVE "'  ||  $$FROM_PATH1  || 'FOO.ZIP"  "'  || $$TO_PATH  ||   'FOO' ||  '.ZIP"'  || CHR(10)      ||  
'MOVE "'  ||  $$FROM_PATH2  || 'BAR.ZIP"  "'  || $$TO_PATH  ||   'BAR'  ||  '.ZIP"'

When the CMD file is generated, it truncates the second variable and looks something like this:

MOVE "\\ABC\XYZ\FOLDER1\FOO.ZIP" "\\ABC\XYZ\FOLFOO.ZIP"
MOVE "\\ABC\XYZ\FOLDER2\BAR.ZIP" "\\ABC\XYZ\FOLBAR.ZIP"

Assuming that $$TO_PATH was \ABC\XYZ\FOLDER3\, notice that it has truncated the variable path but has still added the hard-coded characters. What gives?

Answer 1

The most likely problem is your target port is defined as 255 characters or another transformation during your mapping is limited to 255 characters.

Increase the size of the offending ports to fix your issue.