esql | PHP Extended SQL is an alternative to the also-known DQL | SQL Database library

You can use the pg_get_constraintdef function. The argument is the object ID from pg_constraint.

The chapter ESQL field reference overview describes this use case:

Because the names of the fields appear in the ESQL program, they must be known when the program is written. This limitation can be avoided by using the alternative syntax that uses braces ( { ... } ).

So can change your code like this:

I found the problem.

I used the Windows Template Studio to create the project. I looked at my Package.appxmanifest and went to Capabilities and found "Private Networks (Client & Server)" was not enabled. After enabling it and rebuilding, the connection worked flawlessly.

Please read Accessing the MQRFH2 header and Populating Destination in the local environment tree.

Then you could write your ESQL like this: (assuming the RFH2 routing variable is named Ker)

Using cardinality function is not necessary to get the desired string value. Also, cardinality is an expensive(processor intensive) function in IIB esql.

When running ldd on iclis09b.so as root, instead of my login user, I got different results:

When asking for help please always include the make command you invoked and the error output you got, cut and pasted into your question (with proper formatting) rather than paraphrased. Even slight differences in the exact text of the error can make a big difference.

Also, your makefile is incomplete because you don't show us what the value of RWOBJ is, and you have a typo (you define COMMON_HFILES but you refer to $(COMMON_HFILE). Since make doesn't complain about this I assume the typo only exists here in your question not in your actual makefile (this another reason why cut and paste is better).

Also please include the operating system you're using and the version of make you're using.

In this case the error you're getting "Cannot open input file" is not coming from make, it's coming from your compiler. Make is able to find your header files just fine, but then it invokes the compiler and you haven't told the compiler where to find the header files.

You need to add the -I$(COMMONSRC) option to your compile line (assuming you're using a POSIX-ish compiler such as GCC or clang).

You haven't provided enough information about your complete makefile for us to advise you on where to put that option but see if there's a make variable containing other -I options etc.

To provide a proper answer for future readers ...

Following the comments, it would be more straight-forward and likely more efficient to use the following:

• pandas DataFrame.to_sql() function
• sqlalchemy engine object

The docs for both can be found here:

• pandas to_sql
• sqlalchemy engine connstr for MSSQL, using pyodbc

As use cases for this can vary greatly from case to case, please refer to the official docs for code examples.

I don't know Go, but in Java you could do something like this: