| Author |
Message
|
| nukalas2010 |
 Posted: Wed Sep 18, 2013 4:12 am Post subject: Unable to get data from SQL Server 2012 |
 |
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
Dears,
We are not able to get the data from the Stored Procedure (SP) while executing it from Broker. But the same SP is working from the Database directly using SQLserver.
Broker Version: 7.0.0.4
SQL Server Version: '11.00.3000'
Below is the odbc.ini configuration:
| Quote: |
;# Unix to SQLServer stanza
[XXXDEVDB]
Driver= /opt/IBM/mqsi/7.0/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 SQL Server Wire Protocol
Address=XXX.XX.XX.XX,1203
;#Alternative way to locate server using a named instance
;#Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=XXXXXDB
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0 |
below ist he output for mqsicvp <Brokername> -n XXXDEVDB
| Quote: |
BIP8270I: Connected to Datasource 'XXXDEVDB' as user 'XXXXXUSR'. The datasource platform is 'Microsoft SQL Server', version '11.00.3000'.
===========================
databaseProviderVersion = 11.00.3000
driverVersion = 06.00.0150 (b0102, U0089)
driverOdbcVersion = 03.52
driverManagerVersion = 3.52.0000
driverManagerOdbcVersion = 03.52.0000
databaseProviderName = Microsoft SQL Server
datasourceServerName = XXXXXXXSRV
databaseName = XXXXXDB
odbcDatasourceName = XXXDEVDB
driverName = UKmsss24.so
supportsStoredProcedures = Yes
procedureTerm = stored procedure
accessibleTables = Yes
accessibleProcedures = Yes
identifierQuote =
specialCharacters = None
describeParameter = Yes
schemaTerm = owner
tableTerm = table
sqlSubqueries = 31
activeEnvironments = 0
maxDriverConnections = 0
maxCatalogNameLength = 128
maxColumnNameLength = 128
maxSchemaNameLength = 128
maxStatementLength = 524288
maxTableNameLength = 128
supportsDecimalType = Yes
supportsDateType = Yes
supportsTimeType = No
supportsTimeStampType = Yes
supportsIntervalType = No
supportsAbsFunction = Yes
supportsAcosFunction = Yes
supportsAsinFunction = Yes
supportsAtanFunction = Yes
supportsAtan2Function = Yes
supportsCeilingFunction = Yes
supportsCosFunction = Yes
supportsCotFunction = Yes
supportsDegreesFunction = Yes
supportsExpFunction = Yes
supportsFloorFunction = Yes
supportsLogFunction = Yes
supportsLog10Function = Yes
supportsModFunction = Yes
supportsPiFunction = Yes
supportsPowerFunction = Yes
supportsRadiansFunction = Yes
supportsRandFunction = Yes
supportsRoundFunction = Yes
supportsSignFunction = Yes
supportsSinFunction = Yes
supportsSqrtFunction = Yes
supportsTanFunction = Yes
supportsTruncateFunction = Yes
supportsConcatFunction = Yes
supportsInsertFunction = Yes
supportsLcaseFunction = Yes
supportsLeftFunction = Yes
supportsLengthFunction = Yes
supportsLTrimFunction = Yes
supportsPositionFunction = No
supportsRepeatFunction = Yes
supportsReplaceFunction = Yes
supportsRightFunction = Yes
supportsRTrimFunction = Yes
supportsSpaceFunction = Yes
supportsSubstringFunction = Yes
supportsUcaseFunction = Yes
supportsExtractFunction = Yes
supportsCaseExpression = Yes
supportsCastFunction = Yes
supportsCoalesceFunction = Yes
supportsNullIfFunction = Yes
supportsConvertFunction = Yes
supportsSumFunction = Yes
supportsMaxFunction = Yes
supportsMinFunction = Yes
supportsCountFunction = Yes
supportsBetweenPredicate = No
supportsExistsPredicate = Yes
supportsInPredicate = No
supportsLikePredicate = No
supportsNullPredicate = Yes
supportsNotNullPredicate = Yes
supportsLikeEscapeClause = Yes
supportsClobType = No
supportsBlobType = No
charDatatypeName = char
varCharDatatypeName = varchar
longVarCharDatatypeName = varchar(max)
clobDatatypeName = N/A
timeStampDatatypeName = datetime
binaryDatatypeName = binary
varBinaryDatatypeName = varbinary
longVarBinaryDatatypeName = varbinary(max)
blobDatatypeName = N/A
intDatatypeName = int
doubleDatatypeName = N/A
varCharMaxLength = 8000
longVarCharMaxLength = 2147483647
clobMaxLength = 0
varBinaryMaxLength = 8000
longVarBinaryMaxLength = 2147483647
blobMaxLength = 0
timeStampMaxLength = 23
identifierCase = Mixed
escapeCharacter = \
longVarCharDatatype = -1
clobDatatype = 0
longVarBinaryDatatype = -4
blobDatatype = 0
BIP8273I: The following datatypes and functions are not natively supported by datasource 'XXXDEVDB' using this ODBC driver: Unsupported datatypes: 'TIME, INTERVAL, CLOB, BLOB' Unsupported functions: 'POSITION, BETWEEN, IN, LIKE'
Examine the specific datatypes and functions not supported natively by this datasource using this ODBC driver.
When using these datatypes and functions within ESQL, the associated data processing is done within WebSphere Message Broker rather than being processed by the database provider.
Note that "functions" within this message can refer to functions or predicates. |
Below is the Sample Code:
| Code: |
CREATE COMPUTE MODULE TestDB_AA_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL GetNewCustomerProfile('Fals',50,Environment.Variables.GetAccProfile[]);
DECLARE cMsgs INTEGER;
SET cMsgs = CARDINALITY(Environment.Variables.GetAccProfile[]);
SET Environment.Variables.Count = cMsgs;
RETURN TRUE;
END;
CREATE PROCEDURE GetNewCustomerProfile(IN FailedRec CHARACTER, IN XMLNode INTEGER)
LANGUAGE DATABASE
DYNAMIC RESULT SETS 1
EXTERNAL NAME "dbo.SDB_XXXXXXXX_GET_NEW_ACCOUNTPROFILE";
END MODULE; |
Output:
| Code: |
| Environment.Variables.Count = 0 |
But the same SP if we are executing from SqlServer as
| Code: |
| exec dbo.SDB_AIRARABIA_GET_NEW_ACCOUNTPROFILE 'Fals', 50 |
we are getting data...
Below is the Usertrace:
| Quote: |
2013-09-18 15:57:13.003893 3357 UserTrace BIP2537I: Node 'TestDB_AA.Compute': Executing statement ''GetNewCustomerProfile('Fals', 50, Environment.V
ariables.GetAccProfile[ ]);'' at ('.TestDB_AA_Compute.Main', '4.4').
2013-09-18 15:57:13.003917 3357 UserTrace BIP2538I: Node 'TestDB_AA.Compute': Evaluating expression ''GetNewCustomerProfile('Fals', 50, Environment.V
ariables.GetAccProfile[ ])'' at ('.TestDB_AA_Compute.Main', '4.9').
2013-09-18 15:57:13.333807 3357 UserTrace BIP2562I: Node 'TestDB_AA.Compute': Assigning a list to ''Environment.Variables.GetAccProfile[]''.
2013-09-18 15:57:13.334851 3357 UserTrace BIP2544I: Node 'TestDB_AA.Compute': Executing database SQL statement ''{ CALL dbo.SDB_AIRARABIA_GET_NEW_ACC
OUNTPROFILE ( ? , ? ) }'' derived from ('.TestDB_AA_Compute.GetNewCustomerProfile', '1.2'); expressions '''Fals', 50''; resulting parameter values '''Fals
', 50''.
2013-09-18 15:57:13.334906 3357 UserTrace BIP2537I: Node 'TestDB_AA.Compute': Executing statement ''DECLARE cMsgs INTEGER;'' at ('.TestDB_AA_Comput
e.Main', '6.4').
2013-09-18 15:57:13.334938 3357 UserTrace BIP2537I: Node 'TestDB_AA.Compute': Executing statement ''SET cMsgs = CARDINALITY(Environment.Variables.G
etAccProfile[ ]);'' at ('.TestDB_AA_Compute.Main', '7.4').
2013-09-18 15:57:13.334969 3357 UserTrace BIP2543I: Node 'TestDB_AA.Compute': ('.TestDB_AA_Compute.Main', '7.28') : Failed to navigate to path elemen
t number '3' because it does not exist.
2013-09-18 15:57:13.335003 3357 UserTrace BIP2539I: Node 'TestDB_AA.Compute': Evaluating expression ''Environment.Variables.GetAccProfile[ ]'' at ('.
TestDB_AA_Compute.Main', '7.28'). This resolved to ''Environment.Variables.GetAccProfile[]''. The result was ''EMPTY LIST''.
2013-09-18 15:57:13.335027 3357 UserTrace BIP2540I: Node 'TestDB_AA.Compute': Finished evaluating expression ''CARDINALITY(Environment.Variables.GetA
ccProfile[ ])'' at ('.TestDB_AA_Compute.Main', '7.16'). The result was ''0''. |
Can anyone throw some light on this...
Thanks, |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Sep 18, 2013 4:18 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Wed Sep 18, 2013 4:50 am Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| lancelotlinc wrote: |
| When you turn on ODBC trace, what do you see ? Is the signature of the Stored Proc correct ? |
ODBC Trace as follows :
| Quote: |
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f26de [ -3] "XXXDEVDB"
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f272e [ -3] "XXXXUSR"
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: UCHAR * 0xa28a2308 [ -3] "******"
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: EXIT SQLConnect with return code 1 (SQL_SUCCESS_WITH_INFO)
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f26de [ -3] "XXXDEVDB"
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f272e [ -3] "XXXXVUSR"
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: UCHAR * 0xa28a2308 [ -3] "******"
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectOption
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: UWORD 1041
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: UDWORD 165239156
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: UWORD 1041
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: UDWORD 165239156
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectOption
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: UWORD 1042
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: UDWORD 165239168
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: UWORD 1042
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: UDWORD 165239168
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: PTR 0x17dc78a0
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: SWORD 64
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc7876
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: PTR 0x17dc78a0 [ 20] "Microsoft SQL Server"
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: SWORD 64
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc7876 (20)
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectAttr
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLHDBC 0x1534d6b0
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLINTEGER 1061
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLPOINTER [Unknown attribute 1061]
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLINTEGER 0
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLHDBC 0x1534d6b0
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLINTEGER 1061
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLPOINTER [Unknown attribute 1061]
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLINTEGER 0
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: UWORD 77 <SQL_DRIVER_ODBC_VER>
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: UWORD 77 <SQL_DRIVER_ODBC_VER>
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 5] "03.52"
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (5)
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: UWORD 7 <SQL_DRIVER_VER>
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: UWORD 7 <SQL_DRIVER_VER>
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 25] "06.00.0150 (b0102, U0089)"
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (25)
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: UWORD 10 <SQL_ODBC_VER>
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: UWORD 10 <SQL_ODBC_VER>
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 10] "03.52.0000"
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (10)
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: UWORD 16 <SQL_DATABASE_NAME>
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: UWORD 16 <SQL_DATABASE_NAME>
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 8] "XXXXDB"
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 20] "Microsoft SQL Server"
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (20)
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: UWORD 18 <SQL_DBMS_VER>
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: UWORD 18 <SQL_DBMS_VER>
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 10] "11.00.3000"
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (10)
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: UWORD 2 <SQL_DATA_SOURCE_NAME>
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: UWORD 2 <SQL_DATA_SOURCE_NAME>
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 8] "CTSDEVDB" |
We are sure both the SP's are same..
Thanks, |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Sep 18, 2013 5:00 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Your ODBC trace stops short.
You are also misunderstanding the point about the SP signature.
The signature of the SP is important.
If it does not match, then you won't be able to invoke it.
Apparently the trace shows the fact that you are not invoking it.
| Code: |
Database routine example 4
The following ESQL code demonstrates how to define and call SQL Server stored procedures:
ESQL Definition:
DECLARE inputParm CHARACTER;
DECLARE outputParm CHARACTER;
DECLARE inputOutputParm CHARACTER;
SET inputParm = 'Hello';
SET inputOutputParm = 'World';
CALL swapParms( inputParm, outputParm, inputOutputParm );
CREATE PROCEDURE swapParms (
IN parm1 CHARACTER,
INOUT parm2 CHARACTER,
INOUT parm3 CHARACTER
)
LANGUAGE DATABASE
EXTERNAL NAME dbSwapParms;
To register this stored procedure with SQL Server, copy the following script to a file (for example, test1.sql)
-- SQLServer Example Stored Procedure
DROP PROCEDURE dbSwapParms
go
CREATE PROCEDURE dbSwapParms
@in_param CHAR(32),
@out_param CHAR(32) OUT,
@inout_param CHAR(32) OUT
AS
SET NOCOUNT ON
SET @out_param = @inout_param
SET @inout_param = @in_param
go
Now run file:
isql -UuserID -Ppassword -Sserver -ddatasource -itest1.sql |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Wed Sep 18, 2013 5:30 am Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| lancelotlinc wrote: |
Your ODBC trace stops short.
You are also misunderstanding the point about the SP signature.
The signature of the SP is important.
If it does not match, then you won't be able to invoke it.
Apparently the trace shows the fact that you are not invoking it.
|
Sirrrrrr.... The trace file is too big to copy here.. so copied only necessary information...  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Sep 18, 2013 5:39 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| nukalas2010 wrote: |
| lancelotlinc wrote: |
Your ODBC trace stops short.
You are also misunderstanding the point about the SP signature.
The signature of the SP is important.
If it does not match, then you won't be able to invoke it.
Apparently the trace shows the fact that you are not invoking it.
|
Sirrrrrr.... The trace file is too big to copy here.. so copied only necessary information... |
We would want to see what the query that was sent to SQLServer was and how many rows was returned by SQLServer or the SQLError code, which might have been 'SP not found'.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Wed Sep 18, 2013 5:57 am Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
Ok.. here is the complete ODBCTrace for reference.. "CTSDEVDB" is the DSN name to search.
[code:1:4c9f3df5e5]
2013-09-18 16:40:17.043290 ppid=9306318:pid=14418132:1a1c: ENTER SQLAllocEnv
2013-09-18 16:40:17.043290 ppid=9306318:pid=14418132:1a1c: HENV * 0x151f30b0
2013-09-18 16:40:17.044030 ppid=9306318:pid=14418132:1a1c: EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.044030 ppid=9306318:pid=14418132:1a1c: HENV * 0x151f30b0 ( 0x00000001)
2013-09-18 16:40:17.044072 ppid=9306318:pid=14418132:1a1c: ENTER SQLSetEnvAttr
2013-09-18 16:40:17.044072 ppid=9306318:pid=14418132:1a1c: SQLHENV 0x15203370
2013-09-18 16:40:17.044072 ppid=9306318:pid=14418132:1a1c: SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
2013-09-18 16:40:17.044072 ppid=9306318:pid=14418132:1a1c: SQLPOINTER 3
2013-09-18 16:40:17.044072 ppid=9306318:pid=14418132:1a1c: SQLINTEGER 0
2013-09-18 16:40:17.044152 ppid=9306318:pid=14418132:1a1c: EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.044152 ppid=9306318:pid=14418132:1a1c: SQLHENV 0x15203370
2013-09-18 16:40:17.044152 ppid=9306318:pid=14418132:1a1c: SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
2013-09-18 16:40:17.044152 ppid=9306318:pid=14418132:1a1c: SQLPOINTER 3
2013-09-18 16:40:17.044152 ppid=9306318:pid=14418132:1a1c: SQLINTEGER 0
2013-09-18 16:40:17.231464 ppid=9306318:pid=14418132:1618: ENTER SQLAllocConnect
2013-09-18 16:40:17.231464 ppid=9306318:pid=14418132:1618: HENV 0x17e0a730
2013-09-18 16:40:17.231464 ppid=9306318:pid=14418132:1618: HDBC * 0x1527dda0
2013-09-18 16:40:17.231539 ppid=9306318:pid=14418132:1618: EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.231539 ppid=9306318:pid=14418132:1618: HENV 0x17e0a730
2013-09-18 16:40:17.231539 ppid=9306318:pid=14418132:1618: HDBC * 0x1527dda0 ( 0x00000001)
2013-09-18 16:40:17.231593 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectOption
2013-09-18 16:40:17.231593 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.231593 ppid=9306318:pid=14418132:1618: UWORD 102
2013-09-18 16:40:17.231593 ppid=9306318:pid=14418132:1618: UDWORD 0
2013-09-18 16:40:17.231698 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.231698 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.231698 ppid=9306318:pid=14418132:1618: UWORD 102
2013-09-18 16:40:17.231698 ppid=9306318:pid=14418132:1618: UDWORD 0
2013-09-18 16:40:17.231789 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectOption
2013-09-18 16:40:17.231789 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.231789 ppid=9306318:pid=14418132:1618: UWORD 2535
2013-09-18 16:40:17.231789 ppid=9306318:pid=14418132:1618: UDWORD 0
2013-09-18 16:40:17.231853 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.231853 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.231853 ppid=9306318:pid=14418132:1618: UWORD 2535
2013-09-18 16:40:17.231853 ppid=9306318:pid=14418132:1618: UDWORD 0
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: ENTER SQLConnect
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f26de [ -3] "CTSDEVDB"
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f272e [ -3] "EAISRVUSR"
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: UCHAR * 0xa28a2308 [ -3] "******"
2013-09-18 16:40:17.231926 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: EXIT SQLConnect with return code 1 (SQL_SUCCESS_WITH_INFO)
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f26de [ -3] "CTSDEVDB"
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: UCHAR * 0x171f272e [ -3] "EAISRVUSR"
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: UCHAR * 0xa28a2308 [ -3] "******"
2013-09-18 16:40:17.255847 ppid=9306318:pid=14418132:1618: SWORD -3
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectOption
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: UWORD 1041
2013-09-18 16:40:17.256043 ppid=9306318:pid=14418132:1618: UDWORD 165239156
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: UWORD 1041
2013-09-18 16:40:17.256155 ppid=9306318:pid=14418132:1618: UDWORD 165239156
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectOption
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: UWORD 1042
2013-09-18 16:40:17.256221 ppid=9306318:pid=14418132:1618: UDWORD 165239168
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: UWORD 1042
2013-09-18 16:40:17.256292 ppid=9306318:pid=14418132:1618: UDWORD 165239168
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: PTR 0x17dc78a0
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: SWORD 64
2013-09-18 16:40:17.256367 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc7876
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: PTR 0x17dc78a0 [ 20] "Microsoft SQL Server"
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: SWORD 64
2013-09-18 16:40:17.256499 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc7876 (20)
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: ENTER SQLSetConnectAttr
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLHDBC 0x1534d6b0
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLINTEGER 1061
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLPOINTER [Unknown attribute 1061]
2013-09-18 16:40:17.256745 ppid=9306318:pid=14418132:1618: SQLINTEGER 0
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLHDBC 0x1534d6b0
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLINTEGER 1061
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLPOINTER [Unknown attribute 1061]
2013-09-18 16:40:17.256858 ppid=9306318:pid=14418132:1618: SQLINTEGER 0
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: UWORD 77 <SQL_DRIVER_ODBC_VER>
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257162 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: UWORD 77 <SQL_DRIVER_ODBC_VER>
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 5] "03.52"
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257261 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (5)
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: UWORD 7 <SQL_DRIVER_VER>
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257367 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: UWORD 7 <SQL_DRIVER_VER>
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 25] "06.00.0150 (b0102, U0089)"
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257482 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (25)
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: UWORD 10 <SQL_ODBC_VER>
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257606 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: UWORD 10 <SQL_ODBC_VER>
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 10] "03.52.0000"
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257718 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (10)
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: UWORD 16 <SQL_DATABASE_NAME>
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257840 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: UWORD 16 <SQL_DATABASE_NAME>
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 8] "SELECTDB"
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.257936 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (8)
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258043 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: UWORD 17 <SQL_DBMS_NAME>
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 20] "Microsoft SQL Server"
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258140 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (20)
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: UWORD 18 <SQL_DBMS_VER>
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258248 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: UWORD 18 <SQL_DBMS_VER>
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 10] "11.00.3000"
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258364 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (10)
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: UWORD 2 <SQL_DATA_SOURCE_NAME>
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258472 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: UWORD 2 <SQL_DATA_SOURCE_NAME>
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 8] "CTSDEVDB"
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258583 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (8)
2013-09-18 16:40:17.258691 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258691 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258691 ppid=9306318:pid=14418132:1618: UWORD 171 <SQL_DM_VER>
2013-09-18 16:40:17.258691 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258691 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258691 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258786 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258786 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258786 ppid=9306318:pid=14418132:1618: UWORD 171 <SQL_DM_VER>
2013-09-18 16:40:17.258786 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 9] "3.52.0000"
2013-09-18 16:40:17.258786 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258786 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (9)
2013-09-18 16:40:17.258892 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.258892 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258892 ppid=9306318:pid=14418132:1618: UWORD 6 <SQL_DRIVER_NAME>
2013-09-18 16:40:17.258892 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.258892 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258892 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.258992 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.258992 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.258992 ppid=9306318:pid=14418132:1618: UWORD 6 <SQL_DRIVER_NAME>
2013-09-18 16:40:17.258992 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 11] "UKmsss24.so"
2013-09-18 16:40:17.258992 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.258992 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (11)
2013-09-18 16:40:17.259099 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.259099 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259099 ppid=9306318:pid=14418132:1618: UWORD 13 <SQL_SERVER_NAME>
2013-09-18 16:40:17.259099 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.259099 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.259099 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.259198 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.259198 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259198 ppid=9306318:pid=14418132:1618: UWORD 13 <SQL_SERVER_NAME>
2013-09-18 16:40:17.259198 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 14] "CTSTESTDBVMSRV"
2013-09-18 16:40:17.259198 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.259198 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (14)
2013-09-18 16:40:17.259348 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.259348 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259348 ppid=9306318:pid=14418132:1618: UWORD 116 <SQL_ACTIVE_ENVIRONMENTS>
2013-09-18 16:40:17.259348 ppid=9306318:pid=14418132:1618: PTR 36648
2013-09-18 16:40:17.259348 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.259348 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.259440 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.259440 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259440 ppid=9306318:pid=14418132:1618: UWORD 116 <SQL_ACTIVE_ENVIRONMENTS>
2013-09-18 16:40:17.259440 ppid=9306318:pid=14418132:1618: PTR 36648
2013-09-18 16:40:17.259440 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.259440 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.259542 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.259542 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259542 ppid=9306318:pid=14418132:1618: UWORD 0 <SQL_ACTIVE_CONNECTIONS>
2013-09-18 16:40:17.259542 ppid=9306318:pid=14418132:1618: PTR 36650
2013-09-18 16:40:17.259542 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.259542 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.259634 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.259634 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259634 ppid=9306318:pid=14418132:1618: UWORD 0 <SQL_ACTIVE_CONNECTIONS>
2013-09-18 16:40:17.259634 ppid=9306318:pid=14418132:1618: PTR 36650
2013-09-18 16:40:17.259634 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.259634 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.259735 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.259735 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259735 ppid=9306318:pid=14418132:1618: UWORD 21 <SQL_PROCEDURES>
2013-09-18 16:40:17.259735 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.259735 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.259735 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.259846 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.259846 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259846 ppid=9306318:pid=14418132:1618: UWORD 21 <SQL_PROCEDURES>
2013-09-18 16:40:17.259846 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 1] "Y"
2013-09-18 16:40:17.259846 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.259846 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (1)
2013-09-18 16:40:17.259958 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.259958 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.259958 ppid=9306318:pid=14418132:1618: UWORD 40 <SQL_PROCEDURE_TERM>
2013-09-18 16:40:17.259958 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.259958 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.259958 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.260531 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.260531 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.260531 ppid=9306318:pid=14418132:1618: UWORD 40 <SQL_PROCEDURE_TERM>
2013-09-18 16:40:17.260531 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 16] "stored procedure"
2013-09-18 16:40:17.260531 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.260531 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (16)
2013-09-18 16:40:17.260642 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.260642 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.260642 ppid=9306318:pid=14418132:1618: UWORD 20 <SQL_ACCESSIBLE_PROCEDURES>
2013-09-18 16:40:17.260642 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.260642 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.260642 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.260739 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.260739 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.260739 ppid=9306318:pid=14418132:1618: UWORD 20 <SQL_ACCESSIBLE_PROCEDURES>
2013-09-18 16:40:17.260739 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 1] "Y"
2013-09-18 16:40:17.260739 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.260739 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (1)
2013-09-18 16:40:17.260848 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.260848 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.260848 ppid=9306318:pid=14418132:1618: UWORD 19 <SQL_ACCESSIBLE_TABLES>
2013-09-18 16:40:17.260848 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.260848 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.260848 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.260946 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.260946 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.260946 ppid=9306318:pid=14418132:1618: UWORD 19 <SQL_ACCESSIBLE_TABLES>
2013-09-18 16:40:17.260946 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 1] "Y"
2013-09-18 16:40:17.260946 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.260946 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (1)
2013-09-18 16:40:17.261054 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.261054 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261054 ppid=9306318:pid=14418132:1618: UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
2013-09-18 16:40:17.261054 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.261054 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.261054 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.261166 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.261166 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261166 ppid=9306318:pid=14418132:1618: UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
2013-09-18 16:40:17.261166 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 1] " "
2013-09-18 16:40:17.261166 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.261166 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (1)
2013-09-18 16:40:17.261274 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.261274 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261274 ppid=9306318:pid=14418132:1618: UWORD 10002 <SQL_DESCRIBE_PARAMETER>
2013-09-18 16:40:17.261274 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.261274 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.261274 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.261371 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.261371 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261371 ppid=9306318:pid=14418132:1618: UWORD 10002 <SQL_DESCRIBE_PARAMETER>
2013-09-18 16:40:17.261371 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 1] "Y"
2013-09-18 16:40:17.261371 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.261371 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (1)
2013-09-18 16:40:17.261481 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.261481 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261481 ppid=9306318:pid=14418132:1618: UWORD 95 <SQL_SUBQUERIES>
2013-09-18 16:40:17.261481 ppid=9306318:pid=14418132:1618: PTR 0x15388f68
2013-09-18 16:40:17.261481 ppid=9306318:pid=14418132:1618: SWORD 4
2013-09-18 16:40:17.261481 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.261574 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.261574 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261574 ppid=9306318:pid=14418132:1618: UWORD 95 <SQL_SUBQUERIES>
2013-09-18 16:40:17.261574 ppid=9306318:pid=14418132:1618: PTR 0x15388f68
2013-09-18 16:40:17.261574 ppid=9306318:pid=14418132:1618: SWORD 4
2013-09-18 16:40:17.261574 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.261677 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.261677 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.261677 ppid=9306318:pid=14418132:1618: UWORD 39 <SQL_OWNER_TERM>
2013-09-18 16:40:17.261677 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.261677 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.261677 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.262067 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.262067 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.262067 ppid=9306318:pid=14418132:1618: UWORD 39 <SQL_OWNER_TERM>
2013-09-18 16:40:17.262067 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 5] "owner"
2013-09-18 16:40:17.262067 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.262067 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (5)
2013-09-18 16:40:17.262191 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.262191 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.262191 ppid=9306318:pid=14418132:1618: UWORD 45 <SQL_TABLE_TERM>
2013-09-18 16:40:17.262191 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240
2013-09-18 16:40:17.262191 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.262191 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4
2013-09-18 16:40:17.262579 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.262579 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.262579 ppid=9306318:pid=14418132:1618: UWORD 45 <SQL_TABLE_TERM>
2013-09-18 16:40:17.262579 ppid=9306318:pid=14418132:1618: PTR 0x17dc8240 [ 5] "table"
2013-09-18 16:40:17.262579 ppid=9306318:pid=14418132:1618: SWORD 256
2013-09-18 16:40:17.262579 ppid=9306318:pid=14418132:1618: SWORD * 0x17dc81c4 (5)
2013-09-18 16:40:17.262720 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.262720 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.262720 ppid=9306318:pid=14418132:1618: UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
2013-09-18 16:40:17.262720 ppid=9306318:pid=14418132:1618: PTR 36304
2013-09-18 16:40:17.262720 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.262720 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.262814 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.262814 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.262814 ppid=9306318:pid=14418132:1618: UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
2013-09-18 16:40:17.262814 ppid=9306318:pid=14418132:1618: PTR 36304
2013-09-18 16:40:17.262814 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.262814 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.262925 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.262925 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.262925 ppid=9306318:pid=14418132:1618: UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
2013-09-18 16:40:17.262925 ppid=9306318:pid=14418132:1618: PTR 36306
2013-09-18 16:40:17.262925 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.262925 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263017 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.263017 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263017 ppid=9306318:pid=14418132:1618: UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
2013-09-18 16:40:17.263017 ppid=9306318:pid=14418132:1618: PTR 36306
2013-09-18 16:40:17.263017 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.263017 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263129 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.263129 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263129 ppid=9306318:pid=14418132:1618: UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
2013-09-18 16:40:17.263129 ppid=9306318:pid=14418132:1618: PTR 36308
2013-09-18 16:40:17.263129 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.263129 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263236 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.263236 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263236 ppid=9306318:pid=14418132:1618: UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
2013-09-18 16:40:17.263236 ppid=9306318:pid=14418132:1618: PTR 36308
2013-09-18 16:40:17.263236 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.263236 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263348 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.263348 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263348 ppid=9306318:pid=14418132:1618: UWORD 105 <SQL_MAX_STATEMENT_LEN>
2013-09-18 16:40:17.263348 ppid=9306318:pid=14418132:1618: PTR 356027864
2013-09-18 16:40:17.263348 ppid=9306318:pid=14418132:1618: SWORD 4
2013-09-18 16:40:17.263348 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263440 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.263440 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263440 ppid=9306318:pid=14418132:1618: UWORD 105 <SQL_MAX_STATEMENT_LEN>
2013-09-18 16:40:17.263440 ppid=9306318:pid=14418132:1618: PTR 356027864
2013-09-18 16:40:17.263440 ppid=9306318:pid=14418132:1618: SWORD 4
2013-09-18 16:40:17.263440 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263550 ppid=9306318:pid=14418132:1618: ENTER SQLGetInfo
2013-09-18 16:40:17.263550 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263550 ppid=9306318:pid=14418132:1618: UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
2013-09-18 16:40:17.263550 ppid=9306318:pid=14418132:1618: PTR 36316
2013-09-18 16:40:17.263550 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.263550 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263643 ppid=9306318:pid=14418132:1618: EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.263643 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263643 ppid=9306318:pid=14418132:1618: UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
2013-09-18 16:40:17.263643 ppid=9306318:pid=14418132:1618: PTR 36316
2013-09-18 16:40:17.263643 ppid=9306318:pid=14418132:1618: SWORD 2
2013-09-18 16:40:17.263643 ppid=9306318:pid=14418132:1618: SWORD * 0x00000000
2013-09-18 16:40:17.263796 ppid=9306318:pid=14418132:1618: ENTER SQLAllocStmt
2013-09-18 16:40:17.263796 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263796 ppid=9306318:pid=14418132:1618: HSTMT * 0x17dc7f30
2013-09-18 16:40:17.263892 ppid=9306318:pid=14418132:1618: EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.263892 ppid=9306318:pid=14418132:1618: HDBC 0x1534d6b0
2013-09-18 16:40:17.263892 ppid=9306318:pid=14418132:1618: HSTMT * 0x17dc7f30 ( 0x00000001)
2013-09-18 16:40:17.263979 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.263979 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.263979 ppid=9306318:pid=14418132:1618: SWORD 9 <SQL_DATE>
2013-09-18 16:40:17.266090 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.266090 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.266090 ppid=9306318:pid=14418132:1618: SWORD 9 <SQL_DATE>
2013-09-18 16:40:17.266152 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.266152 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.266208 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.266208 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.266246 ppid=9306318:pid=14418132:1618: ENTER SQLCloseCursor
2013-09-18 16:40:17.266246 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.266290 ppid=9306318:pid=14418132:1618: EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.266290 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.266343 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.266343 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.266343 ppid=9306318:pid=14418132:1618: SWORD 10 <SQL_TIME>
2013-09-18 16:40:17.268475 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.268475 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.268475 ppid=9306318:pid=14418132:1618: SWORD 10 <SQL_TIME>
2013-09-18 16:40:17.268529 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.268529 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.268564 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
2013-09-18 16:40:17.268564 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.268599 ppid=9306318:pid=14418132:1618: ENTER SQLCloseCursor
2013-09-18 16:40:17.268599 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.268635 ppid=9306318:pid=14418132:1618: EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.268635 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.268687 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.268687 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.268687 ppid=9306318:pid=14418132:1618: SWORD 11 <SQL_TIMESTAMP>
2013-09-18 16:40:17.271700 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.271700 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.271700 ppid=9306318:pid=14418132:1618: SWORD 11 <SQL_TIMESTAMP>
2013-09-18 16:40:17.271757 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.271757 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.271794 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.271794 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.271829 ppid=9306318:pid=14418132:1618: ENTER SQLCloseCursor
2013-09-18 16:40:17.271829 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.271881 ppid=9306318:pid=14418132:1618: EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.271881 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.271935 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.271935 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.271935 ppid=9306318:pid=14418132:1618: SWORD 105 <SQL_INTERVAL_MINUTE>
2013-09-18 16:40:17.273713 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.273713 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.273713 ppid=9306318:pid=14418132:1618: SWORD 105 <SQL_INTERVAL_MINUTE>
2013-09-18 16:40:17.273765 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.273765 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.273800 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
2013-09-18 16:40:17.273800 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.273835 ppid=9306318:pid=14418132:1618: ENTER SQLCloseCursor
2013-09-18 16:40:17.273835 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.273870 ppid=9306318:pid=14418132:1618: EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.273870 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.273922 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.273922 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.273922 ppid=9306318:pid=14418132:1618: SWORD 3 <SQL_DECIMAL>
2013-09-18 16:40:17.275518 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.275518 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.275518 ppid=9306318:pid=14418132:1618: SWORD 3 <SQL_DECIMAL>
2013-09-18 16:40:17.275572 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.275572 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.275607 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.275607 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.275642 ppid=9306318:pid=14418132:1618: ENTER SQLCloseCursor
2013-09-18 16:40:17.275642 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.275693 ppid=9306318:pid=14418132:1618: EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.275693 ppid=9306318:pid=14418132:1618: SQLHSTMT 0x15389170
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: ENTER SQLBindCol
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: UWORD 1
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: SWORD 1 <SQL_C_CHAR>
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: PTR 0x17dc8020
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: SQLLEN 1024
2013-09-18 16:40:17.275738 ppid=9306318:pid=14418132:1618: SQLLEN * 0x17dc7fc8
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: UWORD 1
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: SWORD 1 <SQL_C_CHAR>
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: PTR 0x17dc8020
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: SQLLEN 1024
2013-09-18 16:40:17.275849 ppid=9306318:pid=14418132:1618: SQLLEN * 0x17dc7fc8 (0)
2013-09-18 16:40:17.275958 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.275958 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.275958 ppid=9306318:pid=14418132:1618: SWORD 1 <SQL_CHAR>
2013-09-18 16:40:17.277202 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.277202 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.277202 ppid=9306318:pid=14418132:1618: SWORD 1 <SQL_CHAR>
2013-09-18 16:40:17.277255 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.277255 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.277297 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.277297 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.277341 ppid=9306318:pid=14418132:1618: ENTER SQLFreeStmt
2013-09-18 16:40:17.277341 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.277341 ppid=9306318:pid=14418132:1618: UWORD 0 <SQL_CLOSE>
2013-09-18 16:40:17.277425 ppid=9306318:pid=14418132:1618: EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.277425 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.277425 ppid=9306318:pid=14418132:1618: UWORD 0 <SQL_CLOSE>
2013-09-18 16:40:17.277477 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.277477 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.277477 ppid=9306318:pid=14418132:1618: SWORD -2 <SQL_BINARY>
2013-09-18 16:40:17.279384 ppid=9306318:pid=14418132:1618: EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.279384 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.279384 ppid=9306318:pid=14418132:1618: SWORD -2 <SQL_BINARY>
2013-09-18 16:40:17.279438 ppid=9306318:pid=14418132:1618: ENTER SQLFetch
2013-09-18 16:40:17.279438 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.279475 ppid=9306318:pid=14418132:1618: EXIT SQLFetch with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.279475 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.279515 ppid=9306318:pid=14418132:1618: ENTER SQLFreeStmt
2013-09-18 16:40:17.279515 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.279515 ppid=9306318:pid=14418132:1618: UWORD 0 <SQL_CLOSE>
2013-09-18 16:40:17.279575 ppid=9306318:pid=14418132:1618: EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
2013-09-18 16:40:17.279575 ppid=9306318:pid=14418132:1618: HSTMT 0x15389170
2013-09-18 16:40:17.279575 ppid=9306318:pid=14418132:1618: UWORD 0 <SQL_CLOSE>
2013-09-18 16:40:17.279625 ppid=9306318:pid=14418132:1618: ENTER SQLGetTypeInfo
2013-09-18 16:40:17.279625 ppid=9306318:pid=1 |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Sep 18, 2013 6:06 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
I don't see the name of your SP in the trace.
Did you try the "Database routine example 4" I posted above ? Does it work ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Wed Sep 18, 2013 10:43 pm Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| lancelotlinc wrote: |
I don't see the name of your SP in the trace.
Did you try the "Database routine example 4" I posted above ? Does it work ? |
Darling.. I didn't try the above sample.. But I tried to call another SP in same Database.. And it's working fine.. It's testing my patience..  |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Sep 18, 2013 11:17 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
keep going.
I have found that Stored Procs in SQLServer are somewhat troublesome to get setup right compared to some other DB's. When I first started to use them, I experienced problems not too dissimilar to yours. Then suddenly, it clicked and was fine.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Thu Sep 19, 2013 12:34 am Post subject: |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
hmm... getting all silly doubts now..
Is SQL Server 2012 complicance for Broker 7.0.0.4 ???
Using the same SQL server driver for this also... UKmsss24.so
If it can't it should nt work for other DSN's on the same server, and other Sp's on the same database too.. but they are working fine..
 |
