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
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
| Programming languages | Programmer | C programming language |
| Computer programming languages | Java programming language | C programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
