| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to Insert value into a Reserved key word? |
« View previous topic :: View next topic » |
| Author |
Message
|
| busy_chap |
 Posted: Fri Jul 13, 2007 10:21 am Post subject: How to Insert value into a Reserved key word? |
 |
|
Acolyte
Joined: 18 May 2006
Posts: 69
|
Hello all,
My WBI code is trying to insert values into an Oracle database. All the values are successfully insereted except for the reserved words like AS and BY.
I tried using "AS" and "BY" in the Insert statement , no use.
Has anyone come across such a problem?
Thanks in advance. |
|
| Back to top |
|
 |
| mgk |
| Posted: Fri Jul 13, 2007 1:59 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
How about posting an example of the code that is failing to INSERT?
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| busy_chap |
| Posted: Mon Jul 16, 2007 10:08 am Post subject: example |
|
|
Acolyte
Joined: 18 May 2006
Posts: 69
|
My WBI Insert code is as follows:
INSERT INTO Database.ABC."Table_Name"
(AP,AQ,AR,AS,BX,BY,BZ)
VALUES(1,2,3,4,5,6,7);
All the values are inserted into the database except for AS and BY as they are reserved key words in the database.
In my WBI Insert code , I also tried using "AS" and "BY" but this also never worked and I get the error which says invalid column specification.
Can anyone help me with this problem? |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Mon Jul 16, 2007 10:51 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi busy_chap,
Perhaps you can try PASSTHRU.
Regards. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
