IIB DB Connection using DSN | Compute Node

Creator : Mithun Thadi
Connecting to DB from IIB using DSN from Compute Node, accessing InputRoot header and updating the details fetched from DB into OutputRoot header
Required : Pre-Installed
SQL server Express Edition
MQ v8.5
IIB v10
Overview :
DSN creation
Running mqsi commands
configure broker to connect to DB
check the configuration commands.
Flow :
MQ-Input Node :: Compute Node :: MQ-Output Node
MQ-Input Node :- Process messages from Input queue from MQ
Compute Node :- Connect's and Interact's with previously configured DB to perform select operation.
MQ-Output Node :- places message in output queue.

Description :
This video is reference purpose only.
It will showcase how to connect to DB from IIB and select previously inserted values.
----------------------------------------------------------------------------------------------------------
SQL queries :
create schema MT;
create table MT.service(IntId integer, IntType smallint, IntDesc char (50));
Insert into MT.service(IntId , IntType, IntDesc) values (1,1,'DBCONN');
select s.IntType as InType, s.IntDesc as InDesc from MT.service as s where s.IntId= 1;
----------------------------------------------------------------------------------------------------------
MQSI Commands :
Worked for SQL Server Express edition
------------
mqsisetdbparms INTNODE02 -n odbc::SQLMT -u "sa" -p "******"
BIP8071I: Successful command completion.

mqsicvp INTNODE02 -n SQLDB
----------------------------------------------------------------------------------------------------------

ESQL code :: Compute Node :: Query.
-------------------------
DECLARE ID INTEGER InputRoot.MQRFH2.usr.IntId;
SET OutputRoot.MQRFH2.usr.services[] = PASSTHRU ( 'select s.IntType as InType, s.IntDesc as InDesc from MT.service as s where s.IntId= ?' VALUES (ID));
----------------------------------------------------------------------------------------------------------