oracle queries

-
Covert Date to Timestamp
  1. TO_TIMESTAMP(SYSDATE,'DD-MM-RRRR HH24:MI:SS') FROM DUAL;

Comments

Post a Comment

Popular posts from this blog

Java Task Service - Sterling Integrator

-
import com.sterlingcommerce.woodstock.workflow.Document; import java.io.InputStream; import java.io.InputStreamReader; import java.io.BufferedReader; Document doc = wfc.getPrimaryDocument(); Document outPutDoc = wfc.newDocument(); ; InputStream inS = doc .getInputStream(); BufferedReader br = new BufferedReader( new InputStreamReader( inS )); String strData = “<SampleData>” ; String strLine; while ((strLine = br .readLine()) != null ) {     strData = strData.concat(strLine); } br.close(); strData = strData + “</SampleData>”; outPutDoc. setBody( strData .toString().getBytes()); wfc.putPrimaryDocument( outPutDoc );
Read more

Sterling Integrator Purge All Tables

-
1.  EDI_COMPLIANCE_RPT 2.  EDI_DOCUMENT_STATE 3.  WF_INST_S 4.  WORKFLOW_CONTEXT 5.  WORKFLOW_LIFESPAN 6.  WORKFLOW_DATA 7.  EDIINTDOC 8.  MSGMDNDUP 9.  MSGMDNCORRELATION 10. WEBX_MINED_DATA 11. WF_INACTIVE 12. GENERIC_ACK 13. CORRELATION_SET 14. ACT_SESSION 15. ACT_AUTHENTICATE 16. ACT_AUTHORIZE 17. ACT_XFER 18. ACT_NON_XFER 19. DATA_FLOW 20. DMI_ROUTE 21. DMI_ROUTE_FACT 22. MBX_MESSAGE 23. TRANS_DATA
Read more

​ Configure External Databases to IBM Sterling B2B Integrator

-
We can add multiple ​​ external databases to IBM Sterling B2B Integrator. To add custom database need to do the following things, 1. Stop IBM Sterling B2B Integrator 2. Navigate to SI_INSTALL_DIR\properties and edit jdbc_customer.properties.in and add the below properties. 3. Run setupfiles.bat/sh (SI_INSTALL_DIR\bin\setupfiles.bat/sh) 4. Start IBM Sterling B2B Integrator Note: SI_EXTENSION is my pool name. We can name whatever we want. ​ ​ MS SQL Server Database Need to change the test query depending on server, For MS SQL Server Database SI_EXTENSION.testOnReserveQuery=SELECT GETDATE() Oracle Database Need to change the test query depending on server, For Oracle Database SI_EXTENSION.testOnReserveQuery=SELECT * FROM DUAL jdbc_customer.properties.in SI_EXTENSION.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver SI_EXTENSION.url=jdbc:sqlserver://localhost:1433;databaseName=SI_EXTENSION;SelectMethod=cursor SI_EXTENSION.user=sa SI_EXTENSION.password= #SI_EX...
Read more