User Profile

Collapse

Profile Sidebar

Collapse
spanky1968
spanky1968
Last Activity: Mar 11 '08, 04:08 PM
Joined: Sep 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • spanky1968
    started a topic Insert to table question
    in DB2

    Insert to table question

    Hello,

    I have a small dilemma I need some help with. I would like to insert into a DB2 table the system date (timestamp) along with data retrieved via a db2 select statement but I am unsure how to code it using one statement.

    I would like to use the following format to insert to the table but I am unsure how to add the "VALUES (CURRENT TIMESTAMP)"

    Format I would like to use.....
    Code:
    db2 "INSERT
    ...
    See more | Go to post
    • spanky1968
      replied to Table Create Question
      in DB2
      Thank you it worked great.
      See more | Go to post

        Leave a comment:

      • spanky1968
        started a topic Table Create Question
        in DB2

        Table Create Question

        OK, I have an easy one for somebody out there. I am creating a table and I would like to assign one of the fields as the primary key.

        Table create example:
        Code:
        db2 -v "create table temp_table(ID varchar(6), date timestamp(30), acct_total decimal(9), cust_total decimal(9), txn_total decimal(9))"
        I would like to assign the date field as the primary key but I am unsure how to do this, can you help?
        ...
        See more | Go to post
        • spanky1968
          started a topic I need a lot of help with a DB2 query
          in DB2

          I need a lot of help with a DB2 query

          Hello,

          I'm sure there is someone here way smarter than me. I need help with a big to me query.

          I would like to perform a query that gets the information I need and then join a count of some more information to the end of the output. (I know clear as mud)

          Here's what I have so far,
          Code:
          select a.rule, b.account, count(*) from Table1 a, Table2 b, Table3 c where c.rule = a.rule and a.month = DEC and a.rule
          ...
          See more | Go to post
          • spanky1968
            started a topic I need help.....Loading from XML to DB2 table
            in DB2

            I need help.....Loading from XML to DB2 table

            Hello,

            I am still a bit new to the DB2 World but I have a question that has me stumped.

            Is there a quick way to load the data from an XML file to a DB2 Table?

            I am using verion 8.1 of DB2 and if you could do me a favor and dumb it up a bit for me.

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