TCL / Query behavior

This topic has 9 replies, 3 voices, and was last updated 15 years, 1 month ago by Mike Campbell.

Creator

Topic
March 21, 2011 at 6:30 pm #52361
Mike Campbell
Participant
We are on CL 5.7 Patch 2 on AIX.
Creator

Topic

Viewing 8 reply threads

Author

Replies
- March 21, 2011 at 7:09 pm #73922
  Jim Kosloskey
  Participant
  Mike,
  
  It looks like you have 2 connects and only one disconnect.
  
  Maybe you need to disconnect both connections.
  
  email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.
- March 21, 2011 at 7:25 pm #73923
  Mike Campbell
  Participant
  Interesting. I’ve look multiple times at the echo’s and didn’t see that.
  
  Let me revisit…
- March 22, 2011 at 12:45 pm #73924
  Mike Campbell
  Participant
  This is just plain weird.
- March 22, 2011 at 1:37 pm #73925
  Jim Kosloskey
  Participant
  Mike,
  
  Well if the Tcl proc does not get executed at all then I would suspect something in the Xlate that only invokes the Tcl proc under certain conditions.
  
  Make sure you have an echo as the very first command in your proc to make sure whether it is executed or not.
  
  email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.
- March 22, 2011 at 1:41 pm #73926
  Mike Campbell
  Participant
  I do have echos in the xlate and proc. Even if I replay the same message from smat 2 times the second doesn’t hit the tcl-proc.
  
  A real puzzler…
- March 22, 2011 at 1:43 pm #73927
  Jim Kosloskey
  Participant
  Mike,
  
  It does hit the Xlate though?
  
  email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.
- March 22, 2011 at 2:26 pm #73928
  Mike Campbell
  Participant
  Yes, it is hitting the xlate, and there is an echo just before it calls the tcl-proc.
  
  First time:
  
  State code found is: NE
  
  ##### orc_12_id_length is gt 2
  
  ##### found the lisc_id and ready to call query
  
  ##### here we go
  
  Inside CernerDB_Formatted_Name_Select
  
  Starting CernerDB_Formatted_Name_Select Retrieval
  
  ID_NUM: >NE0017678<
  
  SQLALLOCHANDLE : SQL_SUCCESS
  
  Result is: SQL_SUCCESS
  
  Number of Columns is >1<
  
  ColumnName is >colName1<
  
  ColumnData is >colData1<
  
  Results Found for >NE0017678<
  
  Fetched Column Name is >NAME_FULL_FORMATTED<
  
  Fetched Row Data for that Column >Taylor, Edward J<
  
  RESULTS found is > Taylor, Edward J <
  
  FreeHandle : SQL_SUCCESS
  
  Disconnect : SQL_SUCCESS
  
  FreeHandle SQL_HANDLE_DBC : SQL_SUCCESS
  
  FreeHandle SQL_HANDLE_ENV : SQL_SUCCESS
  
  Send back message is: >{Taylor, Edward J}<
  
  Next time resending the same message:
  
  State code found is: NE
  
  ##### orc_12_id_length is gt 2
  
  ##### found the lisc_id and ready to call query
- March 22, 2011 at 3:33 pm #73929
  John Mercogliano
  Participant
  Where are you calling this code from, you need to look at your braces.
  
  John Mercogliano
  Semi Retired, contractor
  Hampton Roads, VA
- March 23, 2011 at 11:14 am #73930
  Mike Campbell
  Participant
  Good catch John. That fixed the issue.
  
  [Dang braces anyway!]
Author

Replies

Viewing 8 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.