Skip to Content
author's profile photo Former Member
Former Member

updating 3rd parties db table using JDBC adapter at sender side

hi all.

i just want to know how i can updated the 3rd party db table field.

my scenario is just to retrieve data from 3rd party DB table where the condition is like " to select records where processed (field name ) = " ".

but i just need to update this field to x immediately after retrieving data from it.

so i simply wote the sql statement select REC_NO, ACTN_DAT, METRNO, MET-READ from PHAKAMA_CONN where processed = " ". under jdbc CC query sql stmt at sender side .

but i want to know how we can updated the processed (field ) from " " to "x"immeidtely after retrieving.

so could any body advice me how we can achiev this through UPDATE SQL STMT under sender jdbc cc.i just want to know wat stmt do we need to srite under this.

waiting for u r response.

cheers.

seeta ram.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jan 07, 2008 at 01:57 PM

    In the communication channel at jdbc sender, specify this

    Update tablename Set fieldname = "x" where fieldname = " ".

    Regards,

    Prateek

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 08:02 PM

    Ram,

    Execute your Select statement as needed and in the sender jdbc communication channel in the update SQL statement give this:

    UPDATE <tablename> SET <fieldname> = 'X' WHERE <fieldname>= ' '

    Also just to make sure if you have access to the database just login and execute this statement which should give the results as expected. If this works here successfully then it executes the same in XI also.

    Regards,

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi .

      sorry i just want to know HOW i could make sure whether the field in table at sender party is updated r not, if i executed the scenario by providing this update stmt under sender jdbc CC in (update sqlquery).

      if i have logon parameters for that sender jdbc i can but i doesnt have that.

      so could nay body tell me how we can make sure if sender jdbc table filed is udated r not through XI.

      waiting for u r anser.

      cheers.

      seeta ram.

  • Posted on Jan 07, 2008 at 08:16 PM

    Are you asking how to specify the query in the channel or where to specify it?

    In sender channel you have fields to specify 2 queries. One for the selecting the data, other is for updating any flags as such. This is the appropriate place to mention the update query/

    VJ

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.