Hi Srini,
Perhaps you could expand upon what exactly you mean by a dataset in this context? IIB (and ACE, which is the more up to date name for the product) provides a variety of message flow nodes which could be helpful in this scenario. For example we have the DatabaseInput node which connects to a database using ODBC and retrieves database updates for propagation through a flow. Alternatively you could poll a database on a timed basis, or if you already have some other kind of trigger for the IIB activity you could then use a mid-flow Compute node for example to query multiple database tables and join the results. On the outbound side of the flow you have a FileOutput node which you could use to generate a variety of output file formats such as delimited/fixed/length/bespoke formats modelled using DFDL/XML/JSON etc. There are also a variety of tutorials available in the Toolkit Tutorial Gallery which provide working scenarios and step-by-step instructions. These tutorials are best navigated using the Toolkit as here the artifacts can be imported directly into the Toolkit and viewed alongside the instructions. The tutorials were massively extended in ACEv11 (IIBv10 had 36, ACEv11 has 76, and ACEv12 released at the weekend has over 100) so the following tutorials are available in ACEv11 or ACEv12 (the artifacts and capabilities could be used in IIBv10, but we really would like to encourage you to use the latest versions of the product):
Databases - Using a DatabaseRetrieve node to retrieve data from DB2 via JDBC
Databases - Using a DatabaseRoute node to route messages based on data from DB2 via JDBC
Databases - Using a Mapping node to insert data into a DB2 database via JDBC
Databases - Using a JavaCompute node to insert data into a DB2 database via JDBC
Databases - Using a Compute node to insert data into a DB2 database via ODBC
Databases - Using a Database node to insert data into a DB2 database via ODBC
Databases - Using a DatabaseInput node to trigger a flow on insert into DB2 via ODBC
File - Using the FileInput node with Whole File record detection
File - Using the FileInput node with Fixed Length record detection
File - Using the FileInput node with Delimited record detection
File - Using the FileInput node with Parsed Record Sequence record detection
Cheers,
Ben
------------------------------
Ben Thompson
IBM UK
------------------------------
Original Message:
Sent: Sat May 15, 2021 08:48 PM
From: sreenu rao
Subject: Dataset creation using IIB
Hi,
How to create a dataset in IIB. Basically I want to create a message as a dataset and write it to a file/path. Is this achievable in IIB? It would be greatIIB help if anyone can provide code/logic for this .
RegardsSrini
------------------------------
sreenu rao
------------------------------