connecting to the database

[Shivakumar_3]

hello everybody,
i am using hp-ux server.i will be sending some data from the qnx client to hp-ux server.that data has to be directly dumped into database.how to go about it?

[Yogeeraj_1]

hi shiv,

What format is the data which you retrieving from the qnx client?

If the data is delimited (text), then you can use the SQLLDR utility to upload the data into Oracle tables.
(http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch05.htm#4959)

There is also the concept of External table that is available as from Oracle9i.
(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch12.htm)

In 10g, you have the new feature called data pump. Data pump which can do things like:
o parallelize
o direct path imports
o server to server transfer


Please post more details so that we can give you a precise answer.

thanks and regards
yogeeraj

[Shivakumar_3]

Hello everybody,
I am taking the data in a packet of 512kb on qnx side and just sending this packet to hp-ux server and i should dump this packet into database how to go about it?pls help me out.