want to get all columns of a db2 table using easytriev

barobaybay · Posted: Fri Jul 21, 2006 4:16 pm

i need to get all columns in a table by using easytrieve I have part of the ezytriev code below, but sadly, it only writes back my id_number into the output file.

What am i missing? any samples?

Thanks in advance!

barobaybay · Posted: Fri Jul 21, 2006 4:19 pm

mods, sorry, can we move my topic to the CA Products forum? thanks

guptae · Posted: Fri Jul 21, 2006 4:29 pm

You have to write your sql in
EXEC sql

ENd EXEC'

barobaybay · Posted: Mon Jul 24, 2006 9:06 am

sorry, I can exec the SQL statement, but what i want to happen is to put the results of my query onto the output file...

barobaybay · Posted: Mon Jul 24, 2006 12:24 pm

good news guys! thanks for this post: ibmmainframes.com/viewtopic.php?t=12436&sid=bb869b04d72055436fcdd8cbd331d269

last post(or one of the last) ont the above topic basically reminds us to include each of the fields and put it into the host variable. just remember which data type of the field is the equivalent data type in the ezytriev program... great! problem solved! now it's possible to have several (100+) records as input and look them up directly from the table...
you guys rock! i love this forum!

chiranjeevi_mca · New User Joined: 19 Feb 2006 Posts: 27

i don't know the easytrive

but for that the query is

select name from sysibm.syscolumns where table='tablename'

chiranjeevi_mca · New User Joined: 19 Feb 2006 Posts: 27

Hi,

i understand what you written.

but i want to know you need the column names of the table
or
you need to retrieve all the data from that table.

if you need columns, the above posted topic is the write query
if you need the data, you are not getting even a single row from your table.

that's why it's displaying your id.