DSXchange

Hi,

Is it possible to convert the entire input record read from a sequential file in to upper case. i am aware of the UpCase function, but if i use this i'll have to apply this funtion for each and every field. isn't there any generic way in which i can apply this to athe entire incoming record at once.

also i have some 100 odd jobs for which i have to convert all the inputs in to upper case . is there any other easier way of doing this.
mass relace or something.

thanx

dhiraj

You should not post this in the Looking for Talent forum.

The short answer, if you're on UNIX, is to use a filter in the Sequential File stage, running the file through tr. For example:

sorry ray,

i posted it to this forum by mistake.

btw i'm using windows.


thanks
dhiraj

As a suggestion try defining the inbound record as a single wide field in the sequential stage, UPCASE the single field then split the result through a second transform using substrings [] commands.

Just gave it a try and it works ok. Just have to be aware of quotes around any string fields and allow for these when splitting the main field.

Regards
Gavin

Moving topic to DataStage forum

To take Gavin's response one step further (and easier and more efficient) would be to write the record using the same delimiter. Then define the metadata correctly in another sequential stage thereby eliminating any need for substring'ing or field'ing of data in a transform.

Regards,

Michael Hester