DSXchange

Thanks for the reply

I am able to read the flat file successfully.
But the problem is : the last tag is coming in different column number in different records. I want it to send to one last column known as alt_text.

We don't have any knowledge in which column that particular tag appears.

Hi I want to detach the code which is at end of each record into separte column "alt_text" and palce at the end of record. The output should look like OUTPUT : CODE | TEXT|.... |ALT_TEXT (=TEXT) 470E | HYD!3721|...|HYD!3721 471E|HYD!3722|.....|HYD!3722 How to do this? My job is something l...

The delimiter is pipe
I am sorry for not being clear.

Hi I am having a flat file which is having data like: 1 record: 470E|Hyd! 3721|Hyd! Consolidated||Intl||Asia Pacific||North Asia||Total China w/ JV||Total China||470E|Hyd! 3721 2 record: 471E|Hyd! 3722|Hyd! Consolidated||Intl||Total China w/ JV ||Total China || 471E|Hyd!3722 I want to detach the cod...

Thanks Kris Here are few lines from my raw data file ---- there are 10 fields in each record -- given below are 3 records... DRACDDrachenblut Delikatessen Sven Ottlieb Order Administrator Walserweg 21 Aachen 52066 Germany 0241-039123 0241-059428 DUMONDu monde entier Janine Labrune Owner 67, rue des ...

Thanks for the reply

I do have the permission to create.
I do not know where it is going wrong.

Regards

Forgive me for my ignorance in this regard. I did try the above mentioned method before I posted here and could not get it to work - I got an error stating unable to initialize importer - ""record_length fixed" (no length given) and record field is variable length"" First of...

Hi Kris Thanks for the reply Sorry to trouble you. I am a novice to data stage and learning and I worked on Server and now trying on parallel. Actually I did use format tab and set the Record delimiter to DOS format. and also used Record length to be fixed. But it did not work out. My raw data does ...

Hi I am trying to extract the raw data from a flat file. This is a fixed width (column) file. I am using a sequential file stage to extract. Now how do I specify that it is fixed width column (like in server edition we have this option in the format tab). I donot know how this can be accomplished in...

chulett wrote:I guess you haven't looked to see if your identical question on IBM's forum was answered, eh?

Hi

I did not check it. Thanks for letting me know

Thanks
Sunil

Hi

I am trying to backup all projects.
Is there any utility or script to back up all projects on an identified server and also to make BMPs for all jobs in the project.

Thanks
Pradeep

Hi I am new to this group. I am using Datastage EE (7.5) I am trying to read the data from an ODBC Enterprise stage and pass it to a transformer and then write it into a ODBC Enterprise stage ODBC Enterprise-->Transformer-->ODBC Enterprise I am giving the write mode as "CREATE table". I am...