Using ODBC Enterprise 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
jammala.ds
Participant
Posts: 38
Joined: Thu Jul 03, 2008 3:42 am

Using ODBC Enterprise stage

Post by jammala.ds »

Hi all,
I am using below job design

Externatsource---->xmlinput stage---->transformerstage---->Odbcstage

job is sucessfully run.i am getting no data.

here job showing one record going to target stage (odbc)

i am using update query

In Xml file Column name are
column names--- repno,text_info,text_type,text_sourcefilling_type,

Odbc table lo colmns names, ppi,gnrc_code,hdg_code,medium_text,
here update medium_Text

Repno=ppi these are key columns

(gnrc_code,hdg_code----key colmns)

UPDATE VOY.BUSINESS_SUMMARY SET MEDIUM_TEXT = 'Text_SourceFilingType' WHERE PPI = 'C840L88970'
any one help me please
Thanks&Regards
Krishna
Post Reply