currentFunctionPath in DB2 UDB driver ignored by DB2?



IBM's flagship relational database management system

currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby stoked » Fri Mar 18, 2011 11:53 pm

Has anyone used the currentFunctionPath property in the DB2 UDB driver? It seems to be recognized by the driver and the connection is configured with the specified value but DB2 seems to ignore it.

Here's the trace file for one select. The trace shows the driver is definitely seeing the currentFunctionPath setting (line 53). It then executes the unqualified statement (line 155). It receives SQLCODE -204 (line 237). Finally, lines 379-380 seem to imply that the SQL command SET CURRENT FUNCTION PATH ="DB2TST6" was applied to the connection and the transport. The question is, did DB2 do anything with it? It doesn’t look like it. It looks to me like the problem lies with DB2 or DRDA rather than the driver.

[jcc] BEGIN TRACE_XML_CONFIGURATION_FILE
[jcc] dsdriverConfigFile=null

[jcc] BEGIN TRACE_DRIVER_CONFIGURATION
[jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 3.61.84
[jcc] Compatible JRE versions: { 1.4, 1.5, 1.6 }
[jcc] Target server licensing restrictions: { z/OS: enabled; SQLDS: enabled; iSeries: enabled; DB2 for Unix/Windows: enabled; Cloudscape: enabled; Informix: enabled }
[jcc] Range checking enabled: true
[jcc] Bug check level: 0xff
[jcc] Default fetch size: 64
[jcc] Default isolation: 2
[jcc] Collect performance statistics: false
[jcc] No security manager detected.
[jcc] Detected local client host: AMACHIN/661.345.936.669
[jcc] Access to package sun.io is permitted by security manager.
[jcc] JDBC 1 system property jdbc.drivers = null
[jcc] Java Runtime Environment version 1.5.0_24-rev
[jcc] Java Runtime Environment vendor = Sun Microsystems Inc.
[jcc] Java vendor URL = http://java.sun.com/
[jcc] Java installation directory = C:\Program Files\Java\jdk1.5.0_24\jre
[jcc] Java Virtual Machine specification version = 1.0
[jcc] Java Virtual Machine specification vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine specification name = Java Virtual Machine Specification
[jcc] Java Virtual Machine implementation version = 1.5.0_24-rev-b04
[jcc] Java Virtual Machine implementation vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine implementation name = Java HotSpot(TM) Client VM
[jcc] Java Runtime Environment specification version = 1.5
[jcc] Java Runtime Environment specification vendor = Sun Microsystems Inc.
[jcc] Java Runtime Environment specification name = Java Platform API Specification
[jcc] Java class format version number = 49.0
[jcc] Java class path = .;jjjjj.jar;lib\ojdbc14.jar;lib\log4j.jar;lib\db2jcc.jar;lib\db2jcc_license_cisuz.jar;lib\db2jcc_javax.jar
[jcc] Java native library path = C:\Program Files\Java\jdk1.5.0_24\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_24\bin;C:\Oracle9\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\ant\apache-ant-1.7.0;C:\Program Files\E!TCP\;C:\Program Files\TortoiseSVN\bin
[jcc] Path of extension directory or directories = C:\Program Files\Java\jdk1.5.0_24\jre\lib\ext
[jcc] Operating system name = Windows XP
[jcc] Operating system architecture = x86
[jcc] Operating system version = 5.1
[jcc] File separator ("/" on UNIX) = \
[jcc] Path separator (":" on UNIX) = ;
[jcc] User's account name = xyz1
[jcc] User's home directory = C:\Documents and Settings\xyz1
[jcc] User's current working directory = c:\data\jjjjj
[jcc] JCC outputDirectory = C:\Temp\
[jcc] Loaded global properties file: C:\Data\jjjjj\DB2JccConfiguration.properties
[jcc] Using global properties:
[jcc]   db2.jcc.traceFile = jccTrace_TableExample, file
[jcc]   db2.jcc.traceDirectory = C:/Data/jjjjj/Trace, file
[jcc]   db2.jcc.traceFileAppend = false, file
[jcc]   db2.jcc.traceLevel = -1, file
[jcc] Dumping all system properties: { java.runtime.name=Java(TM) Platform, Standard Edition for Business, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_24\jre\bin, java.vm.version=1.5.0_24-rev-b04, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=US, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=c:\data\jjjjj, java.runtime.version=1.5.0_24-rev-b04, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, db2.jcc.propertiesFile=C:/Data/jjjjj/DB2JccConfiguration.properties, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_24\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Temp\, line.separator=\r\n, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_24\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_24\bin;C:\Oracle9\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\ant\apache-ant-1.7.0;C:\Program Files\E!TCP\;C:\Program Files\TortoiseSVN\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\xyz1, user.timezone=America/Los_Angeles, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, java.class.path=.;jjjjj.jar;lib\ojdbc14.jar;lib\log4j.jar;lib\db2jcc.jar;lib\db2jcc_license_cisuz.jar;lib\db2jcc_javax.jar, user.name=xyz1, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_24\jre, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.5.0_24-rev, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_24\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_24\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_24\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86 }
[jcc] Dumping all file properties: { db2.jcc.traceFileAppend=false, db2.jcc.traceFile=jccTrace_TableExample, db2.jcc.traceDirectory=C:/Data/jjjjj/Trace, db2.jcc.traceLevel=-1 }
[jcc] pureQuery present = false
[jcc] END TRACE_DRIVER_CONFIGURATION
[jcc] BEGIN TRACE_CONNECTS
[jcc] Attempting connection to ABCD:6666/DB2SYS
[jcc] Using properties: { currentPackagePath=null, currentLockTimeout=-2147483647, timerLevelForQueryTimeOut=0, optimizationProfileToFlush=null, timeFormat=1, monitorPort=0, sendCharInputsUTF8=0, LOCKSSFU=null, sendDataAsIs=false, stripTrailingZerosForDecimalNumbers=0, returnAlias=1, supportsAsynchronousXARollback=2, sessionTimeZone=null, pkList=null, atomicMultiRowInsert=0, DEBUG=null, IFX_UPDDESC=1, traceDirectory=null, maxRowsetSize=32767, driverType=4, extendedDiagnosticLevel=240, accountingInterval=null, monitoredDataSourceName=null, concurrentAccessResolution=0, LKNOTIFY=yes, clientProgramName=null, connectNode=-1, progressiveStreaming=0, DBMAXPROC=null, INFORMIXSTACKSIZE=null, databaseName=DB2SYS, IFX_XASTDCOMPLIANCE_XAEND=null, decimalSeparator=0, DBPATH=., emulateParameterMetaDataForZCalls=0, decimalRoundingMode=-2147483647, serverName=ABCD, DUMPDIR=null, allowUnassignedParameters=0, streamBufferSize=1048576, STMT_CACHE_DEBUG=null, downgradeHoldCursorsUnderXa=false, currentRefreshAge=-9223372036854775807, kerberosServerPrincipal=null, DB_LOCALE=null, description=null, DUMPCORE=null, queryCloseImplicit=0, keepDynamic=0, PSORT_NPROCS=null, user=xyz1, connectionCloseWithInFlightTransaction=0, fullyMaterializeLobData=true, enableClientAffinitiesList=0, clientUser=null, portNumber=6666, resultSetHoldability=0, allowNextOnExhaustedResultSet=0, NOSORTINDEX=null, enableConnectionConcentrator=false, monitorServerName=null, STMT_CACHE=null, PSORT_DBTEMP=null, sqljEnableClassLoaderSpecificProfiles=false, clientAccountingInformation=null, IFX_EXTDIRECTIVES=null, clientProgramId=null, IFX_DIRECTIVES=null, enableSeamlessFailover=0, GCORE=null, SQLSTATS=null, LOCKDOWN=no, currentExplainMode=null, SORTINDEX=null, timestampFormat=5, retryIntervalForClientReroute=-1, password=****, updateCountForBatch=0, reportLongTypes=0, xaNetworkOptimization=true, plugin=null, pdqProperties=null, currentSchema=null, CR_LOCKBLOB=null, traceLevel=-1, enableRowsetSupport=0, clientDebugInfo=null, dataSourceName=null, enableAlternateServerListFirstConnect=0, maxRetriesForClientReroute=-1, fetchSize=-1, queryDataSize=0, clientRerouteAlternateServerName=null, DBTEMP=/tmp, enableT2zosLBF=0, SUBQCACHESZ=10, ssid=null, currentMaintainedTableTypesForOptimization=null, traceFile=null, currentExplainSnapshot=null, DBDATE=Y4MD-, SLABEL=null, enableMultirowInsertSupport=true, currentFunctionPath=db2tst6, monitorEnabled=0, enableNamedParameterMarkers=0, PDQPRIORITY=null, supportsRawDateTimeRetrieval=false, useCachedCursor=true, pluginName=null, charOutputSize=0, maxTransportObjects=2147483647, NOSHMSG=null, resultSetHoldabilityForCatalogQueries=0, monitorLevel=0, IFX_FLAT_UCSQ=null, affinityFailbackInterval=0, planName=null, SQL_FROM_DBIMPORT=null, interruptProcessingMode=1, floatingPointStringFormat=0, currentPackageSet=null, timestampPrecisionReporting=0, clientRerouteAlternatePortNumber=null, useTransactionRedirect=false, dateTimeMutation=false, securityMechanism=3, statementConcentrator=0, timestampOutputType=0, allowNullResultSetForExecuteQuery=0, sysSchema=null, decimalStringFormat=0, blockingReadConnectionTimeout=0, DBANSIWARN=false, sslTrustStorePassword=null, DELIMIDENT=false, clientWorkstation=null, currentQueryOptimization=-2147483647, clientApplicationInformation=null, DUMPSHMEM=null, translateForBitData=0, monitorCollectionInterval=0, sslTrustStoreLocation=null, optimizationProfile=null, retrieveMessagesFromServerOnGetMessage=false, readOnly=false, INFORMIXOPCACHE=null, useRowsetCursor=true, traceFileAppend=false, clientRerouteServerListJNDIName=null, enableSysplexWLB=false, useJDBC4ColumnNameAndLabelSemantics=0, recordTemporalHistory=0, NODEFDAC=no, sslConnection=false, dateFormat=1, OPTOFC=null, cliSchema=null, retryWithAlternativeSecurityMechanism=0, DBSPACETEMP=null, enableExtendedIndicators=0, PLOAD_LO_PATH=null, encryptionAlgorithm=0, DBUPSPACE=null, cursorSensitivity=0, jdbcCollection=NULLID, fullyMaterializeInputStreams=false, currentSQLID=null, loginTimeout=0, useIdentityValLocalForAutoGeneratedKeys=false, OPTCOMPIND=null, LIGHT_SCANS=null, defaultIsolationLevel=2, deferPrepares=true, currentDegree=null, DUMPMEM=null }
[jcc] END TRACE_CONNECTS
[jcc][t4] [time:2011-03-18-10:22:33.950][Thread:main][tracepoint:950]searching the server list cache for key ABCD:6666
[jcc][t4] [time:2011-03-18-10:22:34.013][Thread:main][tracepoint:315]creating a socket to ABCD at 10.44.21.40
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:1][Request.flush]
[jcc][t4]        SEND BUFFER: EXCSAT                 (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   009CD04100010096  10410048115E8482  ...A.....A.H.^..  ..}....o.....;db
[jcc][t4] 0010   F29183836D819797  93898381A3899695  ....m...........  2jcc_application
[jcc][t4] 0020   4040D1C3C3F0F3F6  F1F0F3F0F0000000  @@..............    JCC03610300...
[jcc][t4] 0030   0000000000000000  0000000000000000  ................  ................
[jcc][t4] 0040   0000000000000000  000000000060F0F0  .............`..  .............-00
[jcc][t4] 0050   F0F10016116DC1F1  F1F7F8F0F8404040  .....m.......@@@  01..._AMACHIN   
[jcc][t4] 0060   4040404040404040  000C115AD1C3C3F0  @@@@@@@@...Z....          ...!JCC0
[jcc][t4] 0070   F3F6F1F0001C1404  1403000A2407000A  ............$...  3610............
[jcc][t4] 0080   1C0804B8240F0008  1440000914740008  ....$....@...t..  ......... ......
[jcc][t4] 0090   000C1147D8C4C2F2  61D1E5D4          ...G....a...      ....QDB2/JVM   
[jcc][t4]
[jcc][t4]        SEND BUFFER: ACCSEC                 (ASCII)           (EBCDIC)
[jcc][t4] 0000   0026D00100020020  106D000611A20003  .&..... .m......  ..}......_...s..
[jcc][t4] 0010   00162110C3C1C9C3  C2C3C4C2F2F24040  ..!...........@@  ....DB2SYS 
[jcc][t4] 0020   404040404040                        @@@@@@                           
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:2][Reply.fill]
[jcc][t4]        RECEIVE BUFFER: EXCSATRD            (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   0092D0430001008C  14430044115EC4C2  ...C.....C.D.^..  .k}..........;DB
[jcc][t4] 0010   F2F24BC3C1C9C3C2  C3C4C2F2F2000000  ..K.............  22.DB2SYS...
[jcc][t4] 0020   0000000000000000  0000000000000000  ................  ................
[jcc][t4] 0030   0000000000000000  0000000000001800  ................  ................
[jcc][t4] 0040   0000000000000000  000000000000001C  ................  ................
[jcc][t4] 0050   1404140300072407  00071C080000240F  ......$.......$.  ................
[jcc][t4] 0060   0007144000071474  000500081147D8C4  ...@...t.....G..  ... ..........QD
[jcc][t4] 0070   C2F20014116DC3C1  C9C3C2C3C4C2F2F2  .....m..........  B2..._DB2SYS
[jcc][t4] 0080   404040404040000C  115AC4E2D5F0F9F0  @@@@@@...Z......        ...!DSN090
[jcc][t4] 0090   F1F0                                ..                10             
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: ACCSECRD            (ASCII)           (EBCDIC)
[jcc][t4] 0000   0010D0030002000A  14AC000611A20003  ................  ..}..........s..
[jcc][t4]
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:1][Request.flush]
[jcc][t4]        SEND BUFFER: SECCHK                 (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   003AD04100010034  106E000611A20003  .:.A...4.n......  ..}......>...s..
[jcc][t4] 0010   00162110C3C1C9C3  C2C3C4C2F2F24040  ..!...........@@  ....DB2SYS 
[jcc][t4] 0020   4040404040400008  11A09384F494000C  @@@@@@..........        ....xyz1..
[jcc][t4] 0030   11A15C5C5C5C5C5C  5C5C              ..\\\\\\\\        .~********     
[jcc][t4]
[jcc][t4]        SEND BUFFER: ACCRDB                 (ASCII)           (EBCDIC)
[jcc][t4] 0000   00C7D001000200C1  200100162110C3C1  ........ ...!...  .G}....A......CA
[jcc][t4] 0010   C9C3C2C3C4C2F2F2  4040404040404040  ........@@@@@@@@  ABCDDB22       
[jcc][t4] 0020   0006210F2407000C  112ED1C3C3F0F3F6  ..!.$...........  ..........JCC036
[jcc][t4] 0030   F1F0007221046DD1  C3C3F0F3F6F1F0C1  ...r!.m.........  10...._JCC03610A
[jcc][t4] 0040   F1F1F7F8F0F84040  4040404040404040  ......@@@@@@@@@@  117808         
[jcc][t4] 0050   408482F29183836D  81979793898381A3  @......m........   db2jcc_applicat
[jcc][t4] 0060   89969540409384F4  944040404036D1C3  ...@@....@@@@6..  ion  xyz1    .JC
[jcc][t4] 0070   C3F0F3F6F1F0C1F1  F1F7F8F0F8404040  .............@@@  C03610AMACHIN   
[jcc][t4] 0080   4040404040404040  4040404040404040  @@@@@@@@@@@@@@@@                 
[jcc][t4] 0090   4040404040404040  4040404040404040  @@@@@@@@@@@@@@@@                 
[jcc][t4] 00A0   40404040000D002F  D8E3C4E2D8D3C1E2  @@@@.../........      ....QTDSQLAS
[jcc][t4] 00B0   C300160035000611  9C04B80006119D04  ....5...........  C...............
[jcc][t4] 00C0   B00006119E04B8                      .......           .......         
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:34.169][Thread:main][tracepoint:2][Reply.fill]
[jcc][t4]        RECEIVE BUFFER: SECCHKRM            (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   0015D0420001000F  1219000611490000  ...B.........I..  ..}.............
[jcc][t4] 0010   000511A400                          .....             ...u.           
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: ACCRDBRM            (ASCII)           (EBCDIC)
[jcc][t4] 0000   00A0D0020002009A  2201000611490000  ........"....I..  ..}.............
[jcc][t4] 0010   000D002FD8E3C4E2  D8D3F3F7F0000C11  .../............  ....QTDSQL370...
[jcc][t4] 0020   2EC4E2D5F0F9F0F1  F000160035000611  ............5...  .DSN09010.......
[jcc][t4] 0030   9C04B80006119E04  B80006119D04B000  ................  ................
[jcc][t4] 0040   172135C7C1F2F2F8  F8F4F54BC8F0F7F4  .!5........K....  ...GA228845.H074
[jcc][t4] 0050   C77CF70C8B5A001E  244E0006244C0001  .|...Z..$N..$L..  G@7..!...+...<..
[jcc][t4] 0060   0014244D0006244F  FFFF000A11E80A2C  ..$M..$O.......,  ...(...|.....Y..
[jcc][t4] 0070   1528139D00222103  00000000128C9AE8  .(..."!.........  ...............Y
[jcc][t4] 0080   C7C1F2F2F8F8F4F5  C8F0F7F440404040  ............@@@@  GA228845H074   
[jcc][t4] 0090   C77CF70C8B5A000A  11E80A2C1528139E  .|...Z.....,.(..  G@7..!...Y......
[jcc][t4]
[jcc][Time:2011-03-18-10:22:34.169][Thread:main][Connection@14eaec9] getHostAddressFromIpaddr (6, { 0xa, 0x2c, 0x15, 0x28, 0x13, 0x9e }) called
[jcc][Time:2011-03-18-10:22:34.169][Thread:main][Connection@14eaec9] getHostAddressFromIpaddr () returned ABCD.ABCD.net
[jcc][Time:2011-03-18-10:22:34.185][Thread:main][Connection@14eaec9] setCurrentFunctionPath () called
[jcc][Connection@14eaec9] BEGIN TRACE_CONNECTS
[jcc][Connection@14eaec9] Successfully connected to server jdbc:db2://ABCD:6666/DB2SYS
[jcc][Connection@14eaec9] User: xyz1
[jcc][Connection@14eaec9] Database product name: DB2
[jcc][Connection@14eaec9] Database product version: DSN09010
[jcc][Connection@14eaec9] Driver name: IBM DB2 JDBC Universal Driver Architecture
[jcc][Connection@14eaec9] Driver version: 3.61.84
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] getDB2Correlator () returned GA228845.H074.C77CF70C8B5A
[jcc][Connection@14eaec9] DB2 Application Correlator: GA228845.H074.C77CF70C8B5A.0000
[jcc][Connection@14eaec9] END TRACE_CONNECTS
[jcc][t4]   DRDA manager levels: { SQLAM=7, AGENT=7, CMNTCPIP=5, RDB=7, SECMGR=7, XAMGR=7, SYNCPTMGR=7, RSYNCMGR=5 }
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] createStatement () called
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] createStatement () returned Statement@1295fe8
[jcc][SystemMonitor:start]
[jcc][Time:2011-03-18-10:22:45.434][Thread:AWT-EventQueue-0][Statement@1295fe8] executeQuery (select * from rpl_process ) called
[jcc] [t4][time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:1][Request.flush]
[jcc][t4]        SEND BUFFER: EXCSQLIMM              (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   005BD05100010055  200A00442113C3C1  .[.Q...U ..D!...  .$}...........CA
[jcc][t4] 0010   C9C3C2C3C4C2F2F2  4040404040404040  ........@@@@@@@@  ABCDDB22       
[jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID         
[jcc][t4] 0030   4040E2E8E2D3C8F2  F0F0404040404040  @@........@@@@@@    SYSLH200     
[jcc][t4] 0040   404040405359534C  564C303101810005  @@@@SYSLVL01....      ...<.<...a..
[jcc][t4] 0050   2105F10008190080  000000            !..........       ..1........     
[jcc][t4]
[jcc][t4]        SEND BUFFER: SQLSTT                 (ASCII)           (EBCDIC)
[jcc][t4] 0000   002AD04300010024  2414000000001A53  .*.C...$$......S  ..}.............
[jcc][t4] 0010   4554204355525245  4E54205041544820  ET CURRENT PATH   ........+..&....
[jcc][t4] 0020   3D20646232747374  36FF              = db2tst6.        ..........     
[jcc][t4]
[jcc][t4]        SEND BUFFER: PRPSQLSTT              (ASCII)           (EBCDIC)
[jcc][t4] 0000   0060D0510002005A  200D00442113C3C1  .`.Q...Z ..D!...  .-}....!......CA
[jcc][t4] 0010   C9C3C2C3C4C2F2F2  4040404040404040  ........@@@@@@@@  ABCDDB22       
[jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID         
[jcc][t4] 0030   4040E2E8E2D3C8F2  F0F0404040404040  @@........@@@@@@    SYSLH200     
[jcc][t4] 0040   404040405359534C  564C303100010005  @@@@SYSLVL01....      ...<.<......
[jcc][t4] 0050   2116F10005214604  0008190080000000  !....!F.........  ..1.............
[jcc][t4]
[jcc][t4]        SEND BUFFER: SQLATTR                (ASCII)           (EBCDIC)
[jcc][t4] 0000   001ED05300020018  2450000000000E46  ...S....$P.....F  ..}......&......
[jcc][t4] 0010   4F52205245414420  4F4E4C5920FF      OR READ ONLY .    |.......|+<... 
[jcc][t4]
[jcc][t4]        SEND BUFFER: SQLSTT                 (ASCII)           (EBCDIC)
[jcc][t4] 0000   002AD04300020024  2414000000001A73  .*.C...$$......s  ..}.............
[jcc][t4] 0010   656C656374202A20  66726F6D2072706C  elect * from rpl  .%........?_...%
[jcc][t4] 0020   5F70726F63657373  20FF              _process .        ...?......     
[jcc][t4]
[jcc][t4]        SEND BUFFER: OPNQRY                 (ASCII)           (EBCDIC)
[jcc][t4] 0000   0063D0010003005D  200C00442113C3C1  .c.....] ..D!...  ..}....)......CA
[jcc][t4] 0010   C9C3C2C3C4C2F2F2  4040404040404040  ........@@@@@@@@  ABCDDB22       
[jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID         
[jcc][t4] 0030   4040E2E8E2D3C8F2  F0F0404040404040  @@........@@@@@@    SYSLH200     
[jcc][t4] 0040   404040405359534C  564C303100010008  @@@@SYSLVL01....      ...<.<......
[jcc][t4] 0050   211400007FFF0005  215D030008190080  !.......!]......  ...."....)......
[jcc][t4] 0060   000000                              ...               ...             
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:45.481][Thread:AWT-EventQueue-0][tracepoint:2][Reply.fill]
[jcc][t4]        RECEIVE BUFFER: SQLCARD             (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   000BD05300010005  2408FF            ...S....$..       ..}........     
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: MONITORRD           (ASCII)           (EBCDIC)
[jcc][t4] 0000   0016D04300010010  1C00000C19010000  ...C............  ..}.............
[jcc][t4] 0010   0000000042BF                        ....B.            ......         
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: SQLDARD             (ASCII)           (EBCDIC)
[jcc][t4] 0000   0064D0530002005E  241100FFFFFF3434  .d.S...^$.....44  ..}....;........
[jcc][t4] 0010   3237303444534E58  4F544C2000FFFFFE  2704DSNXOTL ....  ......+.|.<.....
[jcc][t4] 0020   0C00000000000000  00FFFFFFFF000000  ................  ................
[jcc][t4] 0030   0000000000202020  2020202020202020  .....             ................
[jcc][t4] 0040   000A434149434243  4442323200104C44  ..DB2SYS..LD  ..............<.
[jcc][t4] 0050   344D2E52504C5F50  524F434553530000  4M.RPL_PROCESS..  .(..&<.&.|......
[jcc][t4] 0060   FFFF0000                            ....              ....           
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: MONITORRD           (ASCII)           (EBCDIC)
[jcc][t4] 0000   0016D04300020010  1C00000C19010000  ...C............  ..}.............
[jcc][t4] 0010   000000003A25                        ....:%            ......         
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: OPNQFLRM            (ASCII)           (EBCDIC)
[jcc][t4] 0000   0026D05200030020  2212000611490008  .&.R... "....I..  ..}.............
[jcc][t4] 0010   00162110C3C1C9C3  C2C3C4C2F2F24040  ..!...........@@  ....DB2SYS 
[jcc][t4] 0020   404040404040                        @@@@@@                           
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: SQLCARD             (ASCII)           (EBCDIC)
[jcc][t4] 0000   005FD00300030059  240800FFFFFDFE32  ._.....Y$......2  ..}.............
[jcc][t4] 0010   3635303144534E58  4552543200FFFFFE  6501DSNXERT2....  ......+.........
[jcc][t4] 0020   D000000000000000  00FFFFFFFF000000  ................  }...............
[jcc][t4] 0030   0000000000202020  2020202020202020  .....             ................
[jcc][t4] 0040   000A434149434243  44423232000E5351  ..DB2SYS..SQ  ................
[jcc][t4] 0050   4C5F4355524C4832  303043310000FF    L_CURLH200C1...   <....<.........
[jcc][t4]
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] java.sql.SQLException
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] DB2 SQLCA from server
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlCode        = -204
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrd        = { -500, 0, 0, -1, 0, 0 }
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrmc       = xyz1.RPL_PROCESS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrmcTokens = { xyz1.RPL_PROCESS }
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrp        = DSNXOTL
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlState       = 42704
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlWarn        =           
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] SQL state  = 42704
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Error code = -204
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Tokens     = xyz1.RPL_PROCESS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Stack trace follows
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=xyz1.RPL_PROCESS, DRIVER=3.61.84
   at com.ibm.db2.jcc.am.ed.a(ed.java:676)
   at com.ibm.db2.jcc.am.ed.a(ed.java:60)
   at com.ibm.db2.jcc.am.ed.a(ed.java:127)
   at com.ibm.db2.jcc.am.hn.c(hn.java:2554)
   at com.ibm.db2.jcc.am.hn.d(hn.java:2542)
   at com.ibm.db2.jcc.am.hn.a(hn.java:2034)
   at com.ibm.db2.jcc.am.hn.a(hn.java:2012)
   at com.ibm.db2.jcc.t4.cb.g(cb.java:135)
   at com.ibm.db2.jcc.t4.cb.a(cb.java:40)
   at com.ibm.db2.jcc.t4.q.a(q.java:32)
   at com.ibm.db2.jcc.t4.rb.i(rb.java:135)
   at com.ibm.db2.jcc.am.hn.gb(hn.java:2005)
   at com.ibm.db2.jcc.am.hn.a(hn.java:3029)
   at com.ibm.db2.jcc.am.hn.a(hn.java:667)
   at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:651)
   at com.ABCD.jjjjjapps.models.JDBCAdapter.executeQuery(JDBCAdapter.java:80)
   at com.ABCD.jjjjjapps.TableExample.fetch(TableExample.java:413)
   at com.ABCD.jjjjjapps.TableExample$2.actionPerformed(TableExample.java:110)
   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:246)
   at java.awt.Component.processMouseEvent(Component.java:5517)
   at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
   at java.awt.Component.processEvent(Component.java:5282)
   at java.awt.Container.processEvent(Container.java:1966)
   at java.awt.Component.dispatchEventImpl(Component.java:3984)
   at java.awt.Container.dispatchEventImpl(Container.java:2024)
   at java.awt.Component.dispatchEvent(Component.java:3819)
   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
   at java.awt.Container.dispatchEventImpl(Container.java:2010)
   at java.awt.Window.dispatchEventImpl(Window.java:1791)
   at java.awt.Component.dispatchEvent(Component.java:3819)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
   at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[jcc] END TRACE_DIAGNOSTICS
