Problem While transfering data from db2 to flatfile stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
hhh
Participant
Posts: 86
Joined: Tue Aug 02, 2005 7:39 am

Problem While transfering data from db2 to flatfile stage

Post by hhh »

Hello Friends,

I have 9 columns
I have transfered data from Db2 stages to Flatfile

columns are like

Fund char(4)
Asset_id char(9)
Name char(24)
Source_code char(1)
Sec_type char(1)
shares char(14)
Price char(10)
Zerofill char(10)
MktVal char(16)

Total length is 80.

when i run job, job works fine but when i concatenated 9 columns at that time it gives output upto Name(Column name)

I am not getting what is going on ?

please help me urgently to sort out my problem.

thax and regards

Hman
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Re: Problem While transfering data from db2 to flatfile stag

Post by ArndW »

hhh wrote:...
...when i run job, job works fine but when i concatenated 9 columns at that time it gives output upto Name(Column name)

I am not getting what is going on ?

please help me urgently to sort out my problem.
OK, So you read the columns correctly from DB/2 and have a problem concatenating them. I don't understand what the issue is, perhaps you could explain exactly what is not working.

If you use the term "urgent" again, chances are quite high that you will not get a response.
Post Reply