Hi all,
I am trying to populate data to DB2 table through DB2 UDB stage. I should load bulk data, so i choosed the same stage. In the properties, i have given user-id, password, tablename and so on. But somewhere, i am missing the actual connection. Actual connection is not happening. It is showing the error as, Invalid pointer to stage user data. The log is telling:
Internal Error: Function 'get_stage_prop' failed.
Error opening file in 'Directory for Data and Command Files'
Can you please tell what additional settings i need to make.
Thanks in Advance...
Rudresh
Unable to connect DB2 through DB2 UDB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact:
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact:
Re: Unable to connect DB2 through DB2 UDB
The DB2 UDB stage does not do bulk loading - please refere to the manual. For bulk loading you have to use the separate db2 bulk load stage.
Best regards
Klaus
Best regards
Klaus
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact: