| Author |
Message
|
| james2005 |
 Posted: Mon Dec 19, 2005 10:13 pm Post subject: Getting warnings at insert into Database-need urgent help |
 |
|
Apprentice
Joined: 18 Sep 2005
Posts: 31
|
Hi,
I am getting warnings at esql,
INSERT INTO Database.RECON( CLIENT,....)
here i am using 'INTDB01' as my database and 'broker' as my schema.
Can anyone pl tell me what is the correct statement.
i tried with,
INSERT INTO broker.RECON( CLIENT,....)
here 'broker' is my schema name for table 'RECON'.
I tried with INSERT INTO RECON(CLIENT,....)
But i am getting the same problem.
I need very urgent help.
Regards,
Enda. |
|
| Back to top |
|
 |
| EddieA |
| Posted: Mon Dec 19, 2005 10:21 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Try this.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Mon Dec 19, 2005 10:40 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Go to the toolkit Help-->Help Contents and search INSERT statement.
Regards. |
|
| Back to top |
|
|
| james2005 |
| Posted: Tue Dec 20, 2005 3:49 am Post subject: JDBC driver class? |
|
|
Apprentice
Joined: 18 Sep 2005
Posts: 31
|
Hi Eddie,
I tried to create database from data perspective. There i have to give ODBC driver class name and location. What i have to give?
-Enda. |
|
| Back to top |
|
|
| wschutz |
| Posted: Tue Dec 20, 2005 4:45 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
James, it's not too clear exactly what you problem is...firstly, what warnngs are you getting from the tooling? Sometimes it OK to ignote them.
Have you created the database and the odbc connections to it? You need to do that OUTSIDE of the tooling (the data perspective is used to import schema's, which isn't your problem).
_________________
-wayne |
|
| Back to top |
|
|
| james2005 |
| Posted: Thu Dec 22, 2005 1:52 am Post subject: My problem solved |
|
|
Apprentice
Joined: 18 Sep 2005
Posts: 31
|
Hi all,
My problem solved. Thanks for ur quick response.
Regards |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Thu Dec 22, 2005 1:58 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Maybe you could tell us how u did it, so that others will also benefit.
And mark the topic Solved.
Thanks. |
|
| Back to top |
|
|
|
|