[jcc][ResultSetMetaData@1c18a4c] BEGIN TRACE_RESULT_SET_META_DATA
[jcc][ResultSetMetaData@1c18a4c] Result set meta data for statement Statement@1295fe8
[jcc][ResultSetMetaData@1c18a4c] Number of result set columns: 0
isDescribed=true[jcc][ResultSetMetaData@1c18a4c] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=null, sqldSchema=null }
[jcc][ResultSetMetaData@1c18a4c] END TRACE_RESULT_SET_META_DATA
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] java.sql.SQLException
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] DB2 SQLCA from server
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlCode        = -514
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrd        = { -304, 0, 0, -1, 0, 0 }
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrmc       = SQL_CURLH200C1
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrmcTokens = { SQL_CURLH200C1 }
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrp        = DSNXERT2
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlState       = 26501
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlWarn        =           
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] SQL state  = 26501
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Error code = -514
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Tokens     = SQL_CURLH200C1
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Stack trace follows
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.61.84
   at com.ibm.db2.jcc.am.ed.a(ed.java:679)
   at com.ibm.db2.jcc.am.ed.a(ed.java:60)
   at com.ibm.db2.jcc.am.ed.a(ed.java:127)
   at com.ibm.db2.jcc.am.hn.c(hn.java:2554)
   at com.ibm.db2.jcc.am.hn.a(hn.java:2061)
   at com.ibm.db2.jcc.t4.cb.n(cb.java:844)
   at com.ibm.db2.jcc.t4.cb.i(cb.java:265)
   at com.ibm.db2.jcc.t4.cb.c(cb.java:54)
   at com.ibm.db2.jcc.t4.q.c(q.java:44)
   at com.ibm.db2.jcc.t4.rb.j(rb.java:147)
   at com.ibm.db2.jcc.am.hn.ib(hn.java:2056)
   at com.ibm.db2.jcc.am.hn.a(hn.java:3032)
   at com.ibm.db2.jcc.am.hn.a(hn.java:667)
   at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:651)
   at com.ABCD.jjjjjapps.models.JDBCAdapter.executeQuery(JDBCAdapter.java:80)
   at com.ABCD.jjjjjapps.TableExample.fetch(TableExample.java:413)
   at com.ABCD.jjjjjapps.TableExample$2.actionPerformed(TableExample.java:110)
   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:246)
   at java.awt.Component.processMouseEvent(Component.java:5517)
   at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
   at java.awt.Component.processEvent(Component.java:5282)
   at java.awt.Container.processEvent(Container.java:1966)
   at java.awt.Component.dispatchEventImpl(Component.java:3984)
   at java.awt.Container.dispatchEventImpl(Container.java:2024)
   at java.awt.Component.dispatchEvent(Component.java:3819)
   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
   at java.awt.Container.dispatchEventImpl(Container.java:2010)
   at java.awt.Window.dispatchEventImpl(Window.java:1791)
   at java.awt.Component.dispatchEvent(Component.java:3819)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
   at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[jcc] END TRACE_DIAGNOSTICS
