| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| eSQL jumping around? |
« View previous topic :: View next topic » |
| Author |
Message
|
| madi |
 Posted: Thu Apr 06, 2006 10:46 am Post subject: eSQL jumping around? |
 |
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
This is what i have
| Code: |
IF LENGTH(mozDate) = 7 THEN
(1)SET TOrderYear = CAST(SUBSTRING(mozDate FROM 1 FOR 3) AS INT) + 1900;
(2)SET TOrderMon = SUBSTRING(mozDate FROM 4 FOR 2);
(3)SET TOrderDay = SUBSTRING(mozDate FROM 6 FOR 2);
ELSE
(4)SET TOrderYear = CAST(SUBSTRING(mozDate FROM 1 FOR 2) AS INT) + 1900;
(5)SET TOrderMon = SUBSTRING(mozDate FROM 3 FOR 2);
(6)SET TOrderDay = SUBSTRING(mozDate FROM 5 FOR 2);
END IF;
(7)DECLARE mozTimeLen INT Length(mozTime);
WHILE mozTimeLen < 6 DO
(8)SET mozTime = '0' || mozTime;
(9)SET mozTimeLen = Length(mozTime);
END WHILE; |
I have numbered the statements just to explain the problem.
tha order of the execution of the statement is random!!!
sometime it goeslike 1,5,6,7,8,10..
sometime it is 1,2,6,6,7, .. jumps 8 and 9
i dont understand.
and when it executes 7 i dont see the variable mozTimeLen in the list (debugger) i can see mozTime there and its length is 5 which means it should exec the while but its not.
this is totally freaking me out
has anybody seen this
im on v5 fix pack 7
sometimes its working perfect and I get my desired output but sometimes its just not working and everything is the same
--madi |
|
| Back to top |
|
 |
| fschofer |
| Posted: Thu Apr 06, 2006 11:20 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
maybe you are jumping over some steps when using the debugger.
Run a debug level trace to see what happens.
Greetings
Frank |
|
| Back to top |
|
|
| madi |
| Posted: Thu Apr 06, 2006 11:20 am Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
thats what i thought
i ve run it without the debugger but still the same results. |
|
| Back to top |
|
|
| EddieA |
| Posted: Thu Apr 06, 2006 5:43 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| fschofer wrote: |
Run a debug level trace to see what happens. |
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| JT |
| Posted: Fri Apr 07, 2006 6:20 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| The source code in your toolkit is not in sync with the code deployed to the broker. 'Bar' the source code again, and re-deploy. |
|
| 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
|
|
|
|
