Ask a Question

How can we determine the database type(db2/SQLServer/Oracle) for current environment dynamically ?

0 votes
745 views
in Integrations by (16.3k points)

1 Answer

0 votes
by (16.3k points)
selected by
 
Best answer

In 8.6 version at least there is a system service called "SQL Get Database Type" which returns a variable of type "SQLDatabaseType" which has all the information regarding the underlying DB, this can be useful in developing generic applications which will adapt their queries to the connected Database Type.

Related questions

0 votes
1 answer 613 views
How to determine the current environment type Production/Development/Test/Staging?
asked Apr 30, 2018 by Anil Singh (16.3k points)
0 votes
0 answers 365 views
How can we automap database table columns from SELECT * to a BO List?
asked May 16, 2016 in Integrations by anonymous
0 votes
1 answer 700 views
How can we setup UCAs to fire at specific date(s) of the month?
asked Jul 3, 2019 in Integrations by Anil Singh (16.3k points)
0 votes
0 answers 258 views
How can we encode the username password in a Service Invocation URL?
asked May 15, 2016 in Integrations by anonymous
0 votes
1 answer 600 views
How can we make the hostname for our web service invocations dynamic?
asked May 25, 2017 in Integration Designer by Anil Singh (16.3k points)
0 votes
0 answers 238 views
How can we find out the bpd id/artifact id for a event gateway etc for migration purposes?
asked May 17, 2016 in BPD by anonymous
0 votes
0 answers 251 views
What is the new config type "event" for Coach Views and how is it used/configured?
asked Feb 7, 2019 in Coach Views by Anil Singh (16.3k points)

635 questions

495 answers

98 comments

3.0k users

Join BPM Community Discord Channel

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel

Categories

Most popular tags

#ibmbpm bpm baw ibm #coachviews workflow #integrations ecm bpm-ibm toolkits portal java #baw validationerror webdesigner processdesigner - coachview stored validation database procedure team rest migration #text-rich #client-side #texteditor #heritage #heritagehumanservice #hss bpd-integrations bpmservices ibmbpm notreachanble humanservices @username #ibmbaw#ibmbpm#baw#table #error migration- #bpm #eventhandler #bpmadmin #function #button debugger pet filenet cometd #production #processcenter #processserver log4j breadcrumbs careers jobs html- css- crumb- io pdf hierarchy inspector authentication cmis bread responsive section dependency db2 enterprise package tab dashboard artifact file page query email views start filter center ui playback standard rules bal decision js search service bpd variables integrations coaches services coach process 5
Powered by Dosvak LLC
...