Multiple Table Query Again

[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]

Abgeschickt von vabrol am 11 April, 2006 um 00:43:40

My Question is again on Multiple table updation.
One of the posts,I saw,did mention to to use multiple appenders or Stored procedure. Using Stored procedure is not an option for me but would like more details on using multiple appenders. My accepts a file save it in database.
I have 2 tables for logging: 'Category' table and other is 'cat_detail' .
'Category' table will contain information about each file received,total # of records,# of rejected records.

'cat_detail' will contain detail of each step to process data in the file.

I defined 2 appenders, one to insert into table 'cateogory' and other one for 'cat_detail' but not sure how to point specific messages to 'category' table while others to 'cat_detail'

Please advise.

Thanks

Antworten:

Ihre Antwort

Name:
E-Mail:

Subject:

Text:
: My Question is again on Multiple table updation. : One of the posts,I saw,did mention to to use multiple appenders or Stored procedure. Using Stored procedure is not an option for me but would like more details on using multiple appenders. My accepts a file save it in database. : I have 2 tables for logging: 'Category' table and other is 'cat_detail' . : 'Category' table will contain information about each file received,total # of records,# of rejected records. : : 'cat_detail' will contain detail of each step to process data in the file. : I defined 2 appenders, one to insert into table 'cateogory' and other one for 'cat_detail' but not sure how to point specific messages to 'category' table while others to 'cat_detail' : Please advise. : Thanks

Optionale URL:
Link Titel:
Optionale Bild-URL:

[ Antworten ] [ Ihre Antwort ] [ Forum www.mannhaupt.com ]