why i get three more Addnl rows ?

[srinath51]

Hi All,

i am populating a Record which is hardcoded as "TRAILERRELIARTOWSFRWC".

When i run this in Dev i get output as TRAILERRELIARTOWSFRWC (which is correct)

But recently i migrated the code to QA & when i test it in QA then i get TRAILERRELIARTOWSFRWC and also there are 3 more rows (rows with Spaces) are also coming in the output.

So i am debugging the code to see why i am getting those Addnl 3 Rows below the "TRAILERRELIARTOWSFRWC",But i am unable to resolve.

so Please Help me On why those three addnl rows occur in the QA.

[chulett]

How many nodes does the job run on in QA?

[srinath51]

Hi Chulett,
it runs on a single Node.

Here is the Config file:

dsQ:'$APT_CONFIG_FILE'=/ford/thishost/proj/Ascential/DataStage/Configurations/FEDW_SOWSQAdefault.apt

[sambitsamantray]

Try copying the hard coded code to a notepad to see if the code is not ending on the same line.

[srinath51]

Hi,
i did compare the Hardcoded characters and it looks same.

[SURA]

share your job flow!

DS User

[kandyshandy]

Sri.. Since you hardcoded the value, your job flow probably looks like

dummy sequential file -> transformer -> output file.

I guess the dummy sequential file (input file) has 1 record in DEV but 3 records (atleast new line characters) in QA. Check it out!!

[srinath51]

Hi ALL,

the length of the hard-coded character i.e; TRAILERRELIARTOWSFRWC is Char(120).But earlier i didn't specify the Length in Dev.
so i made this change in Dev now i.e; Specified the Exact Length i.e; Char(120) and migrated to QA.

Now it is working fine in QA ( i.e; i Don't see 3 Additional Rows )

[kandyshandy]

Doesn't seem to be a valid reason Anyways, you got what you wanted.