[jcc] [t4][time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:1][Request.flush]
[jcc][t4]        SEND BUFFER: RDBCMM                 (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   000AD00100010004  200E              ........ .        ..}.......     
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:2][Reply.fill]
[jcc][t4]        RECEIVE BUFFER: ENDUOWRM            (ASCII)           (EBCDIC)
[jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[jcc][t4] 0000   0030D0520001002A  220C000611490004  .0.R...*"....I..  ..}.............
[jcc][t4] 0010   00162110C3C1C9C3  C2C3C4C2F2F24040  ..!...........@@  ....DB2SYS 
[jcc][t4] 0020   4040404040400005  2115010005119FF2  @@@@@@..!.......        .........2
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: SQLCARD             (ASCII)           (EBCDIC)
[jcc][t4] 0000   000BD05300010005  2408FF            ...S....$..       ..}........     
[jcc][t4]
[jcc][t4]        RECEIVE BUFFER: SQLSTT              (ASCII)           (EBCDIC)
[jcc][t4] 0000   0034D0030001002E  2414000000002453  .4......$.....$S  ..}.............
[jcc][t4] 0010   4554204355525245  4E542046554E4354  ET CURRENT FUNCT  ........+....+..
[jcc][t4] 0020   494F4E2050415448  203D224442325453  ION PATH ="DB2TS  .|+.&...........
[jcc][t4] 0030   543622FF                            T6".              ....           
[jcc][t4]
[jcc][Connection@14eaec9] DB2 LUWID: GA228845.H074.C77CF70C8B5A.0001
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:204]parseSQLSTTList :
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:220]On Connection: : SET CURRENT FUNCTION PATH ="DB2TST6"
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:220]On Transport : : SET CURRENT FUNCTION PATH ="DB2TST6"
[jcc][SystemMonitor:stop] core: 69.488939ms | network: 42.952379ms | server: 31.972ms
stoked
 
