top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

CMD file has 256 character length limit

+1 vote
96 views

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?

posted Nov 11, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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.

answer Nov 14, 2014 by Shweta Singh
Similar Questions
+1 vote

I am trying to create character sequence like AAA, AAB, AAC, AAD,....,BAA, BAB, BAC,.... and So on in a flat file using Informatica. I have the formula to create the charater sequence.

Here I need to have sequence numbers generated in informatica. But I dont have any source file or database to have this source.

Is there any method in Informatica to create sequence using Sequence Generater when there is no source records to read?

0 votes

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

+1 vote

I am reading a file which has many descriptive fields of length 4000 bytes. While reading this file as a table I could not put the conditions into the source qualifier because it does not have enough space to put SQL in it.

Hence i decided to put replace newline character by spaces in a expression transformation.

I tried the following code:

REPLACECHR(0,SUPSPD_COMMUNICATION_PLAN, CHR(10)||CHR(11)||CHR(12),'<br/>')
I am getting < in the output.

How do i do this?

0 votes

I have designed a mapping where i have flat file as source and teradata as target. I am using MS Windows Latin 1(super set of latin 1) code page.

Can anyone help me to find it out?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...