hardcode value

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
praburaj
Premium Member
Premium Member
Posts: 133
Joined: Thu Jun 30, 2005 1:26 am
Location: philippines

hardcode value

Post by praburaj »

Hi All,

I have one problem. I hardcoded Some value in to one column. When

i execute the job, that corresponding column show that hardcoded

value for only one row but Other row not show that hardcoded value. I

think Some Logical Error. Can anyone help me . How can i solve that?

EX:

AGG_GRID_OUTPUT : "N/A" COLUMN TYPE : VARCHAR LENGTH : 240

Regards,

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

Post by ArndW »

prabu,

a hardcoded value will add that value for each row. If it doesn't then the error is elsewhere. Could you explain your job? Does your transform have constraints and what type of object are you writing to?
praburaj
Premium Member
Premium Member
Posts: 133
Joined: Thu Jun 30, 2005 1:26 am
Location: philippines

Post by praburaj »

I removed that corresponding hardcoded value and i hardcoded value

once again for that column. And i check the column one by one and run

the job. Now, the job is run successfully. Thanks all :D
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

If you have append type output, you might have wrongly refferd to the previous run data, the only recored with the correct value might be for current.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply