Insertion proble in JDBC

hi,

  1. hw to insert batch data in JDBC such that data must be inserted only when the first query in sql is successfully executed and others must be executed?
  2. hw do u format flat files?
  3. whether the segments of EDI is fixed or variable?

thanks in advance. Kindly help me. bye,
Narendra

Narendra,
Can you be more specific what you wnat to achieve.

  1. It is better that complex sql processing is done in Oracle as stored procedures.
  2. Use flat file format service. Register the transformation you want as flat file service and then invoke in yr flat file schema.
    3)its both delimited and fixed length. Header ISA segment is fixed lengh
    whereas transaction segments are delimited.

Johnson

This is a cross post (see http://www.wmusers.com/wmusers/messages/117/72948.shtml for my rant and then suggestions)

This post (unlike the other one) missed out the part about it being a set of questions for a job interview however… So what they’re trying to achieve is to scam their way into a job.

Hello,

Yemi Bedu