|
| Back to top |
|
|
| dogorsy |
| Posted: Thu Sep 19, 2013 1:01 am Post subject: Re: Unable to get data from SQL Server 2012 |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
the procedure name in the esql signature is different to the one you call from the sqlserver command line:
| Code: |
| EXTERNAL NAME "dbo.SDB_XXXXXXXX_GET_NEW_ACCOUNTPROFILE"; |
and
| Code: |
| exec dbo.SDB_AIRARABIA_GET_NEW_ACCOUNTPROFILE 'Fals', 50 |
and make sure your SQLServer stored procedure contains the following statement:
otherwise the stored procedure, apart from returning the result set, it also returns the number of records processed. |
|
| Back to top |
|
|
| nukalas2010 |
| Posted: Thu Sep 19, 2013 2:39 am Post subject: Re: Unable to get data from SQL Server 2012 |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| dogorsy wrote: |
the procedure name in the esql signature is different to the one you call from the sqlserver command line:
| Code: |
| EXTERNAL NAME "dbo.SDB_XXXXXXXX_GET_NEW_ACCOUNTPROFILE"; |
and
| Code: |
| exec dbo.SDB_AIRARABIA_GET_NEW_ACCOUNTPROFILE 'Fals', 50 |
|
It's just mistake while editing..
| dogorsy wrote: |
make sure your SQLServer stored procedure contains the following statement:
otherwise the stored procedure, apart from returning the result set, it also returns the number of records processed. |
yeah, my SP have this statement..
And I dnt want to break my head with this issue, so I am going to use direct SQL Statement for time being..
Thanks all of you for yr valuable time.. Thanks lance darling.. |
|
| Back to top |
|
|
| vani_cool |
| Posted: Wed Oct 09, 2013 4:50 pm Post subject: Re: Unable to get data from SQL Server 2012 |
|
|
Novice
Joined: 15 Jul 2009
Posts: 17
|
any response on this ?
We are also facing problems when calling a SP of SQL Server which returns a CURSOR.
Were u able to resolve this ? |
|
| Back to top |
|
|
|
|
