Dear All,
How to retrieve the contents of a flat file and insert into a table present in
DB2 database using STORED PROCEDURES...My Flat file contains employee name,emp
id ,emp address etc
..I got o/p at the DB2 command prompt using following
command
IMPORT FROM "C:\CPS\EMPLOYEE\emp1.del" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7)
MESSAGES "C:\CPS\EMPLOYEE\emp.log"
INSERT INTO DB2ADMIN.ASHOK
(EMP_ID,EMP_NAME,EMP_ADDRESS,EMP_DEPT,EMP_POSITION,EMP_
AGE,EMP_SEX)
Here emp.del is a flat file
ASHOK is a table name
If I copy the same command from the command prompt and place it inside the
stored procedure,it's not working... is there any alternative command to be
used inside the stored procedure to retrieve the file contents..
please let me know if u get a solution for this
Regards
H.Ashok
---------------------------------
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection
for FREE!
http://in.mail.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