Posts: 11
Joined: Thu Mar 17, 2011 4:15 am
Location: Vancouver, BC
Has thanked: 0 time
Been thanked: 0 time

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby GuyC » Mon Mar 21, 2011 8:17 pm

Is rpl_process a table function ?
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby stoked » Mon Mar 21, 2011 9:20 pm

GuyC wrote:Is rpl_process a table function ?

No, it's just a table, i.e. SELECT * FROM RPL_PROCESS.
stoked
 
Posts: 11
Joined: Thu Mar 17, 2011 4:15 am
Location: Vancouver, BC
Has thanked: 0 time
Been thanked: 0 time

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby GuyC » Tue Mar 22, 2011 2:29 pm

Why do you think it will use current function path as schema of a table ?
Isn't currentSchema more logical ?
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby stoked » Tue Mar 22, 2011 10:13 pm

GuyC wrote:Why do you think it will use current function path as schema of a table ?
Isn't currentSchema more logical ?

We're using DB2 UDB for z/OS.

The following url http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvdsprp.htm states

currentSchema
Specifies the default schema name that is used to qualify unqualified database objects in dynamically prepared SQL statements. This value of this property sets the value in the CURRENT SCHEMA special register on a server other than a DB2 UDB for z/OS server. Do not set this property for a DB2 UDB for z/OS server.

