| Author |
Message
|
| anadin |
 Posted: Fri Sep 27, 2002 12:47 am Post subject: Can i get a System Date in MQSI ? |
 |
|
Novice
Joined: 19 Aug 2002
Posts: 16
|
Hello
Can i get a System Date in MQSI ?
I want to chk one of the fields in XML to be <= System date.
Can i do this ?
Thanks in advance
Anadin |
|
| Back to top |
|
 |
| Miriam Kaestner |
| Posted: Fri Sep 27, 2002 1:29 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2001
Posts: 103
Location: IBM IT Education Services, Germany
|
| in ESQL there are functions CURRENT_DATE and CURRENT_TIMESTAMP. |
|
| Back to top |
|
|
| anadin |
| Posted: Fri Sep 27, 2002 2:16 am Post subject: |
|
|
Novice
Joined: 19 Aug 2002
Posts: 16
|
| Can i change the format of CURRENT_DATE ? |
|
| Back to top |
|
|
| Miriam Kaestner |
| Posted: Fri Sep 27, 2002 2:22 am Post subject: |
|
|
Centurion
Joined: 26 Jun 2001
Posts: 103
Location: IBM IT Education Services, Germany
|
Yes, in ESQL you can EXTRACT parts of the date/time, CAST them as CHAR, and thus set up your own format with string manipulation.
With MRM (version 2.1 only!) it is much easier - you don't have to write ESQL. Just enter a custom DateTime format string into the physical layer properties of an Element of simple type DateTime. |
|
| Back to top |
|
|
| anadin |
| Posted: Fri Sep 27, 2002 2:29 am Post subject: BIP60485 : Error occurred at offset '732' in the RFH2 option |
|
|
Novice
Joined: 19 Aug 2002
Posts: 16
|
Yeah !!! This can be done...
BTW do u know how to solve this error ?
BIP60485 : Error occurred at offset '732' in the RFH2 option buffer.
Thanks ...
Anadin |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Sep 27, 2002 12:10 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Anadin,
BIP6048E means there is an error in your name-value data area of MQRFH2 header and the position of the error is 732.
Please check the program, which is generating this RFH2 header.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
