Wrong column names in seq.file

[admin]

Hi,

I've got the following problem:

I create a sequential file with certain column names, first line is
columnnames is used. I've tried lot of things to change the column names in
the output file but it doesn't have any influence on the names mentioned in
the first line of the created output file. Could it be a reference to a
table-definition or something like that?

Any idea?

Thanks!

Wim van Dommelen.


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
*******************************************************************************

[admin]

The name of the columns in the first row should be the name of the fields on
the input link of the sequential file stage. Changing the field names
should change the names written to the sequential file.

Is that what you are asking or have I misunderstood the question.


-----Original Message-----
From: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com]
Sent: Monday, 17 November 2003 6:48 PM
To: 'datastage-users@oliver.com'
Subject: Wrong column names in seq.file

Hi,

I've got the following problem:

I create a sequential file with certain column names, first line is
columnnames is used. I've tried lot of things to change the column names in
the output file but it doesn't have any influence on the names mentioned in
the first line of the created output file. Could it be a reference to a
table-definition or something like that?

Any idea?

Thanks!

Wim van Dommelen.


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking
aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere
aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
****************************************************************************
***

[admin]

David,

This is the way it should work, the changes I make do not result in other
names in the first line of the output file...
It's realy strange.

Wim.

-----Oorspronkelijk bericht-----
Van: David Barham [mailto:david@barham.hm]
Verzonden: maandag 17 november 2003 10:13
Aan: datastage-users@oliver.com
Onderwerp: RE: Wrong column names in seq.file


The name of the columns in the first row should be the name of the fields on
the input link of the sequential file stage. Changing the field names
should change the names written to the sequential file.

Is that what you are asking or have I misunderstood the question.


-----Original Message-----
From: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com]
Sent: Monday, 17 November 2003 6:48 PM
To: 'datastage-users@oliver.com'
Subject: Wrong column names in seq.file

Hi,

I've got the following problem:

I create a sequential file with certain column names, first line is
columnnames is used. I've tried lot of things to change the column names in
the output file but it doesn't have any influence on the names mentioned in
the first line of the created output file. Could it be a reference to a
table-definition or something like that?

Any idea?

Thanks!

Wim van Dommelen.


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking
aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere
aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
****************************************************************************
***

[admin]

I had a typo in my first reply.... Here you go again!
Good luck!

Try this:

* Run your file through another transformer.
* The column names on the INPUT tab of the stage that is input to the transformer should have the old columns name listed. The column names that are in the OUTPUT TAB of the stage that is input to the transformer should have the new column names that you want to change to.
* Then, in the sequential stage AFTER the transformer, create a new file as "first line is column names", and in that stage, also put the new column names in the "INPUT" tab there.

I tested this, and it worked for me.
Lindi


*****E-Mail Confidentiality Notice*****
This message (including any attachments) contains information intended for a specific individual(s) and purpose that may be privileged, confidential or otherwise protected from disclosure pursuant to applicable law. Any inappropriate use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalty. If you have received this transmission in error, please reply to the sender indicating this error and delete the transmission from your system immediately.


>>> Wim.van.Dommelen@NL.Fortis.com 11/17/03 03:48AM >>>
Hi,

I've got the following problem:

I create a sequential file with certain column names, first line is
columnnames is used. I've tried lot of things to change the column names in
the output file but it doesn't have any influence on the names mentioned in
the first line of the created output file. Could it be a reference to a
table-definition or something like that?

Any idea?

Thanks!

Wim van Dommelen.


****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
*******************************************************************************