| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| selecting records based on DATE from oracle DB using ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqs_guy |
 Posted: Wed Jun 02, 2004 12:28 pm Post subject: selecting records based on DATE from oracle DB using ESQL |
 |
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
Hi,
I am trying to select a record based on a contents of the XML message.
The XML message is as below:
<Cds-sample>
<CURR_CODE>INR</CURR_CODE>
<CDS_DATE>18-jan-04</CDS_DATE>
</Cds-sample>
I have the following ESQL:
SET OutputRoot.XML."Cds-sample".Currency[] = (SELECT T1.FVR_RATE as Rate, T1.CURR_CODE as Code FROM Database.FIN_VALUE_RATE as T1 where ((T1.CURR_CODE = InputRoot.XML."Cds-sample".CURR_CODE) AND T1.FVR_DATE =InputRoot.XML."Cds-sample".CDS_DATE));
Though there are records in the table...no records get selected if i execute the above ESQL.
Do i need to format the date type? Doesn't Oracle DB uses "DD-MON-YY" as the date format?
As always, any inputs appreciated. |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Jun 02, 2004 1:47 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| Doesn't Oracle DB uses "DD-MON-YY" as the date format? |
What does your database administrator say? |
|
| Back to top |
|
|
| mqs_guy |
| Posted: Wed Jun 02, 2004 1:54 pm Post subject: |
|
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
JT,
When i select the sysdate from dual it gives me the output in the format "DD-MON-YY".
Wanted to know if there's anything wrong with my ESQL?
Cheers |
|
| Back to top |
|
|
| mqs_guy |
| Posted: Thu Jun 03, 2004 6:16 am Post subject: |
|
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
Guys,
'Am still stuck!!
Looks like, i should format the way i specify the date!!
Your inputs are highly appreciated.
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
|
|
|
|