So currentFunctionPath should work.
stoked
 
Posts: 11
Joined: Thu Mar 17, 2011 4:15 am
Location: Vancouver, BC
Has thanked: 0 time
Been thanked: 0 time

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby GuyC » Wed Mar 23, 2011 3:18 pm

well, if your convinced take it up with IBM


Otherwise reread the info in the link you yourself gave :
currentFunctionPath
Specifies the SQL path that is used to resolve unqualified data type names and function names in SQL statements that are in JDBC programs.
...
currentSQLID
Specifies:
...
• The implicit qualifier of all table, view, alias, and index names specified in dynamic SQL statements.
currentSQLID sets the value in the CURRENT SQLID special register on a DB2 UDB for z/OS server. If the currentSQLID property is not set, the default schema name is the value in the CURRENT SQLID special register.

now : is RPL_PROCESS "a data type name or function" or is it "a table, view, alias, or index name" ?
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby stoked » Tue Mar 29, 2011 3:47 am

Thanks guyc for your comments.

I wrote a test program to check out how currentFunctionPath and currentSchema work with calling DB2 stored procedures residing on z/OS.

1) Specifying currentSchema does not seem to do anything. Not surprising, considering its use is proscribed in DB2 z/OS according to the documentation link I gave above.

2) Specifying currentFunctionPath does qualify stored procedures that are unqualified in the query.

So, if I've learned anything by the exercise vis-a-vis DB2 on z/OS, it's that currentFunctionPath will qualify stored procedure but not table names.
stoked
 
Posts: 11
Joined: Thu Mar 17, 2011 4:15 am
Location: Vancouver, BC
Has thanked: 0 time
Been thanked: 0 time

Re: currentFunctionPath in DB2 UDB driver ignored by DB2?

Postby GuyC » Tue Mar 29, 2011 1:37 pm

but the question is : Did currentsqlid solve your problem ?
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2