|
View previous topic :: View next topic
|
| Author |
Message |
vvvvv
New User
Joined: 10 Jul 2006
Posts: 1
|
|
|
|
I need a Rexx code to list the column names of a given table.
eg: If i give CUST as table name, the output should be
Select CUST_ID,FNAME,LNAME...... FROM CUST WHERE <Primary Key>;
If this output query can be placed in a PS it will be more helpful. Or just listing the column names and keys will also work good.
Can someone helpme on this? |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| I moved this topic to the DB2 forum, although you haven't specified exactly what database you're referring to. If it's not DB2, let me know and I'll move it elsewhere. |
|
| Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2358
Location: Israel
|
|
|
|
You can read SYSCOLUMNS through the DSNREXX interface.
O. |
|
| Back to top |
|
|
|
|
