CODEWITHSUNDEEP
phpdb2ibm-midrange
KOUSIK MANDAL
KOUSIK MANDAL

Reputation: 2052

How to get column names from a query in IBM db2 via SQL

Is it possible to get the list column names from a query in IBM db2?

Consider a very simple example I want the column names fetched by following SQL;

select * from db.t1,db.t2 where t1.id = t2.id

Actually I know how to get column names from a a single table. But facing difficulties to get column names from such scenario.

I want the list of columns as an Array in PHP. It can be done if I just add "FETCH FIRST 1 ROW ONLY" as the end of the SQL, and run it. Then from result set I can get the columns.

But if there is no data then also I need the list of columns. How to achieve that?

Any help would be great for me.

Upvotes: 0

Views: 9340

Answers (2)

John Hennesy
John Hennesy

Reputation: 9

You could always just do something like

describe select * from tablea, tableb

Upvotes: 0

mustaccio
mustaccio

Reputation: 18945

You can use db2_num_fields() to determine the number of columns in the result set, then loop over them and call db2_field_name() to obtain the names.

Upvotes: 3

Related Questions