User Profile

Collapse

Profile Sidebar

Collapse
sara1231
sara1231
Last Activity: Jul 27 '07, 07:22 AM
Joined: Jun 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sara1231
    started a topic timestamp
    in DB2

    timestamp

    Hi,

    I'm new to DB2.

    I'm connecting to a remote database through command line processor, while trying to retrieve records based on timestamp , i'm getting an error.

    select * from user.file where log_time <= CURRENT_TIMESTA MP

    i have only read access to this remote db.

    What is the correct syntax to use current timestamp from CLP?

    thanks
    sara
    See more | Go to post
    • sara1231
      started a topic Unable to connect to DB2 v7.2 using JDBC Universal driver 4
      in DB2

      Unable to connect to DB2 v7.2 using JDBC Universal driver 4

      Hi,

      Unable to connect to DB2 UDB v7.2 using JDBC Universal driver 4.

      com.ibm.db2.jcc .b.SqlException : DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSSH200

      Please help as this is urgent.

      Thanks
      See more | Go to post
      No activity results to display
      Show More
      Working...