sample stored procedure??

vijay253 · #1 (**permalink**) 01-06-06, 10:20

Hi all,

If you have a stored procedure to read a fixedwith file and insert it into a Db2 table one line to one record at a time... please forward it to me at vijay253@yahoo.com.

thanks

Peter.Vanroose · #2 (**permalink**) 01-09-06, 04:13

Try using the LOAD utility.
Depending on your platform and DB2 version, the syntax may vary slightly.
E.g., have a look at http://publib.boulder.ibm.com/infoce...e/r0008305.htm

It contains the following example:

Code:

db2 load from ascfile1 of asc
      method L (1 20, 21 22, 24 27, 28 31)
      null indicators (0,0,23,32)
      insert into table1 (col1, col5, col2, col3)

where table1 at least has the following columns:
* COL1 CHAR(20) NOT NULL
* COL2 SMALLINT
* COL3 CHAR(4)
* COL5 CHAR(2) NOT NULL

Internet Services

Web Development

Digital Marketing

Consumer Tech