Clicky
Skip to Content
Custom Search

Reply to comment

RE:NOT WORKING......PLZ HELP

siteadmin - 06/29/2011 - 07:22

For your first query, I suppose you might be giving some incorrect information. I would suggest you to browse the table SYSIBM.SYSCOLUMNS and find for your table and this way you would know the creator 

 

SELECT * FROM tablename WHERE 1=2

would return 0 rows only, but you would see the column names displayed.

 

 

SELECT * FROM SYSIBM.SYSTABLES WHERE 1=2;                                      
---------+---------+---------+---------+---------+---------+---------+--------
NAME                                                                          
---------+---------+---------+---------+---------+---------+---------+--------

 

DSNE610I NUMBER OF ROWS DISPLAYED IS 0                                        
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100                   
 
Highlighted section will display the column names.

Reply

  • Allowed HTML tags:
      2. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 1232
Theme by Dr. Radut.