Versions Compared

Old Version 6

changes.mady.by.user user-ff8ce

Saved on

compared with

New Version Current

changes.mady.by.user user-ff8ce

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
iconfalse
titleNote

LANSA Composer does not guarantee that any form of SQL statement that is valid for your target database can successfully be executed through the SQL database activities, nor that every form of SQL stored procedure can successfully be executed.
Nor will it be possible to successfully address every possible data type in your database.  Since processing sequence variables that might be used to pass or receive data to the SQL database are untyped, not all conversions can be successful or yield useful results.  It is your responsibility to ensure that any data passed through the SQL database suite of activities is in a form that can be accepted and processed by both the JDBC driver and the target database.


Anchor
Example Processing Sequences using the SQL database activities
Example Processing Sequences using the SQL database activities
Example Processing Sequences using the SQL database activities

Refer to the following example processing sequences supplied with LANSA Composer for working (*) examples that use the SQL database activities.  (*)  Note that some setup will be required on your system to enable these examples to execute successfully.  Refer to the notes accompanying the example processing sequences for details:

  • EXAMPLE_SQL01: Example of using the SQL_QUERY activity
  • EXAMPLE_SQL02: Example of using the SQL_UPDATE activity
  • EXAMPLE_SQL03: Example of using the SQL_CALLQRYCSV activity

Related SQL database activities

The SQL_CONNECT activity returns a "handle" that can then be passed on to the other SQL database activities to accomplish a range of database tasks.  The full suite of SQL database activities are briefly described below:

...