Advertisement
mariusbutuc

sp-deploy-output

Apr 27th, 2012
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. Deploy DB2INST1.TABLECOUNT(VARCHAR(128), INTEGER)
  2.  
  3. Running
  4. DB2INST1.TABLECOUNT - Deploy started.
  5. DB2INST1.TABLECOUNT - Created temporary working directory C:\Users\Marius Butuc\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.datatools.db2.routines.deploy.ui\bld1335557969832.
  6. C:\Program Files (x86)\ibm\DS3.1\jdk\bin\javac -classpath ".;C:\Program Files\IBM\SQLLIB\java\sqlj.zip;C:\Program Files (x86)\ibm\SDPShared\plugins\com.ibm.datatools.db2_2.1.303.v20110924_0203\driver\db2jcc4.jar;C:\Program Files (x86)\ibm\SDPShared\plugins\com.ibm.datatools.db2_2.1.303.v20110924_0203\driver\db2jcc_license_cisuz.jar" com\bigdatauniversity\TableCount.java
  7. DB2INST1.TABLECOUNT - Javac completed.
  8. C:\Program Files (x86)\ibm\DS3.1\jdk\bin\jar cf spjar.jar com\bigdatauniversity\TableCount.class
  9. DB2INST1.TABLECOUNT - JAR file created.
  10. Call SQLJ.DB2_INSTALL_JAR (<<C:\Users\Marius Butuc\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.datatools.db2.routines.deploy.ui\bld1335557969832\spjar.jar>>, 'DB2INST1.SAMPLE', 0)
  11. DB2INST1.TABLECOUNT - SQLJ.DB2_INSTALL_JAR using Jar name DB2INST1.SAMPLE completed.
  12. Call sqlj.refresh_classes( )
  13. DB2INST1.TABLECOUNT - sqlj.refresh_classes completed.
  14. Call SQLJ.DB2_UPDATEJARINFO ('DB2INST1.SAMPLE', 'com.bigdatauniversity.TableCount', <<C:\Users\Marius Butuc\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.datatools.db2.routines.deploy.ui\bld1335557969832\com\bigdatauniversity\TableCount.java>>)
  15. DB2INST1.TABLECOUNT - Source saved to the server.
  16. CREATE PROCEDURE TABLECOUNT ( IN VARNAME VARCHAR(128),
  17. OUT VARCOUNT INTEGER )
  18. NOT DETERMINISTIC
  19. LANGUAGE Java
  20. EXTERNAL NAME 'DB2INST1.SAMPLE:com.bigdatauniversity.TableCount.x_TableCount'
  21. FENCED
  22. THREADSAFE
  23. PARAMETER STYLE JAVA
  24. DB2INST1.TABLECOUNT - Create stored procedure completed.
  25. DB2INST1.TABLECOUNT - Removed temporary working directory C:\Users\Marius Butuc\IBM\rationalsdp\workspace\.metadata\.plugins\com.ibm.datatools.db2.routines.deploy.ui\bld1335557969832.
  26. DB2INST1.TABLECOUNT - Deploy successful.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement